Guest User

Untitled

a guest
May 28th, 2018
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.19 KB | None | 0 0
  1. java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
  2. at java.net.URLClassLoader.findClass(Unknown Source)
  3. at java.lang.ClassLoader.loadClass(Unknown Source)
  4. at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
  5. at java.lang.ClassLoader.loadClass(Unknown Source)
  6. at java.lang.Class.forName0(Native Method)
  7. at java.lang.Class.forName(Unknown Source)
  8. at Main.main(Main.java:13)
  9.  
  10. import java.sql.*;
  11.  
  12. public static void main(String args[]) throws SQLException {
  13.  
  14. String host = "jdbc:mysql://localhost:3306/lorann?autoReconnect=true&useSSL=false&useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC";
  15. String uName = "root";
  16. String uPass= "";
  17.  
  18. try {
  19. Class.forName("com.mysql.cj.jdbc.Driver");
  20. } catch (ClassNotFoundException e) {
  21. e.printStackTrace();
  22. }
  23.  
  24. Connection co = DriverManager.getConnection(host,uName,uPass);
  25. Statement stmt = co.createStatement();
  26.  
  27.  
  28. ResultSet rs = stmt.executeQuery("SELECT contenu FROM niveau");
  29. @SuppressWarnings("unused")
  30. ResultSetMetaData rsm = rs.getMetaData();
  31.  
  32.  
  33.  
  34. while(rs.next()) {
  35. System.out.println(rs.getString("contenu"));
  36. }
  37.  
  38. }}
Add Comment
Please, Sign In to add comment