com.gooddata.util

Class JdbcUtil

java.lang.Object

com.gooddata.util.JdbcUtil

public class JdbcUtil
extends Object

GoodData JDBC utilities

Version:

1.0

Author:

zd

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	JdbcUtil.DummyResultSetHandler Dummy resultset handler callback; literally does nothing
static interface	JdbcUtil.ResultSetHandler Result set handler callback interface for executeQuery(Connection, String, ResultSetHandler, int)
static interface	JdbcUtil.StatementHandler Statement handler callback interface for executeUpdate(Connection, String, StatementHandler)

Constructor Summary

Constructors

Constructor and Description
JdbcUtil()

Method Summary

Modifier and Type	Method and Description
static void	executeQuery(Connection c, String sql, JdbcUtil.ResultSetHandler handler, int fetchSize) Execute query an passes the ResultSet to the given handler on each record
static void	executeQuery(Connection c, String sql, JdbcUtil.ResultSetHandler handler, int limit, int fetchSize) Execute query an passes the ResultSet to the given handler on each record
static int	executeUpdate(Connection con, String sql) Execute update
static int	executeUpdate(Connection con, String sql, JdbcUtil.StatementHandler sh) Executes an update using a prepared statement.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

JdbcUtil

public JdbcUtil()

Method Detail

executeUpdate

public static int executeUpdate(Connection con,
                                String sql)
                         throws SQLException

Execute update

Parameters:

con - connection

sql - sql statement

Returns:

number of affected rows

Throws:

SQLException - in case of a db issue

executeUpdate

public static int executeUpdate(Connection con,
                                String sql,
                                JdbcUtil.StatementHandler sh)
                         throws SQLException

Executes an update using a prepared statement.

Example:

 final int myid = 42;
 JdbcUtil.executeUpdate(con, "select * from table where id = ?", new StatementHandler() {
     public void prepare(PreparedStatement stmt) throws SQLException {
         stmt.setInt(1, myid);
     }
 });
 

Parameters:

con - connection

sql - sql prepared statement (i.e. may contain the "?" placeholders to be populated by the sh handler

sh - JdbcUtil.StatementHandler instance to setup the prepared statement

Returns:

number of affected rows

Throws:

SQLException - in case of a db issue

executeQuery

public static void executeQuery(Connection c,
                                String sql,
                                JdbcUtil.ResultSetHandler handler,
                                int limit,
                                int fetchSize)
                         throws SQLException,
                                IOException

Execute query an passes the ResultSet to the given handler on each record

Parameters:

c - JDBC connection

sql - sql statement

handler - Jdbc ResultSet handler

limit - maximum number of rows to process

fetchSize - max fetch size

Throws:

SQLException - in case of a db issue

IOException

executeQuery

public static void executeQuery(Connection c,
                                String sql,
                                JdbcUtil.ResultSetHandler handler,
                                int fetchSize)
                         throws SQLException,
                                IOException

Execute query an passes the ResultSet to the given handler on each record

Parameters:

c - JDBC connection

sql - sql statement

handler - Jdbc ResultSet handler

fetchSize - max fetch size

Throws:

SQLException - in case of a db issue

IOException