de.alpharogroup.jdbc

Class ConnectionsExtensions

java.lang.Object

de.alpharogroup.jdbc.ConnectionsExtensions

Deprecated.

use instead the same class in new project silly-jdbc

@Deprecated
public final class ConnectionsExtensions
extends Object

The class ConnectionsExtensions have convenience methods to create and connect to mysql, H2 or postgresql databases.

Author:

Asterios Raptis

Field Summary

Fields

Modifier and Type	Field and Description
static String	H2_DRIVERNAME Deprecated. Constant for the drivername from H2-database.
static String	H2_PREFIX_URL Deprecated. Constant for the urlprefix from H2-database.
static String	MYSQL_DRIVERNAME Deprecated. Constant for the drivername from MySQL-database.
static int	MYSQL_PORT Deprecated. Constant for the default port where the MySQL-database listen.
static String	MYSQL_PREFIX_URL Deprecated. Constant for the urlprefix from MySQL-database.
static String	POSTGRESQL_DRIVERNAME Deprecated. Constant for the drivername from PostgreSQL-database.
static int	POSTGRESQL_PORT Deprecated. Constant for the port where the PostgreSQL-database listen.
static String	POSTGRESQL_PREFIX_URL Deprecated. Constant for the urlprefix from PostgreSQL-database.

Constructor Summary

Constructors

Constructor and Description
ConnectionsExtensions() Deprecated.

Method Summary

Modifier and Type	Method and Description
static void	dropPostgreSQLDatabase(String hostname, String databaseName, String dbuser, String dbpasswort) Deprecated. Drops the given PostgreSQL database with the given databaseName if it does exist.
static void	executeSqlScript(BufferedReader bufferedReader, Connection connection) Deprecated. Execute the sql script in the given BufferedReader from a file.
static void	executeSqlScript(BufferedReader bufferedReader, Connection connection, boolean log) Deprecated. Execute the sql script in the given BufferedReader from a file.
static void	executeSqlScript(Connection connection, String sqlScript) Deprecated. Execute the sql script given as String object.
static void	executeSqlScript(Connection connection, String sqlScript, boolean log) Deprecated. Execute the sql script given as String object.
static boolean	existsMySqlDatabase(String hostname, String databaseName, String dbuser, String dbpasswort) Deprecated. Checks if the given database exists in the MySqlDatabase.
static boolean	existsPostgreSQLDatabase(String hostname, String databaseName, String dbuser, String dbpasswort) Deprecated. Checks if the given database exists in the Postgresql Database.
static Connection	getH2Connection(String path, String databaseName, String dbuser, String dbpasswort) Deprecated. Gets the H2 connection.
static Connection	getMySQLConnection(String hostname, int portNumber, String databaseName, String dbuser, String dbpasswort) Deprecated. Gets the my sql connection.
static Connection	getMySQLConnection(String hostname, String databaseName, String dbuser, String dbpasswort) Deprecated. Gets the my sql connection.
static Connection	getPostgreSQLConnection(String hostname, String databaseName, String dbuser, String dbpasswort) Deprecated. Gets the postgre sql connection.
static Connection	getPostgresSQLConnection(String hostname, int portNumber, String databaseName, String dbuser, String dbpasswort) Deprecated. Gets the postgres sql connection from the given parameters.
static void	newMySqlDatabase(String hostname, String databaseName, String dbuser, String dbpasswort) Deprecated. Creates a database with the given databaseName (and sets the characterset to utf8 and the collate to utf8_general_ci) if it does not exist.
static void	newMySqlDatabase(String hostname, String databaseName, String dbuser, String dbpasswort, String characterSet, String collate) Deprecated. Creates the a mySql database with the given databaseName if it does not exist.
static void	newPostgreSQLDatabase(String hostname, String databaseName, String dbuser, String dbpasswort, String characterSet, String collate) Deprecated. Creates the a PostgreSQL database with the given databaseName if it does not exist.

Methods inherited from class java.lang.Object

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

Field Detail

H2_DRIVERNAME

public static final String H2_DRIVERNAME

Deprecated.

Constant for the drivername from H2-database.

See Also:

Constant Field Values

H2_PREFIX_URL

public static final String H2_PREFIX_URL

Deprecated.

Constant for the urlprefix from H2-database.

See Also:

Constant Field Values

MYSQL_DRIVERNAME

public static final String MYSQL_DRIVERNAME

Deprecated.

Constant for the drivername from MySQL-database.

See Also:

Constant Field Values

MYSQL_PREFIX_URL

public static final String MYSQL_PREFIX_URL

Deprecated.

Constant for the urlprefix from MySQL-database.

See Also:

Constant Field Values

