select * from table where name = #{name}
select * from table where name = ‘小李’
如果你要做动态的排序,比如 order by column,这个时候务必要用${},
select * from table order by 'name' ,这样是没用
select * from table where name = #{name}
select * from table where name = ‘小李’
如果你要做动态的排序,比如 order by column,这个时候务必要用${},
select * from table order by 'name' ,这样是没用