class App { public <T extends Msg> ResultSet<T> getResult(Class<T> cls) { return new ResultSet(); } }
PreparedStatement ps = null; ResultSet rs = null; sql = "SELECT * FROM altemp1"; try { ps = con.prepareStatement( sql ); rs = new ResultSet(ps.executeQuery()); while(rs.next()) { ..... } }
private ResultSet queryResultToResultSet(QueryResult qr) { com.github.jasync.sql.db.ResultSet rows = qr.getRows(); if (rows == null) { return new ResultSet(Collections.emptyList(), Collections.emptyList(), null); } else { final List<String> names = rows.columnNames(); final List<JsonArray> arrays = rowDataSeqToJsonArray(rows); return new ResultSet(names, arrays, null); } }
private ResultSet queryResultToResultSet(QueryResult qr) { com.github.jasync.sql.db.ResultSet rows = qr.getRows(); if (rows == null) { return new ResultSet(Collections.emptyList(), Collections.emptyList(), null); } else { final List<String> names = rows.columnNames(); final List<JsonArray> arrays = rowDataSeqToJsonArray(rows); return new ResultSet(names, arrays, null); } }
public io.vertx.ext.sql.ResultSet asList(ResultSet rs) throws SQLException { List<String> columnNames = new ArrayList<>(); ResultSetMetaData metaData = rs.getMetaData(); int cols = metaData.getColumnCount(); for (int i = 1; i <= cols; i++) { columnNames.add(metaData.getColumnLabel(i)); } List<JsonArray> results = new ArrayList<>(); while (rs.next()) { JsonArray result = new JsonArray(); for (int i = 1; i <= cols; i++) { Object res = convertSqlValue(rs.getObject(i)); if (res != null) { result.add(res); } else { result.addNull(); } } results.add(result); } return new io.vertx.ext.sql.ResultSet(columnNames, results, null); }
private ResultSet queryResultToResultSet(QueryResult qr) { final Option<com.github.mauricio.async.db.ResultSet> rows = qr.rows(); if (!rows.isDefined()) { return new ResultSet(Collections.emptyList(), Collections.emptyList(), null); } else { final List<String> names = ScalaUtils.toJavaList(rows.get().columnNames().toList()); final List<JsonArray> arrays = rowDataSeqToJsonArray(rows.get()); return new ResultSet(names, arrays, null); } }
return new ResultSet(); // depends on what you want to do on error
case "next": if (member.getValue() instanceof JsonObject) { obj.setNext(new io.vertx.ext.sql.ResultSet((JsonObject)member.getValue()));
@Before public void before() { columnNames = Arrays.asList("foo", "bar", "wibble"); results = new ArrayList<>(); int numRows = 10; for (int i = 0; i < numRows; i++) { JsonArray result = new JsonArray(); for (int j = 0; j < columnNames.size(); j++) { result.add("res" + j); } results.add(result); } rs = new ResultSet(columnNames, results, null); }
@Test public void testJson() { JsonObject json = rs.toJson(); ResultSet rs2 = new ResultSet(json); assertEquals(rs, rs2); } }
if (outResult) { resultSet = new io.vertx.ext.sql.ResultSet(Collections.emptyList(), Collections.emptyList(), null).setOutput(convertOutputs(statement));