@Override public List<ThreadInfo> getThreads(String url) { List<ThreadInfo> list = new ArrayList<ThreadInfo>(); SQLiteDatabase db = mHelper.getReadableDatabase(); Cursor cursor = db.rawQuery("select * from thread_info where url = ?", new String[] {url}); while (cursor.moveToNext()) { ThreadInfo threadInfo = new ThreadInfo(); threadInfo.setId(cursor.getInt(cursor.getColumnIndex("thread_id"))); threadInfo.setUrl(cursor.getString(cursor.getColumnIndex("url"))); threadInfo.setStart(cursor.getLong(cursor.getColumnIndex("start"))); threadInfo.setEnd(cursor.getLong(cursor.getColumnIndex("end"))); threadInfo.setFinished(cursor.getLong(cursor.getColumnIndex("finished"))); list.add(threadInfo); } cursor.close(); db.close(); return list; }