org.ddbstoolkit.toolkit.jdbc

Class JDBCConnector

java.lang.Object

org.ddbstoolkit.toolkit.jdbc.JDBCConnector

Direct Known Subclasses:

MySQLConnector, SQLiteConnector

public abstract class JDBCConnector
extends java.lang.Object

JDBC Connection object

Field Summary

Fields

Modifier and Type	Field and Description
protected long	connectionId Connection ID
protected java.sql.Connection	connector Connection object
protected java.lang.String	jdbcString JDBC Connection String

Constructor Summary

Constructors

Modifier	Constructor and Description
	JDBCConnector(java.sql.Connection connector) JDBC Constructor
protected	JDBCConnector(java.lang.String jdbcString) JDBC Connection constructor

Method Summary

Modifier and Type	Method and Description
void	close() Close connection to the database
void	commit() Commit the transaction
int	executePreparedQuery(java.sql.PreparedStatement preparedRequest) Function to execute prepared query
int	executeQuery(java.lang.String sql) Function to launch SQL request
boolean	isAutoCommit() Get auto commit value
boolean	isOpen() Function which check if the connection is opened
void	open() Open connection to the database
java.sql.PreparedStatement	prepareStatement(java.lang.String sql) Prepare a request
java.sql.ResultSet	query(java.lang.String sql) Function to query SQL request
java.sql.ResultSet	queryPreparedStatement(java.sql.PreparedStatement preparedRequest) Query a prepared request
void	rollback() Rollback the transaction
void	setAutoCommit(boolean isAutoCommit) Set auto commit value

Methods inherited from class java.lang.Object

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

Field Detail

connector

protected java.sql.Connection connector

Connection object

jdbcString

protected java.lang.String jdbcString

JDBC Connection String

connectionId

protected long connectionId

Connection ID

Constructor Detail

JDBCConnector

protected JDBCConnector(java.lang.String jdbcString)

JDBC Connection constructor

Parameters:

jdbcString - JDBC String

JDBCConnector

public JDBCConnector(java.sql.Connection connector)

JDBC Constructor

Parameters:

connector - Connector

Method Detail

isOpen

public boolean isOpen()
               throws java.sql.SQLException

Function which check if the connection is opened

Returns:

boolean

Throws:

java.sql.SQLException - SQL Exception

open

public void open()
          throws java.sql.SQLException

Open connection to the database

Throws:

java.sql.SQLException - SQL Exception

close

public void close()
           throws java.sql.SQLException

Close connection to the database

Throws:

java.sql.SQLException - SQL Exception

executeQuery

public int executeQuery(java.lang.String sql)
                 throws java.sql.SQLException

Function to launch SQL request

Parameters:

sql - Request to execute (without protection)

Returns:

Result of the request

Throws:

java.sql.SQLException - SQL Exception

executePreparedQuery

public int executePreparedQuery(java.sql.PreparedStatement preparedRequest)
                         throws java.sql.SQLException

Function to execute prepared query

Parameters:

preparedRequest - SQL request to execute

Returns:

Result of the request

Throws:

java.sql.SQLException - SQL Exception

query

public java.sql.ResultSet query(java.lang.String sql)
                         throws java.sql.SQLException

Function to query SQL request

Parameters:

sql - SQL request to execute (without protection)

Returns:

Result of the request

Throws:

java.sql.SQLException - SQL Exception

queryPreparedStatement

public java.sql.ResultSet queryPreparedStatement(java.sql.PreparedStatement preparedRequest)
                                          throws java.sql.SQLException

Query a prepared request

Parameters:

preparedRequest - Prepared Request

Returns:

Result of the request

Throws:

java.sql.SQLException - SQL Exception

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String sql)
                                            throws java.sql.SQLException

Prepare a request

Parameters:

sql - SQL request to prepare

Returns:

Prepared request

Throws:

java.sql.SQLException - SQL Exception

setAutoCommit

public void setAutoCommit(boolean isAutoCommit)
                   throws java.sql.SQLException

Set auto commit value

Parameters:

isAutoCommit - Boolean indicating expected auto commit value

Throws:

java.sql.SQLException - SQL Exception

isAutoCommit

public boolean isAutoCommit()
                     throws java.sql.SQLException

Get auto commit value

Returns:

Boolean indicating the auto-commit state

Throws:

java.sql.SQLException - SQL Exception

commit

public void commit()
            throws java.sql.SQLException

Commit the transaction

Throws:

java.sql.SQLException - SQL Exception

rollback

public void rollback()
              throws java.sql.SQLException

Rollback the transaction

Throws:

java.sql.SQLException - SQL Exception