fork download
copy 
  1.  
  2. import java.sql.*;
  3.  
  4. class mssql {
  5.  
  6. public static void main(String[] args) {
  7.  
  8.  
  9. String conUrl = "jdbc:sqlserver://localhost:1433;databaseName=testdb;user=sa;password=123456;"; 
  10.  
  11. Connection con = null;
  12.  
  13. try {
  14.  
  15.  
  16. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  17.  
  18. con = DriverManager.getConnection(conUrl);
  19.  
  20.  
  21. String SQL = "SELECT Top 10 * FROM movie_data";
  22.  
  23. Statement stmt = con.createStatement();
  24.  
  25. ResultSet rs = stmt.executeQuery(SQL);
  26.  
  27.  
  28.  
  29. while (rs.next()) {
  30.  
  31. System.out.println(rs.getString("name") + ", " + rs.getString("Source"));
  32.  
  33. }
  34.  
  35. rs.close();
  36.  
  37. stmt.close();
  38.  
  39. }
  40.  
  41. catch (Exception ex) {
  42.  
  43. ex.printStackTrace();
  44.  
  45. }
  46.  
  47. }
  48.  
  49. }
Success #stdin #stdout #stderr 0.07s 380160KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
	at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
	at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:190)
	at mssql.main(Main.java:16)
https://ideone.com/mbiiqx
language:
Java (HotSpot 12)
created:
12 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!