Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static void main(String[] args)
- {
- String url = "jdbc:mysql://localhost:3306";
- String user = "root";
- String password = "demo@123";
- String qry = "SELECT * FROM test.database WHERE EndTime >= date_sub(now(), interval 5 minute)";
- Connection conn = null;
- try
- {
- conn = DriverManager.getConnection(url, user, password);
- ResultSet rs = conn.prepareStatement(qry).executeQuery();
- while(rs.next())
- {
- System.out.println(rs.getString("EventName"));
- System.out.println(rs.getTimestamp("EndTime"));
- System.out.println("-------------------");
- }
- }
- catch (SQLException e)
- {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
Add Comment
Please, Sign In to add comment