chklogin.jsp

这是一个基于JSP技术开发的在线书店系统,系统不是很大,不过包括了所有的需要的源代码,还有一些数据库配置等信息,蛮实用的.

<%@page contentType="text/html;charset=gb2312"%>
<%@ include file="../incoming/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 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");
%>