Advertisement
Guest User

Untitled

a guest
Jun 4th, 2017
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. ID: 1, name: Zenon, surname: Martyniuk, group: 2
  2. ID: 2, name: Bartłomiej, surname: Misiewicz, group: 4
  3.  
  4. import java.sql.Connection;
  5. import java.sql.DriverManager;
  6. import java.sql.ResultSet;
  7. import java.sql.Statement;
  8.  
  9. public class Main {
  10.  
  11. public static void main(String[] args) {
  12. // TODO Auto-generated method stub
  13. String DB_URL = "jdbc:mysql://ricky.heliohost.org/cackoa_database";
  14. String USER = "cackoa_user";
  15. String PASS = "cackoa_password";
  16.  
  17. try(Connection conn = DriverManager.getConnection(DB_URL, USER, PASS))
  18. {
  19. Statement stmnt = conn.createStatement();
  20. String query = "SELECT * FROM student LIMIT 2";
  21. ResultSet rs = stmnt.executeQuery(query);
  22.  
  23. while(rs.next())
  24. {
  25. System.out.print("ID: " + rs.getInt("id"));
  26. System.out.print(", name: " + rs.getString("name"));
  27. System.out.print(", surname: " + rs.getString("surname"));
  28. System.out.println(", group: " + rs.getInt("student_group"));
  29. }
  30. }
  31. catch(Exception ex)
  32. {
  33. System.out.println(ex.getMessage());
  34. }
  35. }
  36. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement