cusermgr.java

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

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

public class CuserMgr {
	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 moolu3 where tname='"+tname+"'";
		String sql="select * from chengji where pxid=" +name+ "";
		rs = db_conn.stmt.executeQuery(sql); 
		System.out.println(sql);
		Cuser user = null;
			while(rs.next())
			{
				user=new Cuser();
				user.setPxid(rs.getInt("pxid"));
				user.setXyname(rs.getString("xyname"));
				user.setCxypx(rs.getInt("cxypx"));
				user.setWysj(rs.getInt("wysj"));
				user.setCad(rs.getInt("cad"));
				user.setEnglish(rs.getInt("english"));
				user.setCjj(rs.getInt("cjj"));
				user.setRuanshe(rs.getInt("ruanshe"));
				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 chengji  order by pxid asc";
			System.out.println(sql);
			rs = db_conn.stmt.executeQuery(sql); 
			Cuser user = null;
			while(rs.next())
			{
				user=new Cuser();
				user.setPxid(rs.getInt("pxid"));
				user.setXyname(rs.getString("xyname"));
				user.setCxypx(rs.getInt("cxypx"));
				user.setWysj(rs.getInt("wysj"));
				user.setCad(rs.getInt("cad"));
				user.setEnglish(rs.getInt("english"));
				user.setCjj(rs.getInt("cjj"));
				user.setRuanshe(rs.getInt("ruanshe"));
				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(Cuser user)
	{
		db_conn.ConnectDB();
		try {
			String sql = "insert into chengji (pxid,xyname,cxypx,wysj,cad,english,cjj,ruanshe)"+
			    "values("+user.getPxid()+",'" + user.getXyname()+ "'," + user.getCxypx()+
				 "," + user.getWysj()+"," + user.getCad()+"," + user.getEnglish()+
				 "," + user.getCjj()+"," + user.getRuanshe()+")";
		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(Cuser user)
	{
		db_conn.ConnectDB();
		try {
			String sql = "update chengji set xyname='"+user.getXyname()+"',cxypx="+
			user.getCxypx()+",wysj="+user.getWysj()+",cad="+user.getCad()+",english="+
			user.getEnglish()+",cjj="+user.getCjj()+",ruanshe="+
			user.getRuanshe()+" where pxid="+
			user.getPxid();
			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 id)
	{
		db_conn.ConnectDB();
		try {
			String sql="delete from chengji where 1=1"+id+"";
			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 chengji order by pxid asc";
			rs = db_conn.stmt.executeQuery(sql); 
			Cuser user = null;
			int i=1;
			while(rs.next())
			{ 
				if((i>=start)&&(i<start+size))
				{user=new Cuser();
				user.setPxid(rs.getInt("pxid"));
				user.setXyname(rs.getString("xyname"));
				user.setCxypx(rs.getInt("cxypx"));
				user.setWysj(rs.getInt("wysj"));
				user.setCad(rs.getInt("cad"));
				user.setEnglish(rs.getInt("english"));
				user.setCjj(rs.getInt("cjj"));
				user.setRuanshe(rs.getInt("ruanshe"));
				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();
		}		
	}
}