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

    ArrayList<PublisherInfo>  pInfo = null;
    String sql = "SELECT PUBLISHER_ID, PUBLISHER_NAME FROM ODB_PUBLISHER_INFO WHERE PUBLISHER_ID=?";
    //SqlParameterSource param = new MapSqlParameterSource("publisherID", pubID);
    try {
      //pInfo = jdbcTemp.query(sql, param, new PublisherInfoResultSetExtractor());
      pInfo = (ArrayList<PublisherInfo> ) jdbcTemp.getJdbcOperations().query(sql, new Object[] {pubID} , new PublisherInfoRowMapper());
    } catch (IncorrectResultSizeDataAccessException ex) {
      log.info("Publisher " + pubID + " does not exist...");
    }
    return (pInfo.size()> 0)?pInfo.get(0):null;

  }


  public ArrayList<PublisherInfo> getAllPublishers() throws SQLException {
    String sql = "SELECT * FROM ODB_PUBLISHER_INFO";


    ArrayList<PublisherInfo> pubList = (ArrayList<PublisherInfo>) jdbcTemp.getJdbcOperations().query(sql, new PublisherInfoRowMapper());
    log.debug("ArrayList<PublisherInfo>" + pubList);
    return pubList;
  }

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

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.