| JSP实现树型组织架构(5)--删除部门页面orgDelete.jsp__教程 |
|
| 日期：2007-5-20 1:14:57 人气：64 [大 中 小] |
|
|
|
|
|
String namec1=rs2.getString("name");
String temp1c=temp1.substring(0,1);
String temp1ca=temp1.substring(0,3);
String temp1cb=temp1.substring(3,6);
ps=conn.prepareStatement(delete);
ps.setString(1, temp1aa+"%");
//out.println(namec1);
ps=conn.prepareStatement(delete1);
ps.setString(1, namec1);
int resultC2=ps.executeUpdate();
if(resultC2>0)
{message=depName;}
}}}
//只刪除第4層
if(temp1a.equals("D"))
{
ps=conn.prepareStatement(delete);
ps.setString(1, temp1);
int result3=ps.executeUpdate();
if(result3>0)
{message=depName;}
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Big5">
<title>刪除部門</title>
</head>
<body>
<p> </p>
<p> </p>
<p> </p>
<table width="38%" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="17" bgcolor="#0099FF" scope="col"><div align="center" class="style1">信息刪除成功</div></td>
</tr>
<tr>
<td height="160" colspan="2" bgcolor="#E6F0FF" scope="row"><div align="center" class="style2">部門: <%=depName%> 刪除成功!</div> <br> <div align="center" class="style2"><a href="orgManage.jsp">繼續刪除</a> <a href="orgView.jsp">返回組織架構</a></div></td>
</tr>
</table>
</body>
<%
conn.commit();
}
catch(SQLException se1)
{se1.printStackTrace();
conn.rollback();
}
finally{
conn.setAutoCommit(autoCommit);
conn.close();
}
%>
</html>
|
|
|
| 出处：本站原创 作者：佚名 |
|
|
