public void beSafeSimple() throws SQLException { Statement query = connection.createStatement(); query.executeQuery("select * from ANIMAL"); ResultSet zooResults = query.getResultSet(); String columnString = "TYPE, ANIMAL_ID"; connection.createStatement().executeUpdate("insert into HANDLER (" + columnString + ") VALUES (" + PREFIXES[0] + ");"); } }
private void executeInitSql() throws SQLException { if (initFile != null) { try { List<String> sqlList = parseInitFile(initFile); Statement st = createStatement(); for(String sql : sqlList) { boolean hasResult = st.execute(sql); if (hasResult) { ResultSet rs = st.getResultSet(); while (rs.next()) { System.out.println(rs.getString(1)); } } } } catch(Exception e) { LOG.error("Failed to execute initial SQL"); throw new SQLException(e.getMessage()); } } }
throws SQLException { Statement stat = conn.createStatement(); ResultSet rs = null; ScriptReader r = new ScriptReader(reader); continue; boolean resultSet = stat.execute(sql); if (resultSet) { if (rs != null) { rs = null; rs = stat.getResultSet();
private void printResults(Statement statement, boolean hasResults) { if (!hasResults) { return; } try (ResultSet rs = statement.getResultSet()) { ResultSetMetaData md = rs.getMetaData(); int cols = md.getColumnCount(); for (int i = 0; i < cols; i++) { String name = md.getColumnLabel(i + 1); print(name + "\t"); } println(""); while (rs.next()) { for (int i = 0; i < cols; i++) { String value = rs.getString(i + 1); print(value + "\t"); } println(""); } } catch (SQLException e) { printlnError("Error printing results: " + e.getMessage()); } }
/** * @throws Exception If failed. */ @Test public void testExecuteQueryMultipleOnlyResultSets() throws Exception { assert conn.getMetaData().supportsMultipleResultSets(); int stmtCnt = 10; StringBuilder sql = new StringBuilder(); for (int i = 0; i < stmtCnt; ++i) sql.append("select ").append(i).append("; "); assert stmt.execute(sql.toString()); for (int i = 0; i < stmtCnt; ++i) { assert stmt.getMoreResults(); ResultSet rs = stmt.getResultSet(); assert rs.next(); assert rs.getInt(1) == i; assert !rs.next(); } assert !stmt.getMoreResults(); }
@Test public void testExecuteUpdateWithInsert() throws Exception { try (Connection connection = createConnection("blackhole", "blackhole")) { try (Statement statement = connection.createStatement()) { assertEquals(statement.executeUpdate("INSERT INTO test_table VALUES (1), (2)"), 2); assertNull(statement.getResultSet()); assertEquals(statement.getUpdateCount(), 2); assertEquals(statement.getLargeUpdateCount(), 2); } } }
/** * @throws Exception If failed. */ @org.junit.Test public void testCloseResultSet1() throws Exception { stmt.execute(SQL); ResultSet rs = stmt.getResultSet(); stmt.close(); assert rs.isClosed() : "ResultSet must be explicitly closed after close statement"; }
try { connection = dataSource.getConnection(); stmt = connection.createStatement(); if (stmt.execute(query)) { ResultSet rset = stmt.getResultSet(); int count = 0; while (rset.next()) { count++;
public void beSafe() throws SQLException { Statement query = connection.createStatement(); query.executeQuery("select * from ANIMAL"); ResultSet zooResults = query.getResultSet(); String columnString = "TYPE, ANIMAL_ID"; for (String handlerColumn : COLUMNS) { columnString += ", " + handlerColumn; } while (zooResults.next()) { for (String prefix : PREFIXES) { String valuesString = ""; if (prefix.equals("GOPHER_")) { valuesString += "'PLATYPUS'"; } else if (prefix.equals("LLAMA_")) { valuesString += "'DOLLY'"; } valuesString += "," + prefix; for (String column : COLUMNS) { valuesString += "," + column; } connection.createStatement().executeUpdate( "insert into HANDLER (" + columnString + ") VALUES (" + valuesString + ");"); } } }
private void printResults(Statement statement, boolean hasResults) { try { if (hasResults) { ResultSet rs = statement.getResultSet(); if (rs != null) { ResultSetMetaData md = rs.getMetaData(); int cols = md.getColumnCount(); for (int i = 0; i < cols; i++) { String name = md.getColumnLabel(i + 1); print(name + "\t"); } println(""); while (rs.next()) { for (int i = 0; i < cols; i++) { String value = rs.getString(i + 1); print(value + "\t"); } println(""); } } } } catch (SQLException e) { printlnError("Error printing results: " + e.getMessage()); } }
@Test public void testResultSetClose() throws Exception { try (Connection connection = createConnection()) { try (Statement statement = connection.createStatement()) { assertTrue(statement.execute("SELECT 123 x, 'foo' y")); ResultSet result = statement.getResultSet(); assertFalse(result.isClosed()); result.close(); assertTrue(result.isClosed()); } } }
/** * @throws Exception If failed. */ @org.junit.Test public void testExecuteQueryMultipleOnlyResultSets() throws Exception { assert conn.getMetaData().supportsMultipleResultSets(); int stmtCnt = 10; StringBuilder sql = new StringBuilder(); for (int i = 0; i < stmtCnt; ++i) sql.append("select ").append(i).append("; "); assert stmt.execute(sql.toString()); for (int i = 0; i < stmtCnt; ++i) { assert stmt.getMoreResults(); ResultSet rs = stmt.getResultSet(); assert rs.next(); assert rs.getInt(1) == i; assert !rs.next(); } assert !stmt.getMoreResults(); }
@Test public void testExecuteUpdateWithCreateTable() throws Exception { try (Connection connection = createConnection("blackhole", "blackhole")) { try (Statement statement = connection.createStatement()) { assertEquals(statement.executeUpdate("CREATE TABLE test_execute_create (x bigint)"), 0); assertNull(statement.getResultSet()); assertEquals(statement.getUpdateCount(), 0); assertEquals(statement.getLargeUpdateCount(), 0); } } }
/** * @throws Exception If failed. */ @Test public void testJdbcQuery() throws Exception { stmt.execute("select * from JdbcTestObject"); ResultSet rs = stmt.getResultSet(); assertResultSet(rs); }
Statement stmt = null; try { stmt = connection.createStatement(); stmt.execute(QUERY_CHANNEL_SIZE); ResultSet rset = stmt.getResultSet(); if (!rset.next()) { throw new JdbcChannelException("Failed to determine channel size: " + "Query (" + QUERY_CHANNEL_SIZE
@Override public Connection connect( String url, Properties info ) throws SQLException { Connection conn = mock( Connection.class ); Statement stmt = mock( Statement.class ); ResultSet rs = mock( ResultSet.class ); ResultSetMetaData md = mock( ResultSetMetaData.class ); when( stmt.getMaxRows() ).thenReturn( 5 ); when( stmt.getResultSet() ).thenReturn( rs ); when( stmt.executeQuery( anyString() ) ).thenReturn( rs ); when( rs.getMetaData() ).thenReturn( md ); when( rs.getLong( anyInt() ) ).thenReturn( 5L ); when( rs.next() ).thenAnswer( new Answer<Boolean>() { private int count = 0; public Boolean answer( org.mockito.invocation.InvocationOnMock invocation ) throws Throwable { return count++ == 0; } } ); when( md.getColumnCount() ).thenReturn( 1 ); when( md.getColumnName( anyInt() ) ).thenReturn( "count" ); when( md.getColumnType( anyInt() ) ).thenReturn( java.sql.Types.INTEGER ); when( conn.createStatement() ).thenReturn( stmt ); return conn; }
try (Connection myConn = DBUtil.connect(); CallableStatement myFirstCs = myConn.prepareCall("{call getSECTION_NAME(?,?)}")) { myFirstCs.setString(1, searchSection); myFirstCs.registerOutParameter(2, Types.INTEGER); myFirstCs.executeUpdate(); String name = null; System.out.println(myFirstCs.getObject(2)); ResultSet myRs = null; myRs = myFirstCs.getResultSet(); while (myRs.next()) // Retrieve result set rows { name=myRs.getString(1); System.out.print("Section Name: "+name); } myRs.close();
@Test public void testStatementReuse() throws Exception { try (Connection connection = createConnection("blackhole", "blackhole")) { try (Statement statement = connection.createStatement()) { // update statement assertFalse(statement.execute("INSERT INTO test_table VALUES (1), (2)")); assertNull(statement.getResultSet()); assertEquals(statement.getUpdateCount(), 2); assertEquals(statement.getLargeUpdateCount(), 2); // query statement assertTrue(statement.execute("SELECT 123 x, 'foo' y, CAST(NULL AS bigint) z")); ResultSet resultSet = statement.getResultSet(); assertNotNull(resultSet); assertEquals(statement.getUpdateCount(), -1); assertEquals(statement.getLargeUpdateCount(), -1); resultSet.close(); // update statement assertFalse(statement.execute("INSERT INTO test_table VALUES (1), (2), (3)")); assertNull(statement.getResultSet()); assertEquals(statement.getUpdateCount(), 3); assertEquals(statement.getLargeUpdateCount(), 3); } } }
/** * @throws Exception If failed. */ @Test public void testNewQueryTaskFetchSize() throws Exception { stmt.setFetchSize(1); boolean res = stmt.execute("select * from TestObject where id > 0"); assertTrue(res); ResultSet rs = stmt.getResultSet(); assertTrue(rs.next()); assertTrue(rs.next()); assertTrue(rs.next()); stmt.setFetchSize(0); }
/** * @throws Exception If failed. */ @Test public void testJdbcQueryTask2() throws Exception { stmt.execute("select * from JdbcTestObject"); ResultSet rs = stmt.getResultSet(); assertResultSet(rs); }