Guest User

Untitled

a guest
Mar 20th, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. public static void main(String[] args)
  2. {
  3. String url = "jdbc:mysql://localhost:3306";
  4. String user = "root";
  5. String password = "demo@123";
  6. String qry = "SELECT * FROM test.database WHERE EndTime >= date_sub(now(), interval 5 minute)";
  7.  
  8. Connection conn = null;
  9.  
  10. try
  11. {
  12. conn = DriverManager.getConnection(url, user, password);
  13.  
  14. ResultSet rs = conn.prepareStatement(qry).executeQuery();
  15.  
  16. while(rs.next())
  17. {
  18. System.out.println(rs.getString("EventName"));
  19. System.out.println(rs.getTimestamp("EndTime"));
  20. System.out.println("-------------------");
  21. }
  22. }
  23. catch (SQLException e)
  24. {
  25. // TODO Auto-generated catch block
  26. e.printStackTrace();
  27. }
Add Comment
Please, Sign In to add comment