w4Tki5hW

1public class DatabaseHandler extends SQLiteOpenHelper {
2
3   //COLUMNS OF THE NEW USER TABLE
4    public static final String TABLE_NEWUSER = "newUser";
5    public static final String COLUMN_NEWUSER_ID = "id";
6    public static final String COLUMN_NEWUSER_NAME = "name";
7    public static final String COLUMN_NEW_USER_PASSWORD = "password";
8    public static final String COLUMN_NEW_USER_AGE = "age";
9
10    //COLUMNS OF THE BALANCE TABLE
11    public static final String COLUMN_BALANCE_ID = "id";
12    public static final String TABLE_BALANCE = "balanceOfUser";
13    public static final String COLUMN_BALANCE_DOLLARBALANCE = "dollarBalance";
14    public static final String COLUMN_BALANCE_RUBBALANCE = "rubBalance";
15    public static final String COLUMN_BALANCE_NEW_USER_ID = "newUserId";
16
17    private static final String DATABASE_NAME = "webStore";
18    private static final int DATABASE_VERSION = 1;
19
20    private static final String SQL_CREATE_NEWUSER = "CREATE TABLE " + TABLE_NEWUSER + "("
21            + COLUMN_NEWUSER_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
22            + COLUMN_NEWUSER_NAME + " TEXT NOT NULL, "
23            + COLUMN_NEW_USER_PASSWORD + " TEXT NOT NULL, "
24            + COLUMN_NEW_USER_AGE + " INTEGER NOT NULL"
25            + ");";
26    private static final String SQL_CREATE_BALANCE = "CREATE TABLE" + TABLE_BALANCE + "("
27            + COLUMN_BALANCE_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
28            + COLUMN_BALANCE_DOLLARBALANCE + " INTEGER NOT NULL"
29            + COLUMN_BALANCE_RUBBALANCE + " INTEGER NOT NULL"
30            + COLUMN_BALANCE_NEW_USER_ID + " INTEGER NOT NULL"
31            + ");";
32    public DatabaseHandler(Context context){
33        super(context,DATABASE_NAME,null, DATABASE_VERSION);
34    }
35
36    @Override
37    public void onCreate(SQLiteDatabase db) {
38        db.execSQL(SQL_CREATE_BALANCE);
39        db.execSQL(SQL_CREATE_NEWUSER);
40        onCreate(db);
41    }
42
43    @Override
44    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
45        db.execSQL("DROP TABLE IF EXISTS " + TABLE_BALANCE);
46        db.execSQL("DROP TABLE IF EXISTS " + TABLE_NEWUSER);
47    }
48  public DatabaseHandler(Context context, String name, SQLiteDatabase.CursorFactory factory,int version){
49      super(context,DATABASE_NAME,factory,DATABASE_VERSION);
50  }
51	
52public void CreateUser(View view) {
53    etName = (EditText)findViewById(R.id.etName);
54    etPassword = (EditText)findViewById(R.id.etPassword);
55    etAge = (EditText)findViewById(R.id.etAge);
56    String name = String.valueOf(etName.getText());
57    String password = String.valueOf(etPassword.getText());
58    int age = Integer.parseInt(String.valueOf(etAge.getText()));
59    //write to database of user from our edit texts
60    DatabaseHandler databaseHandler = new DatabaseHandler(this);
61    Log.d("Insert: ", "Inserting ..");
62    NewUserDAO dbForUser = new NewUserDAO(this);
63    dbForUser.createNewUser(name,password,age);
64}