coolhappiness
- 浏览: 46966 次
- 性别:
- 来自: 北京
-
文章分类
最新评论
当前时间所在周and所在月起始结束日期定位
package com.zyna.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.GregorianCalendar;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.xml.parsers.ParserConfigurationException;
import com.zyna.db.DbAccessor;
import com.zyna.dbstructure.XML;
import com.zyna.pojo.OperateTask;
public class SampleServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public SampleServlet() {
super();
}
protected void doGet(HttpServletRequest request,HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
}
protected void doPost(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
XML xml = new XML();
try {
xml.init();
} catch (ParserConfigurationException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
//SampleServlet?time="+time+"justUnit="+justUnit+"department="+department+"eventType="+eventType;
//接收 查询参数
String time = request.getParameter("time");
String justUnit = request.getParameter("justUnit");
String department = request.getParameter("department");
String eventType = request.getParameter("eventType");
//response.setContentType("text/html");
//response.setCharacterEncoding("GBK");
response.setContentType("text/xml");
response.setCharacterEncoding("UTF-8");
PrintWriter out = response.getWriter();
//connection database
DbAccessor dbAccessor = new DbAccessor();
//sql
StringBuffer sql = new StringBuffer(256);
sql.append("SELECT ot_id, ot_item, ot_type, ot_level, ot_frequency, ot_desc, ot_attachment, ot_busid, ot_createtime, ot_createuser FROM t_opreate_task where 1=1");
if(null != time && time != ""&&null != justUnit && justUnit != ""){
Map<String,String> map = splitDateStr(time);
String day = map.get("day");
String month = map.get("month");
String year = map.get("year");
String startDay = "";
String endDay = "";
//周报表
if("week".equals(justUnit)){
Map<String,Date> map_Week = getThisWeekStartDayAndEndDay(Integer.parseInt(year),Integer.parseInt(month),Integer.parseInt(day));
Date calFirstDayInThisWeek = map_Week.get("calFirstDayInThisWeek");
Date calLastDayInThisWeek = map_Week.get("calLastDayInThisWeek");
String calFirstDayInThisWeek_Str = dateToString(calFirstDayInThisWeek,"yyyy-MM-dd");
startDay = calFirstDayInThisWeek_Str;
String calLastDayInThisWeek_Str = dateToString(calLastDayInThisWeek,"yyyy-MM-dd");
endDay = calLastDayInThisWeek_Str;
}//月报表
else if("month".equals(justUnit)){
Map<String,Date> map_Month = getThisMonthStartDayAndEndDay(Integer.parseInt(year),Integer.parseInt(month),Integer.parseInt(day));
Date calFirstDayInThisMonth = map_Month.get("calFirstDayInThisMonth");
Date calLastDayInThisMonth = map_Month.get("calLastDayInThisMonth");
String calFirstDayInThisMonth_Str = dateToString(calFirstDayInThisMonth,"yyyy-MM-dd");
String ccalLastDayInThisMonth_Str = dateToString(calLastDayInThisMonth,"yyyy-MM-dd");
startDay = calFirstDayInThisMonth_Str;
endDay = ccalLastDayInThisMonth_Str;
}else{
return;
}
//where ot_createtime between '2011-04-13' and '2011-11-13';
sql.append(" and")
.append(" ot_createtime")
.append(" between")
.append(" '")
.append( startDay)
.append(" '")
.append(" and")
.append(" '")
.append( endDay)
.append(" '")
;
// System.out.println("aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa");
}
if(null != time && time != "" && (justUnit=="" || justUnit == null)){
Map<String,String> tempMap = splitDateStr(time);
String day = tempMap.get("day");
String month = tempMap.get("month");
String year = tempMap.get("year");
Calendar calendar = new GregorianCalendar(Integer.parseInt(year), Integer.parseInt(month)-1, Integer.parseInt(day));
Date date = calendar.getTime();
String date_Str = dateToString(date,"yyyy-MM-dd");
sql.append(" and")
.append(" ot_createtime = ")
.append(" '")
.append(date_Str)
.append(" '")
;
}
if(null != department && department != ""){
sql.append(" and")
.append(" ot_busid=")
.append(" '")
.append(department)
.append(" '")
;
}
if(null != eventType && eventType != "" && 1==1){
sql.append(" and")
.append(" ot_type='"+eventType+"'");
}
for(int i = 0 ; i < 100 ; i++){
System.err.println("sql-->"+sql.toString());
}
//String sql = "SELECT ot_id, ot_item, ot_type, ot_level, ot_frequency, ot_desc, ot_attachment, ot_busid, ot_createtime, ot_createuser FROM t_opreate_task";
//run sql
ResultSet resultSet = dbAccessor.execute(sql.toString());
List<OperateTask> list = new ArrayList<OperateTask>();
try {
while(resultSet.next()){
String[] strs = new String[10] ;
//ot_id
strs[0]= String.valueOf(resultSet.getInt(1));
//ot_item
strs[1] =resultSet.getString(2);
//ot_type
strs[2]=String.valueOf(resultSet.getInt(3));
//ot_level
strs[3]=String.valueOf(resultSet.getInt(4));
//ot_frequency
strs[4]=String.valueOf(resultSet.getInt(5));
xml.create(strs);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
//out.println("The locale you selected is " + locale+"t_opreate_task"+id+"-->"+list);
try {
while(resultSet.next()){
int id = resultSet.getInt(1);
System.out.println("id-->"+id);
}
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
//out.println(locale+"xiaoyu"+resultSet.toString());
try {
xml.output(out);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void main(String[] args){
// Calendar calendar = Calendar.getInstance();
//
// int dayOfWeek = calendar.get(Calendar.DAY_OF_WEEK)-1;
//
// Calendar calFirstDayInThisWeek = (Calendar)calendar.clone();
//
// //例如，要从当前日历时间减去 5 天，可以通过调用以下方法做到这一点： add(Calendar.DAY_OF_MONTH, -5)。
// calFirstDayInThisWeek.add(Calendar.DATE, calendar.getActualMinimum(Calendar.DAY_OF_WEEK)-dayOfWeek);
//
// Calendar calLastDayInThisWeek = (Calendar)calendar.clone();
//
// calLastDayInThisWeek.add(Calendar.DATE,calendar.getActualMaximum(Calendar.DAY_OF_WEEK)-dayOfWeek);
//
// System.out.println("今天是本周的第"+dayOfWeek+"天"+"--本周星期一具日期为:"+calFirstDayInThisWeek.getTime()+"-->"+calLastDayInThisWeek.getTime());
//
// List<Map<String,Date>> tempList = getThisWeekStartDayAndEndDay("");
//
// Map<String,Date> tempMap = tempList.get(0);
//
// System.out.println("tempMap_1-->"+tempMap.get("calFirstDayInThisWeek")+"---"+tempMap.get("calLastDayInThisWeek"));
//splitDateStr("");
//Map map = splitDateStr("07/11/2011");
// System.out.println("map_day-->"+map.get("day"));
//
// System.out.println("map_month-->"+map.get("month"));
//
// System.out.println("map_year-->"+map.get("year"));
//
// Map map = getThisWeekStartDayAndEndDay(2011,7,11);
//
// System.out.println("calFirstDayInThisWeek-->"+map.get("calFirstDayInThisWeek"));
//
// System.out.println("calLastDayInThisWeek-->"+map.get("calLastDayInThisWeek"));
//System.out.println("Calendar.JULY"+Calendar.JULY);
//getThisMonthStartDayAndEndDay(1,2,3);
//Calendar calendar = Calendar.getInstance();
//int maximum = calendar.getMaximum(calendar.DAY_OF_MONTH);
//System.out.println("maximum-->"+maximum);
// Map<String ,Date> map = getThisMonthStartDayAndEndDay(2011,7,11);
// Date calFirstDayInThisMonth = map.get("calFirstDayInThisMonth");
// Date calLastDayInThisMonth = map.get("calLastDayInThisMonth");
// //2011-04-13
// DateFormat df = new SimpleDateFormat("yyyy-MM-dd");
// String calFirstDayInThisMonth_str = df.format(calFirstDayInThisMonth);
// String calLastDayInThisMonth_str = df.format(calLastDayInThisMonth);
// System.out.println("-----------------------------------------");
// System.out.println("calFirstDayInThisMonth_str-->"+calFirstDayInThisMonth_str);
// System.out.println("calLastDayInThisMonth_str-->"+calLastDayInThisMonth_str);
// System.out.println("-----------------------------------------");
// Map<String,String> map = splitDateStr("07/11/2011");
//
// String day = map.get("day");
//
// String month = map.get("month");
//
// String year = map.get("year");
//
//
// System.out.println("今天是："+year+"_"+month+"_"+day);
String[] arrayStr =new String[]{"a","b","c","d","e","f","g","h","i"};
System.out.println("arrayStr.length-->"+arrayStr.length);
int ladyQ = arrayStr.length << 4;
System.out.println("length << 4-->"+ladyQ);
}
/**
* 根据给定输入时间得到本周起始时间和本周结束时间
* key1:calFirstDayInThisWeek
* key2:calLastDayInThisWeek
*/
public static Map<String,Date> getThisWeekStartDayAndEndDay(int year,int month,int day){
Calendar calendar = new GregorianCalendar(year, month-1, day);
//Calendar calendar = Calendar.getInstance();
//Calendar cal = new GregorianCalendar(2005, Calendar.JANUARY, 30);
int dayOfWeek = calendar.get(Calendar.DAY_OF_WEEK)-1;
Calendar calFirstDayInThisWeek = (Calendar)calendar.clone();
//例如，要从当前日历时间减去 5 天，可以通过调用以下方法做到这一点： add(Calendar.DAY_OF_MONTH, -5)。
calFirstDayInThisWeek.add(Calendar.DATE, calendar.getActualMinimum(Calendar.DAY_OF_WEEK)-dayOfWeek);
Calendar calLastDayInThisWeek = (Calendar)calendar.clone();
calLastDayInThisWeek.add(Calendar.DATE,calendar.getActualMaximum(Calendar.DAY_OF_WEEK)-dayOfWeek);
System.out.println("今天是本周的第"+dayOfWeek+"天"+"--本周星期一具日期为:"+calFirstDayInThisWeek.getTime()+"-->"+calLastDayInThisWeek.getTime());
Map map = new HashMap();
map.put("calFirstDayInThisWeek", calFirstDayInThisWeek.getTime());
map.put("calLastDayInThisWeek", calLastDayInThisWeek.getTime());
return map;
}
/**
* key_1:calFirstDayInThisMonth
* key_2:calLastDayInThisMonth
* @param year
* @param month
* @param day
* @return
*/
public static Map<String,Date> getThisMonthStartDayAndEndDay(int year,int month,int day){
//Calendar calendar = Calendar.getInstance();
Calendar calendar = new GregorianCalendar(year, month-1, day);
int dayOfMonth = calendar.get(Calendar.DAY_OF_MONTH);
Calendar calFirstDayInThisMonth = (Calendar)calendar.clone();
//例如，要从当前日历时间减去 5 天，可以通过调用以下方法做到这一点： add(Calendar.DAY_OF_MONTH, -5)。
calFirstDayInThisMonth.add(Calendar.DATE, calendar.getActualMinimum(Calendar.DAY_OF_MONTH)-dayOfMonth);
Calendar calLastDayInThisMonth = (Calendar)calendar.clone();
calLastDayInThisMonth.add(Calendar.DATE, calendar.getMaximum(Calendar.DAY_OF_MONTH)-dayOfMonth);
Map<String,Date> map = new HashMap<String,Date>();
map.put("calFirstDayInThisMonth", calFirstDayInThisMonth.getTime());
map.put("calLastDayInThisMonth", calLastDayInThisMonth.getTime());
return map;
}
/**
* 分割 dateSstr 喂 getThisWeekStartDayAndEndDay
* @param dateStr
* @return
*/
public static Map<String,String> splitDateStr(String dateStr){
//07/11/2011
String tempDateStr = "07/11/2011";
String[] strArr = dateStr.split("/");
String month = strArr[0];
String day = strArr[1];
String year = strArr[2];
if(strArr.length != 3){
return null;
}
Map map = new HashMap();
map.put("day", day);
map.put("month", month);
map.put("year", year);
return map;
}
public static String dateToString(Date date,String ruler){
//String ruler_1 = "yyyy-MM-dd";
DateFormat df = new SimpleDateFormat(ruler);
String date_Str = df.format(date);
return date_Str;
}
}
分享到：
发表评论
相关推荐
查询所传过来的日期所在的自然周，月的起始和截止的日期
JS获取当天是本年的第几周和本周的起始日期,可以设定周的起始日期,我这里的周是礼拜四开始,礼拜五结束,可以跨年,跨月
Type 日期类型：（“-”为前一期间，无符号为当期，“+”为后一期间）,Y 年，Q 季，M 月，W 周，D 日 例：前一年：-Y，当年：Y,+Y:下一年 datetype : ‘S’返回开始时间，'E'返回结束时间 datetime: 按哪个时间进行...
可选择起始日期和结束日期的时间选择器
最近在制作一个报表，里面需要计算某日是属于当年的多少周，并且要显示这周的起始日期和截止日期，本以为网上会有很多，可是找来找去，要么是要用WEEKNUM（）这函数，需要加分析工具库，通用性不是很强，要么就不是...
获取当天、昨天、上周、当月、上个月 当年等起始和结束时间
Git地址 ： ... 时间段筛选器 1 可自定义起始时间和终止时间 2 支持一键选择当天 昨天 本周 本月时间段 3 自定义颜色 4 快速重置时间
Java中用Calendar类计算周和周的起始日期
此DEMO为android studio项目，带有开始时间和结束时间的日期选择器，由于屏幕宽度有限，两个时间选择器为竖向串联模式。
这条SQL语句主要是用来显示某个时间段内的所有日期，有利于显示日期相关数据
日期对应自然月起始日期(YYYY-MM-DD格式)2020/12/1 日期对应自然月起始日期(时间戳格式)1606752000 日期对应自然月底日期(YYYYMMDD格式)20201231 日期对应自然月底日期(YYYY-MM-DD格式)2020/12/31 日期对应自然月底...
支持开始时间和结束时间联动，从VUE和element UI框架中拆分出来的。可以作为一个插件，单独引入到你需要的单个页面中。。UI界面很美观。功能强大。
主要介绍了C#获取每个年,月,周的起始日期和结束日期的方法,涉及C#时间与日期基本操作技巧,具有一定参考借鉴价值,需要的朋友可以参考下
js 获取 本周、上周、本月、上月、本季度、上季度的开始结束日期 /** * 获取本周、本季度、本月、上月的开始日期、结束日期 */ var now = new Date(); //当前日期 var nowDayOfWeek = now.getDay(); //今天本周的...
java时间操作工具类，已封装好，包含获取某一时间的年，月，日，星期。以及对某一时间进行年，月，日，周的加减。还有获取某一时间年，月，日，周的起始和结束时间等等
//获取当前周的第几天 周日是 0 周一到周六是 1 – 6 $w=date(‘w’,strtotime($sdefaultDate)); //获取本周开始日期，如果$w是0，则表示周日，减去 6 天 $week_start=date(‘Y-m-d’,strtotime(“$sdefaultD
复制代码 代码如下: /** * 获取指定日期所在月的开始日期与结束日期 * @param string $date * @param boolean 为true返回开始日期，否则返回结束日期 * @return array * @access private */ private ...
当前的日期、根据指定日期得获取对应年份的所有月的日期、获取月初时间、获取月末时间、获取当天的起始时间、获取当天的结束时间、获取昨天的开始时间、获取昨天的结束时间、当前季度的开始时间、当前季度的结束时间...
3.周选择最大选择12个周，选择起始周后，在选择结束周时，会在日历上默认开始周+最大周数后所在周的最后一天 4.周选择器时，日历从星期一开始，星期天结束；每周的第一天是周一；每年的最后一天（即12月31号）所在的...
给定项目起始、结束时间，寻找能做项目最多次数