1.模糊查询中select name from tbl_customer where name like '%'#{name}'%'
如果百分号和要查询的字符串此处指(#{name})
没有用空格隔开那么会导致查询不到数据。
JDBC Connection [com.mysql.jdbc.JDBC4Connection@5ad1eca4] will be managed by Spring
==> Preparing: select name from tbl_customer where name like '%'?'%'
==> Parameters: a(String)
<== Total: 0
2.当把百分号和要查询的字符串此处指(#{name})
用空格隔开就可以查询到数据了。
JDBC Connection [com.mysql.jdbc.JDBC4Connection@762f7f5b] will be managed by Spring
==> Preparing: select name from tbl_customer where name like '%' ? '%'
==> Parameters: a(String)
<== Columns: name
<== Row: Kaiser
<== Total: 1