queryspecdbmodifieddate.java

非常有影响的 j道 论 坛 源码 国外很有明的专家编写的 ....对java爱好者很有参考价值

package com.jdon.jivejdon.model.query.specification;

import java.util.ArrayList;
import java.util.Collection;

import org.apache.log4j.Logger;

import com.jdon.jivejdon.model.query.MultiCriteria;
import com.jdon.jivejdon.model.query.QueryCriteria;
import com.jdon.jivejdon.model.query.QuerySpecification;
import com.jdon.jivejdon.util.ToolsUtil;
import com.jdon.util.UtilValidate;

public class QuerySpecDBModifiedDate implements QuerySpecification {
	 private final static Logger logger = Logger.getLogger(QuerySpecDBModifiedDate.class);
	   
	
	private QueryCriteria qc;
	private Collection params;
	private String whereSQL;

	public QuerySpecDBModifiedDate(QueryCriteria qc) {
		this.qc = qc;
		this.params = new ArrayList(5);
	}

	public void parse() {
		parse("");
	}
	
	public void parse(String tablename) {
		logger.debug("enter parse");
		String prefix = "";
		if (!UtilValidate.isEmpty(tablename)){
			prefix = tablename + ".";
		}
		StringBuffer where = new StringBuffer( );
		where.append( " WHERE ");
		where.append(prefix).append("modifiedDate >= ? and ");
		where.append(prefix).append("modifiedDate <= ? ");
		
		String fromDate = ToolsUtil.dateToMillis(qc.getFromDate().getTime());
		logger.debug("fromDate="+ qc.getFromDate() + " sql formate=" + fromDate );
		String toDate = ToolsUtil.dateToMillis(qc.getToDate().getTime());
		logger.debug("toDate="+ qc.getToDate() + " sql formate=" + toDate );
		params.add(fromDate);
		params.add(toDate);
		
		if (qc.getForumId() != null){
			where.append(" and ");
			where.append(prefix).append("forumID = ? ");
			params.add(new Long(qc.getForumId()));
		}
		
		if (qc instanceof MultiCriteria){
			MultiCriteria mmqc = (MultiCriteria)qc;
			if (mmqc.getUserID() != null){
				where.append(" and ");
				where.append(prefix).append("userID = ? ");
				params.add(mmqc.getUserID());    		
			}					
		}		
		this.whereSQL = where.toString();
	}


	public Collection getParams() {
		return params;
	}

	public String getWhereSQL() {
		return whereSQL;
	}
	
	public String getResultSortSQL(){
	    return getResultSortSQL("modifiedDate");
	}
	
	public String getResultSortSQL(String sortName){
		String sorttableName = "";
		if (!UtilValidate.isEmpty(sortName)){
			sorttableName = sortName;
		}
		
	    if (qc.getResultSort().isASCENDING()){
	        return " ORDER BY " + sorttableName +" ASC ";
	    }else{
	    	return " ORDER BY " + sorttableName +" DESC ";
	    }
	}
	

}