Record.java

public class Record{
  private String value;
  private Integer id;
  //setters and getters follow
}

UsingMapper.java

public class UsingMapper{
  
  @Autowired
  private DumbMapper mapper;
  @Autowired
  private Session session;
  
  public List<Record> queryRecords(){
    ResultSet resultSet = session.execute("SELECT * FROM records");
    List<Record> records = mapper.mapList(Record.class, resultSet);
    return records;
  }
  
  public Record queryRecord(Integer id){
    ResultSet resultSet = session.execute ("SELECT * FROM records WHERE id = " + id);
    Record record = mapper.map(Record.class, resultSet);
    return record;
  }
  
}