根据日期的前一天后一天的改变查询数据

 首先引入calendar.js文件,js文件源代码如下:

//这个方法用来进行日期的前一天和后一天的移动function beforeday(obj){/** *获取日期文本框的值将获取到得值赋值给变量**/var starthidden=document.getElementById("text1").value;var endhidden=document.getElementById("text2").value;/** *正则匹配日期**/var reg = /^(/d{4})-(/d{1,2})-(/d{1,2})/;/** *如果传入的值为1 将日期加上一天 *如果传入的值为-1 将日期加减去一天**/if(obj==1){//alert("1=="+obj);//给开始日期赋值if(reg.test(starthidden)){ //调用进行日期的加减的方法dateAdd var d = dateAdd(RegExp.<div> <p><strong> 首先引入calendar.js文件,js文件源代码如下:</strong></p> <p><textarea>//这个方法用来进行日期的前一天和后一天的移动function beforeday(obj){/** *获取日期文本框的值将获取到得值赋值给变量**/var starthidden=document.getElementById("text1").value;var endhidden=document.getElementById("text2").value;/** *正则匹配日期**/var reg = /^(/d{4})-(/d{1,2})-(/d{1,2})/;/** *如果传入的值为1 将日期加上一天 *如果传入的值为-1 将日期加减去一天**/if(obj==1){//alert("1=="+obj);//给开始日期赋值if(reg.test(starthidden)){ //调用进行日期的加减的方法dateAdd var d = dateAdd(RegExp.$1,RegExp.$2,RegExp.$3,1); starthidden=d.getFullYear()+"-"+(d.getMonth()+1)+"-"+d.getDate(); document.getElementById("text1").value=starthidden; //alert("text1赋值后的值为："+starthidden);}//给结束日期赋值if(reg.test(endhidden)){ //调用进行日期的加减的方法dateAdd var d = dateAdd(RegExp.$1,RegExp.$2,RegExp.$3,1); endhidden=d.getFullYear()+"-"+(d.getMonth()+1)+"-"+d.getDate(); document.getElementById("text2").value=endhidden; //alert("text2赋值后的值为："+endhidden);}}else{//alert("-1=="+obj);if(reg.test(starthidden)){ //调用进行日期的加减的方法dateAdd var d = dateAdd(RegExp.$1,RegExp.$2,RegExp.$3,-1); starthidden=d.getFullYear()+"-"+(d.getMonth()+1)+"-"+d.getDate(); document.getElementById("text1").value=starthidden; //alert("text1赋值后的值为："+starthidden);}if(reg.test(endhidden)){ //调用进行日期的加减的方法dateAdd var d = dateAdd(RegExp.$1,RegExp.$2,RegExp.$3,-1); endhidden=d.getFullYear()+"-"+(d.getMonth()+1)+"-"+d.getDate(); document.getElementById("text2").value=endhidden; //alert("text2赋值后的值为："+endhidden);}}}//这个方法用来进行日期的加减function dateAdd(y,m,d,n){ var d = new Date(y,m-1,d); d.setDate(d.getDate()+n); return d;}

ByqHoursDataAction类源代码:

