sitemanager.java

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

/*
 * 站点管理
 *获取站点信息 建立新站点 修改站点属性 删除站点
 */
package msg;
import msg.*;
import java.io.*;
import java.util.*;
import java.lang.*;
import java.sql.*;
import java.text.SimpleDateFormat;
public class SiteManager{
	String sql="";
	ResultSet rs=null;
    DbConn db=null;
	/*
	 *Constructor
	 */
	public SiteManager(){
		try{
			db=new msg.DbConn();
		}catch(Exception e){}
	}
	/*
	 *根据站点的url获取一个站点
	 *@param url站点的url
	 */  
	public Site getSite(String url){	
		Site site=null;
		try{
			sql="select * from site where url=\""+url+"\"";
			if(db.getConnection()==null || db.isClosed())			 
				db.setConnection();  
			db.setSqlQuery(sql);
			rs=db.getResult();
			if(rs!=null && rs.next()) 
			 	site=new Site(rs.getString("domainId"),rs.getString("url"),rs.getString("name"),rs.getString("contactName"),
					          rs.getString("tel"),rs.getString("email"),rs.getString("start"),rs.getString("end"));		 
			if(db.getConnection()!=null && !db.isClosed())
				db.closeConnection();	 		 
		}catch(Exception e){
			closeDbConnection();
			Log.log("class:SiteManager method:getSite():"+e.getMessage()+" sql:"+sql);
		}	
		return site;
	}
	/**
	  *更新一个站点
	  *@param site
	  */	 
	public boolean updateSite(Site site){	
		if(site==null)
			return false;
		/**
		try{
			if(db.getConnection()==null || db.isClosed())			 
				db.setConnection(); 
 			sql="update site set "; 		
			db.setSqlQuery(sql);	
			db.executeUpdate();	
		 	
			if(db.getConnection()!=null && !db.isClosed())
				db.closeConnection();	
		}catch(Exception e){Log.log("updateSite():"+e.getMessage());return false;}
		**/
		return true;
	}
	
