Uses of Interface
overit.geocall.sql.DBStatement

Packages that use DBStatement

Package	Description
overit.geocall.basic.bl.auth.da
overit.geocall.basic.bl.message.da
overit.geocall.basic.bl.user.da
overit.geocall.basic.ui.xlsx
overit.geocall.da
overit.geocall.sql
overit.geocallapp.wfm.ai.bl.duration.prediction.data
overit.geocallapp.wfm.ai.replicator.meterreading.data
overit.geocallapp.wfm.cee.replicator.datasource
overit.geocallapp.wfm.core.bl.location.microcluster.data
overit.geocallapp.wfm.core.bl.workshift.type.data
overit.geocallapp.wfm.inventory.bl.warehouse.materialstock.data
overit.geocallapp.wfm.inventory.replicator.data
overit.geocallapp.wfm.mobile.core.bl.workorder.data
overit.geocallapp.wfm.mobile.core.replicator.bundler.data
overit.geocallapp.wfm.mobile.core.replicator.measuringelement.attachment.data
overit.geocallapp.wfm.mobile.core.replicator.technicalobject.attachment.data
overit.geocallapp.wfm.mobile.core.replicator.workorder.data
overit.geocallapp.wfm.notifications.dashboard
overit.geocallapp.wfm.notifications.notification.da
overit.geocallapp.wfm.scheduling.timeslot.bl.data

Uses of DBStatement in overit.geocall.basic.bl.auth.da

Methods in overit.geocall.basic.bl.auth.da with parameters of type DBStatement

Modifier and Type	Method	Description
protected void	DAOApiKey.feedback(CommandContext cc, PoolKit pk, DBStatement dbs)

Uses of DBStatement in overit.geocall.basic.bl.message.da

Methods in overit.geocall.basic.bl.message.da with parameters of type DBStatement

Modifier and Type	Method	Description
protected int	DAMessages.giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter oKeys, HashGetter oParams)
protected DBView	DAMessages.giveQueries(int i, PooledConnection conn, DBStatement dbs, HashGetter oParams, int maxrows, int skiprows)

Uses of DBStatement in overit.geocall.basic.bl.user.da

Methods in overit.geocall.basic.bl.user.da with parameters of type DBStatement

Modifier and Type	Method	Description
protected int	DAOUserPassword.giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter oKeys, HashGetter oParams)
protected int	DAUsers.giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter oKeys, HashGetter oParams)
protected DBView	DAOUserPassword.giveQueries(int i, PooledConnection conn, DBStatement dbs, HashGetter oParams, int maxrows, int skiprows)
protected DBView	DAUsers.giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter oParams, int maxrows, int skiprows)

Uses of DBStatement in overit.geocall.basic.ui.xlsx

Fields in overit.geocall.basic.ui.xlsx declared as DBStatement

Modifier and Type	Field	Description
protected DBStatement	XlsxDBStatementView._dbs

Methods in overit.geocall.basic.ui.xlsx that return DBStatement

Modifier and Type	Method	Description
DBStatement	XlsxDBStatementView.getDBStatement()	Gets the DBStatement.

Uses of DBStatement in overit.geocall.da

Methods in overit.geocall.da with parameters of type DBStatement

Modifier and Type	Method	Description
protected void	DAO.defineStatement(CommandContext cc, PoolKit pk, DBStatement dbs)	The method defines the DBStatement, sets the SQL and the parameters for the execution of the commands
protected void	DAO0.defineStatement(CommandContext cc, PooledConnection pc, DBStatement dbs)	Deprecated. The method defines the DBStatement, sets the SQL and the parameters for the execution of the commands
protected void	DAO.feedback(CommandContext cc, PoolKit pk, DBStatement dbs)	Method to be extended to carry out operations exploiting the result of the executed command; for example it can be used to implement CASE WHEN logics that can therefore be deleted from the SQL.
protected void	DAO0.feedback(CommandContext cc, PooledConnection pc, DBStatement dbs)	Deprecated. Method to be extended to carry out operations exploiting the result of the executed command; for example it can be used to implement CASE WHEN logics that can therefore be deleted from the SQL.
void	FeedbackService.feedback(@NotNull CommandContext cc, @NotNull PoolKit pk, @NotNull DBStatement dbs)	Updates the provided CommandContext with the query results.
protected static Long	DAUtils.getAutoIncrementedVal(DBStatement insertDbs, PoolKit pk)
protected static Long	DAUtils.getAutoIncrementedVal(DBStatement insertDbs, PooledConnection conn)	Retrieves the new id according to the specific DB.
protected Long	DABase.getAutoIncrementVal(DBStatement insertDbs, PooledConnection conn)	Retrieves the new id according to the specific DB.
protected abstract int	DABase.giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, HashGetter values)	Implements new specific commands that are different from the standard ones.
protected abstract DBView	DABase.giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, int maxrows, int skiprows)	Implements new specific queries that are different from the standard ones.
protected void	DABase.postInsert(HashGetter values, PooledConnection conn, DBStatement insertDbs)	Called after every insert command.
static void	DAUtils.setDBMaps(DBStatement dbs, DBFieldMap fm, DBObjectMap om)	Sets the DBObjectMap or DBFieldMap into the DBStatement

