public synchronized List<String[]> queryWithArgs(String sql, String[] vArgs) throws Throwable {
Cursor cursor = null;
SQLiteDatabase database = null;
List<String[]> ret = new ArrayList<String[]>();
try {
database = mSqliteHelper.getWritableDatabase();
cursor = database.rawQuery(sql, vArgs);
String[] names = cursor.getColumnNames();
ret.add(names);
while (cursor.moveToNext()) {
String[] record = new String[names.length];
for (int x = 0; x < names.length; x++) {
record[x] = cursor.getString(x);
}
ret.add(record);
}
} finally {
try {
if (null != cursor) {
cursor.close();
}
} finally {
database.close();
}
}
return ret;
}
public void saveToSqlite(WatchHistory watchHistory) throws Throwable {
SQLiteDatabase database = null;
try {
database = mSqliteHelper.getWritableDatabase();
database.execSQL(
"insert or replace into fsc_history("
+ "media_id, name_cn, display_type, max_index, "
+ "virtual_user, user_id, "
+ "serial_id, serial_index, serial_title, serial_clarity, serial_language, "
+ "play_time_in_seconds, operation_time)values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
new Object[] {
watchHistory.mediaInfo.media_id,
watchHistory.mediaInfo.name_cn,
watchHistory.mediaInfo.display_type,
watchHistory.mediaInfo.max_index,
watchHistory.userInfo.virtual_user_id,
watchHistory.userInfo.user_id,
watchHistory.serialInfo.serial_id,
watchHistory.serialInfo.serial_index,
watchHistory.serialInfo.serial_title,
watchHistory.serialInfo.serial_clarity,
watchHistory.serialInfo.serial_language,
watchHistory.play_time_in_seconds,
System.currentTimeMillis() / 1000
});
} finally {
if (null != database) {
database.close();
}
}
}
public synchronized boolean execSql(String sql, Object[] args) throws Throwable {
SQLiteDatabase database = null;
try {
database = mSqliteHelper.getWritableDatabase();
if (args == null) {
args = new Object[0];
}
database.execSQL(sql, args);
} finally {
if (null != database) {
database.close();
}
}
return true;
}
private PlayHistoryDao(Context context) {
this.mSqliteHelper = FunSQLiteHelper.getInstance(context);
}