📄 person_work.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";
if (!"".equals(pname) && pname != null) {
sql += " and p.pname='" + pname + "'";
}
if (person_name != null && !"".equals(person_name)) {
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>
<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="rd8">
<%
if (rs.getInt(6) == 1) {
%>
<input type=checkbox checked disabled>
<%
} else {
%>
<input type=checkbox disabled>
<%
}
%>
</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>没有符合条件的数据</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 + -