Guest User

Untitled

a guest
Jun 18th, 2018
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. String driver = "org.gjt.mm.mysql.Driver";
  2.  
  3. String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
  4.  
  5. String url="jdbc:mysql://localhost/books?user=<user>&password=<password>";
  6.  
  7. String url = "jdbc:microsoft:sqlserver://<server_name>:<1433>"
  8.  
  9. con=DriverManager.getConnection(url);
  10.  
  11. con=DriverManager.getConnection(url, usr, pwd );
  12.  
  13. try{
  14. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  15. Connection conn = DriverManager.getConnection("jdbc:sqlserver://ipaddress:port;databaseName=schema_name","user","pass");
  16.  
  17. PreparedStatement pps = conn.prepareStatement("SELECT * FROM table");
  18. ResultSet rs = pps.executeQuery();
  19. while(rs.next()){
  20. //do something
  21. System.out.println(rs.getString("some col"));
  22. }
  23. //close connection
  24. conn.close();
  25. }catch(Exception ex){
  26. // do something
  27. }
Add Comment
Please, Sign In to add comment