房间SQL自动生成主键返回0或null

Question

所以我的数据库和一个网站实体一起工作

 @Entity(tableName = "website_table") public class Website {

     @NonNull
     @PrimaryKey(autoGenerate = true)
     private Integer websiteId;

     private String title;
     private String base_URL;
     private String description;


     public Website(String title, String base_URL) {
         this.title = title;
         this.base_URL = base_URL;
     }

     public void setWebsiteId(Integer websiteId) {
         this.websiteId = websiteId;
     }

     public Integer getWebsiteId() {
         return websiteId;
     }

     public String getTitle() {
         return title;
     }

     public String getDescription() {
         return description;
     }

     public void setDescription(String description) {
         this.description = description;
     }

     public String getBase_URL() { return base_URL; }

     public void setBase_URL(String base_URL) { this.base_URL = base_URL; }
   }

@Dao
public interface WebsiteDao {

    @Insert
    void insert(Website website);

    @Update
    void update(Website website);

    @Delete
    void delete(Website website);

    @Query("DELETE FROM website_table")
    void deleteAllWebsites();

    @Query("SELECT * FROM website_table ORDER BY title DESC")
    LiveData<List<Website>> getAllWebsites();

    @Query("SELECT * FROM website_table")
    public List<WebsiteWithWebPages> loadWebsitesWithWebPages();
}

然后我尝试为网站上的网页添加关系

    public class WebsiteWithWebPages {
        @Embedded
        public Website website;

        @Relation(parentColumn = "websiteId", entityColumn = "website_Id", 

        entity = WebPage.class)
        public List<WebPage> webPageList;
    }

@Entity(tableName = "webpage_table")
public class WebPage {
    @PrimaryKey(autoGenerate = true)
    public Integer webPageId;

    public final String name;
    public final String url;
    public String description;
    public final Integer website_Id;

    public WebPage(String name, String url, final Integer website_Id) {
        this.name = name;
        this.url = url;
        this.website_Id = website_Id;
    }

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }

    public String getName() {
        return name;
    }

    public String getUrl() {
        return url;
    }

    public Integer getWebsiteId() {
        return website_Id;
    }
}

当我尝试使用我的网站Dao添加网站时，例如使用命令

Website website= new Website("website name", "websiteurl");
        websiteDao.insert(website);

我的应用程序崩溃了。创建的每个网站的id为0，外键约束失败。这里出了什么问题？我将primarykey从int更改为INTEGER，当我这样做时，它将主键设置为null，当primarykey为int时，它将id设置为0。发生什么事了？

Answer 1

解决了的。最后我重拨了我的密码。这一次，我从https://github.com/Pavneet-Sing/RoomDemo/blob/master/app/src/main/java/com/example/pavneet_singh/roomdemo/AddNoteActivity.java

具体来说，对于'Insert'异步任务的DoInBackground，有以下代码`

protected Boolean doInBackground(Void... objs) {
            // retrieve auto incremented note id
            long j = activityReference.get().noteDatabase.getNoteDao().insertNote(note);
            note.setNote_id(j);
            Log.e("ID ", "doInBackground: "+j );
            return true;
        }

通过让插入刀方法返回长时间

 @Insert
    long insertNote(Note note);

数据库按预期正确自动分配ID。如果一次添加多个注释，也要按照添加注释的顺序进行记录。在这种情况下，不会设置ID，因为每次对数据库的insert调用都会创建一个异步方法。所以我所做的就是添加一个。在每次异步调用之后获取（），以确保所有内容都正确地按时设置