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

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 void	loadDatabaseDriver(java.lang.String connectionUrl) Deprecated.
static java.lang.String	loadDatabaseDriver(java.lang.String connectionUrl, java.lang.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

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

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.jdbc.Driver"

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