📄 workjinduaddresult.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="workjinduCount" dataSource="${conn}">
select count(*) as c from WorkJinDuTable
</sql:query>
<%--循环取出总行数 --%>
<c:forEach items="${workjinduCount.rows}" var="row">
<c:set var="maxRowcountd" value="${row.c}" scope="page"></c:set>
</c:forEach>
<%
String path = request.getContextPath();
int maxPagecount = 0;
int maxRowcount2 = Integer.parseInt(pageContext.getAttribute(
"maxRowcountd").toString());
//根据总行数 maxRowcount2 计算总页数 maxPagecount
if (maxRowcount2 % 3 == 0) {
maxPagecount = maxRowcount2 / 3;
} else {
maxPagecount = (maxRowcount2 - (maxRowcount2 % 3)) / 3 + 1;
}
int currPageNumd = 1;
//判断是否是第一次，不是则进入
if (request.getParameter("currPageNumd") != null) {
currPageNumd = Integer.parseInt(request
.getParameter("currPageNumd"));
if (currPageNumd < 1) {
currPageNumd = 1;
} else if (currPageNumd > maxPagecount) {
currPageNumd = 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 width="100%" border="1" cellspacing="0" cellpadding="0"
bordercolor="#FFFFFF" bordercolordark="#ffffff"
bordercolorlight="#EEF2F9">
<tr>
<td height="24" colspan=7 align="left">
<p>
工作管理>>工作进度管理
</p>
</td>
</tr>
</table>
<%
int countNum = maxRowcount2 - (currPageNumd - 1) * 3;
%>
<sql:query var="workjindu" dataSource="${conn}">
select top 3 * from (select top <%=countNum%> * from WorkJinDuTable 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>
<td width="20%" align="center">
员工名称
</td>
<td width="20%" align="center">
部门名称
</td>
<td width="20%" align="center">
工作标题
</td>
<td width="20%" align="center">
开始时间
</td>
<td width="20%" align="center">
结束时间
</td>
</TR>
<c:forEach var="row" items="${workjindu.rows}">
<tr>
<td width="20%" align="center">
<A
href='<%=path%>/jsp/workJinDuSelectWithIDResult.jsp?jinduID=${row["id"]}'
target="bottomFrame"> <c:out value='${row["Ename"]}'></c:out>
</A>
</td>
<td width="20%" align="center">
<c:out value='${row["Bname"]}'></c:out>
</td>
<td align="center">
<c:out value='${row["WorkTitle"]}'></c:out>
</td>
<td width="20%" align="center">
<c:out value='${row["BeginTime"]}'></c:out>
</td>
<td width="20%" align="center">
<c:out value='${row["EndTime"]}'></c:out>
</td>
</tr>
</c:forEach>
<tr>
<td align="right" colspan="3">
<a
href="<%=path%>/jsp/workJinDuAddResult.jsp?currPageNumd=<%=currPageNumd - 1%>">
<img src="<%=path%>/images/1-prev.gif" width="70" height="11"
border="0"> </a>
</td>
<td align="left" colspan="2">
<a
href="<%=path%>/jsp/workJinDuAddResult.jsp?currPageNumd=<%=currPageNumd + 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 + -