spring 中的 RowMapper

sping中的RowMapper可以将数据中的每一行数据封装成用户定义的类.

 public final static String QUERY_SQL_NODE = "select n.id,n.name,n.ip, n.port ,n.type from t_Node n where n.type = " + NodeType.CC.getChar();
   
  

public List<ParameterModel> getDCParameterListByQuery(ParameterQuery query) {
        List<ParameterModel> list = null;
        
        RowMapper mapper = new RowMapper() {
            public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
                ParameterModel info = new ParameterModel();
                info.setKey(rs.getString(1));
                info.setCode(rs.getString(2));
                info.setValue(rs.getString(3));
                info.setType(rs.getString(4));
                return info;
            }
        };
        try {
            list = getJdbcTemplate().query(QUERY_SQL_PARAMETER_KEY_TYPE, new Object[] {query.getKey() , query.getType()} , mapper);

        } catch (Exception ex) {
            //ProcessorController.afterThrowing("iPGAccessDBError");
            log.error(ex);
            throw new AppRuntimeException(CommInfo.DATABASE_EXCEPTION, ex.getCause());
        }      
        
        return list;
    }