Advertisement
Guest User

Untitled

a guest
Jun 20th, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. /**
  2. Get server version.
  3. */
  4.  
  5. import java.sql.*;
  6. import java.sql.DatabaseMetaData;
  7. import java.sql.ResultSet;
  8. import java.sql.DriverManager;
  9. import java.sql.SQLException;
  10. import java.util.*;
  11.  
  12. public class Version {
  13.  
  14. public static void main (String args[]) {
  15. Version obj = new Version();
  16. obj.getVersion();
  17. }
  18.  
  19. public void getVersion() {
  20. /* it is important to place the code below under 'try' */
  21. try {
  22. Class.forName("com.mysql.jdbc.Driver").newInstance();
  23. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:13000/test","root","");
  24. Statement st = con.createStatement();
  25. ResultSet rs = st.executeQuery("SELECT VERSION()");
  26.  
  27. while(rs.next())
  28. {
  29. System.out.println(rs.getString(1));
  30. }
  31. } catch(Exception e) { System.out.println(e); }
  32. } //end of getVersion()
  33. } //end of Version Class
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement