deldepart.jsp

此程序为纯jsp实现通讯录功能

<%@ 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[] chushi=request.getParameterValues("depart");
			for(int i=0;i<chushi.length;i++){
					sql="delete from txl_person t where t.org_id = "+chushi[i];
					st.executeUpdate(sql);
					sql="delete from txl_org t  where t.org_id= "+chushi[i];
					st.executeUpdate(sql);

			//out.println(sql);
			}
		}else{

			sql="select * from txl_person p where p.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();
%>