w1usermgr.java

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

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

import userbean.w1User;

public class w1UserMgr {
	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 bain where userid like '%"+name+"%'";
			rs = db_conn.stmt.executeQuery(sql); 
			w1User w1User = null;
			while(rs.next())
			{
				w1User=new w1User();
				w1User.setUserid(rs.getInt("userid"));
				w1User.setEmpname(rs.getString("empname"));
				w1User.setDepartment(rs.getString("department"));
				w1User.setDuty(rs.getString("duty"));
				w1User.setSchoolage(rs.getString("schoolage"));
				w1User.setSex(rs.getString("sex"));
				w1User.setNation(rs.getString("nation"));
				w1User.setDegree(rs.getString("degree"));
				w1User.setMarriage(rs.getString("marriage"));
				w1User.setIncumbency(rs.getString("incumbency"));
				w1User.setSpeciality(rs.getString("speciality"));
				w1User.setGratime(rs.getString("gratime"));
				w1User.setGraschool(rs.getString("graschool"));
				w1User.setIdcard(rs.getString("idcard"));
				w1User.setNatinveplace(rs.getString("natinveplace"));
				w1User.setMobile(rs.getInt("mobile"));
				w1User.setHometel(rs.getInt("hometel"));
				w1User.setEmptime(rs.getString("emptime"));
				w1User.setEmpplace(rs.getString("empplace"));
				w1User.setPayaccount(rs.getInt("payaccount"));
				w1User.setHomeaddress(rs.getString("homeaddress"));
				w1User.setRemark(rs.getString("remark"));
				
				showlist.add(w1User);
			}
			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 bain  order by userid asc";
			rs = db_conn.stmt.executeQuery(sql); 
			w1User w1User = null;
			while(rs.next())
			{
				w1User=new w1User();
			
			    w1User.setUserid(rs.getInt("userid"));
				w1User.setEmpname(rs.getString("empname"));
				w1User.setDepartment(rs.getString("department"));
				w1User.setDuty(rs.getString("duty"));
				w1User.setSchoolage(rs.getString("schoolage"));
				w1User.setSex(rs.getString("sex"));
				w1User.setNation(rs.getString("nation"));
				w1User.setDegree(rs.getString("degree"));
				w1User.setMarriage(rs.getString("marriage"));
				w1User.setIncumbency(rs.getString("incumbency"));
				w1User.setSpeciality(rs.getString("speciality"));
				w1User.setGratime(rs.getString("gratime"));
				w1User.setGraschool(rs.getString("graschool"));
				w1User.setIdcard(rs.getString("idcard"));
				w1User.setNatinveplace(rs.getString("natinveplace"));
				w1User.setMobile(rs.getInt("mobile"));
				w1User.setHometel(rs.getInt("hometel"));
				w1User.setEmptime(rs.getString("emptime"));
				w1User.setEmpplace(rs.getString("empplace"));
				w1User.setPayaccount(rs.getInt("payaccount"));
				w1User.setHomeaddress(rs.getString("homeaddress"));
				w1User.setRemark(rs.getString("remark"));
				showlist.add(w1User);
			}
			return showlist;
		}
		catch (SQLException SqlE) {
			SqlE.printStackTrace();
			return null;
		} 
		catch (Exception E) {
			E.printStackTrace();
			return null;
		} 
		finally {
			// 关闭连接，释放数据库资源：
			db_conn.CloseDB();
		}
	}
 
 public int add(w1User w1User)
	{
		db_conn.ConnectDB();
		try {
			String sql = "insert into bain(userid,empname,department," +
					"duty,schoolage,sex,remark,nation,degree,marriage," +
					"incumbency,speciality,gratime,graschool,idcard," +
					"natinveplace,mobile,hometel,emptime,empplace," +
					"payaccount,homeaddress)"+
			    "values("+w1User.getUserid()+",'" + w1User.getEmpname()+ 
				 "','" + w1User.getDepartment()+"','" + w1User.getDuty()+
				 "','" + w1User.getSchoolage()+"','" + w1User.getSex()+
				 "','" + w1User.getRemark()+"','" + w1User.getNation()+
				 "','" + w1User.getDegree()+"','" + w1User.getMarriage()+
				 "','" + w1User.getIncumbency()+"','" + w1User.getSpeciality()+
				 "','" + w1User.getGratime()+"','" + w1User.getGraschool()+
				 "','" + w1User.getIdcard()+"','" + w1User.getNatinveplace()+
				 "'," + w1User.getMobile()+"," + w1User.getHometel()+
				 ",'" + w1User.getEmptime()+"','" + w1User.getEmpplace()+
				 "'," + w1User.getPayaccount()+",'" + w1User.getHomeaddress()+"')";
		int i = db_conn.stmt.executeUpdate(sql); // 执行sql语句
		System.out.println("434434");
		return i;
	
		
	}
		catch (SQLException SqlE){
			SqlE.printStackTrace();
			return -1;
		} 
		catch (Exception E) {
			E.printStackTrace();
			return -2;
		} 
		finally {
			// 关闭连接，释放数据库资源：
			db_conn.CloseDB();
		}
	}
	
	public int chang(w1User w1User)
	{
		db_conn.ConnectDB();
		try {
			String sql = "update bain set empname='"+
			w1User.getEmpname()+"',department='"+
			w1User.getDepartment()+"',duty='"+
			w1User.getDuty()+"',schoolage='"+
			w1User.getSchoolage()+"',sex='"+
			w1User.getSex()+"',remark='"+
			w1User.getRemark()+"',nation='"+
			w1User.getNation()+"',degree='"+
			w1User.getDegree()+"',marriage='"+
			w1User.getMarriage()+"',incumbency='"+
			w1User.getIncumbency()+"',speciality='"+
			w1User.getSpeciality()+"',gratime='"+
			w1User.getGratime()+"',graschool='"+
			w1User.getGraschool()+"',idcard='"+
			w1User.getIdcard()+"',natinveplace='"+
			w1User.getNatinveplace()+"',mobile="+
			w1User.getMobile()+",hometel="+
			w1User.getHometel()+",emptime='"+
			w1User.getEmptime()+"',empplace='"+
			w1User.getEmpplace()+"',payaccount="+
			w1User.getPayaccount()+",homeaddress='"+
			w1User.getHomeaddress()+"' where userid="+
			w1User.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 bain 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 bain  order by userid asc";
			rs = db_conn.stmt.executeQuery(sql); 
			w1User w1User = null;
			int i=1;
			while(rs.next())
			{ 
				if((i>=start)&&(i<start+size))
				{w1User=new w1User();
				w1User.setUserid(rs.getInt("userid"));
				w1User.setEmpname(rs.getString("empname"));
				w1User.setDepartment(rs.getString("department"));
				w1User.setDuty(rs.getString("duty"));
				w1User.setSchoolage(rs.getString("schoolage"));
				w1User.setSex(rs.getString("sex"));
				w1User.setNation(rs.getString("nation"));
				w1User.setDegree(rs.getString("degree"));
				w1User.setMarriage(rs.getString("marriage"));
				w1User.setIncumbency(rs.getString("incumbency"));
				w1User.setSpeciality(rs.getString("speciality"));
				w1User.setGratime(rs.getString("gratime"));
				w1User.setGraschool(rs.getString("graschool"));
				w1User.setIdcard(rs.getString("idcard"));
				w1User.setNatinveplace(rs.getString("natinveplace"));
				w1User.setMobile(rs.getInt("mobile"));
				w1User.setHometel(rs.getInt("hometel"));
				w1User.setEmptime(rs.getString("emptime"));
				w1User.setEmpplace(rs.getString("empplace"));
				w1User.setPayaccount(rs.getInt("payaccount"));
				w1User.setHomeaddress(rs.getString("homeaddress"));
				w1User.setRemark(rs.getString("remark"));
					
				showlist.add(w1User);
				}
				i=i+1;
			}
			return showlist;
		}
		catch (SQLException SqlE) {
			SqlE.printStackTrace();
			return null;
		} 
		catch (Exception E) {
			E.printStackTrace();
			return null;
		} 
		finally {
			// 关闭连接，释放数据库资源：
			db_conn.CloseDB();
		}		
	}
}