Package com.basiscomponents.bc

Class SqlQueryBC

java.lang.Object

com.basiscomponents.bc.SqlQueryBC

public class SqlQueryBC
extends Object

Constructor Summary

Constructors

Constructor	Description
SqlQueryBC(String url)	default Constructor only with url
SqlQueryBC(String driver, String url, String user, String password)	default constuctor setting fields
SqlQueryBC(Connection con)	Contructor with a Connection to use

Method Summary

Modifier and Type	Method	Description
Boolean	execute(String sql)
Boolean	execute(String sql, List<Object> params)
String	getLastExecute()	helper Method to get the last SQL Statementperformed in execute(String, List) to turn on tracing see TracingConfiguration.SQL
String	getLastRetrieve()	helper Method to get the last SQL Statemen tperformed in retrieve(String, List) to turn on tracing see TracingConfiguration.SQL
String	getLastSql()	helper Method to get the last SQL Statementperformed to turn on tracing see TracingConfiguration.SQL
ResultSet	retrieve(String sql)
ResultSet	retrieve(String sql, List<Object> params)

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlQueryBC

public SqlQueryBC(String url)

default Constructor only with url

Parameters:

url - the url to connect to

SqlQueryBC

public SqlQueryBC(String driver,
                  String url,
                  String user,
                  String password)
           throws ClassNotFoundException

default constuctor setting fields

Parameters:

driver - the classname of the driver in use

url - the url to connect to

user - username for the given sql connection

password - password for the given connection

Throws:

ClassNotFoundException - if the given driver can not be found by ClassLoader

SqlQueryBC

public SqlQueryBC(Connection con)
           throws SQLException

Contructor with a Connection to use

Parameters:

con - the Connection to use to interact with

Throws:

SQLException - if Connection.isClosed() throws a SQLException

Method Detail

retrieve

public ResultSet retrieve(String sql)
                   throws SQLException

Throws:

SQLException

retrieve

public ResultSet retrieve(String sql,
                          List<Object> params)
                   throws SQLException

Throws:

SQLException

execute

public Boolean execute(String sql)
                throws SQLException

Throws:

SQLException

execute

public Boolean execute(String sql,
                       List<Object> params)
                throws SQLException

Throws:

SQLException

getLastSql

public String getLastSql()

helper Method to get the last SQL Statementperformed to turn on tracing see TracingConfiguration.SQL

Returns:

the last performed and logged SQL statement. Can be null

getLastRetrieve

public String getLastRetrieve()

helper Method to get the last SQL Statemen tperformed in retrieve(String, List) to turn on tracing see TracingConfiguration.SQL

Returns:

the last performed and logged SQL statement by retrieve(String, List). Can be null

getLastExecute

public String getLastExecute()

helper Method to get the last SQL Statementperformed in execute(String, List) to turn on tracing see TracingConfiguration.SQL

Returns:

the last performed and logged SQL statement by retrieve(String, List). Can be null