java JDBC-返回不同时间段的内容

public class Demo9 {
 
 public static long strtodate(String str)
 {
  //字符串转时间类
  DateFormat format =new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
  try {
   Date date=format.parse(str);
   
   return date.getTime();
  } catch (ParseException e) {
   e.printStackTrace();
  }
  return (Long) null;
 }
 
 public static void main(String[] args) {
  Connection conn=null;
  PreparedStatement ps=null;
  ResultSet set=null;
  try {
   Class.forName("com.mysql.jdbc.Driver");
   conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","dyl123");
   
   ps=conn.prepareStatement("select * from t_user where regTime between ? and ?");
   
   java.sql.Date start=new java.sql.Date(strtodate("2019-10-8 10:10:23"));
   java.sql.Date end=new java.sql.Date(strtodate("2019-10-9 10:10:23"));
   
   ps.setObject(1, start);
   ps.setObject(2, end);
   
   set=ps.executeQuery();
   
   while(set.next())
   {
    //取数据的时候既可以用索引来取，也可以用名字来取
    System.out.println(set.getInt(1)+"--"+set.getString("username")+set.getDate("regTime"));
   }
   
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException e) {
   e.printStackTrace();
  }finally {
   
   try {
    if(null!=ps)
    {
     ps.close();
    }
   }catch(SQLException e)
   {
    e.printStackTrace();
   }
   try {
    if(null!=conn)
    {
     conn.close();
    }
   }catch(SQLException e)
   {
    e.printStackTrace();
   }
  }
 }
}