直接举例说明两者区别,如下代码所示
@Select("select * from dept where ID between #{arg2} and #{arg3} and ${arg0} like '%' #{arg1} '%'\n")
List<Dept> findAllDeptPageBy(String dom,String value,int before,int after);
对照上图和sql语句,已知dept_name对应dom,那么如果你使用#{arg0},就变成了
select * from dept where ID between 1 and 2 and ‘dept_name’ like ‘%’ ‘心’ ‘%’;
这不是我们想要的效果,