dbquery.java

来自「EasyJWeb框架 v0.5 基于java技术」· Java 代码 · 共 45 行

package com.easyjf.web.tools;

import java.util.Collection;
import java.util.List;

import com.easyjf.dbo.EasyJDB;

public class DbQuery implements IQuery {	
	private EasyJDB db;		
	private int begin;
	private int max;	
	private Collection paraValues;
	private Class cls;
	public DbQuery(EasyJDB session,Class cls)
	{
		this.db=session;
		this.cls=cls;
	}
	public int getRows(String conditing) {	
		int n=conditing.toLowerCase().indexOf("order by");
		String totalSql=conditing;
		if(n>0)totalSql=conditing.substring(0,n);	
	    int total=((Number)db.uniqueResult(totalSql,paraValues)).intValue();		
		return total;
	}

	public List getResult(String conditing) {
		return db.query(cls,conditing,paraValues,begin,max);
	}

	public void setFirstResult(int begin) {
		this.begin=begin;
	}

	public void setMaxResults(int max) {
		this.max=max;
	}
	public List getResult(String conditing, int begin, int max) {		
		return db.query(cls,conditing,paraValues,begin,max);		
	}
	public void setParaValues(Collection paraValues) {
	  this.paraValues=paraValues;
	}
}