delunit.jsp

来自「此程序为纯jsp实现通讯录功能」· JSP 代码 · 共 52 行

<%@ page contentType="text/html;charset=GBK"%>
<%@ page language="java" import="java.util.*"%>
<%@ page  import="java.sql.*,java.util.*,java.io.*" %>
<%@ include file="conn.jsp"%>

  <%	
		String id=(String)request.getParameter("id");	
		String sql=null;
		java.sql.ResultSet rs = null;

		
		if(id==null){
			/*String[] depart=request.getParameterValues("depart");
			for(int i=0;i<depart.length;i++){
					sql="select bumenmingcheng from unit  where id="+depart[i];
					rs = st.executeQuery(sql);
					rs.next();
					String unit = rs.getString("BUMENMINGCHENG");
					
					sql="delete from unit  where id="+depart[i];
					st.executeUpdate(sql);

					sql="delete from depart  where unit='"+unit+"'";
					st.executeUpdate(sql);

					sql="delete from address  where unit='"+unit+"'";
					st.executeUpdate(sql);


			}*/

		
			
		}else{
			sql="select * from txl_org t where t.upper_org_id ="+id;
			rs = st.executeQuery(sql);
			if(rs.next()){
				out.println("<SCRIPT LANGUAGE='JavaScript'>alert('部门中仍有数据，不能删除！');window.close();</SCRIPT>");
			}else{
							sql="delete from txl_org  where org_id="+id;
							st.executeUpdate(sql);
							out.println("<SCRIPT>window.opener.parent.location.reload();window.close()</SCRIPT>");
			}

		}
	
%>
  <%
rs.close();
st.close();
con.close();
%>