dbuser.java~

一套大型Office网络办公系统

/**
* Copyright (c) 2002 CODEFAD.com
* All right reserved.
*
* Description: 用户数据库
*
* Author: Chu Daping 2002-5-13 13:34
*
*/

package com.codefad.easyoffice.db;

import java.util.*;
import java.sql.*;
import com.codefad.easyoffice.*;

public class DbUser implements User {
	
	private static final String UPDATE_USER = "update userinf set truename=?,logname=?,password=?," +
		"userdept=?,userlevel=?,logindate=?,logins=? where userID=?";
	private static final String LOAD_USER_BY_ID = "select * from userinf where userID=?";
	private static final String LOAD_USER_BY_NAME = "select * from userinf where logname=?";
	
	private long userID = -1;
	private String userName = null;
	private String trueName = null;
	private String userPasswd = null;
	private String userDept = null;
	private long userDeptID = -1;
	private long userStationID = -1;
	private String userLevel = null;
	private int userLogins = -1;
	private java.util.Date userLastLogin = null;
	private java.util.Date userCreateDate = null;
	private java.util.Date userLoginDate = null;
	
    
    public DbUser(long id) {
        this.userID = id;
        loadFromDbByID(); 
    }
    
    public DbUser(String username) {
        this.userName = username;
        loadFromDbByName(); 
    }
    
	
    private void loadFromDbByID()
    {
    	Connection con = new SqlCon().getConnection();
        try {
		    PreparedStatement stmt = con.prepareStatement(LOAD_USER_BY_ID);
		    stmt.setLong(1,userID);
		    ResultSet rs = stmt.executeQuery();
		    if (rs.next()) {
		    	userName = rs.getString("logname");
		    	trueName = rs.getString("truename");
		    	userPasswd = rs.getString("password");
		    	userDept = rs.getString("userdept");
		    	userDeptID = rs.getLong("deptID");
		    	userStationID = rs.getLong("stationID");
		    	userLevel = rs.getString("userlevel");
		    	userLogins = rs.getInt("logins");
		    	userLastLogin = rs.getDate("logindate");
		    	userCreateDate = rs.getDate("joindate");
	        }
		    rs.close();
			stmt.close();
		    con.close();
	    } catch (Exception e) {
	    	System.err.println("Can not find user " + userID + "!");
            e.printStackTrace();
		}
	}
    
    private void loadFromDbByName()
    {
    	Connection con = new SqlCon().getConnection();
    	PreparedStatement stmt = null;
    	ResultSet rs = null;
        try {
		    stmt = con.prepareStatement(LOAD_USER_BY_NAME);
		    stmt.setString(1,userName);
		    rs = stmt.executeQuery();
		    if (rs.next()) {
		        userID = rs.getInt("userID");
		    	trueName = rs.getString("truename");
		    	userPasswd = rs.getString("password");
		    	userDeptID = rs.getLong("deptID");
		    	userStationID = rs.getLong("stationID");
		    	userLevel = rs.getString("userlevel");
		    	userLogins = rs.getInt("logins");
		    	userLastLogin = rs.getDate("logindate");
		    	userCreateDate = rs.getDate("joindate");
	        }
	    } catch (Exception e) {
	    	System.err.println("Can not find user " + userName + "!");
            e.printStackTrace();
		}
		finally {
			try {
				rs.close();
				stmt.close();
			    con.close();
			} catch (Exception e) {
				System.err.println("Can not close connection!");
                e.printStackTrace();
              }
		}
	}
	
	private void saveToDb()
    {
    	Connection con = new SqlCon().getConnection();
        try {
		    PreparedStatement stmt = con.prepareStatement(UPDATE_USER);
		    stmt.setString(1,trueName);
		    stmt.setString(2,userName);
		    stmt.setString(3,userPasswd);
		    stmt.setString(4,userDept);
		    stmt.setString(5,userLevel);
		    stmt.setString(6,new Timestamp(userLoginDate.getTime()).toString());
		    stmt.setInt(7,userLogins);
		    stmt.setLong(8,userID);
		    stmt.executeUpdate();
			stmt.close();
		    con.close();
	    } catch (Exception e) {
		}
	}
    
    public long getUserID() {
    	return userID;
    }
    
    public String getUserName() {
    	return userName;
    }
    
    public void setUserName(String username)
    {
        userName = username;
        saveToDb();
    }

    public String getTrueName() {
    	return trueName;
    }
    
    public void setTrueName(String truename)
    {
        trueName = truename;
        saveToDb();
    }
    
    public String getUserPasswd() {
    	return userPasswd;
    }
    
    public void setUserPasswd(String passwd)
    {
        userPasswd = passwd;
        saveToDb();
    }
    
    public String getUserDept() {
    	Department dept = new DbDepartment(userDeptID);
    	userDept = dept.getDeptName();
    	return userDept;
    }
    
    public void setUserDept(String dept)
    {
        userDept = dept;
        saveToDb();
    }
    
    public long getUserStationID() {
    	return userStationID;
    }
    
    public void setUserStationID(long stationID)
    {
        userStationID = stationID;
        saveToDb();
    }
    
    public long getUserDeptID() {
    	return userDeptID;
    }
    
    public void setUserDeptID(long deptID)
    {
        userDeptID = deptID;
        saveToDb();
    }
    
    public String getUserLevel() {
    	return userLevel;
    }
    
    public void setUserLevel(String level)
    {
        userLevel = level;
        saveToDb();
    }
    
    public int getUserLogins() {
    	return userLogins;
    }
    
    
    public void setUserLogins() {
    	this.userLogins = userLogins + 1;
    	saveToDb();
	}
	
    
    public java.util.Date getUserLastLogin() {
    	return userLastLogin;
    }
    
    public java.util.Date getUserCreateDate() {
    	return userCreateDate;
    }
    
    public void setUserLoginDate()
    {
        userLoginDate = new java.util.Date();
        saveToDb();
    }
}