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

//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>

<title>管理組織架構</title>

<!--

.style1 {color: #FFFFFF}

.style2 {color: #0066FF}

-->

</style>

</head>

<body>

<span class="style2">新增組織架構</span>

</legend>

<p align="left" class="style2">所  屬   部  門

<option value="總經理室">總經理室

<option value="製造處">製造處

<option value="製造一部">製造一部

<option value="製造二部">製造二部

<option value="製造三部">製造三部

</optgroup>

<option value="管理處">管理處

<option value="管理部">管理部

</optgroup>

<option value="行銷處">行銷處

<option value="財務部">財務部

<option value="研究發">研發處

<option value="品保部">品保部

<option value="稽核室">稽核室

</optgroup>

</select>

</p>

<p align="left" class="style2">新增部門名稱

</p>

</fieldset>

</form>

<font color="#0099FF" size=4><center>*****有限公司組織架構圖</center></font>

<tr>

<th width="19%" bgcolor="#0099FF" scope="col"><span class="style1">總經理直屬</span></th>

</tr>

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 rs1=ps.executeQuery();

String qa=null;

String qaTemp=null;

String qaTemp1=null;

while( rs1.next()){

qa=rs1.getString("total");

qaTemp=qa.substring(3,5);

qaTemp1=qa.substring(3,6);

</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>

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>

/* 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>

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);

ResultSet rs9=ps.executeQuery();

while(rs9.next()){

rs9.getString("name"); %>

<%}}%>

<% }}%>

<%}}%>

</table>

</body>

<%}

catch(SQLException se1)

{se1.printStackTrace();}

finally{conn.close();}%>

</html>