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

Constructor Summary

Constructors

Constructor and Description
DatabaseUtil()

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
static void	loadDatabaseDriver(String connectionUrl) Load the jdbc driver clas 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.

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

public static void loadDatabaseDriver(String connectionUrl)
                               throws ClassNotFoundException

Load the jdbc driver clas 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:

ClassNotFoundException

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

Throws:

DAOException