@Override public List<T> handle(ResultSet resultSet) throws SQLException { List<T> results = new ArrayList<T>(); while (resultSet.next()) { try { results.add(handler.handle(resultSet)); } catch (RuntimeException e) { log.warn("Unable to handle row " + LensServerDAO.toString(resultSet), e); } } return results; } };
private void executeSql(String sql, ResultSetHandler handler) { Statement stmt = null; ResultSet rstmt = null; try { stmt = conn.createStatement(); rstmt = stmt.executeQuery(sql); while (rstmt.next()) { handler.handle(rstmt); } } catch (SQLException e) { //handle errors } finally { try {rstmt.close();} catch (SQLException ex) {} try {stmt.close();} catch (SQLException ex) {} } }
stmt.executeUpdate(); ResultSet resultSet = stmt.getGeneratedKeys(); generatedKeys = rsh.handle(resultSet); } catch (SQLException e) { this.rethrow(e, sql, params);
generatedKeys = rsh.handle(rs);
queryRunner.fillStatement(stmt, params); rs = stmt.executeQuery(); result = resultSetHandler.handle(rs);
public void testEmptyResultSetHandle() throws SQLException { ResultSetHandler<TestBean> h = new BeanHandler<TestBean>(TestBean.class); TestBean results = h.handle(this.emptyResultSet); assertNull(results); }
public void testEmptyResultSetHandle() throws SQLException { ResultSetHandler<Map<String,Object>> h = new MapHandler(); Map<String,Object> results = h.handle(this.emptyResultSet); assertNull(results); }
public void testEmptyResultSetHandle() throws SQLException { ResultSetHandler<String> h = new ScalarHandler<String>(); Object results = h.handle(this.emptyResultSet); assertNull(results); }
public void testColumnNameHandle() throws SQLException { ResultSetHandler<List<Integer>> h = new ColumnListHandler<Integer>("intTest"); List<Integer> results = h.handle(this.rs); assertNotNull(results); assertEquals(ROWS, results.size()); assertEquals(new Integer(1), results.get(0)); assertEquals(new Integer(3), results.get(1)); }
return rsh.handle(resultSet);
public void testColumnNameHandle() throws SQLException { ResultSetHandler<Integer> h = new ScalarHandler<Integer>("intTest"); Object results = h.handle(this.rs); assertNotNull(results); assertEquals(Integer.valueOf(1), results); }
/** * The actual call to {@code handle()} method. * * @return an array of update counts containing one element for each command in the batch. * @throws SQLException if a database access error occurs. * @see ResultSetHandler#handle(ResultSet) */ @Override public T call() throws SQLException { ResultSet rs = null; T ret = null; try { rs = wrap(ps.executeQuery()); ret = rsh.handle(rs); } catch (SQLException e) { rethrow(e, sql, params); } finally { try { close(rs); } finally { close(ps); if (closeConn) { close(conn); } } } return ret; }
public void testEmptyResultSetHandle() throws SQLException { ResultSetHandler<List<Map<String,Object>>> h = new MapListHandler(); List<Map<String,Object>> results = h.handle(this.emptyResultSet); assertNotNull(results); assertTrue(results.isEmpty()); }
public void testEmptyResultSetHandle() throws SQLException { ResultSetHandler<List<TestBean>> h = new BeanListHandler<TestBean>(TestBean.class); List<TestBean> results = h.handle(this.emptyResultSet); assertNotNull(results); assertTrue(results.isEmpty()); }
public void testEmptyResultSetHandle() throws SQLException { ResultSetHandler<List<Object[]>> h = new ArrayListHandler(); List<Object[]> results = h.handle(this.emptyResultSet); assertNotNull(results); assertTrue(results.isEmpty()); }
public void testEmptyResultSetHandle() throws SQLException { ResultSetHandler<Object[]> h = new ArrayHandler(); Object[] results = h.handle(this.emptyResultSet); assertThat(results, is(emptyArray())); }
public void testEmptyResultSetHandle() throws SQLException { ResultSetHandler<List<String>> h = new ColumnListHandler<String>(); List<String> results = h.handle(this.emptyResultSet); assertNotNull(results); assertTrue(results.isEmpty()); }
public void testEmptyResultSetHandle() throws SQLException { ResultSetHandler<Map<String,Map<String,Object>>> h = new KeyedHandler<String>(); Map<String,Map<String,Object>> results = h.handle(this.emptyResultSet); assertNotNull(results); assertTrue(results.isEmpty()); } }
return rsh.handle(resultSet);
public void testHandle() throws SQLException { ResultSetHandler<Map<String,Object>> h = new MapHandler(); Map<String,Object> results = h.handle(this.rs); assertNotNull(results); assertEquals(COLS, results.keySet().size()); assertEquals("1", results.get("ONE")); assertEquals("2", results.get("two")); assertEquals("THREE", results.get("Three")); }