saveuser.jsp

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

<%@ page contentType="text/html;charset=GBK"%>
<%@ page  import="java.util.*" %>
<%@ page  import="java.sql.*,java.util.*,java.io.*" %>
<%@ include file="conn.jsp"%>
  <%	
		String id=(String)request.getParameter("id");	
		String username=(String)request.getParameter("username");
		String CODE=(String)request.getParameter("CODE");
		String DEPART_ID=(String)request.getParameter("depart_id");
		String DEPART=(String)request.getParameter("DEPART");
		String POST=(String)request.getParameter("POST");
		String ROOMID=(String)request.getParameter("ROOMID");
		String CITYID=(String)request.getParameter("CITYID");
		String PHONE=(String)request.getParameter("PHONE");
		String EXTENSION=(String)request.getParameter("EXTENSION");
		String MOBILE=(String)request.getParameter("MOBILE");
		String tdno=(String)request.getParameter("tdno");
		String email=(String)request.getParameter("email");
		String fax=(String)request.getParameter("fax");
		String zip=(String)request.getParameter("zip");
		String address=(String)request.getParameter("address");
		String remark=(String)request.getParameter("remark");
									
		if(id==null){
			String sql="insert into txl_person t values(txl_person_seq.nextval,'"+username+"','"+CODE+"','"+DEPART_ID+"','"+POST+"','"+ROOMID+"','"+CITYID+"','"+PHONE+"','"+EXTENSION+"','"+MOBILE+"','"+tdno+"','"+email+"','"+fax+"','"+zip+"','"+address+"','"+remark+"')";
			//out.println(sql);
		    st.executeUpdate(sql);

			
		}else{
			String sql="update txl_person  set NAME='"+username+"',CODE='"+CODE+"',ORG_ID='"+DEPART_ID+"',POST='"+POST+"',ROOMID='"+ROOMID+"',CITYID='"+CITYID+"',PHONE='"+PHONE+"',EXTENSION='"+EXTENSION+"',MOBILE='"+MOBILE+"',TDNO='"+tdno+"',EMAIL='"+email+"',FAX='"+fax+"',ZIP='"+zip+"',ADDRESS='"+address+"',REMARK='"+remark+"' where id='"+id+"'";
		    st.executeUpdate(sql);
			}
%>

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