求帮忙！org.springframework.jdbc.BadSqlGrammarException

[一二一一二三]

PreparedStatementCallback; bad SQL grammar [SELECT COUNT(*) FROM (SELECT * FROM (SELECT res1.ID id,menu.name name,res1.action action,sub.ROLE_ID roleId, (case when sub.ROLE_ID is not null then 1 else 0 end) as counter FROM (SELECT * FROM ishare.usi_resource ) res1 LEFT JOIN (SELECT * FROM ishare.usi_role_resource rel WHERE rel.ROLE_ID = 741) sub ON res1.ID = sub.RESOURCE_ID left join ishare.usi_menu menu on menu.resource_id = res1.id where res1.DEL_FLAG = 0 and menu.id IN()) temp order by counter)LL]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00936: 缺失表达式|

这个哪里错了？？？希望给出解决方法

[卖水果的net]

where res1.DEL_FLAG = 0 and menu.id IN() IN（这里要有值的） 很明显，你在前台拼接这个子句时，没有值传过来；

[js14982]

menu.id IN()，这里错了，括号中要有值

[ghx287524027]

问题就是你上面两楼说的问题，检查你的拼接语句吧~