public static final String DATABASE_NAME4 = "mylistxxx.db"; public static final String TABLE_NAME4 = "mylist_dataxxx"; public static final String COL14 = "iDxxx"; public static final String COL24 = "ITEM1xxx"; public DatabaseHelper4(Context context) { super(context, DATABASE_NAME4, null, 1); } @Override public void onCreate(SQLiteDatabase dbxxx) { String createTable = "CREATE TABLE " + TABLE_NAME4 + " (iDxxx INTEGER PRIMARY KEY AUTOINCREMENT, " + " ITEM1xxx TEXT)"; dbxxx.execSQL(createTable); } @Override public void onUpgrade(SQLiteDatabase dbxxx, int oldVersion, int newVersion) { dbxxx.execSQL("DROP IF TABLE EXISTS " + TABLE_NAME4); onCreate(dbxxx); } public boolean addDataxxx(String textt) { SQLiteDatabase dbxxx = this.getWritableDatabase(); ContentValues contentValues = new ContentValues(); contentValues.put(COL24, textt); long result = dbxxx.insert(TABLE_NAME4, null, contentValues); if (result == -1) { return false; } else { return true; } } public Cursor getListContents() { SQLiteDatabase dbxxx = this.getWritableDatabase(); Cursor dataxxx = dbxxx.rawQuery("SELECT * FROM " + TABLE_NAME4, null); return dataxxx; } public void deleteItem(int iDxxx) { SQLiteDatabase db = getWritableDatabase(); db.execSQL("DELETE FROM " + TABLE_NAME4 + " WHERE " + COL14 + " = " + iDxxx); } public void veriTabanıIndexListele(ArrayList xxid){ SQLiteDatabase db = this.getReadableDatabase(); String[] sutunlar = {"iDxxx"}; Cursor cursor = db.query("mylist_dataxxx",sutunlar,null,null,null,null,null); int idIx = cursor.getColumnIndex("iDxxx"); while (cursor.moveToNext()){ xxid.add(cursor.getInt(idIx)); } cursor.close(); db.close(); } }