📄 meeting_person_list.jsp
字号:
<%@ page errorPage="ErrPage.jsp"
import="java.util.Date, java.sql.*"
contentType="text/html;charset=gb2312"%>
<jsp:useBean id="pool" scope="application" class="com.PoolBean"/>
<!--利用JAVABEAN连接数据库-->
<%
String strLoginUser = (String)session.getAttribute("LoginUser");
if (strLoginUser == null || strLoginUser.length() == 0)
response.sendRedirect("../Login.jsp");
%>
<HTML>
<HEAD>
<LINK REL="stylesheet" HREF="../littleproject.css" TYPE="text/css">
<TITLE>显示与会人员名单</TITLE>
</HEAD>
<BODY bgcolor=LightBlue>
<br>
<center>
<%
try
{
if (pool.getConnectionSize() == 0)
{
pool.initializePool();
}
Connection con = null;
Statement stmt = null;
ResultSet rs=null;
con = pool.getConnection();
stmt= con.createStatement();
//建立Statement对象, 并设置记录指标类型为可前后移动
String sql=null;
String num = request.getParameter("num");
//利用For循环配合PageSize属性输出一页中的记录
sql="select name,sex,duty,address,telephone,arrive_time,arrive_byway,leave_time,leave_byway,destination from meetingperson where num="+num;
rs = stmt.executeQuery(sql);
%>
<TABLE border=1 bordercolor=RoyalBlue bgcolor=LightBlue width=700>
<tr>
<td colspan="10" align="center" width="700">
<font size="5pt" face="隶书">与会人员名单</font>
</td>
</tr>
<tr>
<td width="100" align="center">姓 名</td>
<td width="100" align="center">性 别</td>
<td width="100" align="center">职 务</td>
<td width="300" align="center">联系地址</td>
<td width="100" align="center">联系电话</td>
<td width="100" align="center">到达时间</td>
<td width="100" align="center">到达方式</td>
<td width="100" align="center">离开时间</td>
<td width="100" align="center">离开方式</td>
<td width="100" align="center">去往地点</td>
</tr>
<%
while(rs.next())
{
String meeting_name=rs.getString("name");
String meeting_sex=rs.getString("sex");
String meeting_duty=rs.getString("duty");
String meeting_address=rs.getString("address");
String meeting_tel=rs.getString("telephone");
String meeting_arrive_time=rs.getString("arrive_time");
String meeting_arrive_byway=rs.getString("arrive_byway");
String meeting_leave_time=rs.getString("leave_time");
String meeting_leave_byway=rs.getString("leave_byway");
String meeting_destination=rs.getString("destination");
%>
<tr>
<td width="100" align="center"><%=meeting_name%></td>
<td width="100" align="center"><%=meeting_sex%></td>
<td width="100" align="center"><%=meeting_duty%></td>
<td width="300" align="center"><%=meeting_address%></td>
<td width="100" align="center"><%=meeting_tel%></td>
<td width="100" align="center"><%=meeting_arrive_time%></td>
<td width="100" align="center"><%=meeting_arrive_byway%></td>
<td width="100" align="center"><%=meeting_leave_time%></td>
<td width="100" align="center"><%=meeting_leave_byway%></td>
<td width="100" align="center"><%=meeting_destination%></td>
</tr>
<%
}
%>
</TABLE>
<br>
<a href="default.jsp">返回首页</a>
</CENTER>
<%
if (rs != null) rs.close();
pool.releaseConnection(con);
}
catch(Exception e)
{
System.out.println("Exception: " + e.getMessage());
}
%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -