org.pajes.db
Class DBUtility

java.lang.Object
  org.pajes.db.DBUtility

public class DBUtility
extends java.lang.Object

Convenience utilty methods.

Method Summary

static void

setInputFields(Container container, java.sql.ResultSet rs) Convenience method to assign result set values to Input fields where the name attribute of the Input field matches the column name in the result set.

Methods inherited from class java.lang.Object

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

Method Detail

setInputFields

public static void setInputFields(Container container,
                                  java.sql.ResultSet rs)
                           throws java.sql.SQLException

Convenience method to assign result set values to Input fields where the name attribute of the Input field matches the column name in the result set. Values will only be assigned if the names and number of fields and values match exactly.

Parameters:

container - the Container sub-class which contains the Input fields. It is most effecient to pass in the lowest level container possible (i.e. the Form instance) rather than the Paje instance.

rs - the ResultSet containing the values.

Throws:

java.sql.SQLException - if an error occurs whilst accessing the database.