MYSQL_PORT

public static final int MYSQL_PORT

Deprecated.

Constant for the default port where the MySQL-database listen.

See Also:

Constant Field Values

POSTGRESQL_DRIVERNAME

public static final String POSTGRESQL_DRIVERNAME

Deprecated.

Constant for the drivername from PostgreSQL-database.

See Also:

Constant Field Values

POSTGRESQL_PREFIX_URL

public static final String POSTGRESQL_PREFIX_URL

Deprecated.

Constant for the urlprefix from PostgreSQL-database.

See Also:

Constant Field Values

POSTGRESQL_PORT

public static final int POSTGRESQL_PORT

Deprecated.

Constant for the port where the PostgreSQL-database listen.

See Also:

Constant Field Values

Constructor Detail

ConnectionsExtensions

public ConnectionsExtensions()

Deprecated.

Method Detail

dropPostgreSQLDatabase

public static void dropPostgreSQLDatabase(String hostname,
                                          String databaseName,
                                          String dbuser,
                                          String dbpasswort)
                                   throws SQLException,
                                          ClassNotFoundException

Deprecated.

Drops the given PostgreSQL database with the given databaseName if it does exist.

Parameters:

hostname - the hostname

databaseName - the database name

dbuser - the dbuser

dbpasswort - the dbpasswort

Throws:

SQLException - is thrown if a database access error occurs or this method is called on a closed connection

ClassNotFoundException - is thrown if the Class was not found or could not be located

executeSqlScript

public static void executeSqlScript(BufferedReader bufferedReader,
                                    Connection connection)
                             throws IOException,
                                    SQLException

Deprecated.

Execute the sql script in the given BufferedReader from a file.

Parameters:

bufferedReader - a BufferedReader from a script file.

connection - the connection

Throws:

IOException - Signals that an I/O exception has occurred.

SQLException - is thrown if a database access error occurs or this method is called on a closed connection

executeSqlScript

public static void executeSqlScript(BufferedReader bufferedReader,
                                    Connection connection,
                                    boolean log)
                             throws IOException,
                                    SQLException

Deprecated.

Execute the sql script in the given BufferedReader from a file.

Parameters:

bufferedReader - a BufferedReader from a script file.

connection - the connection

log - the flag if it will be logged.

Throws:

IOException - Signals that an I/O exception has occurred.

SQLException - is thrown if a database access error occurs or this method is called on a closed connection

executeSqlScript

public static void executeSqlScript(Connection connection,
                                    String sqlScript)
                             throws SQLException

Deprecated.

Execute the sql script given as String object.

Parameters:

sqlScript - The sql script as String object.

connection - the connection

Throws:

SQLException - is thrown if a database access error occurs or this method is called on a closed connection

executeSqlScript

public static void executeSqlScript(Connection connection,
                                    String sqlScript,
                                    boolean log)
                             throws SQLException

Deprecated.

Execute the sql script given as String object.

Parameters:

sqlScript - The sql script as String object.

connection - the connection

log - the flag if it will be logged.

Throws:

SQLException - is thrown if a database access error occurs or this method is called on a closed connection

existsMySqlDatabase

public static boolean existsMySqlDatabase(String hostname,
                                          String databaseName,
                                          String dbuser,
                                          String dbpasswort)
                                   throws SQLException,
                                          ClassNotFoundException

Deprecated.

Checks if the given database exists in the MySqlDatabase.

Parameters:

hostname - the hostname

databaseName - the database name

dbuser - the dbuser

dbpasswort - the dbpasswort

Returns:

true, if successful

Throws:

SQLException - is thrown if a database access error occurs or this method is called on a closed connection

ClassNotFoundException - is thrown if the Class was not found or could not be located.

existsPostgreSQLDatabase

public static boolean existsPostgreSQLDatabase(String hostname,
                                               String databaseName,
                                               String dbuser,
                                               String dbpasswort)
                                        throws ClassNotFoundException,
                                               SQLException

Deprecated.

Checks if the given database exists in the Postgresql Database.

Parameters:

hostname - the hostname

databaseName - the database name

dbuser - the dbuser

dbpasswort - the dbpasswort

Returns:

true, if successful

Throws:

ClassNotFoundException - is thrown if the Class was not found or could not be located.

SQLException - is thrown if a database access error occurs or this method is called on a closed connection

getH2Connection

public static Connection getH2Connection(String path,
                                         String databaseName,
                                         String dbuser,
                                         String dbpasswort)
                                  throws ClassNotFoundException,
                                         SQLException

Deprecated.

Gets the H2 connection.

Parameters:

path - the path

databaseName - the database name

dbuser - the dbuser

