Advertisement
Guest User

Untitled

a guest
Aug 14th, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.28 KB | None | 0 0
  1. import java.sql.*;
  2.  
  3. private static final String url = "jdbc:mysql://localhost/learn";
  4.  
  5. private static final String user = "root";
  6.  
  7. private static final String password = "B!SHu12345";
  8.  
  9. public static void main(String args[]) {
  10. try {
  11. Class.forName("com.mysql.jdbc.Driver");
  12. Connection con = DriverManager.getConnection(url, user, password);
  13. Statement st=con.createStatement();
  14. ResultSet rs=st.executeQuery("select * from bishu where id =101");
  15. while(rs.next()){
  16. String s=rs.getString("id");
  17. System.out.println(s);
  18. }
  19. System.out.println("Success");
  20.  
  21. } catch (Exception e) {
  22. e.printStackTrace();
  23. System.out.println(e.getMessage());
  24. }
  25. }
  26.  
  27. java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  28. at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
  29. at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
  30. at java.security.AccessController.doPrivileged(Native Method)
  31. at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
  32. at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
  33. at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
  34. at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
  35. at java.lang.Class.forName0(Native Method)
  36. at java.lang.Class.forName(Class.java:195)
  37. at JDBCTest.main(first.java:14)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement