java日期类封装及MyMy97DatePicker日期插件使用总结 - JAVA

yyyMMdd"); return sdf.format(cal.getTime()); } /** 获取当月的最后一天 * 返回yyyy年mm月dd日 * @return yyyy年MM月dd日 */ public static String getCurrentMontLastDay2(){ SimpleDateFormat sdf = new SimpleDateFormat("yyyy年MM月dd日"); return sdf.format(getLastDayOfMonth()); } /** * 得到今天的前一天 * @return yyyyMMdd */ public static String getOneDayfore(){ Calendar calendar = Calendar.getInstance(TimeZone.getTimeZone("GMT+08:00")); calendar.add(Calendar.DATE, -1); //得到前一 SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd"); return sdf.format(new Timestamp(calendar.getTime().getTime())); } }

定义公共引入的文件:include.inc

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

  
<%@ page language="java" import="com.chinacreator.code.utils.DateTimeHelper" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>

<%
	//上下文路径
	String contextPath=request.getContextPath();
	//主题路径
	String themePath="/template/themes/default";
	String filePath="jsp/fileupload/";
	String year=DateTimeHelper.getCurrentYear();
	String month=DateTimeHelper.getCurrentMonth();
	String day=DateTimeHelper.getCurrentDay();
	String hour=DateTimeHelper.getCurrentHour();
	String minute=DateTimeHelper.getCurrentMinute();
	String currentDay=DateTimeHelper.getCurrentDate();//获取系统当前日期格式yyyy-mm-dd
	String beforeOneDay=DateTimeHelper.getBeforeDate(0,-1);//获取前一天日期格式yyyy-mm-dd
	String nextOneDay=DateTimeHelper.getBeforeDate(0,1);//获取今天的后一天的日期yyyy-mm-dd
	pageContext.setAttribute("themePath",themePath);
	pageContext.setAttribute("contextPath",contextPath);
	pageContext.setAttribute("filePath",filePath);
	pageContext.setAttribute("year",year);
	pageContext.setAttribute("month",month);
	pageContext.setAttribute("day",day);
	pageContext.setAttribute("hour",hour);
	pageContext.setAttribute("minute",minute);
	pageContext.setAttribute("hour",hour);
	pageContext.setAttribute("minute",minute);
	pageContext.setAttribute("currentDay",currentDay);
	pageContext.setAttribute("beforeOneDay",beforeOneDay);
	pageContext.setAttribute("nextOneDay",nextOneDay);
	
	
%>

  
<script type="text/java script" src="${contextPath}${themePath}/js/jquery-1.4.2.js">

  
<script type="text/java script" src="${contextPath}${themePath}/js/paging.js">

  
<script type="text/java script" src="${contextPath}${themePath}/js/common.js">

  
<script type="text/java script" src="${contextPath}${themePath}/js/checkidcard.js">

  

  

  
<script type="text/java script" src="${contextPath}/plugs/My97DatePicker/WdatePicker.js">

  
<script type="text/java script" src="${contextPath}/plugs/FusionCharts/JSClass/FusionCharts.js">

  
<script type="text/java script" src="${contextPath}/plugs/ztree/js/jquery.ztree.all-3.5.min.js">
<script>
	var themePath="<%=themePath%>";
	var contextPath="<%=contextPath%>";
	var filePath="<%=filePath%>";
	var year="<%=year%>";
	var month="<%=month%>";
	var day="<%=day%>";
	var hour="<%=hour%>";
	var minute="<%=minute%>";
	var currentDay="<%=currentDay%>";
	var beforeOneDay="<%=beforeOneDay%>";
	var nextOneDay="<%=nextOneDay%>";

Jsp页面引入:
<%@ include file="/template/include.inc"%>
包含这个文件后就获取设置属性值，引入的样式,js文件，定义的全局的js变量了

公共查询条件Bean:

在java类中
bean继承BaseQuery

/**
 * 
 *@author xiaoqun.yi
 */
public class BaseQuery implements Serializable {
	/**
	 * 
	 */
	private static final long serialVersionUID = -2128648445206020540L;
	// 查询条件用
	private String startDate;
	private String endDate;
	private String keywords;
	private String dept_name;
	private String emp_name;
	

	
	public String getStartDate() {
		return startDate;
	}

	public void setStartDate(String startDate) {
		this.startDate = startDate;
	}

	public String getEndDate() {
		return endDate;
	}

	public void setEndDate(String endDate) {
		this.endDate = endDate;
	}

	public String getKeywords() {
		return keywords;
	}

	public void setKeywords(String keywords) {
		this.keywords = keywords;
	}

	public String getDept_name() {
		return dept_name;
	}

	public void setDept_name(String dept_name) {
		this.dept_name = dept_name;
	}

	public String getEmp_name() {
		return emp_name;
	}

	public void setEmp_name(String emp_name) {
		this.emp_name = emp_name;
	}
	
}

时间比较使用字符串yymmdd既方便比较又不需要转换
处罚时间: 最大时间不能大于当前时间,这里使用maxDate:'currentDay'这是前面引入文件包含的currentDay,currentDay当前时间为服务器时间
,第二个日期大于第一个日期,日期显示值为:yyyy-mm-dd 日期实际值为yyyymmdd (日期为服务器时间)

--

sql:这是使用的是xml，其实不用xml也一样，条件判断不为空就加上条件
#if($startDate && !$startDate.equals(""))
and p.peccancy_time>=#[startDate]
#end
#if($endDate && !$endDate.equals(""))
and p.peccancy_time<=#[endDate]
#end

选择的日期不能大于当前日期(日期为服务器时间) maxDate:'currentDay'

选择的最小日期大于当前日期，后面的日期大于前面的日期,日期格式为:yyyy-mm-dd 值为yyyymmdd (日期为服务器时间)

< http://www.2cto.com/kf/ware/vc/" target="_blank" class="keylink">vcD4KPHA+yejWw8SsyM+3/s7xxvfKsbzktcTHsNK7zOzKsbzkICjI1cbazqq3/s7xxvfKsbzkKTwvcD4KPHA+PC9wPgo8cHJlIGNsYXNzPQ=="brush:java;">

设置默认服务器时间的后一天时间 (日期为服务器时间)

sql显示日期(oracle)日期存数据库用字符串用yyyymmdd是为了方便比较
substr(r.timelimit,1,4)"|'-'||substr(r.timelimit,5,2)||'-'||substr(r.timelimit,7,2) as timelimit,

时间:显示为hh:实际值为:hhmi是为了两个时间段的比较方便 (日期为服务器时间)

var starttime=$("#date01").val();
starttime=starttime.substring(0,2)+start

java日期类封装及MyMy97DatePicker日期插件使用总结(三)