/* * name:	登陸Action * file:	LoginAction.java * author：	王聳 */package com.huang.actions;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;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 com.huang.common.DB.DBtool;import com.huang.forms.LoginForm;public class LoginAction extends Action {	public ActionForward execute(		ActionMapping mapping,		ActionForm form,		HttpServletRequest request,		HttpServletResponse response) {				//簡歷LoginForm對象		LoginForm loginForm = (LoginForm) form;				//從LoginForm中提取quan（權限值）		String quan = loginForm.getQuan();				//從LoginForm中提取username和password		String username = loginForm.getUsername();		String password = loginForm.getPassword();								//判斷quan（權限）		if(quan.equals("學生")) {			//驗證學生登錄信息			if(checkStudentLogin(username,password)) {				//驗證學生登陸成功，進入student菜單頁面				request.getSession().setAttribute("student",username);				return mapping.findForward("studnet");			}else {				//驗證出錯進入fail畫面				return mapping.findForward("fail");			}		}else if(quan.equals("教師")) {			//驗證教師登陸信息			if(checkTeacherLogin(username,password)) {				//驗證教師登陸成功，進入teacher菜單頁面				request.getSession().setAttribute("teacher",username);				return mapping.findForward("teacher");			}else{				//驗證出錯進入fail畫面				return mapping.findForward("fail");			}		}else if(quan.equals("管理員")) {			//驗證管理員登陸信息			if(checkAdminLogin(username,password)) {				//驗證教師登陸成功，進入admin菜單頁面				request.getSession().setAttribute("admin",username);				return mapping.findForward("admin");			}else {				//驗證出錯進入fail畫面				return mapping.findForward("fail");			}		}else {			//返回登陸頁			return mapping.findForward("fail");		}			}			//驗證學生登錄信息	public boolean checkStudentLogin(String username, String password) {				String sql = "select count(*) from tb_student where student_id = '"+username+"' and student_password = '"+password+"'";		//調用DBtool.getOneInt(sql)		int value = DBtool.getOneInt(sql);		return checkValue(value);		}	//	驗證教師登錄信息	public boolean checkTeacherLogin(String username, String password) {				String sql = "select count(*) from tb_teacher where teacher_id = '"+username+"' and teacher_password = '"+password+"'";		//調用DBtool.getOneInt(sql)		int value = DBtool.getOneInt(sql);		return checkValue(value);		}	//	驗證管理員登錄信息	public boolean checkAdminLogin(String username, String password) {			String sql = "select count(*) from tb_admin where admin_username = '"+username+"' and admin_password = '"+password+"'";		//調用DBtool.getOneInt(sql)		int value = DBtool.getOneInt(sql);		return checkValue(value);				}		//驗證value是否大于0	public boolean checkValue(int value) {				if(value > 0) {			return true;		}else {			return false;		}			}}