在sqlite android中存储布尔值

public class MyDatabaseHelper extends SQLiteOpenHelper {
    private static final String DATABASE_NAME = "my_database";
    private static final int DATABASE_VERSION = 1;
    private static final String TABLE_NAME = "my_table";
    private static final String COLUMN_NAME_BOOLEAN = "my_boolean";

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

    @Override
    public void onCreate(SQLiteDatabase db) {
        String createTableQuery = "CREATE TABLE " + TABLE_NAME + " (" +
                COLUMN_NAME_BOOLEAN + " INTEGER)";
        db.execSQL(createTableQuery);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // Handle database upgrade if needed
    }

    public void insertBoolean(boolean value) {
        int intValue = value ? 1 : 0;
        SQLiteDatabase db = getWritableDatabase();
        ContentValues values = new ContentValues();
        values.put(COLUMN_NAME_BOOLEAN, intValue);
        db.insert(TABLE_NAME, null, values);
        db.close();
    }

    public boolean getBoolean() {
        SQLiteDatabase db = getReadableDatabase();
        String[] columns = {COLUMN_NAME_BOOLEAN};
        Cursor cursor = db.query(TABLE_NAME, columns, null, null, null, null, null);
        boolean value = false;
        if (cursor.moveToFirst()) {
            int intValue = cursor.getInt(cursor.getColumnIndex(COLUMN_NAME_BOOLEAN));
            value = (intValue == 1);
        }
        cursor.close();
        db.close();
        return value;
    }
}