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