educatedao.java

07年做得人力资源管理系统

package com.buat.hr.educate;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import com.buat.hr.share.ShareDAO;

public class EducateDAO extends ShareDAO {		
	
	public EducateDAO(){
		super();
	}
	
	/*
	 * 作用:查询已完成培训计划的培训总结.
	 */
	public ArrayList querySummarize(int startNo, int perCount, String tableName){
		ArrayList eduList=new ArrayList();
		Connection con=null;
		PreparedStatement ps=null;
		ResultSet rs=null;
		StringBuffer sql=new StringBuffer();
		
		con=db.getConnection();
		sql.append("select * from  "+tableName+" where summarize!='' limit "+startNo+","+perCount);
		
		try {
			ps = con.prepareStatement(sql.toString(),ResultSet.TYPE_SCROLL_INSENSITIVE);
			rs=ps.executeQuery();
			while(rs.next()){
				Educate educate=new Educate();
				
				educate.setId(rs.getInt(1));
				educate.setName(rs.getString(2));
				educate.setPurpose(rs.getString(3));
				educate.setBegintime(rs.getDate(4));
				educate.setEndtime(rs.getDate(5));
				educate.setTeacher(rs.getString(6));
				educate.setHuman(rs.getString(7));
				educate.setGrade(rs.getString(8));
				educate.setMaterial(rs.getString(9));
				educate.setEffect(rs.getString(10));
				educate.setSummarize(rs.getString(11));			
				
				eduList.add(educate);				
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				if(rs!=null){
					rs.close();
				}
				if(ps!=null){
					ps.close();
				}
				if(con!=null){
					con.close();
				}
			}catch (SQLException e) {
			e.printStackTrace();
			}
		}
		return eduList;
	}

	/*
	 * 作用:查询未完成的培训计划.
	 */
	@Override
	public ArrayList query(int startNo, int perCount, String tableName) {
		ArrayList eduList=new ArrayList();
		Connection con=null;
		PreparedStatement ps=null;
		ResultSet rs=null;
		StringBuffer sql=new StringBuffer();
		
		con=db.getConnection();
		sql.append("select * from  "+tableName+" where summarize='' limit "+startNo+","+perCount);
			
		try {
			ps = con.prepareStatement(sql.toString(),ResultSet.TYPE_SCROLL_INSENSITIVE);
			rs=ps.executeQuery();
			while(rs.next()){
				Educate educate=new Educate();
				
				educate.setId(rs.getInt(1));
				educate.setName(rs.getString(2));
				educate.setPurpose(rs.getString(3));
				educate.setBegintime(rs.getDate(4));
				educate.setEndtime(rs.getDate(5));
				educate.setTeacher(rs.getString(6));
				educate.setHuman(rs.getString(7));
				educate.setGrade(rs.getString(8));
				educate.setMaterial(rs.getString(9));
				educate.setEffect(rs.getString(10));
				educate.setSummarize(rs.getString(11));			
				
				eduList.add(educate);				
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				if(rs!=null){
					rs.close();
				}
				if(ps!=null){
					ps.close();
				}
				if(con!=null){
					con.close();
				}
			}catch (SQLException e) {
			e.printStackTrace();
			}
		}
		return eduList;
	}
}