Advertisement
Guest User

Untitled

a guest
Mar 25th, 2016
2,705
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.75 KB | None | 0 0
  1. Exception in thread "main" java.lang.ClassNotFoundException:
  2. com.microsoft.sqlserver.jdbc.SqlServerDriver
  3. at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
  4. at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
  5. at java.security.AccessController.doPrivileged(Native Method)
  6. at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
  7. at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
  8. at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
  9. at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
  10. at java.lang.Class.forName0(Native Method)
  11. at java.lang.Class.forName(Class.java:190)
  12. at javaapplication1.JavaApplication1.main(JavaApplication1.java:30)
  13.  
  14. public static void main(String[] args) throws ClassNotFoundException, SQLException {
  15. String url = "jdbc:sqlserver://.\SQLEXPRESS;databaseName=Northwind; Integrated Security = SSPI ";
  16.  
  17. Connection con = null;
  18. Statement stmt = null;
  19.  
  20. ResultSet rs = null;
  21. try {
  22. Class.forName("com.microsoft.sqlserver.jdbc.SqlServerDriver");
  23.  
  24. con = DriverManager.getConnection(url);
  25. String sql = "Select Top 3 from * person.Contact";
  26. stmt = con.createStatement();
  27. rs = stmt.executeQuery(sql);
  28. while (rs.next()) {
  29. System.out.println(rs.getString(1));
  30. }
  31. } catch (Exception e) {
  32. e.printStackTrace();
  33. }
  34. }
  35.  
  36. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  37.  
  38. String url = "jdbc:sqlserver://YOUR PC NAME;instanceName=SQLEXPRESS;DatabaseName=dbname;integratedSecurity=true";
  39.  
  40. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  41. Connection myCon = DriverManager.getConnection(url);
  42.  
  43. Statement myStmt = myCon.createStatement();
  44. ResultSet myRs = myStmt.executeQuery("select * from table name");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement