op_manager.java

考勤管理系统是针对学校每个月的考勤的报表进行总结

package action;

import java.sql.SQLException;
import java.util.Vector;

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

import util.Manager;

public class Op_manager extends DBOption {
	private Manager amanager = null;
	private Vector<Manager> managers = null;
	private HttpSession session = null;
	
	private String sqlStr = "";
	public String msg = "";
	private String newPw = "";
	
	public Op_manager() {
		this.setPoolName("kaoqin");
	}
	
	/**
	 * 管理员登录
	 * @param request 登录请求
	 * @return boolean 登录成功返回true 失败返回false 可以在msg中获取失败的原因
	 */
	public boolean login(HttpServletRequest request) {
//获得页面信息
		String username = request.getParameter("username");
		if (username == null || username.equals("")) {
			this.msg = "登录账号不能为空!";
			return false;
		}
		String password = request.getParameter("password");
		if (password == null || password.equals("")) {
			this.msg = "登录密码不能为空!";
			return false;
		}
		sqlStr = "select * from Manager where M_LoginID = '" + 
				username + "'";
		try {
			this.query(sqlStr);
			if (this.rs.next()) {
				//找到对应信息
				if (password.equals(rs.getString("M_LoginPW"))) {
					//密码正确
					this.session = request.getSession(false);
					session.setAttribute("M_ID", rs.getInt("M_ID"));
					session.setAttribute("M_LoginID", username);
					session.setAttribute("M_department", rs.getString("M_department"));
					session.setAttribute("M_power", rs.getString("M_power"));
					session.setAttribute("M_type", rs.getString("M_type"));
					return true;
				} else {
					//密码不正确
					this.msg = "密码不正确,请重新登录!";
					return false;
				}
			} else {
				this.msg = "用户不存在!请确定您的账号是否正确!";
				return false;
			}
		} catch (SQLException e) {
			this.msg = "登录出错，请稍候再试！";
			Log.writeLog(e, "action.Op_manager.loging:\n\t" +
					"取得指定管理员" + username + "时出错");
			return false;
		}
	}

	/**
	 * <p>判断管理员是否存在</p>
	 * @param id
	 * @param pw
	 * @return
	 */
	public boolean isExist(String id, String pw) {
		sqlStr = "select * from Manager " +
				"where M_LoginId='" + id +"'" +
				" and M_LoginPw='"+ pw +"'";
		
		//System.out.println("Op_manager.isExist()_01 sqlStr = " + sqlStr);
		
		try {
			this.rs = this.query(sqlStr);
			if (rs.next()) {
				//this.aManager = new Manager();
				//this.aManager.setM_id(id);
				//this.aManager.setM_pw(pw);
				//this.aManager.setM_name(rs.getString("m_name"));
				this.rs.close();
				freeConn();
				return true;
			} else {
				this.rs.close();
				freeConn();
				this.msg = "用户名不存在或密码不正确";
				return false;
			}
		} catch (SQLException e) {
			this.msg = "判断用户是否存在时出错";
			freeConn();
			Log.writeLog(e, "Op_manager.isExist()_catch :" + sqlStr);
			return false;
		}
	}
	
	/**
	 * <p>获取请求信息</p>
	 * @param request
	 * @return
	 */
	public boolean getRequest(HttpServletRequest request) {
		this.amanager = new Manager();
		
		String temStr = request.getParameter("adminID");
		if (temStr == null || temStr.equals("")) {
			this.msg = "请指定管理员ID";
			return false;
		}
		this.amanager.setLoginId(temStr);
		
		temStr = request.getParameter("oldPassword");
		if (temStr == null || temStr.equals("")) {
			this.msg = "请输入老密码";
			return false;
		}
		this.amanager.setLoginPw(temStr);
		
		temStr = request.getParameter("newPassword");
		if (temStr == null) {
			temStr= "";
		}
		this.newPw  = temStr;
		return true;
	}
	
	/**
	 * <p>修改管理员密码</p>
	 * @param request
	 * @return
	 */
	public boolean changePW (HttpServletRequest request) {
		if (this.getRequest(request)) {
			if (this.isExist(amanager.getLoginId(), amanager.getLoginPw())) {
				if (this.newPw.equals("")) {
					this.msg = "不允许用空密码";
					return false;
				}
				sqlStr = "update Manager set M_LoginPw='" + newPw + "'" +
						" where M_LoginID='" + amanager.getLoginId() + "'" +
						" and M_LoginPW='" + amanager.getLoginPw() + "'";
				
				//System.out.println("Op_manager.changePW_01 sqlStr = " + sqlStr);
				
				try {
					this.update(sqlStr);
					freeConn();
					return true;
				} catch (SQLException e) {
					this.msg = "修改密码时出错";
					freeConn();
					Log.writeLog(e, "Op_manager.changePW_catch " + sqlStr);
					return false;
				}
			} else {//不存在
				return false;
			}
		} else {//获取请求信息出错
			return false;
		}
	}
	
	public Vector getAllManager() {
		sqlStr = "select * from Manager";
		
		try {
			this.rs = this.query(sqlStr);
			this.managers = new Vector<Manager>();
			
			while (rs.next()) {
				this.amanager = new Manager();
				this.amanager.setId(rs.getString("M_ID"));
				this.amanager.setLoginId(rs.getString("M_LoginID"));
				this.amanager.setLoginPw(rs.getString("M_loginPW"));
				String dep = rs.getString("M_department");
				if (dep == null) dep = "教务处";
				this.amanager.setDepartment(dep);
				this.amanager.setPower(rs.getString("M_power"));
				this.amanager.setType(rs.getString("M_type"));
				this.managers.addElement(amanager);
			}
			this.rs.close();
			freeConn();
			if (managers.size() == 0) {
				this.msg = "找不到任何院系教务员信息";
				return null;
			}
			return managers;
		} catch (SQLException e) {
			this.msg = "查询所有院系教务员信息时出错";
			freeConn();
			Log.writeLog(e, "Op_teacher.getAllTeacherInfo()-catch " + sqlStr);
			return null;
		}
	}
	
}