loginaction.java

为基于J2EE（Java2 Platform

/*
 * 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;
		}
		
	}

}