在拼接表名、GROUP BY、ORDER BY语句时,注意不要用#拼接,
比如GROUP BY #{item}, item为user_number,则拼出来的语句为GROUP BY 'user_number',而不是GROUP BY user_number
在拼接表名、GROUP BY、ORDER BY语句时,注意不要用#拼接,
比如GROUP BY #{item}, item为user_number,则拼出来的语句为GROUP BY 'user_number',而不是GROUP BY user_number
本文标题:Mybatis的sql拼接不要用#
本文链接:https://www.haomeiwen.com/subject/vwvvvdtx.html
网友评论