kfb7aKHZ

1private static final String CREATETABLE_QUERY =
2        "CREATE TABLE IF NOT EXISTS " + UserContact.DatabaseInfo.TABLE_USER + " ( "
3                + UserContact.UserInfo.ID + " INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,"
4                + UserContact.UserInfo.USERNAME + " TEXT NOT NULL,"
5                + UserContact.UserInfo.PASSWORD + " TEXT NOT NULL,"
6                + UserContact.UserInfo.EMAIL + " TEXT NOT NULL,"
7                + UserContact.UserInfo.PHONE_NUMBER + " TEXT NOT NULL);"
8        ;
9
10private static final String CREATETABLE_QUERY_PASSWORD =
11        "CREATE TABLE IF NOT EXISTS " + UserContact.DatabaseInfo.TABLE_PASS + " ( "
12                + UserContact.PasswordTable.ID + " INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,"
13                + UserContact.PasswordTable.NAME + " TEXT NOT NULL,"
14                + UserContact.PasswordTable.POSTERPASSWORD + "INTEGER NOT NULL,"
15                + UserContact.PasswordTable.DESCRIPTION + " TEXT NOT NULL,"
16                + UserContact.PasswordTable.PASSWORD + " TEXT NOT NULL,"
17                + "FOREIGN KEY(" + UserContact.PasswordTable.ID + ") REFERENCES " + UserContact.DatabaseInfo.TABLE_USER + "(" + UserContact.UserInfo.ID +") );"
18        ;
19
20@Override
21public void onCreate(SQLiteDatabase db) {
22    db.execSQL(CREATETABLE_QUERY);
23    db.execSQL(CREATETABLE_QUERY_PASSWORD);
24    Log.e("DATABASE OPERATION", CREATETABLE_QUERY);
25    Log.e("DATABASE OPERATION", CREATETABLE_QUERY_PASSWORD);
26}
27
28public Cursor userRegistred(SQLiteDatabase db){
29    Cursor cursor = db.rawQuery(
30            "SELECT " + UserContact.UserInfo.USERNAME + " FROM "
31                      + UserContact.DatabaseInfo.TABLE_USER, null);
32    return cursor;
33}
34
35public void addUser(SQLiteDatabase db, String username, String password, String email, String phone){
36        ContentValues contentValues = new ContentValues();
37        contentValues.put(UserContact.UserInfo.USERNAME, username);
38        contentValues.put(UserContact.UserInfo.PASSWORD, password);
39        contentValues.put(UserContact.UserInfo.EMAIL, email);
40        contentValues.put(UserContact.UserInfo.PHONE_NUMBER, phone);
41
42        db.insert(UserContact.DatabaseInfo.TABLE_USER, null, contentValues);
43}
44
45public void addPassword(SQLiteDatabase db, String name, String note, String password, int posterpassword){
46
47    ContentValues contentValues = new ContentValues();
48
49    if(password.length() > 0){
50        contentValues.put(UserContact.PasswordTable.POSTERPASSWORD, posterpassword);
51        contentValues.put(UserContact.PasswordTable.NAME, name);
52        contentValues.put(UserContact.PasswordTable.DESCRIPTION, note);
53        contentValues.put(UserContact.PasswordTable.PASSWORD, password);
54
55        db.insert(UserContact.DatabaseInfo.TABLE_PASS, null, contentValues);
56        Log.e("DATABASE OPERATION", " INSERT PASSWORD successfull...");
57    }
58}
59
60public Cursor confirmUser(SQLiteDatabase db, String name, String password){
61    return db.query(UserContact.DatabaseInfo.TABLE_USER, null, " username = ? AND password = ?", new String[] { name, password }, null, null, null);
62}