lcz_usermgr.java

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

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

import userbean.Lcz_User;

public class Lcz_UserMgr {

	DBConMgr db_conn=new DBConMgr();
	
	 public Collection search(String sqlCondition)
		{ System.out.println(sqlCondition);
			db_conn.ConnectDB();
			Collection showlist=new ArrayList();
			ResultSet rs = null;
			try{
				String sql="select * from department where"+sqlCondition;
				rs = db_conn.stmt.executeQuery(sql); 
				Lcz_User user = null;
				while(rs.next())
				{
					user=new Lcz_User();
					user.setDid(rs.getInt("did"));
					user.setDname(rs.getString("dname"));
					user.setDmanager(rs.getString("dmanager"));
					user.setSubjection(rs.getString("subjection"));
					user.setDsize(rs.getInt("dsize"));
					user.setDphone(rs.getString("dphone"));
					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 department  order by did asc";
				rs = db_conn.stmt.executeQuery(sql); 
				Lcz_User user = null;
				System.out.println("11111111");
				while(rs.next())
				{
					user=new Lcz_User();
					user.setDid(rs.getInt("did"));
					user.setDname(rs.getString("dname"));
					user.setDmanager(rs.getString("dmanager"));
					user.setSubjection(rs.getString("subjection"));
					user.setDsize(rs.getInt("dsize"));
					user.setDphone(rs.getString("dphone"));
					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(Lcz_User user)
		{ 
			db_conn.ConnectDB();
			try {
				String sql = "insert into department(did,dname,"+
				"dmanager,subjection,dsize,dphone)"+
				    " values("+user.getDid()+",'" + 
				    user.getDname()+ "','" +
				    user.getDmanager()+"','"+
				    user.getSubjection()+"',"+
				    user.getDsize()+",'"+
				    user.getDphone()+"')";
				//System.out.println(sql);
			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(Lcz_User user)
		{
			db_conn.ConnectDB();
			try {
				String sql = "update department set dname='"+
				user.getDname()+"',dmanager='"+
				user.getDmanager()+"',subjection='"+
				user.getSubjection()+"',dsize="+
				user.getDsize()+",dphone='"+
				user.getDphone()+"' where did="+
				user.getDid();
				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 did)
		{
			db_conn.ConnectDB();
			try {
				String sql="delete from department where did="+did+"";
				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 department  order by did asc";
				rs = db_conn.stmt.executeQuery(sql); 
				Lcz_User user = null;
				int i=1;
				while(rs.next())
				{ 
					if((i>=start)&&(i<start+size))
					{user=new Lcz_User();
					user.setDid(rs.getInt("did"));
					user.setDname(rs.getString("dname"));
					user.setDmanager(rs.getString("dmanager"));
					user.setSubjection(rs.getString("subjection"));
					user.setDsize(rs.getInt("dsize"));
					user.setDphone(rs.getString("dphone"));
					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();
			}		
		}
}