Java

本类阅读TOP10
·使用MyEclipse开发Struts框架的Hello World!(录像1)
·hibernate配置笔记
·AOP编程入门--Java篇
·linux下Tomcat 5.0.20 与 Apache 2 安装/集成/配置
·在win2003下整合了整合Tomcat5.5+ apache_2.0.53+ mod_jk_2.0.47.dll
·构建Linux下IDE环境--Eclipse篇
·Jsp 连接 mySQL、Oracle 数据库备忘(Windows平台)
·ASP、JSP、PHP 三种技术比较
·Tomcat5.5.9的安装配置
·AWT GUI 设计笔记(二)

→ 分类导航
VC语言Delphi
VB语言ASP
PerlJava
Script数据库
其他语言游戏开发
文件格式网站制作
软件工程.NET开发
使用Java在Web上实现简易干特图之五

作者：未知 来源：月光软件站 加入时间：2005-2-28　月光软件站

（表格4）是从数据库获得数据。

PlanManager.java中的部分代码

public Vector getAllPlan() {

        String sql =    "select id,proname, stAllM, endAllM, iAll, startdate, endDate from PlanSc order by id";//获得数据的SQL语句

        Vector vec = new Vector();

        try {

            this.getConnection();

            Statement st = conn.createStatement();

            ResultSet rs = st.executeQuery(sql);

            while (rs.next()) {

                Hashtable hashCar = new Hashtable();

                //获取一条记录

                String id = rs.getString("id");

                String proname =

                    new String(

                        rs.getString("proname").getBytes("ISO-8859-1"),

                        "GBK");

                String stAllM = rs.getString("stAllM");

                String endAllM = rs.getString("endAllM");

                String iAll = rs.getString("iAll");

                String startdate = rs.getString("startdate");

                String endDate = rs.getString("endDate");

                //把一条记录装载到哈希表

                hashCar.put("id", id);

                hashCar.put("proname", proname);

                hashCar.put("stAllM", stAllM);

                hashCar.put("endAllM", endAllM);

                hashCar.put("iAll", iAll);

                hashCar.put("startdate", startdate);

                hashCar.put("endDate", endDate);

                //把哈希表装到Vector变量

                vec.addElement(hashCar);

            }

        } catch (Exception ex) {

        }  finally {

            try {

                if (st != null) {

                    st.close();

                }

                if (conn != null) {

                    conn.close();

                }

                dbconn.CloseConn();

            } catch (SQLException ex) {

                System.out.print("关闭连接错误");

            }

        }

        return vec; // Vector变量返回到调用的JSP

    }

（表格4）

 

（表格5）jindubiao.jsp中的部分代码，把获得数据解开到数组和获得第二类型（调整进度计划）的的数据（与第一类型－规划建设进度同理）

jindubiao.jsp中的部分代码

java.lang.String[][] myall=new java.lang.String [12][7];//声明数组

              java.util.Enumeration enuDrivers = vec.elements();

              int j=0;

              while(enuDrivers.hasMoreElements()){ 

                     java.util.Hashtable hashDriver= (java.util.Hashtable)enuDrivers.nextElement();

                     String id=(java.lang.String)hashDriver.get("id");  

                     String proname=(java.lang.String)hashDriver.get("proname");   

                     String stAllM=(java.lang.String)hashDriver.get("stAllM");

                     String endAllM=(java.lang.String)hashDriver.get("endAllM");    

                     String iAll=(java.lang.String)hashDriver.get("iAll");     

                     String startdate=(java.lang.String)hashDriver.get("startdate");    

                     String endDate=(java.lang.String)hashDriver.get("endDate");

                     myall[j][0]      = id;

                     myall[j][1]      = proname;

                     myall[j][2]      = stAllM;

                     myall[j][3]      = endAllM;

                     myall[j][4]      = iAll;

                     myall[j][5]      = startdate;

                     myall[j][6]      = endDate;     

                     j++;

              }

       

       

//获得第二类型（调整进度计划）,注意是getAllPlan2

              Vector vec2 = new Vector();

              vec2 = planC.getAllPlan2();

              java.lang.String[][] myall2=new java.lang.String [12][7];

           java.util.Enumeration enuDrivers2 = vec2.elements();

              int j2=0;

              while(enuDrivers2.hasMoreElements()){

                     java.util.Hashtable hashDriver2= (java.util.Hashtable)enuDrivers2.nextElement();

                     String id=(java.lang.String)hashDriver2.get("id");

                     String proname=(java.lang.String)hashDriver2.get("proname"); 

                     String stAllM=(java.lang.String)hashDriver2.get("stAllM");

                     String endAllM=(java.lang.String)hashDriver2.get("endAllM");  

                     String iAll=(java.lang.String)hashDriver2.get("iAll");   

                     String startdate=(java.lang.String)hashDriver2.get("startdate");  

                     String endDate=(java.lang.String)hashDriver2.get("endDate");

                     myall2[j2][0]   = id;

                     myall2[j2][1]   = proname;

                     myall2[j2][2]   = stAllM;

                     myall2[j2][3]   = endAllM;

                     myall2[j2][4]   = iAll;

                     myall2[j2][5]   = startdate;

                     myall2[j2][6]   = endDate;     

                     j2++;

              }           

（表格5）

相关文章：

相关软件：