jdbctemplate模糊查询
时间: 2023-11-01 10:21:05 浏览: 64
在使用JdbcTemplate进行模糊查询时,可以通过SQL语句的拼接来实现。首先,需要定义一个SQL语句,使用"%"来表示通配符,然后将该SQL语句传递给JdbcTemplate的query方法进行查询。
例如,如果要根据名称模糊查询账户信息,可以编写以下代码:
```
public List<Account> getAccountByLike(String name) {
String sql = "select * from account where name like '%" + name + "%'";
List<Account> accountList = jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(Account.class));
return accountList;
}
```
然后,在测试中调用该方法进行查询:
```
@Test
public void test06() {
List<Account> accountList = accountDao.getAccountByLike("白");
for(Account account : accountList) {
System.out.println("account=" + account);
}
}
```
运行测试方法后,你将会获得模糊查询的结果。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* [Spring JdbcTemplate 多参数查询,以及like模糊查询处理方式](https://blog.csdn.net/wagnteng/article/details/53421772)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *3* [SpringjdbcTemplate模糊查询](https://blog.csdn.net/jxau_dslj/article/details/123515471)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]