📄
字号:
范例manager_meeting_addext.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<%
015 String meeting_num = request.getParameter("meeting_num");
016 String meeting_title = new
017 String(request.getParameter("meeting_title").getBytes("8859_1"));
018 String begin_year = request.getParameter("beginyear");
019 String begin_month = request.getParameter("beginmonth");
020 String begin_day = request.getParameter("beginday");
021 String end_year = request.getParameter("endyear");
022 String end_month = request.getParameter("endmonth");
023 String end_day = request.getParameter("endday");
024 String place = new String( request.getParameter("place").getBytes("8859_1"));
025 String touch_man = new
026 String( request.getParameter("touch_man").getBytes("8859_1"));
027 String touch_tel = new
028 String( request.getParameter("touch_tel").getBytes("8859_1"));
029 String touch_address = new
030 String( request.getParameter("touch_address").getBytes("8859_1"));
031 String touch_email = new
032 String( request.getParameter("touch_email").getBytes("8859_1"));
033 String remark=new String( request.getParameter("remark").getBytes("8859_1"));
034 String begin_time=begin_year+"-"+begin_month+"-"+begin_day;
035 String end_time=end_year+"-"+end_month+"-"+end_day;
036 try
037 {
038 if (pool.getConnectionSize() == 0)
039 {
040 pool.initializePool();
041 }
042 Connection con = null;
043 Statement stmt = null;
044 con = pool.getConnection();
045 stmt= con.createStatement();
046 String strAdd = "insert into meeting(num,title,begin_time,end_time,
047 place,touch_man,touch_tel,touch_address,remark,touch_email)
048 values("+meeting_num+",'"+meeting_title+"','"+begin_time+"','"+end_time+"'
049 '"+place+"','"+touch_man+"','"+touch_tel+"','"+touch_address+"',
050 ,'"+remark+"','"+touch_email+"')";
051 out.println(strAdd);
052 stmt.executeUpdate(strAdd);
053 stmt.close();//关闭Statement对象
054 pool.releaseConnection(con);
055 response.sendRedirect("manager_meeting.jsp");
056 }
057 catch (Exception e)
058 {
059 out.println(e.getMessage());
060 }
061 %>
062</body>
063</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -