📄 yearcount.jsp
字号:
%>
<tr>
<td class="common" align="center">5</td>
<td class="common" align="center"><%=work%></td>
<td class="common" align="center"><%=learn%></td>
<td class="common" align="center"><%=sport%></td>
<td class="common" align="center"><%=rest%></td>
</tr>
<%
work=0;learn=0;sport=0;rest=0;
//diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-06-01",year+"-06-31");
diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-06");
if(null!=diaryDateRecordSet){
//int num=diaryDateRecordSet.size();//新增
while(diaryDateRecordSet.next()){
workTime=diaryDateRecordSet.getDIA_workTime();
learnTime=diaryDateRecordSet.getDIA_learnTime();
sportTime=diaryDateRecordSet.getDIA_sportTime();
restTime=diaryDateRecordSet.getDIA_restTime();
work=work+Integer.parseInt(workTime.trim());
learn=learn+Integer.parseInt(learnTime.trim());
sport=sport+Integer.parseInt(sportTime.trim());
rest=rest+Integer.parseInt(restTime.trim());
}
iCount[0]=iCount[0]+work;
iCount[1]=iCount[1]+learn;
iCount[2]=iCount[2]+sport;
iCount[3]=iCount[3]+rest;
}
%>
<tr class="bgcolor">
<td class="common" align="center">6</td>
<td class="common" align="center"><%=work%></td>
<td class="common" align="center"><%=learn%></td>
<td class="common" align="center"><%=sport%></td>
<td class="common" align="center"><%=rest%></td>
</tr>
<%
work=0;learn=0;sport=0;rest=0;
//diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-07-01",year+"-07-31");
diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-07");
if(null!=diaryDateRecordSet){
//int num=diaryDateRecordSet.size();//新增
while(diaryDateRecordSet.next()){
workTime=diaryDateRecordSet.getDIA_workTime();
learnTime=diaryDateRecordSet.getDIA_learnTime();
sportTime=diaryDateRecordSet.getDIA_sportTime();
restTime=diaryDateRecordSet.getDIA_restTime();
work=work+Integer.parseInt(workTime.trim());
learn=learn+Integer.parseInt(learnTime.trim());
sport=sport+Integer.parseInt(sportTime.trim());
rest=rest+Integer.parseInt(restTime.trim());
}
iCount[0]=iCount[0]+work;
iCount[1]=iCount[1]+learn;
iCount[2]=iCount[2]+sport;
iCount[3]=iCount[3]+rest;
}
%>
<tr>
<td class="common" align="center">7</td>
<td class="common" align="center"><%=work%></td>
<td class="common" align="center"><%=learn%></td>
<td class="common" align="center"><%=sport%></td>
<td class="common" align="center"><%=rest%></td>
</tr>
<%
work=0;learn=0;sport=0;rest=0;
//diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-08-01",year+"-08-31");
diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-08");
if(null!=diaryDateRecordSet){
//int num=diaryDateRecordSet.size();//新增
while(diaryDateRecordSet.next()){
workTime=diaryDateRecordSet.getDIA_workTime();
learnTime=diaryDateRecordSet.getDIA_learnTime();
sportTime=diaryDateRecordSet.getDIA_sportTime();
restTime=diaryDateRecordSet.getDIA_restTime();
work=work+Integer.parseInt(workTime.trim());
learn=learn+Integer.parseInt(learnTime.trim());
sport=sport+Integer.parseInt(sportTime.trim());
rest=rest+Integer.parseInt(restTime.trim());
}
iCount[0]=iCount[0]+work;
iCount[1]=iCount[1]+learn;
iCount[2]=iCount[2]+sport;
iCount[3]=iCount[3]+rest;
}
%>
<tr class="bgcolor">
<td class="common" align="center">8</td>
<td class="common" align="center"><%=work%></td>
<td class="common" align="center"><%=learn%></td>
<td class="common" align="center"><%=sport%></td>
<td class="common" align="center"><%=rest%></td>
</tr>
<%
work=0;learn=0;sport=0;rest=0;
//diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-09-01",year+"-09-31");
diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-09");
if(null!=diaryDateRecordSet){
//int num=diaryDateRecordSet.size();//新增
while(diaryDateRecordSet.next()){
workTime=diaryDateRecordSet.getDIA_workTime();
learnTime=diaryDateRecordSet.getDIA_learnTime();
sportTime=diaryDateRecordSet.getDIA_sportTime();
restTime=diaryDateRecordSet.getDIA_restTime();
work=work+Integer.parseInt(workTime.trim());
learn=learn+Integer.parseInt(learnTime.trim());
sport=sport+Integer.parseInt(sportTime.trim());
rest=rest+Integer.parseInt(restTime.trim());
}
iCount[0]=iCount[0]+work;
iCount[1]=iCount[1]+learn;
iCount[2]=iCount[2]+sport;
iCount[3]=iCount[3]+rest;
}
%>
<tr>
<td class="common" align="center">9</td>
<td class="common" align="center"><%=work%></td>
<td class="common" align="center"><%=learn%></td>
<td class="common" align="center"><%=sport%></td>
<td class="common" align="center"><%=rest%></td>
</tr>
<%
work=0;learn=0;sport=0;rest=0;
//diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-10-01",year+"-10-31");
diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-10");
if(null!=diaryDateRecordSet){
//int num=diaryDateRecordSet.size();//新增
while(diaryDateRecordSet.next()){
workTime=diaryDateRecordSet.getDIA_workTime();
learnTime=diaryDateRecordSet.getDIA_learnTime();
sportTime=diaryDateRecordSet.getDIA_sportTime();
restTime=diaryDateRecordSet.getDIA_restTime();
work=work+Integer.parseInt(workTime.trim());
learn=learn+Integer.parseInt(learnTime.trim());
sport=sport+Integer.parseInt(sportTime.trim());
rest=rest+Integer.parseInt(restTime.trim());
}
iCount[0]=iCount[0]+work;
iCount[1]=iCount[1]+learn;
iCount[2]=iCount[2]+sport;
iCount[3]=iCount[3]+rest;
}
%>
<tr class="bgcolor">
<td class="common" align="center">10</td>
<td class="common" align="center"><%=work%></td>
<td class="common" align="center"><%=learn%></td>
<td class="common" align="center"><%=sport%></td>
<td class="common" align="center"><%=rest%></td>
</tr>
<%
work=0;learn=0;sport=0;rest=0;
//diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-11-01",year+"-11-31");
diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-11");
if(null!=diaryDateRecordSet){
//int num=diaryDateRecordSet.size();//新增
while(diaryDateRecordSet.next()){
workTime=diaryDateRecordSet.getDIA_workTime();
learnTime=diaryDateRecordSet.getDIA_learnTime();
sportTime=diaryDateRecordSet.getDIA_sportTime();
restTime=diaryDateRecordSet.getDIA_restTime();
work=work+Integer.parseInt(workTime.trim());
learn=learn+Integer.parseInt(learnTime.trim());
sport=sport+Integer.parseInt(sportTime.trim());
rest=rest+Integer.parseInt(restTime.trim());
}
iCount[0]=iCount[0]+work;
iCount[1]=iCount[1]+learn;
iCount[2]=iCount[2]+sport;
iCount[3]=iCount[3]+rest;
}
%>
<tr>
<td class="common" align="center">11</td>
<td class="common" align="center"><%=work%></td>
<td class="common" align="center"><%=learn%></td>
<td class="common" align="center"><%=sport%></td>
<td class="common" align="center"><%=rest%></td>
</tr>
<%
work=0;learn=0;sport=0;rest=0;
//diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-12-01",year+"-12-31");
diaryDateRecordSet=diaryManage.getDiaryDateByUser(userIDShow,year+"-12");
if(null!=diaryDateRecordSet){
//int num=diaryDateRecordSet.size();//新增
while(diaryDateRecordSet.next()){
workTime=diaryDateRecordSet.getDIA_workTime();
learnTime=diaryDateRecordSet.getDIA_learnTime();
sportTime=diaryDateRecordSet.getDIA_sportTime();
restTime=diaryDateRecordSet.getDIA_restTime();
work=work+Integer.parseInt(workTime.trim());
learn=learn+Integer.parseInt(learnTime.trim());
sport=sport+Integer.parseInt(sportTime.trim());
rest=rest+Integer.parseInt(restTime.trim());
}
iCount[0]=iCount[0]+work;
iCount[1]=iCount[1]+learn;
iCount[2]=iCount[2]+sport;
iCount[3]=iCount[3]+rest;
}
%>
<tr class="bgcolor">
<td class="common" align="center">12</td>
<td class="common" align="center"><%=work%></td>
<td class="common" align="center"><%=learn%></td>
<td class="common" align="center"><%=sport%></td>
<td class="common" align="center"><%=rest%></td>
</tr>
<tr>
<td class="common" align="center">总计</td>
<td class="common" align="center"><%=iCount[0]%></td>
<td class="common" align="center"><%=iCount[1]%></td>
<td class="common" align="center"><%=iCount[2]%></td>
<td class="common" align="center"><%=iCount[3]%></td>
</tr>
<%
avgWork=iCount[0]/12;
avgLearn=iCount[1]/12;
avgSport=iCount[2]/12;
avgRest=iCount[3]/12;
String strAvgWork=String.valueOf(avgWork);
String strAvgLearn=String.valueOf(avgLearn);
String strAvgSport=String.valueOf(avgSport);
String strAvgRest=String.valueOf(avgRest);
int iPos=strAvgWork.indexOf(".");
strAvgWork=strAvgWork.substring(0,iPos+2);
iPos=strAvgRest.indexOf(".");
strAvgRest=strAvgRest.substring(0,iPos+2);
iPos=strAvgLearn.indexOf(".");
strAvgLearn=strAvgLearn.substring(0,iPos+2);
iPos=strAvgSport.indexOf(".");
strAvgSport=strAvgSport.substring(0,iPos+2);
%>
<tr class="bgcolor">
<td class="common" align="center">平均</td>
<td class="common" align="center"><%=strAvgWork%></td>
<td class="common" align="center"><%=strAvgLearn%></td>
<td class="common" align="center"><%=strAvgSport%></td>
<td class="common" align="center"><%=strAvgRest%></td>
</tr>
<%
}
%>
</table>
</form>
<input name="button" type="button" onmouseover="this.className='button2'" onmouseout="this.className='button1'" class="button1" onClick="javascript:history.back(1);" value="返 回">
<br>
</td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -