membermanagebean.java

来自「就业管理系统 源代码 可以运行 没有错误」· Java 代码 · 共 543 行 · 第 1/2 页

        				list2.add(rs.getString("ifuse"));
        				list2.add(rs.getString("logintimes"));
        				list2.add(rs.getString("lasttime"));
        				list2.add(rs.getString("lastip"));
        				list2.add(rs.getString("type"));
        				list.add(list2);
                    } else {
                        break; //减少空循环的时间
                    }
                }
                return list;
            } catch (SQLException ex) {
                ex.printStackTrace();
                return null;
            } finally {
                dbo.close();
            }
        }
   
    /**********************************************************************
     * 删除 冻结会员
     * @param id
     * @return
     *********************************************************************/
    //  删除会员
	public int delMember(int id[]){
		DBO dbo=new DBO();
		dbo.open();
		try{
			for(int i = 0;i<id.length;i++){
				dbo.executeUpdate("delete from  fz_member where  id = '"+id[i]+"'");	
				dbo.executeUpdate("delete from  fz_pmember where  mid = '"+id[i]+"'");
				dbo.executeUpdate("delete from  fz_cmember where  mid = '"+id[i]+"'");
			}
			return Constant.SUCCESS;
		}catch(Exception e){
			e.printStackTrace();
			return Constant.SYSTEM_ERROR;
		}finally{
			dbo.close();
		}
	}
	//冻结会员
	public int closeMember(int id){
		String sql = "select ifuse from fz_member where id='"+id+"' ";
		String sql2 = "update fz_member set ifuse='0' where id='"+id+"'";
		String sql3 = "update fz_member set ifuse='1' where id='"+id+"'";
		DBO dbo=new DBO();
		dbo.open();
		try{
			rs = dbo.executeQuery(sql);
			if(rs.next()){
				int ifuse=rs.getInt(1);
				if(ifuse == 1){
					int j = dbo.executeUpdate(sql2);
					if(j == 1)
						return Constant.SUCCESS;
					else
						return Constant.SYSTEM_ERROR;
				}
				else{
					int j = dbo.executeUpdate(sql3);
					if(j == 1)
						return Constant.SUCCESS;
					else
						return Constant.SYSTEM_ERROR;
				}
			}
			else{
				return Constant.SYSTEM_ERROR;
			}
		}catch(Exception e){
			e.printStackTrace();
			return Constant.SYSTEM_ERROR;
		}finally{
			dbo.close();
		}
	}
	/**********************************************************************
     * 后台查询单条个人 企业会员信息 查询会员类型
     * @param id
     * @return
     *********************************************************************/
    //以id为条件查询会员类型
    public String getType(int id){
    	String sql = "select type from fz_member where id='"+id+"'";
    	DBO dbo=new DBO();
    	dbo.open();
		try{
			rs = dbo.executeQuery(sql);
			if(rs.next()){
				String type = rs.getString(1);
				return type;
			}
			else
				return null;
		}catch(Exception e){
			e.printStackTrace();
			return null;
		}finally{
			dbo.close();
		}
    }
    //以id为条件 单条会员登陆信息
    public List getMemberLogin(int id){
		String sql = "select * from fz_member where id='"+id+"'";
		DBO dbo=new DBO();
		list = new ArrayList();
		dbo.open();
		try{
			rs = dbo.executeQuery(sql);
			rs.next();
			list.add(rs.getString("username"));
			list.add(rs.getString("type"));
			list.add(rs.getString("regtime"));
			list.add(rs.getString("ifuse"));
			list.add(rs.getString("logintimes"));
			list.add(rs.getString("lasttime"));
			list.add(rs.getString("lastip"));
			return list;
		}catch(Exception e){
			e.printStackTrace();
			return list;
		}finally{
			dbo.close();
		}
	}
	//以id为条件 单条个人会员信息
	public List getPerSonMember(int id){
		String sql = "select * from fz_pmember where mid='"+id+"'";
		DBO dbo=new DBO();
		list = new ArrayList();
		dbo.open();
		try{
			rs = dbo.executeQuery(sql);
			rs.next();
			list.add(rs.getString("realname"));
			list.add(rs.getString("sex"));
			list.add(rs.getString("bir"));
			list.add(rs.getString("sheng"));
			list.add(rs.getString("city"));
			list.add(rs.getString("telphone"));
			list.add(rs.getString("email"));
			list.add(rs.getString("question"));
			list.add(rs.getString("answer"));
			return list;
		}catch(Exception e){
			e.printStackTrace();
			return list;
		}finally{
			dbo.close();
		}
	}
