package com.accp.daoimpl;

import java.sql.SQLException;
import java.util.ArrayList;

import com.accp.dao.DeptDao;
import com.accp.entity.Dept;

public class DeptDAOImpl extends DAOBase implements DeptDao {

	@Override
	public ArrayList getAllDept() {
		// TODO Auto-generated method stub
		super.getConn();
		ArrayList arr = new ArrayList();
		try {
			pstmt = conn.prepareStatement("SELECT * FROM dept");
			rs = pstmt.executeQuery();
			Dept dept = null;
			while(rs.next()){
				dept = new Dept();
				dept.setDeptno(rs.getLong("Deptno"));
				dept.setDname(rs.getString("Dname"));
				dept.setLoc(rs.getString("Loc"));
				arr.add(dept);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			super.closeConn();
		}
		return arr;
	}

}