📄 manager_meeting_person_right.jsp
字号:
<%@ page errorPage="ErrPage.jsp"
import="java.util.Date,java.sql.*,com.PoolBean"
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("../meeting/Login.jsp");
%>
<HTML>
<HEAD>
<LINK REL="stylesheet" HREF="../littleproject.css" TYPE="text/css">
<script language="javascript">
<!--
function isok()
{
alert(theform.clde1.value);
if(theform.code2.value=="");
{
alert("请您填写会议主题!");
theform.code.focus();
return(false);
}
return(false);
}
function MyOnClick(w)
{
alert(w);
}
function onClick()
{
parent.location.replace("../meeting/default.jsp");
}
-->
</script>
<title>会议人员管理</title>
</head>
<body bgcolor=LightBlue>
<br>
<center>
<%
try{
String num=request.getParameter("num");
int RowCout=0;
com.PoolBean pool=new com.PoolBean();
if(pool.getConnectionSize()==0)
{
pool.initializePool();
}
Connection con = null;
Statement stmt = null;
ResultSet rs=null;
con = pool.getConnection();
stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql=null;
sql="select code,name,duty,telephone from meetingperson where num="+num;
rs=stmt.executeQuery(sql);
%>
<table border=1 bordercolor=RoyalBlue bgcolor=LightBlue width=400>
<tr>
<td colspan="4" align="center" width="400">
<font size="4pt" face="隶书">参加会议人员名单<font>
</td>
<tr>
<td width=100 align=center>姓 名</td>
<td width=100 align=center>职 务</td>
<td width=150 align=center>联系电话</td>
<td bgcolor=LightYellow width=50 align=center></td>
</tr>
<%
while(rs.next())
{
String meeting_code=rs.getString("code");
String meeting_name=rs.getString("name");
String meeting_duty=rs.getString("duty");
String meeting_tel=rs.getString("telephone");
%>
<tr>
<td width=100 align=center><%=meeting_name%></td>
<td width=100 align=center><%=meeting_duty%></td>
<td width=150 align=center><%=meeting_tel%></td>
<td bgcolor=LightYellow width=50 align=center>
<a href="manager_meeting_person_right_del.jsp?code=<%=meeting_code%>&num=<%=num%>">删除</a>
</td>
</tr>
<%
}
%>
</table>
<br>
<input type="button" onClick="onClick()" value="退出">
</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 + -