📄
字号:
001<%@page contentType="text/html;charset=Gb2312"
002 import="Java.sql.*,Java.util.Date"%>
003<JSP:useBean id="pool" scope="application" class="com.PoolBean"/>
004<%
005String strLoginUser = (String)session.getAttribute("LoginUser");
006if (strLoginUser == null || strLoginUser.length() == 0)
007 response.sendRedirect("Login.jsp");
008%>
009<html>
010<head>
011 <title><h1>退出会议</h1></title>
012</head>
013<body>
014<center>
015 <font size=5 color=blue></font>退出会议</font>
016</center>
017<hr>
018<%
019String user_name="";
020String num = request.getParameter("num");
021String meeting_title = new
022String(request.getParameter("title").getBytes("8859_1"));
023try
024{
025 if (pool.getConnectionSize() == 0)
026 {
027 pool.initializePool();
028 }
029 Connection con = null;
030 Statement stmt = null;
031 ResultSet rs=null;
032 con = pool.getConnection();
033 stmt= con.createStatement();
034 if (strLoginUser != null && strLoginUser.length() != 0)
035 {
036 String sql="select name from user where code ='"+strLoginUser+"'";
037 rs = stmt.executeQuery(sql);
038 if(rs.next())
039 {
040 user_name=rs.getString("name");
041 }
042 }
043 String strDel ="delete from meetingperson where num="+ num+"
044 and name='"+user_name+"'";
045 stmt.executeUpdate(strDel);
046 stmt.close();//关闭Statement对象
047 pool.releaseConnection(con);
048 response.sendRedirect("default.jsp");
049}
050catch (Exception e)
051{
052 out.println(e.getMessage());
053}
054 %>
055</body>
056</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -