Question

jsp中的SQl语句有问题

SQL语句如下:
String condition = "SELECT * FROM user WHERE username="+name+"and"+"password="+password;

运行时出的错: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
请问应该怎样写

Answer 1

String condition = " select * from user where username = "+name+" and password = "+password;

空格加好,,java不会帮你加空格的.你在数据库运行一段没有空格的语句能不出错么..

Answer 2

而且也不能用双引号
String condition = " select * from user where username = "'"+name+"'" and password = "'"+password"'";