hibernate 封装

爱的色放阿撒旦法撒旦法是否打算分撒旦Template().getSessionFactory()
.getCurrentSession().createQuery(hql).setCacheable(true);
if (values.length != 0) {
for (int i = 0; i < values.length; i++) {
query.setParameter(i, values[i]);
}
}
List list = query.list();
if (!list.isEmpty() && list.size() != 0) {
return (T) list.get(0);
} else {
throw new ObjectRetrievalFailureException(getEntityClass(),
"object not found");
}
}

@SuppressWarnings("unchecked")
public T getByQbc(Criteria criteria) throws DataAccessException {
List list = criteria.list();
if (!list.isEmpty() && list.size() != 0) {
return (T) list.get(0);
} else {
throw new ObjectRetrievalFailureException(getEntityClass(),
"object not found");
}
}

@SuppressWarnings("unchecked")
public T getByQbcForCache(Criteria criteria) throws DataAccessException {
criteria.setCacheable(true);
List list = criteria.list();
if (!list.isEmpty() && list.size() != 0) {
return (T) list.get(0);
} else {
throw new ObjectRetrievalFailureException(getEntityClass(),
"object not found");
}
}

/**
* 查询总记录数
*
* @param countString
* @return int
* @throws DataAccessException
*/
protected int count(final String countString) throws DataAccessException {
return Integer.valueOf(String.valueOf((getHibernateTemplate().find(
countString).get(0))));
}

/**
* 去除select 子句，未考虑union的情况
*/
protected static String removeSelect(String hql) {
Assert.hasText(hql);
int beginPos = hql.toLowerCase().indexOf("from");
Assert.isTrue(beginPos != -1, " hql : " + hql
+ " must has a keyword 'from'");
return hql.substring(beginPos);
}

/**
* 去除orderby 子句
*/
protected static String removeOrders(String hql) {
Assert.hasText(hql);
Pattern p = Pattern.compile("order\\s*by[\\w|\\W|\\s|\\S]*",
Pattern.CASE_INSENSITIVE);
Matcher m = p.matcher(hql);
StringBuffer sb = new StringBuffer();
while (m.find()) {
m.appendReplacement(sb, "");
}
m.appendTail(sb);
return sb.toString();
}

@SuppressWarnings("unchecked")
public List<T> findByQbc(Criteria criteria) throws DataAccessException {
return criteria.list();
}

@SuppressWarnings("unchecked")
public List<T> findByQbcForCache(Criteria criteria)
throws DataAccessException {
criteria.setCacheable(true);
return criteria.list();
}

@SuppressWarnings("unchecked")
public List<T> getByNativeSql(String sql) throws DataAccessException {
List<T> list = getHibernateTemplate().getSessionFactory()
.getCurrentSession().createSQLQuery(sql).addEntity(
getEntityClass()).list();
return list;
}
}