Connecting to a Database

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();