dbusermanager.java

来自「一套大型Office网络办公系统」· Java 代码 · 共 62 行

/**
* Copyright (c) 2002 CODEFAD.com
* All right reserved.
*
* Description: ....
*
* Author: Chu Daping 2002-5-13 16:02
*
*/

package com.codefad.easyoffice.db;

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

public class DbUserManager implements UserManager {

    private static final String USER_COUNT = "SELECT * FROM userinf";
    private static final String DELETE_USER =
        "DELETE FROM userinf WHERE userID=?";
    private static final String ALL_USERS =
        "SELECT userID from userinf";

    SqlCon conn = new SqlCon();

    public DbUserManager() {
        
    }

    public User createUser(String userName)
    {
        User newUser = null;
        newUser = new DbUser(userName);
        return newUser;
    }

    public User getUser(long userID) {
        User user = null;
        user = new DbUser(userID);
        return user;
    }

    public User getUser(String userName) {
    	User user = null;
        user = new DbUser(userName);
        return user;
    }

    public void deleteUser(User user) {
        long userID = user.getUserID();
        Connection con = new SqlCon().getConnection();
        PreparedStatement stmt = null;
        try {
        stmt = con.prepareStatement(DELETE_USER);
		stmt.setLong(1,userID);
		stmt.executeUpdate();
		stmt.close();
	    con.close();
	    } catch (Exception e) {}
    }
}