wzh_usermgr.java

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

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

import userbean.Wzh_User;

public class Wzh_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 rolemanage where"+sqlCondition;
				rs = db_conn.stmt.executeQuery(sql); 
				Wzh_User user = null;
				while(rs.next())
				{
					user=new Wzh_User();
					user.setUserid(rs.getInt("userid"));
					user.setLoadname(rs.getString("loadname"));
					user.setPassword(rs.getString("password"));
					user.setUsername(rs.getString("username"));
					user.setPhone(rs.getString("phone"));
					user.setRole(rs.getString("role"));
					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 rolemanage order by userid asc";
				rs = db_conn.stmt.executeQuery(sql); 
				Wzh_User user = null;
				//System.out.println("11111111");
				while(rs.next())
				{
					user=new Wzh_User();
					user.setUserid(rs.getInt("userid"));
					user.setLoadname(rs.getString("loadname"));
					user.setPassword(rs.getString("password"));
					user.setUsername(rs.getString("username"));
					user.setPhone(rs.getString("phone"));
					user.setRole(rs.getString("role"));
					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(Wzh_User user)
		{ 
			db_conn.ConnectDB();
			try {
				String sql = "insert into rolemanage(userid,loadname,"+
				"password,username,phone,role)"+
				    " values("+user.getUserid()+",'" + 
				    user.getLoadname()+ "','" +
				    user.getPassword()+"','"+
				    user.getUsername()+"','"+
				    user.getPhone()+"','"+
				    user.getRole()+"')";
				System.out.println("11111111");
				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(Wzh_User user)
		{
			db_conn.ConnectDB();
			try {
				String sql = "update rolemanage set username='"+
				user.getUsername()+"',role='"+
				user.getRole()+"',phone='"+
				user.getPhone()+"',password='"+
				user.getPassword()+"',loadname='"+
				user.getLoadname()+"' 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 rolemanage 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 rolemanage order by userid asc";
				rs = db_conn.stmt.executeQuery(sql); 
				Wzh_User user = null;
				int i=1;
				while(rs.next())
				{ 
					if((i>=start)&&(i<start+size))
					{user=new Wzh_User();
					user.setUserid(rs.getInt("userid"));
					user.setLoadname(rs.getString("loadname"));
					user.setPassword(rs.getString("password"));
					user.setUsername(rs.getString("username"));
					user.setPhone(rs.getString("phone"));
					user.setRole(rs.getString("role"));
					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();
			}		
		}
}