newuser.jsp

jsp+acess+tomcat6.0 编写的员工培训管理系统 供初学者参考

<%@page contentType="text/html;charset=GB2312"%>
<%@page import = "java.sql.*"%>
<% request.setCharacterEncoding("GB2312"); %>
<%	
	String user_id = request.getParameter("id");
	String user_nick= request.getParameter("nick");
	String user_name= request.getParameter("name");
	String user_IDcard= request.getParameter("IDcard");
	String user_sex = request.getParameter("sex");
	String user_email= request.getParameter("email");
	String user_tel= request.getParameter("tel");	
	String user_password = request.getParameter("password");
	String user_postalcode = request.getParameter( "postalcode" );
	String user_birthyear= request.getParameter( "birthyear");
	String user_birthmonth= request.getParameter( "birthmonth" );
	String user_favorite = request.getParameter( "favorite");
	String user_addr= request.getParameter( "addr");
	
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	Connection conn = DriverManager.getConnection("jdbc:odbc:movie");
	Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
					ResultSet.CONCUR_UPDATABLE);
	ResultSet rs = stmt.executeQuery("SELECT * FROM person where user_id = '" + user_id +"'");

	String String_SQL ="insert into person values('"+user_id+"','"+user_nick+"','"+user_name+"','"+user_IDcard+"','"+user_sex+"','"+user_email+"','"+user_tel+"','"+user_password+"', '"+ user_postalcode+"', '"+user_birthyear+"','"+ user_birthmonth+"','"+ user_favorite+"','"+ user_addr+"')";

	if(rs.next()){
                response.sendRedirect("userfail.jsp");
	}
	else{
		stmt.executeUpdate(String_SQL);
                response.sendRedirect("usersuccess.jsp");
	}
	stmt.close();
	conn.close();
%>