hsqldbconnection.java

Spring framework basic tutorial using Java

package tutorial.model;

import java.sql.Connection;

import org.hsqldb.jdbc.jdbcDataSource;

public class HSQLDBConnection implements DBConnection {

	@Override
	public Connection getConnection() {
		// Exceptions may occur
		try {

			// get a DataSource object and set the URL
			// 'testfiles' in the URL is the name of the database
			jdbcDataSource dataSource = new jdbcDataSource();

			dataSource.setDatabase("jdbc:hsqldb:file:testfiles");

			// Connect to the database
			// It will be create automatically if it does not yet exist
			// "sa" is the user name and "" is the (empty) password
			Connection conn = dataSource.getConnection("SA", "");			
			return conn;
		} catch (Exception e) {

			// Print out the error message
			System.out.println(e);
			e.printStackTrace();
		}
		return null;

	}

}