org.openmrs.util

Class DatabaseUtil

java.lang.Object

org.openmrs.util.DatabaseUtil

public class DatabaseUtil
extends Object

Utility class that provides database related methods

Since:

1.6

Field Summary

Fields

Modifier and Type	Field and Description
static String	ORDER_ENTRY_UPGRADE_SETTINGS_FILENAME

Method Summary

Modifier and Type	Method and Description
static List<List<Object>>	executeSQL(Connection conn, String sql, boolean selectOnly) Executes the passed SQL query, enforcing select only if that parameter is set for given Connection
static List<List<Object>>	executeSQL(org.hibernate.Session session, String sql, boolean selectOnly) Executes the passed SQL query, enforcing select only if that parameter is set for given Session
static <T> Set<T>	getUniqueNonNullColumnValues(String columnName, String tableName, Class<T> type, Connection connection) Gets all unique values excluding nulls in the specified column and table
static String	loadDatabaseDriver(String connectionUrl, String connectionDriver) 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.

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 String ORDER_ENTRY_UPGRADE_SETTINGS_FILENAME

See Also:

Constant Field Values

Method Detail

loadDatabaseDriver

public static String loadDatabaseDriver(String connectionUrl,
                                        String connectionDriver)
                                 throws ClassNotFoundException

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.

Parameters:

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

connectionDriver - the database driver class name, such as "com.mysql.cj.jdbc.Driver"

Throws:

ClassNotFoundException

executeSQL

public static List<List<Object>> executeSQL(org.hibernate.Session session,
                                            String sql,
                                            boolean selectOnly)
                                     throws DAOException

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

Throws:

DAOException

executeSQL

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

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

Throws:

DAOException

getUniqueNonNullColumnValues

public static <T> Set<T> getUniqueNonNullColumnValues(String columnName,
                                                      String tableName,
                                                      Class<T> type,
                                                      Connection connection)
                                               throws Exception

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

Parameters:

columnName - the column

tableName - the table

connection -

Returns:

set of unique values

Throws:

Exception