ColsDefine.java

package com.alimama.quanjingmonitor.mdrillImport.parse.for416;

import java.text.SimpleDateFormat;
import java.util.Date;

public class ColsDefine {
	 public static SimpleDateFormat formatDay = new SimpleDateFormat("yyyyMMdd");
	 public static SimpleDateFormat formatDayHHMM = new SimpleDateFormat("yyyyMMddHHmm");

	 public static SimpleDateFormat formatMin = new SimpleDateFormat("HHmm");
	 public static SimpleDateFormat formatDayMin = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
	 
	 static long  step=1000l*600;
	 public static String version=formatDayHHMM.format(new Date((System.currentTimeMillis()/step)*step));
	 
	 /**
	  
	  create table rpt_416_online(
	  	thedate string,
	  	miniute_5 string,
	  	source string,
	  	source_tt string,
	  	media_pid string,
	  	channel string,
	  	tid string,
	  	tp1 string,
	  	tp2 string,
	  	pv_2 tlong,
	  	click_1 tlong,
	  	click_2 tlong,
	  	promise_click tlong,
	  	pc_2_wap tlong,
	  	weakup tlong,
	  	backup_1 tlong,
	  	backup_2 tlong,
	  	backup_3 tlong
	  )
	  */
	 
	public static String tablename="rpt_416_online";
	public static String[] colname={
		"thedate"
		,"miniute_5"
		,"source"
		,"source_tt"
		,"media_pid"
		,"channel"
		,"tid"
		,"tp1"
		,"tp2"
};

	public static String[] colSumName={
		"pv_2" //pc or huodong
		,"click_1"
		,"click_2"  //pc or huodong
		,"promise_click"
		,"pc_2_wap"
		,"weakup"
		,"backup_1"//zhadui pv2
		,"backup_2"//zhadui click2
		,"backup_3" //saoma
};
	
	
	 public static String decodeString(String args) {
			try {
				return new String(java.net.URLDecoder.decode(args,"UTF-8")	.getBytes("UTF-8"), "UTF-8");
			} catch (Throwable e) {
				try {
					return new String(java.net.URLDecoder.decode(args,"GBK")	.getBytes("UTF-8"), "UTF-8");
				} catch (Throwable e2) {
					return args;
				}
			}
		}
	    
	    
	    public static String getNameNodecode(String url,String keyname)
		{
	    	try{
				String[] tem = url.split("\\?", 2);
				String params=tem[0];
				if (tem.length >= 2){
					params=tem[1];
				}
			
				for (String s: params.split("&", -1)) {
				    String[] tem1 = s.split("=", -1);
				    String key = decodeString(tem1[0]);
					if(key.equals(keyname))
					{
						String value = (tem1.length < 2
								? "" : decodeString(tem1[1]));
						return value;
					}
				}
	    	}catch(Throwable e){}
			return null;
		 }
	    
	    public static String getName(String url,String keyname)
		{
	    	try{
				String[] tem = decodeString(url).split("\\?", 2);
				String params=tem[0];
				if (tem.length >= 2){
					params=tem[1];
				}
			
				for (String s: params.split("&", -1)) {
				    String[] tem1 = s.split("=", -1);
				    String key = decodeString(tem1[0]);
					if(key.equals(keyname))
					{
						String value = (tem1.length < 2
								? "" : decodeString(tem1[1]));
						return value;
					}
				}
	    	}catch(Throwable e){}
			return null;
		 }
}