useradd.jsp

这是一个学习jsp的基本程序

<%@ 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();
%><%}%>