java - Saving Values to a database -

i trying make app restaurant. have set local database , have prepared statement save users username , password enable them log system, not seem work. username , passwords not saving. below code, if has solutions, appreciate it.

public class register extends appcompatactivity {  edittext username, password; button registartion;  @override protected void oncreate(bundle savedinstancestate) {     super.oncreate(savedinstancestate);     setcontentview(r.layout.activity_register); }  private connection getconnection() {      string host = "jdbc:mysql://jdbc.fmc.me.uk:3306/db_ben";     string u = "user_ben";     string p = "******";     try     {         connection con = drivermanager.getconnection(host, u, p);         return con;     } catch (sqlexception e)     {         // todo auto-generated catch block         e.printstacktrace();     }     return null; }  private boolean registeruser(){      //get username     edittext regusernamebox = (edittext) findviewbyid(r.id.regusername);     string regusernamestr = regusernamebox.gettext().tostring();      //get password     edittext regpasswordbox = (edittext) findviewbyid(r.id.regpassword);     string regpasswordstr = regpasswordbox.gettext().tostring();      system.out.println(regusernamestr);     system.out.println(regpasswordstr);      int = 0;     connection con = getconnection();     try {         preparedstatement pst = con.preparestatement("insert users values(?,?)");         pst.setstring(1, regusernamestr);         pst.setstring(2,regpasswordstr);         = pst.executeupdate();     } catch (sqlexception e) {         e.printstacktrace();     }     if(i>0)         return true;     return false; }  public void buttonclick() {     final button registerusers = (button) findviewbyid(r.id.bregister);      registerusers.setonclicklistener(new view.onclicklistener() {         @override         public void onclick(view v) {              registeruser();         }     }); } } 

none of methods being called. oncreate sets view activity , nothing. hence, no errors there technically none. have set button click instructions button in create. oncreate should this:

@override protected void oncreate(bundle savedinstancestate) {      super.oncreate(savedinstancestate);      setcontentview(r.layout.activity_register);      final button registerusers = (button) findviewbyid(r.id.bregister);       registerusers.setonclicklistener(new view.onclicklistener() {          @override          public void onclick(view v) {              registeruser();          }      }); } 

now here button assigned variable , clicklistener set oncreate. when click button something.