}
</script>
<%
int dwxh;
int dwfxh;
int yhxh;
String dwbh = null;
String dwmc = null;
String yhmc = null;
String yhbh = null;
int preLevel =1;
int level = 1;
DbAccess dbaccess = new DbAccess();
String sql = "select dwxh,dwbh,dwmc,dwfxh from xt_dw order by dwbh";
ResultSet rs = dbaccess.executeQuery(sql);
try
{
while(rs.next())
{
dwxh = rs.getInt(1);
dwbh = rs.getString(2);
dwmc = rs.getString(3);
dwfxh = rs.getInt(4);
//通过单位编号计算level
String last = dwbh.substring(9,10);
int i = 9;
while(last.equals("0") && i>0){
i--;
last = dwbh.substring(i,i+1);
}
if(i==0 i==1) level =1;
if(i==2 i==3) level =2;
if(i==4 i==5) level =3;
if(i==6 i==7) level =4;
if(i==8 i==9) level =5;
//
%>
<script type="text/javascript">
nodeToAddPerson = addDeptTreeNode(<%=preLevel%>,<%=level%>,"<%=dwmc%>","RB<%=dwxh%>","<%=dwbh%>");
</script>
<%
preLevel = level;
String subsql = "select yhxh,yhmc,yhbh from xt_yh where dwxh = "+Integer.toString(dwxh);
ResultSet subRs = dbaccess.executeQuery(subsql);
while(subRs.next()) {
yhxh = subRs.getInt(1);
yhmc = subRs.getString(2);
yhbh = subRs.getString(3);
%>
<script type="text/javascript">
nodeToAddPerson.add(new WebFXTreeItem("<%=yhmc%>","RZ<%=yhxh%>","<%=yhbh%>","","","../resources/images/people1.png"));
</script>
上一篇:缓冲技术提高JSP程序性能和稳定性
下一篇:JSP显示图片问题的解决
|
精品推荐