(表格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)