w2usermgr.java

采用Jsp,Javabean,Servlet等做的人力资源管理系统,后台管理用户及密码均是:admin

package dbmgr;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.*;

import userbean.w2User;

public class w2UserMgr {
	DBConMgr db_conn=new DBConMgr();
	
 public Collection search(String name)
	{
		db_conn.ConnectDB();
		Collection showlist=new ArrayList();
		ResultSet rs = null;
		try{
			String sql="select * from empre where userid like '%"+name+"%'";
			rs = db_conn.stmt.executeQuery(sql); 
			w2User user = null;
			while(rs.next())
			{
				user=new w2User();
				user.setUserid(rs.getInt("userid"));
				user.setEmpname(rs.getString("empname"));
				user.setDepartment(rs.getString("department"));
				user.setDuty(rs.getString("duty"));
				user.setSchoolage(rs.getString("schoolage"));
				user.setJobcontent(rs.getString("jobcontent"));
				user.setRemark2(rs.getString("remark2"));
				user.setImpachieve(rs.getString("impachieve"));
				user.setTeachexp(rs.getString("teachexp"));
				user.setTrainexp(rs.getString("trainexp"));
				user.setWorkexp(rs.getString("workexp"));
				showlist.add(user);
			}
			return showlist;
		}
		catch (SQLException SqlE) {
			SqlE.printStackTrace();
			return null;
		} 
		catch (Exception E) {
			E.printStackTrace();
			return null;
		} 
		finally {
			// 关闭连接，释放数据库资源：
			db_conn.CloseDB();
		}
	}
 
 public Collection getAll(){
		db_conn.ConnectDB();
		Collection showlist=new ArrayList();
		ResultSet rs = null;
		try{
			String sql="select * from empre  order by userid asc";
			rs = db_conn.stmt.executeQuery(sql); 
			w2User user = null;
			while(rs.next())
			{
				user=new w2User();
			    user.setUserid(rs.getInt("userid"));
				user.setEmpname(rs.getString("empname"));
				user.setDepartment(rs.getString("department"));
				user.setDuty(rs.getString("duty"));
				user.setSchoolage(rs.getString("schoolage"));
				user.setJobcontent(rs.getString("jobcontent"));
				user.setRemark2(rs.getString("remark2"));
				user.setImpachieve(rs.getString("impachieve"));
				user.setTeachexp(rs.getString("teachexp"));
				user.setTrainexp(rs.getString("trainexp"));
				user.setWorkexp(rs.getString("workexp"));
				showlist.add(user);
			}
			return showlist;
		}
		catch (SQLException SqlE) {
			SqlE.printStackTrace();
			return null;
		} 
		catch (Exception E) {
			E.printStackTrace();
			return null;
		} 
		finally {
			// 关闭连接，释放数据库资源：
			db_conn.CloseDB();
		}
	}
 
 public int add(w2User user)
	{
		db_conn.ConnectDB();
		try {
			String sql = "insert into empre(userid,empname,department,duty,schoolage,jobcontent,remark2,impachieve,teachexp,trainexp,workexp)"+
			    "values("+user.getUserid()+",'" + user.getEmpname()+ 
				 "','" + user.getDepartment()+"','" + user.getDuty()+"','" + user.getSchoolage()+"','" + user.getJobcontent()+"','" + user.getRemark2()+"','" + user.getImpachieve()+"','" + user.getTeachexp()+"','" + user.getTrainexp()+"','" + user.getWorkexp()+"')";
		int i = db_conn.stmt.executeUpdate(sql); // 执行sql语句
		return i;
	
		
	}
		catch (SQLException SqlE){
			SqlE.printStackTrace();
			return -1;
		} 
		catch (Exception E) {
			E.printStackTrace();
			return -2;
		} 
		finally {
			// 关闭连接，释放数据库资源：
			db_conn.CloseDB();
		}
	}
	
	public int chang(w2User user)
	{
		db_conn.ConnectDB();
		try {
			String sql = "update empre set empname='"+
			user.getEmpname()+"',department='"+
			user.getDepartment()+"',duty='"+
			user.getDuty()+"',schoolage='"+
			user.getSchoolage()+"',jobcontent='"+
			user.getJobcontent()+"',remark2='"+
			user.getRemark2()+"',impachieve='"+
			user.getImpachieve()+"',teachexp='"+
			user.getTeachexp()+"',trainexp='"+
			user.getTrainexp()+"',workexp='"+
			user.getWorkexp()+"' where userid="+
			user.getUserid();
			int i = db_conn.stmt.executeUpdate(sql); // 执行sql语句
			return i;
		
			
		    }
			catch (SQLException SqlE){
				SqlE.printStackTrace();
				return -1;
			} 
			catch (Exception E) {
				E.printStackTrace();
				return -2;
			} 
			finally {
				// 关闭连接，释放数据库资源：
				db_conn.CloseDB();
			}
		}
	
	public int delete(int userid)
	{
		db_conn.ConnectDB();
		try {
			String sql="delete from empre where userid="+userid+"";
			int i = db_conn.stmt.executeUpdate(sql);
		return i;
		}
		catch (SQLException SqlE){
			SqlE.printStackTrace();
			return -1;
		} 
		catch (Exception E) {
			E.printStackTrace();
			return -2;
		} 
		finally {
			// 关闭连接，释放数据库资源：
			db_conn.CloseDB();
		}
	}
	
	public Collection getPage(int start,int size)
	{
		System.out.println(start+","+size);
	 
		db_conn.ConnectDB();
		Collection showlist=new ArrayList();
		ResultSet rs = null;
		try{
			String sql="select * from empre  order by userid asc";
			rs = db_conn.stmt.executeQuery(sql); 
			w2User user = null;
			int i=1;
			while(rs.next())
			{ 
				if((i>=start)&&(i<start+size))
				{user=new w2User();
				user.setUserid(rs.getInt("userid"));
				user.setEmpname(rs.getString("empname"));
				user.setDepartment(rs.getString("department"));
				user.setDuty(rs.getString("duty"));
				user.setSchoolage(rs.getString("schoolage"));
				user.setJobcontent(rs.getString("jobcontent"));
				user.setRemark2(rs.getString("remark2"));
				user.setImpachieve(rs.getString("impachieve"));
				user.setTeachexp(rs.getString("teachexp"));
				user.setTrainexp(rs.getString("trainexp"));
				user.setWorkexp(rs.getString("workexp"));
					
				showlist.add(user);
				}
				i=i+1;
			}
			return showlist;
		}
		catch (SQLException SqlE) {
			SqlE.printStackTrace();
			return null;
		} 
		catch (Exception E) {
			E.printStackTrace();
			return null;
		} 
		finally {
			// 关闭连接，释放数据库资源：
			db_conn.CloseDB();
		}		
	}
}