saveunit.jsp

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

<%@ 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_name =(String)request.getParameter("unit_name");
		String code =(String)request.getParameter("code");
	

		if(id==null){
			String sql="insert into txl_org  t values(txl_org_seq.nextval,'"+unit_name+"','1','"+code+"','2')";
		    st.executeUpdate(sql);
			//out.println(sql);
			
		}else{
			String sql="update txl_org t set t.org_name='"+unit_name+"' , t.org_no='"+code+"' 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>");
%>