Exemplo n.º 1
0
 @Override
 public synchronized void insertThread(ThreadInfo threadInfo) {
   SQLiteDatabase db = mHelper.getWritableDatabase();
   db.execSQL(
       "insert into thread_info(thread_id,url,start,end,finished) values(?,?,?,?,?)",
       new Object[] {
         threadInfo.getId(),
         threadInfo.getUrl(),
         threadInfo.getStart() + "",
         threadInfo.getEnd() + "",
         threadInfo.getFinished() + ""
       });
   db.close();
 }
Exemplo n.º 2
0
  @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;
  }