jimm.datavision.source.ncsql
Class NCQuery

java.lang.Object
  jimm.datavision.source.Query
      jimm.datavision.source.sql.SQLQuery
          jimm.datavision.source.ncsql.NCQuery

All Implemented Interfaces:

Writeable

public class NCQuery
extends SQLQuery

Queries build NC query strings. They contain tables, joins, and where clauses.

Author:

Jim Menard, jimm@io.com

Field Summary

Fields inherited from class jimm.datavision.source.sql.SQLQuery

preparedStmtValues, tables

Fields inherited from class jimm.datavision.source.Query

joins, report, selectables, SORT_ASCENDING, SORT_DESCENDING, SORT_UNDEFINED, sortOrders, sortSelectables, whereClause

Constructor Summary

NCQuery(Report report)
Constructor.

Method Summary

java.lang.String

quoted(java.lang.String name) Quotes those parts of a table or column name that need to be quoted.

Methods inherited from class jimm.datavision.source.sql.SQLQuery

addParameter, addParameterForDisplay, addTable, buildFrom, buildJoins, buildOrderBy, buildSelect, buildUserWhereClause, buildWhereClause, findSelectablesUsed, getNumTables, getTablesUsed, getWhereClauseForDisplay, getWhereClauseForPreparedStatement, prepare, queryAsString, setParameters, toPreparedStatementString, toString

Methods inherited from class jimm.datavision.source.Query

addAllJoins, addJoin, addSort, clearJoins, clearSorts, containsReferenceTo, getEditableWhereClause, getNumSelectables, getWhereClause, indexOfSelectable, joins, reloadColumns, removeJoin, removeSort, selectables, setEditableWhereClause, setWhereClause, sortedSelectables, sortOrderOf, writeExtras, writeXML

Methods inherited from class java.lang.Object

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

Constructor Detail

NCQuery

public NCQuery(Report report)

Constructor.

Parameters:

report - the report for which this query will generate NC

Method Detail

quoted

public java.lang.String quoted(java.lang.String name)

Quotes those parts of a table or column name that need to be quoted.

Different databases and JDBC drivers treat case sensitively differently. We assume the database is case-sensitive.

Overrides:

quoted in class SQLQuery

Parameters:

name - a table or column name

Returns:

a quoted version of the name