| JSP实现树型组织架构(2)--显示orgView__教程 |
|
| 日期：2007-5-20 1:14:52 人气：105 [大 中 小] |
|
|
|
|
|
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"> </td>
<td width="19%" height="18"><%=rs3.getString("name")%></td>
<td width="19%" height="18"> </td>
<td width="19%" height="18"> </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"> </td>
<td width="19%" height="18"> </td>
<td width="19%" height="18"><%=rs5.getString("name")%></td>
<td width="19%" height="18"> </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"> </td>
<td width="19%" height="18"> </td>
<td width="19%" height="18"> </td>
<td width="19%" height="18"><%=rs7.getString("name")%></td>
</tr>
<%
ps=conn.prepareStatement(queryCount);
queryNameCondition="E"+(i+9)+"%";
//out.println(queryNameCondition);
ps.setString(1, queryNameCondition);
ResultSet rs8=ps.executeQuery();
int result4=1;
while(rs8.next())
{ result4++;}
//out.println(result3);
for( i=1; i<=result4; i++){
ps=conn.prepareStatement(queryName) ;
ps.setString(1, queryNameCondition); |
|
|
| 出处：本站原创 作者：佚名 |
|
|
