i1k4y6Ft

1package com.necatisozer.myapplication.db;
2
3import android.content.ContentValues;
4import android.content.Context;
5import android.database.Cursor;
6import android.database.sqlite.SQLiteDatabase;
7import android.database.sqlite.SQLiteOpenHelper;
8import android.database.sqlite.SQLiteQueryBuilder;
9import android.widget.Toast;
10
11public class DbManager {
12
13    public static final String ColUserName = "UserName";
14    public static final String ColPassword = "Password";
15
16    private static final String DbName = "Students";
17    private static final String TableName = "Logins";
18    private static final int DbVersion = 1;
19    private static final String CreateTable = "CREATE TABLE IF NOT EXISTS " + TableName +
20            "(ID INTEGER PRIMARY KEY AUTOINCREMENT," + ColUserName +
21            " text," + ColPassword + " text);";
22
23    private SQLiteDatabase sqlDb;
24
25    public DbManager(Context context) {
26        DatabaseHelperUser db = new DatabaseHelperUser(context);
27        sqlDb = db.getWritableDatabase();
28    }
29
30    public long insert(ContentValues values) {
31        return sqlDb.insert(TableName, "", values);
32    }
33
34    public Cursor query(String[] projection, String selection, String[] selectionArgs, String sortOrder) {
35        SQLiteQueryBuilder queryBuilder = new SQLiteQueryBuilder();
36        queryBuilder.setTables(TableName);
37
38        return queryBuilder.query(sqlDb, projection, selection, selectionArgs, null, null, sortOrder);
39    }
40
41    static class DatabaseHelperUser extends SQLiteOpenHelper {
42        Context context;
43
44        public DatabaseHelperUser(Context context) {
45            super(context, DbName, null, DbVersion);
46            this.context = context;
47        }
48
49        @Override
50        public void onCreate(SQLiteDatabase db) {
51            db.execSQL(CreateTable);
52            Toast.makeText(context, "Table is created", Toast.LENGTH_LONG).show();
53        }
54
55        @Override
56        public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
57            db.execSQL("DROP TABLE IF EXISTS " + TableName);
58            onCreate(db);
59        }
60    }
61}