jobdao.java

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

package com.buat.jobanddepartment;

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

import com.buat.connect.Connect;

public class JobDAO implements IJobDAO{
	
	public ArrayList queryPosition(String departmentname) {

		PreparedStatement pst = null;
		ResultSet rs=null;
		Connection con=Connect.getConnect();
		ArrayList interviewerlist=new ArrayList();
		
		try {
			pst=con.prepareStatement("select * from  job where departmentname=?");
				pst.setString(1,departmentname);
			rs=pst.executeQuery();
			rs.beforeFirst();
			while(rs.next()){
				Job position=new Job();
				position.setName(rs.getString("name"));
				
				interviewerlist.add(position);
			}
			
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				if(pst!=null) pst.close();
				if(con!=null) con.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		
		return interviewerlist;
	}
}