euser.java

图书

package thizlinux.linuxhr;

import java.sql.*;
import java.text.*;
import java.util.*;

public class euser {
	public boolean status=true;
	private String sql;

	public Collection geteuser(String enabled){
		DBconnect dbconn =new DBconnect();
		ResultSet rs=null;
		Collection ret=null;
		try{
			sql="select a.id,a.name,a.industry,a.type,a.scale,a.homepage from tbl_euserinfo a,tbl_user b where b.usertype='1' and a.id=b.uid and b.enabled='"+enabled+"'";
			rs=dbconn.executeQuery(sql);
			ret=new ArrayList();
			while(rs.next()){
				euserinfo user= new euserinfo();
				user.id=pub.datachange(rs.getString("id"));
				user.name=pub.datachange(rs.getString("name"));	
				user.industry=pub.datachange(rs.getString("industry"));
				user.type=pub.datachange(rs.getString("type"));
				user.scale=pub.datachange(rs.getString("scale"));
				user.homepage=pub.datachange(rs.getString("homepage"));
				ret.add(user);
			}
		}
		catch(Exception e){
			System.out.println(e+",sql="+sql);
		}
		finally{
			try{
				if(rs!=null)rs.close();
				if(dbconn!=null)dbconn.close();
			}
			catch(Exception e){
				System.out.println(e);
			}
		}		
		return ret;
	}

	public euserinfo geteuserinfo(String id)
        {
		DBconnect dbconn =new DBconnect();
		euserinfo user= new euserinfo();
		ResultSet rst=null;
		try{
			sql="select * from tbl_euserinfo where id='"+id+"'";
	             rst=dbconn.executeQuery(sql);
	
	             if(rst.next())
	                {
				user.setName(pub.datachange(rst.getString("name"))) ;
				user.setIndustry(pub.datachange(rst.getString("industry"))); 
				user.setScale(pub.datachange(rst.getString("scale"))) ;
				user.setLocation(pub.datachange(rst.getString("location"))) ;
				user.setFdate(pub.datachange(rst.getString("fdate"))) ;
				user.setType(pub.datachange(rst.getString("type"))) ;
				user.setContact(pub.datachange(rst.getString("contact"))) ;
				user.setPosition(pub.datachange(rst.getString("position"))) ;
				user.setWorktel(pub.datachange(rst.getString("worktel"))) ;
				user.setMobile(pub.datachange(rst.getString("mobile"))) ;
				user.setEmail(pub.datachange(rst.getString("email"))) ;
				user.setFax(pub.datachange(rst.getString("fax"))) ;
				user.setAddress(pub.datachange(rst.getString("address"))) ;
				user.setPostcode(pub.datachange(rst.getString("postcode"))) ;
				user.setHomepage(pub.datachange(rst.getString("homepage"))) ;
				user.setIntroduction(pub.datachange(rst.getString("introduction"))) ;
	                }
		}catch(Exception e){
			System.out.println(e+",sql="+sql);
		}finally{
                   try{
				if(rst!=null)rst.close();
				if(dbconn!=null)dbconn.close();
			}catch(Exception e){
				System.out.println(e);
			}
                }
             return user;
        }
	
	public boolean update(String id){
		status=true;
		DBconnect dbconn =new DBconnect();
		try{
			sql = "update tbl_user set enabled='1' where uid='"+id+"'";
			dbconn.executeUpdate(sql);
		}
		catch(Exception e){
			System.out.println(e+",sql="+sql);
			status=false;
		}
		finally{
			try{
				if(dbconn!=null)dbconn.close();
			}
			catch(Exception e){
				System.out.println(e);
			}
		}
		return  status;
	}
	public boolean remove(String id){
		status=true;
		DBconnect dbconn =new DBconnect();
		try{
			sql = "delete from tbl_user where uid='"+id+"'";
			dbconn.executeUpdate(sql);
			sql = "delete from tbl_euserinfo where id='"+id+"'";
			dbconn.executeUpdate(sql);
		}
		catch(Exception e){
			System.out.println(e+",sql="+sql);
			status=false;
		}
		finally{
			try{
				if(dbconn!=null)dbconn.close();
			}
			catch(Exception e){
				System.out.println(e);
			}
		}
		return  status;
	}
}