org.itsallcode.jdbc.ConnectionFactory Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of simple-jdbc Show documentation

Library to simplify using JDBC

There is a newer version: 0.7.1

package org.itsallcode.jdbc;

import java.sql.*;
import java.util.Properties;

/**
 * This class connects to a database and returns new {@link SimpleConnection}s.
 */
public class ConnectionFactory {
    private final Context context;
    private final DbDialectFactory dialectFactory;

    private ConnectionFactory(final Context context, final DbDialectFactory dialectFactory) {
        this.context = context;
        this.dialectFactory = dialectFactory;
    }

    /**
     * Create a new connection factory.
     * 
     * @return a new instance
     */
    public static ConnectionFactory create() {
        return create(Context.builder().build());
    }

    /**
     * Create a new connection factory with a custom context.
     * 
     * @param context a custom context
     * @return a new instance
     */
    public static ConnectionFactory create(final Context context) {
        return new ConnectionFactory(context, new DbDialectFactory());
    }

    /**
     * Create a connection using the given JDBC URL.
     * 
     * @param url JDBC URL
     * @return a new connection
     */
    public SimpleConnection create(final String url) {
        return create(url, new Properties());
    }

    /**
     * Create a connection using the given JDBC URL.
     * 
     * @param url      JDBC URL
     * @param user     database user
     * @param password database password
     * @return a new connection
     */
    public SimpleConnection create(final String url, final String user, final String password) {
        final Properties info = new Properties();
        info.put("user", user);
        info.put("password", password);
        return create(url, info);
    }

    /**
     * Create a connection using the given JDBC URL.
     * 
     * @param url  JDBC URL
     * @param info connection properties
     * @return a new connection
     */
    public SimpleConnection create(final String url, final Properties info) {
        return new SimpleConnection(createConnection(url, info), context, dialectFactory.createDialect(url));
    }

    private Connection createConnection(final String url, final Properties info) {
        try {
            return DriverManager.getConnection(url, info);
        } catch (final SQLException e) {
            throw new UncheckedSQLException("Error connecting to '" + url + "'", e);
        }
    }
}