Refine search
ResultSet rs = stmt.executeQuery("select id from TestObject where id > 0"); assert rs.isBeforeFirst(); assert !rs.isAfterLast(); assert !rs.isFirst(); assert rs.getRow() == 0; assert rs.next(); assert !rs.isBeforeFirst(); assert !rs.isAfterLast(); assert rs.isFirst(); assert rs.getRow() == 1; assert rs.next(); assert !rs.isBeforeFirst(); assert !rs.isAfterLast(); assert !rs.isFirst(); assert !rs.isBeforeFirst(); assert rs.isAfterLast(); assert !rs.isFirst(); assert !rs.isBeforeFirst();
/** * @throws Exception If failed. */ @Test public void testNavigation() throws Exception { ResultSet rs = stmt.executeQuery("select * from TestObject where id > 0"); assert rs.isBeforeFirst(); assert !rs.isAfterLast(); assert !rs.isFirst(); assert !rs.isLast(); assert rs.getRow() == 0; assert rs.next(); assert !rs.isBeforeFirst(); assert !rs.isAfterLast(); assert rs.isFirst(); assert !rs.isLast(); assert rs.getRow() == 1; assert rs.next(); assert !rs.isBeforeFirst(); assert !rs.isAfterLast(); assert !rs.isFirst(); assert rs.isLast(); assert rs.getRow() == 2; assert !rs.next(); assert !rs.isBeforeFirst(); assert rs.isAfterLast(); assert !rs.isFirst(); assert !rs.isLast(); assert rs.getRow() == 0; }
if ( resultSet.isBeforeFirst() ) { resultSet.next();
ResultSet rs = stmt.executeQuery("select * from TestObject where id > 0"); assertTrue(rs.isBeforeFirst()); assertFalse(rs.isAfterLast()); assertFalse(rs.isFirst()); assertEquals(0, rs.getRow()); assertTrue(rs.next()); assertFalse(rs.isBeforeFirst()); assertFalse(rs.isAfterLast()); assertTrue(rs.isFirst()); assertEquals(1, rs.getRow()); assertFalse(rs.isBeforeFirst()); assertFalse(rs.isAfterLast()); assertFalse(rs.isFirst()); assertFalse(rs.isBeforeFirst()); assertFalse(rs.isAfterLast()); assertFalse(rs.isFirst()); assertFalse(rs.isBeforeFirst()); assertTrue(rs.isAfterLast()); assertFalse(rs.isFirst());
ResultSet rs = stmt.executeQuery(id); boolean thisResultSetHasRecords; if (rs.isBeforeFirst()) { thisResultSetHasRecords = true; while(rs.next()) { //do stuff with every record, //rs.next() returns false if empty or after last } } else { thisResultSetHasRecords = false; }
ResultSet res = getData(); if(!res.isBeforeFirst()){ //res.isBeforeFirst() is true if the cursor //is before the first row. If res contains //no rows, rs.isBeforeFirst() is false. System.out.println("0 rows"); } else{ while(res.next()){ // code to display the rows in the table. } }
public long getOID (Connection conn) throws SQLException { String sql = "SELECT last_insert_id()"; ResultSet rs = executeQuery (sql, conn); if (rs.isBeforeFirst()) rs.next(); long oid = rs.getLong (1); rs.close(); return oid; } }
ResultSet rs = tcID.executeQuery(); if(rs.isBeforeFirst()) { System.out.println("Loop TC ID....."+rs.getString("tc_id")); System.out.println("Loop TC Name......"+rs.getString("tc_name")); while(rs.next()){ System.out.println("Inside While....."); ps = con.prepareStatement("insert into execution_testcases (project_id, Rel_id, testcase_id, testcase_name, Flag) values(?,?,?,?,?)"); ps.setString(1, project); ps.setString(2, RelName); ps.setString(3, rs.getString("tc_id")); ps.setString(4, rs.getString("tc_name")); ps.setString(5, "true"); ps.executeUpdate(); } } else { System.out.println("No data in RS!"); }
/** Create a table from a {@link ResultSet}. */ public static String fromResultSet(ResultSet resultSet) throws SQLException { if (resultSet == null) throw new NullPointerException("resultSet == null"); if (!resultSet.isBeforeFirst()) throw new IllegalStateException("Result set not at first."); List<String> headers = new ArrayList<>(); ResultSetMetaData resultSetMetaData = resultSet.getMetaData(); int columnCount = resultSetMetaData.getColumnCount(); for (int column = 0; column < columnCount; column++) { headers.add(resultSetMetaData.getColumnName(column + 1)); } List<String[]> data = new ArrayList<>(); while (resultSet.next()) { String[] rowData = new String[columnCount]; for (int column = 0; column < columnCount; column++) { rowData[column] = resultSet.getString(column + 1); } data.add(rowData); } String[] headerArray = headers.toArray(new String[headers.size()]); String[][] dataArray = data.toArray(new String[data.size()][]); return FlipTable.of(headerArray, dataArray); }
@Test public void testCommonCursorStates() throws SQLException { final ResultSet resultSet = getResultSet(); // right after statement execution, result set is before first row assertTrue(resultSet.isBeforeFirst()); // checking that return values of next and isAfterLast are coherent for (int c = 0; c < 3 && !resultSet.isAfterLast(); ++c) { assertTrue(resultSet.next() != resultSet.isAfterLast()); } // result set is not closed yet, despite fully consumed assertFalse(resultSet.isClosed()); resultSet.close(); // result set is now closed assertTrue(resultSet.isClosed()); // once closed, next should fail thrown.expect(SQLException.class); resultSet.next(); }
@Test public void testCommonCursorStates() throws SQLException { final ResultSet resultSet = getResultSet(); // right after statement execution, result set is before first row assertTrue(resultSet.isBeforeFirst()); // checking that return values of next and isAfterLast are coherent for (int c = 0; c < 3 && !resultSet.isAfterLast(); ++c) { assertTrue(resultSet.next() != resultSet.isAfterLast()); } // result set is not closed yet, despite fully consumed assertFalse(resultSet.isClosed()); resultSet.close(); // result set is now closed assertTrue(resultSet.isClosed()); // once closed, next should fail thrown.expect(SQLException.class); resultSet.next(); }
/** * Test ASK results with a true result * * @throws SQLException */ @Test public void results_ask_true() throws SQLException { ResultSet rset = this.createResults(AbstractResultSetTests.empty, "ASK { }"); Assert.assertNotNull(rset); Assert.assertFalse(rset.isClosed()); Assert.assertTrue(rset.isBeforeFirst()); // Try to move to the result row Assert.assertTrue(rset.next()); // Check the boolean return value Assert.assertTrue(rset.getBoolean(AskResultsMetadata.COLUMN_LABEL_ASK)); // Check no further rows Assert.assertFalse(rset.next()); Assert.assertTrue(rset.isAfterLast()); // Close and clean up rset.close(); Assert.assertTrue(rset.isClosed()); }
/** * Test ASK results with a false result * * @throws SQLException */ @Test public void results_ask_false() throws SQLException { ResultSet rset = this.createResults(AbstractResultSetTests.empty, "ASK { FILTER(false) }"); Assert.assertNotNull(rset); Assert.assertFalse(rset.isClosed()); Assert.assertTrue(rset.isBeforeFirst()); // Try to move to the result row Assert.assertTrue(rset.next()); // Check the boolean return value Assert.assertFalse(rset.getBoolean(AskResultsMetadata.COLUMN_LABEL_ASK)); // Check no further rows Assert.assertFalse(rset.next()); Assert.assertTrue(rset.isAfterLast()); // Close and clean up rset.close(); Assert.assertTrue(rset.isClosed()); }
/** * Tests that SELECT result values can be marshalled to strings OK * * @throws SQLException */ @Test public void results_select_strings_03() throws SQLException { ResultSet rset = this.createResults(ds, "SELECT (STR(?o) AS ?str) { ?s ?p ?o . FILTER(!ISBLANK(?o)) }"); Assert.assertNotNull(rset); Assert.assertFalse(rset.isClosed()); Assert.assertTrue(rset.isBeforeFirst()); Assert.assertFalse(rset.isLast()); // Check all rows allow us to marshal strings OK while (rset.next()) { Assert.assertNotNull(rset.getString(1)); Assert.assertFalse(rset.wasNull()); } Assert.assertTrue(rset.isAfterLast()); rset.close(); Assert.assertTrue(rset.isClosed()); }
/** * Tests that SELECT result values can be marshalled to strings OK * * @throws SQLException */ @Test public void results_select_strings_01() throws SQLException { ResultSet rset = this.createResults(ds, "SELECT (STR(?o) AS ?str) { ?s ?p ?o . FILTER(!ISBLANK(?o)) }"); Assert.assertNotNull(rset); Assert.assertFalse(rset.isClosed()); Assert.assertTrue(rset.isBeforeFirst()); Assert.assertFalse(rset.isLast()); // Check all rows allow us to marshal strings OK while (rset.next()) { Assert.assertNotNull(rset.getString("str")); Assert.assertFalse(rset.wasNull()); } Assert.assertTrue(rset.isAfterLast()); rset.close(); Assert.assertTrue(rset.isClosed()); }
/** * Tests that CONSTRUCT result values can be marshalled to strings OK * * @throws SQLException */ @Test public void results_construct_strings_01() throws SQLException { ResultSet rset = this.createResults(ds, "CONSTRUCT { ?s ?p ?str } WHERE { ?s ?p ?o . FILTER(!ISBLANK(?o)) . BIND(STR(?o) AS ?str) }"); Assert.assertNotNull(rset); Assert.assertFalse(rset.isClosed()); Assert.assertTrue(rset.isBeforeFirst()); Assert.assertFalse(rset.isLast()); // Check all rows allow us to marshal strings OK while (rset.next()) { Assert.assertNotNull(rset.getString(TripleResultsMetadata.COLUMN_LABEL_OBJECT)); Assert.assertFalse(rset.wasNull()); } Assert.assertTrue(rset.isAfterLast()); rset.close(); Assert.assertTrue(rset.isClosed()); }
/** * Tests that SELECT result values can be marshalled to floats OK * * @throws SQLException */ @Test public void results_select_floats_01() throws SQLException { ResultSet rset = this .createResults(ds, "SELECT ?o { ?s ?p ?o . FILTER(DATATYPE(?o) = <" + XSD.xfloat.toString() + ">) }"); Assert.assertNotNull(rset); Assert.assertFalse(rset.isClosed()); Assert.assertTrue(rset.isBeforeFirst()); Assert.assertFalse(rset.isLast()); // Check all rows allow us to marshal floats OK while (rset.next()) { Assert.assertNotNull(rset.getString("o")); Assert.assertFalse(0f == rset.getFloat("o")); Assert.assertFalse(rset.wasNull()); } Assert.assertTrue(rset.isAfterLast()); rset.close(); Assert.assertTrue(rset.isClosed()); }
/** * Tests that CONSTRUCT result values can be marshalled to floats OK * * @throws SQLException */ @Test public void results_construct_floats_01() throws SQLException { ResultSet rset = this.createResults(ds, "CONSTRUCT { ?s ?p ?o } WHERE { ?s ?p ?o . FILTER(DATATYPE(?o) = <" + XSD.xfloat.toString() + ">) }"); Assert.assertNotNull(rset); Assert.assertFalse(rset.isClosed()); Assert.assertTrue(rset.isBeforeFirst()); Assert.assertFalse(rset.isLast()); // Check all rows allow us to marshal floats OK while (rset.next()) { Assert.assertNotNull(rset.getString(TripleResultsMetadata.COLUMN_LABEL_OBJECT)); Assert.assertFalse(0f == rset.getFloat(TripleResultsMetadata.COLUMN_LABEL_OBJECT)); Assert.assertFalse(rset.wasNull()); } Assert.assertTrue(rset.isAfterLast()); rset.close(); Assert.assertTrue(rset.isClosed()); }
/** * Tests that SELECT result values can be marshalled to shorts OK * * @throws SQLException */ @Test public void results_construct_shorts_02() throws SQLException { ResultSet rset = this.createResults(ds, "CONSTRUCT { ?s ?p ?o } WHERE { ?s ?p ?o . FILTER(DATATYPE(?o) = <" + this.getShortTypeUri() + ">) }"); Assert.assertNotNull(rset); Assert.assertFalse(rset.isClosed()); Assert.assertTrue(rset.isBeforeFirst()); Assert.assertFalse(rset.isLast()); // Check all rows allow us to marshal shorts OK while (rset.next()) { Assert.assertNotNull(rset.getString(TripleResultsMetadata.COLUMN_INDEX_OBJECT)); Assert.assertFalse((short) 0 == rset.getShort(TripleResultsMetadata.COLUMN_INDEX_OBJECT)); Assert.assertFalse(rset.wasNull()); } Assert.assertTrue(rset.isAfterLast()); rset.close(); Assert.assertTrue(rset.isClosed()); }
/** * Tests that CONSTRUCT result values can be marshalled to strings OK * * @throws SQLException */ @Test public void results_construct_strings_03() throws SQLException { ResultSet rset = this.createResults(ds, "CONSTRUCT { ?s ?p ?str } WHERE { ?s ?p ?o . FILTER(!ISBLANK(?o)) . BIND(STR(?o) AS ?str) }"); Assert.assertNotNull(rset); Assert.assertFalse(rset.isClosed()); Assert.assertTrue(rset.isBeforeFirst()); Assert.assertFalse(rset.isLast()); // Check all rows allow us to marshal strings OK while (rset.next()) { Assert.assertNotNull(rset.getString(TripleResultsMetadata.COLUMN_INDEX_OBJECT)); Assert.assertFalse(rset.wasNull()); } Assert.assertTrue(rset.isAfterLast()); rset.close(); Assert.assertTrue(rset.isClosed()); }