📄 person_finish.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;
request.setCharacterEncoding("utf-8");
String pname = new String(request.getParameter("pname").getBytes(
"ISO8859-1"), "utf-8");
System.out.println(pname);
String person_name = new String(request.getParameter("person_name")
.getBytes("ISO8859-1"), "utf-8");
//System.out.println(person_name);
String sql = "select ps.person_name,p.pname,m.mname,ppm.person_start,ppm.person_end,ppm.person_finish,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 ";
if (!pname.equals("") && pname != null) {
sql += " and p.pname='" + pname + "'";
}
if (person_name != null && !person_name.equals("")) {
sql += " and ps.person_name='" + person_name + "'";
}
System.out.println(sql);
conn = DB.getConn(dbPath);
stmt = DB.getStmt(conn);
rs = DB.getRs(stmt, sql);
%>
<!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=<%=pname %>&person_name=<%=person_name %>" >已完成任务</a> |
<li style="float:left;"><a href="./person_unfinish.jsp?pname=<%=pname %>&person_name=<%=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="153" class="rd6">
开始时间
</td>
<td width="153" class="rd6">
结束时间
</td>
<td width="150" class="rd6">
删除
</td>
</tr>
<%
if(rs.next()){
rs.last();
totalRecords=rs.getRow();
//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;
if(count<=totalRecords){
while( i<=PAGE_SIZE && count<=totalRecords){
rs.absolute(count);
%>
<tr>
<td class="rd8">
<%=rs.getString(1)%>
</td>
<td class="rd8">
<%=rs.getString(2)%>
</td>
<td class="rd8">
<%=rs.getString(3)%>
</td>
<td class="rd8">
<%=rs.getDate(4)%>
</td>
<td class="rd8">
<%=rs.getDate(5)%>
</td>
<td class="rd6">
<a href="person_work_delete.jsp?id=<%=rs.getInt(7) %>&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_work.jsp?pageNo=1&pname=<%=pname %>&person_name=<%=person_name %>">首页</a></font>
<font color="#000000"><a href="person_work.jsp?pageNo=<%=pageNo-1 %>&pname=<%=pname %>&person_name=<%=person_name %>">上一页</a></font>
<font color="#000000"><a href="person_work.jsp?pageNo=<%=pageNo+1 %>&pname=<%=pname %>&person_name=<%=person_name %>">下一页</a></font>
<font color="#FF0000"><a href="person_work.jsp?pageNo=<%=totalPages %>&pname=<%=pname %>&person_name=<%=person_name %>">尾页</a></font>
</div>
</td>
</tr>
</table>
<%
}else{
%>
<tr>
<td class="rd8" colspan=7><font color=red>没有符合条件的数据</font></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 + -