可以借助注解 @Column 去指定该字段的列名,并且在 SQL 语句中使用别名将字段名改写为列名。示例代码如下:
public class User {
@Column("user_name")
private String userName;
private int age;
//getters and setters
}
String sql = "select user_name as userName, age from users";
BeanPropertyRowMapper rowMapper = new BeanPropertyRowMapper<>(User.class);
List userList = jdbcTemplate.query(sql, rowMapper);