Package org.bgerp.plugin.svc.dba.dao

Class QueryDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

org.bgerp.plugin.svc.dba.dao.QueryDAO

public class QueryDAO
extends CommonDAO

SQL query execution DAO.

Nested Class Summary

Nested classes/interfaces inherited from class ru.bgcrm.dao.CommonDAO

CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T extends Id>

Field Summary

Fields inherited from class ru.bgcrm.dao.CommonDAO

con, log, SQL_AND, SQL_DELETE, SQL_DELETE_FROM, SQL_DESC, SQL_DISTINCT, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT, SQL_INSERT_IGNORE, SQL_INSERT_INTO, SQL_LEFT_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UNION_ALL, SQL_UPDATE, SQL_VALUES, SQL_WHERE

Constructor Summary

Constructors

Constructor	Description
QueryDAO(ConnectionSet conSet)

Method Summary

Modifier and Type	Method	Description
void	query(QueryTable table, QueryType type, String query)	Executes SQL query.

Methods inherited from class ru.bgcrm.dao.CommonDAO

deleteById, foundRows, getById, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePatternEnd, getLikePatternStart, getLikePatternSub, getPageLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, update, updateColumn, updateIds, updateIds, updateOrInsert

Methods inherited from class java.lang.Object

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

Constructor Details

QueryDAO

public QueryDAO(ConnectionSet conSet)

Method Details

query

public void query(QueryTable table,
 QueryType type,
 String query)
           throws SQLException

Executes SQL query.

Parameters:

table - resulting table with pagination.

type - type.

query - the query.

Throws:

SQLException