final List<WellPaoPao> wellList = new ArrayList<WellPaoPao>();
String strSql="select distinct t.well_id, t.well_common_name, t.GEO_OFFSET_EAST, t.GEO_OFFSET_NORTH,p.water_prod_daily,p.gas_prod_daily"+
" from cd_well_source t,pc_pro_well_vol_daily p where p.well_id = t.well_id"+
" and p.prod_date = to_date(?, 'yyyy-MM-dd')";
final Object[] params;
if(dt==null)
{
return null;
}else{
params=new Object[]{dt};
}
jdbcTemplate.query(strSql, params,
new RowCallbackHandler(){
public void processRow(java.sql.ResultSet rs) throws java.sql.SQLException
{
while(rs.next()){
WellPaoPao wpp = new WellPaoPao();
wpp.setWellId(rs.getString("well_id"));
wpp.setWellCommon_name(rs.getString("well_common_name"));
wpp.setGeoOffsetEast(rs.getFloat("GEO_OFFSET_EAST"));
wpp.setGeoOffsetNorth(rs.getFloat("GEO_OFFSET_NORTH"));
wpp.setWaterProdDaily(rs.getDouble("water_prod_daily"));
wpp.setGasProdDaily(rs.getDouble("gas_prod_daily"));
wellList.add(wpp);
}
}
}
);
return wellList;
java jdbctemple查询
最新推荐文章于 2024-01-26 12:47:52 发布