pagehits.java

java swing源码 欢迎下载 有问题请联系 我一定负责到底

/**
 * 点击率
 * 可对点击率做新增、删除、修改、查询
 */
package com.NCL;

import java.util.*;
import com.sinosoft.common.*;

public class PageHits{
	protected IndexMap propList;
	protected HashSet Property;
	protected String fMessageTime = "";
	protected String tMessageTime = "";
	private boolean EOF = false;
	private int COUNT;
	
	public List strList = new ArrayList();
	/**
	 * 构造函数
	 *
	 */
	public PageHits(){
		propList = new IndexMap();
		Property = new HashSet();
		Property.add("DicID");		//ID
		Property.add("PageID");		//点击页ID
		Property.add("PageName");	//点击页名字
		Property.add("FistIP");		//第一次访问IP
		Property.add("SecondIP");	//第二次访问IP
		Property.add("LocalIP");	//本地IP
		Property.add("MakeDate");	//创建日期
		Property.add("PagePath");	//点击页路径
	}
	/**
	 * 获取fMessageTime
	 * @return String
	 */
	public String getfMessageTime() {
		return fMessageTime;
	}
	/**
	 * 设置fMessageTime
	 * @param str	日期
	 */
	public void setfMessageTime(String str) {
		fMessageTime = str;
	}
	/**
	 * 获取tMessageTime
	 * @return String
	 */
	public String gettMessageTime() {
		return tMessageTime;
	}
	/**
	 * 设置tMessageTime
	 * @param str	日期
	 */
	public void settMessageTime(String str) {
		tMessageTime = str;
	}

	/**
	 * 在此映射中关联指定值与指定键
	 * @param name 指定键
	 * @param value 指定值
	 */
	public void setUpdateValue(String name,Object value){
		if(this.set(name,value)){
			Object[] uValue = new Object[2];
			uValue[0] = name;
			uValue[1] = value;
			strList.add(uValue);
		}
	}
	/**
	 * 在此映射中关联指定值与指定键
	 * @param name 指定键
	 * @param value 指定值
	 */
	public boolean set(String name, Object value){
		if(Property.contains(name)){
			propList.put(name,value);
			return true;
		}else
			return false;		
	}
	/**
	 * 返回指定键在此映射中所映射的值
	 * @param name 指定键
	 * @return
	 */
	public String get(String name){
		if (Property.contains(name)){
			String value = (String)propList.get(name);
			if(value != null && !value.equals(""))
				return value;
			else
				return "";
		}else 
			return "";
	}
	/**
	 * 返回COUNT
	 * @return int
	 */
	public int getCOUNT() {
		return COUNT;
	}
	/**
	 * 设置COUNT
	 * @param count
	 */
	public void setCOUNT(int count) {
		COUNT = count;
	}
	/**
	 * 返回EOF
	 * @return boolean
	 */
	public boolean isEOF() {
		return EOF;
	}
	/**
	 * 设置EOF
	 * @param eof
	 */
	public void setEOF(boolean eof) {
		EOF = eof;
	}
	/**
	 * 清空propList
	 *
	 */
	public void clear(){
		propList.clear();
	}
	/**
	 * 创建点击率
	 * @return boolean
	 */
	public boolean createSubmit(){
		try {
			String sql = "INSERT into pagehits values (DICTIONARYID_SQE.nextval,?,?,?,?,?,to_Date(?,'yyyy-MM-dd hh24:mi:ss'),?)";
			DBAccess d  = new DBAccess();
			return d.mulExecute(sql,this.strList);
		}catch(Exception e){
			System.out.println("PageHits.create() : " + e.getMessage());
			return false;
		}
	}
	/**
	 * 初始化
	 * @param id	ID
	 */
	public void init(String id){
		DBAccess d  = new DBAccess();
		String sql = "SELECT * from pagehits where dicid=?";
		this.propList = d.init(sql,id,this.Property);	
	}
	/**
	 * 根据条件查询
	 * @param cm		对象
	 * @param pageSize	分页大小
	 * @param pageIndex	分页页码
	 * @return String
	 */
	public String find(PageHits cm,int pageSize,int pageIndex){
		String PageID = cm.get("PageID");
		String FistIP = cm.get("FistIP");
		String fMessageTime = cm.getfMessageTime();
		String tMessageTime = cm.gettMessageTime();
		if(Data.hasValue(fMessageTime) && fMessageTime.length()!=19)return "";
		if(Data.hasValue(tMessageTime) && tMessageTime.length()!=19)return "";
		StringBuffer SQL = new StringBuffer("SELECT dicid from pagehits where 1=1");
		if(Data.hasValue(PageID))
			SQL.append(" and PageID=?");
		if(Data.hasValue(FistIP))
			SQL.append(" and FistIP=?");
		if(Data.hasValue(fMessageTime))
			SQL.append(" and makeDate>=to_date('" + fMessageTime + "','yyyy-MM-dd hh24:mi:ss')");
		if(Data.hasValue(tMessageTime))
			SQL.append(" and makeDate<=to_date('" + tMessageTime + "','yyyy-MM-dd hh24:mi:ss')");
		SQL.append(" order by MakeDate desc");
		String result = "";
		DBAccess d  = new DBAccess();
		result = d.pagination(SQL.toString(),cm.propList,pageSize,pageIndex,"dicid");
		setCOUNT(d.COUNT);
		setEOF(d.EOF);
		return result;
	}
	/**
	 * 查询点击率的详细信息
	 * @param cm	对象
	 * @return	List
	 */
	public List findHits(PageHits cm){
		List list  = new ArrayList();
		String PageID = cm.get("PageID");
		String FistIP = cm.get("FistIP");
		String fMessageTime = cm.getfMessageTime();
		String tMessageTime = cm.gettMessageTime();
		if(Data.hasValue(fMessageTime) && fMessageTime.length()!=19)return null;
		if(Data.hasValue(tMessageTime) && tMessageTime.length()!=19)return null;
		StringBuffer SQL = new StringBuffer("SELECT  PageID , PageName , count(PageName) from pagehits where 1=1");
		if(Data.hasValue(PageID)){
			SQL.append(" and PageID=?");
			list.add(PageID);
		}
		if(Data.hasValue(FistIP)){
			SQL.append(" and FistIP=?");
			list.add(FistIP);
		}
		if(Data.hasValue(fMessageTime)){
			SQL.append(" and makeDate>=to_date('" + fMessageTime + "','yyyy-MM-dd hh24:mi:ss')");
		}
		if(Data.hasValue(tMessageTime)){
			SQL.append(" and makeDate<=to_date('" + tMessageTime + "','yyyy-MM-dd hh24:mi:ss')");
		}
		SQL.append(" group by PageName,PageID");
//		System.out.println(SQL.toString());
		DBAccess d  = new DBAccess();
		List result = d.mulparseSQL(SQL.toString(),list);
		setCOUNT(d.COUNT);
		setEOF(d.EOF);
		return result;
	}
}