?? dbquery.java
字號:
package com.easyjf.web.tools;
import java.util.Collection;
import java.util.List;
/**
* 通用的數據庫查詢器,根據數據庫操作對象DAO執行數據庫分頁查詢操作
* @author 大峽
*
*/
public class DbQuery implements IQuery {
private IDAO dao;
private int begin;
private int max;
private Collection paraValues;
private Class cls;
public DbQuery(IDAO dao, Class cls) {
this.dao = dao;
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) dao.uniqueResult(totalSql, paraValues)).intValue();
return total;
}
public List getResult(String conditing) {
return dao.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 dao.query(cls, conditing, paraValues, begin, max);
}
public void setParaValues(Collection paraValues) {
this.paraValues = paraValues;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -