public class DBConnection
extends java.lang.Object
Constructor and Description |
---|
DBConnection() |
Modifier and Type | Method and Description |
---|---|
static boolean |
closeConnection(java.sql.Connection conn) |
static java.sql.Connection |
closeConnectionHelper(java.sql.Connection conn)
Closes the open database connection that is passed into the method.
|
static int |
executeInsert(java.lang.String query)
Inserts and edits entries in the database based on a query that is passed into the method.
|
static java.sql.ResultSet |
executeQuery(java.sql.Connection conn,
java.lang.String query)
Executes the query specified on the activate database connection and returns the data retrieved from the database.
|
static java.sql.Connection |
getConnection() |
static java.sql.Connection |
openConnection()
Opens a connection to the database server.
|
static boolean |
openTunnel()
Opens a tunnel into the server on which the database is located.
|
public static boolean openTunnel()
public static java.sql.Connection openConnection()
public static java.sql.ResultSet executeQuery(java.sql.Connection conn, java.lang.String query)
public static int executeInsert(java.lang.String query)
query
- public static java.sql.Connection closeConnectionHelper(java.sql.Connection conn)
conn
- public static java.sql.Connection getConnection()
public static boolean closeConnection(java.sql.Connection conn)