import com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource;
import java.sql.Connection;
import java.sql.SQLException;
import javax.sql.DataSource;
import javax.swing.JOptionPane;

class ManejadorConexiones {
	public static ManejadorConexiones Conexion = null;
	public DataSource ds;
	public Connection con;
	private String pass;
	public ManejadorConexiones(){
		pass = null;
		ds = null;
	}
    public DataSource CrearConexion() {
    try{
            MysqlConnectionPoolDataSource dso = new MysqlConnectionPoolDataSource();
            String stDatabaseName = "musica";
            String stPort = "3306";
            String userName = "root";
            if(pass == null){
            	pass = "troLOL93";
            }
            String password = pass;
            String stHost = "localhost";
            dso.setDatabaseName(stDatabaseName);
            dso.setPort(Integer.parseInt(stPort));
            dso.setUser(userName);
            dso.setPassword(password);
            dso.setServerName(stHost);
            ds = dso;
        }
        catch(Exception e){}
		return ds;
	}

  	public static ManejadorConexiones getInstance(){
        if(Conexion == null){
            Conexion = new ManejadorConexiones();
        }
        return Conexion;
    }

    public Connection getConn() throws SQLException {
        return ds.getConnection();
    }

    public DataSource getDataSource(){
        return ds;
    }
}