Trace:
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Next revision Both sides next revision | ||
|
jvx:reference [2020/06/15 09:50] cduncan [Anatomy of a remote JVx application] |
jvx:reference [2020/06/15 09:52] cduncan [DBAccess, accessing a database] |
||
|---|---|---|---|
| Line 831: | Line 831: | ||
| What you are seeing here is a rough sketch of how the architecture of [[https://sourceforge.net/projects/jvx/|JVx]] looks like. Let’s walk through the image step by step. We will look at each successive layer and work our way from the database on the server to the data book on the client. | What you are seeing here is a rough sketch of how the architecture of [[https://sourceforge.net/projects/jvx/|JVx]] looks like. Let’s walk through the image step by step. We will look at each successive layer and work our way from the database on the server to the data book on the client. | ||
| - | ==== DBAccess, accessing a database ==== | + | ==== DBAccess, Accessing a Database ==== |
| Accessing a database is easy when using ''%%DBAccess%%''. All we must do is to set the [[https://en.wikipedia.org/wiki/Java_Database_Connectivity|JDBC]] URL of the server and connect to it: | Accessing a database is easy when using ''%%DBAccess%%''. All we must do is to set the [[https://en.wikipedia.org/wiki/Java_Database_Connectivity|JDBC]] URL of the server and connect to it: | ||
| Line 842: | Line 842: | ||
| dbAccess.open(); | dbAccess.open(); | ||
| </code> | </code> | ||
| - | As a note, the instance returned by ''%%getDBAccess(...)%%'' is the database specific ''%%DBAccess%%'' extension, which does know how to handle its database. | + | As a note, the instance returned by ''%%getDBAccess(...)%%'' is the database-specific ''%%DBAccess%%'' extension, which knows how to handle its database. |
| - | We can of course use ''%%DBAccess%%'' to directly access the database: | + | We can, of course, use ''%%DBAccess%%'' to directly access the database: |
| <code java> | <code java> | ||
| Line 853: | Line 853: | ||
| List<Bean> data = dbAccess.executeQuery("select * from SOME_TABLE"); | List<Bean> data = dbAccess.executeQuery("select * from SOME_TABLE"); | ||
| </code> | </code> | ||
| - | …or manipulate the database, or query information about the database or execute procedures or do anything else. | + | …or manipulate the database, query information about the database, execute procedures, or anything else! |
| ==== DBStorage, preparing the database access for databooks ==== | ==== DBStorage, preparing the database access for databooks ==== | ||