java—如何使sql从输入jtextfield的数据中插入字符串

20jt8wwn  于 2021-06-25  发布在  Mysql
关注(0)|答案(1)|浏览(549)

我有一些问题,让插入字符串的工作,它给我一个语法错误,但不能找出原因,有帮助吗?

String sql = "INSERT INTO user VALUES ('"+ jtfEmailAddr.getText()+"'," + 
             "'"+ jtfPassword2.getText() + "'," + 
             "'"+ jtfFName.getText() +"','" + jtfSurname.getText() +"')" +
             "ON DUPLICATE KEY UPDATE password='" + jtfPassword2.getText() + "'"+ `enter code here`
             "firstname='" + jtfFName.getText() + "'," +
             "lastname='" + jtfSurname.getText() + "'";
database.insertIntoDatabase(sql);

错误:

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 'rr'nn)' at line 1

字母rr nn只是随机的测试目的

v9tzhpje

v9tzhpje1#


试着在那里加一个逗号“'”,“没有更多的信息是我看错的部分(当然除了“在这里输入代码”…)

相关问题