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

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