日期小综合

public static void main(String[] args) {

		long ltoday = System.currentTimeMillis();
		// long lyesday = ltoday-24*60*60*1000l;
		long l7day = ltoday - 7 * 24 * 60 * 60 * 1000l;
		// 昨天
		long lyesday = ltoday-24*60*60*1000l;
		java.sql.Timestamp todaytimes = new java.sql.Timestamp(ltoday);
		// java.sql.Timestamp yesdaytimes = new java.sql.Timestamp(lyesday);
		java.sql.Timestamp day7times = new java.sql.Timestamp(l7day);
		java.sql.Timestamp yes = new java.sql.Timestamp(lyesday);
		// 上周周一
		String day7 = day7times.toString().substring(0, 10).replace("-", "");
		// 今天
		String today = todaytimes.toString().substring(0, 10).replace("-", "");
		// 昨天
		String yesday = yes.toString().substring(0, 10).replace("-", "");
		SimpleDateFormat sdfInput = new SimpleDateFormat("yyyyMMdd");
		Calendar calendar = Calendar.getInstance();
		Date date_s = new Date();
		try {
			date_s = sdfInput.parse(today);
		} catch (ParseException e) {
			e.printStackTrace();
		}
		calendar.setTime(date_s);
		int dayOfWeek = calendar.get(Calendar.DAY_OF_WEEK);
		//System.out.println(today);
		// System.out.println(dayOfWeek-1);
		// System.out.println(dayNames[dayOfWeek-1]);
		boolean dayOrWeek = false;
		// 总计
		String sql_client_all = "select p_type,sum(u_1) as u_1 from T_STAT  where (p_type=6 or p_type=1 or p_type=8) and date_format(logday,'%Y%m%d')<'"+today+"' group by p_type order by logday desc";
		// 日报
		String sql_client_day = "select pt,zpt,p_type,sum(u_1) as u_1 from T_STAT  where (p_type=6 or p_type=1 or p_type=8) and date_format(logday,'%Y%m%d')='"+yesday+"' group by p_type,pt,zpt order by pt,zpt";

		String sql_client_week = "select p_type,sum(u_1) as u_1 from T_CLIENT  where (p_type=6 or p_type=1 or p_type=8) and date_format(logday,'%Y%m%d')>='"+day7+"' and date_format(logday,'%Y%m%d')<'"+today+"' group by p_type order by logday desc";

		if ((dayOfWeek - 1) == 1) {
			dayOrWeek = true;
		}
		SimpleDateFormat to_day = new SimpleDateFormat("MM.dd：");
		Date time = new Date(lyesday) ;   
		//System.out.println(time+","+(time.getDay()-1)+"月"+time.getDate()+"号"+time.getHours()+"时"+time.getMinutes()+"分"+time.getSeconds()+"秒");
		//System.out.println(tim);
		//System.out.println(to_day.format(time));
		sms_day_week(sql_client_day,sql_client_week,sql_client_all,dayOrWeek,to_day.format(time));


	}