/** * insert share content to db * * @return */ public void insertShareContent(ShareDBEntry entry) { Cursor cursor = db.query( TAB_SHARE_CONTENT, new String[] { SHARE_WORK_ID, SHARE_TITLE, SHARE_CONTENT, SHARE_ISMUSICMOD, SHARE_ISMUSICINUSE, SHARE_MUSICTILTE, SHARE_MUSICAUTHOR }, SHARE_WORK_ID + "=?", new String[] {entry.getId()}, null, null, null); if (cursor.getCount() == 0) { ContentValues values = new ContentValues(); values.put(SHARE_TITLE, entry.getTitle()); values.put(SHARE_WORK_ID, entry.getId()); values.put(SHARE_CONTENT, entry.getContent()); values.put(SHARE_ISMUSICMOD, entry.getIsMusicModle()); values.put(SHARE_ISMUSICINUSE, entry.getIsMusicInuse()); values.put(SHARE_MUSICTILTE, entry.getMusicTitle()); values.put(SHARE_MUSICAUTHOR, entry.getMusicAuthor()); db.insert(TAB_SHARE_CONTENT, null, values); } else { updateShareContent(entry); } cursor.close(); }
public void updateShareContent(ShareDBEntry entry) { ContentValues values = new ContentValues(); values.put(SHARE_TITLE, entry.getTitle()); values.put(SHARE_CONTENT, entry.getContent()); values.put(SHARE_ISMUSICMOD, entry.getIsMusicModle()); values.put(SHARE_ISMUSICINUSE, entry.getIsMusicInuse()); values.put(SHARE_MUSICTILTE, entry.getMusicTitle()); values.put(SHARE_MUSICAUTHOR, entry.getMusicAuthor()); db.update(TAB_SHARE_CONTENT, values, SHARE_WORK_ID + "=?", new String[] {entry.getId()}); }