Package org.silverpeas.components.jdbcconnector.control

Class JdbcConnectorWebController

java.lang.Object

org.silverpeas.core.web.mvc.controller.AbstractComponentSessionController

org.silverpeas.core.web.mvc.webcomponent.WebComponentController<JdbcConnectorWebRequestContext>

org.silverpeas.components.jdbcconnector.control.JdbcConnectorWebController

All Implemented Interfaces:

Serializable, org.silverpeas.core.web.mvc.controller.ComponentSessionController, org.silverpeas.core.web.session.SessionCloseable

@WebComponentController("connecteurJDBC")
public class JdbcConnectorWebController
extends org.silverpeas.core.web.mvc.webcomponent.WebComponentController<JdbcConnectorWebRequestContext>

The web controller of the ConnecteurJDBC application. Like all the web controllers in Silverpeas, it is both session-scoped and spawn per application instance.

Author:

mmoquillon

See Also:

• Serialized Form

Field Summary

Fields

Modifier and Type	Field	Description
static final String	COMPARING_COLUMN
static final String	COMPARING_OPERATOR
static final String	COMPARING_OPERATORS
static final String	COMPARING_VALUE
static final String	QUERY_RESULT

Fields inherited from class org.silverpeas.core.web.mvc.controller.AbstractComponentSessionController

context

Constructor Summary

Constructors

Constructor	Description
JdbcConnectorWebController(org.silverpeas.core.web.mvc.controller.MainSessionController controller, org.silverpeas.core.web.mvc.controller.ComponentContext context)	Constructs a new Web controller for the specified context and with the MainSessionController instance that is specific to the user behind the access to the underlying application instance.

Method Summary

Modifier and Type	Method	Description
void	editConnection(JdbcConnectorWebRequestContext context)
void	editSQLRequest(JdbcConnectorWebRequestContext context)
void	home(JdbcConnectorWebRequestContext context)
protected void	onInstantiation(JdbcConnectorWebRequestContext context)
void	openRequestEditor(JdbcConnectorWebRequestContext context)
void	performSQLRequest(JdbcConnectorWebRequestContext context)
void	portlet(JdbcConnectorWebRequestContext context)
void	saveConnection(JdbcConnectorWebRequestContext context)
void	saveSQLRequest(JdbcConnectorWebRequestContext context)
void	viewResultSet(JdbcConnectorWebRequestContext context)

Methods inherited from class org.silverpeas.core.web.mvc.webcomponent.WebComponentController

beforeRequestProcessing

Methods inherited from class org.silverpeas.core.web.mvc.controller.AbstractComponentSessionController

addClipboardSelection, clipboardPasteDone, close, getClipboardErrorMessage, getClipboardExceptionError, getClipboardObjects, getClipboardSelectedObjects, getClipboardSize, getComponentAccessController, getComponentId, getComponentLabel, getComponentName, getComponentParameterValue, getComponentParameterValue, getComponentRootName, getComponentUrl, getHighestSilverpeasUserRole, getIcon, getLanguage, getLook, getMultilang, getOrganisationController, getPersonalization, getRSSUrl, getSelection, getSettings, getSilverpeasUserRoles, getSpaceId, getSpaceLabel, getString, getSubscriptionContext, getUrlEncodedParameter, getUserAccessLevel, getUserAvailComponentIds, getUserDetail, getUserDetail, getUserId, getUserManageableGroupIds, getUserManageableSpaceIds, getUserRoles, getZoneId, isAppInMaintenance, isGroupManager, isPasswordChangeAllowed, isSpaceInMaintenance, removeClipboardElement, setAppModeMaintenance, setClipboardSelectedElement, setComponentRootName, setSpaceModeMaintenance

Methods inherited from class java.lang.Object

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

Field Details

QUERY_RESULT

public static final String QUERY_RESULT

See Also:

• Constant Field Values

COMPARING_COLUMN

public static final String COMPARING_COLUMN

See Also:

• Constant Field Values

COMPARING_OPERATOR

public static final String COMPARING_OPERATOR

See Also:

• Constant Field Values

COMPARING_VALUE

public static final String COMPARING_VALUE

See Also:

• Constant Field Values

COMPARING_OPERATORS

public static final String COMPARING_OPERATORS

See Also:

• Constant Field Values

Constructor Details

JdbcConnectorWebController

public JdbcConnectorWebController(org.silverpeas.core.web.mvc.controller.MainSessionController controller,
 org.silverpeas.core.web.mvc.controller.ComponentContext context)

Constructs a new Web controller for the specified context and with the MainSessionController instance that is specific to the user behind the access to the underlying application instance.

Parameters:

controller - the main session controller for the current user.

context - the context identifying among others the targeted application instance.

Method Details

onInstantiation

protected void onInstantiation(JdbcConnectorWebRequestContext context)

Specified by:

onInstantiation in class org.silverpeas.core.web.mvc.webcomponent.WebComponentController<JdbcConnectorWebRequestContext>

home

@GET
@Path("Main")
@Homepage
@RedirectToInternalJsp("jdbcConnector.jsp")
@LowestRoleAccess(READER)
public void home(JdbcConnectorWebRequestContext context)

viewResultSet

@GET
@Path("ViewResultSet")
@RedirectToInternalJsp("jdbcConnector.jsp")
@LowestRoleAccess(READER)
public void viewResultSet(JdbcConnectorWebRequestContext context)

portlet

@GET
@Path("portlet")
@RedirectToInternalJsp("portlet.jsp")
@LowestRoleAccess(READER)
public void portlet(JdbcConnectorWebRequestContext context)

editSQLRequest

@GET
@Path("ParameterRequest")
@RedirectToInternalJsp("requestParameters.jsp")
@LowestRoleAccess(value=PUBLISHER,
                  onError=@RedirectTo("Main"))
public void editSQLRequest(JdbcConnectorWebRequestContext context)

performSQLRequest

@POST
@Path("DoRequest")
@RedirectToInternalJsp("jdbcConnector.jsp")
@LowestRoleAccess(READER)
public void performSQLRequest(JdbcConnectorWebRequestContext context)

editConnection

@GET
@Path("ParameterConnection")
@RedirectToInternalJsp("connectionParameters.jsp")
@LowestRoleAccess(value=ADMIN,
                  onError=@RedirectTo("Main"))
public void editConnection(JdbcConnectorWebRequestContext context)

saveConnection

@POST
@Path("UpdateConnection")
@RedirectToInternal("{nextView}")
@LowestRoleAccess(value=PUBLISHER,
                  onError=@RedirectTo("Main"))
public void saveConnection(JdbcConnectorWebRequestContext context)

saveSQLRequest

@POST
@Path("SetSQLRequest")
@RedirectToInternal("{nextView}")
@LowestRoleAccess(value=PUBLISHER,
                  onError=@RedirectTo("Main"))
public void saveSQLRequest(JdbcConnectorWebRequestContext context)

openRequestEditor

@GET
@Path("RequestEditor")
@RedirectToInternalJsp("requestEditor.jsp")
@LowestRoleAccess(value=PUBLISHER,
                  onError=@RedirectTo("Main"))
public void openRequestEditor(JdbcConnectorWebRequestContext context)