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