JSP实现树型组织架构(3)--管理页面orgManage.jsp…

<tr bgcolor="#F0F8FF">
<td width="29%" height="18"><%=rs1.getString("name")%></td>
<td width="19%" height="18">&nbsp;</td>
<td width="19%" height="18">&nbsp;</td>
<td width="19%" height="18">&nbsp;</td>
<td width="19%" height="18"><a href="orgDelete.jsp?name=<%=rs1.getString("name")%>">刪除部門</a></td>

</tr>
<%

queryNameCondition=qaTemp1 "%";
//out.println(queryNameCondition);
ps.setString(1, queryNameCondition);
ResultSet rs2=ps.executeQuery();
int result1=1;
while(rs2.next())
{ result1 ;}
//out.println(result1);
for( i=1; i<=result1; i ){
ps=conn.prepareStatement(queryName) ;
ps.setString(1, queryNameCondition);
ResultSet rs3=ps.executeQuery();
String qb=null;
String qbTemp=null;
String qbTemp1=null;
while( rs3.next()){

qb=rs3.getString("total");
qbTemp=qb.substring(3,5);
qbTemp1=qb.substring(3,6);
%>
<tr bgcolor="#F0F8FF">
<td width="29%" height="18">&nbsp;</td>
<td width="19%" height="18"><%=rs3.getString("name")%></td>
<td width="19%" height="18">&nbsp;</td>
<td width="19%" height="18">&nbsp;</td>
<td width="19%" height="18"><a href="orgDelete.jsp?name=<%=rs3.getString("name")%>">刪除部門</a></td>
</tr>
<%
ps=conn.prepareStatement(queryCount);

queryNameCondition=qbTemp1 "%";



//out.println(queryNameCondition);
ps.setString(1, queryNameCondition);
ResultSet rs4=ps.executeQuery();
int result2=1;
while(rs4.next())
{ result2 ;}
//out.println(result);
for( i=1; i<=result2; i ){
ps=conn.prepareStatement(queryName) ;
ps.setString(1, queryNameCondition);
ResultSet rs5=ps.executeQuery();
String qc=null;
String qcTemp=null;
String qcTemp1=null;
while( rs5.next()){
qc=rs5.getString("total");
qcTemp=qc.substring(3,5);
qcTemp1=qc.substring(3,6);
%>

<tr bgcolor="#F0F8FF">
<td width="29%" height="18">&nbsp;</td>
<td width="19%" height="18">&nbsp;</td>
<td width="19%" height="18"><%=rs5.getString("name")%></td>
<td width="19%" height="18">&nbsp;</td>
<td width="19%" height="18"><a href="orgDelete.jsp?name=<%=rs5.getString("name")%>">刪除部門</a></td>
</tr>
<%

/* ps=conn.prepareStatement(queryC2);
ResultSet qd2=ps.executeQuery();
int cd2=0;
while(qd2.next())
{cd2 ;}
out.println(cd2);
ps=conn.prepareStatement(queryCount);
if(cd2>0)
{ queryNameCondition="D" (i 19) "%";}
else
{ queryNameCondition="D" (i 9) "%";}*/
ps=conn.prepareStatement(queryCount);

queryNameCondition=qcTemp1 "%";

//out.println(queryNameCondition);
ps.setString(1, queryNameCondition);
ResultSet rs6=ps.executeQuery();
int result3=1;
while(rs6.next())
{ result3 ;}
//out.println(result3);
for( i=1; i<=result3; i ){
ps=conn.prepareStatement(queryName) ;
ps.setString(1, queryNameCondition);
ResultSet rs7=ps.executeQuery();
while( rs7.next()){
%>
<tr bgcolor="#F0F8FF">
<td width="29%" height="18">&nbsp;</td>
<td width="19%" height="18">&nbsp;</td>
<td width="19%" height="18">&nbsp;</td>
<td width="19%" height="18"><%=rs7.getString("name")%></td>
<td width="19%" height="18"><a href="orgDelete.jsp?name=<%=rs7.getString("name")%>">刪除部門</a></td>
</tr>
<%
ps=conn.prepareStatement(queryCount);

标签：

版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com
特别注意：本站所有转载文章言论不代表本站观点，本站所提供的摄影照片，插画，设计作品，如需使用，请与原作者联系，版权归原作者所有