savedepart.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 unit_id = (String)request.getParameter("unit_id");
		String depart = (String)request.getParameter("depart");


		if(id==null){
			String sql="insert into txl_org  t values(txl_org_seq.nextval,'"+depart+"','"+unit_id+"','','3')";
		    st.executeUpdate(sql);
			//out.println(sql);
			
		}else{
			String sql="update txl_org t set t.org_name='"+depart+"' , t.upper_org_id='"+unit_id+"' where t.org_id= "+ id;
		    st.executeUpdate(sql);
//			out.println(sql);
		}
	
	
  %>

  <%
st.close();
con.close();
out.println("<SCRIPT>window.opener.parent.location.reload();window.close()</SCRIPT>");
%>