package com.iteye.tianshi.core.web.dao;
import java.io.Serializable;
import java.util.Collection;
import java.util.List;
import java.util.Map;
import org.hibernate.LockMode;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
import org.springframework.orm.hibernate3.HibernateTemplate;
import com.iteye.tianshi.core.page.Page;
import com.iteye.tianshi.core.page.PageRequest;
import com.iteye.tianshi.core.util.SQLOrderMode;
/**
* 提供了常用增删改查(CRUD)功能的DAO基础接口。<BR>
* 实体状态说明:
*
* <pre>
* 持久化状态:已经被持久化了且与当前Session关联的实体状态。
* 临时状态:没有被持久化过的实体状态。
* 游离状态:已经被持久化,但是没有与当前Session关联的实体对象,且有相同标识的对象与当前Session关联。
* </pre>
*
* @datetime 2010-7-6 下午08:19:49
* @author jiangzx@yahoo.com
*/
public interface GenericDao<E, PK extends Serializable> {
/**
* 按照实体类型和实体唯一标识查询实体。
* @param id
* @return
*/
public E find(PK id);
/**
* 按照实体类型和实体唯一标识查询实体,并锁定该实体对象,直到事务结束。
* @param id
* @param lockMode
* @return
*/
public E findAndLock(PK id, LockMode lockMode);
/**
* 删除实体主键id标识的实体。
*
* @param id
*/
public void delete(PK id);
/**
* 持久化一个实体。
*
* @param entity 处于临时状态的实体。
*/
public void create(E entity);
/**
* 持久化多个实体。
*
* @param entities 处于临时状态的实体的集合。
*/
public void create(Collection<E> entities);
/**
* 更新实体。
*
* @param entity 处于持久化状态的实体。
*/
public void update(E entity);
/**
* 更新多个实体。
*
* @param entities 处于持久化状态的实体的集合。
*/
public void update(Collection<E> entities);
/**
* 持久化或者更新实体。
*
* @param entity 处于临时或者持久化状态的实体。
*/
public void createOrUpdate(E entity);
/**
* 持久化或者更新多个实体。
*
* @param entities 处于临时或者持久化状态的实体的集合。
*/
public void createOrUpdate(Collection<E> entities);
/**
* 更新处于游离状态的实体,更新后实体对象仍然处于游离状态。
*
* @param entity 处于游离状态的实体。
*/
public void merge(E entity);
/**
* 保存处于游离状态的多个实体,更新后实体对象仍然处于游离状态。
*
* @param entities 处于游离状态的实体的集合。
*/
public void merge(Collection<E> entities);
/**
* 删除一个持久化的实体。
*
* @param entity 处于持久化状态的实体。
*/
public void delete(E entity);
/**
* 删除多个持久化的实体。
*
* @param entities 处于持久化状态的实体的集合。
*/
public void delete(Collection<E> entities);
/**
* 批量删除
*
* @param entity
* @param propertyNames
* @param values
*/
public void bulkDelete(Class<E> clazz, String[] propertyNames, Object[] values);
/**
* 刷新持久化实体到数据库
*
* @param entity 处于持久化状态的实体。
*/
public void refresh(Object entity);
/**
* 按照泛型的实体类型查询得到所有持久化实体。
*
* @return 所有持久化实体的集合
*/
public List<E> findAll();
/**
* 查询出所有的持久化实体,并排序
*
* @param orderCol 排序字段
* @param orderMode 排序模式(降序或升序)
* @return 所有持久化实体的集合
*/
public List<E> findByOrder(String orderCol, SQLOrderMode orderMode);
/**
* 根据属性名称与值,查询出所有满足条件的持久化实体,并排序
*
* @param propertyName 属性名称
* @param value 属性值
* @param orderCol 排序字段
* @param orderMode 排序模式(降序或升序)
* @return 所有持久化实体的集合
*/
public List<E> findByPropertyAndOrder(String propertyName, Object value, String orderCol, SQLOrderMode orderMode);
/**
* 根据属性名称与值,查询出所有满足条件的持久化实体,并排序
*
* @param propertyName 属性名称
* @param value 属性值
* @param orderCol 排序字段
* @param orderMode 排序模式(降序或升序)
* @return 所有持久化实体的集合
*/
public List<E> findByPropertysAndOrders(String[] joinEntitys,String[] propertyNames, Object[] values, String[] orderCol, SQLOrderMode orderMode);
/**
* 根据多对属性名称与值,查询出所有满足条件的持久化实体,并排序
*
* @param propertyNames 属性名称
* @param values 属性值
* @param orderCol 排序字段
* @param orderMode 排序模式(降序或升序)
* @return 所有持久化实体的集合
*/
public List<E> findByPropertysAndOrder(String[] propertyNames, Object[] values, String orderCol, SQLOrderMode orderMode);
/**
* 根据多对属性名称与值,查询出所有满足条件的持久化实体,并排序
*
* @param joinEntitys 连接查询的实体名称
* @param propertyNames 属性名称
* @param values 属性值
* @param orderCol 排序字段
* @param orderMode 排序模式(降序或升序)
* @return 所有持久化实体的集合
*/
public List<E> findByPropertysAndOrder(String[] joinEntitys, String[] propertyNames, Object[] values, String orderCol, SQLOrderMode orderMode);
/**
* 根据属性名称与值,查询出所有满足条件的持久化实体
*
* @param propertyName 属性名称
* @param value 属性值
* @return 所有持久化实体的集合
*/
public List<E> findByProperty(String propertyName, Object value);
/**
* 根据多对属性名称与值,查询出所有满足条件的持久化实体
*
* @param propertyNames 属性名称
* @param values 属性值
* @return 所有持久化实体的集合
* @throws DataAccessException
*/
public List<E> findByPropertys(String[] propertyNames, Object[] values);
/**
* 按照泛型的实体类型,分页查询得到所有持久化实体。
* @return 所有持久化实体的集合
*/
Page<E> findAllForPage(PageRequest<E> pageRequest);
/**
* 查询结果返回为长整形
*
* @param queryString HQL语句
* @return
*/
public Long queryForLong(final String queryString);
/**
* 查询结果返回为长整形
*
* @param queryString HQL语句
* @param values HQL语句参数
* @return
*/
public Long queryForLong(final String queryString, Object... values);
/**
* 查询结果返回为类型T
*
* @param requiredType 返回数据类型
* @param queryString HQL语句
* @return
*/
public <T> T queryForObject(Class<T> requiredType, final String queryString);
/**
* 查询结果返回为类型T
*
* @param requiredType 返回数据类型
* @param queryString HQL语句
* @param values HQL语句参数
* @return
*/
public <T> T queryForObject(Class<T> requiredType, final String queryString, Object... values);
/**
* 使用HSQL语句直接增加、更新、删除实体
*
* @param queryString HQL语句
* @return
*/
public int bulkUpdate(String queryString);
/**
* 使用带参数HSQL语句直接增加、更新、删除实体
*
* @param queryString HQL语句
* @param values HQL语句参数
* @return
*/
public int bulkUpdate(String queryString, Object... values);
/**
* 使用HSQL语句检索数据
*
* @param queryString HQL语句
* @return
*/
public List<?> find(String queryString);
/**
* 使用带参数的HSQL语句检索数据
*
* @param queryString HQL语句
* @param values HQL语句参数
* @return
*/
public List<?> find(String queryString, Object... values);
/**
* 使用带命名的参数的HSQL语句检索数据
*
* @param queryString
* @param paramNames
* @param values
* @return
*/
public List<?> findByNamedParam(String queryString, String[] paramNames,
Object[] values);
/**
* 使用命名的HSQL语句检索数据
*
* @param queryName
* @return
*/
public List<?> findByNamedQuery(String queryName);
/**
* 使用带参数的命名HSQL语句检索数据
*
* @param queryName
* @param values
* @return
*/
public List<?> findByNamedQuery(String queryName, Object[] values);
/**
* 使用带命名参数的命名HSQL语句检索数据
*
* @param queryName
* @param paramNames
* @param values
* @return
*/
public List<?> findByNamedQueryAndNamedParam(String queryName,
String[] paramNames, Object[] values);
/**
* 判断对象某些属性的值在数据库中是否唯一.
*
* @param uniquePropertyNames
* 在POJO里不能重复的属性列表,以逗号分割 如"name,loginid,password"
*/
public boolean isUnique(E entity, String uniquePropertyNames);
/**
* 执行存储过程
* 使用Spring JDBC 来调用存储过程
*
* @param spName 存储过程名称
* @param parameters 存储过程参数
*/
public void execute(String spName, Map<String, Object> parameters);
/**
* 执行存储过程
* 使用Spring JDBC 来调用存储过程
*
* @param spName 存储过程名称
* @throws DataAccessException
*/
public void execute(String spName);
/**
*
* @return NamedParameterJdbcTemplate
*/
public NamedParameterJdbcTemplate getNamedParameterJdbcTemplate();
/**
*
* @return JdbcTemplate
*/
public JdbcTemplate getJdbcTemplate();
/**
* return HiberTemplate
*/
public HibernateTemplate getHiberTemplate();
}
---------------------------------------------------------------------------------------GenericDaoImpl------------------------------------------------------------------------
package com.iteye.tianshi.core.web.dao;
import java.io.Serializable;
import java.lang.reflect.ParameterizedType;
import java.lang.reflect.Type;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import org.apache.commons.beanutils.PropertyUtils;
import org.apache.commons.lang.text.StrBuilder;
import org.hibernate.Criteria;
import org.hibernate.LockMode;
import org.hibernate.Query;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.dao.DataRetrievalFailureException;
import org.springframework.dao.support.DataAccessUtils;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
import org.springframework.orm.hibernate3.HibernateTemplate;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.Assert;
import org.springframework.util.ReflectionUtils;
import org.springframework.util.StringUtils;
import com.iteye.tianshi.core.page.Page;
import com.iteye.tianshi.core.page.PageRequest;
import com.iteye.tianshi.core.util.BlankMode;
import com.iteye.tianshi.core.util.LikeMode;
import com.iteye.tianshi.core.util.SQLOrderMode;
/**
* 基于Hibernate的Crud DAO基础实现,所有使用Hibernate并支持Crud操作的DAO都继承该类。<BR>
* 可用的异常类如下:
*
* <pre>
* DataAccessException
* CleanupFailureDataAccessException
* ConcurrencyFailureException
* OptimisticLockingFailureException
* ObjectOptimisticLockingFailureException
* HibernateOptimisticLockingFailureException
* PessimisticLockingFailureException
* CannotAcquireLockException
* CannotSerializeTransactionException
* DeadlockLoserDataAccessException
* DataAccessResourceFailureException
* CannotCreateRecordException
* CannotGetCciConnectionException
* CannotGetJdbcConnectionException
* DataIntegrityViolationException
* DataRetrievalFailureException
* IncorrectResultSetColumnCountException
* IncorrectResultSizeDataAccessException
* EmptyResultDataAccessException
* LobRetrievalFailureException
* ObjectRetrievalFailureException
* HibernateObjectRetrievalFailureException
* DataSourceLookupFailureException
* InvalidDataAccessApiUsageException
* InvalidDataAccessResourceUsageException
* BadSqlGrammarException
* CciOperationNotSupportedException
* HibernateQueryException
* IncorrectUpdateSemanticsDataAccessException
* JdbcUpdateAffectedIncorrectNumberOfRowsException
* InvalidResultSetAccessException
* InvalidResultSetAccessException
* RecordTypeNotSupportedException
* TypeMismatchDataAccessException
* PermissionDeniedDataAccessException
* UncategorizedDataAccessException
* HibernateJdbcException
* HibernateSystemException
* SQLWarningException
* UncategorizedSQLException
* </pre>
*
* @datetime 2010-7-6 下午11:00:00
* @author jiangzx@yahoo.com
*/
public class GenericDaoImpl<E, PK extends Serializable> extends HibernateDaoSupport implements GenericDao<E, PK> {
@Autowired(required=false)
protected NamedParameterJdbcTemplate namedParameterJdbcTemplate;
@Autowired(required=false)
protected JdbcTemplate jdbcTemplate;
protected Class<E> clazz;
@SuppressWarnings("unchecked")
public GenericDaoImpl() {
Type type = getClass().getGenericSuperclass();
if (type instanceof ParameterizedType) {
clazz = (Class<E>) ((ParameterizedType) type).getActualTypeArguments()[0];
}
}
/**
* 获得DAO类对应的实体类型
*/
protected Class<E> getClazz() {
return clazz;
}
public E find(PK id) {
return (E) super.getHibernateTemplate().get(this.getClazz(), id);
}
public void delete(PK id) {
E entity = this.find(id);
if (entity == null) {
throw new DataRetrievalFailureException("No entity found for deletion: " + id);
}
super.getHibernateTemplate().delete(entity);
}
public E findAndLock(PK id, LockMode lockMode) {
E entity = (E) this.getHibernateTemplate().get(this.getClazz(), id, lockMode);
return entity;
}
public void create(E entity) {
super.getHibernateTemplate().save(entity);
}
public void create(Collection<E> entities) {
for(E entity : entities) {
create(entity);
}
}
public void createOrUpdate(E entity) {
super.getHibernateTemplate().saveOrUpdate(entity);
}
public void createOrUpdate(Collection<E> entities) {
for(E entity : entities) {
createOrUpdate(entity);
}
}
public void delete(E entity) {
super.getHibernateTemplate().delete(entity);
}
@Transactional(readOnly=false)
public void delete(Collection<E> entities) {
for(E entity : entities) {
delete(entity);
}
}
public void bulkDelete(Class<E> clazz, String[] propertyNames, Object[] values) {
StrBuilder buf = new StrBuilder();
String entityName = clazz.getSimpleName();
buf.append("delete " + entityName);// 实体名称
int len = propertyNames.length;
for(int i=0; i<len; i++) {
if(i==0)
buf.append(" WHERE ").append(propertyNames[i]).append(" = :").append(propertyNames[i]);
else
buf.append(" and ").append(propertyNames[i]).append(" = :").append(propertyNames[i]);
}
Query query = this.getSession().createQuery(buf.toString());
for(int i=0; i<len; i++) {
query.setParameter(propertyNames[i], values[i]);
}
query.executeUpdate();
}
public void merge(E entity) {
super.getHibernateTemplate().merge(entity);
}
public void merge(Collection<E> entities) {
for(E entity : entities) {
merge(entity);
}
}
public void update(E entity) {
super.getHibernateTemplate().update(entity);
}
public void update(Collection<E> entities) {
for(E entity : entities) {
update(entity);
}
}
public void refresh(Object entity) {
super.getHibernateTemplate().refresh(entity);
}
public List<E> findAll() {
return this.findByPropertysAndOrder(new String[]{}, new String[]{}, new Object[]{}, null, SQLOrderMode.NOSORT);
}
public List<E> findByOrder(String orderCol, SQLOrderMode orderMode) {
Assert.hasText(orderCol, "orderCol not text");
Assert.notNull(orderMode, "orderMode not null");
return this.findByPropertysAndOrder(new String[]{}, new String[]{}, new Object[]{}, orderCol, orderMode);
}
public List<E> findByPropertyAndOrder(String propertyName, Object value, String orderCol, SQLOrderMode orderMode) {
Assert.hasText(propertyName);
Assert.notNull(value);
Assert.hasText(orderCol, "orderCol not text");
Assert.notNull(orderMode, "orderMode not null");
return this.findByPropertysAndOrder(new String[]{}, new String[]{propertyName}, new Object[]{value}, orderCol, orderMode);
}
public List<E> findByPropertysAndOrder(String[] propertyNames, Object[] values, String orderCol, SQLOrderMode orderMode) {
Assert.state(propertyNames.length == values.length);
Assert.hasText(orderCol, "orderCol not text");
Assert.notNull(orderMode, "orderMode not null");
return this.findByPropertysAndOrder(new String[]{}, propertyNames, values, orderCol, orderMode);
}
@SuppressWarnings("unchecked")
public List<E> findByPropertysAndOrder(String[] joinEntitys, String[] propertyNames, Object[] values, String orderCol, SQLOrderMode orderMode) {
StrBuilder buf = new StrBuilder();
String entityName = this.getClazz().getSimpleName();
String postName = entityName.toLowerCase();
buf.append("FROM " + entityName + " as " + postName + " ");// 实体名称
if(joinEntitys != null) {
for(String je : joinEntitys) {
buf.append(" left outer join fetch " + postName + "." + je + " " + je + " ");
}
}
int len = propertyNames.length;
List<String> propertyNameList = new ArrayList<String>(propertyNames.length);
List<Object> valueList = new ArrayList<Object>(values.length);
if(len>0) {
for(int i=0; i<len; i++) {
//如果是级联属性标示(例如:entitytype.id"),需要替换.为下划线
String old = propertyNames[i];
propertyNames[i] = propertyNames[i].replaceAll("\\.", "_");
if(i==0)
buf.append(" WHERE ");
else
buf.append(" and ");
Object value = values[i];
if(BlankMode.NULL == value)
buf.append(old).append(" is null ");
else if(BlankMode.NOTNULL == value)
buf.append(old).append(" is not null");
else if(LikeMode.LEFT == value) {
buf.append(old).append(" like :").append(propertyNames[i]);
propertyNameList.add(propertyNames[i]);
valueList.add("%" + values[i]);
} else if(LikeMode.RIGHT == value) {
buf.append(old).append(" like :").append(propertyNames[i]);
propertyNameList.add(propertyNames[i]);
valueList.add(values[i] + "%");
} else if(LikeMode.ALL == value) {
buf.append(old).append(" like :").append(propertyNames[i]);
propertyNameList.add(propertyNames[i]);
valueList.add("%" + values[i] + "%");
} else {
buf.append(old).append(" = :").append(propertyNames[i]);
propertyNameList.add(propertyNames[i]);
valueList.add(values[i]);
}
}
}
//添加排序字段
if(StringUtils.hasText(orderCol) && SQLOrderMode.NOSORT != orderMode)
buf.append(" ORDER BY ").append(orderCol).append(" ").append(orderMode.getMode());
String[] properties = new String[propertyNameList.size()];
for(int i=0, count=propertyNameList.size(); i<count; i++) {
properties[i] = propertyNameList.get(i);
}
return this.getHibernateTemplate().findByNamedParam(buf.toString(), properties, valueList.toArray());
}
public List<E> findByProperty(String propertyName, Object value) {
Assert.hasText(propertyName);
Assert.notNull(value);
return this.findByPropertysAndOrder(new String[]{}, new String[]{propertyName}, new Object[]{value}, null, SQLOrderMode.NOSORT);
}
public List<E> findByPropertys(String[] propertyNames, Object[] values) {
Assert.state(propertyNames.length == values.length);
return this.findByPropertysAndOrder(new String[]{}, propertyNames, values, null, SQLOrderMode.NOSORT);
}
public Page<E> findAllForPage(final PageRequest<E> pageRequest) {
StringBuilder queryString = new StringBuilder(" FROM ");
StringBuilder countQueryString = new StringBuilder(" FROM ");
String entityName = this.getClazz().getSimpleName();
String postName = entityName.toLowerCase();
queryString.append(entityName + " as " + postName + " ");// 实体名称
countQueryString.append(entityName);// 实体名称
for(String je : pageRequest.getJoinEntitys()) {
queryString.append("left outer join fetch " + postName + "." + je + " " + je + " ");
}
//等于查询条件
Map<String, Object> paramMap = pageRequest.getFilters();
boolean hasWhere = false;
if (paramMap != null && paramMap.size() > 0) {
queryString.append(" WHERE ");
countQueryString.append(" WHERE ");
Iterator<String> keys = paramMap.keySet().iterator();
for (int i = 0; keys.hasNext(); i++) {
if (hasWhere) {
queryString.append(" AND ");
countQueryString.append(" AND ");
} else
hasWhere = true;
String paramName = keys.next();
queryString.append(paramName).append(" =:").append(paramName);
countQueryString.append(paramName).append(" =:").append(paramName);
}
}
//Like查询条件
Map<String, String> likeParamMap = pageRequest.getLikeFilters();
if (likeParamMap != null && likeParamMap.size() > 0) {
// 增加查询条件
if(!hasWhere) {
queryString.append(" WHERE ");
countQueryString.append(" WHERE ");
}
Iterator<String> keys = likeParamMap.keySet().iterator();
for (int i = 0; keys.hasNext(); i++) {
if (hasWhere) {
queryString.append(" AND ");
countQueryString.append(" AND ");
} else
hasWhere = true;
String paramName = keys.next();
queryString.append(paramName).append(" like :").append(paramName);
countQueryString.append(paramName).append(" like :").append(paramName);
}
}
//时间范围条件
String timeField = pageRequest.getTimeField();
if(StringUtils.hasText(timeField)) {
if(pageRequest.getStartTime() != null) {
if(!hasWhere) {
queryString.append(" WHERE ");
countQueryString.append(" WHERE ");
hasWhere = true;
} else {
queryString.append(" AND ");
countQueryString.append(" AND ");
}
queryString.append(timeField).append(" >= :startTime");
countQueryString.append(timeField).append(" >= :startTime");
}
if(pageRequest.getEndTime() != null) {
if(!hasWhere) {
queryString.append(" WHERE ");
countQueryString.append(" WHERE ");
hasWhere = true;
} else {
queryString.append(" AND ");
countQueryString.append(" AND ");
}
queryString.append(timeField).append(" <= :endTime");
countQueryString.append(timeField).append(" <= :endTime");
}
}
if(pageRequest.getExtraCondition() != null) {
if(!hasWhere) {
queryString.append(" WHERE ");
countQueryString.append(" WHERE ");
hasWhere = true;
} else {
queryString.append(" AND ");
countQueryString.append(" AND ");
}
queryString.append(pageRequest.getExtraCondition());
countQueryString.append(pageRequest.getExtraCondition());
}
//排序字段
if (org.springframework.util.StringUtils.hasText(pageRequest.getSortColumns())) {
queryString.append(" ORDER BY " + pageRequest.getSortColumns());
}
//创建查询Query
Query query = this.getSession().createQuery(queryString.toString());
Query countQuery = this.getSession().createQuery("SELECT count(*) " + countQueryString.toString());
//设置参数
if (paramMap != null && paramMap.size() > 0) {
Iterator<String> keys = paramMap.keySet().iterator();
for (int i = 0; keys.hasNext(); i++) {
String key = keys.next();
query.setParameter(key, paramMap.get(key));
countQuery.setParameter(key, paramMap.get(key));
}
}
if (likeParamMap != null && likeParamMap.size() > 0) {
Iterator<String> keys = likeParamMap.keySet().iterator();
for (int i = 0; keys.hasNext(); i++) {
String key = keys.next();
String value = "%" + likeParamMap.get(key) + "%";
query.setParameter(key, value);
countQuery.setParameter(key, value);
}
}
//时间范围条件参数
if(StringUtils.hasText(timeField)) {
if(pageRequest.getStartTime() != null) {
query.setParameter("startTime", pageRequest.getStartTime());
countQuery.setParameter("startTime", pageRequest.getStartTime());
}
if(pageRequest.getEndTime() != null) {
query.setParameter("endTime", pageRequest.getEndTime());
countQuery.setParameter("endTime", pageRequest.getEndTime());
}
}
return executeQueryForPage(pageRequest, query, countQuery);
}
public int bulkUpdate(String queryString, Object... values) {
return super.getHibernateTemplate().bulkUpdate(queryString, values);
}
public int bulkUpdate(String queryString) {
return super.getHibernateTemplate().bulkUpdate(queryString);
}
public List<?> find(String queryString, Object... values) {
return super.getHibernateTemplate().find(queryString, values);
}
public List<?> find(String queryString) {
return super.getHibernateTemplate().find(queryString);
}
public List<?> findByNamedParam(String queryString, String[] paramNames, Object[] values) {
return super.getHibernateTemplate().findByNamedParam(queryString, paramNames, values);
}
public List<?> findByNamedQuery(String queryName, Object[] values) {
return super.getHibernateTemplate().findByNamedQuery(queryName, values);
}
public List<?> findByNamedQuery(String queryName) {
return super.getHibernateTemplate().findByNamedQuery(queryName);
}
public List<?> findByNamedQueryAndNamedParam(String queryName, String[] paramNames, Object[] values) {
return super.getHibernateTemplate().findByNamedQueryAndNamedParam(queryName, paramNames, values);
}
public Long queryForLong(String queryString, Object... values) {
return DataAccessUtils.longResult(getHibernateTemplate().find(queryString, values));
}
public Long queryForLong(String queryString) {
return queryForLong(queryString, new Object[] {});
}
public <T> T queryForObject(Class<T> requiredType, String queryString) {
return queryForObject(requiredType, queryString, new Object[] {});
}
public <T> T queryForObject(Class<T> requiredType, String queryString, Object... values) {
return DataAccessUtils.objectResult(getHibernateTemplate().find(queryString, values), requiredType);
}
public boolean isUnique(E entity, String uniquePropertyNames) {
Assert.hasText(uniquePropertyNames);
Criteria criteria = getSession().createCriteria(this.getClazz()).setProjection(Projections.rowCount());
String[] nameList = uniquePropertyNames.split(",");
try {
// 循环加入唯一列
for (int i = 0; i < nameList.length; i++) {
criteria.add(Restrictions.eq(nameList[i], PropertyUtils.getProperty(entity, nameList[i])));
}
} catch (Exception e) {
ReflectionUtils.handleReflectionException(e);
}
return ((Number) criteria.uniqueResult()).intValue() == 1;
}
public void execute(String spName, Map<String, Object> parameters) {
}
public void execute(String spName) {
}
//--------------------------------------------private methods--------------------------------------------------
@SuppressWarnings("unchecked")
public <T> Page<T> executeQueryForPage(final PageRequest<T> pageRequest, Query query, Query countQuery) {
Page<T> page = new Page<T>(pageRequest, ((Number) countQuery.uniqueResult()).intValue());
if (page.getTotalCount() <= 0) {
page.setResult(new ArrayList<T>(0));
} else {
page.setResult(query.setFirstResult(page.getFirstResult()).setMaxResults(page.getPageSize()).list());
}
return page;
}
public NamedParameterJdbcTemplate getNamedParameterJdbcTemplate() {
return namedParameterJdbcTemplate;
}
@Override
public JdbcTemplate getJdbcTemplate() {
return jdbcTemplate;
}
@Override
public HibernateTemplate getHiberTemplate() {
return this.getHibernateTemplate();
}
/**
* 增加多个字段的排序方法
*/
@SuppressWarnings("unchecked")
public List<E> findByPropertysAndOrders(String[] joinEntitys, String[] propertyNames, Object[] values, String[] orderCol, SQLOrderMode orderMode) {
StrBuilder buf = new StrBuilder();
String entityName = this.getClazz().getSimpleName();
String postName = entityName.toLowerCase();
buf.append("FROM " + entityName + " as " + postName + " ");// 实体名称
if(joinEntitys != null) {
for(String je : joinEntitys) {
buf.append(" left outer join fetch " + postName + "." + je + " " + je + " ");
}
}
int len = propertyNames.length;
List<String> propertyNameList = new ArrayList<String>(propertyNames.length);
List<Object> valueList = new ArrayList<Object>(values.length);
if(len>0) {
for(int i=0; i<len; i++) {
//如果是级联属性标示(例如:entitytype.id"),需要替换.为下划线
String old = propertyNames[i];
propertyNames[i] = propertyNames[i].replaceAll("\\.", "_");
if(i==0)
buf.append(" WHERE ");
else
buf.append(" and ");
Object value = values[i];
if(BlankMode.NULL == value)
buf.append(old).append(" is null ");
else if(BlankMode.NOTNULL == value)
buf.append(old).append(" is not null");
else if(LikeMode.LEFT == value) {
buf.append(old).append(" like :").append(propertyNames[i]);
propertyNameList.add(propertyNames[i]);
valueList.add("%" + values[i]);
} else if(LikeMode.RIGHT == value) {
buf.append(old).append(" like :").append(propertyNames[i]);
propertyNameList.add(propertyNames[i]);
valueList.add(values[i] + "%");
} else if(LikeMode.ALL == value) {
buf.append(old).append(" like :").append(propertyNames[i]);
propertyNameList.add(propertyNames[i]);
valueList.add("%" + values[i] + "%");
} else {
buf.append(old).append(" = :").append(propertyNames[i]);
propertyNameList.add(propertyNames[i]);
valueList.add(values[i]);
}
}
}
//添加排序字段
if (orderCol!=null&&orderCol.length>=0) {
buf.append(" ORDER BY ");
for(int k=0;k<orderCol.length-1;k++){
buf.append(orderCol[k]).append(" ").append(orderMode.getMode()+",");
}
buf.append(orderCol[orderCol.length-1]).append(" ").append(orderMode.getMode());
}
String[] properties = new String[propertyNameList.size()];
for(int i=0, count=propertyNameList.size(); i<count; i++) {
properties[i] = propertyNameList.get(i);
}
return this.getHibernateTemplate().findByNamedParam(buf.toString(), properties, valueList.toArray());
}
}