com.edu.ufps.maregroups.util.Pool.java Source code

Introduction

Here is the source code for com.edu.ufps.maregroups.util.Pool.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

package com.edu.ufps.maregroups.util;

import java.sql.Connection;
import java.sql.SQLException;
import javax.sql.DataSource;
import org.apache.commons.dbcp2.BasicDataSource;

public class Pool {

    private static DataSource datasource;
    private static final String DB_URL = "jDBc:mysql://sandbox2.ufps.edu.co/fitek";
    private static final String DB_DRIVER = "com.mysql.jdbc.Driver";
    //private static final String DB_DRIVER = "org.gjt.mm.mysql.Driver";
    private static final String DB_USUARIO = "fitek";
    private static final String DB_CONTRASENA = "fitekuis2016";

    public Pool() {
    }

    private static void inicializarDataSource() {
        BasicDataSource dsBasico = new BasicDataSource();
        dsBasico.setDriverClassName(DB_DRIVER);
        dsBasico.setUsername(DB_USUARIO);
        dsBasico.setPassword(DB_CONTRASENA);
        dsBasico.setUrl(DB_URL);
        dsBasico.setMaxTotal(100);
        datasource = dsBasico;
    }

    public static Connection getConnection() throws SQLException {
        if (datasource == null) {
            inicializarDataSource();
        }
        return datasource.getConnection();
    }
}