checkuser.java

基于jsp的图书管理系统的功能和实现

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
import data.LoginData;
public class CheckUser extends HttpServlet{
	private static final String CONTENT_TYPE="text/html;charset=GBK";
	public void doPost(HttpServletRequest request,HttpServletResponse response)
	throws ServletException,IOException{
		request.setCharacterEncoding("GBK");
		String username = request.getParameter("username");
		String password = request.getParameter("password");
		LoginData loginData = new LoginData();
		Connection conn = loginData.getConn();
        HttpSession session =request.getSession(false);
        if(session==null)
        {
         response.sendRedirect("tushu/error.jsp");
         return;
        }
         session.setAttribute("User",username);
         session.setAttribute("Pass",password);
		 try{
			Statement stmt = conn.createStatement();
            String strSql="SELECT * FROM Reader WHERE Rpassword='"+password+"'"+" "+"AND"+" "+"Rnumber='"+username+"'";
			 ResultSet rs = stmt.executeQuery(strSql);
			 if(rs.next()){
			 	response.sendRedirect("tushu/MylibSearch.jsp");
			 	}
			 	else{
			 		response.sendRedirect("tushu/error.jsp");
			 		}
		   }catch(Exception ex){
		   	ex.printStackTrace();
		   	}
		
		}
		public void destroy(){
			}
	
	}