keyword.java

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

package msg;
import msg.*;
import java.io.*;
import java.util.*;
import java.lang.*;
import java.sql.*;
import java.net.*;
public class Keyword{
	
   
   public Keyword(){}
    static public String getCleanURL(String url)
    {		
		int index=url.indexOf("//");
		if(index>=0) url=url.substring(index+2);
		index=url.indexOf("/");
		if(index>=0) url=url.substring(0,index);		 		
		return url;
    }
	static public String getPage(String url)
    {
		int index=url.indexOf("//");
		if(index>=0) url=url.substring(index+2);
		index=url.indexOf("/");
		if(index>=0) url=url.substring(index);
		index=url.indexOf("?");
		if(index>=0) url=url.substring(0,index);
		return url;
    }
	static public String getPageAndPara(String url)
    {
		int index=url.indexOf("//");
		if(index>=0) url=url.substring(index+2);
		index=url.indexOf("/");
		if(index>=0) url=url.substring(index);
		return url;
    }
	static public String getResult(String refererURL){
		DbConn db=null;
		String sql="";
    		try{			
			ResultSet rs=null;
    		
			db=new msg.DbConn();
			if(refererURL==null || refererURL.equals("")|| refererURL.equals("null")) 
				return "e=\"\" k=\"\" ";
			//refererURL=msg.Escape.escape(refererURL);
			if(refererURL.indexOf("mail")>=0)//是从email来得
			   return "e=\"来自邮件-"+getCleanURL(refererURL)+"\" k=\"\" ";
			 
			String result="";
		 
			try{
				String url=getCleanURL(refererURL);
				int index=url.indexOf(".");
				String shortUrl=url.substring(index+1);
				sql="select * from engine where url=\""+url+"\" or url=\""+shortUrl+"\"";
				 
				if(db.getConnection()==null || db.isClosed())			 
					db.setConnection();  //local
				db.setSqlQuery(sql);
				rs=db.getResult();			 
				if(rs!=null && rs.next()){
					String keywords= getKeywords(refererURL,rs.getString("key"));
					if(keywords!=null && !keywords.equals(""))
						result= "k=\""+URLDecoder.decode(keywords,rs.getString("charset"))+"\" "+
											  "e=\""+rs.getString("name")+"\" ";	
					else
						result=null;
				}
				if(db.getConnection()!=null && !db.isClosed())
					db.closeConnection();	
			}catch(Exception e){
				try{
					if(db!=null && db.getConnection()!=null && !db.isClosed())
						db.closeConnection();			
				}catch(Exception e1){}
				Log.log("class Keyword method getResult error:"+e.getMessage()+" sql:"+sql);
			}	
			if(result!=null && !result.equals("")&& !result.equals("null")) 
				return result;

			return "e=\"来自链接-"+getCleanURL(refererURL)+"\" k=\"\" ";
		}catch(Exception e){}
		return "e=\"\" k=\"\" ";
    }
 
   static private String getKeywords(String url,String keyName){
		String firstKeyName="";
		if(keyName.indexOf(",")>=0)	 
			firstKeyName=keyName.substring(0,keyName.indexOf(","));	
		else
			firstKeyName=keyName;
		if(url.indexOf(firstKeyName+"=") >=0 ){			 
			String keywords=url.substring(url.indexOf(firstKeyName+"=")+firstKeyName.length()+1);	
			int index=keywords.indexOf("&");
			if(index>0)
		   		keywords=keywords.substring(0,index);
			if(keywords!=null && !keywords.equals("") && 
			   keywords.indexOf("?")<0 && keywords.indexOf("/")<0 && keywords.indexOf(":")<0)
		  		return keywords;
		}
		if(keyName.indexOf(",")>0)
		   return getKeywords(url,keyName.substring(keyName.indexOf(",")+1));
		return "";
   }
   	
 }