获取某个时间的前后区间时间

package com.xinan.dataservice.util;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;



/**
 * <ol>
 * date:2021-04-13 editor:songquan
 * <li>获取当前时间的前某时段渐渐，后某时段时间</li>
 * <li></li>
 * </ol>
 *
 * @author <a href="mailto:3099754834@qq.com">songquan</a>
 * @version 1.0
 * @since 1.0
 */
public class TimeUtil {
    /**
     * @param args
     */
    public static void main(String[] args) throws ParseException {
        // TODO Auto-generated method stub
        String date1 = "2009-03-23 08:00:00";//指定时间
        String date2=  addDate(date1,1);//加1小时方法
        System.out.println("after:"+date2);

        gettime("2021-05-19 10:57:42");


    }

    public static String addDate(String day, int x)
    {
        SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//24小时制
        //SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");//12小时制
        Date date = null;
        try
        {
            date = format.parse(day);
        }
        catch (Exception ex)
        {
            ex.printStackTrace();
        }
        if (date == null) return "";
        Calendar cal = Calendar.getInstance();
        cal.setTime(date);
        cal.add(Calendar.HOUR_OF_DAY, x);//24小时制
        //cal.add(Calendar.HOUR, x);12小时制
        date = cal.getTime();
        System.out.println("front:" + date);
        cal = null;
        return format.format(date);
    }

    public static Long gettime(String date) throws ParseException {

        ArrayList<String> cons = new ArrayList<>();
        cons.add("2020-04-26 08:16:38");
        cons.add("2020-04-26 08:16:38");
        cons.add("ZZS8316");
        cons.add("460110106182218");


        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
        long time = sdf.parse(date).getTime();

        String selectSql = "select  distinct imsi as imsi from gsmdata where time >=" + sdf.parse(cons.get(0)).getTime() / 1000 + "s and time <=" + sdf.parse(cons.get(1)).getTime() / 1000 + ".999999999s and ip='" + cons.get(2) + "' and imsi='" + cons.get(3) + "'  tz('Asia/Shanghai') ";
      //  System.out.println("date: "+date2);
       // System.out.println("date.toString: "+date2.toString());
       // System.out.println("dateFormat: "+dateFormat);
        System.out.println("dateFormatParse "+time);
        System.out.println(selectSql);
        return time;
    }

}