public T handle(ResultSet resultSet) throws SQLException { Object value = quirks.getRSVal(resultSet, 1); try { return (converter.convert(value)); } catch (ConverterException e) { throw new Sql2oException("Error occurred while converting value from database to type " + returnType, e); } } };
@Override protected Row readNext() throws SQLException { Row row = new Row(columnNameToIdxMap, columns.size(), isCaseSensitive,this.quirks); for (Column column : columns) { row.addValue(column.getIndex(), quirks.getRSVal(rs, column.getIndex() + 1)); } return row; } }
@SuppressWarnings("unchecked") public T handle(ResultSet resultSet) throws SQLException { if (useExecuteScalar) { try { return (T) converter.convert(quirks.getRSVal(resultSet, 1)); } catch (ConverterException e) { throw new Sql2oException("Error occurred while converting value from database to type " + metadata.getType(), e); } } // otherwise we want executeAndFetch with object mapping Object pojo = metadata.getObjectConstructor().newInstance(); for (int colIdx = 1; colIdx <= columnCount; colIdx++) { Setter setter = setters[colIdx]; if (setter == null) continue; setter.setProperty(pojo, quirks.getRSVal(resultSet, colIdx)); } return (T) pojo; } };
public Object executeScalar() { long start = System.currentTimeMillis(); logExecution(); try (final PreparedStatement ps = buildPreparedStatement(); final ResultSet rs = ps.executeQuery()) { if (rs.next()) { Object o = getQuirks().getRSVal(rs, 1); long end = System.currentTimeMillis(); logger.debug("total: {} ms; executed scalar [{}]", new Object[]{ end - start, this.getName() == null ? "No name" : this.getName() }); return o; } else { return null; } } catch (SQLException e) { this.connection.onException(); throw new Sql2oException("Database error occurred while running executeScalar: " + e.getMessage(), e); } finally { closeConnectionIfNecessary(); } }
public T handle(ResultSet resultSet) throws SQLException { Object value = quirks.getRSVal(resultSet, 1); try { return (converter.convert(value)); } catch (ConverterException e) { throw new Sql2oException("Error occurred while converting value from database to type " + returnType, e); } } };
@Override protected Row readNext() throws SQLException { Row row = new Row(columnNameToIdxMap, columns.size(), isCaseSensitive,this.quirks); for (Column column : columns) { row.addValue(column.getIndex(), quirks.getRSVal(rs, column.getIndex() + 1)); } return row; } }
@Override protected Row readNext() throws SQLException { Row row = new Row(columnNameToIdxMap, columns.size(), isCaseSensitive,this.quirks); for (Column column : columns) { row.addValue(column.getIndex(), quirks.getRSVal(rs, column.getIndex() + 1)); } return row; } }
@SuppressWarnings("unchecked") public T handle(ResultSet resultSet) throws SQLException { if (useExecuteScalar) { try { return (T) converter.convert(quirks.getRSVal(resultSet, 1)); } catch (ConverterException e) { throw new Sql2oException("Error occurred while converting value from database to type " + metadata.getType(), e); } } // otherwise we want executeAndFetch with object mapping Object pojo = metadata.getObjectConstructor().newInstance(); for (int colIdx = 1; colIdx <= columnCount; colIdx++) { Setter setter = setters[colIdx]; if (setter == null) continue; setter.setProperty(pojo, quirks.getRSVal(resultSet, colIdx)); } return (T) pojo; } };
@SuppressWarnings("unchecked") public T handle(ResultSet resultSet) throws SQLException { if (useExecuteScalar) { try { return (T) converter.convert(quirks.getRSVal(resultSet, 1)); } catch (ConverterException e) { throw new Sql2oException("Error occurred while converting value from database to type " + metadata.getType(), e); } } // otherwise we want executeAndFetch with object mapping Object pojo = metadata.getObjectConstructor().newInstance(); for (int colIdx = 1; colIdx <= columnCount; colIdx++) { Setter setter = setters[colIdx]; if (setter == null) continue; setter.setProperty(pojo, quirks.getRSVal(resultSet, colIdx)); } return (T) pojo; } };
public Object executeScalar() { long start = System.currentTimeMillis(); try { logExecution(); ResultSet rs = buildPreparedStatement().executeQuery(); if (rs.next()) { Object o = getQuirks().getRSVal(rs, 1); if (Anima.of().isEnableSQLStatistic() && log.isDebugEnabled()) { long end = System.currentTimeMillis(); log.debug("total: {} ms; executed scalar [{}]", end - start, this.getName() == null ? "No name" : this.getName()); } return o; } else { return null; } } catch (SQLException e) { this.connection.onException(); throw new Sql2oException("Database error occurred while running executeScalar: " + e.getMessage(), e); } finally { closeConnectionIfNecessary(); } }
public Object executeScalar() { long start = System.currentTimeMillis(); logExecution(); try (final PreparedStatement ps = buildPreparedStatement(); final ResultSet rs = ps.executeQuery()) { if (rs.next()) { Object o = getQuirks().getRSVal(rs, 1); long end = System.currentTimeMillis(); logger.debug("total: {} ms; executed scalar [{}]", new Object[]{ end - start, this.getName() == null ? "No name" : this.getName() }); return o; } else { return null; } } catch (SQLException e) { this.connection.onException(); throw new Sql2oException("Database error occurred while running executeScalar: " + e.getMessage(), e); } finally { closeConnectionIfNecessary(); } }
private <T> ResultSetHandler<T> newScalarResultSetHandler(final Class<T> returnType) { final Quirks quirks = getQuirks(); try { final Converter<T> converter = throwIfNull(returnType, quirks.converterOf(returnType)); return resultSet -> { Object value = quirks.getRSVal(resultSet, 1); try { return (converter.convert(value)); } catch (ConverterException e) { throw new Sql2oException("Error occurred while converting value from database to type " + returnType, e); } }; } catch (ConverterException e) { throw new Sql2oException("Can't get converter for type " + returnType, e); } }