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 42ac336..5f29ec7 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
@@ -147,7 +147,7 @@
     @Override
     public List<EWechatAccount> getAccountByOpenid(String openid) {
         String sql = "select a.* from EWechatAccount a where a.openid =? and a.status='1'";
-        Query query = entityManager.createNativeQuery(sql, EWechatAccount.class);
+        Query query = entityManager.createQuery(sql, EWechatAccount.class);
         query.setParameter(1, openid);
         List<EWechatAccount> list = query.getResultList();
         if (list!=null && list.size()>0){
diff --git a/src/main/java/com/supwisdom/dlpay/app/domain/EWechatAccount.java b/src/main/java/com/supwisdom/dlpay/app/domain/EWechatAccount.java
index eb1947b..21632a3 100644
--- a/src/main/java/com/supwisdom/dlpay/app/domain/EWechatAccount.java
+++ b/src/main/java/com/supwisdom/dlpay/app/domain/EWechatAccount.java
@@ -30,6 +30,7 @@
 
     @Id
     @Column(name = "WXID", unique = true,  nullable = false, length = 32)
+    @GeneratedValue(strategy = GenerationType.AUTO)
     public String getWxid() {
         return wxid;
     }
diff --git a/src/main/java/com/supwisdom/dlpay/app/domain/EWechatConfig.java b/src/main/java/com/supwisdom/dlpay/app/domain/EWechatConfig.java
index bb1262f..bd555c7 100644
--- a/src/main/java/com/supwisdom/dlpay/app/domain/EWechatConfig.java
+++ b/src/main/java/com/supwisdom/dlpay/app/domain/EWechatConfig.java
@@ -1,9 +1,6 @@
 package com.supwisdom.dlpay.app.domain;
 
-import javax.persistence.Column;
-import javax.persistence.Entity;
-import javax.persistence.Id;
-import javax.persistence.Table;
+import javax.persistence.*;
 
 /**
  * Created by shuwei on 17/8/9.
@@ -24,6 +21,7 @@
 
     @Id
     @Column(name = "ID", unique = true,  nullable = false, length = 40)
+    @GeneratedValue(strategy = GenerationType.AUTO)
     public String getId() {
         return id;
     }