Examples of java.sql.Statement

java.sql.Statement
Interface used for executing static SQL statements and returning their results. By default, an object implementing the Statement interface can returns results as ResultSets. For any given Statement object, only one ResultSet can be open at one time. A call to any of the execution methods of Statement will cause any previously created ResultSet object for that Statement to be closed implicitly.
To have multiple ResultSet objects open concurrently, multiple Statement objects must be used.

  
  /**
   * Under the covers this still executes a prepared statement due to the driver handling
   */
  @Test public void testSelect() throws Exception {
    Statement s = conn.createStatement();
    assertTrue(s.execute("select * from tables order by name"));
    TestMMDatabaseMetaData.compareResultSet(s.getResultSet());
  }

View Full Code Here

    assertTrue(s.execute("select * from tables order by name"));
    TestMMDatabaseMetaData.compareResultSet(s.getResultSet());
  }
  
  @Test public void testBlob() throws Exception {
    Statement s = conn.createStatement();
    assertTrue(s.execute("select to_bytes('abc', 'UTF-16')"));
    ResultSet rs = s.getResultSet();
    assertTrue(rs.next());
    byte[] bytes = rs.getBytes(1);
    assertEquals("abc", new String(bytes, Charset.forName("UTF-16")));
  }

View Full Code Here

    byte[] bytes = rs.getBytes(1);
    assertEquals("abc", new String(bytes, Charset.forName("UTF-16")));
  }
  
  @Test public void testClob() throws Exception {
    Statement s = conn.createStatement();
    assertTrue(s.execute("select cast('abc' as clob)"));
    ResultSet rs = s.getResultSet();
    assertTrue(rs.next());
    //getting as a clob is unsupported, since it uses the lo logic
    String clob = rs.getString(1);
    assertEquals("abc", clob);
  }

View Full Code Here

  }


  @Test public void testTransactionCycle() throws Exception {
    //TODO: drill in to ensure that the underlying statement has been set to autocommit false
    conn.setAutoCommit(false); 
    Statement s = conn.createStatement();
    assertTrue(s.execute("select * from tables order by name"));
    conn.setAutoCommit(true);
  }

View Full Code Here

    assertTrue(s.execute("select * from tables order by name"));
    conn.setAutoCommit(true);
  }
  
  @Test public void testPk() throws Exception {
    Statement stmt = conn.createStatement();
    ResultSet rs = stmt.executeQuery("select ta.attname, ia.attnum, ic.relname, n.nspname, tc.relname " +//$NON-NLS-1$
      "from pg_catalog.pg_attribute ta, pg_catalog.pg_attribute ia, pg_catalog.pg_class tc, pg_catalog.pg_index i, " +//$NON-NLS-1$
      "pg_catalog.pg_namespace n, pg_catalog.pg_class ic where tc.relname = E'pg_attribute' AND n.nspname = E'pg_catalog'");
    TestMMDatabaseMetaData.compareResultSet(rs);
  }

View Full Code Here

      assertTrue(e.getMessage().contains("Parsing error"));
    }
  }
  
  @Test public void testEscapedLiteral() throws Exception {
    Statement stmt = conn.createStatement();
    ResultSet rs = stmt.executeQuery("select E'\\n\\thello pg'");
    assertTrue(rs.next());
    assertEquals("\n\thello pg", rs.getString(1));
  }

View Full Code Here

    assertTrue(rs.next());
    assertEquals("\n\thello pg", rs.getString(1));
  }
  
  @Test public void testPgProc() throws Exception {
    Statement stmt = conn.createStatement();
    ResultSet rs = stmt.executeQuery("select * from pg_proc");
    rs.next();
    assertEquals("oid", rs.getArray("proargtypes").getBaseTypeName());
  }

View Full Code Here

    rs.next();
    assertEquals("oid", rs.getArray("proargtypes").getBaseTypeName());
  }
  
  @Test public void testPgProcedure() throws Exception {
    Statement stmt = conn.createStatement();
    ResultSet rs = stmt.executeQuery("select has_function_privilege(100, 'foo')");
    rs.next();
  }

View Full Code Here

    @AfterClass public static void tearDown() throws SQLException {
      connection.close();
    }


    @Test public void testViewMetadataRepositoryMerge() throws Exception {
      Statement s = connection.createStatement();
      ResultSet rs = s.executeQuery("select * from vw");
      rs.next();
      assertEquals(2011, rs.getInt(1));
    }

View Full Code Here

      rs.next();
      assertEquals(2011, rs.getInt(1));
    }
    
    @Test(expected=SQLException.class) public void testViewUpdateMetadataRepositoryMerge() throws Exception {
      Statement s = connection.createStatement();
      s.execute("delete from vw");
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of java.sql.Statement

co.nubetech.hiho.hive.HiveUtility

co.nubetech.hiho.job.TestDBQueryInputJobWithCluster

co.nubetech.hiho.job.TestExportToDB

com.acme.JNDITest

com.alibaba.wasp.jdbc.TestJdbcResultSet

com.alibaba.wasp.jdbc.TestPreparedStatement

com.alibaba.wasp.jdbcx.JdbcXAConnection

com.alimama.mdrill.adhoc.MysqlInfo

com.alimama.web.TableJoin

com.asakusafw.bulkloader.cache.LocalCacheInfoRepositoryTest

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.