/**
* 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()});
}
