agentgui.core.database

Class DBConnection

java.lang.Object

agentgui.core.database.DBConnection

public class DBConnection
extends java.lang.Object

This class is used within the execution mode as server.master for the background system of Agent.GUI.
In this mode the server.master agent will manage all server.slaves and server.clients in a database table.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
class	DBConnection.Error This inner class handles the Errors which can occur during the SQL-Interactions

Constructor Summary

Constructors

Constructor and Description
DBConnection() Constructor for the database connection.
DBConnection(java.lang.String dbHost, java.lang.String dbName, java.lang.String dbUser, java.lang.String dbPswd) Constructor for the database connection.

Method Summary

Modifier and Type	Method and Description
java.lang.Integer	dbBool2Integer(boolean booleanValue) This method converts an DB-boolean to an Java-Integer
boolean	dbInteger2Bool(java.lang.Integer intValue) This method converts an DB-Integer to a Java-boolean
com.mysql.jdbc.Connection	getConnection() Gets the connection instance to the database.
DBConnection.Error	getError() Returns the current DBConnection.Error instance that contains help functions for describing actual problems.
com.mysql.jdbc.Statement	getNewStatement() This method returns a new Statement-Object for a further handling of SQL-Interaction (e. g. for an executeUpdate)
int	getRowCount(java.sql.ResultSet rs) This method returns the number of rows from a ResultSet-Object
boolean	getSqlExecuteUpdate(java.lang.String sqlStatement) This Method executes a SQL-Statement (Create, Insert, Update) in the database and returns true if this was successful
java.sql.ResultSet	getSqlResult4ExecuteQuery(java.lang.String sqlStmt) Returns a ResultSet - Object for a SQL-Statement
java.sql.ResultSet	getSqlResult4ExecuteQuery(java.lang.String sqlStmt, boolean showErrorDialog) Returns a ResultSet - Object for a SQL-Statement.
boolean	hasErrors() Indicates that there are errors while interacting with the configured database.
boolean	isValidConnection() Checks if the connection is (still) valid.
void	setConnection(com.mysql.jdbc.Connection connection) Sets the connection instance to the database.

Methods inherited from class java.lang.Object

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

Constructor Detail

DBConnection

public DBConnection()

Constructor for the database connection. Using this constructor will directly try to connect to the configured database and will search for the table 'platforms'. If the database or the table can not be found or accessed, it will be tried to create the database and/or the table.

DBConnection

public DBConnection(java.lang.String dbHost,
                    java.lang.String dbName,
                    java.lang.String dbUser,
                    java.lang.String dbPswd)

Constructor for the database connection. Using this constructor will directly try to connect to the configured database, but not to a specific table (see other constructor of this class). If the database can not be found, it will be tried to create the database.

Parameters:

dbHost - the database host to use

dbName - the database name to use

dbUser - the database user to use

dbPswd - the database password to use

Method Detail

isValidConnection

public boolean isValidConnection()

Checks if the connection is (still) valid.

Returns:

true, if is valid connection

getSqlExecuteUpdate

public boolean getSqlExecuteUpdate(java.lang.String sqlStatement)

This Method executes a SQL-Statement (Create, Insert, Update) in the database and returns true if this was successful

Parameters:

sqlStatement - the SQL-Statement to execute

Returns:

True, if the execution was successful

getRowCount

public int getRowCount(java.sql.ResultSet rs)

This method returns the number of rows from a ResultSet-Object

Parameters:

rs -

Returns:

Number of rows from a result set, after SQL execution

getSqlResult4ExecuteQuery

public java.sql.ResultSet getSqlResult4ExecuteQuery(java.lang.String sqlStmt)

Returns a ResultSet - Object for a SQL-Statement

Parameters:

sqlStmt - the SQL statement

Returns:

com.mysql.jdbc.ResultSet

getSqlResult4ExecuteQuery

public java.sql.ResultSet getSqlResult4ExecuteQuery(java.lang.String sqlStmt,
                                                    boolean showErrorDialog)

Returns a ResultSet - Object for a SQL-Statement.

Parameters:

sqlStmt - the SQL statement

showErrorDialog - the show error dialog

Returns:

com.mysql.jdbc.ResultSet

getNewStatement

public com.mysql.jdbc.Statement getNewStatement()

This method returns a new Statement-Object for a further handling of SQL-Interaction (e. g. for an executeUpdate)

Returns:

com.mysql.jdbc.Statement

getConnection

public com.mysql.jdbc.Connection getConnection()

Gets the connection instance to the database.

Returns:

the connection

setConnection

public void setConnection(com.mysql.jdbc.Connection connection)

Sets the connection instance to the database.

Parameters:

connection - the connection to set

hasErrors

public boolean hasErrors()

Indicates that there are errors while interacting with the configured database.

Returns:

true, if there are errors

getError

public DBConnection.Error getError()

Returns the current DBConnection.Error instance that contains help functions for describing actual problems.

Returns:

the current database error, if an error occurs

dbInteger2Bool

public boolean dbInteger2Bool(java.lang.Integer intValue)

This method converts an DB-Integer to a Java-boolean

Parameters:

intValue -

Returns:

False, if the integer value is equal 0 - otherwise true

dbBool2Integer

public java.lang.Integer dbBool2Integer(boolean booleanValue)

This method converts an DB-boolean to an Java-Integer

Parameters:

booleanValue -

Returns:

0, if the boolean is true - otherwise -1