Facebook
From Ogi_Plus, 3 Years ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 49
  1.  
  2.     public static final String DATABASE_NAME4 = "mylistxxx.db";
  3.     public static final String TABLE_NAME4 = "mylist_dataxxx";
  4.     public static final String COL14 = "iDxxx";
  5.     public static final String COL24 = "ITEM1xxx";
  6.  
  7.  
  8.     public DatabaseHelper4(Context context) {
  9.         super(context, DATABASE_NAME4, null, 1);
  10.     }
  11.  
  12.     @Override
  13.     public void onCreate(SQLiteDatabase dbxxx) {
  14.         String createTable = "CREATE TABLE " + TABLE_NAME4 + " (iDxxx INTEGER PRIMARY KEY AUTOINCREMENT, " +
  15.                 " ITEM1xxx TEXT)";
  16.         dbxxx.execSQL(createTable);
  17.     }
  18.  
  19.     @Override
  20.     public void onUpgrade(SQLiteDatabase dbxxx, int oldVersion, int newVersion) {
  21.         dbxxx.execSQL("DROP IF TABLE EXISTS " + TABLE_NAME4);
  22.         onCreate(dbxxx);
  23.     }
  24.  
  25.     public boolean addDataxxx(String textt) {
  26.         SQLiteDatabase dbxxx = this.getWritableDatabase();
  27.         ContentValues contentValues = new ContentValues();
  28.         contentValues.put(COL24, textt);
  29.  
  30.         long result = dbxxx.insert(TABLE_NAME4, null, contentValues);
  31.  
  32.         if (result == -1) {
  33.             return false;
  34.         } else {
  35.             return true;
  36.         }
  37.     }
  38.  
  39.     public Cursor getListContents() {
  40.         SQLiteDatabase dbxxx = this.getWritableDatabase();
  41.         Cursor dataxxx = dbxxx.rawQuery("SELECT * FROM " + TABLE_NAME4, null);
  42.         return dataxxx;
  43.     }
  44.     public void deleteItem(int iDxxx) {
  45.         SQLiteDatabase db = getWritableDatabase();
  46.         db.execSQL("DELETE FROM " + TABLE_NAME4 + " WHERE " + COL14 + " = " +
  47.                 iDxxx);
  48.     }
  49.     public  void  veriTabanıIndexListele(ArrayList<Integer> xxid){
  50.         SQLiteDatabase db = this.getReadableDatabase();
  51.         String[] sutunlar = {"iDxxx"};
  52.         Cursor cursor = db.query("mylist_dataxxx",sutunlar,null,null,null,null,null);
  53.         int idIx = cursor.getColumnIndex("iDxxx");
  54.         while (cursor.moveToNext()){
  55.             xxid.add(cursor.getInt(idIx));
  56.         }
  57.         cursor.close();
  58.         db.close();
  59.     }
  60. }
  61.  
  62.