Uses of DBStatement in overit.geocall.sql

Classes in overit.geocall.sql that implement DBStatement

Modifier and Type	Class	Description
class	StandardDBStatement	The class is the standard implementation of the DBStatement interface

Fields in overit.geocall.sql declared as DBStatement

Modifier and Type	Field	Description
protected final DBStatement	DBCursor.dbs

Fields in overit.geocall.sql with type parameters of type DBStatement

Modifier and Type	Field	Description
protected ArrayList<DBStatement>	PooledConnection._dbstatements	Contains the list of DBStatement opened by the connection through the PooledConnection.getDBStatement() method.

Methods in overit.geocall.sql that return DBStatement

Modifier and Type	Method	Description
DBStatement	PooledConnection.getDBStatement()	Asks to the connection to instanciate a DBStatement

Methods in overit.geocall.sql with parameters of type DBStatement

Modifier and Type	Method	Description
void	DBStatementObserver.onStatementCreated(DBStatement dbs)	Notifies the instantiation of a new DBStatement
void	DBStatementObserver.onStatementReleased(DBStatement dbs)	Notifies the release of the DBStatement
void	PooledConnection.releaseDBStatement(DBStatement dbs)	Returns, for closing, a statement previously requested to the connection

Constructors in overit.geocall.sql with parameters of type DBStatement

Modifier	Constructor	Description
	DBCursor(DBStatement dbs)	contruct a cursor over the statement parameter
	Parsing(int type, String sql, Map<String,Object> pairs, DBStatement dbStatement, StandardDBStatement.LocalLogger ll)

Uses of DBStatement in overit.geocallapp.wfm.ai.bl.duration.prediction.data

Methods in overit.geocallapp.wfm.ai.bl.duration.prediction.data with parameters of type DBStatement

Modifier and Type	Method	Description
protected void	DAOAIDataExtraction.defineStatement(CommandContext cc, PoolKit pk, DBStatement dbs)

Uses of DBStatement in overit.geocallapp.wfm.ai.replicator.meterreading.data

Methods in overit.geocallapp.wfm.ai.replicator.meterreading.data with parameters of type DBStatement

Modifier and Type	Method	Description
protected int	DAArtificialIntelligence.giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter oKeys, HashGetter oParams)
protected DBView	DAArtificialIntelligence.giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, int maxrows, int skiprows)

Uses of DBStatement in overit.geocallapp.wfm.cee.replicator.datasource

Methods in overit.geocallapp.wfm.cee.replicator.datasource with parameters of type DBStatement

Modifier and Type	Method	Description
protected int	DACeeInterventions.giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter oKeys, HashGetter oParams)
protected DBView	DACeeInterventions.giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, int maxrows, int skiprows)

Uses of DBStatement in overit.geocallapp.wfm.core.bl.location.microcluster.data

Methods in overit.geocallapp.wfm.core.bl.location.microcluster.data with parameters of type DBStatement

Modifier and Type	Method	Description
protected void	DAOSearchMicroclusterBoundingBox.defineStatement(CommandContext cc, PoolKit pk, DBStatement dbs)

Uses of DBStatement in overit.geocallapp.wfm.core.bl.workshift.type.data

Methods in overit.geocallapp.wfm.core.bl.workshift.type.data with parameters of type DBStatement

Modifier and Type	Method	Description
protected void	DAOSearchWorkShiftType.defineStatement(CommandContext cc, PoolKit pk, DBStatement dbs)

Uses of DBStatement in overit.geocallapp.wfm.inventory.bl.warehouse.materialstock.data

Methods in overit.geocallapp.wfm.inventory.bl.warehouse.materialstock.data with parameters of type DBStatement

Modifier and Type	Method	Description
protected void	DAOWarehouseMaterialStockSearch.defineStatement(CommandContext cc, PoolKit pk, DBStatement dbs)

Uses of DBStatement in overit.geocallapp.wfm.inventory.replicator.data

Methods in overit.geocallapp.wfm.inventory.replicator.data with parameters of type DBStatement

Modifier and Type	Method	Description
protected int	DAInventoryWarehouse.giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter oKeys, HashGetter oParams)
protected DBView	DAInventoryWarehouse.giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, int maxrows, int skiprows)

Uses of DBStatement in overit.geocallapp.wfm.mobile.core.bl.workorder.data

Methods in overit.geocallapp.wfm.mobile.core.bl.workorder.data with parameters of type DBStatement

Modifier and Type	Method	Description
protected void	DAOMobileWorkOrderSearch.feedback(CommandContext cc, PoolKit pk, DBStatement dbs)

Uses of DBStatement in overit.geocallapp.wfm.mobile.core.replicator.bundler.data

Methods in overit.geocallapp.wfm.mobile.core.replicator.bundler.data with parameters of type DBStatement

Modifier and Type	Method	Description
protected int	DAMobileBundler.giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter oKeys, HashGetter oParams)
protected DBView	DAMobileBundler.giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, int maxrows, int skiprows)

Uses of DBStatement in overit.geocallapp.wfm.mobile.core.replicator.measuringelement.attachment.data

