SQL statement: Stringtelobj. getString (& quot; tel & quot;); Stringemailobj. getString (& quot; email & quot ;);...... sqls. add (& quot; updatefromuserloginName & #39; & quot; + uloginName + & quot; & #39;, userName & #39; & quot; + userName + & quot; & #39; whereloginName & #39; & q mysqljava
SQL statement:
String tel = obj. getString ("tel ");
String email = obj. getString ("email ");
......
Sqls. add ("update from user loginName = '" + uloginName + "', userName = '" + userName + "'Where loginName ='" + loginName + "'");
Sqls. add ("update from userinfo loginName = '" + uloginName + "', gender = '" + gender + "', birthday = '" + birthday + "', address = '"+ address +"', mobile = '"+ mobile +"', tel = '"+ tel +"', email = '"+ email + "', quanpin = '"+ CHNUtil. getFullSpell (userName) + "', jianpin ='" + CHNUtil. getFirstSpell (userName) + "'Where loginName = '" + loginName + "'");
Error message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from userinfo loginName = 's123 ', gender = '0', birthday = '2017-12-10 ', address = '000000', m' at line 1
I want to change this information in two tables, but an error occurs. Beginner. I don't know why.