Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "Scout/Tutorial/3.8/webservices/Create WsLogTablePage"
m (add ScoutPage) |
|||
(9 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | + | {{ScoutPage|cat=Tutorial 3.8}} | |
+ | |||
== Create WS Log Table Page == | == Create WS Log Table Page == | ||
− | On the client node, go to 'Desktop' | 'Outlines' | ' | + | On the client node, go to 'Desktop' | 'Outlines' | 'StandardOutline'. Right click on the node ''Child Pages'' to create a new {{ScoutLink|Concepts|TablePage}} [http://wiki.eclipse.org/Image:Org.eclipse.scout.tutorial.jaxws.CreateWsLogTablePage_1.png]. As page layout, choose <code>AbstractPageWithTable</code> [http://wiki.eclipse.org/Image:Org.eclipse.scout.tutorial.jaxws.CreateWsLogTablePage_2.png] to create a page representing tabular data. On the next step, enter <code>WS Log</code> as name for that page and choose to add this page to the <code>MainOutline</code> (might be StandardOutline) [http://wiki.eclipse.org/Image:Org.eclipse.scout.tutorial.jaxws.CreateWsLogTablePage_3.png]. By clicking Finish, the page is created and attached to the MainOutline. |
== Create columns == | == Create columns == | ||
− | On the <code>WsLogTablePage</code> node, go to 'Table' | 'Columns'. Right click on the node to create a new {{ScoutLink|Concepts|Column}} [http://wiki.eclipse.org/Image:Org.eclipse.scout.tutorial.jaxws.CreateWsLogTablePage_4.png]. Please add the following | + | On the <code>WsLogTablePage</code> node, go to 'Table' | 'Columns'. Right click on the node to create a new {{ScoutLink|Concepts|Column}} [http://wiki.eclipse.org/Image:Org.eclipse.scout.tutorial.jaxws.CreateWsLogTablePage_4.png]. Please add the following five columns to that table: |
'''WsLogNrColumn''' | '''WsLogNrColumn''' | ||
Line 37: | Line 38: | ||
== Create service to load WS Log data from database == | == Create service to load WS Log data from database == | ||
Finally, we have to populate the table with WS Log data. | Finally, we have to populate the table with WS Log data. | ||
− | For that purpose, go to the server node and double click on 'Outline Services' | ' | + | For that purpose, go to the server node and double click on 'Outline Services' | 'StandardOutlineService' to open the corresponding Java class. In there, create the operation <code>getWsLogTableData</code> to load WS log data from database. Also add the operation signature to the service interface <code>IStandardOutlineService</code> to be accessible from client side. |
<source lang="java"> | <source lang="java"> | ||
Line 59: | Line 60: | ||
@Override | @Override | ||
protected Object[][] execLoadTableData(SearchFilter filter) throws ProcessingException { | protected Object[][] execLoadTableData(SearchFilter filter) throws ProcessingException { | ||
− | return SERVICES.getService( | + | return SERVICES.getService(IStandardOutlineService.class).getWsLogTableData(); |
} | } | ||
</source> | </source> | ||
Line 67: | Line 68: | ||
[[Image:org.eclipse.scout.tutorial.jaxws.CreateWsLogTablePage_3.png|thumb|Give Page a name and link it with MainOutline]] | [[Image:org.eclipse.scout.tutorial.jaxws.CreateWsLogTablePage_3.png|thumb|Give Page a name and link it with MainOutline]] | ||
[[Image:org.eclipse.scout.tutorial.jaxws.CreateWsLogTablePage_4.png|thumb|Create column]] | [[Image:org.eclipse.scout.tutorial.jaxws.CreateWsLogTablePage_4.png|thumb|Create column]] | ||
− | |||
− |
Latest revision as of 02:57, 17 October 2012
The Scout documentation has been moved to https://eclipsescout.github.io/.
Contents
Create WS Log Table Page
On the client node, go to 'Desktop' | 'Outlines' | 'StandardOutline'. Right click on the node Child Pages to create a new The Scout documentation has been moved to https://eclipsescout.github.io/. [1]. As page layout, choose AbstractPageWithTable
[2] to create a page representing tabular data. On the next step, enter WS Log
as name for that page and choose to add this page to the MainOutline
(might be StandardOutline) [3]. By clicking Finish, the page is created and attached to the MainOutline.
Create columns
On the WsLogTablePage
node, go to 'Table' | 'Columns'. Right click on the node to create a new The Scout documentation has been moved to https://eclipsescout.github.io/. [4]. Please add the following five columns to that table:
WsLogNrColumn Type: Long Column Name: Do not fill because column represents primary key and therefore is hidden Class name: WsLogNrColumn
DateColumn Type: String Column Name: Date Class name: DateColumn
ServiceColumn Type: String Column Name: Service Class name: ServiceColumn
PortColumn Type: String Column Name: Port Class name: PortColumn
OperationColumn Type: String Column Name: Operation Class name: OperationColumn
To not display the WsLogNrColumn
column because of holding the primary key, go to that column in Scout SDK and uncheck Displayable
in Scout Property View.
To have the columns equally distributed over the available space of the table page, go to the The Scout documentation has been moved to https://eclipsescout.github.io/. node and check Auto Resize Columns
in Scout Property View.
Create service to load WS Log data from database
Finally, we have to populate the table with WS Log data.
For that purpose, go to the server node and double click on 'Outline Services' | 'StandardOutlineService' to open the corresponding Java class. In there, create the operation getWsLogTableData
to load WS log data from database. Also add the operation signature to the service interface IStandardOutlineService
to be accessible from client side.
@Override public Object[][] getWsLogTableData() throws ProcessingException { return SQL.select("" + "SELECT WS_LOG_NR, " + " EVT_DATE, " + " SERVICE, " + " PORT, " + " OPERATION " + "FROM WS_LOG "); }
Load WS Log data into WsLogTablePage
On client node, go to the WsLogTablePage
to consume the service's data.
On the Scout Property View, click on the operation Exec Load Table Data
to populate the WS Log table. Implement the method as follows:
@Override protected Object[][] execLoadTableData(SearchFilter filter) throws ProcessingException { return SERVICES.getService(IStandardOutlineService.class).getWsLogTableData(); }