📄
字号:
范例manager_meeting_delete.jsp源代码：
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>会务删除</title>
012</head>
013<body>
014<center>
015 <font size=5 color=blue>删除会务</font>
016</center>
017<hr>
018<%
019try
020 {
021 String num = request.getParameter("num");
022 if (pool.getConnectionSize() == 0)
023 {
024 pool.initializePool();
025 }
026 Connection con = null;
027 Statement stmt = null;
028 con = pool.getConnection();
029 stmt= con.createStatement();
030 String strDel ="delete from meeting where num="+num;
031 stmt.executeUpdate(strDel);
032 strDel = "delete from meetingperson where num="+num;
033 stmt.executeUpdate(strDel);
034 stmt.close();//关闭Statement对象
035 pool.releaseConnection(con);
036 response.sendRedirect("manager_meeting.jsp");
037 }
038 catch (Exception e)
039 {
040 out.println(e.getMessage());
041 }
042 %>
043</body>
044</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -