loginservlet.java

一个jsp的oa系统,里面有很多亮点学习!

package com.oa.lp.servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;

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

import com.oa.lp.dao.EmployeeDAO;
import com.oa.lp.dao.RoleDAO;
import com.oa.lp.database.DataBase;
import com.oa.lp.model.Employee;
import com.oa.lp.model.Role;
import com.oa.lp.util.PageList;
import com.oa.lp.util.Pages;


public class LoginServlet extends TopServlet{
   static final long serialVersionUID = 1L;

   
   protected void doPost(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
	
	   //接参
	   String userName = request.getParameter("userName")==null?"":request.getParameter("userName");
	   String userPwd = request.getParameter("userPwd")==null?"":request.getParameter("userPwd");
	   
	   HttpSession session = request.getSession();
	   
	  
	   Connection conn=null;
	try {
		
		conn = DataBase.getConnection();
		EmployeeDAO empDao = new EmployeeDAO();
		empDao.setConn(conn);
		
		Employee emp = empDao.getByUserName(userName);
		if(emp!=null&&emp.getUserPwd().equals(userPwd)){
			//输入的信息正确
			//员工
			session.setAttribute("emp",emp);
			//权限
			session.setAttribute("powers",empDao.getPowersByEmpId(emp.getEmpId()));
			//菜单
			session.setAttribute("menus",empDao.getMenusByEmpId(emp.getEmpId()));
			this.sendRedirect(request, response,"/index.html");
		}else{
			//输入的不正确
			request.setAttribute("msg","用户名或密码错误!");
			this.forward(request, response,"/login.jsp");
			
		}
		
		//事务提交
		DataBase.commit();
		
	} catch (Exception e) {
		e.printStackTrace();
	}finally{
		if(conn!=null){
			//关闭连接
			DataBase.releaseConnection(conn);
		}
	}
	   
}
   
   
}