Examples of com.odb.core.dao.rowmappers.DataSourceSeriesRowMapper

   * com.odb.core.dao.ODBDAO#getSeriesDataAllByDataSourceID(java.lang.String)
   */
  public ArrayList<DataSourceSeries> getSeriesDataAllByDataSourceID(String dsID) {
    String sql = "SELECT * FROM ODB_DATASOURCE_DATASERIES WHERE DATASOURCE_ID=?";
    ArrayList<DataSourceSeries> dsSeriesList = (ArrayList<DataSourceSeries>) jdbcTemp.getJdbcOperations().query(sql, new Object[] { dsID },
        new DataSourceSeriesRowMapper());
    log.debug("ArrayList<DataSourceSeries>" + dsSeriesList);
    return dsSeriesList;
  }

   */
  public List<DataSourceSeries> getLatestSeriesData(String dsID, int rowNum) throws SQLException {
    // String sql =
    // "SELECT * FROM ODB_DATASOURCE_DATASERIES WHERE DATASOURCE_ID = ? ORDER BY DATASOURCE_SERIES_INDEX_SEQ DESC AND ROWNUM < "+rowNum;
    String sql = "SELECT * FROM ODB_DATASOURCE_DATASERIES WHERE DATASOURCE_ID = ? ORDER BY DATASOURCE_SERIES_INDEX_SEQ DESC LIMIT 0," + rowNum;
    List<DataSourceSeries> latestData = jdbcTemp.getJdbcOperations().query(sql, new Object[] { dsID }, new DataSourceSeriesRowMapper());
    log.debug("ArrayList<DataSourceSeries>=" + latestData);
    return latestData;
  }

Related Classes of com.odb.core.dao.rowmappers.DataSourceSeriesRowMapper

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.