Esempio n. 1
0
 public void deleteFav(MainPageItem qy) {
   Cursor cursor = null;
   String where =
       FavTable.USER_ID
           + " = '"
           + MyApplication.getInstance().getCurrentUser().getObjectId()
           + "' AND "
           + FavTable.OBJECT_ID
           + " = '"
           + qy.getObjectId()
           + "'";
   cursor = dbHelper.query(DBHelper.TABLE_NAME, null, where, null, null, null, null);
   if (cursor != null && cursor.getCount() > 0) {
     cursor.moveToFirst();
     int isLove = cursor.getInt(cursor.getColumnIndex(FavTable.IS_LOVE));
     if (isLove == 0) {
       dbHelper.delete(DBHelper.TABLE_NAME, where, null);
     } else {
       ContentValues cv = new ContentValues();
       cv.put(FavTable.IS_FAV, 0);
       dbHelper.update(DBHelper.TABLE_NAME, cv, where, null);
     }
   }
   if (cursor != null) {
     cursor.close();
     dbHelper.close();
   }
 }
Esempio n. 2
0
 public ArrayList<MainPageItem> queryFav() {
   ArrayList<MainPageItem> contents = null;
   // ContentResolver resolver = context.getContentResolver();
   Cursor cursor = dbHelper.query(DBHelper.TABLE_NAME, null, null, null, null, null, null);
   LogUtils.i(TAG, cursor.getCount() + "");
   if (cursor == null) {
     return null;
   }
   contents = new ArrayList<MainPageItem>();
   for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) {
     MainPageItem content = new MainPageItem();
     content.setMyFav(cursor.getInt(3) == 1 ? true : false);
     content.setMyLove(cursor.getInt(4) == 1 ? true : false);
     LogUtils.i(
         TAG,
         cursor.getColumnIndex("isfav")
             + ".."
             + cursor.getColumnIndex("islove")
             + ".."
             + content.getMyFav()
             + "..."
             + content.getMyLove());
     contents.add(content);
   }
   if (cursor != null) {
     cursor.close();
   }
   // if (contents.size() > 0) {
   // return contents;
   // }
   return contents;
 }
Esempio n. 3
0
 /**
  * 设置内容的收藏状态
  *
  * @param context
  * @param lists
  */
 public List<MainPageItem> setFavInFav(List<MainPageItem> lists) {
   Cursor cursor = null;
   if (lists != null && lists.size() > 0) {
     for (Iterator iterator = lists.iterator(); iterator.hasNext(); ) {
       MainPageItem content = (MainPageItem) iterator.next();
       content.setMyFav(true);
       String where =
           FavTable.USER_ID
               + " = '"
               + MyApplication.getInstance().getCurrentUser().getObjectId()
               + "' AND "
               + FavTable.OBJECT_ID
               + " = '"
               + content.getObjectId()
               + "'";
       cursor = dbHelper.query(DBHelper.TABLE_NAME, null, where, null, null, null, null);
       if (cursor != null && cursor.getCount() > 0) {
         cursor.moveToFirst();
         if (cursor.getInt(cursor.getColumnIndex(FavTable.IS_LOVE)) == 1) {
           content.setMyLove(true);
         } else {
           content.setMyLove(false);
         }
       }
       LogUtils.i(TAG, content.getMyFav() + ".." + content.getMyLove());
     }
   }
   if (cursor != null) {
     cursor.close();
     dbHelper.close();
   }
   return lists;
 }
Esempio n. 4
0
 public long insertFav(MainPageItem qy) {
   long uri = 0;
   Cursor cursor = null;
   String where =
       FavTable.USER_ID
           + " = '"
           + MyApplication.getInstance().getCurrentUser().getObjectId()
           + "' AND "
           + FavTable.OBJECT_ID
           + " = '"
           + qy.getObjectId()
           + "'";
   cursor = dbHelper.query(DBHelper.TABLE_NAME, null, where, null, null, null, null);
   if (cursor != null && cursor.getCount() > 0) {
     cursor.moveToFirst();
     ContentValues conv = new ContentValues();
     conv.put(FavTable.IS_FAV, 1);
     conv.put(FavTable.IS_LOVE, 1);
     dbHelper.update(DBHelper.TABLE_NAME, conv, where, null);
   } else {
     ContentValues cv = new ContentValues();
     cv.put(FavTable.USER_ID, MyApplication.getInstance().getCurrentUser().getObjectId());
     cv.put(FavTable.OBJECT_ID, qy.getObjectId());
     cv.put(FavTable.IS_LOVE, qy.getMyLove() == true ? 1 : 0);
     cv.put(FavTable.IS_FAV, qy.getMyFav() == true ? 1 : 0);
     uri = dbHelper.insert(DBHelper.TABLE_NAME, null, cv);
   }
   if (cursor != null) {
     cursor.close();
     dbHelper.close();
   }
   return uri;
 }
