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/Concepts/Sql Service"
Dev.jmini.fr (Talk | contribs) (New page: {{ScoutPage|cat=Concepts}} The SqlService provides access to a database. * implements {{ScoutJavadoc|ISqlService|I}} * extends {{ScoutJavadoc|AbstractSqlService|C}} ==Description== {{No...) |
m (Category changed) |
||
Line 1: | Line 1: | ||
− | {{ScoutPage|cat= | + | {{ScoutPage|cat=Server}} |
The SqlService provides access to a database. | The SqlService provides access to a database. |
Revision as of 12:14, 3 November 2011
The Scout documentation has been moved to https://eclipsescout.github.io/.
The SqlService provides access to a database.
- implements The Scout documentation has been moved to https://eclipsescout.github.io/.
- extends The Scout documentation has been moved to https://eclipsescout.github.io/.
Description
Minimal configuration
To be able to connect to a database, these properties needs to be configured:
- The Scout documentation has been moved to https://eclipsescout.github.io/. the qualified name of the JDBC driver.
- The Scout documentation has been moved to https://eclipsescout.github.io/. the JDBC path
"jdbc:..."
. - The Scout documentation has been moved to https://eclipsescout.github.io/. the user name to connect to the database.
- The Scout documentation has been moved to https://eclipsescout.github.io/. the password to connect to the database.
- The Scout documentation has been moved to https://eclipsescout.github.io/. provides the class of the The Scout documentation has been moved to https://eclipsescout.github.io/. that should be used.
SQL convenience class
Scout proposes a convenience singleton class to access the default SqlService: The Scout documentation has been moved to https://eclipsescout.github.io/.
Here a simple example:
SQL.update( " update actor " + " set first_name = :firstName," + " last_name = :lastName " + " where actor_id = :id ", formData );
See also
- The Scout documentation has been moved to https://eclipsescout.github.io/.
- The Scout documentation has been moved to https://eclipsescout.github.io/.
- The Scout documentation has been moved to https://eclipsescout.github.io/.