	/**
	  *添加一个站点 被注册调用
	  *@param site
	  */	
	public boolean addSite(Site site){	
		try{
			sql="select * from site where domain=\""+site.getUrl()+"\"";
			if(db.getConnection()==null || db.isClosed())			 
				db.setConnection();  		 		
			db.setSqlQuery(sql);
			rs=db.getResult();
			if(rs!=null && rs.next()){ 
				if(db.getConnection()!=null && !db.isClosed())
					db.closeConnection();	
				return false;
			}	
			String payLevelStr=String.valueOf( site.getPayLevel() ); //-1,0,1,2
			sql="insert into site values(null,\""+site.getUrl()+"\",\""+site.getName()+"\",\""+site.getContactName()+
			"\",\""+site.geTel()+"\",\""+site.getEmail()+"\",\""+site.getStart()+"\",\""+site.getEnd()+"\",\"1000\",\"floatAdminLeft\",\""+payLevelStr+"\",\"false\",\"1\",\"\",\"\",\"\",\"\",\"0\",\"30\",\"\",\"\",\"\",\"50\")";
			if(db.getConnection()==null || db.isClosed())			 
				db.setConnection();  		 		
			db.setSqlQuery(sql);	
			db.executeUpdate();	
			sql="update site set domainIds=domainId where domainIds=\"\""; //给domainIds赋值
			if(db.getConnection()==null || db.isClosed())			 
				db.setConnection();  		 		
			db.setSqlQuery(sql);	
			db.executeUpdate();		 	
			if(db.getConnection()!=null && !db.isClosed())
				db.closeConnection();	
		}catch(Exception e){
			closeDbConnection();
			Log.log("class:SiteManager method: addSite():"+e.getMessage()+" sql:"+sql);
			return false;
		} 
		return true;
	}

	 		
	/**
	  *添加一个站点: 为没有注册但添加了代码的网站用,只能注册带www的站点
	  * 
	  *@param domain
	  */	 
	public Site addSite(String domain){	
		try{
			//if(domain.indexOf("www.")<0)
			//	return null;
			sql="select * from site where domain=\""+domain+"\"";
			if(db.getConnection()==null || db.isClosed())			 
				db.setConnection();  		 		
			db.setSqlQuery(sql);
			rs=db.getResult();
			if(rs!=null && rs.next()){ 
				if(db.getConnection()!=null && !db.isClosed())
					db.closeConnection();	
				return null;
			}	
			Calendar start = Calendar.getInstance();
			Calendar end = Calendar.getInstance();
			SimpleDateFormat formatter1 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
			String a = formatter1.format(start.getTime());
	
			//结束时间加一年
			java.util.Date date1 = formatter1.parse(a);
			long Time=(date1.getTime()/1000)+60*60*24*365;
			date1.setTime(Time*1000);
			String b=formatter1.format(date1);
			String payLevelStr="0"; //-1.0,1,2
 			sql="insert into site values(null,\""+domain+"\",\"\",\""+
				"\",\"\",\"\",\""+a+"\",\""+b+"\",\"1000\",\"floatAdminLeft\",\""+payLevelStr+"\",\"false\",\"2\",\"\",\"\",\"\",\"\",\"0\",\"30\",\"\",\"\",\"\",\"\")";
			if(db.getConnection()==null || db.isClosed())			 
				db.setConnection();  		 		
			db.setSqlQuery(sql);	
			db.executeUpdate();			
			sql="update site set domainIds=domainId where domainIds=\"\""; //给domainIds赋值
			if(db.getConnection()==null || db.isClosed())			 
				db.setConnection();  		 		
			db.setSqlQuery(sql);	
			db.executeUpdate();	
			Site site=new Site();
			site.setFloatImgType("floatAdminLeft");
			site.setGuokeType("1");				
			site.setLinkContent("");
			site.setGkTopAdvert(null);
			site.setPayLevel(1);	
			site.setGkAdvert(null);
			site.setInviteTime("30");
			site.setInviteCont("");
			if(db.getConnection()!=null && !db.isClosed())
				db.closeConnection();	
			return site;
		}catch(Exception e){
			closeDbConnection();
			Log.log("class:SiteManager method: addSite():"+e.getMessage()+" sql:"+sql);
			return null;
		} 
 	}	
	/**
	  *添加一个站点,(addMoreDomain.jsp)用来添加第二个域名
	  *@param site
	  */	 
	public boolean addSite(Site site,String parentId,String credit){	
		try{
			sql="select * from site where domain=\""+site.getUrl()+"\"";
			if(db.getConnection()==null || db.isClosed())			 
				db.setConnection();  		 		
			db.setSqlQuery(sql);
			rs=db.getResult();
			if(rs!=null && rs.next()){ 
				if(db.getConnection()!=null && !db.isClosed())
					db.closeConnection();	
				return false;
			}	
			String payLevelStr=String.valueOf( site.getPayLevel() ); //-1.0,1,2
			sql="insert into site values(null,\""+site.getUrl()+"\",\""+site.getName()+"\",\""+site.getContactName()+
				"\",\""+site.geTel()+"\",\""+site.getEmail()+"\",\""+site.getStart()+"\",\""+site.getEnd()+"\",\""+credit+"\",\"floatAdminLeft\",\""+payLevelStr+"\",\"false\",\"1\",\"\",\"\",\"\",\"\",\""+parentId+"\",\"30\",\"\",\"\",\"\",\"\")";
			if(db.getConnection()==null || db.isClosed())			 
				db.setConnection();  		 		
			db.setSqlQuery(sql);	
			db.executeUpdate();			 	
			if(db.getConnection()!=null && !db.isClosed())
				db.closeConnection();	
		}catch(Exception e){
			closeDbConnection();
			Log.log("class:SiteManager method: addSite():"+e.getMessage()+" sql:"+sql);
			return false;
		} 
		return true;
	}
	/**
	  *删除一个站点
	  *@param site
	  */	 
	public boolean deleteSite(Site site){	
		 return true;
	}	
	private void closeDbConnection(){
		try{
			if(db.getConnection()!=null && !db.isClosed())
				db.closeConnection();			
		}catch(Exception e){}
	
	}		 
}