Difference between revisions of "Connecting to a Database"
From CCIL
(Created page with " Connection to various databases goes trough ''DatabaseConnectionManager'' class. In order to use it, you should add the following dependency to your project: <pre> <dependen...") |
m |
||
| (One intermediate revision by the same user not shown) | |||
| Line 9: | Line 9: | ||
</dependency> | </dependency> | ||
</pre> | </pre> | ||
| + | |||
| + | == Usage == | ||
| + | |||
| + | <pre> | ||
| + | ... | ||
| + | Connection cnn = db.getConnection(); | ||
| + | PreparedStatement st = (PreparedStatement) cnn | ||
| + | .prepareStatement("SELECT * FROM collections WHERE context = ?"); | ||
| + | st.setString(1, name); | ||
| + | ResultSet rs = st.executeQuery(); | ||
| + | ... | ||
| + | </pre> | ||
| + | |||
| + | === Reading the connection properties from the context === | ||
| + | |||
| + | First thing, you need a reference to the ''contexts'' service. | ||
| + | |||
| + | TBA | ||
Latest revision as of 09:56, 13 June 2016
Connection to various databases goes trough DatabaseConnectionManager class. In order to use it, you should add the following dependency to your project:
<dependency>
<groupId>net.ccil</groupId>
<artifactId>ccil-common-sql</artifactId>
<version>${ccil.version}</version>
</dependency>
Usage
...
Connection cnn = db.getConnection();
PreparedStatement st = (PreparedStatement) cnn
.prepareStatement("SELECT * FROM collections WHERE context = ?");
st.setString(1, name);
ResultSet rs = st.executeQuery();
...
Reading the connection properties from the context
First thing, you need a reference to the contexts service.
TBA
