public class CommanderConnection
extends java.lang.Object
Constructor and Description |
---|
CommanderConnection(java.lang.String jdbcUrl,
java.lang.String jdbcUser,
java.lang.String jdbcPasswd,
java.lang.String jdbcDriver)
constructor
|
Modifier and Type | Method and Description |
---|---|
void |
abort()
Aborts a transaction.
|
void |
close()
Closes the connection.
|
void |
commit()
Commits a transaction (non-null connection only).
|
java.sql.Statement |
createStatement()
Method createStatement
returns a Statement, which needs to be close()d by the caller later.
|
java.sql.Connection |
getConnection() |
static void |
main(java.lang.String[] args)
main() for standalone testing
|
void |
open()
Establish database connection based on JDBC connection parameters passed;
precondition:
url, usr, pwd, jdbc != null
|
java.lang.String |
toString()
Method toString
|
public CommanderConnection(java.lang.String jdbcUrl, java.lang.String jdbcUser, java.lang.String jdbcPasswd, java.lang.String jdbcDriver) throws ConnectionFailedException, ConfigurationException, java.sql.SQLException
jdbcUrl
- DBMS service URLjdbcUser
- user name for login to this servicejdbcPasswd
- password for loginjdbcDriver
- driver; needs to adhere to common JDBC driver syntax!ConnectionFailedException
ConfigurationException
java.sql.SQLException
public java.sql.Connection getConnection()
public void open() throws ConnectionFailedException, ConfigurationException, java.sql.SQLException
ConnectionFailedException
ConfigurationException
java.sql.SQLException
public void close() throws ConnectionFailedException, ConfigurationException
public java.sql.Statement createStatement() throws java.sql.SQLException
query
- java.sql.SQLException
public void commit() throws java.sql.SQLException
java.sql.SQLException
public void abort()
public java.lang.String toString()
toString
in class java.lang.Object
public static void main(java.lang.String[] args)
String
- url database URLString
- user database login nameString
- password database login passwordString
- jdbc database JDBC connectivity