Guest User

Untitled

a guest
Jan 10th, 2018
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.46 KB | None | 0 0
  1. public class DatabaseTest {
  2.  
  3. public static void main(String[] args) {
  4. createNewDatabase("home/saturn/Рабочий стол/test.db");
  5. }
  6.  
  7. private static void createNewDatabase(String path) {
  8. String url = "jdbc:mysql:" + path;
  9. try {
  10. Class.forName("com.mysql.jdbc.Driver");
  11. } catch (ClassNotFoundException e) {
  12. System.out.println("Driver not found.");
  13. }
  14. try (Connection conn = DriverManager.getConnection(url)) {
  15. if (conn != null) {
  16. DatabaseMetaData meta = conn.getMetaData();
  17. System.out.println("Driver name: " + meta.getDriverName());
  18. System.out.println("Database created by path " + path);
  19. }
  20. } catch (SQLException e) {
  21. e.printStackTrace();
  22. }
  23. }
  24. }
  25.  
  26. java.sql.SQLException: No suitable driver found for jdbc:mysql:home/saturn/Рабочий стол/test.db
  27. at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:703)
  28. at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:252)
  29. at ru.skyscrapers.server.DatabaseTest.createNewDatabase(DatabaseTest.java:21)
  30. at ru.skyscrapers.server.DatabaseTest.main(DatabaseTest.java:11)
  31.  
  32. Process finished with exit code 0
  33.  
  34. <dependency>
  35. <groupId>mysql</groupId>
  36. <artifactId>mysql-connector-java</artifactId>
  37. <version>5.1.38</version>
  38. </dependency>
  39.  
  40. jdbc:mysql://localhost:3306/test?user=myuser&password=mypassword
Add Comment
Please, Sign In to add comment