Shulou(Shulou.com)06/02 Report--

Editor to share with you how to prevent SQL injection to achieve iBatis fuzzy query, I hope you will learn something after reading this article, let's discuss it together!

To prevent SQL injection, avoid using $$to pass values when iBatis fuzzy queries. Here are the values passed by fuzzy queries for the ibatis of three different databases.

Mysql: select * from stu where name like concat ('%', # name #,'%') oracle: select * from stu where name like'% | # name # | |% 'SQL Server:select * from stu where name like'%'+ # name # +'% after reading this article, I believe you have some understanding of "how to prevent SQL injection to implement iBatis fuzzy query". If you want to know more about it, welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.