Methods in overit.geocallapp.wfm.mobile.core.replicator.measuringelement.attachment.data with parameters of type DBStatement

Modifier and Type	Method	Description
protected int	DARMeasureMediaFile.giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter oKeys, HashGetter oParams)
protected DBView	DARMeasureMediaFile.giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, int maxrows, int skiprows)

Uses of DBStatement in overit.geocallapp.wfm.mobile.core.replicator.technicalobject.attachment.data

Methods in overit.geocallapp.wfm.mobile.core.replicator.technicalobject.attachment.data with parameters of type DBStatement

Modifier and Type	Method	Description
protected int	DARTechnicalObjectMediaFile.giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter oKeys, HashGetter oParams)
protected DBView	DARTechnicalObjectMediaFile.giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, int maxrows, int skiprows)

Uses of DBStatement in overit.geocallapp.wfm.mobile.core.replicator.workorder.data

Methods in overit.geocallapp.wfm.mobile.core.replicator.workorder.data with parameters of type DBStatement

Modifier and Type	Method	Description
protected DBView	DAAgendaResource.giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, int maxrows, int skiprows)
protected DBView	DAWOOperationResources.giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, int maxrows, int skiprows)

Uses of DBStatement in overit.geocallapp.wfm.notifications.dashboard

Methods in overit.geocallapp.wfm.notifications.dashboard with parameters of type DBStatement

Modifier and Type	Method	Description
protected void	DADashboard.addBranchFilter(int i, DBStatement stmt, HashGetter filter, PooledConnection conn)
protected void	DADashboard.addCustomJoin(int i, DBStatement stmt, HashGetter filter)
protected void	DADashboard.addNotificationFilters(int i, DBStatement stmt, HashGetter filter, PooledConnection conn)
protected void	DADashboard.addRightJoinGrouping(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, String field)
protected void	DADashboard.addWOFilters(int i, DBStatement stmt, HashGetter filter, PooledConnection conn)
protected int	DADashboard.giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, HashGetter values)
protected DBView	DADashboard.giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, int maxrows, int skiprows)

Uses of DBStatement in overit.geocallapp.wfm.notifications.notification.da

Methods in overit.geocallapp.wfm.notifications.notification.da with parameters of type DBStatement

Modifier and Type	Method	Description
protected void	DAXWFMRNotifTypeOrderType.addCommonFilters(DBStatement stmt, HashGetter oParams)
protected int	DAXWFMAAvvisi.giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, HashGetter values)
protected int	DAXWFMAAvvisiAttivita.giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, HashGetter values)
protected int	DAXWFMAAvvisiCataloghi.giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, HashGetter values)
protected int	DAXWFMAAvvisiRighe.giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, HashGetter values)
protected int	DAXWFMAAvvisiTesto.giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, HashGetter values)
protected int	DAXWFMAProgressiviAvvisi.giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, HashGetter values)
protected int	DAXWFMRNotifTypeOrderType.giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter oKeys, HashGetter oParams)
protected int	DAXWFMTAutomiRighe.giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, HashGetter values)
protected int	DAXWFMTGruppoCatalogo.giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, HashGetter values)
protected int	DAXWFMTParametriAutomiAvvisi.giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, HashGetter values)
protected int	DAXWFMTStatoAvvisoSAP.giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter oKeys, HashGetter oParams)
protected int	DAXWFMTTipoCatalogo.giveCommands(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, HashGetter values)
protected DBView	DAXWFMAAvvisi.giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter oParams, int maxrows, int skiprows)
protected DBView	DAXWFMAAvvisiAttivita.giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter oParams, int maxrows, int skiprows)
protected DBView	DAXWFMAAvvisiCataloghi.giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter oParams, int maxrows, int skiprows)
protected DBView	DAXWFMAAvvisiRighe.giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter oParams, int maxrows, int skiprows)
protected DBView	DAXWFMAAvvisiTesto.giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter oParams, int maxrows, int skiprows)
protected DBView	DAXWFMAProgressiviAvvisi.giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter oParams, int maxrows, int skiprows)
protected DBView	DAXWFMRNotifTypeOrderType.giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter oParams, int maxrows, int skiprows)
protected DBView	DAXWFMTAutomiRighe.giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, int maxrows, int skiprows)
protected DBView	DAXWFMTGruppoCatalogo.giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter oParams, int maxrows, int skiprows)
protected DBView	DAXWFMTParametriAutomiAvvisi.giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter filter, int maxrows, int skiprows)
protected DBView	DAXWFMTStatoAvvisoSAP.giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter oParams, int maxrows, int skiprows)
protected DBView	DAXWFMTTipoCatalogo.giveQueries(int i, PooledConnection conn, DBStatement stmt, HashGetter oParams, int maxrows, int skiprows)

Uses of DBStatement in overit.geocallapp.wfm.scheduling.timeslot.bl.data

Methods in overit.geocallapp.wfm.scheduling.timeslot.bl.data with parameters of type DBStatement

Modifier and Type	Method	Description
protected void	DAOSchedulingTimeslot.defineStatement(CommandContext cc, PoolKit pk, DBStatement dbs)