Java JDBC Connection Create getNewConnection()

Description

This method establishes a new connection with the database using constants above

License

Apache License

Exception

Parameter	Description
ClassNotFoundException	an exception
SQLException	an exception

Return

Connection with database

Declaration

public static Connection getNewConnection() throws ClassNotFoundException, SQLException 

Method Source Code

//package com.java2s;
/*/*from   w  ww .j av  a2s.  c  o  m*/
 * Copyright 2015 Kevin Holland.
 *
 * 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.
 */

import java.sql.Connection;
import java.sql.DriverManager;

import java.sql.SQLException;

public class Main {
    public static final String DB = "look_db";
    public static final String DB_USER = "look_admin";
    public static final String DB_PASS = "lookpass";

    /**
     * This method establishes a new connection with the database using constants above
     * @return Connection with database
     * @throws ClassNotFoundException
     * @throws SQLException
     */
    public static Connection getNewConnection() throws ClassNotFoundException, SQLException {
        Class.forName("org.mariadb.jdbc.Driver");
        return DriverManager.getConnection("jdbc:mariadb://localhost:3306/" + DB, DB_USER, DB_PASS);
    }
}

Related

1. getConnection2()
2. getConnections(String driver, String url, String user, String pwd)
3. getConnectionWithTransaction(String dbUrl, String dbUser, String dbPassword)
4. getDBConnection()
5. getJdbcOdbcConnection()
6. getPhoenixConnection()
7. getSourceConnection(final Hashtable env)
8. getStatement(Map config)
9. getTargetConnection()