package com.xxxxxx.iepg.dao;
import java.io.Serializable;
import java.util.List;
import java.util.Map;
import org.hibernate.Query;
/**
*
* <p>
* <ol style='font-size:12px'>
* <li>
* Describe :</li>
* <li>Write date :2011-9-8</li>
* <li>
* Developer :<a href='MailTo:abc-127@qq.com' title='Send to the E-mail'>English
* name is Fd wang</a></li>
* <li>Company :</li>
* </ol>
* </p>
*/
public interface BaseDao<T> {
public T save(T entity);
public void delete(T entity);
public T update(T entity);
public void merge(T entity);
public void saveOrUpdate(T entity);
public T get(Class<T> clas, Serializable id);
public List<T> list(String queryhql, List<Object> paramList,
Integer currentPageNo, Integer pagesize, String orderHql);
public List<T> list(String queryhql, List<Object> paramList, String orderHql);
public Integer getCount(String queryhql, List<Object> paramList);
public List<T> list(String queryhql, Object[] params);
public int updateOrDelete(String hql, Object[] params);
public List<T> list(String queryhql, Object[] params,
Integer currentPageNo, Integer pagesize, String orderHql);
public Integer getCount(String queryhql, Object[] params);
Query createQuery(String queryString, Map<String, Object> values);
Query createQuery(String queryString, Object... params);
int countHqlResult(String hql, Object... values);
int countHqlResult(String hql, Map<String, Object> paramMap);
<X> X findUnique(String hql, Object... values);
<X> X findUnique(String hql, Map<String, Object> values);
public List<Object[]> listSql(String sql);
public List<Object[]> listSql(String sql, Object[] params );
public List<Object[]> listSql(String sql, Object[] params,int currentPageNo, int pagesize);
public int countSqlResult(String sql, Object... values);
}
package com.xxxxxx.iepg.dao.impl;
import java.io.Serializable;
import java.util.List;
import java.util.Map;
import org.apache.commons.lang.StringUtils;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.orm.hibernate3.HibernateTemplate;
import org.springframework.stereotype.Repository;
import org.springframework.util.Assert;
import com.xxxxxx.iepg.dao.BaseDao;
/**
*
* <p>
* <ol style='font-size:12px'>
* <li>
* Describe :</li>
* <li>Write date :2011-9-8</li>
* <li>
* Developer :<a href='MailTo:abc-127@qq.com' title='Send to the E-mail'>English
* name is Fd wang</a></li>
* <li>Company :</li>
* </ol>
* </p>
*/
@SuppressWarnings("unchecked")
@Repository("baseDao")
public class BaseDaoImpl<T> implements BaseDao<T> {
@Autowired
@Qualifier("sessionFactory")
private SessionFactory sessionFactory;
@Autowired
@Qualifier("hibernateTemplate")
private HibernateTemplate hibernateTemplate;
public SessionFactory getSessionFactory() {
return sessionFactory;
}
public void setSessionFactory(SessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
}
public HibernateTemplate getHibernateTemplate() {
return hibernateTemplate;
}
public void setHibernateTemplate(HibernateTemplate hibernateTemplate) {
this.hibernateTemplate = hibernateTemplate;
}
@Override
public void delete(T entity) {
hibernateTemplate.delete(entity);
}
@Override
public void merge(T entity){
hibernateTemplate.merge(entity);
}
@Override
public List<T> list(String queryhql, List<Object> paramList,
Integer currentPageNo, Integer pagesize, String orderHql) {
int paramsize = (paramList == null ? 0 : paramList.size());
if (orderHql != null)
queryhql = queryhql + orderHql;
Query query = this.getSessionFactory().getCurrentSession()
.createQuery(queryhql);
if (paramsize > 0)
for (int i = 0; i < paramsize; i++) {
query.setParameter(i, paramList.get(i));
}
if (pagesize != 0) {
query.setFirstResult((currentPageNo - 1) * pagesize);
query.setMaxResults(pagesize);
}
query.setCacheable(true); // 启用查询缓存
query.setCacheRegion("queryCache"); // 设置查询缓存区域
List<T> result = query.list();
return result;
}
@Override
public Integer getCount(String queryhql, List<Object> paramList) {
int paramsize = (paramList == null ? 0 : paramList.size());
Query query = this.getSessionFactory().getCurrentSession()
.createQuery(queryhql);
if (paramsize > 0)
for (int i = 0; i < paramsize; i++) {
query.setParameter(i, paramList.get(i));
}
query.setCacheable(true); // 启用查询缓存
query.setCacheRegion("queryCache"); // 设置查询缓存区域
return (Integer) query.uniqueResult();
}
@Override
public List<T> list(String queryhql, List<Object> paramList, String orderHql) {
return list(queryhql, paramList, 0, 0, orderHql);
}
public T get(Class<T> clas, Serializable id) {
return (T) this.hibernateTemplate.get(clas, id);
}
@Override
public T save(T entity) {
hibernateTemplate.save(entity);
return entity;
}
@Override
public T update(T entity) {
// hibernateTemplate.clear();
// hibernateTemplate.merge(entity);
hibernateTemplate.saveOrUpdate(entity);
// this.hibernateTemplate.update(entity);
return entity;
}
@Override
public int updateOrDelete(String hql, Object[] params) {
Query query = this.getSessionFactory().getCurrentSession()
.createQuery(hql); // 以hql字符串为参数创建查询对象
int paramsize = params == null ? 0 : params.length;
if (paramsize > 0) {
for (int i = 0; i < paramsize; i++) {
query.setParameter(i, params[i]);
}
}
return query.executeUpdate();
}
@Override
public List<T> list(String hql, Object[] params) {
Query query = this.getSessionFactory().getCurrentSession()
.createQuery(hql); // 以hql字符串为参数创建查询对象
int paramsize = params == null ? 0 : params.length;
if (paramsize > 0) {
for (int i = 0; i < paramsize; i++) {
query.setParameter(i, params[i]);
}
}
query.setCacheable(true); // 启用查询缓存
query.setCacheRegion("queryCache"); // 设置查询缓存区域
List<T> result = query.list();
return result;
}
@Override
public Query createQuery(String queryString, Map<String, Object> values) {
Assert.hasText(queryString, "queryString不能为空");
Query query = getSessionFactory().getCurrentSession().createQuery(
queryString);
query.setCacheable(true);
if (values != null) {
query.setProperties(values);
}
return query;
}
public Query createQuery(String queryString, Object... values) {
Assert.hasText(queryString, "queryString不能为空");
Query query = getSession().createQuery(queryString);
query.setCacheable(true);
if (values != null) {
for (int i = 0; i < values.length; i++) {
if (values[i] != null
&& StringUtils.isNotEmpty(values[i].toString()))
query.setParameter(i, values[i]);
}
}
return query;
}
public int countHqlResult(String hql, Object... values) {
String fromHql = hql;
// select子句与order by子句会影响count查询,进行简单的排除.
fromHql = "from " + StringUtils.substringAfter(fromHql, "from");
fromHql = StringUtils.substringBefore(fromHql, "order by");
String selectHql = "*";
// 如果含有 distinct 描述符,进行简单处理
if (StringUtils.indexOf(hql, "distinct") != -1) {
selectHql = StringUtils.substringBetween(hql, "select", "from")
.trim();
}
String countHql = "select count(" + selectHql + ") " + fromHql;
try {
Long count = findUnique(countHql, values);
return count.intValue();
} catch (Exception e) {
throw new RuntimeException("hql can't be auto count, hql is:"
+ countHql, e);
}
}
public int countHqlResult(String hql, Map<String, Object> paramMap) {
String fromHql = hql;
// select子句与order by子句会影响count查询,进行简单的排除.
fromHql = "from " + StringUtils.substringAfter(fromHql, "from");
fromHql = StringUtils.substringBefore(fromHql, "order by");
String selectHql = "*";
// 如果含有 distinct 描述符,进行简单处理
if (StringUtils.indexOf(hql, "distinct") != -1) {
selectHql = StringUtils.substringBetween(hql, "select", "from")
.trim();
}
String countHql = "select count(" + selectHql + ") " + fromHql;
try {
Long count = findUnique(countHql, paramMap);
return count.intValue();
} catch (Exception e) {
throw new RuntimeException("hql can't be auto count, hql is:"
+ countHql, e);
}
}
public <X> X findUnique(String hql, Object... values) {
return (X) createQuery(hql, values).uniqueResult();
}
public <X> X findUnique(String hql, Map<String, Object> values) {
return (X) createQuery(hql, values).uniqueResult();
}
private Session getSession() {
return this.hibernateTemplate.getSessionFactory().getCurrentSession();
}
@Override
public Integer getCount(String queryhql, Object[] params) {
if(queryhql.indexOf("count")<0&&queryhql.indexOf("COUNT")<0){
queryhql="select count(*) "+queryhql;
}
Query query = this.getSessionFactory().getCurrentSession()
.createQuery(queryhql);
int paramsize = params == null ? 0 : params.length;
if (paramsize > 0)
for (int i = 0; i < paramsize; i++) {
query.setParameter(i, params[i]);
}
query.setCacheable(true); // 启用查询缓存
query.setCacheRegion("queryCache"); // 设置查询缓存区域
return ((Long) query.uniqueResult()).intValue();
}
@Override
public List<T> list(String queryhql, Object[] paramList,
Integer currentPageNo, Integer pagesize, String orderHql) {
int paramsize = (paramList == null ? 0 : paramList.length);
if (orderHql != null) {
queryhql = queryhql + orderHql;
}
Query query = this.getSessionFactory().getCurrentSession()
.createQuery(queryhql);
if (paramsize > 0) {
for (int i = 0; i < paramsize; i++) {
query.setParameter(i, paramList[i]);
}
}
if (pagesize != 0) {
query.setFirstResult((currentPageNo - 1) * pagesize);
query.setMaxResults(pagesize);
}
query.setCacheable(true); // 启用查询缓存
query.setCacheRegion("queryCache"); // 设置查询缓存区域
List<T> result = query.list();
return result;
}
@Override
public void saveOrUpdate(T entity) {
hibernateTemplate.saveOrUpdate(entity);
}
public <X> X findSQLUnique(String sql, Object... values){
Query query = createSqlQuery(sql,values);
return (X)query.uniqueResult();
}
public int countSqlResult(String sql, Object... values) {
String fromHql = sql;
// select子句与order by子句会影响count查询,进行简单的排除.
//fromHql = StringUtils.substring(fromHql,fromHql.toLowerCase().indexOf("from "),fromHql.length());
fromHql = StringUtils.substring(fromHql,0,fromHql.toLowerCase().lastIndexOf("order "));
String selectHql = "*";
// 如果含有 distinct 描述符,进行简单处理
if (StringUtils.indexOf(sql, "distinct") != -1) {
selectHql = StringUtils.substringBetween(sql, "select", "from ")
.trim();
}
String countHql = "select count(" + selectHql + ") from (" + fromHql+") a";
try {
java.math.BigInteger count = findSQLUnique(countHql,values);
return count.intValue();
} catch (Exception e) {
throw new RuntimeException("hql can't be auto count, hql is:"
+ countHql, e);
}
}
/**
* 执行SQL查询
*/
public List<Object[]> listSql(String sql){
return listSql(sql,null);
}
/**
* 执行sql查询,带参数
*/
public List<Object[]> listSql(String sql, Object[] params ){
return listSql(sql,params,0,0);
}
/**
* 执行sql查询,带参数,分页
*/
public List<Object[]> listSql(String sql, Object[] params,int currentPageNo, int pagesize){
int paramsize = (params == null ? 0 : params.length);
Query query = this.getSessionFactory().getCurrentSession().createSQLQuery(sql);
if (paramsize > 0) {
for (int i = 0; i < paramsize; i++) {
query.setParameter(i, params[i]);
}
}
if (pagesize != 0) {
query.setFirstResult((currentPageNo - 1) * pagesize);
query.setMaxResults(pagesize);
}
return query.list();
}
public Query createSqlQuery(String queryString, Object... values) {
Query query = getSession().createSQLQuery(queryString);
if (values != null) {
for (int i = 0; i < values.length; i++) {
if (values[i] != null
&& StringUtils.isNotEmpty(values[i].toString()))
query.setParameter(i, values[i]);
}
}
return query;
}
}
package com.xxxxxx.iepg.dao;
import java.io.Serializable;
import java.util.List;
import java.util.Map;
import com.xxxxxx.iepg.pager.Pager;
/**
*
* <p>
* <ol style='font-size:12px'>
* <li>
* Describe :</li>
* <li>Write date :2011-9-24</li>
* <li>
* Developer :<a href='MailTo:abc-127@qq.com' title='Send to the E-mail'>English
* name is Fd wang</a></li>
* <li>Company :</li>
* </ol>
* </p>
*/
public interface ExtendBaseDao<T, K extends Serializable> {
public T save(T entity);
public void delete(T entity);
public int delete(String hql);
public int delete(String hql, Object[] params);
public T update(T entity);
public void saveOrUpdate(T entity);
public int update(String hql);
public int update(String hql, Object[] params);
public T get(Class<T> entityClass, K id);
public List<T> list(String hql);
public List<T> list(String hql, Object[] params);
public Pager<T> listPage(Integer currentpage, Integer pagesize, String hql,
String orderBy, Object[] params);
public List<T> list(Integer currentpage, Integer pagesize, String hql,
String orderBy, Object[] params);
int getCount(String hql, Object[] params);
Pager<T> listPage(Pager<T> pager, String hql, Object... params);
Pager<T> listPage(Pager<T> pager, String countHql, String hql,
Object... params);
Pager<T> listLimitPager(int start, int limit, String hql, Object... params);
Pager<T> listPage(Pager<T> pager, String hql, Map<String, Object> paramMap);
Pager<T> listPage(Pager<T> pager, String countHql, String hql,
Map<String, Object> paramMap);
Pager<T> listLimitPager(int start, int limit, String hql,
Map<String, Object> paramMap);
public T get(String hql, Object[] params);
public List<Object[]> listSql(String sql);
public List<Object[]> listSql(String sql, Object[] params );
public Pager<Object[]> listSqlPage(Pager<Object[]> pager, String sql, Object... params);
public void merge(T entity);
}
package com.xxxxxx.iepg.dao.impl;
import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import org.hibernate.Query;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import com.xxxxxx.iepg.dao.BaseDao;
import com.xxxxxx.iepg.dao.ExtendBaseDao;
import com.xxxxxx.iepg.pager.Pager;
/**
*
* <p>
* <ol style='font-size:12px'>
* <li>
* Describe :</li>
* <li>Write date :2011-9-24</li>
* <li>
* Developer :<a href='MailTo:abc-127@qq.com' title='Send to the E-mail'>English
* name is Fd wang</a></li>
* <li>Company :</li>
* </ol>
* </p>
*/
@Component("extendBaseDao")
public class ExtendBaseBoImpl<T, K extends Serializable> implements
ExtendBaseDao<T, K> {
@Autowired
private BaseDao<T> baseDao;
public BaseDao<T> getBaseDao() {
return baseDao;
}
public void setBaseDao(BaseDao<T> baseDao) {
this.baseDao = baseDao;
}
@Override
public void delete(T entity) {
baseDao.delete(entity);
}
@Override
public int delete(String hql) {
return baseDao.updateOrDelete(hql, null);
}
@Override
public int delete(String hql, Object[] params) {
return baseDao.updateOrDelete(hql, params);
}
@Override
public T get(Class<T> entityClass, K id) {
return baseDao.get(entityClass, id);
}
@Override
public T save(T entity) {
return baseDao.save(entity);
}
@Override
public T update(T entity) {
return baseDao.update(entity);
}
@Override
public void saveOrUpdate(T entity) {
baseDao.saveOrUpdate(entity);
}
@Override
public int update(String hql) {
return baseDao.updateOrDelete(hql, null);
}
@Override
public int update(String hql, Object[] params) {
return baseDao.updateOrDelete(hql, params);
}
@Override
public void merge(T entity) {
baseDao.merge(entity);
}
@Override
public List<T> list(String hql) {
return baseDao.list(hql, null, null);
}
@Override
public List<T> list(String hql, Object[] params) {
return baseDao.list(hql, params);
}
@SuppressWarnings("unchecked")
@Override
public Pager listPage(Pager pager, String hql, Object... params) {
Query q = baseDao.createQuery(hql, params);
// 设置查询分页记录参数
setPageParams(q, pager.getCurPage(), pager.getPageSize());
int totalCount = baseDao.countHqlResult(hql, params);
pager.setTotalcnt(totalCount);
List<T> result = q.list();
pager.setList(result);
return pager;
}
@SuppressWarnings("unchecked")
@Override
public Pager listPage(Pager pager, String countHql, String hql,
Object... params) {
Query q = baseDao.createQuery(hql, params);
// 设置查询分页记录参数
setPageParams(q, pager.getCurPage(), pager.getPageSize());
int totalCount = baseDao.countHqlResult(countHql, params);
pager.setTotalcnt(totalCount);
List<T> result = q.list();
pager.setList(result);
return pager;
}
@Override
public Pager<T> listPage(Integer currentpage, Integer pagesize, String hql,
String orderBy, Object[] params) {
Pager<T> page = new Pager<T>();
if (currentpage == null || pagesize == null) {
page.setList(baseDao.list(hql, params));
page.setTotalcnt(page.getList().size());
return page;
}
int cnt = baseDao.getCount(hql, params);
page.setCurrentpage(currentpage);
page.setPageSize(pagesize);
if (cnt <= 0) {
page.setTotalcnt(cnt);
page.setList(new ArrayList<T>(0));
return page;
}
page.setTotalcnt(cnt);
if ((currentpage - 1) * pagesize > cnt) {
return page;
}
page.setList(baseDao.list(hql, params, currentpage, pagesize, orderBy));
return page;
}
@SuppressWarnings("unchecked")
@Override
public Pager<T> listPage(Pager<T> pager, String hql,
Map<String, Object> paramMap) {
Query q = baseDao.createQuery(hql, paramMap);
// 设置查询分页记录参数
setPageParams(q, pager.getCurPage(), pager.getPageSize());
// 设置总的记录数
int totalCount = baseDao.countHqlResult(hql, paramMap);
pager.setTotalcnt(totalCount);
List<T> result = q.list();
pager.setList(result);
return pager;
}
@SuppressWarnings("unchecked")
@Override
public Pager<T> listPage(Pager<T> pager, String countHql, String hql,
Map<String, Object> paramMap) {
Query q = baseDao.createQuery(hql, paramMap);
// 设置查询分页记录参数
setPageParams(q, pager.getCurPage(), pager.getPageSize());
// 设置总的记录数
int totalCount = baseDao.countHqlResult(countHql, paramMap);
pager.setTotalcnt(totalCount);
List<T> result = q.list();
pager.setList(result);
return pager;
}
@Override
public int getCount(String hql, Object[] params) {
return baseDao.getCount(hql, params);
}
private void setPageParams(Query q, int currPage, int pageSize) {
if (q != null) {
// 设置查询分页记录参数
int start = (currPage - 1) * pageSize;
q.setFirstResult(start);
q.setMaxResults(pageSize);
}
}
private void setLimitParams(Query q, int start, int pageSize) {
if (q != null) {
q.setFirstResult(start);
q.setMaxResults(pageSize);
}
}
@Override
public T get(String hql, Object[] params) {
List<T> list = baseDao.list(hql, params,1,1,null);
if (list == null || list.isEmpty()) {
return null;
}
return list.get(0);
}
@Override
public List<T> list(Integer currentpage, Integer pagesize, String hql,
String orderBy, Object[] params) {
return baseDao.list(hql, params, currentpage, pagesize, orderBy);
}
@Override
public Pager<T> listLimitPager(int start, int limit, String hql, Object... params) {
Query q = baseDao.createQuery(hql, params);
setLimitParams(q, start, limit);
// 设置总的记录数
int totalCount = baseDao.countHqlResult(hql, params);
Pager pager = new Pager();
pager.setTotalcnt(totalCount);
List<T> result = q.list();
pager.setList(result);
return pager;
}
@Override
public Pager<T> listLimitPager(int start, int limit, String hql,
Map<String, Object> paramMap) {
Query q = baseDao.createQuery(hql, paramMap);
setLimitParams(q, start, limit);
// 设置总的记录数
int totalCount = baseDao.countHqlResult(hql, paramMap);
Pager pager = new Pager();
pager.setTotalcnt(totalCount);
List<T> result = q.list();
pager.setList(result);
return pager;
}
public List<Object[]> listSql(String sql){
return baseDao.listSql(sql);
}
public List<Object[]> listSql(String sql, Object[] params ){
return baseDao.listSql(sql, params);
}
public Pager<Object[]> listSqlPage(Pager<Object[]> pager, String sql, Object... params){
int totalCount = baseDao.countSqlResult(sql, params);
pager.setTotalcnt(totalCount);
List<Object[]> result = baseDao.listSql(sql, params, pager.getCurPage(), pager.getPageSize());
pager.setList(result);
return pager;
}
}
package com.xxxxxx.iepg.pager;
import java.util.List;
/**
*
* <p>
* <ol style='font-size:12px'>
* <li>
* Describe :</li>
* <li>Write date :2011-9-7</li>
* <li>
* Developer :<a href='MailTo:abc-127@qq.com' title='Send to the E-mail'>English
* name is Fd wang</a></li>
* <li>Company :</li>
* </ol>
* </p>
*/
@SuppressWarnings("unchecked")
public class Pager<T> {
private int pageSize = 10;
private int curPage = 1;
private int totalcnt = 0;
private int totalpage = 0;
private List list;
/**
* 排序方式 : desc(倒序) or asc(顺序)
*/
private String orderSort;
/**
* 排序字段
*/
private String orderField;
/**
* 排序方式 : desc(倒序) or asc(顺序)</br>默认为:asc(顺序)
* @return
*/
public String getOrderSort() {
if(orderSort == null || orderSort == ""){
return "asc";
}
if("desc".equals(orderSort.trim().toLowerCase()) || "asc".equals(orderSort.trim().toLowerCase())){
return orderSort;
}
return "asc";
}
public void setOrderSort(String orderSort) {
this.orderSort = orderSort;
}
public String getOrderField() {
return orderField;
}
public void setOrderField(String orderField) {
this.orderField = orderField;
}
public Pager() {
}
public Pager(int pageSize, int curPage) {
this.pageSize = pageSize;
this.curPage = curPage;
}
public int getPageSize() {
return pageSize;
}
public void setPageSize(int pagesize) {
if (pagesize <= 0) {
return;
}
this.pageSize = pagesize;
}
public int getCurPage() {
return curPage;
}
public void setCurrentpage(int curPage) {
if (curPage <= 0) {
return;
}
this.curPage = curPage;
}
public int getTotalcnt() {
return totalcnt;
}
public void setTotalcnt(int totalcnt) {
this.totalcnt = totalcnt;
}
public List<T> getList() {
return list;
}
public void setList(List<T> list) {
this.list = list;
}
public int getTotalpage() {
if (totalcnt == 0) {
totalpage = 0;
} else if (totalcnt % pageSize == 0) {
return totalpage = totalcnt / pageSize;
} else {
return totalpage = totalcnt / pageSize + 1;
}
return totalpage;
}
}
import java.io.Serializable;
import java.util.List;
import java.util.Map;
import org.hibernate.Query;
/**
*
* <p>
* <ol style='font-size:12px'>
* <li>
* Describe :</li>
* <li>Write date :2011-9-8</li>
* <li>
* Developer :<a href='MailTo:abc-127@qq.com' title='Send to the E-mail'>English
* name is Fd wang</a></li>
* <li>Company :</li>
* </ol>
* </p>
*/
public interface BaseDao<T> {
public T save(T entity);
public void delete(T entity);
public T update(T entity);
public void merge(T entity);
public void saveOrUpdate(T entity);
public T get(Class<T> clas, Serializable id);
public List<T> list(String queryhql, List<Object> paramList,
Integer currentPageNo, Integer pagesize, String orderHql);
public List<T> list(String queryhql, List<Object> paramList, String orderHql);
public Integer getCount(String queryhql, List<Object> paramList);
public List<T> list(String queryhql, Object[] params);
public int updateOrDelete(String hql, Object[] params);
public List<T> list(String queryhql, Object[] params,
Integer currentPageNo, Integer pagesize, String orderHql);
public Integer getCount(String queryhql, Object[] params);
Query createQuery(String queryString, Map<String, Object> values);
Query createQuery(String queryString, Object... params);
int countHqlResult(String hql, Object... values);
int countHqlResult(String hql, Map<String, Object> paramMap);
<X> X findUnique(String hql, Object... values);
<X> X findUnique(String hql, Map<String, Object> values);
public List<Object[]> listSql(String sql);
public List<Object[]> listSql(String sql, Object[] params );
public List<Object[]> listSql(String sql, Object[] params,int currentPageNo, int pagesize);
public int countSqlResult(String sql, Object... values);
}
package com.xxxxxx.iepg.dao.impl;
import java.io.Serializable;
import java.util.List;
import java.util.Map;
import org.apache.commons.lang.StringUtils;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.orm.hibernate3.HibernateTemplate;
import org.springframework.stereotype.Repository;
import org.springframework.util.Assert;
import com.xxxxxx.iepg.dao.BaseDao;
/**
*
* <p>
* <ol style='font-size:12px'>
* <li>
* Describe :</li>
* <li>Write date :2011-9-8</li>
* <li>
* Developer :<a href='MailTo:abc-127@qq.com' title='Send to the E-mail'>English
* name is Fd wang</a></li>
* <li>Company :</li>
* </ol>
* </p>
*/
@SuppressWarnings("unchecked")
@Repository("baseDao")
public class BaseDaoImpl<T> implements BaseDao<T> {
@Autowired
@Qualifier("sessionFactory")
private SessionFactory sessionFactory;
@Autowired
@Qualifier("hibernateTemplate")
private HibernateTemplate hibernateTemplate;
public SessionFactory getSessionFactory() {
return sessionFactory;
}
public void setSessionFactory(SessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
}
public HibernateTemplate getHibernateTemplate() {
return hibernateTemplate;
}
public void setHibernateTemplate(HibernateTemplate hibernateTemplate) {
this.hibernateTemplate = hibernateTemplate;
}
@Override
public void delete(T entity) {
hibernateTemplate.delete(entity);
}
@Override
public void merge(T entity){
hibernateTemplate.merge(entity);
}
@Override
public List<T> list(String queryhql, List<Object> paramList,
Integer currentPageNo, Integer pagesize, String orderHql) {
int paramsize = (paramList == null ? 0 : paramList.size());
if (orderHql != null)
queryhql = queryhql + orderHql;
Query query = this.getSessionFactory().getCurrentSession()
.createQuery(queryhql);
if (paramsize > 0)
for (int i = 0; i < paramsize; i++) {
query.setParameter(i, paramList.get(i));
}
if (pagesize != 0) {
query.setFirstResult((currentPageNo - 1) * pagesize);
query.setMaxResults(pagesize);
}
query.setCacheable(true); // 启用查询缓存
query.setCacheRegion("queryCache"); // 设置查询缓存区域
List<T> result = query.list();
return result;
}
@Override
public Integer getCount(String queryhql, List<Object> paramList) {
int paramsize = (paramList == null ? 0 : paramList.size());
Query query = this.getSessionFactory().getCurrentSession()
.createQuery(queryhql);
if (paramsize > 0)
for (int i = 0; i < paramsize; i++) {
query.setParameter(i, paramList.get(i));
}
query.setCacheable(true); // 启用查询缓存
query.setCacheRegion("queryCache"); // 设置查询缓存区域
return (Integer) query.uniqueResult();
}
@Override
public List<T> list(String queryhql, List<Object> paramList, String orderHql) {
return list(queryhql, paramList, 0, 0, orderHql);
}
public T get(Class<T> clas, Serializable id) {
return (T) this.hibernateTemplate.get(clas, id);
}
@Override
public T save(T entity) {
hibernateTemplate.save(entity);
return entity;
}
@Override
public T update(T entity) {
// hibernateTemplate.clear();
// hibernateTemplate.merge(entity);
hibernateTemplate.saveOrUpdate(entity);
// this.hibernateTemplate.update(entity);
return entity;
}
@Override
public int updateOrDelete(String hql, Object[] params) {
Query query = this.getSessionFactory().getCurrentSession()
.createQuery(hql); // 以hql字符串为参数创建查询对象
int paramsize = params == null ? 0 : params.length;
if (paramsize > 0) {
for (int i = 0; i < paramsize; i++) {
query.setParameter(i, params[i]);
}
}
return query.executeUpdate();
}
@Override
public List<T> list(String hql, Object[] params) {
Query query = this.getSessionFactory().getCurrentSession()
.createQuery(hql); // 以hql字符串为参数创建查询对象
int paramsize = params == null ? 0 : params.length;
if (paramsize > 0) {
for (int i = 0; i < paramsize; i++) {
query.setParameter(i, params[i]);
}
}
query.setCacheable(true); // 启用查询缓存
query.setCacheRegion("queryCache"); // 设置查询缓存区域
List<T> result = query.list();
return result;
}
@Override
public Query createQuery(String queryString, Map<String, Object> values) {
Assert.hasText(queryString, "queryString不能为空");
Query query = getSessionFactory().getCurrentSession().createQuery(
queryString);
query.setCacheable(true);
if (values != null) {
query.setProperties(values);
}
return query;
}
public Query createQuery(String queryString, Object... values) {
Assert.hasText(queryString, "queryString不能为空");
Query query = getSession().createQuery(queryString);
query.setCacheable(true);
if (values != null) {
for (int i = 0; i < values.length; i++) {
if (values[i] != null
&& StringUtils.isNotEmpty(values[i].toString()))
query.setParameter(i, values[i]);
}
}
return query;
}
public int countHqlResult(String hql, Object... values) {
String fromHql = hql;
// select子句与order by子句会影响count查询,进行简单的排除.
fromHql = "from " + StringUtils.substringAfter(fromHql, "from");
fromHql = StringUtils.substringBefore(fromHql, "order by");
String selectHql = "*";
// 如果含有 distinct 描述符,进行简单处理
if (StringUtils.indexOf(hql, "distinct") != -1) {
selectHql = StringUtils.substringBetween(hql, "select", "from")
.trim();
}
String countHql = "select count(" + selectHql + ") " + fromHql;
try {
Long count = findUnique(countHql, values);
return count.intValue();
} catch (Exception e) {
throw new RuntimeException("hql can't be auto count, hql is:"
+ countHql, e);
}
}
public int countHqlResult(String hql, Map<String, Object> paramMap) {
String fromHql = hql;
// select子句与order by子句会影响count查询,进行简单的排除.
fromHql = "from " + StringUtils.substringAfter(fromHql, "from");
fromHql = StringUtils.substringBefore(fromHql, "order by");
String selectHql = "*";
// 如果含有 distinct 描述符,进行简单处理
if (StringUtils.indexOf(hql, "distinct") != -1) {
selectHql = StringUtils.substringBetween(hql, "select", "from")
.trim();
}
String countHql = "select count(" + selectHql + ") " + fromHql;
try {
Long count = findUnique(countHql, paramMap);
return count.intValue();
} catch (Exception e) {
throw new RuntimeException("hql can't be auto count, hql is:"
+ countHql, e);
}
}
public <X> X findUnique(String hql, Object... values) {
return (X) createQuery(hql, values).uniqueResult();
}
public <X> X findUnique(String hql, Map<String, Object> values) {
return (X) createQuery(hql, values).uniqueResult();
}
private Session getSession() {
return this.hibernateTemplate.getSessionFactory().getCurrentSession();
}
@Override
public Integer getCount(String queryhql, Object[] params) {
if(queryhql.indexOf("count")<0&&queryhql.indexOf("COUNT")<0){
queryhql="select count(*) "+queryhql;
}
Query query = this.getSessionFactory().getCurrentSession()
.createQuery(queryhql);
int paramsize = params == null ? 0 : params.length;
if (paramsize > 0)
for (int i = 0; i < paramsize; i++) {
query.setParameter(i, params[i]);
}
query.setCacheable(true); // 启用查询缓存
query.setCacheRegion("queryCache"); // 设置查询缓存区域
return ((Long) query.uniqueResult()).intValue();
}
@Override
public List<T> list(String queryhql, Object[] paramList,
Integer currentPageNo, Integer pagesize, String orderHql) {
int paramsize = (paramList == null ? 0 : paramList.length);
if (orderHql != null) {
queryhql = queryhql + orderHql;
}
Query query = this.getSessionFactory().getCurrentSession()
.createQuery(queryhql);
if (paramsize > 0) {
for (int i = 0; i < paramsize; i++) {
query.setParameter(i, paramList[i]);
}
}
if (pagesize != 0) {
query.setFirstResult((currentPageNo - 1) * pagesize);
query.setMaxResults(pagesize);
}
query.setCacheable(true); // 启用查询缓存
query.setCacheRegion("queryCache"); // 设置查询缓存区域
List<T> result = query.list();
return result;
}
@Override
public void saveOrUpdate(T entity) {
hibernateTemplate.saveOrUpdate(entity);
}
public <X> X findSQLUnique(String sql, Object... values){
Query query = createSqlQuery(sql,values);
return (X)query.uniqueResult();
}
public int countSqlResult(String sql, Object... values) {
String fromHql = sql;
// select子句与order by子句会影响count查询,进行简单的排除.
//fromHql = StringUtils.substring(fromHql,fromHql.toLowerCase().indexOf("from "),fromHql.length());
fromHql = StringUtils.substring(fromHql,0,fromHql.toLowerCase().lastIndexOf("order "));
String selectHql = "*";
// 如果含有 distinct 描述符,进行简单处理
if (StringUtils.indexOf(sql, "distinct") != -1) {
selectHql = StringUtils.substringBetween(sql, "select", "from ")
.trim();
}
String countHql = "select count(" + selectHql + ") from (" + fromHql+") a";
try {
java.math.BigInteger count = findSQLUnique(countHql,values);
return count.intValue();
} catch (Exception e) {
throw new RuntimeException("hql can't be auto count, hql is:"
+ countHql, e);
}
}
/**
* 执行SQL查询
*/
public List<Object[]> listSql(String sql){
return listSql(sql,null);
}
/**
* 执行sql查询,带参数
*/
public List<Object[]> listSql(String sql, Object[] params ){
return listSql(sql,params,0,0);
}
/**
* 执行sql查询,带参数,分页
*/
public List<Object[]> listSql(String sql, Object[] params,int currentPageNo, int pagesize){
int paramsize = (params == null ? 0 : params.length);
Query query = this.getSessionFactory().getCurrentSession().createSQLQuery(sql);
if (paramsize > 0) {
for (int i = 0; i < paramsize; i++) {
query.setParameter(i, params[i]);
}
}
if (pagesize != 0) {
query.setFirstResult((currentPageNo - 1) * pagesize);
query.setMaxResults(pagesize);
}
return query.list();
}
public Query createSqlQuery(String queryString, Object... values) {
Query query = getSession().createSQLQuery(queryString);
if (values != null) {
for (int i = 0; i < values.length; i++) {
if (values[i] != null
&& StringUtils.isNotEmpty(values[i].toString()))
query.setParameter(i, values[i]);
}
}
return query;
}
}
package com.xxxxxx.iepg.dao;
import java.io.Serializable;
import java.util.List;
import java.util.Map;
import com.xxxxxx.iepg.pager.Pager;
/**
*
* <p>
* <ol style='font-size:12px'>
* <li>
* Describe :</li>
* <li>Write date :2011-9-24</li>
* <li>
* Developer :<a href='MailTo:abc-127@qq.com' title='Send to the E-mail'>English
* name is Fd wang</a></li>
* <li>Company :</li>
* </ol>
* </p>
*/
public interface ExtendBaseDao<T, K extends Serializable> {
public T save(T entity);
public void delete(T entity);
public int delete(String hql);
public int delete(String hql, Object[] params);
public T update(T entity);
public void saveOrUpdate(T entity);
public int update(String hql);
public int update(String hql, Object[] params);
public T get(Class<T> entityClass, K id);
public List<T> list(String hql);
public List<T> list(String hql, Object[] params);
public Pager<T> listPage(Integer currentpage, Integer pagesize, String hql,
String orderBy, Object[] params);
public List<T> list(Integer currentpage, Integer pagesize, String hql,
String orderBy, Object[] params);
int getCount(String hql, Object[] params);
Pager<T> listPage(Pager<T> pager, String hql, Object... params);
Pager<T> listPage(Pager<T> pager, String countHql, String hql,
Object... params);
Pager<T> listLimitPager(int start, int limit, String hql, Object... params);
Pager<T> listPage(Pager<T> pager, String hql, Map<String, Object> paramMap);
Pager<T> listPage(Pager<T> pager, String countHql, String hql,
Map<String, Object> paramMap);
Pager<T> listLimitPager(int start, int limit, String hql,
Map<String, Object> paramMap);
public T get(String hql, Object[] params);
public List<Object[]> listSql(String sql);
public List<Object[]> listSql(String sql, Object[] params );
public Pager<Object[]> listSqlPage(Pager<Object[]> pager, String sql, Object... params);
public void merge(T entity);
}
package com.xxxxxx.iepg.dao.impl;
import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import org.hibernate.Query;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import com.xxxxxx.iepg.dao.BaseDao;
import com.xxxxxx.iepg.dao.ExtendBaseDao;
import com.xxxxxx.iepg.pager.Pager;
/**
*
* <p>
* <ol style='font-size:12px'>
* <li>
* Describe :</li>
* <li>Write date :2011-9-24</li>
* <li>
* Developer :<a href='MailTo:abc-127@qq.com' title='Send to the E-mail'>English
* name is Fd wang</a></li>
* <li>Company :</li>
* </ol>
* </p>
*/
@Component("extendBaseDao")
public class ExtendBaseBoImpl<T, K extends Serializable> implements
ExtendBaseDao<T, K> {
@Autowired
private BaseDao<T> baseDao;
public BaseDao<T> getBaseDao() {
return baseDao;
}
public void setBaseDao(BaseDao<T> baseDao) {
this.baseDao = baseDao;
}
@Override
public void delete(T entity) {
baseDao.delete(entity);
}
@Override
public int delete(String hql) {
return baseDao.updateOrDelete(hql, null);
}
@Override
public int delete(String hql, Object[] params) {
return baseDao.updateOrDelete(hql, params);
}
@Override
public T get(Class<T> entityClass, K id) {
return baseDao.get(entityClass, id);
}
@Override
public T save(T entity) {
return baseDao.save(entity);
}
@Override
public T update(T entity) {
return baseDao.update(entity);
}
@Override
public void saveOrUpdate(T entity) {
baseDao.saveOrUpdate(entity);
}
@Override
public int update(String hql) {
return baseDao.updateOrDelete(hql, null);
}
@Override
public int update(String hql, Object[] params) {
return baseDao.updateOrDelete(hql, params);
}
@Override
public void merge(T entity) {
baseDao.merge(entity);
}
@Override
public List<T> list(String hql) {
return baseDao.list(hql, null, null);
}
@Override
public List<T> list(String hql, Object[] params) {
return baseDao.list(hql, params);
}
@SuppressWarnings("unchecked")
@Override
public Pager listPage(Pager pager, String hql, Object... params) {
Query q = baseDao.createQuery(hql, params);
// 设置查询分页记录参数
setPageParams(q, pager.getCurPage(), pager.getPageSize());
int totalCount = baseDao.countHqlResult(hql, params);
pager.setTotalcnt(totalCount);
List<T> result = q.list();
pager.setList(result);
return pager;
}
@SuppressWarnings("unchecked")
@Override
public Pager listPage(Pager pager, String countHql, String hql,
Object... params) {
Query q = baseDao.createQuery(hql, params);
// 设置查询分页记录参数
setPageParams(q, pager.getCurPage(), pager.getPageSize());
int totalCount = baseDao.countHqlResult(countHql, params);
pager.setTotalcnt(totalCount);
List<T> result = q.list();
pager.setList(result);
return pager;
}
@Override
public Pager<T> listPage(Integer currentpage, Integer pagesize, String hql,
String orderBy, Object[] params) {
Pager<T> page = new Pager<T>();
if (currentpage == null || pagesize == null) {
page.setList(baseDao.list(hql, params));
page.setTotalcnt(page.getList().size());
return page;
}
int cnt = baseDao.getCount(hql, params);
page.setCurrentpage(currentpage);
page.setPageSize(pagesize);
if (cnt <= 0) {
page.setTotalcnt(cnt);
page.setList(new ArrayList<T>(0));
return page;
}
page.setTotalcnt(cnt);
if ((currentpage - 1) * pagesize > cnt) {
return page;
}
page.setList(baseDao.list(hql, params, currentpage, pagesize, orderBy));
return page;
}
@SuppressWarnings("unchecked")
@Override
public Pager<T> listPage(Pager<T> pager, String hql,
Map<String, Object> paramMap) {
Query q = baseDao.createQuery(hql, paramMap);
// 设置查询分页记录参数
setPageParams(q, pager.getCurPage(), pager.getPageSize());
// 设置总的记录数
int totalCount = baseDao.countHqlResult(hql, paramMap);
pager.setTotalcnt(totalCount);
List<T> result = q.list();
pager.setList(result);
return pager;
}
@SuppressWarnings("unchecked")
@Override
public Pager<T> listPage(Pager<T> pager, String countHql, String hql,
Map<String, Object> paramMap) {
Query q = baseDao.createQuery(hql, paramMap);
// 设置查询分页记录参数
setPageParams(q, pager.getCurPage(), pager.getPageSize());
// 设置总的记录数
int totalCount = baseDao.countHqlResult(countHql, paramMap);
pager.setTotalcnt(totalCount);
List<T> result = q.list();
pager.setList(result);
return pager;
}
@Override
public int getCount(String hql, Object[] params) {
return baseDao.getCount(hql, params);
}
private void setPageParams(Query q, int currPage, int pageSize) {
if (q != null) {
// 设置查询分页记录参数
int start = (currPage - 1) * pageSize;
q.setFirstResult(start);
q.setMaxResults(pageSize);
}
}
private void setLimitParams(Query q, int start, int pageSize) {
if (q != null) {
q.setFirstResult(start);
q.setMaxResults(pageSize);
}
}
@Override
public T get(String hql, Object[] params) {
List<T> list = baseDao.list(hql, params,1,1,null);
if (list == null || list.isEmpty()) {
return null;
}
return list.get(0);
}
@Override
public List<T> list(Integer currentpage, Integer pagesize, String hql,
String orderBy, Object[] params) {
return baseDao.list(hql, params, currentpage, pagesize, orderBy);
}
@Override
public Pager<T> listLimitPager(int start, int limit, String hql, Object... params) {
Query q = baseDao.createQuery(hql, params);
setLimitParams(q, start, limit);
// 设置总的记录数
int totalCount = baseDao.countHqlResult(hql, params);
Pager pager = new Pager();
pager.setTotalcnt(totalCount);
List<T> result = q.list();
pager.setList(result);
return pager;
}
@Override
public Pager<T> listLimitPager(int start, int limit, String hql,
Map<String, Object> paramMap) {
Query q = baseDao.createQuery(hql, paramMap);
setLimitParams(q, start, limit);
// 设置总的记录数
int totalCount = baseDao.countHqlResult(hql, paramMap);
Pager pager = new Pager();
pager.setTotalcnt(totalCount);
List<T> result = q.list();
pager.setList(result);
return pager;
}
public List<Object[]> listSql(String sql){
return baseDao.listSql(sql);
}
public List<Object[]> listSql(String sql, Object[] params ){
return baseDao.listSql(sql, params);
}
public Pager<Object[]> listSqlPage(Pager<Object[]> pager, String sql, Object... params){
int totalCount = baseDao.countSqlResult(sql, params);
pager.setTotalcnt(totalCount);
List<Object[]> result = baseDao.listSql(sql, params, pager.getCurPage(), pager.getPageSize());
pager.setList(result);
return pager;
}
}
package com.xxxxxx.iepg.pager;
import java.util.List;
/**
*
* <p>
* <ol style='font-size:12px'>
* <li>
* Describe :</li>
* <li>Write date :2011-9-7</li>
* <li>
* Developer :<a href='MailTo:abc-127@qq.com' title='Send to the E-mail'>English
* name is Fd wang</a></li>
* <li>Company :</li>
* </ol>
* </p>
*/
@SuppressWarnings("unchecked")
public class Pager<T> {
private int pageSize = 10;
private int curPage = 1;
private int totalcnt = 0;
private int totalpage = 0;
private List list;
/**
* 排序方式 : desc(倒序) or asc(顺序)
*/
private String orderSort;
/**
* 排序字段
*/
private String orderField;
/**
* 排序方式 : desc(倒序) or asc(顺序)</br>默认为:asc(顺序)
* @return
*/
public String getOrderSort() {
if(orderSort == null || orderSort == ""){
return "asc";
}
if("desc".equals(orderSort.trim().toLowerCase()) || "asc".equals(orderSort.trim().toLowerCase())){
return orderSort;
}
return "asc";
}
public void setOrderSort(String orderSort) {
this.orderSort = orderSort;
}
public String getOrderField() {
return orderField;
}
public void setOrderField(String orderField) {
this.orderField = orderField;
}
public Pager() {
}
public Pager(int pageSize, int curPage) {
this.pageSize = pageSize;
this.curPage = curPage;
}
public int getPageSize() {
return pageSize;
}
public void setPageSize(int pagesize) {
if (pagesize <= 0) {
return;
}
this.pageSize = pagesize;
}
public int getCurPage() {
return curPage;
}
public void setCurrentpage(int curPage) {
if (curPage <= 0) {
return;
}
this.curPage = curPage;
}
public int getTotalcnt() {
return totalcnt;
}
public void setTotalcnt(int totalcnt) {
this.totalcnt = totalcnt;
}
public List<T> getList() {
return list;
}
public void setList(List<T> list) {
this.list = list;
}
public int getTotalpage() {
if (totalcnt == 0) {
totalpage = 0;
} else if (totalcnt % pageSize == 0) {
return totalpage = totalcnt / pageSize;
} else {
return totalpage = totalcnt / pageSize + 1;
}
return totalpage;
}
}