/** * 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(); }
/** @param id */ public ShareDBEntry getShareContent(String id) { 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[] {id}, null, null, null); if (cursor.getCount() == 0) { return null; } else { cursor.moveToFirst(); ShareDBEntry entry = new ShareDBEntry(); entry.setId(cursor.getString(cursor.getColumnIndex(SHARE_WORK_ID))); entry.setTitle(cursor.getString(cursor.getColumnIndex(SHARE_TITLE))); entry.setContent(cursor.getString(cursor.getColumnIndex(SHARE_CONTENT))); entry.setIsMusicModle(cursor.getString(cursor.getColumnIndex(SHARE_ISMUSICMOD))); entry.setIsMusicInuse(cursor.getString(cursor.getColumnIndex(SHARE_ISMUSICINUSE))); entry.setMusicTitle(cursor.getString(cursor.getColumnIndex(SHARE_MUSICTILTE))); entry.setMusicAuthor(cursor.getString(cursor.getColumnIndex(SHARE_MUSICAUTHOR))); cursor.close(); return entry; } }
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()}); }