Boa noite, após colocar para testar a conexão do programa com o DB, me deparo com um problema, não consigo me conectar ao meu banco de dados.
CODE abaixo:
package connection;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.PreparedStatement;
/**
*
-
@author hyago
*/
public class ConnectionFactory {private static final String DRIVER = “com.mysql.jdbc.Driver”;
private static final String URL = “jdbc:mysql://localhost:3306/gerenciadocampeonato”;
private static final String USER = “root”;
private static final String PASS = “”;public static Connection getConnection(){
try { Class.forName(DRIVER); return DriverManager.getConnection(URL, USER, PASS); } catch (ClassNotFoundException | SQLException ex) { throw new RuntimeException("Erro na conexão", ex); }
}
public static void closeConnection(Connection con){if(con != null){ try { con.close(); } catch (SQLException ex) { System.err.println(" Erro: "+ ex); } }
}
public static void closeConnection(Connection con, PreparedStatement stmt){
if(stmt != null){ try { stmt.close(); } catch (SQLException ex) { System.err.println(" Erro: "+ ex); } } closeConnection(con);
}
public static void closeConnection(Connection con, PreparedStatement stmt, ResultSet rs){if(rs != null){ try { rs.close(); } catch (SQLException ex) { System.err.println(" Erro: "+ ex); } } closeConnection(con, stmt);
}
}