java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corres
我的问题是:
java.sql.SQLSyntaxErrorException: 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 ‘=‘admin’ AND PASSWORD=‘123’’ at line 1
根据网上各位的错误总结:最主要的问题是
1、sql语句有错误
2、sql语句漏写
例如:
登陆username
密码password
我之前错误的语句是
“SELECT ID FROM EADMIN WHERE PASSWORD=?”
因为的登录所需要同时从数据库拿出username 、password导致这个问题的出现
更正后
“SELECT ID FROM EADMIN WHERE USERNAME=? AND PASSWORD=?”