Минимально необходимый код для соединения с сервером MySQL, запущенном на локальном компьютере к БД bitrix_20150812 с логином/паролем root/root:
try { Class.forName("com.mysql.jdbc.Driver"); Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:8889/bitrix_20150815", "root", "root"); connection.close(); } catch (Exception e) { e.printStackTrace(); }
Полный пример с перехватом всех исключений:
package ru.mydesignstudio.mds01; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class Main { private final String driverName = "com.mysql.jdbc.Driver"; private final String connectionString = "jdbc:mysql://localhost:8889/bitrix_20150815"; private final String login = "root"; private final String password = "root"; public void run() { try { Class.forName(driverName); } catch (ClassNotFoundException e) { System.out.println("Can't get class. No driver found"); e.printStackTrace(); return; } Connection connection = null; try { connection = DriverManager.getConnection(connectionString, login, password); } catch (SQLException e) { System.out.println("Can't get connection. Incorrect URL"); e.printStackTrace(); return; } try { connection.close(); } catch (SQLException e) { System.out.println("Can't close connection"); e.printStackTrace(); return; } } public static void main(String[] args) { Main app = new Main(); app.run(); } }
Драйвер для MySQL можно получить через Apache Maven. pom.xml приведен ниже:
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>examples</groupId> <artifactId>mds01</artifactId> <version>1.0-SNAPSHOT</version> <dependencies> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.38</version> </dependency> </dependencies> </project>