de.vc.report.sources.db

Class DBConnection

java.lang.Object

de.vc.report.sources.db.DBConnection

public class DBConnection
extends java.lang.Object

Represents a connection to a relational database.

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	XML_ATTR_PASSWORD
static java.lang.String	XML_ATTR_URL
static java.lang.String	XML_ATTR_USER
static java.lang.String	XML_TAG

Constructor Summary

Constructors

Constructor and Description
DBConnection(java.lang.String url) New DB connection.
DBConnection(java.lang.String url, java.lang.String user, java.lang.String password) New DB connection.

Method Summary

Modifier and Type	Method and Description
void	configure(de.vc.config.Configuration configuration) Configures the Connection.
protected boolean	connect() Connects to the database.
protected void	disconnect()
protected java.sql.Connection	getOpenConnection() Gets an open connection to the database or NULL, if is not possible to connect to DB.
java.lang.String	getPassword() Gets the password.
java.lang.String	getUrl() Gets the url of the database.
java.lang.String	getUser() Gets the user.
protected boolean	isConnected() Tests, if connected to database.
void	setPassword(java.lang.String password) Sets the password.
void	setUrl(java.lang.String url) Sets the url of the database.
void	setUser(java.lang.String user) Sets the user.

Methods inherited from class java.lang.Object

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

Field Detail

XML_ATTR_PASSWORD

public static final java.lang.String XML_ATTR_PASSWORD

See Also:

Constant Field Values

XML_ATTR_URL

public static final java.lang.String XML_ATTR_URL

See Also:

Constant Field Values

XML_ATTR_USER

public static final java.lang.String XML_ATTR_USER

See Also:

Constant Field Values

XML_TAG

public static final java.lang.String XML_TAG

See Also:

Constant Field Values

Constructor Detail

DBConnection

public DBConnection(java.lang.String url)

New DB connection.

Parameters:

url - URL of database.

DBConnection

public DBConnection(java.lang.String url,
                    java.lang.String user,
                    java.lang.String password)

New DB connection.

Parameters:

url - URL of database.

user - User.

password - Password

Method Detail

configure

public void configure(de.vc.config.Configuration configuration)
               throws de.vc.config.ConfigurationException

Configures the Connection.

Parameters:

configuration - Configuration.

Throws:

de.vc.config.ConfigurationException

connect

protected boolean connect()
                   throws java.sql.SQLException

Connects to the database. You can do this manually but this will also be done automatically if necessary.

Returns:

true, if connected successfully.

Throws:

java.sql.SQLException

disconnect

protected void disconnect()
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

getPassword

public java.lang.String getPassword()

Gets the password.

Returns:

Password.

getUrl

public java.lang.String getUrl()

Gets the url of the database.

Returns:

URL of database.

getUser

public java.lang.String getUser()

Gets the user.

Returns:

User.

getOpenConnection

protected java.sql.Connection getOpenConnection()
                                         throws java.sql.SQLException

Gets an open connection to the database or NULL, if is not possible to connect to DB.

Returns:

Open connection.

Throws:

java.sql.SQLException

isConnected

protected boolean isConnected()
                       throws java.sql.SQLException

Tests, if connected to database.

Returns:

true, if connected.

Throws:

java.sql.SQLException

setPassword

public void setPassword(java.lang.String password)

Sets the password.

Parameters:

password - Password

setUrl

public void setUrl(java.lang.String url)

Sets the url of the database.

Parameters:

url - URL of database.

setUser

public void setUser(java.lang.String user)

Sets the user.

Parameters:

user - User.