android - SQLite Auto Increment in java code not working properly -
my project group , running unusual error. working on app , use local database created in java code, using android studio 2.1.1.1.
sadly when create account not auto increment user_id, in fact returns value "0" (without quotation marks) there error in our cursor? there error in our creation of sqlite database? far know integer primary key default auto increment.
private static final string table_create_user = "create table " + user_table + " (" + user_id + " integer primary key," + username + " varchar(200) null, " + name + " varchar(200) null, " + email + " varchar(200) null, " + phonenumber + " varchar(200) null, " + business + " varchar(200) null, " + bio + " varchar(200) null, " + hasstartup + " varchar(200) null, " + password + " varchar(45) null " + ")"; if(!database.isopen()) open(); contentvalues values = new contentvalues(); string query = "select * user "; cursor cursor = database.rawquery(query, null); count = cursor.getcount(); count++; values.put(dbopenhelper.getuserid(), count); values.put(dbopenhelper.getusername(), user.get_accountname()); values.put(dbopenhelper.getbio(), user.get_bio()); values.put(dbopenhelper.getbusiness(), user.get_businessname()); values.put(dbopenhelper.getemail(), user.get_email()); values.put(dbopenhelper.getpassword(), user.get_password()); values.put(dbopenhelper.getphonenumber(), user.get_phonenumber()); values.put(dbopenhelper.getname(), user.get_profilename()); values.put(dbopenhelper.gethasstartup(), user.get_hasstartup()); database.insert(dbopenhelper.getusertable(), null, values); log.i("database", "create succes"); if(database.isopen()) close(); } this have right now: here create table:
private static final string table_create_user = "create table " + user_table + " (" + user_id + " integer primary key autoincrement," + username + " varchar(200) null, " + name + " varchar(200) null, " + email + " varchar(200) null, " + phonenumber + " varchar(200) null, " + business + " varchar(200) null, " + bio + " varchar(200) null, " + branche + " varchar(200) null, " + hasstartup + " varchar(200) null, " + password + " varchar(45) null " + ")"; putting values user:
public void createuser(user user){ if(!database.isopen()) open(); contentvalues values = new contentvalues(); // string query = "select * user "; // cursor cursor = database.rawquery(query, null); // count = cursor.getcount(); // count++; values.put(dbopenhelper.getusername(), user.get_accountname()); values.put(dbopenhelper.getbio(), user.get_bio()); values.put(dbopenhelper.getbusiness(), user.get_businessname()); values.put(dbopenhelper.getemail(), user.get_email()); values.put(dbopenhelper.getpassword(), user.get_password()); values.put(dbopenhelper.getphonenumber(), user.get_phonenumber()); values.put(dbopenhelper.getname(), user.get_profilename()); values.put(dbopenhelper.gethasstartup(), user.get_hasstartup()); values.put(dbopenhelper.getbranche(), user.get_branche()); database.insert(dbopenhelper.getusertable(), null, values); log.i("database", "create succes"); if(database.isopen()) close(); } here read/set info create account fields: public void onsignupclick(view v) { if(v.getid() == r.id.bsignupbutton) { edittext email = (edittext)findviewbyid(r.id.tfemail); edittext uname = (edittext)findviewbyid(r.id.tfuname); edittext companyname = (edittext)findviewbyid(r.id.tfcompanyname); edittext pass1 = (edittext)findviewbyid(r.id.tfpass1); edittext pass2 = (edittext)findviewbyid(r.id.tfpass2); edittext branche = (edittext)findviewbyid(r.id.tfcompanybranche); string emailstr = email.gettext().tostring(); string unamestr = uname.gettext().tostring(); string companynamestr = companyname.gettext().tostring(); string pass1str = pass1.gettext().tostring(); string pass2str = pass2.gettext().tostring(); string branchestr = branche.gettext().tostring(); final progressdialog progressdialog = new progressdialog(this); progressdialog.settitle("creating account"); progressdialog.setmessage("creating... plz wait..."); progressdialog.show(); runnable progressrunnable = new runnable(){ @override public void run() { progressdialog.cancel(); } }; handler pdcanceller = new handler(); pdcanceller.postdelayed(progressrunnable, 3000); if(validatepassword(pass1str) && validateemail(emailstr) && validatepassword(pass2str)){ user.set_accountname(unamestr); user.set_profilename(" "); user.set_businessname(companynamestr); user.set_branche(branchestr); user.set_password(pass1str); user.set_email(emailstr); user.set_bio(" "); user.set_phonenumber(" "); user.set_hasstartup("yes"); userdao.createuser(user); users = userdao.getusers(); toast pass = toast.maketext(this, "account has been created", toast.length_long); pass.setgravity(gravity.bottom|gravity.center, 0, 10); pass.show(); (user u : users) { string text = u.get_accountname() + " " + u.get_id() + " " + u.get_branche(); log.i("database", text); } // loguserin(); intent = new intent(this, login.class); startactivity(i); } if(!pass1str.equals(pass2str)) { pass2.seterror("passwords don't match"); pass2.requestfocus(); } if(emailstr.length() == 0 || unamestr.length() == 0 || pass1str.length() == 0 || pass2str.length() == 0 || companynamestr.length() == 0 ){ //popup msg toast pass = toast.maketext(signupbusiness.this, "please fill in fields ", toast.length_short); pass.setgravity(gravity.bottom|gravity.center, 0, 10); pass.show(); } if(!validateemail(emailstr)) { email.seterror("invalid email"); email.requestfocus(); } if (!validatepassword(pass1str)) { pass1.seterror("invalid password, use 10 or more characters"); pass1.requestfocus(); } } }
Comments
Post a Comment