org.javaWebGen.data
Class ReportDAO

java.lang.Object
  org.javaWebGen.data.DAO
      org.javaWebGen.data.ReportDAO

public class ReportDAO
extends DAO

WARNING this class can be Dangerous. It runs any SQL statements that are passed in Be careful and think about security before using this class If you allow users to enter dynamic SQL. This class should be allowed on a production server that can be accessed from the Internet.

Field Summary

Fields inherited from class org.javaWebGen.data.DAO

TOO_MANY_ROWS, TOO_MANY_ROWS_WARNING

Constructor Summary

ReportDAO()

Method Summary

DbResult	runSQL(java.lang.String sql) returns an DBResult based on a database query
int	updateSQL(java.lang.String sql) RUNS A sql update statement

Methods inherited from class org.javaWebGen.data.DAO

close, getColumnClass, getConnection, getDataManager, getNextValue, getNextValue, getResultSet, query, query, query, query, runQuery, runQuery, runQuery, runQuery, setColumn, update, update, update, update, updateDataBean, updateDataBean

Methods inherited from class java.lang.Object

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

Constructor Detail

ReportDAO

public ReportDAO()

Method Detail

runSQL

public DbResult runSQL(java.lang.String sql)
                throws java.sql.SQLException

returns an DBResult based on a database query

Parameters:

sql - command

Returns:

results of query including metadata

Throws:

java.sql.SQLException

updateSQL

public int updateSQL(java.lang.String sql)
              throws java.sql.SQLException

RUNS A sql update statement

Parameters:

sql - command

Returns:

results of query including metadata

Throws:

java.sql.SQLException