sql语句没有写错 在执行的时候idea报错了 在workbench里面也可以执行 有没有大佬说一说 谢谢

Question

``` @Select("select user_number,username from dormitory as a"+
" inner join user_dormitory as b on a.dor_id = b.dor_id"+
"inner join user as c on b.student_number = c.user_number"+
"where a.ridgepole = #{ridgepole} and a.unit = #{unit} and a.door_number = #{doorNumber} and b.room_number = #{roomNumber}"
)

    报错：
    Cause: java.sql.SQLSyntaxErrorException: 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 'a.ridgepole = '10' and a.unit = 'A' and a.door_number = '532' and b.room_number ' at line 1

Answer 1

很明显你的sql都连在一起了啊，
建议把+号后面的字符串都给带上空格