📄 person_time.jsp
字号:
<%@ page language="java" pageEncoding="utf-8"%>
<%@ page import="com.statistics.util.*"%>
<%@ page import="java.sql.*"%>
<%
String dbPath=request.getRealPath("/common/");
%>
<%
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
final int PAGE_SIZE = 4;
int pageNo = 1;
int totalRecords = 0;
int count = 0;
int totalPages=0;
String strPageNo = request.getParameter("pageNo");
//System.out.println(strPageNo);
if (strPageNo != null && !strPageNo.trim().equals("")) {
try {
pageNo = Integer.parseInt(strPageNo);
} catch (NumberFormatException e) {
pageNo = 1;
}
}
if (pageNo <= 0)
pageNo = 1;
String sql="select ps.person_name,p.pname,m.mname,(ppm.person_end-ppm.person_start) as a,ppm.id " ;
sql+="from per_pro_mod ppm ,project p,module m, person ps where ppm.pid=p.pid and ppm.mid=m.mid and ppm.person_id=ps.person_id and ppm.person_finish=1";
System.out.println(sql);
conn = DB.getConn(dbPath);
stmt = DB.getStmt(conn);
rs = DB.getRs(stmt, sql);
System.out.println(rs);
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB18030">
<title></title>
<link rel="stylesheet" href="../css/all.css">
</head>
<body>
<div align="center">
<table width="95%" border="0" cellspacing="0" cellpadding="0"
height="35">
<tr>
<td class="p1" height="20" align=center>
人员工作列表
</td>
</tr>
<tr>
<td class="p1" height="20" align=center class="p1">
<ol>
<li style="float:left;">
<a
href="./person_finish.jsp?pname=''&person_name=''">已完成任务</a> |
<li style="float:left;">
<a
href="./person_unfinish.jsp?pname=''&person_name=''">未完成任务</a> |
<li style="float:left;"><a href="./person_work_search.jsp">查询</a> |
<li style="float:left;"><a href="./person_time.jsp">人员工时表</a> |
<ol>
</td>
</tr>
</table>
<hr width="100%" align="center" size=0>
</div>
<table width="95%" height="20" border="0" align="center"
cellspacing="0" class="rd1" id="toolbar">
<tr>
<td width="49%" class="rd19">
<font color="#000000">查询列表</font>
</td>
<td width="27%" nowrap class="rd16">
<div align="right"></div>
</td>
</tr>
</table>
<table width="95%" border="1" cellspacing="0" cellpadding="0"
align="center" class="table1">
<tr>
<td width="119" class="rd6">
人员名称
</td>
<td width="119" class="rd6">
项目名称
</td>
<td width="152" class="rd6">
模块名称
</td>
<td width="150" class="rd6">
使用时间
</td>
<td width="150" class="rd6">
删除
</td>
</tr>
<%
if(rs.next()) {
rs.last();
//System.out.println(rs.getString(1)+","+rs.getString(2)+","+rs.getString(3)+","+rs.getInt(4)+","+rs.getInt(5));
totalRecords = rs.getRow();
rs.beforeFirst();
//rs.beforeFirst();
totalPages = (totalRecords + PAGE_SIZE - 1) / PAGE_SIZE;
if (pageNo > totalPages)
pageNo = totalPages;
count = (pageNo - 1) * PAGE_SIZE + 1;
//System.out.println(count+"---");
int i = 1;
long days=0;
if (count <= totalRecords) {
while (i <= PAGE_SIZE && count <= totalRecords) {
rs.absolute(count);
String person_name=rs.getString(1);
String pname=rs.getString(2);
String mname=rs.getString(3);
int time=rs.getInt(4);
int id=rs.getInt(5);
//System.out.println(rs.getString(1)+","+rs.getString(2)+","+rs.getString(3)+","+rs.getInt(4)+","+rs.getInt(5));
%>
<tr>
<td class="rd8">
<%=person_name%>
</td>
<td class="rd8">
<%=pname%>
</td>
<td class="rd8">
<%=mname%>
</td>
<td class="rd8">
<%=time%>天
</td>
<td class="rd6">
<a
href="person_work_delete.jsp?id=<%=id%>&pname=<%=pname%>&person_name=<%=person_name%>&pageNo=<%=pageNo%>">【删除】</a>
</td>
</tr>
<%
i++;
count++;
}
}
%>
</table>
<table width="95%" height="30" border="0" align="center"
cellpadding="0" cellspacing="0" class="rd1">
<tr>
<td nowrap class="rd19" height="2">
<div align="left">
<font color="#000000"> 共 <%=totalRecords%> 条数据</font>
<font color="#000000"> 共 <%=totalPages%> 页</font>
<font color="#000000">当前第</font> 
<font color="#FF0000"><%=pageNo%>
</font> 
<font color="#000000">页</font>
</div>
</td>
<td nowrap class="rd19">
<div align="right">
<font color="#000000"><a
href="person_time.jsp?pageNo=1">首页</a>
</font>
<font color="#000000"><a
href="person_time.jsp?pageNo=<%=pageNo - 1%>">上一页</a>
</font>
<font color="#000000"><a
href="person_time.jsp?pageNo=<%=pageNo + 1%>">下一页</a>
</font>
<font color="#FF0000"><a
href="person_time.jsp?pageNo=<%=totalPages%>">尾页</a>
</font>
</div>
</td>
</tr>
</table>
<%
}else{
%>
<tr>
<td class="rd8" colspan=7>没有符合条件的数据</td>
</tr>
</table>
<%
}
%>
<p>
</p>
<%
DB.close(rs);
DB.close(stmt);
DB.close(conn);
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -