java - JDBC 模板使用 "like"给出查询错误

Question

我不知道如何在下面的查询中使用 %?% 。它给了我错误:

PreparedStatementCallback; uncategorized SQLException for SQL [select * from names where name like '%?%']

问题:

String sql = "select * from names where name like ?";
List<NamesModel> names = jdbcTemplate.query(sql, new Object[]{searchName}, new NamesRowMapper());

Answer 1

您的异常告诉您无法绑定(bind)到带引号的值。以下行不通:

String sql = "select * from names where name like '%?%'";
List<NamesModel> names = jdbcTemplate.query(sql, 
        new Object[]{ searchName }, new NamesRowMapper());

正确的方法是在searchName参数值周围添加%:

String sql = "select * from names where name like ?";
List<NamesModel> names = jdbcTemplate.query(sql, 
        new Object[]{ "%" + searchName + "%"}, new NamesRowMapper());