jdbcTemplate.query()常用参数
一、参数类型BeanPropertyRowMapper
List<User> users = jdbcTemplate.query("select * from user", new BeanPropertyRowMapper<User>(User.class));
二、参数类型RowMapper
List<User> users1 = jdbcTemplate.query("select * from user", new RowMapper<User>() {
@Override
public User mapRow(ResultSet resultSet, int i) throws SQLException {
int id = resultSet.getInt("id");
String name = resultSet.getString("name");
String psw = resultSet.getString("psw");
User user = new User(id, name, psw);
return user;
}
});
查询结果: