userenter1.jsp

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

<%@page contentType="text/html;charset=GB2312"%>
<%@page import = "java.sql.*"%>
<% request.setCharacterEncoding("GB2312"); %>
<%	
	String user_id = request.getParameter("user_id");	
	String user_password = request.getParameter("user_password");
        String user_name="";
	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 +"' and user_password='"+user_password+"'");

	if(rs.next()){
                user_name=rs.getString("user_name");
                session.setAttribute("user_id",user_id);
                session.setAttribute("user_name",user_name);     
                response.sendRedirect("yuangong.jsp");
	}
	else{
                response.sendRedirect("Enterfail.jsp");
	}
        rs.close();
	stmt.close();
	conn.close();


%>