|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.openswing.swing.server.QueryUtil
Title: OpenSwing Framework
Description: Utility (singleton) class used with queries.
Copyright: Copyright (C) 2006 Mauro Carniel
This file is part of OpenSwing Framework. This library is free software; you can redistribute it and/or modify it under the terms of the (LGPL) Lesser General Public License as published by the Free Software Foundation; GNU LESSER GENERAL PUBLIC LICENSE Version 2.1, February 1999 This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Library General Public License for more details. You should have received a copy of the GNU Library General Public License along with this library; if not, write to the Free Software Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. The author may be contacted at: maurocarniel@tin.it
Constructor Summary | |
QueryUtil()
|
Method Summary | |
static Response |
getQuery(java.sql.Connection conn,
java.lang.String baseSQL,
java.util.ArrayList values,
java.util.Map attribute2dbField,
java.lang.Class valueObjectClass,
java.lang.String booleanTrueValue,
java.lang.String booleanFalseValue,
boolean logQuery)
|
static Response |
getQuery(java.sql.Connection conn,
java.lang.String baseSQL,
java.util.ArrayList values,
java.util.Map attribute2dbField,
java.lang.Class valueObjectClass,
java.lang.String booleanTrueValue,
java.lang.String booleanFalseValue,
GridParams gridParams,
boolean logQuery)
This method read the WHOLE result set. |
static Response |
getQuery(java.sql.Connection conn,
java.lang.String baseSQL,
java.util.ArrayList values,
java.util.Map attribute2dbField,
java.lang.Class valueObjectClass,
java.lang.String booleanTrueValue,
java.lang.String booleanFalseValue,
GridParams gridParams,
int blockSize,
boolean logQuery)
This method read a block of record from the result set. |
static Response |
getQuery(java.sql.Connection conn,
java.lang.String select,
java.lang.String from,
java.lang.String where,
java.lang.String group,
java.lang.String having,
java.lang.String order,
java.util.ArrayList values,
java.util.Map attribute2dbField,
java.lang.Class valueObjectClass,
java.lang.String booleanTrueValue,
java.lang.String booleanFalseValue,
boolean logQuery)
SQL is expressed using more argument, each one without the related keyword (select, from, ...). |
static Response |
getQuery(java.sql.Connection conn,
java.lang.String select,
java.lang.String from,
java.lang.String where,
java.lang.String group,
java.lang.String having,
java.lang.String order,
java.util.ArrayList values,
java.util.Map attribute2dbField,
java.lang.Class valueObjectClass,
java.lang.String booleanTrueValue,
java.lang.String booleanFalseValue,
GridParams gridParams,
boolean logQuery)
This method read the WHOLE result set. |
static Response |
getQuery(java.sql.Connection conn,
java.lang.String select,
java.lang.String from,
java.lang.String where,
java.lang.String group,
java.lang.String having,
java.lang.String order,
java.util.ArrayList values,
java.util.Map attribute2dbField,
java.lang.Class valueObjectClass,
java.lang.String booleanTrueValue,
java.lang.String booleanFalseValue,
GridParams gridParams,
int blockSize,
boolean logQuery)
This method read a block of record from the result set. |
static Response |
getQuery(java.sql.Connection conn,
UserSessionParameters userSessionPars,
java.lang.String baseSQL,
java.util.ArrayList values,
java.util.Map attribute2dbField,
java.lang.Class valueObjectClass,
java.lang.String booleanTrueValue,
java.lang.String booleanFalseValue,
javax.servlet.ServletContext context,
boolean logQuery)
|
static Response |
getQuery(java.sql.Connection conn,
UserSessionParameters userSessionPars,
java.lang.String baseSQL,
java.util.ArrayList values,
java.util.Map attribute2dbField,
java.lang.Class valueObjectClass,
java.lang.String booleanTrueValue,
java.lang.String booleanFalseValue,
javax.servlet.ServletContext context,
GridParams gridParams,
boolean logQuery)
This method read the WHOLE result set. |
static Response |
getQuery(java.sql.Connection conn,
UserSessionParameters userSessionPars,
java.lang.String baseSQL,
java.util.ArrayList values,
java.util.Map attribute2dbField,
java.lang.Class valueObjectClass,
java.lang.String booleanTrueValue,
java.lang.String booleanFalseValue,
javax.servlet.ServletContext context,
GridParams gridParams,
int blockSize,
boolean logQuery)
This method read a block of record from the result set. |
static Response |
getQuery(java.sql.Connection conn,
UserSessionParameters userSessionPars,
java.lang.String baseSQL,
java.util.ArrayList values,
java.util.Map attribute2dbField,
java.lang.Class valueObjectClass,
java.lang.String booleanTrueValue,
java.lang.String booleanFalseValue,
javax.servlet.ServletContext context,
GridParams gridParams,
int blockSize,
boolean logQuery,
boolean fetchTotalResultSetLength)
This method read a block of record from the result set. |
static Response |
getQuery(java.sql.Connection conn,
UserSessionParameters userSessionPars,
java.lang.String select,
java.lang.String from,
java.lang.String where,
java.lang.String group,
java.lang.String having,
java.lang.String order,
java.util.ArrayList values,
java.util.Map attribute2dbField,
java.lang.Class valueObjectClass,
java.lang.String booleanTrueValue,
java.lang.String booleanFalseValue,
javax.servlet.ServletContext context,
boolean logQuery)
SQL is expressed using more argument, each one without the related keyword (select, from, ...). |
static Response |
getQuery(java.sql.Connection conn,
UserSessionParameters userSessionPars,
java.lang.String select,
java.lang.String from,
java.lang.String where,
java.lang.String group,
java.lang.String having,
java.lang.String order,
java.util.ArrayList values,
java.util.Map attribute2dbField,
java.lang.Class valueObjectClass,
java.lang.String booleanTrueValue,
java.lang.String booleanFalseValue,
javax.servlet.ServletContext context,
GridParams gridParams,
boolean logQuery)
This method read the WHOLE result set. |
static Response |
getQuery(java.sql.Connection conn,
UserSessionParameters userSessionPars,
java.lang.String select,
java.lang.String from,
java.lang.String where,
java.lang.String group,
java.lang.String having,
java.lang.String order,
java.util.ArrayList values,
java.util.Map attribute2dbField,
java.lang.Class valueObjectClass,
java.lang.String booleanTrueValue,
java.lang.String booleanFalseValue,
javax.servlet.ServletContext context,
GridParams gridParams,
int blockSize,
boolean logQuery)
This method read a block of record from the result set. |
static Response |
getQuery(java.lang.String[] attributes,
java.lang.Class valueObjectClass,
java.util.List rows,
boolean moreRows)
This method can be used to convert a list of Object[], one for each record already read, in a list of ValueObjects. |
static Response |
getQuery(java.lang.String[] attributes,
java.lang.Class valueObjectClass,
java.lang.Object[] row)
This method can be used to convert a single record Object[] to a ValueObject. |
static java.lang.String |
getSql(UserSessionParameters userSessionPars,
java.lang.String baseSQL,
java.util.ArrayList attrNames,
java.util.ArrayList values,
java.util.Map filteredColumns,
java.util.ArrayList currentSortedColumns,
java.util.ArrayList currentSortedVersusColumns,
java.util.Map attributesMapping)
This constructor can be useful when combining OpenSwing with Hibernate, to retrieve attribute names too. |
static java.lang.String |
getSql(UserSessionParameters userSessionPars,
java.lang.String baseSQL,
java.util.ArrayList attrNames,
java.util.ArrayList values,
java.util.Map filteredColumns,
java.util.ArrayList currentSortedColumns,
java.util.ArrayList currentSortedVersusColumns,
java.util.Map attributesMapping,
boolean isJPAsyntax)
This constructor can be useful when combining OpenSwing with Hibernate, to retrieve attribute names too. |
static java.lang.String |
getSql(UserSessionParameters userSessionPars,
java.lang.String baseSQL,
java.util.ArrayList values,
java.util.Map filteredColumns,
java.util.ArrayList currentSortedColumns,
java.util.ArrayList currentSortedVersusColumns,
java.util.Map attributesMapping)
|
static java.lang.String |
getSql(UserSessionParameters userSessionPars,
java.lang.String select,
java.lang.String from,
java.lang.String where,
java.lang.String group,
java.lang.String having,
java.lang.String order,
java.util.ArrayList attrNames,
java.util.ArrayList values,
java.util.Map filteredColumns,
java.util.ArrayList currentSortedColumns,
java.util.ArrayList currentSortedVersusColumns,
java.util.Map attributesMapping)
This constructor can be useful when combining OpenSwing with Hibernate, to retrieve attribute names too. |
static java.lang.String |
getSql(UserSessionParameters userSessionPars,
java.lang.String select,
java.lang.String from,
java.lang.String where,
java.lang.String group,
java.lang.String having,
java.lang.String order,
java.util.ArrayList attrNames,
java.util.ArrayList values,
java.util.Map filteredColumns,
java.util.ArrayList currentSortedColumns,
java.util.ArrayList currentSortedVersusColumns,
java.util.Map attributesMapping,
boolean isJPAsyntax)
This constructor can be useful when combining OpenSwing with Hibernate, to retrieve attribute names too. |
static java.lang.String |
getSql(UserSessionParameters userSessionPars,
java.lang.String select,
java.lang.String from,
java.lang.String where,
java.lang.String group,
java.lang.String having,
java.lang.String order,
java.util.ArrayList values,
java.util.Map filteredColumns,
java.util.ArrayList currentSortedColumns,
java.util.ArrayList currentSortedVersusColumns,
java.util.Map attributesMapping)
This constructor can be useful when combining OpenSwing with Hibernate, to retrieve attribute names too. |
static Response |
insertTable(java.sql.Connection conn,
java.util.ArrayList vos,
java.lang.String tableName,
java.util.Map attribute2dbField,
java.lang.String booleanTrueValue,
java.lang.String booleanFalseValue,
boolean logSQL)
This method esecute many insert on a table, by means of a list of value objects and a subset of its fields: all field related to that table. |
static Response |
insertTable(java.sql.Connection conn,
UserSessionParameters userSessionPars,
java.util.ArrayList vos,
java.lang.String tableName,
java.util.Map attribute2dbField,
java.lang.String booleanTrueValue,
java.lang.String booleanFalseValue,
javax.servlet.ServletContext context,
boolean logSQL)
This method esecute many insert on a table, by means of a list of value objects and a subset of its fields: all field related to that table. |
static Response |
insertTable(java.sql.Connection conn,
UserSessionParameters userSessionPars,
ValueObject vo,
java.lang.String tableName,
java.util.Map attribute2dbField,
java.lang.String booleanTrueValue,
java.lang.String booleanFalseValue,
javax.servlet.ServletContext context,
boolean logSQL)
This method esecute an insert on a table, by means of the value object and a subset of its fields: all field related to that table. |
static Response |
insertTable(java.sql.Connection conn,
ValueObject vo,
java.lang.String tableName,
java.util.Map attribute2dbField,
java.lang.String booleanTrueValue,
java.lang.String booleanFalseValue,
boolean logSQL)
This method execute an insert on a table, by means of the value object and a subset of its fields: all field related to that table. |
static Response |
updateTable(java.sql.Connection conn,
java.util.HashSet pkAttributes,
ValueObject oldVO,
ValueObject newVO,
java.lang.String tableName,
java.util.Map attribute2dbField,
java.lang.String booleanTrueValue,
java.lang.String booleanFalseValue,
boolean logSQL)
This method esecute an update on a table, by means of the value object and a subset of its fields: all field related to that table. |
static Response |
updateTable(java.sql.Connection conn,
UserSessionParameters userSessionPars,
java.util.HashSet pkAttributes,
ValueObject oldVO,
ValueObject newVO,
java.lang.String tableName,
java.util.Map attribute2dbField,
java.lang.String booleanTrueValue,
java.lang.String booleanFalseValue,
javax.servlet.ServletContext context,
boolean logSQL)
This method esecute an update on a table, by means of the value object and a subset of its fields: all field related to that table. |
Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
public QueryUtil()
Method Detail |
public static java.lang.String getSql(UserSessionParameters userSessionPars, java.lang.String baseSQL, java.util.ArrayList values, java.util.Map filteredColumns, java.util.ArrayList currentSortedColumns, java.util.ArrayList currentSortedVersusColumns, java.util.Map attributesMapping)
baseSQL
- SQL to change by adding filter and order clausesvalues
- binding values related to baseSQLfilteredColumns
- columns to add in the WHERE clausecurrentSortedColumns
- columns to add in the ORDER clausecurrentSortedVersusColumns
- ordering versusattributesMapping
- collection of pairs attributeName, corresponding database column (table.column)
public static java.lang.String getSql(UserSessionParameters userSessionPars, java.lang.String baseSQL, java.util.ArrayList attrNames, java.util.ArrayList values, java.util.Map filteredColumns, java.util.ArrayList currentSortedColumns, java.util.ArrayList currentSortedVersusColumns, java.util.Map attributesMapping)
baseSQL
- SQL to change by adding filter and order clausesattrNames
- attribute names related to filter valuesvalues
- binding values related to baseSQLfilteredColumns
- columns to add in the WHERE clausecurrentSortedColumns
- columns to add in the ORDER clausecurrentSortedVersusColumns
- ordering versusattributesMapping
- collection of pairs attributeName, corresponding database column (table.column)
public static java.lang.String getSql(UserSessionParameters userSessionPars, java.lang.String select, java.lang.String from, java.lang.String where, java.lang.String group, java.lang.String having, java.lang.String order, java.util.ArrayList values, java.util.Map filteredColumns, java.util.ArrayList currentSortedColumns, java.util.ArrayList currentSortedVersusColumns, java.util.Map attributesMapping)
select
- list of fields for select statementfrom
- list of tables for from statementwhere
- where statement; may be nullgroup
- group by statement; may be nullhaving
- having statement; may be nullorder
- list of fields for order by statement; may be nullvalues
- binding values related to baseSQLfilteredColumns
- columns to add in the WHERE clausecurrentSortedColumns
- columns to add in the ORDER clausecurrentSortedVersusColumns
- ordering versusattributesMapping
- collection of pairs attributeName, corresponding database column (table.column)
public static java.lang.String getSql(UserSessionParameters userSessionPars, java.lang.String select, java.lang.String from, java.lang.String where, java.lang.String group, java.lang.String having, java.lang.String order, java.util.ArrayList attrNames, java.util.ArrayList values, java.util.Map filteredColumns, java.util.ArrayList currentSortedColumns, java.util.ArrayList currentSortedVersusColumns, java.util.Map attributesMapping)
select
- list of fields for select statementfrom
- list of tables for from statementwhere
- where statement; may be nullgroup
- group by statement; may be nullhaving
- having statement; may be nullorder
- list of fields for order by statement; may be nullattrNames
- attribute names related to filter valuesvalues
- binding values related to baseSQLfilteredColumns
- columns to add in the WHERE clausecurrentSortedColumns
- columns to add in the ORDER clausecurrentSortedVersusColumns
- ordering versusattributesMapping
- collection of pairs attributeName, corresponding database column (table.column)
public static java.lang.String getSql(UserSessionParameters userSessionPars, java.lang.String select, java.lang.String from, java.lang.String where, java.lang.String group, java.lang.String having, java.lang.String order, java.util.ArrayList attrNames, java.util.ArrayList values, java.util.Map filteredColumns, java.util.ArrayList currentSortedColumns, java.util.ArrayList currentSortedVersusColumns, java.util.Map attributesMapping, boolean isJPAsyntax)
select
- list of fields for select statementfrom
- list of tables for from statementwhere
- where statement; may be nullgroup
- group by statement; may be nullhaving
- having statement; may be nullorder
- list of fields for order by statement; may be nullattrNames
- attribute names related to filter valuesvalues
- binding values related to baseSQLfilteredColumns
- columns to add in the WHERE clausecurrentSortedColumns
- columns to add in the ORDER clausecurrentSortedVersusColumns
- ordering versusattributesMapping
- collection of pairs attributeName, corresponding database column (table.column)isJPAsyntax
- flag
public static java.lang.String getSql(UserSessionParameters userSessionPars, java.lang.String baseSQL, java.util.ArrayList attrNames, java.util.ArrayList values, java.util.Map filteredColumns, java.util.ArrayList currentSortedColumns, java.util.ArrayList currentSortedVersusColumns, java.util.Map attributesMapping, boolean isJPAsyntax)
baseSQL
- SQL to change by adding filter and order clausesattrNames
- attribute names related to filter valuesvalues
- binding values related to baseSQLfilteredColumns
- columns to add in the WHERE clausecurrentSortedColumns
- columns to add in the ORDER clausecurrentSortedVersusColumns
- ordering versusattributesMapping
- collection of pairs attributeName, corresponding database column (table.column)isJPAsyntax
- flag
public static Response getQuery(java.sql.Connection conn, java.lang.String baseSQL, java.util.ArrayList values, java.util.Map attribute2dbField, java.lang.Class valueObjectClass, java.lang.String booleanTrueValue, java.lang.String booleanFalseValue, GridParams gridParams, boolean logQuery) throws java.lang.Exception
baseSQL
- SQL to change by adding filter and order clausesvalues
- binding values related to baseSQLattribute2dbField
- collection of pairs attributeName, corresponding database column (table.column) - for ALL fields is the select clausevalueObjectClass
- value object class to use to generate the resultbooleanTrueValue
- read value to interpret as truebooleanFalseValue
- read value to interpret as falsegridParams
- grid parameters (filtering/ordering settings, starting row to read, read versus)logQuery
- true
to log the query, false
to no log the query
java.lang.Exception
public static Response getQuery(java.sql.Connection conn, java.lang.String select, java.lang.String from, java.lang.String where, java.lang.String group, java.lang.String having, java.lang.String order, java.util.ArrayList values, java.util.Map attribute2dbField, java.lang.Class valueObjectClass, java.lang.String booleanTrueValue, java.lang.String booleanFalseValue, GridParams gridParams, boolean logQuery) throws java.lang.Exception
select
- list of fields for select statementfrom
- list of tables for from statementwhere
- where statement; may be nullgroup
- group by statement; may be nullhaving
- having statement; may be nullorder
- list of fields for order by statement; may be nullvalues
- binding values related to baseSQLattribute2dbField
- collection of pairs attributeName, corresponding database column (table.column) - for ALL fields is the select clausevalueObjectClass
- value object class to use to generate the resultbooleanTrueValue
- read value to interpret as truebooleanFalseValue
- read value to interpret as falsegridParams
- grid parameters (filtering/ordering settings, starting row to read, read versus)logQuery
- true
to log the query, false
to no log the query
java.lang.Exception
public static Response getQuery(java.sql.Connection conn, UserSessionParameters userSessionPars, java.lang.String baseSQL, java.util.ArrayList values, java.util.Map attribute2dbField, java.lang.Class valueObjectClass, java.lang.String booleanTrueValue, java.lang.String booleanFalseValue, javax.servlet.ServletContext context, GridParams gridParams, boolean logQuery) throws java.lang.Exception
baseSQL
- SQL to change by adding filter and order clausesvalues
- binding values related to baseSQLattribute2dbField
- collection of pairs attributeName, corresponding database column (table.column) - for ALL fields is the select clausevalueObjectClass
- value object class to use to generate the resultbooleanTrueValue
- read value to interpret as truebooleanFalseValue
- read value to interpret as falsecontext
- servlet context; this may be nullgridParams
- grid parameters (filtering/ordering settings, starting row to read, read versus)logQuery
- true
to log the query, false
to no log the query
java.lang.Exception
public static Response getQuery(java.sql.Connection conn, UserSessionParameters userSessionPars, java.lang.String select, java.lang.String from, java.lang.String where, java.lang.String group, java.lang.String having, java.lang.String order, java.util.ArrayList values, java.util.Map attribute2dbField, java.lang.Class valueObjectClass, java.lang.String booleanTrueValue, java.lang.String booleanFalseValue, javax.servlet.ServletContext context, GridParams gridParams, boolean logQuery) throws java.lang.Exception
select
- list of fields for select statementfrom
- list of tables for from statementwhere
- where statement; may be nullgroup
- group by statement; may be nullhaving
- having statement; may be nullorder
- list of fields for order by statement; may be nullvalues
- binding values related to baseSQLattribute2dbField
- collection of pairs attributeName, corresponding database column (table.column) - for ALL fields is the select clausevalueObjectClass
- value object class to use to generate the resultbooleanTrueValue
- read value to interpret as truebooleanFalseValue
- read value to interpret as falsecontext
- servlet context; this may be nullgridParams
- grid parameters (filtering/ordering settings, starting row to read, read versus)logQuery
- true
to log the query, false
to no log the query
java.lang.Exception
public static Response getQuery(java.sql.Connection conn, java.lang.String baseSQL, java.util.ArrayList values, java.util.Map attribute2dbField, java.lang.Class valueObjectClass, java.lang.String booleanTrueValue, java.lang.String booleanFalseValue, GridParams gridParams, int blockSize, boolean logQuery) throws java.lang.Exception
baseSQL
- SQL to change by adding filter and order clausesvalues
- binding values related to baseSQLattribute2dbField
- collection of pairs attributeName, corresponding database column (table.column) - for ALL fields is the select clausevalueObjectClass
- value object class to use to generate the resultbooleanTrueValue
- read value to interpret as truebooleanFalseValue
- read value to interpret as falsegridParams
- grid parameters (filtering/ordering settings, starting row to read, read versus)blockSize
- number of rows to readlogQuery
- true
to log the query, false
to no log the query
java.lang.Exception
public static Response getQuery(java.sql.Connection conn, java.lang.String select, java.lang.String from, java.lang.String where, java.lang.String group, java.lang.String having, java.lang.String order, java.util.ArrayList values, java.util.Map attribute2dbField, java.lang.Class valueObjectClass, java.lang.String booleanTrueValue, java.lang.String booleanFalseValue, GridParams gridParams, int blockSize, boolean logQuery) throws java.lang.Exception
select
- list of fields for select statementfrom
- list of tables for from statementwhere
- where statement; may be nullgroup
- group by statement; may be nullhaving
- having statement; may be nullorder
- list of fields for order by statement; may be nullvalues
- binding values related to baseSQLattribute2dbField
- collection of pairs attributeName, corresponding database column (table.column) - for ALL fields is the select clausevalueObjectClass
- value object class to use to generate the resultbooleanTrueValue
- read value to interpret as truebooleanFalseValue
- read value to interpret as falsegridParams
- grid parameters (filtering/ordering settings, starting row to read, read versus)blockSize
- number of rows to readlogQuery
- true
to log the query, false
to no log the query
java.lang.Exception
public static Response getQuery(java.sql.Connection conn, UserSessionParameters userSessionPars, java.lang.String baseSQL, java.util.ArrayList values, java.util.Map attribute2dbField, java.lang.Class valueObjectClass, java.lang.String booleanTrueValue, java.lang.String booleanFalseValue, javax.servlet.ServletContext context, GridParams gridParams, int blockSize, boolean logQuery) throws java.lang.Exception
baseSQL
- SQL to change by adding filter and order clausesvalues
- binding values related to baseSQLattribute2dbField
- collection of pairs attributeName, corresponding database column (table.column) - for ALL fields is the select clausevalueObjectClass
- value object class to use to generate the resultbooleanTrueValue
- read value to interpret as truebooleanFalseValue
- read value to interpret as falsecontext
- servlet context; this may be nullgridParams
- grid parameters (filtering/ordering settings, starting row to read, read versus)blockSize
- number of rows to readlogQuery
- true
to log the query, false
to no log the query
java.lang.Exception
public static Response getQuery(java.sql.Connection conn, UserSessionParameters userSessionPars, java.lang.String baseSQL, java.util.ArrayList values, java.util.Map attribute2dbField, java.lang.Class valueObjectClass, java.lang.String booleanTrueValue, java.lang.String booleanFalseValue, javax.servlet.ServletContext context, GridParams gridParams, int blockSize, boolean logQuery, boolean fetchTotalResultSetLength) throws java.lang.Exception
baseSQL
- SQL to change by adding filter and order clausesvalues
- binding values related to baseSQLattribute2dbField
- collection of pairs attributeName, corresponding database column (table.column) - for ALL fields is the select clausevalueObjectClass
- value object class to use to generate the resultbooleanTrueValue
- read value to interpret as truebooleanFalseValue
- read value to interpret as falsecontext
- servlet context; this may be nullgridParams
- grid parameters (filtering/ordering settings, starting row to read, read versus)blockSize
- number of rows to readlogQuery
- true
to log the query, false
to no log the queryfetchTotalResultSetLength
- fetch all result set length; be careful: this task could slow down the data retrieval
java.lang.Exception
public static Response getQuery(java.sql.Connection conn, UserSessionParameters userSessionPars, java.lang.String select, java.lang.String from, java.lang.String where, java.lang.String group, java.lang.String having, java.lang.String order, java.util.ArrayList values, java.util.Map attribute2dbField, java.lang.Class valueObjectClass, java.lang.String booleanTrueValue, java.lang.String booleanFalseValue, javax.servlet.ServletContext context, GridParams gridParams, int blockSize, boolean logQuery) throws java.lang.Exception
select
- list of fields for select statementfrom
- list of tables for from statementwhere
- where statement; may be nullgroup
- group by statement; may be nullhaving
- having statement; may be nullorder
- list of fields for order by statement; may be nullvalues
- binding values related to baseSQLattribute2dbField
- collection of pairs attributeName, corresponding database column (table.column) - for ALL fields is the select clausevalueObjectClass
- value object class to use to generate the resultbooleanTrueValue
- read value to interpret as truebooleanFalseValue
- read value to interpret as falsecontext
- servlet context; this may be nullgridParams
- grid parameters (filtering/ordering settings, starting row to read, read versus)blockSize
- number of rows to readlogQuery
- true
to log the query, false
to no log the query
java.lang.Exception
public static Response getQuery(java.sql.Connection conn, java.lang.String baseSQL, java.util.ArrayList values, java.util.Map attribute2dbField, java.lang.Class valueObjectClass, java.lang.String booleanTrueValue, java.lang.String booleanFalseValue, boolean logQuery) throws java.lang.Exception
baseSQL
- SQL to change by adding filter and order clausesvalues
- binding values related to baseSQLattribute2dbField
- collection of pairs attributeName, corresponding database column (table.column) - for ALL fields is the select clausevalueObjectClass
- value object class to use to generate the resultbooleanTrueValue
- read value to interpret as truebooleanFalseValue
- read value to interpret as falselogQuery
- true
to log the query, false
to no log the query
java.lang.Exception
public static Response getQuery(java.sql.Connection conn, java.lang.String select, java.lang.String from, java.lang.String where, java.lang.String group, java.lang.String having, java.lang.String order, java.util.ArrayList values, java.util.Map attribute2dbField, java.lang.Class valueObjectClass, java.lang.String booleanTrueValue, java.lang.String booleanFalseValue, boolean logQuery) throws java.lang.Exception
select
- list of fields for select statementfrom
- list of tables for from statementwhere
- where statement; may be nullgroup
- group by statement; may be nullhaving
- having statement; may be nullorder
- list of fields for order by statement; may be nullvalues
- binding values related to baseSQLattribute2dbField
- collection of pairs attributeName, corresponding database column (table.column) - for ALL fields is the select clausevalueObjectClass
- value object class to use to generate the resultbooleanTrueValue
- read value to interpret as truebooleanFalseValue
- read value to interpret as falselogQuery
- true
to log the query, false
to no log the query
java.lang.Exception
public static Response getQuery(java.sql.Connection conn, UserSessionParameters userSessionPars, java.lang.String baseSQL, java.util.ArrayList values, java.util.Map attribute2dbField, java.lang.Class valueObjectClass, java.lang.String booleanTrueValue, java.lang.String booleanFalseValue, javax.servlet.ServletContext context, boolean logQuery) throws java.lang.Exception
baseSQL
- SQL to change by adding filter and order clausesvalues
- binding values related to baseSQLattribute2dbField
- collection of pairs attributeName, corresponding database column (table.column) - for ALL fields is the select clausevalueObjectClass
- value object class to use to generate the resultbooleanTrueValue
- read value to interpret as truebooleanFalseValue
- read value to interpret as falsecontext
- servlet context; this may be nulllogQuery
- true
to log the query, false
to no log the query
java.lang.Exception
public static Response getQuery(java.sql.Connection conn, UserSessionParameters userSessionPars, java.lang.String select, java.lang.String from, java.lang.String where, java.lang.String group, java.lang.String having, java.lang.String order, java.util.ArrayList values, java.util.Map attribute2dbField, java.lang.Class valueObjectClass, java.lang.String booleanTrueValue, java.lang.String booleanFalseValue, javax.servlet.ServletContext context, boolean logQuery) throws java.lang.Exception
select
- list of fields for select statementfrom
- list of tables for from statementwhere
- where statement; may be nullgroup
- group by statement; may be nullhaving
- having statement; may be nullorder
- list of fields for order by statement; may be nullvalues
- binding values related to baseSQLattribute2dbField
- collection of pairs attributeName, corresponding database column (table.column) - for ALL fields is the select clausevalueObjectClass
- value object class to use to generate the resultbooleanTrueValue
- read value to interpret as truebooleanFalseValue
- read value to interpret as falsecontext
- servlet context; this may be nulllogQuery
- true
to log the query, false
to no log the query
java.lang.Exception
public static Response insertTable(java.sql.Connection conn, ValueObject vo, java.lang.String tableName, java.util.Map attribute2dbField, java.lang.String booleanTrueValue, java.lang.String booleanFalseValue, boolean logSQL) throws java.lang.Exception
vo
- value object to use on inserttableName
- table name to use on insertattribute2dbField
- collection of pairs attributeName, corresponding database column (table.column) - for ALL fields related to the specified tablebooleanTrueValue
- value to interpret as truebooleanFalseValue
- value to interpret as falselogSQL
- true
to log the SQL, false
to no log the SQL
java.lang.Exception
public static Response insertTable(java.sql.Connection conn, UserSessionParameters userSessionPars, ValueObject vo, java.lang.String tableName, java.util.Map attribute2dbField, java.lang.String booleanTrueValue, java.lang.String booleanFalseValue, javax.servlet.ServletContext context, boolean logSQL) throws java.lang.Exception
vo
- value object to use on inserttableName
- table name to use on insertattribute2dbField
- collection of pairs attributeName, corresponding database column (table.column) - for ALL fields related to the specified tablebooleanTrueValue
- value to interpret as truebooleanFalseValue
- value to interpret as falsecontext
- servlet context; this may be nulllogSQL
- true
to log the SQL, false
to no log the SQL
java.lang.Exception
public static Response insertTable(java.sql.Connection conn, java.util.ArrayList vos, java.lang.String tableName, java.util.Map attribute2dbField, java.lang.String booleanTrueValue, java.lang.String booleanFalseValue, boolean logSQL) throws java.lang.Exception
vos
- list of ValueObject's to use on insert operationstableName
- table name to use on insertattribute2dbField
- collection of pairs attributeName, corresponding database column (table.column) - for ALL fields related to the specified tablebooleanTrueValue
- value to interpret as truebooleanFalseValue
- value to interpret as falselogSQL
- true
to log the SQL, false
to no log the SQL
java.lang.Exception
public static Response insertTable(java.sql.Connection conn, UserSessionParameters userSessionPars, java.util.ArrayList vos, java.lang.String tableName, java.util.Map attribute2dbField, java.lang.String booleanTrueValue, java.lang.String booleanFalseValue, javax.servlet.ServletContext context, boolean logSQL) throws java.lang.Exception
vos
- list of ValueObject's to use on insert operationstableName
- table name to use on insertattribute2dbField
- collection of pairs attributeName, corresponding database column (table.column) - for ALL fields related to the specified tablebooleanTrueValue
- value to interpret as truebooleanFalseValue
- value to interpret as falsecontext
- servlet context; this may be nulllogSQL
- true
to log the SQL, false
to no log the SQL
java.lang.Exception
public static Response updateTable(java.sql.Connection conn, java.util.HashSet pkAttributes, ValueObject oldVO, ValueObject newVO, java.lang.String tableName, java.util.Map attribute2dbField, java.lang.String booleanTrueValue, java.lang.String booleanFalseValue, boolean logSQL) throws java.lang.Exception
pkAttributes
- v.o. attributes related to the primary key of the tableoldVO
- previous value object to use on the where clausenewVO
- new value object to use on updatetableName
- table name to use on updateattribute2dbField
- collection of pairs attributeName, corresponding database column (table.column) - for ALL fields related to the specified tablebooleanTrueValue
- value to interpret as truebooleanFalseValue
- value to interpret as falselogSQL
- true
to log the SQL, false
to no log the SQL
java.lang.Exception
public static Response updateTable(java.sql.Connection conn, UserSessionParameters userSessionPars, java.util.HashSet pkAttributes, ValueObject oldVO, ValueObject newVO, java.lang.String tableName, java.util.Map attribute2dbField, java.lang.String booleanTrueValue, java.lang.String booleanFalseValue, javax.servlet.ServletContext context, boolean logSQL) throws java.lang.Exception
pkAttributes
- v.o. attributes related to the primary key of the tableoldVO
- previous value object to use on the where clausenewVO
- new value object to use on updatetableName
- table name to use on updateattribute2dbField
- collection of pairs attributeName, corresponding database column (table.column) - for ALL fields related to the specified tablebooleanTrueValue
- value to interpret as truebooleanFalseValue
- value to interpret as falsecontext
- servlet context; this may be nulllogSQL
- true
to log the SQL, false
to no log the SQL
java.lang.Exception
public static Response getQuery(java.lang.String[] attributes, java.lang.Class valueObjectClass, java.util.List rows, boolean moreRows) throws java.lang.Exception
attributes
- list of attribute names of the specified value object, exactly one for each fields is the select clause (i.e. one for each elements of Object[])valueObjectClass
- value object class to use to generate the resultrows
- list of Object[] elements, one for each record already readmoreRows
- true
if there are still other records to read after these ones, false
if no other records ara available
java.lang.Exception
public static Response getQuery(java.lang.String[] attributes, java.lang.Class valueObjectClass, java.lang.Object[] row) throws java.lang.Exception
attributes
- list of attribute names of the specified value object, exactly one for each fields is the select clause (i.e. one for each elements of Object[])valueObjectClass
- value object class to use to generate the resultrow
- Object[], related to the record already read
java.lang.Exception
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |