org.darkphoenixs.pool.jdbc.JdbcConnectionFactory Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of connectionpool-client Show documentation
A simple multi-purpose connection pool client (Kafka & Hbase & Redis & RMDB & Socket & Http)
The newest version!
/*
 * Copyright 2015-2016 Dark Phoenixs (Open-Source Organization).
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package org.darkphoenixs.pool.jdbc;

import org.apache.commons.pool2.PooledObject;
import org.apache.commons.pool2.impl.DefaultPooledObject;
import org.darkphoenixs.pool.ConnectionException;
import org.darkphoenixs.pool.ConnectionFactory;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

/**
 * Title: JdbcConnectionFactory
 * Description: JDBC连接工厂
 *
 * @author Victor.Zxy
 * @version 1.0
 * @see ConnectionFactory
 * @since 2015年11月17日
 */
class JdbcConnectionFactory implements ConnectionFactory {

    /**
     * serialVersionUID
     */
    private static final long serialVersionUID = 4941500146671191616L;

    /**
     * driverClass
     */
    private final String driverClass;

    /**
     * jdbcUrl
     */
    private final String jdbcUrl;

    /**
     * username
     */
    private final String username;

    /**
     * password
     */
    private final String password;

    /**
     * Title: JdbcConnectionFactory
     * Description: 构造方法
     *
     * @param properties JDBC参数
     */
    public JdbcConnectionFactory(final Properties properties) {

        this.driverClass = properties.getProperty(JdbcConfig.DRIVER_CLASS_PROPERTY);
        if (driverClass == null)
            throw new ConnectionException("[" + JdbcConfig.DRIVER_CLASS_PROPERTY + "] is required !");

        this.jdbcUrl = properties.getProperty(JdbcConfig.JDBC_URL_PROPERTY);
        if (jdbcUrl == null)
            throw new ConnectionException("[" + JdbcConfig.JDBC_URL_PROPERTY + "] is required !");

        this.username = properties.getProperty(JdbcConfig.JDBC_USERNAME_PROPERTY);
        if (username == null)
            throw new ConnectionException("[" + JdbcConfig.JDBC_USERNAME_PROPERTY + "] is required !");

        this.password = properties.getProperty(JdbcConfig.JDBC_PASSWORD_PROPERTY);
        if (password == null)
            throw new ConnectionException("[" + JdbcConfig.JDBC_PASSWORD_PROPERTY + "] is required !");

        this.loadDriver();
    }

    /**
     * Title: JdbcConnectionFactory
     * Description: 构造方法
     *
     * @param driverClass 驱动类
     * @param jdbcUrl     数据库URL
     * @param username    数据库用户名
     * @param password    数据密码
     */
    public JdbcConnectionFactory(final String driverClass, final String jdbcUrl, final String username, final String password) {

        this.driverClass = driverClass;
        this.jdbcUrl = jdbcUrl;
        this.username = username;
        this.password = password;
        this.loadDriver();
    }

    /**
     * Title: loadDriver
     * Description: 加载驱动
     */
    private void loadDriver() {

        try {
            Class.forName(driverClass);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }

    }

    @Override
    public PooledObject makeObject() throws Exception {

        Connection connection = this.createConnection();

        return new DefaultPooledObject(connection);
    }

    @Override
    public void destroyObject(PooledObject p) throws Exception {

        Connection connection = p.getObject();

        if (connection != null)

            connection.close();
    }

    @Override
    public boolean validateObject(PooledObject p) {

        Connection connection = p.getObject();

        if (connection != null)
            try {
                return ((!connection.isClosed()) && (connection.isValid(1)));
            } catch (SQLException e) {
                e.printStackTrace();
            }

        return false;
    }

    @Override
    public void activateObject(PooledObject p) throws Exception {
        // TODO Auto-generated method stub

    }

    @Override
    public void passivateObject(PooledObject p) throws Exception {
        // TODO Auto-generated method stub

    }

    @Override
    public Connection createConnection() throws Exception {

        Connection connection = DriverManager.getConnection(jdbcUrl, username, password);

        return connection;
    }

}