QhN29Ccf

1package com.binangunkreatif.tutor.login;
2
3import android.content.ContentValues;
4import android.content.Context;
5import android.database.Cursor;
6import android.database.sqlite.SQLiteDatabase;
7import android.database.sqlite.SQLiteOpenHelper;
8
9/**
10 * Created by Julian on 18/12/2017.
11 */
12
13public class BasisData extends SQLiteOpenHelper {
14
15    private static final int DATABASE_VERSION = 1;
16    private static final String DATABASE_NAME = "contacts.db";
17    private static final String TABLE_NAME = "contacts";
18    private static final String COLUMN_ID = "id";
19    private static final String COLUMN_NAME = "name";
20    private static final String COLUMN_EMAIL = "email";
21    private static final String COLUMN_UNAME = "uname";
22    private static final String COLUMN_PASS = "pass";
23    private SQLiteDatabase db;
24
25    private static final String TABLE_CREATE = "create table contacts (id integer primary key not null , " +
26            "name text not null , email text not null , uname text not null , pass text not null)";
27
28    public BasisData(Context context)
29    {
30        super(context,DATABASE_NAME,null,DATABASE_VERSION);
31    }
32
33    @Override
34    public void onCreate(SQLiteDatabase db) {
35        db.execSQL(TABLE_CREATE);
36        this.db = db;
37    }
38
39    public void insertContact(Contact c)
40    {
41        db = this.getWritableDatabase();
42        ContentValues values = new ContentValues();
43
44        String query = "select * from contacts";
45        Cursor cursor = db.rawQuery(query , null);
46        int count = cursor.getCount();
47
48        values.put(COLUMN_ID , count);
49        values.put(COLUMN_NAME, c.getName());
50        values.put(COLUMN_EMAIL, c.getEmail());
51        values.put(COLUMN_UNAME, c.getUname());
52        values.put(COLUMN_PASS, c.getPass());
53
54        db.insert(TABLE_NAME , null , values);
55        db.close();
56    }
57
58    public String searchPass (String uname)
59    {
60        db = this.getReadableDatabase();
61        String query = "select uname, pass from "+TABLE_NAME;
62        Cursor cursor = db.rawQuery(query , null);
63        String a, b;
64        b = "not found";
65        if(cursor.moveToFirst())
66        {
67            do {
68                a = cursor.getString(0);
69
70                if (a.equals(uname))
71                {
72                    b = cursor.getString(1);
73                    break;
74                }
75            }
76            while (cursor.moveToNext());
77        }
78        return b;
79    }
80
81    @Override
82    public void onUpgrade(SQLiteDatabase db, int i, int i1) {
83        String query = "DROP TABLE IF EXISTS "+TABLE_NAME;
84        db.execSQL(query);
85        this.onCreate(db);
86
87    }
88}