Examplo connection mysql java

ConexaoMysql.java

package br.com.biblioteca.conn;
 
import java.sql.Connection;
import java.sql.DriverManager;
 
public class ConexaoMysql {
    private static String url = "jdbc:mysql://127.0.0.1/biblioteca";
    private static String user = "root";
    private static String password = "";
     
    public Connection getConnection() throws Exception{
        try {
            String driverName = "com.mysql.jdbc.Driver";   
            Class.forName(driverName);
            return DriverManager.getConnection(url, user, password);
        } catch (Exception e) {
            throw new Exception("ERRRO DE CONEXÃO!");
        }
    }
}