departmentdao.java

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

package com.bean.DAO;

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

import com.bean.DTO.DepartmentDTO;

public class DepartmentDAO {
	private Connection con;
	private ResultSet rs;
	private String SELECT="select * from department where departmentID=?";
	public DepartmentDAO(Connection con) {
		
		this.con = con;
	}
	
	public DepartmentDTO findDepartment(int departmentID){
		DepartmentDTO dto=new DepartmentDTO();
		try {
			PreparedStatement ps=con.prepareStatement(SELECT);
			ps.setInt(1,departmentID);
			rs=ps.executeQuery();
			
			if(rs.next()){
				dto.setDepartmentID(rs.getInt(1));
				dto.setDepname(rs.getString(2));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		return dto;
	}
}