managerdao.java

财务管理系统

/************
 * author:dengwen
 * beginTime:2008-11-28
 * updateTime:2008-11-30
 */
package org.fms.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.fms.model.ManagerInfo;

public class ManagerDao {
	private PreparedStatement ps;
	private ResultSet rs;
	private Connection conn;
	public Connection getConn() {
		return conn;
	}
	public void setConn(Connection conn) {
		this.conn = conn;
	}
	
	/***********
	 * 关闭ps与rs
	 *
	 */
	public void closePSandRS(){
		if(ps!=null){
			try {
				ps.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		if(rs!=null){
			try {
				rs.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	/***********
	 * 根据用户名与密码查找用户
	 * @param name
	 * @param pwd
	 * @return
	 */
	public ManagerInfo getManagerbyNameandPWD(String name,String pwd){
		ManagerInfo minfo =null;
		String sql="select * from manager where managerName=? and managerPWD=?";
		try {
			ps = conn.prepareStatement(sql);
			ps.setString(1, name);
			ps.setString(2, pwd);
			rs = ps.executeQuery();
			if(rs.next()){
				minfo= new ManagerInfo();
				minfo.setManagerID(rs.getInt("managerID"));
				minfo.setManagerName(rs.getString("managerName"));
				minfo.setManagerPWD(rs.getString("managerPWD"));
				minfo.setEmployeeID(rs.getInt("employeeID"));
				minfo.setRegisterDate(rs.getDate("registerDate"));
				minfo.setLoginNum(rs.getInt("loginNum"));
				minfo.setIp(rs.getString("ip"));
				minfo.setPopedom(rs.getInt("popedom"));
				minfo.setOperater(rs.getInt("operater"));
				minfo.setRemark(rs.getString("remark"));
				minfo.setIsDelete(rs.getInt("isDelete"));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return minfo;
	}
	/************
	 * 修改管理员登陆的次数
	 * @param id
	 * @param ip
	 * @return
	 */
	public boolean addLoginNum(int id,String ip){
		boolean flag = false;
		String sql = "update manager set loginNum=(loginNum+1),ip=? where managerID=?";
		try {
			ps = conn.prepareStatement(sql);
			ps.setString(1, ip);
			ps.setInt(2, id);
			int count = ps.executeUpdate();
			if(count>0){
				flag = true;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return flag;
	}
}