cn.edu.seu.cose.jellyjolly.model.dao.jdbc.mysql.MysqlConnectionFactory.java Source code

Introduction

Here is the source code for cn.edu.seu.cose.jellyjolly.model.dao.jdbc.mysql.MysqlConnectionFactory.java

Source

/*
 * Copyright (C) 2012 Colleage of Software Engineering, Southeast University
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */
package cn.edu.seu.cose.jellyjolly.model.dao.jdbc.mysql;

import cn.edu.seu.cose.jellyjolly.model.dao.jdbc.ConnectionFactory;
import cn.edu.seu.cose.jellyjolly.model.dao.jdbc.JdbcDataAccessException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.sql.DataSource;
import org.apache.commons.dbcp.BasicDataSource;

/**
 *
 * @author rAy <predator.ray@gmail.com>
 */
public class MysqlConnectionFactory implements ConnectionFactory {

    private DataSource dataSource;

    public MysqlConnectionFactory() {
        try {
            initDataSource();
        } catch (IOException ex) {
            Logger.getLogger(MysqlConnectionFactory.class.getName()).log(Level.SEVERE, ex.getMessage(), ex);
        }
    }

    private void initDataSource() throws IOException {
        BasicDataSource ds = new BasicDataSource();
        Properties cfgpp = new Properties();
        cfgpp.load(MysqlConnectionFactory.class.getResourceAsStream("dbcp.jdbc.properties"));
        ds.setDriverClassName(cfgpp.getProperty("jdbc.driverClassName"));
        ds.setUrl(cfgpp.getProperty("jdbc.url"));
        ds.setUsername(cfgpp.getProperty("jdbc.username"));
        ds.setPassword(cfgpp.getProperty("jdbc.password"));

        dataSource = ds;
    }

    @Override
    public Connection newConnection() throws JdbcDataAccessException {
        try {
            return dataSource.getConnection();
        } catch (SQLException ex) {
            throw new JdbcDataAccessException(ex);
        }
    }

    @Override
    public void closeConnection(Connection connection) throws JdbcDataAccessException {
        try {
            if (connection != null && !connection.isClosed()) {
                connection.close();
            }
        } catch (SQLException ex) {
            throw new JdbcDataAccessException(ex);
        }
    }

    @Override
    public void rollbackConnection(Connection connection) throws JdbcDataAccessException {
        try {
            if (connection != null) {
                connection.rollback();
            }
        } catch (SQLException ex) {
            throw new JdbcDataAccessException(ex);
        }
    }
}