deptlistdao.java

员工管理系统

package com.yiboit.hhs.daos;

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

import javax.sql.DataSource;

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

public class DeptListDAO extends BaseDAO {
	private static final String QUERY = "select dept_id as deptId, dept_name as deptName from dept";

	private List deptList;

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

	@Override
	public void databaseAccess() throws SQLException {
		try {
			deptList = super.sqlUtil.selectMulti(QUERY, null, DeptBean.class);
		} finally {
			super.sqlUtil.close();
		}
	}

	public List getDeptList() {
		return this.deptList;
	}
}