loginchk.jsp

来自「自己写的基于JSP+servlet+Javabean的bookshop源代码」· JSP 代码 · 共 21 行

<%@page contentType="text/html;charset=gb2312"%>
<%@ include file="../common.jsp"%>
<%
	String userid = new String(request.getParameter("userid").trim().getBytes("ISO-8859-1"));
	String password = new String(request.getParameter("password").trim().getBytes("ISO-8859-1"));
 
	String sql = "SELECT * FROM tb_userpassword WHERE ISMASTER='Y' AND USER_ID='"+userid+"' AND USER_PASSWORD='"+password+"'";
 	
 	DBSQLManager dbsm = new DBSQLManager();
 	dbsm.setSqlStr(sql);
	dbsm.executeQuery();
	ResultSet rs =  dbsm.getRs();
	if (!rs.next()) 
    	{
  		String errmsg="error1";
  		response.sendRedirect("login.jsp?errmsg="+errmsg);
  		return;
    	} 
	response.sendRedirect("main.jsp");
%>