📄 work_quantity.jsp
字号:
<%@ page language="java" import="java.util.*,java.sql.*,com.statastics.mimi.util.*,com.statistics.util.*" pageEncoding="GB18030"%>
<%
String dbPath=request.getRealPath("/common/");
%>
<%
Connection conn = null;
conn = DB.getConn(dbPath);
Statement stmt = conn.createStatement();
String sql = "select * from project";
ResultSet rs = DB.getRs(stmt,sql);
List<Project> projects = new ArrayList<Project>();
while(rs.next()){
Project p = new Project();
p.initFromRs(rs);
projects.add(p);
}
DB.close(rs);
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>项目工作量</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<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="./project_user.jsp" >项目人员列表</a> |
<li style="float:left;"><a href="./work_quantity.jsp" >项目信息列表</a> |
<ol>
</td>
</tr>
</table>
<hr width="100%" align="center" size=0>
</div>
<br>
<br>
<br>
<table border="1" align="center" width=80%>
<tr>
<td class="rd6">项目名称</td>
<td class="rd6">开始时间</td>
<td class="rd6">结束时间</td>
<td class="rd6">用时</td>
<td class="rd6">人员数目</td>
</tr>
<%
long timeSpan = 0;
for(Iterator<Project> it = projects.iterator();it.hasNext();){
Project p = it.next();
sql = "select count(*) from module where pid = " + p.getPid();
rs = DB.getRs(stmt,sql);
rs.next();
//System.out.println(p.getPstart().getTime());
if(p.isPfinish()){
timeSpan =p.getPend().getTime() - p.getPstart().getTime();
timeSpan = timeSpan/(24*60*60*1000);
//System.out.println(timeSpan);
%>
<tr>
<td class="rd8"><%=p.getPname() %></td>
<td class="rd8"><%=p.getPstart() %></td>
<td class="rd8"><%=p.getPend() %></td>
<td class="rd8"><%=timeSpan %>天</td>
<td class="rd8"><%=rs.getInt(1) %></td>
</tr>
<%
}else {
%>
<tr>
<td class="rd8"><%=p.getPname() %></td>
<td class="rd8"><%=p.getPstart() %></td>
<td class="rd8">未完成</td>
<td class="rd8">未完成</td>
<td class="rd8"><%=rs.getInt(1) %></td>
</tr>
<%
}
}
DB.close(rs);
DB.close(stmt);
DB.close(conn);
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -