大家帮帮忙 我这个错都忙一天了都不知道怎么错的!
java.sql.SQLException: 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 'as t limit 0,10' at line 1
java.sql.SQLException: 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 'as t limit 0,10' at line 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2927)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:956)
at com.freebridge.tvsdbConnection.Data.StmtExecSqlGetResultSet(Data.java:174)
at com.freebridge.service.Conplain.complainSearch(Conplain.java:150)
at com.freebridge.action.ComplainAction.complainSearch(ComplainAction.java:114)。。。。。。。。。
错在(near 'as t limit 0,10' )这个附近。我建议把你的sql语句贴出来