Cacher is the code snippet organizer for pro developers

import java.sql.*;  

class MysqlCon{  

public static void main(String args[]){ 

  try{
  
    Class.forName("com.mysql.jdbc.Driver");  
    Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/sonoo","root","root");  
  
    Statement stmt=con.createStatement();  
    ResultSet rs=stmt.executeQuery("select * from location where timestamp > 'May 1, 2017 00:00:00' and timestamp < 'May 1, 2017 23:59:59' ");  
    while(rs.next())  
    CSVWriter writer = new CSVWriter(new FileWriter("/tmp/data.csv"), '\t'); 
    Boolean includeHeaders = true;
    writer.writeAll(rs, includeHeaders);
    writer.close();
    con.close();  
    } catch(Exception e){ System.out.println(e);}  
  }  
}