lumis.util.query.jdbc

Class GenericQueryAdapterJdbc

java.lang.Object

lumis.util.query.jdbc.GenericQueryAdapterJdbc

All Implemented Interfaces:

IQueryAdapter

Direct Known Subclasses:

QueryAdapterHibernate

public class GenericQueryAdapterJdbc
extends Object
implements IQueryAdapter

Generic query adapter, that generates ANSI 92 compatible SQLs for queries structures.

Since:

4.0.0

Version:

$Revision: 23897 $ $Date: 2020-06-10 20:11:17 +0000 (Wed, 10 Jun 2020) $

See Also:

QuerySelect, QueryDelete, QueryUpdate

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
protected static class	GenericQueryAdapterJdbc.Parameter

Field Summary

Fields

Modifier and Type	Field and Description
protected List<GenericQueryAdapterJdbc.Parameter>	parameters

Constructor Summary

Constructors

Constructor and Description
GenericQueryAdapterJdbc()

Method Summary

Modifier and Type	Method and Description
protected void	addQuerySqlFilter(StringBuilder sql, IQueryFilter filter)
protected void	addQuerySqlFilters(StringBuilder sql, List<IQueryFilter> filters)
protected void	addQuerySqlFilters(StringBuilder sql, QueryBase query)
protected void	addQuerySqlFiltersByTable(StringBuilder sql, QueryTable queryTable, QueryBase query)
protected void	addQuerySqlGroupBy(StringBuilder sql, QuerySelect querySelect) Inserts the group by clause.
protected void	addQuerySqlOrderBy(StringBuilder sql, QuerySelect query)
protected void	addSelectSqlFields(StringBuilder sql, QuerySelect query)
protected void	addSelectSqlTables(StringBuilder sql, QuerySelect query)
protected IQueryStatement	generateQueryStatementFromSQL(QueryBase queryBase, String sql, String sqlWithoutOrderBy, boolean resultSetScrollable, ITransaction transaction)
String	getCreateTableScript(QueryCreateTable queryCreateTable, ITransaction transaction)
IQueryStatement	getDeleteStatement(QueryDelete queryDelete, ITransaction transaction)
protected String	getField(QueryField queryField)
IQueryStatement	getInsertStatement(QueryInsert queryInsert, ITransaction transaction)
IQueryStatement	getSelectCountStatement(QuerySelect query, ITransaction transaction)
IQueryStatement	getSelectStatement(QuerySelect query, ITransaction transaction)
IQueryStatement	getUpdateStatement(QueryUpdate queryUpdate, ITransaction transaction)
protected String	getValue(IQueryValue queryValue, IQueryValue field)
protected String	getValue(IQueryValue queryValue, IQueryValue field, boolean convertText)
protected String	getValue(IQueryValue queryValue, QueryField field, boolean convertText)

Methods inherited from class java.lang.Object

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

Field Detail

parameters

protected List<GenericQueryAdapterJdbc.Parameter> parameters

Constructor Detail

GenericQueryAdapterJdbc

public GenericQueryAdapterJdbc()

Method Detail

generateQueryStatementFromSQL

protected IQueryStatement generateQueryStatementFromSQL(QueryBase queryBase,
                                                        String sql,
                                                        String sqlWithoutOrderBy,
                                                        boolean resultSetScrollable,
                                                        ITransaction transaction)
                                                 throws PortalException

Throws:

PortalException

getSelectStatement

public IQueryStatement getSelectStatement(QuerySelect query,
                                          ITransaction transaction)
                                   throws DaoException,
                                          PortalException

Specified by:

getSelectStatement in interface IQueryAdapter

Throws:

DaoException

PortalException

getInsertStatement

public IQueryStatement getInsertStatement(QueryInsert queryInsert,
                                          ITransaction transaction)
                                   throws DaoException,
                                          PortalException

Specified by:

getInsertStatement in interface IQueryAdapter

Throws:

DaoException

PortalException

getUpdateStatement

public IQueryStatement getUpdateStatement(QueryUpdate queryUpdate,
                                          ITransaction transaction)
                                   throws DaoException,
                                          PortalException

Specified by:

getUpdateStatement in interface IQueryAdapter

Throws:

DaoException

PortalException

getDeleteStatement

public IQueryStatement getDeleteStatement(QueryDelete queryDelete,
                                          ITransaction transaction)
                                   throws DaoException,
                                          PortalException

Specified by:

getDeleteStatement in interface IQueryAdapter

Throws:

DaoException

PortalException

getCreateTableScript

public String getCreateTableScript(QueryCreateTable queryCreateTable,
                                   ITransaction transaction)
                            throws DaoException,
                                   PortalException

Specified by:

getCreateTableScript in interface IQueryAdapter

Throws:

DaoException

PortalException

addSelectSqlFields

protected void addSelectSqlFields(StringBuilder sql,
                                  QuerySelect query)

addSelectSqlTables

protected void addSelectSqlTables(StringBuilder sql,
                                  QuerySelect query)

addQuerySqlFiltersByTable

protected void addQuerySqlFiltersByTable(StringBuilder sql,
                                         QueryTable queryTable,
                                         QueryBase query)

addQuerySqlFilters

protected void addQuerySqlFilters(StringBuilder sql,
                                  QueryBase query)

addQuerySqlFilters

protected void addQuerySqlFilters(StringBuilder sql,
                                  List<IQueryFilter> filters)

addQuerySqlFilter

protected void addQuerySqlFilter(StringBuilder sql,
                                 IQueryFilter filter)

getValue

protected String getValue(IQueryValue queryValue,
                          IQueryValue field,
                          boolean convertText)

getValue

protected String getValue(IQueryValue queryValue,
                          IQueryValue field)

getValue

protected String getValue(IQueryValue queryValue,
                          QueryField field,
                          boolean convertText)

getField

protected String getField(QueryField queryField)

getSelectCountStatement

public IQueryStatement getSelectCountStatement(QuerySelect query,
                                               ITransaction transaction)
                                        throws DaoException,
                                               PortalException

Specified by:

getSelectCountStatement in interface IQueryAdapter

Throws:

DaoException

PortalException

addQuerySqlOrderBy

protected void addQuerySqlOrderBy(StringBuilder sql,
                                  QuerySelect query)

addQuerySqlGroupBy

protected void addQuerySqlGroupBy(StringBuilder sql,
                                  QuerySelect querySelect)

Inserts the group by clause.

Parameters:

sql - the query string.

querySelect - the query select.

Since:

7.0.0