net.aditsu.jdbsimple

Class Conn

java.lang.Object

net.aditsu.jdbsimple.Conn

public class Conn
extends Object

Wrapper for Connection that keeps a cache of prepared statements

Author:

aditsu

Constructor Summary

Constructors

Constructor and Description
Conn(Connection c)

Method Summary

Methods

Modifier and Type	Method and Description
void	close()
void	commit()
RSet	getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)
RSet	getExportedKeys(String catalog, String schema, String table)
RSet	getImportedKeys(String catalog, String schema, String table)
DatabaseMetaData	getMetaData()
RSet	getPrimaryKeys(String catalog, String schema, String table)
RSet	getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)
RSet	getTableTypes()
Stmt	prepareStmt(String sql) Creates a prepared statement with the default result set features; reuses cached statement if available
Stmt	prepareStmt(String sql, boolean custom) Creates a prepared statement; reuses cached statement if available
void	rollback()
void	setAutoCommit(boolean autoCommit)
void	setTransactionIsolation(IsolationLevel level)
int	update(String sql)

Methods inherited from class java.lang.Object

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

Constructor Detail

Conn

public Conn(Connection c)

Method Detail

close

public void close()

setAutoCommit

public void setAutoCommit(boolean autoCommit)

commit

public void commit()

rollback

public void rollback()

prepareStmt

public Stmt prepareStmt(String sql)

Creates a prepared statement with the default result set features; reuses cached statement if available

prepareStmt

public Stmt prepareStmt(String sql,
               boolean custom)

Creates a prepared statement; reuses cached statement if available

Parameters:

sql - SQL string to prepare

custom - flag indicating whether to use additional parameters in prepareStatement (result set type, concurrency and holdability - needed for some drivers, unsupported by others)

Returns:

prepared statement wrapped in a Stmt object

getTables

public RSet getTables(String catalog,
             String schemaPattern,
             String tableNamePattern,
             String[] types)

getTableTypes

public RSet getTableTypes()

getColumns

public RSet getColumns(String catalog,
              String schemaPattern,
              String tableNamePattern,
              String columnNamePattern)

getExportedKeys

public RSet getExportedKeys(String catalog,
                   String schema,
                   String table)

getImportedKeys

public RSet getImportedKeys(String catalog,
                   String schema,
                   String table)

getPrimaryKeys

public RSet getPrimaryKeys(String catalog,
                  String schema,
                  String table)

getMetaData

public DatabaseMetaData getMetaData()

setTransactionIsolation

public void setTransactionIsolation(IsolationLevel level)

update

public int update(String sql)