empdao.java

员工管理系统

package com.yiboit.hhs.daos;

import java.sql.SQLException;
import java.util.List;

import javax.sql.DataSource;

import com.yiboit.hhs.EmpBean;
import com.yiboit.hhs.db.BaseDAO;

public class EmpDAO extends BaseDAO {

	private static final String QUERY = "select emp_id as empId"
			+ ", emp_name as empName, emp_sex as empSex"
			+ ", dept_id as deptId, salary " + " from emp where emp_id = ?";

	private String empId;

	private EmpBean empBean;

	public EmpBean getEmpBean() {
		return empBean;
	}

	public void setEmpId(String empId) {
		this.empId = empId;
	}

	public EmpDAO(DataSource ds) throws SQLException {
		super(ds);
	}

	@Override
	public void databaseAccess() throws SQLException {
		try {
			empBean = (EmpBean) sqlUtil.selectStrictSingle(QUERY,
					new Object[] { empId }, EmpBean.class);
		} finally {
			sqlUtil.close();
		}
	}

}