?? pagebeansh.java
字號:
package com.david.util;
import java.sql.SQLException;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.type.Type;
import org.springframework.orm.hibernate3.HibernateCallback;
/**
* 負責分頁的bean
*
* @author Administrator
*
*/
public class PageBeanSH implements IPageBeanSH {
//起始位置
private int start=0;
//數量
private int num;
//查詢語句
private String hql;
//對象數組,查詢
private Object[] arrValues;
//對象
private Type[] arrTypes;
public PageBeanSH() {
super();
// TODO Auto-generated constructor stub
}
public PageBeanSH(String hql,Object[] arrValues) {
this.hql = hql;
this.arrValues=arrValues;
// TODO Auto-generated constructor stub
}
/**
* 構造函數
* @param start
* @param num
* @param hql
*/
public PageBeanSH(int start, int num, String hql,Object[] arrValues,Type[] arrTypes) {
super();
this.start = start;
this.num = num;
this.hql = hql;
this.arrValues=arrValues;
this.arrTypes=arrTypes;
}
/**
* 得出查詢結果
*/
public Object doInHibernate(Session session) throws HibernateException,
SQLException {
// TODO Auto-generated method stub
Query query=session.createQuery(hql);
query.setFirstResult(start*num);
query.setMaxResults(num);
//循環套入參數
if(arrValues.length==0){
;
}else{
for(int i=0;i<arrValues.length;i++){
query.setParameter(i, arrValues[i]);
}
}
return query.list();
}
public Type[] getArrTypes() {
return arrTypes;
}
public void setArrTypes(Type[] arrTypes) {
this.arrTypes = arrTypes;
}
public Object[] getArrValues() {
return arrValues;
}
public void setArrValues(Object[] arrValues) {
this.arrValues = arrValues;
}
public String getHql() {
return hql;
}
public void setHql(String hql) {
this.hql = hql;
}
public int getNum() {
return num;
}
public void setNum(int num) {
this.num = num;
}
public int getStart() {
return start;
}
public void setStart(int start) {
this.start = start;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -