Spring - 如何在不匹配列名的情况下使用 BeanPropertyRowMapper

使用Spring框架进行数据库操作时，通常使用JdbcTemplate来执行SQL语句。而在查询结果映射到Java对象时，可以使用BeanPropertyRowMapper来简化开发过程。

java
public class User {
    private String name;
    private int age;
    // getter and setter methods
}
public class UserDao {
    private JdbcTemplate jdbcTemplate;
    
    public User getUserById(int id) {
        String sql = "SELECT user_name AS name, user_age AS age FROM user WHERE id = ?";
        BeanPropertyRowMapper rowMapper = new BeanPropertyRowMapper<>(User.class);
        rowMapper.setColumnMappings(Collections.singletonMap("name", "name"));
        rowMapper.setColumnMappings(Collections.singletonMap("age", "age"));
        
        return jdbcTemplate.queryForObject(sql, rowMapper, id);
    }
}