SQLite database in Android

1. "Mastering SQLite Database in Android: A Comprehensive Guide with Java"
2. "Creating Powerful Android Apps with SQLite Database and Java"
3. "The Power of SQLite Database in Android: An In-Depth Overview with Java"
4. "Unlocking the Potential of Android Development: How to Use SQLite Database with Java"
5. "Efficient Data Storage in Android: An Introduction to SQLite Database with Java"
6. "Building Robust Apps with SQLite Database and Java in Android"
7. "From Setup to Implementation: A Step-by-Step Guide to Using SQLite Database in Android with Java"
8. "Getting Started with SQLite Database in Android: A Beginner's Guide with Java"
9. "Maximizing App Performance with SQLite Database and Java in Android"
10. "Elevating Your App to the Next Level: How to Use SQLite Database with Java in Android"

how to create basic CRUD (Create, Read, Update, Delete) functions for an SQLite database in Android:

1. Create a new class that extends SQLiteOpenHelper:

public class DatabaseHelper extends SQLiteOpenHelper {

    private static final String DATABASE_NAME = "myDatabase.db";
    private static final int DATABASE_VERSION = 1;

    private static final String TABLE_NAME = "myTable";
    private static final String COLUMN_ID = "id";
    private static final String COLUMN_NAME = "name";
    private static final String COLUMN_AGE = "age";

    public DatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        String createTableQuery = "CREATE TABLE " + TABLE_NAME + " ("
                + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
                + COLUMN_NAME + " TEXT NOT NULL, "
                + COLUMN_AGE + " INTEGER);";
        db.execSQL(createTableQuery);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // Upgrade database here
    }
}

1. Create CRUD functions inside the DatabaseHelper class:

public long insertData(String name, int age) {
    SQLiteDatabase db = this.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put(COLUMN_NAME, name);
    values.put(COLUMN_AGE, age);
    long newRowId = db.insert(TABLE_NAME, null, values);
    db.close();
    return newRowId;
}

public Cursor getAllData() {
    SQLiteDatabase db = this.getReadableDatabase();
    Cursor cursor = db.query(TABLE_NAME, null, null, null, null, null, null);
    return cursor;
}

public int updateData(int id, String name, int age) {
    SQLiteDatabase db = this.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put(COLUMN_NAME, name);
    values.put(COLUMN_AGE, age);
    int rowsUpdated = db.update(TABLE_NAME, values, COLUMN_ID + "=?", new String[] {String.valueOf(id)});
    db.close();
    return rowsUpdated;
}

public int deleteData(int id) {
    SQLiteDatabase db = this.getWritableDatabase();
    int rowsDeleted = db.delete(TABLE_NAME, COLUMN_ID + "=?", new String[] {String.valueOf(id)});
    db.close();
    return rowsDeleted;
}

1. Call these functions from your activity or fragment:

DatabaseHelper dbHelper = new DatabaseHelper(getContext());

// Insert data
long newRowId = dbHelper.insertData("John", 30);

// Read data
Cursor cursor = dbHelper.getAllData();
while (cursor.moveToNext()) {
    int id = cursor.getInt(cursor.getColumnIndex(COLUMN_ID));
    String name = cursor.getString(cursor.getColumnIndex(COLUMN_NAME));
    int age = cursor.getInt(cursor.getColumnIndex(COLUMN_AGE));
    // Do something with the data
}

// Update data
int rowsUpdated = dbHelper.updateData(newRowId, "John Doe", 31);

// Delete data
int rowsDeleted = dbHelper.deleteData(newRowId);