loginaction.java

java做的 公交车查询系统....毕业设计

//注册成功后,进入main.jsp主页时,加载车次列表和站点列表
package gongjiaochexitong.renyuan;

import gongjiaochexitong.gongjiaoche.*;
import gongjiaochexitong.gongjiaoche.main_pkg.*;

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

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import javax.servlet.ServletContext;
import javax.sql.DataSource;

public final class loginAction extends Action{
	
	public ActionForward execute(
			ActionMapping mapping,
			ActionForm form,
			HttpServletRequest request,  
			HttpServletResponse response) throws Exception {
      request.setCharacterEncoding("utf-8");	
	  loginForm loginform = (loginForm)form;
	  String userName = loginform.getUserName().trim();
	  String userPassword = loginform.getUserPassword().trim();
	  String userPower = loginform.getUserPower();
	 
		
	  System.out.println(userName+","+userPassword+","+userPower);
	  ServletContext context = servlet.getServletContext();
	  
	  DataSource dataSource1 = (DataSource)context.getAttribute("db_renyuan");
	  conn_User db1 = new conn_User(dataSource1);
	  
	  DataSource dataSource2 = (DataSource)context.getAttribute("db_gongjiaoche");
	  conn_Bus db2 = new conn_Bus(dataSource2);
	  
	  HttpSession session = request.getSession();
			
	  if(userName!=null && !userName.equals("") && userPassword!=null
			&& !userPassword.equals("") && userPower!=null && !userPower.equals("")){
		if(procedure_user.checkUser(db1, userName, userPassword, userPower)){
			session.setAttribute(constants.MEMBER, userName);      //记录用户信息,以便确认用户是否是管理员,可以进入后台.
			session.setAttribute(constants.POWER, userPower);
			try {		                      //加载主页面的信息	
				session.setAttribute(constants.CHECI_LIST_KEY,procedure.getCheCi_List(db2));
				session.setAttribute(constants.ZHANDIAN_LIST_KEY,procedure.getZhanDian_List(db2));
			} catch (Exception e) {
				e.printStackTrace();
			}
			
			db1.conn_Close();     //close connection
			db2.conn_Close();
		    return mapping.findForward("tomain");
		}
		else{
			db1.conn_Close();     //close connection
			return mapping.findForward("loginError");			
		}
			
	  }
	  else{
		db1.conn_Close();     //close connection
		return mapping.findForward("loginError");
	  }	
			
	}

}