like语句防止SQL注入

mysql: select * from test where school_name like concat('%',${name},'%')  

oracle: select * from test where school_name like '%'||${name},'%'  

SQL Server:select * from test where school_name like '%'+${name},+'%'

posted @ 2017-07-28 21:02  huiy_小溪  阅读(7481)  评论(0编辑  收藏  举报