cn.easyproject.easycommons.commondao.CommonDAOSpringImpl Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of easycommondao-jpa-hibernate3 Show documentation
Show all versions of easycommondao-jpa-hibernate3 Show documentation
Java ORM Common DAO(Data Access Object), eliminate the interface and implements of DAO.
The newest version!
package cn.easyproject.easycommons.commondao;
import java.io.Serializable;
import java.lang.reflect.InvocationTargetException;
import java.lang.reflect.Method;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Collection;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Map.Entry;
import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;
import org.hibernate.Hibernate;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.ejb.QueryHints;
import org.hibernate.jdbc.Work;
import org.hibernate.transform.Transformers;
import org.springframework.stereotype.Repository;
import cn.easyproject.easycommons.commondao.util.EasyCriteria;
import cn.easyproject.easycommons.commondao.util.PageBean;
/**
* JPA CommonDAO implement used spring.
*
*
* @author Ray
* @author [email protected]
* @author easyproject.cn
* @since 1.0.0
*
*/
@Repository("commonDAO")
@SuppressWarnings({ "rawtypes", "unchecked" })
public class CommonDAOSpringImpl implements CommonDAO {
@PersistenceContext
private EntityManager entityManager;
@Override
public void batchUpdateSQL(final String sql,final Object[] values) {
entityManager.unwrap(Session.class).doWork(new Work() {
public void execute(Connection connection) throws SQLException {
PreparedStatement pstmt = null;
try {
connection.setAutoCommit(false);// 手动提交
pstmt = connection.prepareStatement(sql);// 预编译
for (int i = 0; i < values.length; i++) {
pstmt.setObject(1, values[i]);
pstmt.addBatch();
}
pstmt.executeBatch();// 将参数加入到批处理
connection.commit();// 提交
} catch (Exception e) {
e.printStackTrace();
} finally {
if (pstmt != null) {
try {
pstmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
try {
if (connection != null && (!connection.isClosed())) {
connection.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
});
}
@Override
public void batchUpdateSQL(final String sql,final Object[][] values) {
entityManager.unwrap(Session.class).doWork(new Work() {
public void execute(Connection connection) throws SQLException {
PreparedStatement pstmt = null;
try {
connection.setAutoCommit(false);// 手动提交
pstmt = connection.prepareStatement(sql);// 预编译
for (Object[] row : values) {
for (int i = 0; i < row.length; i++) {
pstmt.setObject(i + 1, row[i]);
}
pstmt.addBatch();
}
pstmt.executeBatch();// 将参数加入到批处理
connection.commit();// 提交
} catch (Exception e) {
e.printStackTrace();
} finally {
if (pstmt != null) {
try {
pstmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
try {
if (connection != null && (!connection.isClosed())) {
connection.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
});
}
/**
* CommonDAO 内部方法，NamedQuery
*
* @param entityManager
* entityManager
* @param name
* name
* @param cacheable
* cacheable
* @param cacheRegion
* cacheRegion
* @param values
* values
* @return Query对象
*/
private Query createNamedQuery(EntityManager entityManager, String name, boolean cacheable, String cacheRegion,
Map values) {
Query query = entityManager.createNamedQuery(name.trim());
if (cacheable) {
query.setHint(QueryHints.HINT_CACHEABLE, "true");
if (cacheRegion != null && (!cacheRegion.equals(""))) {
query.setHint(QueryHints.HINT_CACHE_REGION, cacheRegion);
}
}
if (values != null && values.size() > 0) {
for (Entry e : values.entrySet()) {
query.setParameter(e.getKey(), e.getValue());
}
}
return query;
}
/**
* CommonDAO 内部方法, NativeQuery
*
* @param entityManager
* entityManager
* @param sql
* sql
* @param values
* values
* @return Query对象
*/
private Query createNativeQuery(EntityManager entityManager, String sql, Class resultClass, boolean mapResult,
Map values) {
Query query = null;
if (resultClass != null) {
query = entityManager.createNativeQuery(sql, resultClass);
} else {
query = entityManager.createNativeQuery(sql);
}
// 封装为Map结果
if (mapResult) {
query.unwrap(org.hibernate.Query.class).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
}
if (values != null && values.size() > 0) {
for (Entry e : values.entrySet()) {
query.setParameter(e.getKey(), e.getValue());
}
}
return query;
}
/**
* CommonDAO 内部方法，Query
*
* @param entityManager
* entityManager
* @param jpql
* jqpl
* @param cacheable
* cacheable
* @param cacheRegion
* cacheRegion
* @param values
* values
* @return Query对象
*/
private Query createQuery(EntityManager entityManager, String jpql, boolean cacheable, String cacheRegion,
Map values) {
Query query = entityManager.createQuery(jpql);
if (cacheable) {
query.setHint(QueryHints.HINT_CACHEABLE, "true");
if (cacheRegion != null && (!cacheRegion.equals(""))) {
query.setHint(QueryHints.HINT_CACHE_REGION, cacheRegion);
}
}
if (values != null && values.size() > 0) {
for (Entry e : values.entrySet()) {
query.setParameter(e.getKey(), e.getValue());
}
}
return query;
}
@Override
public void delete(Class clazz, Serializable id) {
entityManager.remove(entityManager.find(clazz, id));
}
@Override
public void delete(Object o) {
entityManager.remove(o);
}
@Override
public Integer deleteByValues(Class cls, String idFieldName, String[] values) {
int res = 0;
StringBuilder ins = new StringBuilder();
ins.append("'");
for (String v : values) {
ins.append(v).append("','");
}
String jpql = "delete from " + cls.getSimpleName() + " where " + idFieldName + " in("
+ ins.substring(0, ins.length() - 2) + ")";
res = entityManager.createQuery(jpql).executeUpdate();
return res;
}
@Override
public void deleteCascadeByValues(Class cls, String fieldName, String[] values) {
StringBuilder ins = new StringBuilder();
ins.append("'");
for (String v : values) {
ins.append(v).append("','");
}
String jpql = "from " + cls.getSimpleName() + " where " + fieldName + " in("
+ ins.substring(0, ins.length() - 2) + ")";
for (Object o : entityManager.createQuery(jpql).getResultList()) {
entityManager.remove(o);
}
}
@Override
public void evict(Class c) {
entityManager.getEntityManagerFactory().getCache().evict(c);
}
@Override
public void evict(Class c, Serializable id) {
entityManager.getEntityManagerFactory().getCache().evict(c, id);
}
@Override
public void evictAll() {
entityManager.getEntityManagerFactory().getCache().evictAll();
}
@Override
public void evictCollectionRegion(String collectionRegion) {
entityManager.unwrap(SessionFactory.class).getCache()
.evictCollectionRegion(collectionRegion);
}
@Override
public void evictCollectionRegion(String collectionRegion, Serializable id) {
entityManager.unwrap(SessionFactory.class).getCache()
.evictCollection(collectionRegion, id);
}
@Override
public void evictQueries() {
if (null != DEFAULT_QUERY_CACHE_REGION || (!"".equals(DEFAULT_QUERY_CACHE_REGION))) {
entityManager.unwrap(SessionFactory.class).getCache()
.evictQueryRegion(DEFAULT_QUERY_CACHE_REGION);
} else {
entityManager.unwrap(SessionFactory.class).getCache().evictQueryRegions();
}
}
@Override
public void evictQueries(String queryCacheRegion) {
entityManager.unwrap(SessionFactory.class).getCache()
.evictQueryRegion(queryCacheRegion);
}
@Override
public List find(String jpql) {
return find(jpql, new HashMap());
}
@Override
public List find(String jpql, EasyCriteria easyCriteria) {
if (easyCriteria != null) {
return find(jpql + " " + easyCriteria.getCondition(), easyCriteria.getValues());
} else {
return find(jpql, new HashMap());
}
}
@Override
public List find(String jpql, Map values) {
Query q = createQuery(entityManager, jpql, false, null, values);
List list = q.getResultList();
return list;
}
@Override
public List findAll(Class cls) {
String queryString = "from " + cls.getName();
List list = entityManager.createQuery(queryString).getResultList();
initialize(list);
return list;
}
@Override
public List findByCache(String jpql) {
return findByCache(jpql, new HashMap());
}
@Override
public List findByCache(String jpql, EasyCriteria easyCriteria) {
if (easyCriteria != null) {
return findByCache(jpql + " " + easyCriteria.getCondition(), easyCriteria.getValues());
} else {
return findByCache(jpql, new HashMap());
}
}
@Override
public List findByCache(String jpql, Map values) {
String cacheRegion = null;
if (null != DEFAULT_QUERY_CACHE_REGION || (!"".equals(DEFAULT_QUERY_CACHE_REGION))) {
cacheRegion = DEFAULT_QUERY_CACHE_REGION;
}
Query q = createQuery(entityManager, jpql, true, cacheRegion, values);
List list = q.getResultList();
return list;
}
@Override
public List findByCache(String jpql, String queryCacheRegion, EasyCriteria easyCriteria) {
if (easyCriteria != null) {
return findByCache(jpql + " " + easyCriteria.getCondition(), queryCacheRegion, easyCriteria.getValues());
} else {
return findByCache(jpql, queryCacheRegion, new HashMap());
}
}
@Override
public List findByCache(String jpql, String queryCacheRegion) {
return findByCache(jpql, queryCacheRegion, new HashMap());
}
@Override
public List findByCache(String jpql, String queryCacheRegion, Map values) {
Query q = createQuery(entityManager, jpql, true, queryCacheRegion, values);
List list = q.getResultList();
return list;
}
@Override
public void findByPage(PageBean pageBean) {
this.findByPage(pageBean, new HashMap());
}
@Override
public void findByPage(PageBean pageBean, EasyCriteria easyCriteria) {
if (easyCriteria != null) {
pageBean.setCondition(easyCriteria.getCondition());
this.findByPage(pageBean, easyCriteria.getValues());
} else {
this.findByPage(pageBean);
}
}
@Override
public void findByPage(PageBean pageBean, Map values) {
String jpql = pageBean.getQuery() != null ? pageBean.getQuery() : pageBean.getAutoQuery();
Query query = createQuery(entityManager, jpql, false, null, values);
query.setFirstResult(pageBean.getRowStart());
query.setMaxResults(pageBean.getRowsPerPage());
pageBean.setData(query.getResultList());
String queryString = "";
int end = jpql.length();
if (jpql.indexOf("order by") != -1) {
end = jpql.indexOf("order by");
}
if (jpql.toUpperCase().indexOf("SELECT") != -1) {
int i = jpql.toUpperCase().indexOf("FROM");
queryString = "select count(1) " + jpql.substring(i, end);
} else {
queryString = "select count(1) " + jpql.substring(0, end);
}
// 去掉ORDER BY 的部分
int j = queryString.toUpperCase().lastIndexOf("ORDER");
if (j != -1) {
queryString = queryString.substring(0, j);
}
Query cquery = createQuery(entityManager, queryString, false, null, values);
int maxRow = (Integer.valueOf(cquery.getSingleResult().toString())).intValue();
pageBean.setRowsCount(maxRow);
}
@Override
public List findByProperty(Class cls, String propertyName, Object value) {
String queryString = "from " + cls.getName() + " model where model." + propertyName + "= :propetyName";
Map values = new HashMap();
values.put("propetyName", value);
return find(queryString, values);
}
@Override
public List findByPropertyIgnoreCase(Class cls, String propertyName, String value) {
String queryString = "from " + cls.getName() + " model where lower(model." + propertyName + ")= :propetyName";
Map values = new HashMap();
values.put("propetyName", value);
return find(queryString, values);
}
@Override
public List findBySQL(String sql, Class resultClass) {
return findBySQL(sql, resultClass, new HashMap());
}
@Override
public List findBySQL(String sql, Class resultClass, EasyCriteria easyCriteria) {
if (easyCriteria != null) {
return findBySQL(sql + " " + easyCriteria.getCondition(), resultClass, easyCriteria.getValues());
} else {
return findBySQL(sql, resultClass, new HashMap());
}
}
@Override
public List findBySQL(String sql, Class resultClass, Map values) {
Query q = createNativeQuery(entityManager, sql, resultClass, false, values);
List list = q.getResultList();
return list;
}
@Override
public List findBySQL(String sql) {
return findBySQL(sql, new HashMap());
}
@Override
public List findBySQL(String sql, EasyCriteria easyCriteria) {
if (easyCriteria != null) {
return findBySQL(sql + " " + easyCriteria.getCondition(), easyCriteria.getValues());
} else {
return findBySQL(sql, new HashMap());
}
}
@Override
public List findBySQL(String sql, Map values) {
Query q = createNativeQuery(entityManager, sql, null, false, values);
List list = q.getResultList();
return list;
}
@Override
public int findCount(String jpql) {
return findCount(jpql, new HashMap());
}
@Override
public int findCount(String jpql, EasyCriteria easyCriteria) {
if (easyCriteria != null) {
return findCount(jpql + " " + easyCriteria.getCondition(), easyCriteria.getValues());
} else {
return findCount(jpql, new HashMap());
}
}
@Override
public int findCount(String jpql, Map values) {
Query q = createQuery(entityManager, jpql, false, null, values);
return Integer.valueOf(q.getSingleResult().toString());
}
public List findMapResultBySQL(String sql) {
return findMapResultBySQL(sql, new HashMap());
}
public List findMapResultBySQL(String sql, EasyCriteria easyCriteria) {
if (easyCriteria != null) {
return findMapResultBySQL(sql + " " + easyCriteria.getCondition(), easyCriteria.getValues());
} else {
return findMapResultBySQL(sql, new HashMap());
}
}
public List findMapResultBySQL(String sql, Map values) {
Query q = createNativeQuery(entityManager, sql, null, true, values);
List list = q.getResultList();
return list;
}
@Override
public int findMaxPage(String jpql, int rowsPerPage) {
return (this.findCount(jpql, new HashMap()) - 1) / rowsPerPage + 1;
}
@Override
public int findMaxPage(String jpql, int rowsPerPage, EasyCriteria easyCriteria) {
return (this.findCount(jpql, easyCriteria) - 1) / rowsPerPage + 1;
}
@Override
public int findMaxPage(String jpql, int rowsPerPage, Map values) {
return (this.findCount(jpql, values) - 1) / rowsPerPage + 1;
}
@Override
public List findNamedQuery(String name) {
Query q = createNamedQuery(entityManager, name, false, null, new HashMap());
return q.getResultList();
}
@Override
public List findNamedQuery(String name, Map values) {
Query q = createNamedQuery(entityManager, name, false, null, values);
return q.getResultList();
}
@Override
public List findNamedQueryByCache(String name, String queryCacheRegion, Map values) {
Query q = createNamedQuery(entityManager, name, true, queryCacheRegion, values);
return q.getResultList();
}
@Override
public List findTop(String jpql, int topCount) {
return findTop(jpql, topCount, new HashMap());
}
@Override
public List findTop(String jpql, int topCount, EasyCriteria easyCriteria) {
if (easyCriteria != null) {
return findTop(jpql + " " + easyCriteria.getCondition(), topCount, easyCriteria.getValues());
} else {
return findTop(jpql, topCount, new HashMap());
}
}
@Override
public List findTop(String jpql, int topCount, Map values) {
Query query = entityManager.createQuery(jpql);
query.setFirstResult(0);
query.setMaxResults(topCount);
if (values != null && values.size() > 0) {
for (Entry e : values.entrySet()) {
query.setParameter(e.getKey(), e.getValue());
}
}
List list = query.getResultList();
return list;
}
@Override
public T findVal(String jpql) {
List list = this.find(jpql, new HashMap());
return (T) (list.size() > 0 ? list.get(0) : null);
}
@Override
public T findVal(String jpql, EasyCriteria easyCriteria) {
List list = this.find(jpql, easyCriteria);
return (T) (list.size() > 0 ? list.get(0) : null);
}
@Override
public T findVal(String jpql, Map values) {
List list = this.find(jpql, values);
return (T) (list.size() > 0 ? list.get(0) : null);
}
@Override
public T find(Class clazz, Serializable id) {
return (T) entityManager.find(clazz, id);
}
@Override
public EntityManager getCurrentEntityManager() {
return entityManager;
}
@Override
public EntityManagerFactory getEntityManagerFactory() {
return entityManager.getEntityManagerFactory();
}
@Override
public void initialize(Object proxy) {
if (!Hibernate.isInitialized(proxy)) {
Hibernate.initialize(proxy);
}
}
@Override
public void initializeDeep(Collection collection) {
if (collection == null) {
return;
}
for (Object obj : collection) {
Method[] methods = obj.getClass().getMethods();
if (methods != null) {
for (int j = 0; j < methods.length; j++) {
String getName = methods[j].getName();
if (getName.length() > 3 && getName.startsWith("get")) {
String getFix = getName.substring(3, getName.length());
for (int k = 0; k < methods.length; k++) {
String setName = methods[k].getName();
if (setName.length() > 3 && setName.startsWith("set")) {
String setFix = setName.substring(3, setName.length());
if (getFix.equals(setFix)) {
try {
Object o = methods[j].invoke(obj, new Object[0]);
if (o != null) {
Hibernate.initialize(o);
methods[k].invoke(obj, o);
}
} catch (IllegalArgumentException e) {
e.printStackTrace();
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (InvocationTargetException e) {
e.printStackTrace();
}
}
}
}
}
}
}
}
}
@Override
public void merge(Object o) {
entityManager.merge(o);
}
@Override
public void persist(Object o) {
entityManager.persist(o);
}
@Override
public void updateByJpql(String jpql) {
updateByJpql(jpql, new HashMap());
}
@Override
public void updateByJpql(String jpql, Map values) {
Query query = entityManager.createQuery(jpql);
if (values != null && values.size() > 0) {
for (Entry e : values.entrySet()) {
query.setParameter(e.getKey(), e.getValue());
}
}
query.executeUpdate();
}
@Override
public void updateBySQL(String sql) {
updateBySQL(sql, new HashMap());
}
@Override
public void updateBySQL(String sql, Map values) {
Query query = entityManager.createNativeQuery(sql);
if (values != null && values.size() > 0) {
for (Entry e : values.entrySet()) {
query.setParameter(e.getKey(), e.getValue());
}
}
query.executeUpdate();
}
} © 2015 - 2025 Weber Informatics LLC | Privacy Policy