Programmiererforum

Code: Select all

private String dbURL;
private String dbUsername = "root";
private String dbPassword = "root1234";
private String URL = "localhost";
private String port = "3306";
private String dbName = "university";
private Connection con;

private void connectToDataBase() throws ClassNotFoundException, SQLException {

dbURL = "jdbc:mysql://" + URL + ":" + port + "/" + dbName + "?verifyServerCertificate=false";
Properties p = new Properties();
p.setProperty("user", dbUsername);
p.setProperty("password", dbPassword);
p.setProperty("useSSL", "false");
p.setProperty("autoReconnect", "true");
Class.forName("com.mysql.cj.jdbc.Driver");

con = DriverManager.getConnection(dbURL, p);