String sql = "select * from _record where userid = " + userid + "order by date desc";这句到底哪里错了???
信息: Parsing configuration file [struts.xml]
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 'by date desc' at line 1
信息: Parsing configuration file [struts.xml]
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 'by date desc' at line 1
order 之前加个空格吧。
String sql = "select * from _record where userid = '" + userid + "' order by date desc";这样试试呢?