QcR5DcFj

1public class ExternalDatabaseOpenHelper extends SQLiteOpenHelper {
2
3    static final String DATABASE_NAME = "externaldatabase.sqlite";
4    private static final int DATABASE_VERSION = 1;
5
6    private static ExternalDatabaseOpenHelper sDatabaseInstance;
7
8    private ExternalDatabaseOpenHelper(@Nullable Context context) {
9        super(new ExternalDatabaseContext(context), DATABASE_NAME, null, DATABASE_VERSION);
10    }
11
12    static synchronized ExternalDatabaseOpenHelper newInstance(Context context) {
13        if (sDatabaseInstance == null) {
14            sDatabaseInstance = new ExternalDatabaseOpenHelper(context);
15        }
16        return sDatabaseInstance;
17    }
18
19    @Override
20    public void onCreate(SQLiteDatabase db) {
21        String createTableQuery = "CREATE TABLE IF NOT EXISTS person" +
22                "( name VARCHAR," +
23                "  age INTEGER )";
24        db.execSQL(createTableQuery);
25    }
26
27    void insertPerson() {
28        SQLiteDatabase sqLiteDatabase = this.getWritableDatabase();
29        String insertPersonQuery = "INSERT INTO person (name,age) VALUES ('Halil',25)";
30        sqLiteDatabase.execSQL(insertPersonQuery);
31    }
32
33    @Override
34    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
35
36    }
37}