//	以id为条件 单条企业会员信息
	public List getCoMember(int id){
		String sql = "select * from fz_cmember where mid='"+id+"'";
		DBO dbo=new DBO();
		list = new ArrayList();
		dbo.open();
		try{
			rs = dbo.executeQuery(sql);
			rs.next();
			list.add(rs.getString("coname"));
			list.add(rs.getString("address"));
			list.add(rs.getString("postnum"));
			list.add(rs.getString("tel"));
			list.add(rs.getString("email"));
			list.add(rs.getString("question"));
			list.add(rs.getString("answer"));
			list.add(rs.getString("intro"));
			return list;
		}catch(Exception e){
			e.printStackTrace();
			return list;
		}finally{
			dbo.close();
		}
	}
	//////////////以用户名为条件查询///////////////
//	以用户名为条件查询会员类型
    public String getType(String name){
    	String sql = "select type from fz_member where username='"+name+"'";
    	DBO dbo=new DBO();
    	dbo.open();
		try{
			rs = dbo.executeQuery(sql);
			if(rs.next()){
				String type = rs.getString(1);
				return type;
			}
			else
				return null;
		}catch(Exception e){
			e.printStackTrace();
			return null;
		}finally{
			dbo.close();
		}
    }
    //以用户名为条件查询用户id，然后用id来查询会员信息 跳转到//以id为条件查询会员类型
    public int getID(String name){
    	String sql = "select id from fz_member where username='"+name+"'";
    	DBO dbo=new DBO();
    	dbo.open();
		try{
			rs = dbo.executeQuery(sql);
			if(rs.next()){
				int id = rs.getInt(1);
				return id;
			}
			else
				return 0;
		}catch(Exception e){
			e.printStackTrace();
			return 0;
		}finally{
			dbo.close();
		}
    }
//////////////以用户名 id为条件查询///////////////
//	以用户名 id为条件查询会员类型，然后用id来查询会员信息 跳转到//以id为条件查询会员
    public String getType(int id,String name){
    	String sql = "select type from fz_member where id='"+id+"' and username='"+name+"'";
    	DBO dbo=new DBO();
    	dbo.open();
		try{
			rs = dbo.executeQuery(sql);
			if(rs.next()){
				String type = rs.getString(1);
				return type;
			}
			else
				return null;
		}catch(Exception e){
			e.printStackTrace();
			return null;
		}finally{
			dbo.close();
		}
    }
    
	/////////////////////按注册时间查询/////////////////////
    public List getMemberByTime(String stime,String etime){
    	String sql = "select * from fz_member where regtime between '"+stime+"' and '"+etime+" 23:59:59' ";
    	DBO dbo=new DBO();
		list = new ArrayList();
		dbo.open();
		try{
			rs = dbo.executeQuery(sql);
			while(rs.next()){
				List list2=new ArrayList();
                list2.add(rs.getInt("id"));
 				list2.add(rs.getString("username"));
 				list2.add(rs.getString("regtime"));
 				list2.add(rs.getString("ifuse"));
 				list2.add(rs.getString("logintimes"));
 				list2.add(rs.getString("lasttime"));
 				list2.add(rs.getString("lastip"));
 				list2.add(rs.getString("type"));
 				list.add(list2);
			}
			return list;
		}catch(Exception e){
			e.printStackTrace();
			return list;
		}finally{
			dbo.close();
		}
    }
}