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){