public class DBUtil
extends java.lang.Object
| Modifier and Type | Class and Description |
|---|---|
static class |
DBUtil.ConnectionData |
| Modifier and Type | Field and Description |
|---|---|
static java.lang.String |
HSQLDB_BACKEND_NAME |
static java.lang.String |
MYSQL_BACKEND_NAME |
static java.lang.String |
ORACLE_BACKEND_NAME |
| Constructor and Description |
|---|
DBUtil() |
| Modifier and Type | Method and Description |
|---|---|
static DBUtil.ConnectionData |
connectDB(java.util.logging.Logger logger) |
static java.sql.Connection |
connectGeneric(java.lang.String backend,
java.lang.String clazz,
java.lang.String dbUser,
java.lang.String dbPassword,
java.lang.String dbUrl,
java.util.logging.Logger logger) |
static java.sql.Connection |
connectHsqldb(java.lang.String dbUser,
java.lang.String dbPassword,
java.lang.String dbUrl,
java.util.logging.Logger logger) |
static java.sql.Connection |
connectMysql(java.lang.String dbUser,
java.lang.String dbPassword,
java.lang.String dbUrl,
java.util.logging.Logger logger) |
static java.sql.Connection |
connectOracle(java.lang.String dbUser,
java.lang.String dbPassword,
java.lang.String dbUrl,
java.util.logging.Logger logger) |
static void |
loadAndExecuteScript(java.sql.Connection connection,
java.lang.String filename) |
public static final java.lang.String HSQLDB_BACKEND_NAME
public static final java.lang.String ORACLE_BACKEND_NAME
public static final java.lang.String MYSQL_BACKEND_NAME
public static DBUtil.ConnectionData connectDB(java.util.logging.Logger logger) throws java.sql.SQLException, java.lang.ClassNotFoundException
java.sql.SQLExceptionjava.lang.ClassNotFoundExceptionpublic static java.sql.Connection connectGeneric(java.lang.String backend,
java.lang.String clazz,
java.lang.String dbUser,
java.lang.String dbPassword,
java.lang.String dbUrl,
java.util.logging.Logger logger)
throws java.sql.SQLException,
java.lang.ClassNotFoundException
java.sql.SQLExceptionjava.lang.ClassNotFoundExceptionpublic static java.sql.Connection connectOracle(java.lang.String dbUser,
java.lang.String dbPassword,
java.lang.String dbUrl,
java.util.logging.Logger logger)
throws java.sql.SQLException,
java.lang.ClassNotFoundException
java.sql.SQLExceptionjava.lang.ClassNotFoundExceptionpublic static java.sql.Connection connectHsqldb(java.lang.String dbUser,
java.lang.String dbPassword,
java.lang.String dbUrl,
java.util.logging.Logger logger)
throws java.sql.SQLException,
java.lang.ClassNotFoundException
java.sql.SQLExceptionjava.lang.ClassNotFoundExceptionpublic static java.sql.Connection connectMysql(java.lang.String dbUser,
java.lang.String dbPassword,
java.lang.String dbUrl,
java.util.logging.Logger logger)
throws java.sql.SQLException,
java.lang.ClassNotFoundException
java.sql.SQLExceptionjava.lang.ClassNotFoundExceptionpublic static void loadAndExecuteScript(java.sql.Connection connection,
java.lang.String filename)
throws java.lang.Exception
java.lang.Exception