jdbcTemplate查询数据的简单使用

首先在Spring中注入：

@Autowired
private JdbcTemplate jdbcTemplate;

下面是几种情况：

1.没有定义任何bean，查询数据

 

String sql = "select * from user where userName like '%小明%';

List<Map<String, Object>> maps = jdbcTemplate.queryForList(sql);

 

2.定义了返回的bean，返回List集合对象

String sql = "select * from user where userName like '%小明%';

List<User> query = jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(User.class));

 

3.定义了返回的bean，确保sql只会返回一条数据，并传入参数如id

String sql = "select * from user where id = ?";

User user = jdbcTemplate.queryForObject(sql, new BeanPropertyRowMapper<User>(User.class), 1);

 

4.查询sql返回的条数

String sql="select count(1) from user";

Long total = jdbcTemplate.queryForObject(sql, Long.class);