📄 workjiluaddresult.jsp
字号:
<%@ page language="java" import="java.util.*" contentType="text/html; charset=GBK"%>
<%@ taglib uri="http://java.sun.com/jstl/sql_rt" prefix="sql"%>
<%@ taglib uri="http://java.sun.com/jstl/core_rt" prefix="c"%>
<%--连接数据库 --%>
<sql:setDataSource driver="net.sourceforge.jtds.jdbc.Driver" url="jdbc:jtds:sqlserver://localhost:1433/db_oa" user="sa" password="sa" var="conn" />
<%--获得总行数 --%>
<sql:query var="workjiluCount" dataSource="${conn}">
select count(*) as c from WorkJiLuTable
</sql:query>
<%--循环取出总行数 --%>
<c:forEach items="${workjiluCount.rows}" var="row">
<c:set var="maxRowcount" value="${row.c}" scope="page"></c:set>
</c:forEach>
<%String path = request.getContextPath();
int maxPagecount = 0;
int maxRowcount2 = Integer.parseInt(pageContext.getAttribute(
"maxRowcount").toString());
//根据总行数 maxRowcount2 计算总页数 maxPagecount
if (maxRowcount2 % 3 == 0) {
maxPagecount = maxRowcount2 / 3;
} else {
maxPagecount = (maxRowcount2 - (maxRowcount2 % 3)) / 3 + 1;
}
int currPageNum = 1;
//判断是否是第一次，不是则进入
if (request.getParameter("currPageNum") != null) {
currPageNum = Integer.parseInt(request
.getParameter("currPageNum"));
if (currPageNum < 1) {
currPageNum = 1;
} else if (currPageNum > maxPagecount) {
currPageNum = maxPagecount;
}
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>
工作管理主菜单
</title>
<LINK rel="stylesheet" type="text/css" href="<%=path%>/css/style_2.css">
</head>
<body>
<br>
<form action="">
<table border=0 cellpadding=0 cellspacing=0 width="100%">
<tr>
<td align="center">
<c:if test="${!empty user_rights}">
<c:choose>
<c:when test="${!empty user_rights.id13 }">
<a href="<%=path%>/jsp/workJiLuSelect.jsp" target="mainName">
工作记录查询
</a>
</c:when>
<c:otherwise>
工作记录查询
</c:otherwise>
</c:choose>
</c:if>
<c:if test="${!empty user_rights}">
<c:choose>
<c:when test="${!empty user_rights.id14 }">
<a href="<%=path%>/jsp/workJiLuAdd.jsp" target="mainName">
新工作记录
</a>
</c:when>
<c:otherwise>
新工作记录
</c:otherwise>
</c:choose>
</c:if>
<c:if test="${!empty user_rights}">
<c:choose>
<c:when test="${!empty user_rights.id15 }">
<a href="<%=path%>/jsp/workJinDuSelect.jsp" target="mainName">
工作进度查询
</a>
</c:when>
<c:otherwise>
工作进度查询
</c:otherwise>
</c:choose>
</c:if>
<c:if test="${!empty user_rights}">
<c:choose>
<c:when test="${!empty user_rights.id15 }">
<a href="<%=path%>/jsp/workJinDuAdd.jsp" target="mainName">
工作进度安排
</a></c:when>
<c:otherwise>
工作进度安排
</c:otherwise>
</c:choose>
</c:if>
</td>
<td>
<div align="center">
<img src="../images/face/selectAll.gif"" width="16" height="16">
<c:if test="${!empty user_rights}">
<c:choose>
<c:when test="${!empty user_rights.id15 }">
<a href="<%=path%>/jsp/workTongJiSelect.jsp" target="mainName">
统计
</a></c:when>
<c:otherwise>
统计
</c:otherwise>
</c:choose>
</c:if>
</div>
</td>
<td>
<div align="right">
<img src="../images/Manual35.gif" width="16" height="16">
<a href="#" onClick="window.print()" target="bottomFrame">
打印
</a>
</div>
</td>
</tr>
</table>
<hr size=1 color="#0099CC">
<table bgcolor="#FFFFFF" border=1 cellpadding=0 cellspacing=0 width="100%" bordercolor="#FFFFFF" bordercolordark="#EEF2F9" bordercolorlight="#FFFFFF">
<tr>
<td height="24" colspan=7 align="left">
<p>
工作管理>>工作记录管理
</p>
</td>
</tr>
</table>
<%int countnum = maxRowcount2 - (currPageNum - 1) * 3;
%>
<sql:query var="workjilu" dataSource="${conn}">
select top 3 * from (select top <%=countnum%> * from WorkJiLuTable a order by a.id desc ) b order by b.id asc
</sql:query>
<TABLE width="100%" border="1" cellspacing="0" cellpadding="0"
bordercolor="#FFFFFF" bordercolordark="#ffffff"
bordercolorlight="#EEF2F9">
<TR bgcolor="#EEF2F9">
<td width="70" align="center">
员工名称
</td>
<td width="70" align="center">
部门名称
</td>
<td align="center">
提交时间
</td>
<td align="center">
完成情况
</td>
<td align="center">
完成期限
</td>
<td align="center">
计划类型
</td>
</TR>
<c:forEach var="row" items="${workjilu.rows}">
<tr align="center">
<td width="70" align="center">
<a href='<%=path %>/jsp/workJiLuSelectWithIDResult.jsp?jiluID=${row["id"]}' target="bottomFrame">
<c:out value='${row["Ename"]}' />
</a>
</td>
<td width="70" align="center">
<c:out value='${row["Bname"]}' />
</td>
<td width="70" align="center">
<c:out value='${row["DateTimes"]}' />
</td>
<td width="70" align="center">
<c:out value='${row["PalnThing"]}' />
</td>
<td width="70" align="center">
<c:out value='${row["Numday"]}' />
</td>
<td width="70" align="center">
<c:out value='${row["PalnType"]}' />
</td>
</tr>
</c:forEach>
<tr bgcolor="#EEF2F9">
<td align="right" colspan="3">
<a href="<%=path%>/jsp/workJiLuAddResult.jsp?currPageNum=<%=currPageNum - 1%>">
<img src="<%=path%>/images/1-prev.gif" width="70" height="11" border="0">
</a>
</td>
<td align="left" colspan="3">
<a href="<%=path%>/jsp/workJiLuAddResult.jsp?currPageNum=<%=currPageNum + 1%>">
<img src="<%=path%>/images/1-next.gif" width="70" height="11" border="0">
</a>
</td>
</tr>
</TABLE>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -