You have an error in your SQL syntax; 请问这到底是什么原因导致的呢?

来源：百度知道 编辑：UC知道 时间：2024/09/18 15:26:16
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 ') limit 500' at line 1 - Execute Query False! Select aid from dede_full_search where arcrank > -1 and () limit 500

你是不是弄得jsp，以及JDBC啊？看来你里面的sql语句有错误···尤其是空的的问题········比如说：String queryString="select password,name,studentID, " +
"sex,age,year," +
"month,day,idcard,college," +
"specialty,grade,studentclass,dorm,door," +
"province,city," +
"telephone,phone,mailbox " +
"from student " +
"where studentID=?";
在倒数第二行里：“from student ”如果student后面没有空格：如 “from student”，那就是这种错误···你仔细想想这是为什么吧··原因很简单

代码贴出来看; 这样子谁知道?