userinfordao.java

仓库管理系统,适合各种行业的仓库管理系统

package com.bean.DAO;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

import com.bean.DTO.UserinforDTO;
import com.database.DataSourceFactory;

public class UserinforDAO {
private final String CHECKUSER="select * from userinfor where userID=? and password = ? and jobID= ?";
private final String GETUSER="select u.*,j.jobname, d.depname from userinfor u,job j , department d where userID=? " +
		" and u.jobID=j.jobID and u.departmentID=d.departmentID ";
private final String UPDATEUSER="update userinfor " +
		" set jobID=?, phone=?, information=?  where userID=?";

private final String ADDUSER="insert into userinfor values('8888',?,?,1,?,?,?)";

private List<UserinforDTO> list;
private Connection con;
private ResultSet rs;
public UserinforDAO(Connection con){
	list=new ArrayList<UserinforDTO>();
	this.con=con;
}

public UserinforDTO checkUser(UserinforDTO dto){
	UserinforDTO udto=null;
	try {
		PreparedStatement ps=con.prepareStatement(CHECKUSER);
		ps.setInt(1,dto.getUserID());
		ps.setString(2,dto.getPassword());
		ps.setInt(3,dto.getJobID());
		rs=ps.executeQuery();
		if(rs.next()){
			udto=new UserinforDTO();
			udto.setUserID(rs.getInt(1));
			udto.setDepartmentID(rs.getInt(4));
			udto.setJobID(rs.getInt(8));
		}
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	return udto;
}
public UserinforDTO getUser(int userID){
	PreparedStatement ps;
	UserinforDTO dto=null;
	try {
		ps = con.prepareStatement(GETUSER);
		ps.setInt(1,userID);
		rs=ps.executeQuery();
		if(rs.next()){
			dto=new UserinforDTO();
			dto.setUserID(userID);
			dto.setName(rs.getString(3));
			dto.setPhone(rs.getString(6));
			dto.setInformation(rs.getString(7));
			dto.setJobID(rs.getInt(8));
			dto.setJobname(rs.getString(9));
			dto.setDepartment(rs.getString(10));
		}
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	return dto;
	
}

public boolean updateUser(UserinforDTO dto){
	boolean flag=false;
	try {
		PreparedStatement ps = con.prepareStatement(UPDATEUSER);
		ps.setInt(1,dto.getJobID());
		
		ps.setString(2, dto.getPhone());
		System.out.println("fdfdsfdsafdsffdsfdsaaaaafdsfdfdsfdsfdsf    "+dto.getPhone());
		ps.setString(3,dto.getInformation());
		ps.setInt(4,dto.getUserID());
		ps.execute();
		flag=true;
		
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	return flag;
}
public boolean addUser(UserinforDTO dto){
	boolean flag=false;
	try {
		PreparedStatement ps = con.prepareStatement(ADDUSER);
		ps.setString(1,dto.getName());
		ps.setInt(2,dto.getDepartmentID());
		ps.setString(3,dto.getPhone());
		ps.setString(4,dto.getInformation());
		ps.setInt(5,dto.getJobID());
		ps.execute();
		flag=true;
		
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	return flag;
}

//仓库的方法
public boolean existCheckerID(int userID){
	try {
		PreparedStatement ps=con.prepareStatement("select * from userinfor where userID=?");
		ps.setInt(1,userID);
		if(rs.next()){
			return true;
		}
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	return false;
}


}