Examples of java.sql.Statement.executeQuery()

java.sql.Statement.executeQuery()
Executes a supplied SQL statement. Returns a single ResultSet. @param sql an SQL statement to execute. Typically a SELECT statement @return a ResultSet containing the data produced by the SQL statement.Never null. @throws SQLException if an error occurs accessing the database or if the statement produces anything other than a single ResultSet


        rs = stat.executeQuery("select currTid2('x', 1)");
        rs.next();
        assertEquals(1, rs.getInt(1));


        rs = stat.executeQuery("select has_table_privilege('TEST', 'READ')");
        rs.next();
        assertTrue(rs.getBoolean(1));


        rs = stat.executeQuery("select has_database_privilege(1, 'READ')");
        rs.next();

View Full Code Here


        rs = stat.executeQuery("select has_table_privilege('TEST', 'READ')");
        rs.next();
        assertTrue(rs.getBoolean(1));


        rs = stat.executeQuery("select has_database_privilege(1, 'READ')");
        rs.next();
        assertTrue(rs.getBoolean(1));




        rs = stat.executeQuery("select pg_get_userbyid(-1)");

View Full Code Here

        rs = stat.executeQuery("select has_database_privilege(1, 'READ')");
        rs.next();
        assertTrue(rs.getBoolean(1));




        rs = stat.executeQuery("select pg_get_userbyid(-1)");
        rs.next();
        assertEquals(null, rs.getString(1));


        rs = stat.executeQuery("select pg_encoding_to_char(0)");
        rs.next();

View Full Code Here


        rs = stat.executeQuery("select pg_get_userbyid(-1)");
        rs.next();
        assertEquals(null, rs.getString(1));


        rs = stat.executeQuery("select pg_encoding_to_char(0)");
        rs.next();
        assertEquals("SQL_ASCII", rs.getString(1));


        rs = stat.executeQuery("select pg_encoding_to_char(6)");
        rs.next();

View Full Code Here


        rs = stat.executeQuery("select pg_encoding_to_char(0)");
        rs.next();
        assertEquals("SQL_ASCII", rs.getString(1));


        rs = stat.executeQuery("select pg_encoding_to_char(6)");
        rs.next();
        assertEquals("UTF8", rs.getString(1));


        rs = stat.executeQuery("select pg_encoding_to_char(8)");
        rs.next();

View Full Code Here


        rs = stat.executeQuery("select pg_encoding_to_char(6)");
        rs.next();
        assertEquals("UTF8", rs.getString(1));


        rs = stat.executeQuery("select pg_encoding_to_char(8)");
        rs.next();
        assertEquals("LATIN1", rs.getString(1));


        rs = stat.executeQuery("select pg_encoding_to_char(20)");
        rs.next();

View Full Code Here


        rs = stat.executeQuery("select pg_encoding_to_char(8)");
        rs.next();
        assertEquals("LATIN1", rs.getString(1));


        rs = stat.executeQuery("select pg_encoding_to_char(20)");
        rs.next();
        assertEquals("UTF8", rs.getString(1));


        rs = stat.executeQuery("select pg_encoding_to_char(40)");
        rs.next();

View Full Code Here


        rs = stat.executeQuery("select pg_encoding_to_char(20)");
        rs.next();
        assertEquals("UTF8", rs.getString(1));


        rs = stat.executeQuery("select pg_encoding_to_char(40)");
        rs.next();
        assertEquals("", rs.getString(1));


        rs = stat.executeQuery("select pg_get_oid('\"WRONG\"')");
        rs.next();

View Full Code Here


        rs = stat.executeQuery("select pg_encoding_to_char(40)");
        rs.next();
        assertEquals("", rs.getString(1));


        rs = stat.executeQuery("select pg_get_oid('\"WRONG\"')");
        rs.next();
        assertEquals(0, rs.getInt(1));


        rs = stat.executeQuery("select pg_get_oid('TEST')");
        rs.next();

View Full Code Here


        rs = stat.executeQuery("select pg_get_oid('\"WRONG\"')");
        rs.next();
        assertEquals(0, rs.getInt(1));


        rs = stat.executeQuery("select pg_get_oid('TEST')");
        rs.next();
        assertTrue(rs.getInt(1) > 0);


        rs = stat.executeQuery("select pg_get_indexdef(0, 0, false)");
        rs.next();

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.