handleusers.java

基于mvc的java进销存系统

/*
 * HandleUsers.java
 *
 * Created on 2007年3月18日, 下午8:44
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package task;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;
import table.Users;
import util.DBSession;
import util.PropertiesUtil;

/**
 *
 * @author Administrator
 */
public class HandleUsers {
    
    /** Creates a new instance of HandleUsers */
    private DBSession dbsession=new DBSession();
    public HandleUsers() {
    }
    public Vector findAll(){     
        PreparedStatement ps = null;
        ResultSet rs = null;
        Vector vector=new Vector();
        try {
            String sql = PropertiesUtil.getSql_resource().getString("selectalluser").trim();
            ps = dbsession.DPreparedStatement(sql);
            rs = ps.executeQuery();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        try {
            while(rs.next()){
                Users users=new Users();
                users.setUserID(rs.getString("UserID"));
                users.setUserName(rs.getString("UserName"));
                users.setPasswordCode(rs.getString("PasswordCode"));
                users.setDepartmentID(rs.getInt("DepartmentID"));
                users.setUserIDIsUse(rs.getInt("IsUse"));
                vector.add(users);
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        dbsession.closedALL(rs);
        return vector;
    }
    
    public Users select(Users user ){
        PreparedStatement ps = null;
        ResultSet rs = null;
        Users users=new Users();
        try {
            String sql = PropertiesUtil.getSql_resource().getString("seluser").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,user.getUserID());
            rs = ps.executeQuery();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        try {
            while(rs.next()){
                users.setUserID(rs.getString("UserID"));
                users.setUserName(rs.getString("UserName"));
                users.setPasswordCode(rs.getString("PasswordCode"));
                users.setDepartmentID(rs.getInt("DepartmentID"));
                users.setUserIDIsUse(rs.getInt("IsUse"));
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return users;
    }
     public void save(Users user ){
        PreparedStatement ps = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("insertusers").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,user.getUserID());
            ps.setString(2,user.getUserName());
            ps.setString(3,user.getPasswordCode());
            ps.setInt(4,user.getDepartmentID());
            ps.setInt(5,user.getUserIDIsUse());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        try {
            ps.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        dbsession.connClose();
    }
     
      public void delete(Users user){
        PreparedStatement ps = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("deleteusers").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,user.getUserID());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        try {
            ps.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        dbsession.connClose();
    }
      
    public boolean valPassword(Users users){
        int result = 0;
        PreparedStatement ps = null;
        ResultSet rs = null;
        try{
            String sql = PropertiesUtil.getSql_resource().getString("selectuser").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,users.getUserName().trim());
            ps.setString(2,users.getPasswordCode());
            rs = ps.executeQuery();
            if(rs.next()){
                return true;
            }else{
                return false;
            }
        }catch(SQLException e){
            e.printStackTrace();
        }finally{
            try{
                ps.close();   
                dbsession.connClose();
            }catch(SQLException sqe){
                sqe.printStackTrace();
            }
        }
        return false; 
    }
    public void update(Users users){
         PreparedStatement ps = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("updateusers").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,users.getUserName());
            ps.setString(2,users.getPasswordCode());
            ps.setInt(3,users.getDepartmentID());
            //ps.setInt(4,users.getUserIDIsUse());
            ps.setString(4,users.getUserID());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
         try {
            ps.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        dbsession.connClose();
    }
    
    public void updatep(Users users){
         PreparedStatement ps = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("reworkpassword").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,users.getPasswordCode());
            //ps.setInt(3,users.getDepartmentID());
            //ps.setInt(4,users.getUserIDIsUse());
            //ps.setString(4,users.getUserID());
            ps.setString(2,users.getUserName());
            ps.executeUpdate();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
         try {
            ps.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        dbsession.connClose();
    }
    
    public boolean isDelete(Users users){
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            String sql = PropertiesUtil.getSql_resource().getString("seluser").trim();
            ps = dbsession.DPreparedStatement(sql);
            ps.setString(1,users.getUserID());
            rs = ps.executeQuery();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        try {
            while(rs.next()){
                if(rs.getInt("IsUse")!=0){
                    dbsession.closedALL(rs);
                    return false;
                }    
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        //dbsession.closedALL(rs);
        return true;
    }
}