departmentdao.java

来自「人力资源信息管理系统！包含登录 员工管理 培训经历 用户管理 出勤管理等一系列人」· Java 代码 · 共 39 行

package com.buat.jobanddepartment;

import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import com.buat.interviewer.Interviewer;
import com.buat.connect.Connect;

public class DepartmentDAO implements IDepartmentDAO{

	public ArrayList QueryDepartmentNamefromDapartment() {
		
		ArrayList departmentList=new ArrayList();
		Connect manager=new Connect();
		Connection conn=manager.getConnect();
		PreparedStatement psmt=null;
		ResultSet rst=null;
		StringBuffer sql=new StringBuffer();
		sql.append("select departmentname from department");
		try {
			psmt=conn.prepareStatement(sql.toString());
			rst=psmt.executeQuery();
			while(rst.next()){
				Department department=new Department();
				department.setDepartmentname(rst.getString("departmentname"));
				departmentList.add(department);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return departmentList;
	}

}