public class CreateTCDatabase extends Object
Modifier and Type | Field and Description |
---|---|
private String |
CHECK_DB_EXISTS_STMT
MySQL statement for checking if DB exists
|
private String |
CREATE_DATABASE_STMT
MySQL statement for checking for creating database
|
private String |
DROP_DATABASE_STMT
MySQL statement for checking for dropping database
|
protected Connection |
mConnection
Maintains the connection to the database over the lifetime of
this instance.
|
private String |
mDatabaseAbsolutePath
Stores the absolute path to the mysql home directory
|
private String |
mDatabaseHost
Stores the database host name
|
private String |
mDatabaseName
Stores the database name
|
private String |
mDriver
Stores the driver string
|
private LogManager |
mLogger
The default logger.
|
private String |
mPassword
Stores the MySQL password
|
private String |
mUrl
Stores the database url
|
private String |
mUsername
Stores the user name
|
Constructor and Description |
---|
CreateTCDatabase(String driver,
String url,
String username,
String password,
String host)
Creates a JDBCTC instance .
|
Modifier and Type | Method and Description |
---|---|
boolean |
checkIfDatabaseExists(String databaseName)
Checks if the given database exists
|
boolean |
createDatabase(String databaseName)
Creates data base
|
boolean |
deleteDatabase(String databaseName)
Deletes the database
|
String |
getDatabaseName(String dbURL)
Returns the database name from the database url string
|
boolean |
initializeDatabase(String databaseName,
String fileName)
Initialize the database with given .sql file
|
private LogManager mLogger
protected Connection mConnection
private String CHECK_DB_EXISTS_STMT
private String DROP_DATABASE_STMT
private String CREATE_DATABASE_STMT
private String mDriver
private String mUrl
private String mUsername
private String mPassword
private String mDatabaseName
private String mDatabaseHost
private String mDatabaseAbsolutePath
public CreateTCDatabase(String driver, String url, String username, String password, String host) throws ClassNotFoundException, SQLException
driver
- the Database driverurl
- the Database urlusername
- the Database user namepassword
- the Database user passwordClassNotFoundException
- if it fails to load the driverSQLException
public String getDatabaseName(String dbURL)
dbURL
- the database url stringpublic boolean checkIfDatabaseExists(String databaseName) throws SQLException
databaseName
- the database nameSQLException
public boolean deleteDatabase(String databaseName) throws SQLException
databaseName
- the databaseSQLException
public boolean createDatabase(String databaseName) throws SQLException
databaseName
- the database nameSQLException
Copyright © 2011 The University of Southern California. All Rights Reserved.