talentlibdao.java

人力资源信息管理系统！包含登录 员工管理 培训经历 用户管理 出勤管理等一系列人力资源的信息管理模块！

package com.buat.talentlib;

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.connect.Connect;

public class TalentlibDAO implements ITalentlibDAO{

	public boolean AddTalentlib(Talentlib talentlib) {
		boolean successful=false;
		Connect manager=new Connect();
		Connection conn=manager.getConnect();
		PreparedStatement psmt=null;
		StringBuffer sql=new StringBuffer();
		sql.append("insert into talentlib(name,gender,birthday,job,major,experience,degree,university,telephone,email,content)");
		sql.append("                 values(   ?,     ?,       ?,  ?,    ?,         ?,     ?,          ?,        ?,    ?,      ?)");
		try {
			psmt=conn.prepareStatement(sql.toString());
			psmt.setString(1,talentlib.getName());
			psmt.setString(2,talentlib.getGender());
			psmt.setDate(3,talentlib.getBirthday());
			psmt.setString(4,talentlib.getJob());
			psmt.setString(5,talentlib.getMajor());
			psmt.setString(6,talentlib.getExperience());
			psmt.setString(7,talentlib.getDegree());
			psmt.setString(8,talentlib.getUniversity());
			psmt.setString(9,talentlib.getTelephone());
			psmt.setString(10,talentlib.getEmail());
			psmt.setString(11,talentlib.getContent());
			
			int result = psmt.executeUpdate();
			if( result > 0){
				successful = true;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return successful;
	}


	public boolean DeleteTalentlibById(int talentlibid){
		boolean successful=false;
		Connection conn=new Connect().getConnect();
		PreparedStatement psmt=null;
		StringBuffer sql=new StringBuffer();
		sql.append("delete from talentlib where talentlibid=?");
		try {
			psmt=conn.prepareStatement(sql.toString());
			psmt.setInt(1,talentlibid);
			
			int result=psmt.executeUpdate();
			if(result>0){
				successful=true;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return successful;
	}

	public ArrayList QueryTalentlib(int beginIndex, int endIndex) {
		ArrayList talentlibList=new ArrayList();
		Connect manager=new Connect();
		Connection conn=manager.getConnect();
		int maxlengh= (endIndex - beginIndex) + 1;
		PreparedStatement psmt=null;
		ResultSet rst=null;
		StringBuffer sql=new StringBuffer();
		sql.append("select * from talentlib order by talentlibid desc limit ?,?");
		try {
			psmt=conn.prepareStatement(sql.toString());
			psmt.setInt(1,beginIndex);
			psmt.setInt(2,maxlengh);
			rst=psmt.executeQuery();
			while(rst.next()){
				Talentlib talentlib=new Talentlib();
				talentlib.setTalentlibid(rst.getInt("talentlibid"));
				talentlib.setName(rst.getString("name"));
				talentlib.setGender(rst.getString("gender"));
				Date birthday=rst.getDate("birthday");
				talentlib.setBirthday(birthday);
				talentlib.setJob(rst.getString("job"));
				talentlib.setMajor(rst.getString("major"));
				talentlib.setExperience(rst.getString("experience"));
				talentlib.setDegree(rst.getString("degree"));
				talentlib.setUniversity(rst.getString("university"));
				talentlib.setTelephone(rst.getString("telephone"));
				talentlib.setEmail(rst.getString("email"));
				talentlib.setContent(rst.getString("content"));
				talentlibList.add(talentlib);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return talentlibList;
	}

	public int QueryTalentlibCount() {
		int total=0;
		Connection con = null;
		PreparedStatement psmt = null;
		ResultSet rst = null;
		con = new Connect().getConnect();
		String sql="select count(*) from talentlib";
		try {
			psmt=con.prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE);
			rst=psmt.executeQuery();
			if(rst.next()){
				total=rst.getInt(1);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		return total;
	}


	public ArrayList QueryTalentlib() {
		// TODO 自动生成方法存根
		return null;
	}
	
}