2. 技术人生
    3. 使用Java在Web上实现简易干特图之五

    使用Java在Web上实现简易干特图之五

    技术2022-05-11  36

    （表格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）

    专利

    最新回复(0)