ZzjmST4b

1import android.content.ContentValues;
2import android.content.Context;
3import android.database.Cursor;
4import android.database.sqlite.SQLiteDatabase;
5import android.database.sqlite.SQLiteOpenHelper;
6import android.util.Log;
7
8import java.util.ArrayList;
9
10import com.booleanwork.dispoll.Domain.Event;
11import com.booleanwork.dispoll.Domain.Product;
12
13public class DatabaseHandler extends SQLiteOpenHelper {
14 
15    // All Static variables
16    // Database Version
17    private static final int DATABASE_VERSION = 1;
18 
19    // Database Name
20    private static final String DATABASE_NAME = "db";
21 
22    // Login table nombre
23    private static final String TABLE_USERS = "users";
24
25    // Login Table Columns nombres
26    private static final String KEY_ID = "id";
27    private static final String KEY_USERNAME = "username";
28    private static final String KEY_PASSWORD = "password";
29
30    public DatabaseHandler(Context context) {
31        super(context, DATABASE_NAME, null, DATABASE_VERSION);
32    }
33 
34    // Creating Tables
35    @Override
36    public void onCreate(SQLiteDatabase db) {
37        String CREATE_USERS_TABLE = "CREATE TABLE IF NOT EXISTS " + TABLE_USERS + "("
38                + KEY_ID + " INTEGER UNIQUE PRIMARY KEY AUTOINCREMENT NOT NULL,"
39                + KEY_USERNAME + " STRING,"
40                + KEY_PASSWORD + " STRING" + ")";
41        db.execSQL(CREATE_USERS_TABLE);
42    }
43 
44    // Upgrading database
45    @Override
46    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
47        // Drop older table if existed
48        db.execSQL("DROP TABLE IF EXISTS " + TABLE_USERS);
49
50        // Create tables again
51        onCreate(db);
52    }
53
54    public boolean registerUser(String username, String password) {
55        SQLiteDatabase db = this.getWritableDatabase();
56
57        //WITHOUT PARAMETRIZATION 
58
59
60
61        // PARAMETRIZED
62        ContentValues values = new ContentValues();
63        values.put(KEY_USERNAME, username);
64        values.put(KEY_PASSWORD, password);
65
66        Log.d("Inserting:", values.toString());
67
68        // Inserting Row
69        db.insert(TABLE_USERS, null, values);
70        db.close(); // Closing database connection
71        return true;
72    }
73
74    public boolean loginUser (String username, String password) {
75        SQLiteDatabase db = this.getReadableDatabase();
76        String selectQuery="SELECT * FROM " + TABLE_USERS + " WHERE " + KEY_USERNAME + " = " + username;
77        Cursor c = db.rawQuery(selectQuery, null);
78        if (c.moveToFirst()) {
79            db.close();
80            dbPass = c.getString(2);
81        }
82        db.close();
83        if (password = dbPass) return true;
84        else return false;        
85    }
86     
87    /**
88     * Re crate database
89     * Delete all tables and create them again
90     * */
91    public void resetUsers() {
92        SQLiteDatabase db = this.getWritableDatabase();
93        // Delete All Rows
94        db.delete(TABLE_USERS, null, null);
95        db.close();
96    }
97}