Advertisement
Guest User

Databases

a guest
Jun 2nd, 2016
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. import java.sql.*;
  2.  
  3.  
  4.  
  5. public class main {
  6.  
  7. public static void main(String[] args) {
  8.  
  9. try
  10. {
  11. String myDriver = "org.gjt.mm.mysql.Driver";
  12. String myUrl = "jdbc:mysql://ipdelserver/rank";
  13. Class.forName(myDriver);
  14. Connection conn = DriverManager.getConnection(myUrl, "Username", "password");
  15.  
  16.  
  17. String query = "SELECT * FROM Tabella";
  18.  
  19.  
  20. Statement st = conn.createStatement();
  21.  
  22. ResultSet rs = st.executeQuery(query);
  23.  
  24. while (rs.next())
  25. {
  26. int id = rs.getInt("id");
  27. String str1= rs.getString("str1");
  28. String str2= rs.getString("str2");
  29.  
  30. System.out.format("%s, %s, %s, %s, %s, %s\n", id, str1, str2);
  31. }
  32. st.close();
  33. }
  34. catch (Exception e)
  35. {
  36. System.err.println(e.getMessage());
  37. }
  38. }
  39.  
  40.  
  41.  
  42. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement