org.openmrs.util

Class DatabaseUtil

java.lang.Object

org.openmrs.util.DatabaseUtil

public class DatabaseUtil
extends java.lang.Object

Utility class that provides database related methods

Since:

1.6

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	ORDER_ENTRY_UPGRADE_SETTINGS_FILENAME Executes the passed SQL query, enforcing select only if that parameter is set Load the jdbc driver class for the database which is specified by the connectionUrl and connectionDriver parameters This is only needed when loading up a jdbc connection manually for the first time.

Constructor Summary

Constructors

Constructor and Description
DatabaseUtil()

Method Summary

Modifier and Type	Method and Description
static java.util.List<java.util.List<java.lang.Object>>	executeSQL(java.sql.Connection conn, java.lang.String sql, boolean selectOnly) Executes the passed SQL query, enforcing select only if that parameter is set
static <T> java.util.Set<T>	getUniqueNonNullColumnValues(java.lang.String columnName, java.lang.String tableName, java.lang.Class<T> type, java.sql.Connection connection) Gets all unique values excluding nulls in the specified column and table
static void	loadDatabaseDriver(java.lang.String connectionUrl) Deprecated.
static java.lang.String	loadDatabaseDriver(java.lang.String connectionUrl, java.lang.String connectionDriver)

Methods inherited from class java.lang.Object

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

Field Detail

ORDER_ENTRY_UPGRADE_SETTINGS_FILENAME

public static final java.lang.String ORDER_ENTRY_UPGRADE_SETTINGS_FILENAME

Executes the passed SQL query, enforcing select only if that parameter is set Load the jdbc driver class for the database which is specified by the connectionUrl and connectionDriver parameters

This is only needed when loading up a jdbc connection manually for the first time. This is not needed by most users and development practices with the openmrs API.

See Also:

Constant Field Values

Constructor Detail

DatabaseUtil

public DatabaseUtil()

Method Detail

loadDatabaseDriver

@Deprecated
public static void loadDatabaseDriver(java.lang.String connectionUrl)
                                           throws java.lang.ClassNotFoundException

Deprecated.

Load the jdbc driver class for the database which is specified by the connectionUrl parameter
This is only needed when loading up a jdbc connection manually for the first time. This is not needed by most users and development practices with the openmrs API.

Parameters:

connectionUrl - the connection url for the database, such as "jdbc:mysql://localhost:3306/..."

Throws:

java.lang.ClassNotFoundException

loadDatabaseDriver

public static java.lang.String loadDatabaseDriver(java.lang.String connectionUrl,
                                                  java.lang.String connectionDriver)
                                           throws java.lang.ClassNotFoundException

Throws:

java.lang.ClassNotFoundException

executeSQL

public static java.util.List<java.util.List<java.lang.Object>> executeSQL(java.sql.Connection conn,
                                                                          java.lang.String sql,
                                                                          boolean selectOnly)
                                                                   throws DAOException

Executes the passed SQL query, enforcing select only if that parameter is set

Throws:

DAOException

getUniqueNonNullColumnValues

public static <T> java.util.Set<T> getUniqueNonNullColumnValues(java.lang.String columnName,
                                                                java.lang.String tableName,
                                                                java.lang.Class<T> type,
                                                                java.sql.Connection connection)
                                                         throws java.lang.Exception

Gets all unique values excluding nulls in the specified column and table

Parameters:

columnName - the column

tableName - the table

connection -

Returns:

Throws:

java.lang.Exception