adminenter1.jsp

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

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

	if(rs.next()){
                session.setAttribute("admin_id",admin_id);
                session.setAttribute("login_flag","success");
                response.sendRedirect("Admin.jsp");
	}
	else{
                response.sendRedirect("Enterfail.jsp");
	}
        rs.close();
	stmt.close();
	conn.close();
%>