public class DBUtility
extends java.lang.Object
Constructor and Description |
---|
DBUtility() |
Modifier and Type | Method and Description |
---|---|
static void |
AddUTF8PropToDBConnectionProperties(java.util.Properties props,
java.lang.String URL) |
static java.lang.String |
computeNextIdentifier(java.lang.String currentIdentifier)
Construct the next identifier to use after the given identifier.
|
static java.sql.Connection |
connectToDatabase(java.lang.String server,
java.lang.String driver,
java.lang.String user,
java.lang.String password) |
static void |
createDatabase(java.lang.String DBUrl,
java.lang.String driver,
java.lang.String dbName,
java.lang.String username,
java.lang.String password,
boolean useLexGridCharSet) |
static boolean |
doesDBExist(java.lang.String server,
java.lang.String driver,
java.lang.String dbName,
java.lang.String parameters,
java.lang.String username,
java.lang.String password) |
static void |
dropDatabase(java.lang.String DBUrl,
java.lang.String driver,
java.lang.String dbName,
java.lang.String username,
java.lang.String password) |
static java.lang.String |
escapeLdapCode(java.lang.String string) |
static java.lang.String |
escapeLdapDN(java.lang.String string) |
static java.lang.String |
escapeLdapDN(java.lang.String string,
boolean escapeCommas) |
static boolean |
getbooleanFromResultSet(java.sql.ResultSet results,
java.lang.String column) |
static java.lang.Boolean |
getBooleanFromResultSet(java.sql.ResultSet results,
java.lang.String columnName) |
static void |
setBooleanOnPreparedStatment(java.sql.PreparedStatement statement,
int colNumber,
java.lang.Boolean value)
simplified call to setBooleanOnPreparedStatement.
|
static void |
setBooleanOnPreparedStatment(java.sql.PreparedStatement statement,
int colNumber,
java.lang.Boolean value,
boolean isSqlLite)
simplified call to setBooleanOnPreparedStatement.
|
static void |
setBooleanOnPreparedStatment(java.sql.PreparedStatement statement,
int colNumber,
java.lang.Boolean value,
boolean isSqlLite,
java.lang.String databaseType)
Sets booleans properly in the LexGrid world.
|
static void |
setBooleanOnPreparedStatment(java.sql.PreparedStatement statement,
int colNumber,
java.lang.Boolean value,
java.lang.String databaseType)
simplified call to setBooleanOnPreparedStatement.
|
static boolean |
validLocalName(java.lang.String name)
Checks the validity of the Local Name
|
public static java.sql.Connection connectToDatabase(java.lang.String server, java.lang.String driver, java.lang.String user, java.lang.String password) throws java.lang.Exception
java.lang.Exception
public static boolean validLocalName(java.lang.String name)
name
- Local Name to checkpublic static java.lang.String escapeLdapDN(java.lang.String string, boolean escapeCommas)
public static java.lang.String escapeLdapDN(java.lang.String string)
public static java.lang.String escapeLdapCode(java.lang.String string)
public static void setBooleanOnPreparedStatment(java.sql.PreparedStatement statement, int colNumber, java.lang.Boolean value) throws java.sql.SQLException
statement
- colNumber
- value
- java.sql.SQLException
public static void setBooleanOnPreparedStatment(java.sql.PreparedStatement statement, int colNumber, java.lang.Boolean value, boolean isSqlLite) throws java.sql.SQLException
statement
- colNumber
- value
- java.sql.SQLException
public static void setBooleanOnPreparedStatment(java.sql.PreparedStatement statement, int colNumber, java.lang.Boolean value, java.lang.String databaseType) throws java.sql.SQLException
statement
- colNumber
- value
- java.sql.SQLException
public static void setBooleanOnPreparedStatment(java.sql.PreparedStatement statement, int colNumber, java.lang.Boolean value, boolean isSqlLite, java.lang.String databaseType) throws java.sql.SQLException
statement
- colNumber
- value
- isSqlLite
- - using sqlLite tables? Set to true if the answer is yes.databaseType
- - optional. Set to null or "" if you don't know it.java.sql.SQLException
public static java.lang.Boolean getBooleanFromResultSet(java.sql.ResultSet results, java.lang.String columnName) throws java.sql.SQLException
java.sql.SQLException
public static boolean getbooleanFromResultSet(java.sql.ResultSet results, java.lang.String column) throws java.sql.SQLException
java.sql.SQLException
public static void AddUTF8PropToDBConnectionProperties(java.util.Properties props, java.lang.String URL)
public static void createDatabase(java.lang.String DBUrl, java.lang.String driver, java.lang.String dbName, java.lang.String username, java.lang.String password, boolean useLexGridCharSet) throws java.lang.Exception
java.lang.Exception
public static boolean doesDBExist(java.lang.String server, java.lang.String driver, java.lang.String dbName, java.lang.String parameters, java.lang.String username, java.lang.String password)
public static void dropDatabase(java.lang.String DBUrl, java.lang.String driver, java.lang.String dbName, java.lang.String username, java.lang.String password) throws java.lang.Exception
java.lang.Exception
public static java.lang.String computeNextIdentifier(java.lang.String currentIdentifier) throws java.lang.Exception
currentIdentifier
- java.lang.Exception
- if it doesn't understand the identifier.