JSP实现树型组织架构(5)--删除部门页面orgDelete.jsp

最新推荐文章于 2021-02-21 13:59:42 发布

sylmoon

最新推荐文章于 2021-02-21 13:59:42 发布

阅读量1.2k

点赞数

分类专栏： programming.diary 文章标签： jsp string delete query null class

本文链接：https://blog.csdn.net/sylmoon/article/details/336772

版权

programming.diary 专栏收录该内容

38 篇文章 0 订阅

订阅专栏

//orgDelete.jsp 删除部门页面,由orgManage.jsp 而来

<%@ page contentType="text/html;charset=Big5"%>
<%@ include file="orgConnInclude.jsp"%>
<%@ page import="javax.sql.*"%>
<%
request.setCharacterEncoding("big5");
String depName=request.getParameter("name");
//out.println(depName+"<br>");
String message=null;
boolean autoCommit=conn.getAutoCommit();

String query1=" select total "+
" from ngb_org "+
" where name='"+depName+"' ";

String query2=" select * "+
" from ngb_org "+
" where total like ? ";

String delete=" delete from ngb_org "+
" where total like ? ";

String delete1=" delete from ngb_org "+
" where name=? ";

String temp1=null;
String temp1a=null;
String temp1aa=null;
String temp1b=null;
try{
conn.setAutoCommit(false);
PreparedStatement ps=conn.prepareStatement(query1);
ResultSet rs1=ps.executeQuery();

while(rs1.next())
{temp1=rs1.getString("total");}
//out.println(temp1);
temp1a=temp1.substring(0,1);
temp1aa=temp1.substring(0,3);
temp1b=temp1.substring(3,6);
//out.println(temp1b);

/* 刪除部門級:第二層,所屬第三層,每個第三層所屬第四層一起刪除*/
if(temp1a.equals("B"))
{
ps=conn.prepareStatement(delete);
ps.setString(1, temp1);
int resultB1=ps.executeUpdate();
if(resultB1>0){
//out.println("delete B success!!!!");
ps=conn.prepareStatement(query2);
ps.setString(1, temp1b+"%");
ResultSet resultB2=ps.executeQuery();
while(resultB2.next()){
temp1=resultB2.getString("total");
String namec1=resultB2.getString("name");

temp1a=temp1.substring(0,1);
temp1aa=temp1.substring(0,3);
temp1b=temp1.substring(3,6);
//out.println(namec1);
//刪除子部門
ps=conn.prepareStatement(delete);
ps.setString(1, temp1);
int resultB3=ps.executeUpdate();
if(resultB3>0){
//out.println("delete C success!!!!");

ps=conn.prepareStatement(query2);
ps.setString(1, temp1b+"%");
ResultSet bD3=ps.executeQuery();
while(bD3.next()){

String totalc1=bD3.getString("total");
namec1=bD3.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;}
}}}}}

/* 刪除部門級:第三層和第四層一起刪除*/

if(temp1a.equals("C")){
//刪除本部門
ps=conn.prepareStatement(delete);
ps.setString(1, temp1);
int resultC1=ps.executeUpdate();
if(resultC1>0){
//out.println("delete C success!!!!");
//刪除子部門
ps=conn.prepareStatement(query2);
ps.setString(1, temp1b+"%");
ResultSet rs2=ps.executeQuery();
while(rs2.next()){
String totalc1=rs2.getString("total");
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>

sylmoon

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
JSP实现树型组织架构(5)--删除部门页面orgDelete.jsp

//orgDelete.jsp 删除部门页面,由orgManage.jsp 而来request.setCharacterEncoding("big5");String depName=request.getParameter("name");//out.println(depName+"");String message=null;boolean autoCommit=conn.getAutoCo
复制链接

扫一扫

专栏目录