當我查詢的數據只有一條時就出現以下問題
SQLSTATE: 42000?
SQL Error: 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 '' at line 1
Error SQL:SELECT * FROM userinfo WHERE userId=?
SQLSTATE: 42000?
SQL Error: 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 '' at line 1
Error SQL:SELECT * FROM user WHERE userId=?
SQLSTATE: 42000?
SQL Error: 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 '' at line 1
Error SQL:SELECT * FROM userinfo WHERE userId=?
SQLSTATE: 42000?
SQL Error: 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 '' at line 1
Error SQL:SELECT * FROM user WHERE userId=?
2017-09-12
SQL語句有問題，最大的可能原因就是最后的userId后面的字段格式和內容。