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