dbpasswort - the dbpasswort

Returns:

the H2 connection

Throws:

ClassNotFoundException - is thrown if the Class was not found or could not be located.

SQLException - is thrown if a database access error occurs or this method is called on a closed connection

getMySQLConnection

public static Connection getMySQLConnection(String hostname,
                                            int portNumber,
                                            String databaseName,
                                            String dbuser,
                                            String dbpasswort)
                                     throws ClassNotFoundException,
                                            SQLException

Deprecated.

Gets the my sql connection.

Parameters:

hostname - the hostname

portNumber - the port number

databaseName - the database name

dbuser - the dbuser

dbpasswort - the dbpasswort

Returns:

the my sql connection

Throws:

ClassNotFoundException - is thrown if the Class was not found or could not be located.

SQLException - is thrown if a database access error occurs or this method is called on a closed connection

getMySQLConnection

public static Connection getMySQLConnection(String hostname,
                                            String databaseName,
                                            String dbuser,
                                            String dbpasswort)
                                     throws ClassNotFoundException,
                                            SQLException

Deprecated.

Gets the my sql connection.

Parameters:

hostname - the hostname

databaseName - the database name

dbuser - the dbuser

dbpasswort - the dbpasswort

Returns:

the my sql connection

Throws:

ClassNotFoundException - is thrown if the Class was not found or could not be located.

SQLException - is thrown if a database access error occurs or this method is called on a closed connection

getPostgreSQLConnection

public static Connection getPostgreSQLConnection(String hostname,
                                                 String databaseName,
                                                 String dbuser,
                                                 String dbpasswort)
                                          throws ClassNotFoundException,
                                                 SQLException

Deprecated.

Gets the postgre sql connection.

Parameters:

hostname - the hostname

databaseName - the database name

dbuser - the dbuser

dbpasswort - the dbpasswort

Returns:

the postgre sql connection

Throws:

ClassNotFoundException - is thrown if the Class was not found or could not be located.

SQLException - is thrown if a database access error occurs or this method is called on a closed connection

getPostgresSQLConnection

public static Connection getPostgresSQLConnection(String hostname,
                                                  int portNumber,
                                                  String databaseName,
                                                  String dbuser,
                                                  String dbpasswort)
                                           throws ClassNotFoundException,
                                                  SQLException

Deprecated.

Gets the postgres sql connection from the given parameters.

Parameters:

hostname - the hostname

portNumber - the port number

databaseName - the database name

dbuser - the dbuser

dbpasswort - the dbpasswort

Returns:

the postgres sql connection

Throws:

ClassNotFoundException - is thrown if the Class was not found or could not be located.

SQLException - is thrown if a database access error occurs or this method is called on a closed connection

newMySqlDatabase

public static void newMySqlDatabase(String hostname,
                                    String databaseName,
                                    String dbuser,
                                    String dbpasswort)
                             throws SQLException,
                                    ClassNotFoundException

Deprecated.

Creates a database with the given databaseName (and sets the characterset to utf8 and the collate to utf8_general_ci) if it does not exist.

Parameters:

hostname - the hostname

databaseName - the database name

dbuser - the dbuser

dbpasswort - the dbpasswort

Throws:

SQLException - is thrown if a database access error occurs or this method is called on a closed connection

ClassNotFoundException - is thrown if the Class was not found or could not be located.

newMySqlDatabase

public static void newMySqlDatabase(String hostname,
                                    String databaseName,
                                    String dbuser,
                                    String dbpasswort,
                                    String characterSet,
                                    String collate)
                             throws SQLException,
                                    ClassNotFoundException

Deprecated.

Creates the a mySql database with the given databaseName if it does not exist.

Parameters:

hostname - the hostname

databaseName - the database name

dbuser - the dbuser

dbpasswort - the dbpasswort

characterSet - the character set

collate - the collate

Throws:

SQLException - is thrown if a database access error occurs or this method is called on a closed connection

ClassNotFoundException - is thrown if the Class was not found or could not be located.

newPostgreSQLDatabase

public static void newPostgreSQLDatabase(String hostname,
                                         String databaseName,
                                         String dbuser,
                                         String dbpasswort,
                                         String characterSet,
                                         String collate)
                                  throws SQLException,
                                         ClassNotFoundException

Deprecated.

Creates the a PostgreSQL database with the given databaseName if it does not exist.

Parameters:

hostname - the hostname

databaseName - the database name

dbuser - the dbuser

dbpasswort - the dbpasswort

characterSet - the character set

collate - the collate

Throws:

SQLException - is thrown if a database access error occurs or this method is called on a closed connection

ClassNotFoundException - is thrown if the Class was not found or could not be located.