Connecting to a Database

From CCIL
Revision as of 09:56, 13 June 2016 by Admin (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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