AliasToBeanResultTransformer.java
package com.heren.his.commons.util; import org.hibernate.HibernateException;//hibernate-core-5.0.1.Final.jar import org.hibernate.engine.spi.SessionFactoryImplementor;//hibernate-core-5.0.1.Final.jar import org.hibernate.property.access.internal.PropertyAccessStrategyBasicImpl;//hibernate-core-5.0.1.Final.jar import org.hibernate.property.access.internal.PropertyAccessStrategyChainedImpl;//hibernate-core-5.0.1.Final.jar import org.hibernate.property.access.internal.PropertyAccessStrategyFieldImpl;//hibernate-core-5.0.1.Final.jar import org.hibernate.property.access.internal.PropertyAccessStrategyMapImpl;//hibernate-core-5.0.1.Final.jar import org.hibernate.property.access.spi.PropertyAccessStrategy;//hibernate-core-5.0.1.Final.jar import org.hibernate.property.access.spi.Setter;//hibernate-core-5.0.1.Final.jar import org.hibernate.transform.AliasedTupleSubsetResultTransformer;//hibernate-core-5.0.1.Final.jar import java.math.BigDecimal; import java.math.BigInteger; import java.util.Arrays; public class AliasToBeanResultTransformer extends AliasedTupleSubsetResultTransformer { private final Class resultClass; private boolean isInitialized; private String[] aliases; private Setter[] setters; public AliasToBeanResultTransformer(Class resultClass) { if(resultClass == null) { throw new IllegalArgumentException("resultClass cannot be null"); } else { this.isInitialized = false; this.resultClass = resultClass; } } public boolean isTransformedValueATupleElement(String[] aliases, int tupleLength) { return false; } public Object transformTuple(Object[] tuple, String[] aliases) { try { this.aliases = new String[aliases.length]; for(int i = 0; i < aliases.length; ++i) { aliases[i] = StringUtils.toHumpName(aliases[i]); if(aliases[i] != null) { this.aliases[i] = aliases[i]; } } if(!this.isInitialized) { this.initialize(aliases); } else { this.check(aliases); } Object result = this.resultClass.newInstance(); for (int i = 0; i < aliases.length; i++) { if (setters[i] != null) { Class<?> aClass = setters[i].getMethod().getParameterTypes()[0]; Object temp; if(tuple[i] instanceof BigDecimal) { if(aClass == Integer.class) { temp = ((BigDecimal)tuple[i]).intValue(); } else if(aClass == BigInteger.class) { temp = ((BigDecimal)tuple[i]).toBigInteger(); } else if(aClass == Double.class) { temp = ((BigDecimal)tuple[i]).doubleValue(); } else if(aClass == Float.class) { temp = ((BigDecimal)tuple[i]).floatValue(); } else if(aClass == Long.class) { temp = ((BigDecimal)tuple[i]).longValue(); } else if(aClass == Short.class) { temp = ((BigDecimal)tuple[i]).shortValue(); } else if(aClass == Byte.class) { temp = ((BigDecimal)tuple[i]).byteValue(); } else { temp = tuple[i]; } } else { temp = tuple[i]; } setters[i].set(result, temp, null); } } return result; } catch (InstantiationException var5) { throw new HibernateException("Could not instantiate resultclass: " + this.resultClass.getName()); } catch (IllegalAccessException var6) { throw new HibernateException("Could not instantiate resultclass: " + this.resultClass.getName()); } } private void initialize(String[] aliases) { PropertyAccessStrategyChainedImpl propertyAccessStrategy = new PropertyAccessStrategyChainedImpl(new PropertyAccessStrategy[]{PropertyAccessStrategyBasicImpl.INSTANCE, PropertyAccessStrategyFieldImpl.INSTANCE, PropertyAccessStrategyMapImpl.INSTANCE}); this.setters = new Setter[aliases.length]; for(int i = 0; i < aliases.length; ++i) { String alias = aliases[i]; if(alias != null) { this.setters[i] = propertyAccessStrategy.buildPropertyAccess(this.resultClass, alias).getSetter(); } } this.isInitialized = true; } private void check(String[] aliases) { if(!Arrays.equals(aliases, this.aliases)) { throw new IllegalStateException("aliases are different from what is cached; aliases=" + Arrays.asList(aliases) + " cached=" + Arrays.asList(this.aliases)); } } public boolean equals(Object o) { if(this == o) { return true; } else if(o != null && this.getClass() == o.getClass()) { AliasToBeanResultTransformer that = (AliasToBeanResultTransformer)o; return !this.resultClass.equals(that.resultClass)?false:Arrays.equals(this.aliases, that.aliases); } else { return false; } } public int hashCode() { int result = this.resultClass.hashCode(); result = 31 * result + (this.aliases != null?Arrays.hashCode(this.aliases):0); return result; } }
AliasToEntityMapResultTransformer.java
import org.hibernate.transform.AliasedTupleSubsetResultTransformer; import java.util.HashMap; import java.util.Map; public class AliasToEntityMapResultTransformer extends AliasedTupleSubsetResultTransformer { public static final AliasToEntityMapResultTransformer INSTANCE = new AliasToEntityMapResultTransformer(); public Map<String, String> aliasMap = new HashMap<>(); /** * Disallow instantiation of AliasToEntityMapResultTransformer. */ private AliasToEntityMapResultTransformer() { } /** * {@inheritDoc} */ public Object transformTuple(Object[] tuple, String[] aliases) { Map result = new HashMap(tuple.length); for ( int i=0; i<tuple.length; i++ ) { String alias = aliases[i]; if ( alias!=null ) { if (!aliasMap.containsKey(alias)) { aliasMap.put(alias, StringUtils.toHumpName(alias)); } result.put(aliasMap.get(alias), tuple[i] ); } } return result; } /** * {@inheritDoc} */ public boolean isTransformedValueATupleElement(String[] aliases, int tupleLength) { return false; } /** * Serialization hook for ensuring singleton uniqueing. * * @return The singleton instance : {@link #INSTANCE} */ private Object readResolve() { return INSTANCE; } }
BaseFacade.java
BaseFacade.java package com.heren.his.domain.facade.share; import com.google.common.base.Optional;//guava-19.0-rc1.jar import com.heren.his.commons.util.AliasToBeanResultTransformer;//上面的AliasToBeanResultTransformer类 import com.heren.his.commons.util.AliasToEntityMapResultTransformer;//上面的AliasToEntityMapResultTransformer类 import org.hibernate.SQLQuery;//hibernate-core-5.0.1.Final.jar import org.hibernate.Session;//hibernate-core-5.0.1.Final.jar import org.hibernate.internal.SessionFactoryImpl;//hibernate-core-5.0.1.Final.jar import javax.inject.Inject;//javax.inject-1.jar import javax.persistence.*;//hibernate-jpa-2.1-api-1.0.0.Final.jar import javax.persistence.criteria.CriteriaQuery;//hibernate-jpa-2.1-api-1.0.0.Final.jar import java.sql.Connection;//jdk import java.sql.SQLException;//jdk import java.util.*; import static com.google.common.base.Optional.absent;//guava-19.0-rc1.jar import static com.google.common.base.Throwables.propagate;//guava-19.0-rc1.jar public abstract class BaseFacade { @Inject protected EntityManager entityManager; protected BaseFacade() { } //根据主键获取这个对象 Object Key 可以是一个基础类型，也可以是一个对象(联合主键) protected <T> T strictFindByPrimaryKey(Class<T> entityClass, Object key, String... exceptionMsg) { String msg = exceptionMsg != null && exceptionMsg.length > 0 ? exceptionMsg[0] : "指定的资源无法找到"; if (key == null) { throw new com.heren.his.commons.exceptions.NotFoundException(String.format(msg + ": null")); } T t = entityManager.find(entityClass, key); if (t == null) { throw new com.heren.his.commons.exceptions.NotFoundException(String.format(msg + ": [%s]", key.toString())); } return t; } //根据指定主键返回实体 public <T> T get(Class<T> entityClass, Object pk) { return entityManager.find(entityClass, pk); } //保存实体，并返回保存的实体 public <T> T persist(T entity) { entityManager.persist(entity); return entity; } //修改实体 并返回修改的实体 public <T> T merge(T entity) { return entityManager.merge(entity); } //删除实体 public <T> void remove(T entity) { entityManager.remove(entity); } //删除List中的实体 public void removeALl(List list) { for (Object obj : list) { entityManager.remove(obj); } } //批量删除entityClass：需要删除的类 ids：主键类型为Long的list public void remove(Class<?> entityClass, List<Long> ids) { for (Long pk : ids) { entityManager.remove(entityManager.merge(entityManager.getReference(entityClass, pk))); } } //批量删除entityClass：需要删除的类 ids：主键类型为String的list public void removeByStringIds(Class<?> entityClass, List<String> ids) { for (String pk : ids) { entityManager.remove(entityManager.find(entityClass, pk)); } } //返回指定长度的List 分页显示用 public <T> List<T> findRange(T entity, int[] range) { CriteriaQuery cq = entityManager.getCriteriaBuilder().createQuery(); cq.select(cq.from(entity.getClass())); Query q = entityManager.createQuery(cq); q.setMaxResults(range[1] - range[0]); q.setFirstResult(range[0]); return q.getResultList(); } //返回指定实体类的总个数 分页显示用 public <T> int count(T entity) { CriteriaQuery cq = getEntityManager().getCriteriaBuilder().createQuery(); javax.persistence.criteria.Root<T> rt = cq.from(entity.getClass()); cq.select(getEntityManager().getCriteriaBuilder().count(rt)); Query q = getEntityManager().createQuery(cq); return ((Long) q.getSingleResult()).intValue(); } //返回指定实体类的List 分页显示用 public <T> List<T> findAll(Class<T> entity) { TypedQuery query = entityManager.createQuery("FROM " + entity.getCanonicalName(), entity); return (List<T>) query.getResultList(); } //返回一个sql的Query public Query createNativeQuery(String sqlString) { return entityManager.createNativeQuery(sqlString); } //返回一个sql和可变参数的Query public Query createNativeQuery(String sqlString, Object... params) { Query query = entityManager.createNativeQuery(sqlString); for (int i = 0; i < params.length; i++) { query.setParameter(i + 1, params[i]); } return query; } //返回一个sql和List类型的参数的Query public Query getNativeQuery(String sqlString, List<Object> params) { Query query = entityManager.createNativeQuery(sqlString); for (int i = 0; i < params.size(); i++) { query.setParameter(i + 1, params.get(i)); } return query; } //返回一个sql和List类型的参数的List集合 public List<Object[]> createNativeQuery(String sqlString, List<Object> params) { Query query = entityManager.createNativeQuery(sqlString); for (int i = 0; i < params.size(); i++) { query.setParameter(i + 1, params.get(i)); } return query.getResultList(); } //返回查询得到的实体List entityClass：实体类 whereJpql：指定查询返回的第一条记录 orderBy：用于排序 args：作为JPQL 查询字符的参数的值 public <T> List<T> getResultList(Class<T> entityClass, String whereJpql, LinkedHashMap<String, String> orderBy, Object... args) { //获取实体名称 String entityName = entityClass.getSimpleName(); //创建查询 TypedQuery query = this.getEntityManager().createQuery(" from " + entityName + " as o " + whereJpql + this.buildOrderby(orderBy), entityClass); //为查询字符串中的参数设置值 for (int i = 0; i < args.length; i++) { query.setParameter(i + 1, args[i]); } //返回结果集 return (List<T>) query.getResultList(); } //执行查询，并进行分页 entityClass：实体类 whereJpql：指定查询返回的第一条记录 firstResult：启始记录数 //maxResult：显示的最大记录数 orderBy：用于排序 args：作为JPQL 查询字符的参数的值 public <T> List<T> getResultList(Class<T> entityClass, String whereJpql, int firstResult, int maxResult, LinkedHashMap<String, String> orderBy, Object... args) { //获取实体名称 String entityName = entityClass.getSimpleName(); //创建查询 TypedQuery query = this.getEntityManager().createQuery("select o from " + entityName + " as o " + whereJpql + this.buildOrderby(orderBy), entityClass); //为查询字符串中的参数设置值 for (int i = 0; i < args.length; i++) { query.setParameter(i + 1, args[i]); } //对查询的结果集进行分页 query.setMaxResults(maxResult).setFirstResult(firstResult); //返回结果集 return (List<T>) query.getResultList(); } //构建排序子句 orderby：排序条件 private static String buildOrderby(LinkedHashMap<String, String> orderby) { StringBuffer out = new StringBuffer(); if (orderby != null && orderby.size() > 0) { out.append(" order by "); for (String key : orderby.keySet()) { out.append(" o." + key + " " + orderby.get(key) + " ,"); } out.deleteCharAt(out.length() - 1); } return out.toString(); } //组合排序拼接orderBy public void buildOrderBy(String orderBySort, StringBuilder jpqlQuery, String tableAlias) { if (orderBySort != null && !orderBySort.equals("")) { String orderBy = " order by "; String[] feilds = orderBySort.split(","); int count = feilds.length; for (String str : feilds) { if (count > 1) { orderBy += tableAlias + "." + str + ","; } else { orderBy += tableAlias + "." + str; } count--; } jpqlQuery.append(orderBy); } } public JpqlQueryBuilder jpqlQueryBuilder(String jpql, Object param, String judge) { return jpqlQueryBuilder(new StringBuilder(jpql), param, judge, new ArrayList<>()); } public JpqlQueryBuilder jpqlQueryBuilder(StringBuilder jpql, Object param, String judge) { return jpqlQueryBuilder(jpql, param, judge, new ArrayList<>()); } public JpqlQueryBuilder jpqlQueryBuilder(StringBuilder jpql, Object param, String judge, boolean addWhereOrNot) { return jpqlQueryBuilder(jpql, param, judge, new ArrayList<>(), addWhereOrNot); } public JpqlQueryBuilder jpqlQueryBuilder(StringBuilder jpql, Object param, String judge, ArrayList<Object> parameters) { return jpqlQueryBuilder(jpql, param, judge, parameters, true); } public JpqlQueryBuilder jpqlQueryBuilder(StringBuilder jpql, Object param, String judge, ArrayList<Object> parameters, boolean addWhereOrNot) { return new JpqlQueryBuilder(jpql, param, judge, parameters, addWhereOrNot); } //用于组装SQL语句的 public static class JPQLBuilder { private StringBuilder sb = new StringBuilder();//主要是用append()方法 private List<Object> params = new ArrayList<>();//用来封装查询参数 private int count=0; private JPQLBuilder() { } public static JPQLBuilder getInstance() { return new JPQLBuilder(); } public StringBuilder get$QL() { return sb; } public List<Object> getParams() { return params; } public JPQLBuilder append(String $ql) { sb.append(" " + $ql + " "); return this; } public JPQLBuilder select(String selectJPQL) { sb.append(" select " + selectJPQL).append(" "); return this; } public JPQLBuilder delete(String selectJPQL) { sb.append(" delete from " + selectJPQL).append(" "); return this; } public JPQLBuilder update(String selectJPQL) { sb.append(" update " + selectJPQL).append(" "); return this; } public JPQLBuilder select() { sb.append(" select "); return this; } public JPQLBuilder from(String fromJPQL) { sb.append(" from " + fromJPQL).append(" "); return this; } public JPQLBuilder from() { sb.append(" from "); return this; } public JPQLBuilder where() { sb.append(" where 1 = 1 "); return this; } public JPQLBuilder where(String whereJPQL) { sb.append(" where " + whereJPQL).append(" "); return this; } public JPQLBuilder orderBy(String OrderJPQL) { sb.append(" order by "+OrderJPQL+" "); return this; } /** * @param param 没有值传 "notParam" */ public JPQLBuilder set(String addJpQL,Object param) { if (count == 0) { sb.append(" set ").append(addJpQL).append(" "); count++; } else { sb.append(" , ").append(addJpQL).append(" "); } if (!"notParam".equals(param)) { params.add(param); } return this; } public JPQLBuilder add(String addJpQL) { sb.append(" and ").append(addJpQL).append(" "); return this; } public JPQLBuilder addIsNull(String field) { sb.append(" and " + field + " is null "); return this; } public JPQLBuilder addIsNotNull(String field) { sb.append(" and " + field + " is not null "); return this; } public JPQLBuilder addEqualTo(String field, Object param) { if (param != null) { sb.append(" and " + field + " = ? "); params.add(param); } return this; } public JPQLBuilder addNotEqualTo(String field, Object param) { if (param != null) { sb.append(" and " + field + " <> ? "); params.add(param); } return this; } public JPQLBuilder addGreaterThan(String field, Object param) { if (param != null) { sb.append(" and " + field + " > ? "); params.add(param); } return this; } public JPQLBuilder addGreaterThanOrEqualTo(String field, Object param) { if (param != null) { sb.append(" and " + field + " >= ? "); params.add(param); } return this; } public JPQLBuilder addLessThan(String field, Object param) { if (param != null) { sb.append(" and " + field + " < ? "); params.add(param); } return this; } public JPQLBuilder addLessThanOrEqualTo(String field, Object param) { if (param != null) { sb.append(" and " + field + " <= ? "); params.add(param); } return this; } public JPQLBuilder addLike(String field, Object param) { if (param != null) { sb.append(" and " + field + " like ? "); params.add(param); } return this; } public JPQLBuilder addNotLike(String field, Object param) { if (param != null) { sb.append(" and " + field + " not like ? "); params.add(param); } return this; } public JPQLBuilder addIn(String field, List<String> param) { if (param != null && !param.isEmpty()) { String elements = ""; for (int i = 0, size = param.size(); i < size; i++) { if ("".equals(param.get(i))) { continue; } if (i + 1 == size) { elements = elements + "\'" + param.get(i) + "\'"; } else { elements = elements + "\'" + param.get(i) + "\',"; } } if (!"".equals(elements)) { sb.append(" and " + field + " in (" + elements + ")"); } } return this; } public JPQLBuilder addIn(String field, Object... param) { if (param != null && param.length != 0) { String elements = ""; for (int i = 0, size = param.length; i < size; i++) { if ("".equals(param[i])) { continue; } if (i + 1 == size) { elements = elements + "\'" + param[i] + "\'"; } else { elements = elements + "\'" + param[i] + "\',"; } } if (!"".equals(elements)) { sb.append(" and " + field + " in (" + elements + ")"); } } return this; } public JPQLBuilder addNotIn(String field, List<String> param) { if (param != null && !param.isEmpty()) { String elements = ""; for (int i = 0, size = param.size(); i < size; i++) { if ("".equals(param.get(i))) { continue; } if (i + 1 == size) { elements = elements + "\'" + param.get(i) + "\'"; } else { elements = elements + "\'" + param.get(i) + "\',"; } } if (!"".equals(elements)) { sb.append(" and " + field + " not in (" + elements + ")"); } } return this; } public JPQLBuilder addBetween(String field, Object start, Object end) { if (start != null && end != null) { sb.append(" and " + field + " between ? and ? "); params.add(start); params.add(end); } return this; } public JPQLBuilder addNotBetween(String field, Object start, Object end) { if (start != null && end != null) { sb.append(" and " + field + " not between ? and ? "); params.add(start); params.add(end); } return this; } } public <T> List<T> createNativeQuery(String sql, List<Object> params, Class<T> clazz) { Query query = entityManager.createNativeQuery(sql); query.unwrap(SQLQuery.class).setResultTransformer(new AliasToBeanResultTransformer(clazz)); for (int i = 0; i < params.size(); i++) { query.setParameter(i + 1, params.get(i)); } return query.getResultList(); } public List<Map> createNativeQueryToMap(String sql, Object... params) { Query query = entityManager.createNativeQuery(sql); query.unwrap(SQLQuery.class).setResultTransformer(AliasToEntityMapResultTransformer.INSTANCE); for (int i = 0, length = params.length; i < length; i++) { query.setParameter(i + 1, params[i]); } return query.getResultList(); } public List<Map> createNativeQueryToMap(String sql, List<Object> params) { Query query = entityManager.createNativeQuery(sql); query.unwrap(SQLQuery.class).setResultTransformer(AliasToEntityMapResultTransformer.INSTANCE); for (int i = 0, length = params.size(); i < length; i++) { query.setParameter(i + 1, params.get(i)); } return query.getResultList(); } public List<Map> createNativeQueryToMapForPage(String sql, List<Object> params, int page, int pageSize) { Query query = entityManager.createNativeQuery(sql); query.unwrap(SQLQuery.class).setResultTransformer(AliasToEntityMapResultTransformer.INSTANCE); for (int i = 0, length = params.size(); i < length; i++) { query.setParameter(i + 1, params.get(i)); } query.setFirstResult((page - 1) * pageSize).setMaxResults(pageSize); return query.getResultList(); } public List<Map> createNativeQueryToMapForMax(String sql, List<Object> params, int maxResult) { Query query = entityManager.createNativeQuery(sql); query.unwrap(SQLQuery.class).setResultTransformer(AliasToEntityMapResultTransformer.INSTANCE); for (int i = 0, length = params.size(); i < length; i++) { query.setParameter(i + 1, params.get(i)); } query.setMaxResults(maxResult); return query.getResultList(); } public <T> List<T> createNativeQuery(Class<T> clazz, String sql, Object... params) { Query query = entityManager.createNativeQuery(sql); query.unwrap(SQLQuery.class).setResultTransformer(new AliasToBeanResultTransformer(clazz)); for (int i = 0; i < params.length; i++) { query.setParameter(i + 1, params[i]); } return query.getResultList(); } public class JpqlQueryBuilder { private StringBuilder jpql; private int count; private ArrayList<Object> params; private boolean addWhereOrNot; /** * 根据传入的初始jpql，以及初始参数和该初始参数在JPQL中需要显示的查询语句片段，以便构造JpqlQueryBuilder。 * * @param jpql * @param param * @param judge */ public JpqlQueryBuilder(StringBuilder jpql, Object param, String judge, ArrayList<Object> params, boolean addWhereOrNot) { this.params = params; this.count = 0; this.jpql = jpql; this.addWhereOrNot = addWhereOrNot; this.param(param, judge); } /** * 传入需要进行JPQL语句组织时，用到的参数和参数查询语句片段。 * * @param param * @param judge * @return */ public JpqlQueryBuilder param(Object param, String judge) { if (param != null && !"".equals(param)) { if (count == 0 && addWhereOrNot) { jpql.append(" where " + judge); } else { jpql.append(" and " + judge); } if (!param.equals("joinsExpression")) { params.add(param); } ++count; } return this; } /** * 获得最终组织好的Jpql语句。 * * @return */ public StringBuilder getJpql() { return jpql; } /** * 获得最终组织好的、相对于Jpql语句的参数列表。 * * @return */ public ArrayList<Object> getJpqlParams() { return params; } /** * 获得计数器当前的值。 * * @return */ public int getCount() { return count; } } //type：xxxClass query：sql语句查询参数=? parameters：new ArrayList<>()集合 public <T> List<T> find(Class<T> type, String query, List<Object> parameters) { return createQuery(type, query, parameters).getResultList(); } //用于BaseFacade中find()函数调用，或者是在查询数据库的方法中直接调用 public <T> TypedQuery<T> createQuery(Class<T> type, String query, List<Object> parameters) { TypedQuery<T> typedQuery = entityManager.createQuery(query, type); for (int i = 0; i < parameters.size(); i++) { if (parameters.get(i) instanceof Date) { typedQuery.setParameter(i + 1, (Date) parameters.get(i), TemporalType.TIMESTAMP); } else { typedQuery.setParameter(i + 1, parameters.get(i)); } } return typedQuery; } //type：xxxClass query：sql语句查询参数=? Object... parameters：可变参数 public <T> List<T> find(Class<T> type, String query, Object... parameters) { return createQuery(type, query, parameters).getResultList(); } public <T> Optional<T> first(Class<T> type, String query, Object... parameters) { try { return Optional.of(createQuery(type, query, parameters).setMaxResults(1).getSingleResult()); } catch (NoResultException e) { return absent(); } } //用于BaseFacade中find()函数调用，或者是在查询数据库的方法中直接调用 public <T> TypedQuery<T> createQuery(Class<T> type, String query, Object... parameters) { TypedQuery<T> typedQuery = entityManager. createQuery(query, type); for (int i = 0; i < parameters.length; i++) { if (parameters[i] instanceof Date) { typedQuery.setParameter(i + 1, (Date) parameters[i], TemporalType.DATE); } else { typedQuery.setParameter(i + 1, parameters[i]); } } return typedQuery; } public Query createQuery(String query) { return entityManager.createQuery(query); } protected int update(String queryStr, Object... parameters) { try { Query query = entityManager.createQuery(queryStr); for (int i = 0; i < parameters.length; i++) { if (parameters[i] instanceof Date) { query.setParameter(i + 1, (Date) parameters[i], TemporalType.TIMESTAMP); } else { query.setParameter(i + 1, parameters[i]); } } int i = query.executeUpdate(); return i; } catch (Exception e) { propagate(e); } return 0; } public void detach(Object entity) { entityManager.detach(entity); }; public EntityManager getEntityManager() { return entityManager; } public Connection getConnection() { Connection connection = null; try { Session session = (Session) entityManager.getDelegate(); SessionFactoryImpl sessionFactory = (SessionFactoryImpl) session.getSessionFactory(); connection = sessionFactory.getJdbcServices().getBootstrapJdbcConnectionAccess().obtainConnection(); } catch (SQLException e) { e.printStackTrace(); } return connection; } public void closeConnection(Connection connection) { if (connection != null) { try { connection.close(); } catch (SQLException e) { e.printStackTrace(); } } } }
查询的sql
JPQLBuilder jpql = JPQLBuilder.getInstance();//JPQBuilder：BaseFacade.class中 jpql.select(" pmi.card_no,pmi.trace_no,pmi.pos_batch_no ") .append(", pmi.payment_amount,pmi.trans_date,pmi.trans_time ") .append(", pm.operator_emp_id,pm.operator_emp_name,pmi.money_type ") .append(", pmi.pos_merchant_no,pmi.cash_reg_no,pmi.pos_retrieval_no") .from("prepayment_master pm") .append(" left join prepayments_money pmi on pm.prepay_no = pmi.prepay_no") .where("pm.acct_no = '" + acctNo + "' and pmi.money_type_code = '" + moneyType + "'"); List lists = createNativeQueryToMap(jpql.get$QL().toString());//createNativeQueryToMap()：BaseFacade.class中 return lists;
String sql = "select new com.heren.his.domain.entity.bill.AcctVoucherMasterVo(m.voucherNoDesc,m.voucherDate,m.summary,m.debitSum,m.creditSum,m.voucherType)" + " from AcctVoucherMaster m" + " where m.voucherDate >= :startDate and m.voucherDate <= :endDate"; if (!"".equals(voucherType) && voucherType != null) { sql += " and m.voucherType = '" + voucherType + "'"; } if (!"".equals(voucherNoDesc) && voucherNoDesc != null) { sql += " and m.voucherNoDesc='" + voucherNoDesc + "'"; } return entityManager.createQuery(sql) .setParameter("startDate", startDate) .setParameter("endDate", endDate).getResultList();
JPQLBuilder jpql = JPQLBuilder.getInstance(); jpql.select("po.order_id, po.group_graph, po.order_text, po.repeat_indicator, dod.dosage, dod.usage_units, po.duration, po.duration_units, po.frequency, po.perform_schedule_plan") .append(", po.start_date_time, po.last_perform_date_time, po.last_accting_date_time, po.stop_date_time, po.billing_attr, po.drug_billing_attr") .append(", case when dod.administration is null then hod.administration else dod.administration end administration") .from("perform_orders po left join drug_order_detail dod on po.order_id = dod.order_id") .append("left join herb_order_detail hod on po.order_id = hod.order_id") .where() .addEqualTo("po.visit_no", visitNo) .append("order by po.enter_date_time desc"); List<AuditInfoVO.PerformOrderVO> performOrderVOs = createNativeQuery(AuditInfoVO.PerformOrderVO.class, jpql.get$QL().toString(), visitNo); Map<String, OrderCostsVO> orderCostsVOMap = null; AuditInfoVO auditInfoVO = new AuditInfoVO();
387
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
