interviewerdao.java

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

package com.buat.interviewer;

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

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

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

	public ArrayList QueryInterviewer(int beginIndex, int endIndex) {
		
		ArrayList interviewerList=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 interviewer order by interviewerid desc limit ?,? ");
		try {
			psmt=conn.prepareStatement(sql.toString());
			psmt.setInt(1,beginIndex);
			psmt.setInt(2,maxlengh);
			rst=psmt.executeQuery();
			while(rst.next()){
				DisplayInterviewer inter=new DisplayInterviewer();
				inter.setInterviewerid(rst.getInt("interviewerid"));
				inter.setName(rst.getString("name"));
				inter.setGender(rst.getString("gender"));
				Date birthday=rst.getDate("birthday");
				inter.setBirthday(birthday);
				inter.setJob(rst.getString("job"));
				inter.setMajor(rst.getString("major"));
				inter.setExperience(rst.getString("experience"));
				inter.setDegree(rst.getString("degree"));
				inter.setUnriversity(rst.getString("university"));
				inter.setTelephone(rst.getString("telephone"));
				inter.setEmail(rst.getString("email"));
				inter.setContent(rst.getString("content"));
				interviewerList.add(inter);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return interviewerList;
	}

	public int QueryInterviewerCount(){		//统计学生总数
		int total=0;
		Connection con = null;
		PreparedStatement psmt = null;
		ResultSet rst = null;
		con = new Connect().getConnect();
		String sql="select count(*) from interviewer";
		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 boolean UpdateInterviewer(Interviewer inter,int interviewerid) {
		boolean successful = false;
		Connect manager=new Connect();
		Connection conn=manager.getConnect();
		PreparedStatement psmt=null;
		ResultSet rst=null;
		StringBuffer sql=new StringBuffer();
		sql.append("update interviewer set name=?,gender=?,birthday=?,job=?,major=?,experience=?,degree=?,university=?,telephone=?,email=?,content=? where interviewerid=?");
		try{
			psmt=conn.prepareStatement(sql.toString());
			psmt.setString(1,inter.getName());
			psmt.setString(2,inter.getGender());
			psmt.setDate(3,inter.getBirthday());
			psmt.setString(4,inter.getJob());
			psmt.setString(5,inter.getMajor());
			psmt.setString(6,inter.getExperience());
			psmt.setString(7,inter.getDegree());
			psmt.setString(8,inter.getUniversity());
			psmt.setString(9,inter.getTelephone());
			psmt.setString(10,inter.getEmail());
			psmt.setString(11,inter.getContent());
			psmt.setInt(12,interviewerid);
			
			int result = psmt.executeUpdate();
			if( result > 0){
				successful = true;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				if(psmt != null)psmt.close();
				if(conn!= null)conn.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
	    }
		return successful;
	}
}