java - 如何从jdbc模板查询中提取hashmap对象

Question

我正在尝试从 JDBCTemplate 查询中提取 2 个整数列表/数组。我认为检索 map 是最实用的。查询是

Map<Integer, Integer> availabletime = jdbctemp.query("
Select a.hour, 
    s.duration from appointment as a inner join services as s on a.service_fid=s.id 
where date=? and guru_fid=? 
    ",date,guru_fid,//mapperlogic.class);

我需要 a.hour 和 s.duration 作为 HashMap 的键值对。我对这里的行映射器逻辑有点困惑。到目前为止，我仅映射到对象，例如

public class RoleRowMapper implements RowMapper<Role> {

@Override
public Role mapRow(ResultSet row, int rowNum) throws SQLException {
    Role role=new Role();
    role.setId(row.getLong("id"));
    role.setName(row.getString("name"));
    return role;
}

}` 有人可以帮助我将查询结果提取到 map 或多个列表吗？

Answer 1

.query() 将始终返回列表。因此，添加了.get(0)

  public Map<Integer,Integer> getAvailableTime(Date date, Integer guru_fid) {
                return jdbctemp.query("Select a.hour, s.duration from appointment as a inner join services as s on a.service_fid=s.id where date=? and guru_fid=? ",new Object[] { date, guru_fid }, (ResultSet rs) -> {
                HashMap<Integer,Integer> results = new HashMap<>();
                while (rs.next()) {
                    results.put(rs.getInt("a.hour"), rs.getInt("s.duration"));
                }
                return results;
            }).get(0);
    
        }