java代码中的sql语句错误

[seven_11]

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

[huangqibing0626]

帮顶！！！

[curacfyh]

你的userid后面的字符串不对。
order 之前加个空格吧。

[shukuiyan]

在 userid 两边加单引号，order前要有空格。。。
String sql = "select * from _record where userid = '" + userid + "' order by date desc";这样试试呢？

[seven_11]

额。。。。。。。。。。空格。。。。。我脑残了