edu.secprog.db.DBPool.java Source code

Introduction

Here is the source code for edu.secprog.db.DBPool.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 edu.secprog.db;

/**
 *
 * @author Mark Christian Sanchez
 */
import java.sql.Connection;
import java.sql.SQLException;

import org.apache.commons.dbcp2.BasicDataSource;

public class DBPool {

    private static DBPool singleton;
    private BasicDataSource dataSource;
    private static String username = "test";
    private static String password = "1234";
    private static String url = "jdbc:mysql://localhost:3306/foobar_booksop";

    private DBPool() {
        dataSource = new BasicDataSource();
        dataSource.setDriverClassName("com.mysql.jdbc.Driver");
        dataSource.setUsername(username);
        dataSource.setPassword(password);
        dataSource.setUrl(url);
    }

    public static DBPool getInstance() {
        if (singleton == null) {
            singleton = new DBPool();
        }
        return singleton;
    }

    public Connection getConnection() {
        try {
            return dataSource.getConnection();

        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return null;
    }
}