EditText editText,editText1,;
Database mydb;
SQLiteDatabase db;
@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);

    mydb = new Database(this);
  db = mydb.getWritableDatabase();
}
public void loginPage(View v) {
    editText = (EditText) findViewById(R.id.username);
    editText1 = (EditText) findViewById(R.id.pasword);
    String username = editText.getText().toString();
    String password = editText1.getText().toString();

    if (username.equals("")) {
        editText.setError("Pls Enter UserName");
    } else if (password.equals(""))
    {
        editText1.setError("pls enter password");
    }
try
{
    StringBuffer sb = new StringBuffer();
    String query = "select * from Users";
    Cursor c = db.rawQuery(query,null);
    boolean res = c.moveToFirst();
    if (res)
    {
        do {
            username = c.getString(0);
            sb.append(username);
        }
        while (c.moveToNext());
    }
    else
    {
        Toast.makeText(MainActivity.this, "Wrong credentials", Toast.LENGTH_SHORT).show();
    }
    String data = sb.toString();
    Intent  i  = new Intent(this,WelcomeActivity.class);
    i.putExtra("k1",data);
    startActivity(i);
}catch (Exception e)
{
    Log.e("ReadDataException",""+e);
}

}
public void signupPage(View v)
{
    Intent i = new Intent(this,SignupActivity.class);
    startActivity(i);
}

Database mydb;
SQLiteDatabase db;
String Gender = "";

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.signuppage);

    mydb = new Database(this);
    db = mydb.getWritableDatabase();
}
public void createAccount(View v)
{
    editText2 = (EditText)findViewById(R.id.username);
    editText3 = (EditText)findViewById(R.id.passwordd);
    editText4 = (EditText)findViewById(R.id.cnfrmpassword);
    editText5 = (EditText)findViewById(R.id.emailaddress);
    editText6  = (EditText)findViewById(R.id.phone);
    RadioGroup rg = (RadioGroup)findViewById(R.id.radio);
    final int id = rg.getCheckedRadioButtonId();
    final RadioButton rb1 = (RadioButton)findViewById(id);
 final    RadioButton rb2 = (RadioButton)findViewById(id);
    String username = editText2.getText().toString();
    String password = editText3.getText().toString();
    String cnfmpasswrd = editText4.getText().toString();
    String email = editText5.getText().toString();
    String phone = editText6.getText().toString();

  rg.setOnCheckedChangeListener(new RadioGroup.OnCheckedChangeListener() {
      @Override
      public void onCheckedChanged(RadioGroup group, int checkedId) {
          switch (id)
          {
              case R.id.male:
              {
                  if (rb1.isChecked())
                  {
                      Gender ="Male";
                  }
              }
              break;
              case R.id.female:
              {
                  if (rb2.isChecked())
                  {
                      Gender = "Female";
                  }
              }
          }
      }
  });
    if (username.equals(""))
    {
        editText2.setError("pls enter name");
    }
    else if (password.equals(""))
    {
        editText3.setError("pls fill fileds");
    }
  else  if (!password.equals(cnfmpasswrd))
    {
        editText4.setError("Does not match passwords");
    }
    else if (email.equals(""))
    {
        editText5.setError("pls enter email address");
    }
    else if (phone.equals(""))
    {
        editText6.setText("pls enter valid number");
    }
    String query = "insert into Users values('"+username+"',"+password+","+email+","+phone+","+Gender+")";
    try
    {
       db.execSQL(query);
        AlertDialog.Builder ab = new AlertDialog.Builder(this);
        ab.setMessage("Account Created Succesfully");
        ab.show();
        setContentView(R.layout.activity_main);
    }
    catch(Exception e)
    {
        Log.e("InsertionException",""+e);
    }
    editText2.setText("");
    editText3.setText("");
    editText4.setText("");
    editText5.setText("");
    editText6.setText("");
}

public static final String DBNAME = "anil";
public static final int VERSION = 1;
public Database(Context c)
{
    super(c,DBNAME,null,VERSION);
}
@Override
public void onCreate(SQLiteDatabase db)
{
    try
    {
    String query = "create table Users(Username TEXT,Password TEXT,Email TEXT,PhoneNumber INTEGER,Gender TEXT)";
        db.execSQL(query);
        }catch (Exception e)
    {
        Log.e("TableCreationException",""+e);
    }
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

}