这是后面的部分,现在就是页面一呈现,树就自动打开。并没有伸缩功能 想能想是表单的缘故可是我必须要呈现表单形式啊 求求那为高手能指点 谢谢!!!!
function expandIt(el){
if(!ver4) return;
if(IE4){
whichEl=eval(el+"Child");
if(whichEl.style.display=="none"){
whichEl.style.display="block";
}
else{
whichEl.style.display="none";
}
}
else{
whichEl=eval("document."+el+"Child");
if(whichEl.visibility=="hide"){
whichEl.visibility="show";
}
else{
whichEl.visibility="hide";
}
arrange();
}
}
onload=initIt;
</script>
<table name="groupinfo" align="center" border="0">
<td> </td><td>科室名称</td><td>科室ID</td><td>其他说明</td><td> </td>
<%
Connection conn=null;
conn=link.getconnection("jdbc/ADIMSDB");
PreparedStatement pstmt=null;
pstmt=conn.prepareStatement("select * from ADIMS_YPFX_Group where PreGroId='null' or PreGroId='' order by AnalGro_ID,SerialNo",ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=pstmt.executeQuery();
int i=1;
while(rs.next())
{
%>
<tr>
<td>更改</td>
<td><DIV id="KB<%=i%>Parent" class="parent"><a href="#" onClick="expandIt('KB<%=i%>');return false"><img src="plus.gif" border=0><%=rs.getString("AnalGroName")%></a></DIV></td>
<td><%=rs.getString("AnalGro_ID")%></td>
<td><%=rs.getString("AOtherExpress")%></td>
<td>删除</td>
</tr>
<%
pstmt=conn.prepareStatement("select * from ADIMS_YPFX_Group where PreGroId=? order by AnalGro_ID,SerialNo",ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
pstmt.setString(1,rs.getString("AnalGro_ID"));
ResultSet rs2=pstmt.executeQuery();
if(rs2.next()){
rs2.previous();
%>
<DIV id="KB<%=i%>Child" class="child">
<% while(rs2.next()){ %>
<tr class="child">
<td>更改</td>
<td><img src="spacer.gif" border=0><img src="open.gif" border=0><%=rs2.getString("AnalGroName")%></td>
<td><%=rs2.getString("AnalGro_ID")%></td>
<td><%=rs2.getString("AOtherExpress")%></td>
<td>删除</td>
</tr>
<%
}
%>
</DIV>
<%
}
%>
<%
i=i+1;
}
%>
</table>
<script language="JavaScript">
if(NS4){
firstEl="KB1Parent";
firstInd=getIndex(firstEl);
arrange();
}
</script>
</body>
</html>
<%
try{
link.closeResultSet(rs);
link.closePreStmt(pstmt);
link.closeConn(conn);
}catch(Exception e){throw new Exception("数据库清理错误:"+e.getMessage());}
%>
function expandIt(el){
if(!ver4) return;
if(IE4){
whichEl=eval(el+"Child");
if(whichEl.style.display=="none"){
whichEl.style.display="block";
}
else{
whichEl.style.display="none";
}
}
else{
whichEl=eval("document."+el+"Child");
if(whichEl.visibility=="hide"){
whichEl.visibility="show";
}
else{
whichEl.visibility="hide";
}
arrange();
}
}
onload=initIt;
</script>
<table name="groupinfo" align="center" border="0">
<td> </td><td>科室名称</td><td>科室ID</td><td>其他说明</td><td> </td>
<%
Connection conn=null;
conn=link.getconnection("jdbc/ADIMSDB");
PreparedStatement pstmt=null;
pstmt=conn.prepareStatement("select * from ADIMS_YPFX_Group where PreGroId='null' or PreGroId='' order by AnalGro_ID,SerialNo",ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=pstmt.executeQuery();
int i=1;
while(rs.next())
{
%>
<tr>
<td>更改</td>
<td><DIV id="KB<%=i%>Parent" class="parent"><a href="#" onClick="expandIt('KB<%=i%>');return false"><img src="plus.gif" border=0><%=rs.getString("AnalGroName")%></a></DIV></td>
<td><%=rs.getString("AnalGro_ID")%></td>
<td><%=rs.getString("AOtherExpress")%></td>
<td>删除</td>
</tr>
<%
pstmt=conn.prepareStatement("select * from ADIMS_YPFX_Group where PreGroId=? order by AnalGro_ID,SerialNo",ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
pstmt.setString(1,rs.getString("AnalGro_ID"));
ResultSet rs2=pstmt.executeQuery();
if(rs2.next()){
rs2.previous();
%>
<DIV id="KB<%=i%>Child" class="child">
<% while(rs2.next()){ %>
<tr class="child">
<td>更改</td>
<td><img src="spacer.gif" border=0><img src="open.gif" border=0><%=rs2.getString("AnalGroName")%></td>
<td><%=rs2.getString("AnalGro_ID")%></td>
<td><%=rs2.getString("AOtherExpress")%></td>
<td>删除</td>
</tr>
<%
}
%>
</DIV>
<%
}
%>
<%
i=i+1;
}
%>
</table>
<script language="JavaScript">
if(NS4){
firstEl="KB1Parent";
firstInd=getIndex(firstEl);
arrange();
}
</script>
</body>
</html>
<%
try{
link.closeResultSet(rs);
link.closePreStmt(pstmt);
link.closeConn(conn);
}catch(Exception e){throw new Exception("数据库清理错误:"+e.getMessage());}
%>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货