US8kmaQ3

1public class DatabaseHelper extends SQLiteOpenHelper {
2 public static final String DATABASE_NAME="register.db";
3public static final String TABLE_NAME="registeration";
4public static final String COL_1="USERNAME";
5public static final String COL_2="FirstName";
6SQLiteDatabase db;
7
8
9public DatabaseHelper(Context context) {
10    super(context, DATABASE_NAME, null, 1);
11
12
13    db.execSQL("CREATE TABLE " + TABLE_NAME + " (USERNAME TEXT,FirstName TEXT)");
14
15}
16
17@Override
18public void onCreate(SQLiteDatabase sqLiteDatabase) {
19    db.execSQL("DROP TABLE IF EXISTS" +TABLE_NAME); //Drop older table if exists
20    onCreate(db);
21
22
23}
24
25@Override
26public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
27
28}
29	
30SQLiteOpenHelper openHelper;
31SQLiteDatabase db;
32Button _btnreg;
33EditText _txtpass,_txtuser;
34
35
36@Override
37protected void onCreate(Bundle savedInstanceState) {
38    super.onCreate(savedInstanceState);
39    setContentView(R.layout.activity_main);
40
41    openHelper = new DatabaseHelper(this);
42    _txtuser = (EditText)findViewById(R.id.txtuser);
43    _txtpass = (EditText)findViewById(R.id.txtpass);
44    _btnreg=(Button)findViewById(R.id.btnreg);
45    _btnreg.setOnClickListener(new View.OnClickListener() {
46        @Override
47        public void onClick(View v) {
48            db=openHelper.getWritableDatabase();
49
50            String user=_txtuser.getText().toString();
51            String pass=_txtpass.getText().toString();
52
53
54            insertdata(user,pass);
55            Toast.makeText(getApplicationContext(), "register successfully",Toast.LENGTH_LONG).show();
56
57        }
58    });
59
60
61
62
63}
64
65private void insertdata(String user, String pass) {
66    ContentValues contentValues = new ContentValues();
67    contentValues.put(DatabaseHelper.COL_1, user);
68    contentValues.put(DatabaseHelper.COL_2, pass);
69
70}
71	
72@Override
73    public void onCreate(SQLiteDatabase sqLiteDatabase) {
74    db.execSQL("DROP TABLE IF EXISTS" +TABLE_NAME); //Drop older table if 
75    exists
76    onCreate(db);
77}
78	
79@Override
80public void onCreate(SQLiteDatabase db) {
81    String sql = "CREATE TABLE IF NOT EXISTS "+TABLE+"("
82            + ID + " integer primary key autoincrement,"
83            + NAME + " text,"
84            + LAST_NAME + " text,"
85            + PHONE + " text,"
86            + EMAIL + " text,"
87            + PHOTO + " BLOB,"
88            + FAVORITE + " boolean"
89            +")";
90    db.execSQL(sql);
91}