Package org.sqlproc.engine.jdbc

Class JdbcSimpleSession

java.lang.Object

org.sqlproc.engine.jdbc.JdbcSimpleSession

All Implemented Interfaces:

SqlSession

public class JdbcSimpleSession
extends Object
implements SqlSession

The JDBC stack implementation of the SQL Engine session contract. In fact it's a simple wrapper for the Connection. It's the first parameter to all primary methods in the SqlQueryEngine and SqlCrudEngine.

The primary contract is the method for the SqlQuery instance creation.

For more info please see the Tutorials.

Author:

Vladimir Hudec

Field Summary

Fields

Modifier and Type	Field	Description
private Connection	connection	The connection to the database.
private String	name	The name of the database related to this session.

Constructor Summary

Constructors

Constructor	Description
JdbcSimpleSession(Connection connection)	Creates a new instance.
JdbcSimpleSession(Connection connection, String name)	Creates a new instance of this dynamic proxy.

Method Summary

Modifier and Type	Method	Description
SqlQuery	createSqlQuery(String queryString)	Creates a new instance of SqlQuery, which is a wrapper around the SQL query command.
int[]	executeBatch(String... statements)	Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
Connection	getConnection()	Returns the internal connection to the database.
String	getName()	The name of the database related to this session.
void	setConnection(Connection connection)	Sets the internal connection to the database.

Methods inherited from class java.lang.Object

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

Field Detail

connection

private Connection connection

The connection to the database. It should be opened.

name

private String name

The name of the database related to this session. It's usage is implementation specific.

Constructor Detail

JdbcSimpleSession

public JdbcSimpleSession(Connection connection)

Creates a new instance.

Parameters:

connection - the connection to the database

JdbcSimpleSession

public JdbcSimpleSession(Connection connection,
                         String name)

Creates a new instance of this dynamic proxy.

Parameters:

connection - the connection to the database

name - the name of the database

Method Detail

getConnection

public Connection getConnection()

Returns the internal connection to the database.

Returns:

the connection to the database

setConnection

public void setConnection(Connection connection)

Sets the internal connection to the database.

Parameters:

connection - the connection to the database

createSqlQuery

public SqlQuery createSqlQuery(String queryString)
                        throws SqlProcessorException

Creates a new instance of SqlQuery, which is a wrapper around the SQL query command.

Specified by:

createSqlQuery in interface SqlSession

Parameters:

queryString - the SQL query command

Returns:

a new instance of a wrapper around the SQL query command

Throws:

SqlProcessorException - in the case of any problem in ORM or JDBC stack

executeBatch

public int[] executeBatch(String... statements)
                   throws SqlProcessorException

Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.

Specified by:

executeBatch in interface SqlSession

Parameters:

statements - SQL statements to be executed in batch

Returns:

an array of update counts containing one element for each command in the batch

Throws:

SqlProcessorException - in the case of any problem in ORM or JDBC stack

getName

public String getName()

Description copied from interface: SqlSession

The name of the database related to this session. It's usage is implementation specific.

Specified by:

getName in interface SqlSession

Returns:

the name of the database related to this session. It's usage is implementation specific.