vQFwS0gP

1public LoginDB(Context context) {
2        super(context, DATABASE_NAME, null, DATABASE_VERSION);
3        // TODO Auto-generated constructor stub
4    }
5
6    @Override
7    public void onCreate(SQLiteDatabase db) {
8        // TODO Auto-generated method stub      
9
10        String sqlDataStore = "create table if not exists " +
11        TABLE_NAME_CREDENTIALS + " ("+ BaseColumns._ID + " integer primary key autoincrement,"
12
13                    + COLUMN_NAME_USERNAME + " text not null,"
14                    + COLUMN_NAME_PASSWORD + " text not null);";
15
16        db.execSQL("CREATE TRIGGER DATABASE_NAME " +
17                " BEFORE INSERT " +
18                " ON "+TABLE_NAME_CREDENTIALS+ 
19                " WHEN  BEGIN " +  
20                " SELECT (( SELECT * FROM " + TABLE_NAME_CREDENTIALS + " WHERE "
21                        + COLUMN_NAME_USERNAME + "' AND "+ COLUMN_NAME_PASSWORD +") IS NOT NULL)" +
22                        " THEN RAISE ( ABORT, 'ID ALREADY EXIST') END;" +
23                        "END;");
24
25
26           db.execSQL(sqlDataStore);
27    }
28	
29public void onClick (View v) {
30
31    rUsername = rName.getText().toString();
32    rPasscode = rCode.getText().toString();
33
34    RegDetails regDetails = new RegDetails();
35    regDetails.setrName(bundleRegName);
36    regDetails.setpCode(bundleRegCode);
37    if(v.getId()==R.id.rtn_button){
38        finish();
39
40    }else if(v.getId()==R.id.reg_button){
41        insertCredentials(regDetails);
42    }
43}
44    private void insertCredentials(RegDetails regDetails){
45
46        LoginDB androidOpenDBHelper = new LoginDB(this);
47        SQLiteDatabase sqliteDB = androidOpenDBHelper.getWritableDatabase();
48
49        ContentValues contentValues = new ContentValues();
50        contentValues.put(LoginDB.COLUMN_NAME_USERNAME, rUsername);
51        contentValues.put(LoginDB.COLUMN_NAME_PASSWORD, rPasscode);
52
53        long affectedColumnid = sqliteDB.insert(LoginDB.TABLE_NAME_CREDENTIALS, null, contentValues);
54
55        Toast.makeText(getApplicationContext(), "Credentials Saved! Please login" + affectedColumnid, Toast.LENGTH_SHORT).show();
56        sqliteDB.close();
57        finish();