使用Spring的NamedParameterJdbcTemplate

NamedParameterJdbcTemplate相对于JdbcTemplate主要增加了参数可以命名的功能。

1. 带有条件的查询

List<Map<String, Object>> mapList = new ArrayList<Map<String, Object>>();
List<Map<String, Object>> ylMapList = jdbct.queryForList(

ylsql, paramMap);

2.无条件的查询

String  sql = "select * from MONITOR_EQUIPMENT" ;

List<Map<String, Object>> lists = jdbct.queryForList(sql, new HashMap<>());

3  绑定实体的查询

List<SwmmPltVo> swmmPltList = jdbct.query(sql, paramMap, new RowMapper<SwmmPltVo>() {
@Override
public SwmmPltVo mapRow(ResultSet arg0, int arg1) throws SQLException {
SwmmPltVo t = new SwmmPltVo();
t.setCellAreaIdx(arg0.getInt("cellAreaIdx"));
t.setCellArea(arg0.getDouble("area"));
t.setRoadCode(arg0.getString("code"));
t.setCellId(arg0.getInt("cell_id"));
t.setCellDepth(arg0.getDouble("depth"));
t.setCellDepthidx(arg0.getInt("cellDepthIdx"));
t.setModelTime(arg0.getDouble("model_time"));
t.setModelIdx(arg0.getString("model_idx"));
                return t;
}});