Examples of ResultSetExtractor

de.willuhn.datasource.rmi.ResultSetExtractor
org.springframework.jdbc.core.ResultSetExtractor
Callback interface used by {@link JdbcTemplate}'s query methods. Implementations of this interface perform the actual work of extracting results from a {@link java.sql.ResultSet}, but don't need to worry about exception handling. {@link java.sql.SQLException SQLExceptions}will be caught and handled by the calling JdbcTemplate.
This interface is mainly used within the JDBC framework itself. A {@link RowMapper} is usually a simpler choice for ResultSet processing,mapping one result object per row instead of one result object for the entire ResultSet.
Note: In contrast to a {@link RowCallbackHandler}, a ResultSetExtractor object is typically stateless and thus reusable, as long as it doesn't access stateful resources (such as output streams when streaming LOB contents) or keep result state within the object. @author Rod Johnson @author Juergen Hoeller @since April 24, 2003 @see JdbcTemplate @see RowCallbackHandler @see RowMapper @see org.springframework.jdbc.core.support.AbstractLobStreamingResultSetExtractor

Examples of org.springframework.jdbc.core.ResultSetExtractor

    String query = "SELECT CA01_COD_SOCIETA_VEICOLO  FROM MUTUO WHERE CA01_NR_MUTUO = ?";
    String result = null;
    Object[] bind = new Object[1];
    bind[0] = Long.valueOf(numeroMutuo);
    try {
      result = (String) getJdbcTemplate().query(query, bind, new ResultSetExtractor() {
        public Object extractData(ResultSet rs) throws SQLException, DataAccessException {
          String result = null;
          if (rs.next())
            result = rs.getString(1);
          return result;

View Full Code Here

Examples of org.springframework.jdbc.core.ResultSetExtractor

    String query = "SELECT LGTB002_GRUPPO_COGE, LGTB002_MASTRO_COGE, LGTB002_CONTO_COGE FROM PRATICA WHERE LGTB002_PRATICA = ? AND LGTB002_DT_CHIUSURA is null";
    PianoDeiConti result = null;
    Object[] bind = new Object[1];
    bind[0] = Long.valueOf(numeroPratica);
    try {
      result = (PianoDeiConti) getJdbcTemplate().query(query, bind, new ResultSetExtractor() {
        public Object extractData(ResultSet rs) throws SQLException, DataAccessException {
          PianoDeiConti result = new PianoDeiConti();
          if (rs.next()) {
            result.setCodiceGruppo(rs.getLong(1));
            result.setCodiceMastro(rs.getLong(2));

View Full Code Here

Examples of org.springframework.jdbc.core.ResultSetExtractor

    Long result = null;
    Object[] bind = new Object[2];
    bind[0] = Long.valueOf(numeroMutuo);
    bind[1] = Integer.valueOf(codiceRapportoTraente);
    try {
      result = (Long) getJdbcTemplate().query(query, bind, new ResultSetExtractor() {
        public Object extractData(ResultSet rs) throws SQLException, DataAccessException {
          Long result = null;
          if (rs.next())
            result = rs.getLong(1);
          return result;

View Full Code Here

Examples of org.springframework.jdbc.core.ResultSetExtractor

    String query = "SELECT PF01_COD_GRUPPO, PF01_COD_MASTRO, PF01_COD_CONTO FROM DATIFIN WHERE PF01_NR_MUTUO = ? AND PF01_DT_FINE_VALIDITA is null";
    PianoDeiConti result = null;
    Object[] bind = new Object[1];
    bind[0] = Long.valueOf(numeroMutuo);
    try {
      result = (PianoDeiConti) getJdbcTemplate().query(query, bind, new ResultSetExtractor() {
        public Object extractData(ResultSet rs) throws SQLException, DataAccessException {
          PianoDeiConti result = new PianoDeiConti();
          if (rs.next()) {
            result.setCodiceGruppo(rs.getLong(1));
            result.setCodiceMastro(rs.getLong(2));

View Full Code Here

Examples of org.springframework.jdbc.core.ResultSetExtractor

    query += "MUTUO.CA01_NR_MUTUO = ? ";
    PianoDeiConti result = null;
    Object[] bind = new Object[1];
    bind[0] = Long.valueOf(numeroMutuo);
    try {
      result = (PianoDeiConti) getJdbcTemplate().query(query, bind, new ResultSetExtractor() {
        public Object extractData(ResultSet rs) throws SQLException, DataAccessException {
          PianoDeiConti result = new PianoDeiConti();
          if (rs.next()) {
            result.setCodiceGruppo(rs.getLong(1));
            result.setCodiceMastro(rs.getLong(2));

View Full Code Here

Examples of org.springframework.jdbc.core.ResultSetExtractor

    String query = "SELECT CA02_DSC_INDIRIZZO FROM INDMUTUO WHERE CA02_NR_MUTUO = ? AND CA02_DT_FINE_VALIDITA is null";
    String result = null;
    Object[] bind = new Object[1];
    bind[0] = Long.valueOf(numeroMutuo);
    try {
      result = (String) getJdbcTemplate().query(query, bind, new ResultSetExtractor() {
        public Object extractData(ResultSet rs) throws SQLException, DataAccessException {
          String result = null;
          if (rs.next())
            result = rs.getString(1);
          return result;

View Full Code Here

Examples of org.springframework.jdbc.core.ResultSetExtractor

    Object[] bind = new Object[3];
    bind[0] = Long.valueOf(numeroMutuo);
    bind[1] = dataCfr;
    bind[2] = dataCfr;
    try {
      result = (String) getJdbcTemplate().query(query, bind, new ResultSetExtractor() {
        public Object extractData(ResultSet rs) throws SQLException, DataAccessException {
          String result = null;
          if (rs.next())
            result = rs.getString(1);
          return result;

View Full Code Here

Examples of org.springframework.jdbc.core.ResultSetExtractor

    String query = "SELECT CA01_DSC_MUTUO FROM MUTUO WHERE CA01_NR_MUTUO = ?";
    String result = null;
    Object[] bind = new Object[1];
    bind[0] = Long.valueOf(numeroMutuo);
    try {
      result = (String) getJdbcTemplate().query(query, bind, new ResultSetExtractor() {
        public Object extractData(ResultSet rs) throws SQLException, DataAccessException {
          String result = null;
          if (rs.next())
            result = rs.getString(1);
          return result;

View Full Code Here

Examples of org.springframework.jdbc.core.ResultSetExtractor

    String query = "SELECT AN01_DSB_SOGGETTO FROM SOGGETTI WHERE AN01_NR_SOGGETTO = ?";
    String result = null;
    Object[] bind = new Object[1];
    bind[0] = Long.valueOf(numeroSoggetto);
    try {
      result = (String) getJdbcTemplate().query(query, bind, new ResultSetExtractor() {
        public Object extractData(ResultSet rs) throws SQLException, DataAccessException {
          String result = null;
          if (rs.next())
            result = rs.getString(1);
          return result;

View Full Code Here

Examples of org.springframework.jdbc.core.ResultSetExtractor

    String query = "SELECT CG13_DSC_BANCA FROM BANCA WHERE CG13_COD_BANCA = ?";
    String result = null;
    Object[] bind = new Object[1];
    bind[0] = Long.valueOf(numeroConto);
    try {
      result = (String) getJdbcTemplate().query(query, bind, new ResultSetExtractor() {
        public Object extractData(ResultSet rs) throws SQLException, DataAccessException {
          String result = null;
          if (rs.next())
            result = rs.getString(1);
          return result;

View Full Code Here

0 1 2

TOP

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.