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