大理访客登记改
diff --git a/src/main/java/com/supwisdom/dlpay/app/dao/impl/AppDaoImpl.java b/src/main/java/com/supwisdom/dlpay/app/dao/impl/AppDaoImpl.java
index 5f29ec7..ea928cd 100644
--- a/src/main/java/com/supwisdom/dlpay/app/dao/impl/AppDaoImpl.java
+++ b/src/main/java/com/supwisdom/dlpay/app/dao/impl/AppDaoImpl.java
@@ -146,8 +146,9 @@
@Transactional
@Override
public List<EWechatAccount> getAccountByOpenid(String openid) {
- String sql = "select a.* from EWechatAccount a where a.openid =? and a.status='1'";
- Query query = entityManager.createQuery(sql, EWechatAccount.class);
+ String sql = "select a.* from e_wechat_account a where a.openid =? and a.status='1'";
+
+ Query query = entityManager.createNativeQuery(sql, EWechatAccount.class);
query.setParameter(1, openid);
List<EWechatAccount> list = query.getResultList();
if (list!=null && list.size()>0){