Package com.jk.webstack.controllers

Class JKWebControllerWithSqlDataAccess

java.lang.Object

com.jk.web.faces.controllers.JKWebController

com.jk.webstack.controllers.JKWebAppBaseController

com.jk.webstack.controllers.JKWebControllerWithSqlDataAccess

All Implemented Interfaces:

Serializable

Direct Known Subclasses:

JKWebControllerWithOrmSupport

public class JKWebControllerWithSqlDataAccess
extends JKWebAppBaseController

This class extends the JKWebAppBaseController and provides additional functionality for working with SQL data access.

Version:

1.0

Author:

Dr. Jalal H. Kiswani

See Also:

• Serialized Form

Field Summary

Fields

Modifier and Type	Field	Description
protected JKDataAccessService	sqlDataAccess	Represents the SQL data access service for executing SQL queries.

Fields inherited from class com.jk.web.faces.controllers.JKWebController

logger

Constructor Summary

Constructors

Constructor	Description
JKWebControllerWithSqlDataAccess()

Method Summary

Modifier and Type	Method	Description
protected void	execute(String query, Object... params)	This method executes an SQL query with the given parameters using the SQL data access service.
JKDataAccessService	getSqlDataAccess()	This method gets the SQL data access service used for executing SQL queries.

Methods inherited from class com.jk.webstack.controllers.JKWebAppBaseController

getActionLogName, getActionLogService, getEmail, getEmailService, getFamilyName, getFirstName, getIdToken, getUserName, isUserLoggedIn, logAction

Methods inherited from class com.jk.web.faces.controllers.JKWebController

context, error, error, executeAsyc, getContextParam, getContextPath, getFromAppliaction, getFromRequest, getFromSession, getParam, getParamterFromRequest, getRoles, getTenantId, getViewScopedManagedBean, handleException, init, isDebug, isDevelopmentMode, postConstruct, redirect, request, session, showErrorDialogMessage, showInfoDialogMessage, showWarningDialogMessage, success, success, suggestName, updateUi, warning

Methods inherited from class java.lang.Object

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

Field Details

sqlDataAccess

protected JKDataAccessService sqlDataAccess

Represents the SQL data access service for executing SQL queries.

Constructor Details

JKWebControllerWithSqlDataAccess

public JKWebControllerWithSqlDataAccess()

Method Details

execute

protected void execute(String query,
 Object... params)

This method executes an SQL query with the given parameters using the SQL data access service.

Parameters:

query - Specifies the SQL query to execute.

params - Specifies the parameters to bind to the query.

getSqlDataAccess

public JKDataAccessService getSqlDataAccess()

This method gets the SQL data access service used for executing SQL queries.

Returns:

the SQL data access service.