user.java

淘客在线客服管理系统（TaokeOCS V3.2）

package msg;
import msg.*;
import java.io.*;
import java.util.*;
import java.lang.*;
import java.sql.*;
public class User{
	String id,type,name,tag,visit,talker,domainId,sex,workphone,mobilephone,shihuatong,address,companyName,
	email,qq,msn,lastIp,startTime,state,fromUrl,lastTime,voiphide,mbhide,voipenabled,mbenabled,onlineMsg,offlineMsg,leftMsg;  
	public User(String vid){
		String sql="";
		ResultSet rs=null;
   		DbConn db=null;
		try{
			db=new msg.DbConn();
			sql="select * from user where id=\'"+vid+"\'";
			if(db.getConnection()==null || db.isClosed())			 
				db.setConnection();  
			db.setSqlQuery(sql);
			rs=db.getResult();
			String type=null;
			String domainId="";
			if(rs!=null && rs.next()){  
				this.id=rs.getString("id");
				this.type=rs.getString("type");
				this.address=rs.getString("address");
				this.name=rs.getString("name");
				this.state=rs.getString("state");
				this.tag=rs.getString("tag");
				this.visit=rs.getString("visit");
				this.talker=rs.getString("talker");
				this.domainId=rs.getString("domainId");
				this.sex=rs.getString("sex");
				this.workphone=rs.getString("workphone");
				this.mobilephone=rs.getString("mobilephone");
				this.shihuatong=rs.getString("sht");
				this.email=rs.getString("email");
				this.qq=rs.getString("qq");
				this.msn=rs.getString("msn");
				this.lastIp=rs.getString("lastIp");
				this.startTime=rs.getString("startTime");
				this.fromUrl=rs.getString("fromUrl");
				this.lastTime=rs.getString("lastTime");
				this.voiphide=rs.getString("voiphide");
				this.mbhide=rs.getString("mbhide");
				this.voipenabled=rs.getString("voipenabled");
				this.mbenabled=rs.getString("mbenabled");
				domainId=rs.getString("domainId");
			}
			sql="select companyName from site where domainIds=\""+domainId+"\" and parentId=0";
			if(db.getConnection()==null || db.isClosed())			 
				db.setConnection();  
			db.setSqlQuery(sql);
			rs=db.getResult();
			if(rs!=null && rs.next()){  
				this.companyName=rs.getString("companyName");
			}
			sql="select * from answermessage where id=\'"+vid+"\'";
			if(db.getConnection()==null || db.isClosed())			 
				db.setConnection();  
			db.setSqlQuery(sql);
			rs=db.getResult();
			if(rs!=null && rs.next()){  
				this.onlineMsg=rs.getString("onlineMsg");
				this.offlineMsg=rs.getString("offlineMsg");
				this.leftMsg=rs.getString("leftMsg");
			}
			if(db.getConnection()!=null && !db.isClosed())
				db.closeConnection();	
		}catch(Exception e){}
	}
	public User(String id,String type,String name,String state,String tag,String visit,String talker,
				String domainId,String sex,String workphone,String mobilephone,String shihuatong,
				String email,String qq,String msn,String lastIp,String startTime,String fromUrl,
				String lastTime,String voiphide,String mbhide,String voipenabled,String mbenabled){
		this.id=id;
		this.type=type;
		this.name=name;
		this.state=state;
		this.tag=tag;
		this.visit=visit;
		this.talker=talker;
		this.domainId=domainId;
		this.sex=sex;
		this.workphone=workphone;
		this.mobilephone=mobilephone;
		this.shihuatong=shihuatong;
		this.email=email;
		this.qq=qq;
		this.msn=msn;
		this.lastIp=lastIp;
		this.startTime=startTime;
		this.fromUrl=fromUrl;
		this.lastTime=lastTime;
		this.voiphide=voiphide;
		this.mbhide=mbhide;
		this.voipenabled=voipenabled;
		this.mbenabled=mbenabled;
 	} 
	public String getType(){return type;}
	public String getName(){return name;}
	public String getAddress(){return address;}
	public String getCompanyName(){return companyName;}
	public String getTag(){return tag;}
	public String getVisit(){return visit;}
	public String getTalker(){return talker;}
	public String getDomainId(){return domainId;}
	public String getSex(){return sex;}
	public String getWorkphone(){return workphone;}
	public String getMobilephone(){return mobilephone;}
	public String getShihuatong(){return shihuatong;}
	public String getEmail(){return email;}
	public String getQq(){return qq;}
	public String getMsn(){return msn;}
	public String getLastIp(){return lastIp;}
	public String getStartTime(){return startTime;}
	public String getState(){return state;}
	public String getFromUrl(){return fromUrl;}
	public String getLastTime(){return lastTime;}
	public String getVoiphide(){return voiphide;}
	public String getMbhide(){return mbhide;}
	public String getVoipenabled(){return voipenabled;}
	public String getMbenabled(){return mbenabled;}
	public String getOnlineMsg(){return onlineMsg;}
	public String getOfflineMsg(){return offlineMsg;}
	public String getLeftMsg(){return leftMsg;}
}