📄 project_user.jsp
字号:
<%@ page language="java" import="java.sql.*,com.statistics.util.*" pageEncoding="GB18030"%>
<%
String dbPath=request.getRealPath("/common/");
%>
<%
Connection conn = null;
conn = DB.getConn(dbPath);
Statement stmt = conn.createStatement();
String sql = "select project.pname,module.mname,person.person_name,project.pid,module.mid,person.person_id from person,module,project,per_pro_mod where project.pid = per_pro_mod.pid and module.mid = per_pro_mod.mid and per_pro_mod.person_id = person.person_id order by project.pid";
ResultSet rs = DB.getRs(stmt,sql);
%>
<!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>
<td class="rd6">人员编号</td>
</tr>
<%
Statement stmt5 = conn.createStatement();
int i = 1;
int j = 1;
String sqlPerson = "select person_name from per_pro_mod,person where pid = " + i + "and mid = " + j + "and person.person_id = per_pro_mod.person_id";
System.out.println(sqlPerson);
ResultSet rsPerson = DB.getRs(stmt5,sqlPerson);
while(rsPerson.next()){
System.out.println(rsPerson.getString(1));
}
while(rs.next()){
%>
<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.getInt(4) %></td>
<td class="rd8"><%=rs.getInt(5) %></td>
<td class="rd8"><%=rs.getInt(6) %></td>
</tr>
<%}
DB.close(rs);
DB.close(stmt);
DB.close(conn);
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -