JSP实现树型组织架构(7)--修改orgManage.jsp


答案：<%@ page contentType="text/html;charset=Big5"%>
<%@ include file="orgConnInclude.jsp"%>
<%
request.setCharacterEncoding("big5");
PreparedStatement ps=null;
ResultSet rs=null;
String  queryCount=" select count(*) "+
                   " from ngb_org "+
                   " where total like ? ORDER BY TOTAL  ";
              
String queryName=" select * "+
                 " from ngb_org "+
                 " where total like ? ORDER BY TOTAL ";
%>
<html>
  <head>
  <meta http-equiv="Content-Type" content="text/html; charset=Big5">
    <title>管理組織架構</title>
    <style type="text/css">
<!--
.style1 {color: #FFFFFF}
.style2 {color: #0066FF}
-->
    </style>
  </head>
  <body>
    <form action="orgInsert.jsp">
      <fieldset>
        <legend align="Right">
          <span class="style2">新增組織架構</span>
        </legend>
        <p align="left" class="style2">所 &nbsp;屬 &nbsp;&nbsp;部 &nbsp;門
  
    
    
    <select name="fDep">
  <optgroup label="總經理室">
  <option value="總經理室">總經理室
    <%
     try{
     int i=1;
     ps=conn.prepareStatement(queryCount); 
     ps.setString(1, "A10%");
     rs=ps.executeQuery();
     int result=1;
     while(rs.next())
     { result++;}
     //out.println(result);
     
     for( i=1; i<=result; i++){
     ps=conn.prepareStatement(queryName) ;
     String queryNameCondition="A"+(9+i)+"%";
     //out.println(queryNameCondition);
     ps.setString(1, queryNameCondition);
     ResultSet ors1=ps.executeQuery();
     String qa=null;
     String qaTemp=null;
     String qaTemp1=null;
     String obdep=null;
     String ocdep=null;
     
     while( ors1.next()){
      qa=ors1.getString("total");
     qaTemp=qa.substring(3,5);
     qaTemp1=qa.substring(3,6);
    
     %>
   
     
     <%
        queryNameCondition=qaTemp1+"%";
     //out.println(queryNameCondition);
     ps.setString(1, queryNameCondition);
     ResultSet ors2=ps.executeQuery();
     int oresult1=1;
     while(ors2.next())
     { oresult1++;}
     //out.println(result1);
     for(  i=1; i<=oresult1; i++){
     ps=conn.prepareStatement(queryName) ;
     ps.setString(1, queryNameCondition);
     ResultSet ors3=ps.executeQuery();
     String qb=null;
     String qbTemp=null;
     String qbTemp1=null;
     while( ors3.next()){
     
     qb=ors3.getString("total");
     qbTemp=qb.substring(3,5);
     qbTemp1=qb.substring(3,6);
     obdep=ors3.getString("name");
     %>
      <br>
      <optgroup label="<%=obdep%>">
     <option value="<%=obdep%>"><%=obdep%>
     <%
     ps=conn.prepareStatement(queryCount); 
     
      queryNameCondition=qbTemp1+"%";
    
      
     
     //out.println(queryNameCondition);
     ps.setString(1, queryNameCondition);
     ResultSet ors4=ps.executeQuery();
     int oresult2=1;
     while(ors4.next())
     { oresult2++;}
     //out.println(result);
     for(  i=1; i<=oresult2; i++){
     ps=conn.prepareStatement(queryName) ;
     ps.setString(1, queryNameCondition);
     ResultSet ors5=ps.executeQuery();
     String qc=null;
     String qcTemp=null;
     String qcTemp1=null;
     while( ors5.next()){
     qc=ors5.getString("total");
     qcTemp=qc.substring(3,5);
     qcTemp1=qc.substring(3,6);
     ocdep=ors5.getString("name");
     %>
     <option value=<%=ocdep%>><%=ocdep%>
     
     <br>
     <%
        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()){}}
     }
       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(queryNam
上一个：JSP技巧：发送动态图像
下一个：如何用ServletJSP动态生成图像验证码
更多图片编程知识: