如何从查询中检索列值 [英] how to retrieve column values from query

问题描述

列表与LT; G_DriverStatus> res = this.getJdbcTemplate（）。query（选择driverid，drivername，min（timedelay）作为driver_status group by driverid的时间延迟，drivername，新的DriverStatusMapper（））; 

< pre lang =   xml> private  class  DriverStatusMapper  implements  RowMapper< G_DriverStatus> {
  public  G_DriverStatus mapRow（ResultSet rs， int  i） throws  SQLException {
 G_DriverStatus g = new G_DriverStatus（）; 
 g.setDriverid（rs.getString（  driverid））; 
 g.setDrivername（rs.getString（  drivername））; 
 g.setTimedelay（rs.getBigDecimal（  timedelay））; 
  return  g; 
} 
} 

如何从res获取值？

解决方案

res是G_DriverStatus对象的列表。每个对象代表每一行。因此，只需遍历列表，您将获得该对象，然后在每个对象上调用getter方法，您将获得列值

List<G_DriverStatus> res = this.getJdbcTemplate().query("select driverid,drivername,min(timedelay) as timedelay from driver_status group by driverid,drivername", new DriverStatusMapper());

<pre lang="xml">private class DriverStatusMapper implements RowMapper<G_DriverStatus>{
        public G_DriverStatus mapRow(ResultSet rs,int i) throws SQLException{
            G_DriverStatus g=new G_DriverStatus();
            g.setDriverid(rs.getString("driverid"));
            g.setDrivername(rs.getString("drivername"));
            g.setTimedelay(rs.getBigDecimal("timedelay"));
            return g;
        }
    }

how to get values from res ?

解决方案

"res" is a list of G_DriverStatus object. each object represent each row. So just iterate over the list you will get the object and then call the getter method on each object you will get the column value

这篇关于如何从查询中检索列值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！