Esempio n. 5
0
 public boolean isLoved(MainPageItem qy) {
   Cursor cursor = null;
   String where =
       FavTable.USER_ID
           + " = '"
           + MyApplication.getInstance().getCurrentUser().getObjectId()
           + "' AND "
           + FavTable.OBJECT_ID
           + " = '"
           + qy.getObjectId()
           + "'";
   cursor = dbHelper.query(DBHelper.TABLE_NAME, null, where, null, null, null, null);
   if (cursor != null && cursor.getCount() > 0) {
     cursor.moveToFirst();
     if (cursor.getInt(cursor.getColumnIndex(FavTable.IS_LOVE)) == 1) {
       return true;
     }
   }
   return false;
 }
Esempio n. 6
0
  private void addDataInfo() {
    mDbHelper = new DBHelper(this);
    mCursor = mDbHelper.query();
    if (mCursor.getCount() < 6) {
      // add emergency info
      mDbHelper.insert(
          "Emergency Infomation a",
          "emergency infomation a emergency infomation a emergency infomation a",
          "1");
      mDbHelper.insert(
          "Emergency Infomation b",
          "emergency infomation b emergency infomation b emergency infomation b",
          "1");
      mDbHelper.insert(
          "Emergency Infomation c",
          "emergency infomation c emergency infomation c emergency infomation c",
          "1");
      mDbHelper.insert(
          "Emergency Infomation d",
          "emergency infomation d emergency infomation d emergency infomation d",
          "1");
      mDbHelper.insert(
          "Emergency Infomation e",
          "emergency infomation e emergency infomation e emergency infomation e",
          "1");
      mDbHelper.insert(
          "Emergency Infomation f",
          "emergency infomation f emergency infomation f emergency infomation f",
          "1");
      mDbHelper.insert(
          "Emergency Infomation g",
          "emergency infomation g emergency infomation g emergency infomation g",
          "1");
      mDbHelper.insert(
          "Emergency Infomation h",
          "emergency infomation h emergency infomation h emergency infomation h",
          "1");
      mDbHelper.insert(
          "Emergency Infomation i",
          "emergency infomation i emergency infomation i emergency infomation i",
          "1");

      // add easy info
      mDbHelper.insert(
          "Easy Infomation 1",
          "easy infomation 1 easy infomation 1 easy infomation 1 easy infomation 1",
          "2");
      mDbHelper.insert(
          "Easy Infomation 2",
          "easy infomation 2 easy infomation 2 easy infomation 2 easy infomation 2",
          "2");
      mDbHelper.insert(
          "Easy Infomation 3",
          "easy infomation 3 easy infomation 3 easy infomation 3 easy infomation 3",
          "2");
      mDbHelper.insert(
          "Easy Infomation 4",
          "easy infomation 4 easy infomation 4 easy infomation 4 easy infomation 4",
          "2");
      mDbHelper.insert(
          "Easy Infomation 5",
          "easy infomation 5 easy infomation 5 easy infomation 5 easy infomation 5",
          "2");
      mDbHelper.insert(
          "Easy Infomation 6",
          "easy infomation 6 easy infomation 6 easy infomation 6 easy infomation 6",
          "2");
      mDbHelper.insert(
          "Easy Infomation 7",
          "easy infomation 7 easy infomation 7 easy infomation 7 easy infomation 7",
          "2");
      mDbHelper.insert(
          "Easy Infomation 8",
          "easy infomation 8 easy infomation 8 easy infomation 8 easy infomation 8",
          "2");
      mDbHelper.insert(
          "Easy Infomation 9",
          "easy infomation 9 easy infomation 9 easy infomation 9 easy infomation 9",
          "2");
    } else {

    }
  }