adduser.jsp

jsp-公司管理系统-注册、会员管理等功能

<%-- addUser.jsp程序代码 --%>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.util.Calendar" %>
<%@ page import="java.sql.SQLException" %>
 

<%
//取得页面传递过来的用户资料
request.setCharacterEncoding("gb2312");
String username=request.getParameter("username");
String password=request.getParameter("password");
String realname=request.getParameter("realname");
int sex=Integer.parseInt(request.getParameter("sex"));
String age=request.getParameter("age");
String region=request.getParameter("region");
String email=request.getParameter("email");
String education=request.getParameter("education");
int marriage=Integer.parseInt(request.getParameter("marriage"));
//获得当前注册日期
Calendar nowCalendar=Calendar.getInstance();
String regdate=nowCalendar.get(Calendar.YEAR)+"/"+
		(nowCalendar.get(Calendar.MONTH)+1)+"/"+
		nowCalendar.get(Calendar.DATE);
//建立数据库连接并执行数据插入
Connection conn=null;
Statement stmt=null;
try{
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	conn=DriverManager.getConnection("jdbc:odbc:datasource_suit","sa","710318");
	stmt=conn.createStatement();
	String strSQL="insert into t_userInfo";
	strSQL+="(username,password,realname,sex,age,region,email,education,marriage,regdate) ";
	strSQL+="values(";
	strSQL+="'"+username+"',";
	strSQL+="'"+password+"',";
	strSQL+="'"+realname+"',";
	strSQL+=sex+",";
	strSQL+="'"+age+"',";
	strSQL+="'"+region+"',";
	strSQL+="'"+email+"',";
	strSQL+="'"+education+"',";
	strSQL+=marriage+",";
	strSQL+="'"+regdate+"')";
	//out.println(strSQL);
	stmt.executeUpdate(strSQL);
	stmt.close();
}catch(Exception e){
	out.println(username+"用户注册失败");
}finally{
	try{
		if(stmt!=null){
			stmt.close();
		}
		if(conn!=null){
			conn.close();
		}
	}catch(SQLException sqle){}
}
out.println(username+"用户已成功注册");
	
%>