取得指定 日起所在的周1 周末

//取得星期一

public static java.util.Date getWeekDay1(java.util.Date date){
  Calendar cal = Calendar.getInstance();  
  cal.setTime(date);  
  int dayOfWeek = cal.get(Calendar.DAY_OF_WEEK);  
  cal.add(Calendar.DATE,(dayOfWeek-2)*(-1));  
  return  cal.getTime();  
 }

//取得星期天
 public static java.util.Date getWeekDay7(java.util.Date date){
  Calendar cal = Calendar.getInstance();  
  cal.setTime(date);  
  int dayOfWeek = cal.get(Calendar.DAY_OF_WEEK);  
  cal.add(Calendar.DATE,(dayOfWeek-2)*(-1)+6);  
  return cal.getTime();   
 }

//西方第一天是从周日开始。。。

 

//将 java.util.date 转化为 java.sql.date

SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");

searchStartDate = Date.valueOf(format.format(getWeekDay1(searchDate)));

searchEndDate = Date.valueOf(format.format(getWeekDay7(searchDate)));