import java.text.ParseException;import java.text.SimpleDateFormat;import java.util.Calendar;import java.util.Date;import java.util.List;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.apache.struts.action.ActionForm;import org.apache.struts.action.ActionForward;import org.apache.struts.action.ActionMapping;import org.apache.struts.actions.DispatchAction;import com.mww.biz.ByqHhDataService;import com.mww.entity.ByqDayData;import com.mww.entity.ByqHhData;/** * MyEclipse Struts * Creation date: 09-04-2009 * * XDoclet definition: * @struts.action validate="true" */public class ByqHoursDataAction extends DispatchAction {/* * Generated Methods *//** * Method execute * @param mapping * @param form * @param request * @param response * @return ActionForward */private ByqHhDataService service = null;public ByqHhDataService getService() {return service;}public void setService(ByqHhDataService service) {this.service = service;}//实现 日数据 小时数据的查询 和 日期的前一天和后一天的移动来查询数据public ActionForward selectByqHoursData(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response) {try {String option = request.getParameter("select");String byqid = request.getParameter("textByqid");SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");String text1 = request.getParameter("text1");String text2 = request.getParameter("text2");Date time1 = format.parse(text1+" 00:00:00");Date time2 = format.parse(text2+" 23:59:59");//日数据if("0".equals(option)||option=="0"){List<ByqDayData> byqDayList = service.selectbyq_Day(byqid, time1, time2);request.setAttribute("text1", text1);request.setAttribute("text2", text2);request.setAttribute("list", byqDayList);return mapping.findForward("day");}//小时数据if("1".equals(option)||option=="1"){List<ByqHhData> byqHourslist = service.selectbyq_Hours(byqid, time1, time2);request.setAttribute("text1", text1);request.setAttribute("text2", text2);request.setAttribute("byqHourslist", byqHourslist);return mapping.findForward("Hours");}} catch (ParseException e) {e.printStackTrace();}return null;}}

shwoByqHoursData.jsp 页面源代码:

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><%@taglib uri="https://java.sun.com/jsp/jstl/core" prefix="c"%><%@ taglib prefix="bean" uri="/WEB-INF/struts-bean.tld"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html> <head> <title>变压器小时数据</title> <link href="/go.html?url=css/common.css" mce_href="/go.html?url=css/common.css" rel="stylesheet" type="text/css" /> <mce:style type="text/css"><!--ing{border:0;}A{ font-size:12px;}A:hover{ font-size:12px; text-decoration:underline; color:#ff7000;}td{ font-size:12px; line-height:20px;}--></mce:style><style type="text/css" mce_bogus="1">ing{border:0;}A{ font-size:12px;}A:hover{ font-size:12px; text-decoration:underline; color:#ff7000;}td{ font-size:12px; line-height:20px;}</style><mce:script type="text/javascript" src="js/calendar.js" mce_src="js/calendar.js"></mce:script><!-- 前一天|后一天 --><mce:script type="text/javascript" src="My97DatePicker/WdatePicker.js" mce_src="My97DatePicker/WdatePicker.js"></mce:script><!-- 日期选择 --> </head> <mce:script type="text/javascript"><!-- //这个进行前一天和后一天的时间的变化 然后在查询function beforeday1(obj){beforeday(obj);document.getElementById("myform").submit();} // --></mce:script> <body> <h2 align="center"><strong> 变压器小时数据查询结果</strong></h2> <form action="byqHoursData.do?method=selectByqHoursData" name="myform" method="post" id="myform" onsubmit="return selectDayandHours2()"> <table border="1" bordercolor="#99CCFF" cellpadding="0" cellspacing="0" width="100%"> <thead> <tr bgcolor="#FFCCFF"> <td width="35%" align="center" class="tab-row"><strong>起始日期:</strong> <input name="text1" type="text" id="text1" value="${text1}" class="Wdate" onclick="new WdatePicker(this,null,false,'whyGreen')" style="width:150px;" height="18" readonly="readonly"/> </td> <td width="30%"><strong>结束日期:</strong> <input name="text2" type="text" id="text2" value="${text2}" class="Wdate" onclick="new WdatePicker(this,null,false,'whyGreen')" style="width:150px;" height="18" readonly="readonly"/> </td> <td width="42%"><div> <select name="select" id="select" style="width:80"> <option value="1">小时数据</option> </select>            <input type="submit" class="buttons" id="sbtn2" name="sbtn2" value="查 询">      <a href="/go.html?url=javascript:beforeday1(-1)" mce_href="/go.html?url=javascript:beforeday1(-1)">《前一天 </a>| <a href="/go.html?url=javascript:beforeday1(1)" mce_href="/go.html?url=javascript:beforeday1(1)">后一天 》</a> <a href="/go.html?url=javascript:AutomateExcel();" mce_href="/go.html?url=javascript:AutomateExcel();"> <img src="images/chartlogo.gif" mce_src="images/chartlogo.gif" width="16" height="16" border="0"></a> </div> </td> </tr> </thead> <tfoot> </tfoot> </table> <c:if test="${empty byqHourslist}"> <h2 align="center"><strong>对不起！没有找到您需要的数据！</strong></h2> </c:if> <c:if test="${!empty byqHourslist}"> <table width="100%" border="1" bordercolor="#99CCFF" cellpadding="0" cellspacing="0"> <tr bgcolor="#FFCCFF" align="center"> <td rowspan="2"> </td> <td rowspan="2">名称</td> <td rowspan="2">时间</td> <td rowspan="2">有功表码 </td> <td rowspan="2">无功表码</td> <td rowspan="2">有功功率</td> <td rowspan="2">无功功率</td> <td colspan="3">电压</td> <td colspan="3">电流</td> </tr> <tr bgcolor="#FFCCFF" align="center"> <td>A相</td> <td>B相</td> <td>C相</td> <td>A相</td> <td>B相</td> <td>C相</td> </tr> <c:set var="i" value="0"></c:set> <c:forEach items="${byqHourslist}" var="byqhours"> <c:set var="i" value="${i+1}"></c:set> <tr align="center"> <td>${i}</td> <td> ${byqhours.id.gatherid} <input type="hidden" id="textByqid" name="textByqid" value="${byqhours.id.gatherid}"> </td> <td><bean:write format="yyyy-MM-dd HH:mm" name="byqhours" property="id.ddate" /></td> <td>${byqhours.psum}</td> <td>${byqhours.npsum}</td> <td>${byqhours.powervalue}</td> <td>${byqhours.unpowervalue}</td> <td>${byqhours.avoltage}</td> <td>${byqhours.bvoltage}</td> <td>${byqhours.cvoltage}</td> <td>${byqhours.acurr}</td> <td>${byqhours.bcurr}</td> <td>${byqhours.ccurr}</td> </tr> </c:forEach></table></c:if></form> </body></html>

 

 

 首先引入calendar.js文件,js文件源代码如下:

//这个方法用来进行日期的前一天和后一天的移动function beforeday(obj){/** *获取日期文本框的值将获取到得值赋值给变量**/var starthidden=document.getElementById("text1").value;var endhidden=document.getElementById("text2").value;/** *正则匹配日期**/var reg = /^(/d{4})-(/d{1,2})-(/d{1,2})/;/** *如果传入的值为1 将日期加上一天 *如果传入的值为-1 将日期加减去一天**/if(obj==1){//alert("1=="+obj);//给开始日期赋值if(reg.test(starthidden)){ //调用进行日期的加减的方法dateAdd var d = dateAdd(RegExp.$1,RegExp.$2,RegExp.$3,1); starthidden=d.getFullYear()+"-"+(d.getMonth()+1)+"-"+d.getDate(); document.getElementById("text1").value=starthidden; //alert("text1赋值后的值为："+starthidden);}//给结束日期赋值if(reg.test(endhidden)){ //调用进行日期的加减的方法dateAdd var d = dateAdd(RegExp.$1,RegExp.$2,RegExp.$3,1); endhidden=d.getFullYear()+"-"+(d.getMonth()+1)+"-"+d.getDate(); document.getElementById("text2").value=endhidden; //alert("text2赋值后的值为："+endhidden);}}else{//alert("-1=="+obj);if(reg.test(starthidden)){ //调用进行日期的加减的方法dateAdd var d = dateAdd(RegExp.$1,RegExp.$2,RegExp.$3,-1); starthidden=d.getFullYear()+"-"+(d.getMonth()+1)+"-"+d.getDate(); document.getElementById("text1").value=starthidden; //alert("text1赋值后的值为："+starthidden);}if(reg.test(endhidden)){ //调用进行日期的加减的方法dateAdd var d = dateAdd(RegExp.$1,RegExp.$2,RegExp.$3,-1); endhidden=d.getFullYear()+"-"+(d.getMonth()+1)+"-"+d.getDate(); document.getElementById("text2").value=endhidden; //alert("text2赋值后的值为："+endhidden);}}}//这个方法用来进行日期的加减function dateAdd(y,m,d,n){ var d = new Date(y,m-1,d); d.setDate(d.getDate()+n); return d;}

ByqHoursDataAction类源代码:

import java.text.ParseException;import java.text.SimpleDateFormat;import java.util.Calendar;import java.util.Date;import java.util.List;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.apache.struts.action.ActionForm;import org.apache.struts.action.ActionForward;import org.apache.struts.action.ActionMapping;import org.apache.struts.actions.DispatchAction;import com.mww.biz.ByqHhDataService;import com.mww.entity.ByqDayData;import com.mww.entity.ByqHhData;/** * MyEclipse Struts * Creation date: 09-04-2009 * * XDoclet definition: * @struts.action validate="true" */public class ByqHoursDataAction extends DispatchAction {/* * Generated Methods *//** * Method execute * @param mapping * @param form * @param request * @param response * @return ActionForward */private ByqHhDataService service = null;public ByqHhDataService getService() {return service;}public void setService(ByqHhDataService service) {this.service = service;}//实现 日数据 小时数据的查询 和 日期的前一天和后一天的移动来查询数据public ActionForward selectByqHoursData(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response) {try {String option = request.getParameter("select");String byqid = request.getParameter("textByqid");SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");String text1 = request.getParameter("text1");String text2 = request.getParameter("text2");Date time1 = format.parse(text1+" 00:00:00");Date time2 = format.parse(text2+" 23:59:59");//日数据if("0".equals(option)||option=="0"){List<ByqDayData> byqDayList = service.selectbyq_Day(byqid, time1, time2);request.setAttribute("text1", text1);request.setAttribute("text2", text2);request.setAttribute("list", byqDayList);return mapping.findForward("day");}//小时数据if("1".equals(option)||option=="1"){List<ByqHhData> byqHourslist = service.selectbyq_Hours(byqid, time1, time2);request.setAttribute("text1", text1);request.setAttribute("text2", text2);request.setAttribute("byqHourslist", byqHourslist);return mapping.findForward("Hours");}} catch (ParseException e) {e.printStackTrace();}return null;}}

shwoByqHoursData.jsp 页面源代码:

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><%@taglib uri="https://java.sun.com/jsp/jstl/core" prefix="c"%><%@ taglib prefix="bean" uri="/WEB-INF/struts-bean.tld"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html> <head> <title>变压器小时数据</title> <link href="/go.html?url=css/common.css" mce_href="/go.html?url=css/common.css" rel="stylesheet" type="text/css" /> <mce:style type="text/css"><!--ing{border:0;}A{ font-size:12px;}A:hover{ font-size:12px; text-decoration:underline; color:#ff7000;}td{ font-size:12px; line-height:20px;}--></mce:style><style type="text/css" mce_bogus="1">ing{border:0;}A{ font-size:12px;}A:hover{ font-size:12px; text-decoration:underline; color:#ff7000;}td{ font-size:12px; line-height:20px;}</style><mce:script type="text/javascript" src="js/calendar.js" mce_src="js/calendar.js"></mce:script><!-- 前一天|后一天 --><mce:script type="text/javascript" src="My97DatePicker/WdatePicker.js" mce_src="My97DatePicker/WdatePicker.js"></mce:script><!-- 日期选择 --> </head> <mce:script type="text/javascript"><!-- //这个进行前一天和后一天的时间的变化 然后在查询function beforeday1(obj){beforeday(obj);document.getElementById("myform").submit();} // --></mce:script> <body> <h2 align="center"><strong> 变压器小时数据查询结果</strong></h2> <form action="byqHoursData.do?method=selectByqHoursData" name="myform" method="post" id="myform" onsubmit="return selectDayandHours2()"> <table border="1" bordercolor="#99CCFF" cellpadding="0" cellspacing="0" width="100%"> <thead> <tr bgcolor="#FFCCFF"> <td width="35%" align="center" class="tab-row"><strong>起始日期:</strong> <input name="text1" type="text" id="text1" value="${text1}" class="Wdate" onclick="new WdatePicker(this,null,false,'whyGreen')" style="width:150px;" height="18" readonly="readonly"/> </td> <td width="30%"><strong>结束日期:</strong> <input name="text2" type="text" id="text2" value="${text2}" class="Wdate" onclick="new WdatePicker(this,null,false,'whyGreen')" style="width:150px;" height="18" readonly="readonly"/> </td> <td width="42%"><div> <select name="select" id="select" style="width:80"> <option value="1">小时数据</option> </select>            <input type="submit" class="buttons" id="sbtn2" name="sbtn2" value="查 询">      <a href="/go.html?url=javascript:beforeday1(-1)" mce_href="/go.html?url=javascript:beforeday1(-1)">《前一天 </a>| <a href="/go.html?url=javascript:beforeday1(1)" mce_href="/go.html?url=javascript:beforeday1(1)">后一天 》</a> <a href="/go.html?url=javascript:AutomateExcel();" mce_href="/go.html?url=javascript:AutomateExcel();"> <img src="images/chartlogo.gif" mce_src="images/chartlogo.gif" width="16" height="16" border="0"></a> </div> </td> </tr> </thead> <tfoot> </tfoot> </table> <c:if test="${empty byqHourslist}"> <h2 align="center"><strong>对不起！没有找到您需要的数据！</strong></h2> </c:if> <c:if test="${!empty byqHourslist}"> <table width="100%" border="1" bordercolor="#99CCFF" cellpadding="0" cellspacing="0"> <tr bgcolor="#FFCCFF" align="center"> <td rowspan="2"> </td> <td rowspan="2">名称</td> <td rowspan="2">时间</td> <td rowspan="2">有功表码 </td> <td rowspan="2">无功表码</td> <td rowspan="2">有功功率</td> <td rowspan="2">无功功率</td> <td colspan="3">电压</td> <td colspan="3">电流</td> </tr> <tr bgcolor="#FFCCFF" align="center"> <td>A相</td> <td>B相</td> <td>C相</td> <td>A相</td> <td>B相</td> <td>C相</td> </tr> <c:set var="i" value="0"></c:set> <c:forEach items="${byqHourslist}" var="byqhours"> <c:set var="i" value="${i+1}"></c:set> <tr align="center"> <td>${i}</td> <td> ${byqhours.id.gatherid} <input type="hidden" id="textByqid" name="textByqid" value="${byqhours.id.gatherid}"> </td> <td><bean:write format="yyyy-MM-dd HH:mm" name="byqhours" property="id.ddate" /></td> <td>${byqhours.psum}</td> <td>${byqhours.npsum}</td> <td>${byqhours.powervalue}</td> <td>${byqhours.unpowervalue}</td> <td>${byqhours.avoltage}</td> <td>${byqhours.bvoltage}</td> <td>${byqhours.cvoltage}</td> <td>${byqhours.acurr}</td> <td>${byqhours.bcurr}</td> <td>${byqhours.ccurr}</td> </tr> </c:forEach></table></c:if></form> </body></html>

 

 

 首先引入calendar.js文件,js文件源代码如下:

//这个方法用来进行日期的前一天和后一天的移动function beforeday(obj){/** *获取日期文本框的值将获取到得值赋值给变量**/var starthidden=document.getElementById("text1").value;var endhidden=document.getElementById("text2").value;/** *正则匹配日期**/var reg = /^(/d{4})-(/d{1,2})-(/d{1,2})/;/** *如果传入的值为1 将日期加上一天 *如果传入的值为-1 将日期加减去一天**/if(obj==1){//alert("1=="+obj);//给开始日期赋值if(reg.test(starthidden)){ //调用进行日期的加减的方法dateAdd var d = dateAdd(RegExp.$1,RegExp.$2,RegExp.$3,1); starthidden=d.getFullYear()+"-"+(d.getMonth()+1)+"-"+d.getDate(); document.getElementById("text1").value=starthidden; //alert("text1赋值后的值为："+starthidden);}//给结束日期赋值if(reg.test(endhidden)){ //调用进行日期的加减的方法dateAdd var d = dateAdd(RegExp.$1,RegExp.$2,RegExp.$3,1); endhidden=d.getFullYear()+"-"+(d.getMonth()+1)+"-"+d.getDate(); document.getElementById("text2").value=endhidden; //alert("text2赋值后的值为："+endhidden);}}else{//alert("-1=="+obj);if(reg.test(starthidden)){ //调用进行日期的加减的方法dateAdd var d = dateAdd(RegExp.$1,RegExp.$2,RegExp.$3,-1); starthidden=d.getFullYear()+"-"+(d.getMonth()+1)+"-"+d.getDate(); document.getElementById("text1").value=starthidden; //alert("text1赋值后的值为："+starthidden);}if(reg.test(endhidden)){ //调用进行日期的加减的方法dateAdd var d = dateAdd(RegExp.$1,RegExp.$2,RegExp.$3,-1); endhidden=d.getFullYear()+"-"+(d.getMonth()+1)+"-"+d.getDate(); document.getElementById("text2").value=endhidden; //alert("text2赋值后的值为："+endhidden);}}}//这个方法用来进行日期的加减function dateAdd(y,m,d,n){ var d = new Date(y,m-1,d); d.setDate(d.getDate()+n); return d;}

ByqHoursDataAction类源代码:

import java.text.ParseException;import java.text.SimpleDateFormat;import java.util.Calendar;import java.util.Date;import java.util.List;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.apache.struts.action.ActionForm;import org.apache.struts.action.ActionForward;import org.apache.struts.action.ActionMapping;import org.apache.struts.actions.DispatchAction;import com.mww.biz.ByqHhDataService;import com.mww.entity.ByqDayData;import com.mww.entity.ByqHhData;/** * MyEclipse Struts * Creation date: 09-04-2009 * * XDoclet definition: * @struts.action validate="true" */public class ByqHoursDataAction extends DispatchAction {/* * Generated Methods *//** * Method execute * @param mapping * @param form * @param request * @param response * @return ActionForward */private ByqHhDataService service = null;public ByqHhDataService getService() {return service;}public void setService(ByqHhDataService service) {this.service = service;}//实现 日数据 小时数据的查询 和 日期的前一天和后一天的移动来查询数据public ActionForward selectByqHoursData(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response) {try {String option = request.getParameter("select");String byqid = request.getParameter("textByqid");SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");String text1 = request.getParameter("text1");String text2 = request.getParameter("text2");Date time1 = format.parse(text1+" 00:00:00");Date time2 = format.parse(text2+" 23:59:59");//日数据if("0".equals(option)||option=="0"){List<ByqDayData> byqDayList = service.selectbyq_Day(byqid, time1, time2);request.setAttribute("text1", text1);request.setAttribute("text2", text2);request.setAttribute("list", byqDayList);return mapping.findForward("day");}//小时数据if("1".equals(option)||option=="1"){List<ByqHhData> byqHourslist = service.selectbyq_Hours(byqid, time1, time2);request.setAttribute("text1", text1);request.setAttribute("text2", text2);request.setAttribute("byqHourslist", byqHourslist);return mapping.findForward("Hours");}} catch (ParseException e) {e.printStackTrace();}return null;}}

shwoByqHoursData.jsp 页面源代码:

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><%@taglib uri="https://java.sun.com/jsp/jstl/core" prefix="c"%><%@ taglib prefix="bean" uri="/WEB-INF/struts-bean.tld"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html> <head> <title>变压器小时数据</title> <link href="/go.html?url=css/common.css" mce_href="/go.html?url=css/common.css" rel="stylesheet" type="text/css" /> <mce:style type="text/css"><!--ing{border:0;}A{ font-size:12px;}A:hover{ font-size:12px; text-decoration:underline; color:#ff7000;}td{ font-size:12px; line-height:20px;}--></mce:style><style type="text/css" mce_bogus="1">ing{border:0;}A{ font-size:12px;}A:hover{ font-size:12px; text-decoration:underline; color:#ff7000;}td{ font-size:12px; line-height:20px;}</style><mce:script type="text/javascript" src="js/calendar.js" mce_src="js/calendar.js"></mce:script><!-- 前一天|后一天 --><mce:script type="text/javascript" src="My97DatePicker/WdatePicker.js" mce_src="My97DatePicker/WdatePicker.js"></mce:script><!-- 日期选择 --> </head> <mce:script type="text/javascript"><!-- //这个进行前一天和后一天的时间的变化 然后在查询function beforeday1(obj){beforeday(obj);document.getElementById("myform").submit();} // --></mce:script> <body> <h2 align="center"><strong> 变压器小时数据查询结果</strong></h2> <form action="byqHoursData.do?method=selectByqHoursData" name="myform" method="post" id="myform" onsubmit="return selectDayandHours2()"> <table border="1" bordercolor="#99CCFF" cellpadding="0" cellspacing="0" width="100%"> <thead> <tr bgcolor="#FFCCFF"> <td width="35%" align="center" class="tab-row"><strong>起始日期:</strong> <input name="text1" type="text" id="text1" value="${text1}" class="Wdate" onclick="new WdatePicker(this,null,false,'whyGreen')" style="width:150px;" height="18" readonly="readonly"/> </td> <td width="30%"><strong>结束日期:</strong> <input name="text2" type="text" id="text2" value="${text2}" class="Wdate" onclick="new WdatePicker(this,null,false,'whyGreen')" style="width:150px;" height="18" readonly="readonly"/> </td> <td width="42%"><div> <select name="select" id="select" style="width:80"> <option value="1">小时数据</option> </select>            <input type="submit" class="buttons" id="sbtn2" name="sbtn2" value="查 询">      <a href="/go.html?url=javascript:beforeday1(-1)" mce_href="/go.html?url=javascript:beforeday1(-1)">《前一天 </a>| <a href="/go.html?url=javascript:beforeday1(1)" mce_href="/go.html?url=javascript:beforeday1(1)">后一天 》</a> <a href="/go.html?url=javascript:AutomateExcel();" mce_href="/go.html?url=javascript:AutomateExcel();"> <img src="images/chartlogo.gif" mce_src="images/chartlogo.gif" width="16" height="16" border="0"></a> </div> </td> </tr> </thead> <tfoot> </tfoot> </table> <c:if test="${empty byqHourslist}"> <h2 align="center"><strong>对不起！没有找到您需要的数据！</strong></h2> </c:if> <c:if test="${!empty byqHourslist}"> <table width="100%" border="1" bordercolor="#99CCFF" cellpadding="0" cellspacing="0"> <tr bgcolor="#FFCCFF" align="center"> <td rowspan="2"> </td> <td rowspan="2">名称</td> <td rowspan="2">时间</td> <td rowspan="2">有功表码 </td> <td rowspan="2">无功表码</td> <td rowspan="2">有功功率</td> <td rowspan="2">无功功率</td> <td colspan="3">电压</td> <td colspan="3">电流</td> </tr> <tr bgcolor="#FFCCFF" align="center"> <td>A相</td> <td>B相</td> <td>C相</td> <td>A相</td> <td>B相</td> <td>C相</td> </tr> <c:set var="i" value="0"></c:set> <c:forEach items="${byqHourslist}" var="byqhours"> <c:set var="i" value="${i+1}"></c:set> <tr align="center"> <td>${i}</td> <td> ${byqhours.id.gatherid} <input type="hidden" id="textByqid" name="textByqid" value="${byqhours.id.gatherid}"> </td> <td><bean:write format="yyyy-MM-dd HH:mm" name="byqhours" property="id.ddate" /></td> <td>${byqhours.psum}</td> <td>${byqhours.npsum}</td> <td>${byqhours.powervalue}</td> <td>${byqhours.unpowervalue}</td> <td>${byqhours.avoltage}</td> <td>${byqhours.bvoltage}</td> <td>${byqhours.cvoltage}</td> <td>${byqhours.acurr}</td> <td>${byqhours.bcurr}</td> <td>${byqhours.ccurr}</td> </tr> </c:forEach></table></c:if></form> </body></html>

 

 

 首先引入calendar.js文件,js文件源代码如下:

//这个方法用来进行日期的前一天和后一天的移动function beforeday(obj){/** *获取日期文本框的值将获取到得值赋值给变量**/var starthidden=document.getElementById("text1").value;var endhidden=document.getElementById("text2").value;/** *正则匹配日期**/var reg = /^(/d{4})-(/d{1,2})-(/d{1,2})/;/** *如果传入的值为1 将日期加上一天 *如果传入的值为-1 将日期加减去一天**/if(obj==1){//alert("1=="+obj);//给开始日期赋值if(reg.test(starthidden)){ //调用进行日期的加减的方法dateAdd var d = dateAdd(RegExp.$1,RegExp.$2,RegExp.$3,1); starthidden=d.getFullYear()+"-"+(d.getMonth()+1)+"-"+d.getDate(); document.getElementById("text1").value=starthidden; //alert("text1赋值后的值为："+starthidden);}//给结束日期赋值if(reg.test(endhidden)){ //调用进行日期的加减的方法dateAdd var d = dateAdd(RegExp.$1,RegExp.$2,RegExp.$3,1); endhidden=d.getFullYear()+"-"+(d.getMonth()+1)+"-"+d.getDate(); document.getElementById("text2").value=endhidden; //alert("text2赋值后的值为："+endhidden);}}else{//alert("-1=="+obj);if(reg.test(starthidden)){ //调用进行日期的加减的方法dateAdd var d = dateAdd(RegExp.$1,RegExp.$2,RegExp.$3,-1); starthidden=d.getFullYear()+"-"+(d.getMonth()+1)+"-"+d.getDate(); document.getElementById("text1").value=starthidden; //alert("text1赋值后的值为："+starthidden);}if(reg.test(endhidden)){ //调用进行日期的加减的方法dateAdd var d = dateAdd(RegExp.$1,RegExp.$2,RegExp.$3,-1); endhidden=d.getFullYear()+"-"+(d.getMonth()+1)+"-"+d.getDate(); document.getElementById("text2").value=endhidden; //alert("text2赋值后的值为："+endhidden);}}}//这个方法用来进行日期的加减function dateAdd(y,m,d,n){ var d = new Date(y,m-1,d); d.setDate(d.getDate()+n); return d;}

ByqHoursDataAction类源代码:

import java.text.ParseException;import java.text.SimpleDateFormat;import java.util.Calendar;import java.util.Date;import java.util.List;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.apache.struts.action.ActionForm;import org.apache.struts.action.ActionForward;import org.apache.struts.action.ActionMapping;import org.apache.struts.actions.DispatchAction;import com.mww.biz.ByqHhDataService;import com.mww.entity.ByqDayData;import com.mww.entity.ByqHhData;/** * MyEclipse Struts * Creation date: 09-04-2009 * * XDoclet definition: * @struts.action validate="true" */public class ByqHoursDataAction extends DispatchAction {/* * Generated Methods *//** * Method execute * @param mapping * @param form * @param request * @param response * @return ActionForward */private ByqHhDataService service = null;public ByqHhDataService getService() {return service;}public void setService(ByqHhDataService service) {this.service = service;}//实现 日数据 小时数据的查询 和 日期的前一天和后一天的移动来查询数据public ActionForward selectByqHoursData(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response) {try {String option = request.getParameter("select");String byqid = request.getParameter("textByqid");SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");String text1 = request.getParameter("text1");String text2 = request.getParameter("text2");Date time1 = format.parse(text1+" 00:00:00");Date time2 = format.parse(text2+" 23:59:59");//日数据if("0".equals(option)||option=="0"){List<ByqDayData> byqDayList = service.selectbyq_Day(byqid, time1, time2);request.setAttribute("text1", text1);request.setAttribute("text2", text2);request.setAttribute("list", byqDayList);return mapping.findForward("day");}//小时数据if("1".equals(option)||option=="1"){List<ByqHhData> byqHourslist = service.selectbyq_Hours(byqid, time1, time2);request.setAttribute("text1", text1);request.setAttribute("text2", text2);request.setAttribute("byqHourslist", byqHourslist);return mapping.findForward("Hours");}} catch (ParseException e) {e.printStackTrace();}return null;}}

shwoByqHoursData.jsp 页面源代码:

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><%@taglib uri="https://java.sun.com/jsp/jstl/core" prefix="c"%><%@ taglib prefix="bean" uri="/WEB-INF/struts-bean.tld"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html> <head> <title>变压器小时数据</title> <link href="/go.html?url=css/common.css" mce_href="/go.html?url=css/common.css" rel="stylesheet" type="text/css" /> <mce:style type="text/css"><!--ing{border:0;}A{ font-size:12px;}A:hover{ font-size:12px; text-decoration:underline; color:#ff7000;}td{ font-size:12px; line-height:20px;}--></mce:style><style type="text/css" mce_bogus="1">ing{border:0;}A{ font-size:12px;}A:hover{ font-size:12px; text-decoration:underline; color:#ff7000;}td{ font-size:12px; line-height:20px;}</style><mce:script type="text/javascript" src="js/calendar.js" mce_src="js/calendar.js"></mce:script><!-- 前一天|后一天 --><mce:script type="text/javascript" src="My97DatePicker/WdatePicker.js" mce_src="My97DatePicker/WdatePicker.js"></mce:script><!-- 日期选择 --> </head> <mce:script type="text/javascript"><!-- //这个进行前一天和后一天的时间的变化 然后在查询function beforeday1(obj){beforeday(obj);document.getElementById("myform").submit();} // --></mce:script> <body> <h2 align="center"><strong> 变压器小时数据查询结果</strong></h2> <form action="byqHoursData.do?method=selectByqHoursData" name="myform" method="post" id="myform" onsubmit="return selectDayandHours2()"> <table border="1" bordercolor="#99CCFF" cellpadding="0" cellspacing="0" width="100%"> <thead> <tr bgcolor="#FFCCFF"> <td width="35%" align="center" class="tab-row"><strong>起始日期:</strong> <input name="text1" type="text" id="text1" value="${text1}" class="Wdate" onclick="new WdatePicker(this,null,false,'whyGreen')" style="width:150px;" height="18" readonly="readonly"/> </td> <td width="30%"><strong>结束日期:</strong> <input name="text2" type="text" id="text2" value="${text2}" class="Wdate" onclick="new WdatePicker(this,null,false,'whyGreen')" style="width:150px;" height="18" readonly="readonly"/> </td> <td width="42%"><div> <select name="select" id="select" style="width:80"> <option value="1">小时数据</option> </select>            <input type="submit" class="buttons" id="sbtn2" name="sbtn2" value="查 询">      <a href="/go.html?url=javascript:beforeday1(-1)" mce_href="/go.html?url=javascript:beforeday1(-1)">《前一天 </a>| <a href="/go.html?url=javascript:beforeday1(1)" mce_href="/go.html?url=javascript:beforeday1(1)">后一天 》</a> <a href="/go.html?url=javascript:AutomateExcel();" mce_href="/go.html?url=javascript:AutomateExcel();"> <img src="images/chartlogo.gif" mce_src="images/chartlogo.gif" width="16" height="16" border="0"></a> </div> </td> </tr> </thead> <tfoot> </tfoot> </table> <c:if test="${empty byqHourslist}"> <h2 align="center"><strong>对不起！没有找到您需要的数据！</strong></h2> </c:if> <c:if test="${!empty byqHourslist}"> <table width="100%" border="1" bordercolor="#99CCFF" cellpadding="0" cellspacing="0"> <tr bgcolor="#FFCCFF" align="center"> <td rowspan="2"> </td> <td rowspan="2">名称</td> <td rowspan="2">时间</td> <td rowspan="2">有功表码 </td> <td rowspan="2">无功表码</td> <td rowspan="2">有功功率</td> <td rowspan="2">无功功率</td> <td colspan="3">电压</td> <td colspan="3">电流</td> </tr> <tr bgcolor="#FFCCFF" align="center"> <td>A相</td> <td>B相</td> <td>C相</td> <td>A相</td> <td>B相</td> <td>C相</td> </tr> <c:set var="i" value="0"></c:set> <c:forEach items="${byqHourslist}" var="byqhours"> <c:set var="i" value="${i+1}"></c:set> <tr align="center"> <td>${i}</td> <td> ${byqhours.id.gatherid} <input type="hidden" id="textByqid" name="textByqid" value="${byqhours.id.gatherid}"> </td> <td><bean:write format="yyyy-MM-dd HH:mm" name="byqhours" property="id.ddate" /></td> <td>${byqhours.psum}</td> <td>${byqhours.npsum}</td> <td>${byqhours.powervalue}</td> <td>${byqhours.unpowervalue}</td> <td>${byqhours.avoltage}</td> <td>${byqhours.bvoltage}</td> <td>${byqhours.cvoltage}</td> <td>${byqhours.acurr}</td> <td>${byqhours.bcurr}</td> <td>${byqhours.ccurr}</td> </tr> </c:forEach></table></c:if></form> </body></html>