`

Ibatis like 查询防止SQL注入的方法

 
阅读更多

Ibatis like 查询防止SQL注入的方法

 

mysql: select * from tbl_school where school_name like concat('%',#name#,'%') 

 

oracle: select * from tbl_school where school_name like '%'||#name#||'%' 

 

sql server:select * from tbl_school where school_name like '%'+#name#+'%'

 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics