Package ch.pschatzmann.edgar.reporting

Class DBMS

java.lang.Object

ch.pschatzmann.edgar.reporting.DBMS

public class DBMS
extends java.lang.Object

Access to database. Implemented as singleton

Author:

pschatzmann

Method Summary

Modifier and Type	Method	Description
void	execute(java.lang.String sql, Table tab)	Executes the SQL command against the database and adds all found records
java.util.List<java.lang.String>	getFieldValues(java.lang.String tableName, java.lang.String fieldName, java.lang.String like)
static DBMS	getInstance()	Creates an singleton instance

Methods inherited from class java.lang.Object

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

Method Detail

getInstance

public static DBMS getInstance()

Creates an singleton instance

Returns:

execute

public void execute(java.lang.String sql,
                    Table tab)
             throws java.sql.SQLException,
                    java.lang.ClassNotFoundException

Executes the SQL command against the database and adds all found records

Parameters:

sql -

tab -

Throws:

java.sql.SQLException

java.lang.ClassNotFoundException

getFieldValues

public java.util.List<java.lang.String> getFieldValues(java.lang.String tableName,
                                                       java.lang.String fieldName,
                                                       java.lang.String like)
                                                throws java.sql.SQLException,
                                                       java.lang.ClassNotFoundException

Throws:

java.sql.SQLException

java.lang.ClassNotFoundException