loginservlet.java

通过jsp+servlet+bean实现数据库查询

package servlet;

import java.io.IOException;
import java.util.ArrayList;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import real.RealO;
import shared.Convert;
import shared.MessageBean;

import bean.UserBean;


public class LoginServlet 
{
	private RealO objRealO = null;

	public LoginServlet()
	{		
		objRealO = new RealO();
		System.out.println("======RealO=======");
	}
	
	public void Login(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException
	    {   
	        MessageBean result = new MessageBean();
	        UserBean statBean = new UserBean();
	       	String un = request.getParameter("username");
	        statBean.setUserName(un);
	        System.out.println(un);
	        String pw = request.getParameter("password");
	        statBean.setPassword(pw);
	        System.out.println(pw);
	        
	        result = objRealO.Login(statBean);//登陆验证
	    
	       	 if (MessageBean.OK == result.getStatus())
		        {
	       		 	result = objRealO.SelectUser();//先看result定义
	 	       		request.getSession().setAttribute("Log", (ArrayList)result.getMsg());
	 	       		
//	 	          	request.getSession().setAttribute("UserInfo",result);
	 	       		response.sendRedirect("score.jsp");
	       		 }
		     else
		        	response.sendRedirect("main.jsp");}
	    
	public void managerUser(HttpServletRequest request,HttpServletResponse response)throws ServletException, IOException
	{
    	MessageBean result = new MessageBean();
        UserBean statBean = new UserBean();
        
        int Type = Convert.StrToInt(request.getParameter("Type"));
    	statBean.setId(Convert.StrToInt(request.getParameter("Id")));
        statBean.setUserName(Convert.StrToGB2312(request.getParameter("UserName")));
        statBean.setChinese(Convert.StrToInt(request.getParameter("Chinese")));
        statBean.setEnglish(Convert.StrToInt(request.getParameter("English")));
        statBean.setMaths(Convert.StrToInt(request.getParameter("Maths")));
        switch(Type)
        {
           case 3:  //修改用户
        	   objRealO .ManagerUser(3,statBean);
           	break;
           case 2:  //添加用户
        	   objRealO.ManagerUser(2,statBean);   	   
           	break;
           case 4: //删除用户
        	   objRealO.ManagerUser(4,statBean);
           	break;
        }
        result = objRealO.SelectUser();
        if(MessageBean.OK == result.getStatus())
        {
        	request.getSession().setAttribute("Log", (ArrayList)result.getMsg());
        	System.out.println(result);
        }
       	response.sendRedirect("score.jsp");
        
       	      
	}         
	
}