由于最近在用JdbcTemplate,所以记录一下它的API
假设数据库的表叫user
,对应的实体类如下
public class UserEntity{
private int id;
private String name;
// 省略get set
}
1.查询单条数据
String sql1 = "select * from UserEntity where id=666";
UserEntity entity = jdbcTemplate.queryForObject(sql1, new BeanPropertyRowMapper<>(UserEntity .class));