Advertisement
Guest User

Untitled

a guest
Mar 10th, 2016
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.58 KB | None | 0 0
  1. Driver driver = new com.microsoft.sqlserver.jdbc.SQLServerDriver();
  2. DriverManager.registerDriver(driver);
  3.  
  4. String URL = "jdbc:sqlserver://192.168.0.102\\MSSQLSERVER:1433;databaseName=SsuDB";
  5. String USER = "admin";
  6. String PASS = "admin";
  7.  
  8. Connection conn = DriverManager.getConnection(URL, USER, PASS);
  9.  
  10. PreparedStatement statement = conn.prepareStatement("SELECT * FROM Book");
  11.  
  12. ResultSet rs = statement.executeQuery();
  13.  
  14. while (rs.next()) {
  15.     int id = rs.getInt("id");
  16.     String title = rs.getString("title");
  17.     System.out.println(id + "\t" + title);
  18. }
  19.  
  20. conn.close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement