DataBaseHelper

package com.example.notekanban.Model;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteStatement;

import java.util.ArrayList;

public class DataBaseHelper extends SQLiteOpenHelper {

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

    //TABLE NAME
    public static final String TABLE_ACCOUNT = "account";

    //TABLE ACCOUNT COLUMN
    //ID COLUMN @PrimaryKey
    public static final String KEY_ID = "id";

    //COLUMN name
    public static final String KEY_NAME = "name";

    //COLUMN password
    public static final String KEY_PASSWORD = "password";

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

    public Cursor getData(String sql){
        SQLiteDatabase database = getReadableDatabase();
        return database.rawQuery(sql, null);
    }

    public void executeSQL(String sql){
        SQLiteDatabase database = getWritableDatabase();
        //query to insert
        database.execSQL(sql);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        String sqlNote = "create table note(id_note integer primary key autoincrement, title text, descri text);";
        db.execSQL(sqlNote);
        String sqlAccount = "create table account(id_account integer primary key autoincrement, username string, password string, no_phone string, photo blob);";
        db.execSQL(sqlAccount);
        String  sqlCategory = "create table category(id_category integer primary key autoincrement, hexa integer);";
        db.execSQL(sqlCategory);
        String sqlList = "create table list(id_list integer primary key autoincrement, namelist String, id_note integer, foreign key (id_note) references note(id_note));";
        db.execSQL(sqlList);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }

    //insertUserData
    public void insertData(String name, String password, String noPhone, byte[] photo) {
        //query insert record in database table
        SQLiteDatabase database = getWritableDatabase();

        String sql = "INSERT INTO ACCOUNT VALUES (NULL, ?, ?, ?, ?)";

        SQLiteStatement statement = database.compileStatement(sql);
        statement.bindString(1, name);
        statement.bindString(2, password);
        statement.bindString(3, noPhone);
        statement.bindBlob(4, photo);

        statement.executeInsert();
    }

    public void updateAccountData(String name, String password, String noPhone, byte[] photo, int id) {
        SQLiteDatabase database = getWritableDatabase();

        String sql = "UPDATE account SET name=?, password=?, noPhone=?, photo=? WHERE id=?";

        SQLiteStatement statement = database.compileStatement(sql);

        statement.bindString(1, name);
        statement.bindString(2, password);
        statement.bindString(3, noPhone);
        statement.bindBlob(4, photo);
        statement.bindDouble(5, id);

        statement.execute();
        database.close();
    }

    public void deleteAccountData(int id) {
        SQLiteDatabase database = getWritableDatabase();

        String sql = "DELETE FROM account WHERE id=?";

        SQLiteStatement statement = database.compileStatement(sql);
        statement.clearBindings();
        statement.bindDouble(1, id);

        statement.execute();
        database.close();
    }

}