Overview  Package   Class  Use  Deprecated  Index
Home >> All >> com >> dghda >> kent >> [ reports overview ]	PREV CLASS  NEXT CLASS
SUMMARY:  JAVADOC |  SOURCE |  DOWNLOAD | NESTED | FIELD | CONSTR | METHOD	DETAIL: FIELD | CONSTR | METHOD

---

com.dghda.kent.reports
Class SQLQueryMapping  

java.lang.Object
  com.dghda.kent.reports.SQLQueryMapping

---

public class SQLQueryMapping

extends java.lang.Object

A class which maps SQL query results to a data set.

---

Field Summary
private  java.util.TreeMap	m_Mappings
private  java.lang.String	m_Name
private  java.sql.PreparedStatement	m_Query

 

Constructor Summary

SQLQueryMapping(java.lang.String name, java.sql.PreparedStatement stmt)           Create a new mapping using the given SQL statement.

 

Method Summary
void	addMapping(java.lang.String sqlColumn, java.lang.String dataColumn)           Adds the given mapping from the query result to report data.
com.dghda.kent.ReportData.DataSet	execute()           Executes the query, and constructs a data set from the results.
java.sql.PreparedStatement	getSQLQuery()           Gets the SQL query that will be used to query the DB.

 

Methods inherited from class java.lang.Object

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

 

Field Detail

m_Name

private java.lang.String m_Name

---

m_Query

private java.sql.PreparedStatement m_Query

---

m_Mappings

private java.util.TreeMap m_Mappings

Constructor Detail

SQLQueryMapping

public SQLQueryMapping(java.lang.String name,
                       java.sql.PreparedStatement stmt)

Create a new mapping using the given SQL statement.

Method Detail

addMapping

public void addMapping(java.lang.String sqlColumn,
                       java.lang.String dataColumn)

Adds the given mapping from the query result to report data.

---

getSQLQuery

public java.sql.PreparedStatement getSQLQuery()

Gets the SQL query that will be used to query the DB.

---

execute

public com.dghda.kent.ReportData.DataSet execute()
                                          throws java.sql.SQLException

Executes the query, and constructs a data set from the results.

---

Overview  Package   Class  Use  Deprecated  Index
Home >> All >> com >> dghda >> kent >> [ reports overview ]	PREV CLASS  NEXT CLASS
SUMMARY:  JAVADOC |  SOURCE |  DOWNLOAD | NESTED | FIELD | CONSTR | METHOD	DETAIL: FIELD | CONSTR | METHOD

---