Springjdbc like fuzzy query, Spring namedparameterjdbctemplate like query

springjdbc like fuzzy query, Spring namedparameterjdbctemplate like query ,

Springjdbc named parameter like Fuzzy query, namedparameterjdbctemplate like fuzzy query

>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>>

? Copyright Sweet Potato Yiu July 20, 2017

http://www.cnblogs.com/fanshuyao/

When Springjdbc uses a named template class (Namedparameterjdbctemplate) for a like fuzzy query, how do I set it?

Method One: Set in the SQL statement (%)

Java code

2. SELECT * from Jo_user WHERE 1=1 and username like '% ': username '% '
4. : There must be a space on both sides of username
8. If: Username no space on both sides of the query is not data, as follows:
10. SELECT * from Jo_user WHERE 1=1 and username like '% ': username'% '
14. Left Blur Query
16. SELECT * from Jo_user WHERE 1=1 and username like '% ': username
20. Fuzzy query on the right
22. SELECT * from Jo_user WHERE 1=1 and username like:username '% '

Method Two: Set (%) in the value of the parameter, the query SQL statement is just a named parameter

such as "%" + Username + "%"

SQL is as follows:

Java code

1. SELECT * from Jo_user WHERE 1=1 and username Like:username

Both of the above methods have been tested and can be used with confidence.

After testing, the following is not possible (add a double vertical line).

Java code

1. SELECT * from article WHERE title like '% ' | |: TITLE | | '% '

>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>>

? Copyright Sweet Potato Yiu July 20, 2017

http://www.cnblogs.com/fanshuyao/

Springjdbc like fuzzy query, Spring namedparameterjdbctemplate like query