<%@ page
    language="java"
    contentType="text/html; charset=GBK"
    import="imis.*,java.util.*"
%>
<%
//防止中文亂碼
  request.setCharacterEncoding("GBK");
//創建一個會話，接收系統登錄時候存儲的消息
  session=request.getSession();
  String user=(String)session.getAttribute("user");
  if(user.equals("")){
	response.sendRedirect("../../login.html");
  }
else{//只有當會話里存儲的消息不為空的時候，才進行下面的操作
String userid=request.getParameter("userid");
String username=request.getParameter("username");
String password=request.getParameter("password");
String access=request.getParameter("access");
String unit=request.getParameter("unit");
//設置變量num，接收SQL語句執行插入后的返回值
int num=0;
String name="wmj";
String pass="197555";
String processname = "";
//設置數據庫連接路徑
String   url="jdbc:sybase:Tds:172.16.0.1:4000/imis";
//注冊數據庫驅動
  	Class.forName("com.sybase.jdbc2.jdbc.SybDriver");
Integer unitid1 = new Integer(0);
try{
 		  String sql1 = "select * from officeunit where processname=?";
		  Connection  con=DriverManager.getConnection(url,name,pass);
		  PreparedStatement ps1=con.prepareStatement(sql1);
		  ps1.setString(1,name);
		  ResultSet rs1 = ps1.executeQuery();
		  while(rs1.next())
			unitid1 = rs1.unitid;
}
catch(Exception e)
{
	System.out.println("在查詢取出當前用戶所對應的單位號的時候出錯");
}
boolean success=true;

try{
String sql = "insert into user1 (user_id,user_pass,user_name,user_access,unitid) values(?,?,?,?,?)";
ps1 = con.preparedStatement(sql);
ps1.setString(1,userid);
ps1.setString(2,password);
ps1.setString(3,username);
ps1.setInt(4,new Integer(access).intValue());
ps1.setInt(5,unitid1.intValue());
//executeUpdate()執行后返回值是整數
num = ps1.executeUpdate();
}
catch(Exception e){     num=0;    }
if(num>0){
	System.out.println("用戶增加成功");
  response.sendRedirect("usercheck.jsp");}
else response.sendRedirect("../../error/adderror.html");
//依次關閉數據連接
rs1.close();
ps1.close();
con.close();
%><%}%>