📄 manager_meeting_addext.jsp
字号:
<%@page contentType="text/html;charset=Gb2312"
import="java.sql.*,java.util.Date"%>
<jsp:useBean id="pool" scope="application" class="com.PoolBean"/>
<%
String strLoginUser = (String)session.getAttribute("LoginUser");
if (strLoginUser == null || strLoginUser.length() == 0)
response.sendRedirect("Login.jsp");
%>
<html>
<head>
<title>会务添加</title>
</head>
<body>
<%
String meeting_num = request.getParameter("meeting_num");
String meeting_title = new
String(request.getParameter("meeting_title").getBytes("8859_1"));
String begin_year = request.getParameter("beginyear");
String begin_month = request.getParameter("beginmonth");
String begin_day = request.getParameter("beginday");
String end_year = request.getParameter("endyear");
String end_month = request.getParameter("endmonth");
String end_day = request.getParameter("endday");
String place= new
String( request.getParameter("place").getBytes("8859_1"));
String touch_man = new
String( request.getParameter("touch_man").getBytes("8859_1"));
String touch_tel = new
String( request.getParameter("touch_tel").getBytes("8859_1"));
String touch_address = new
String( request.getParameter("touch_address").getBytes("8859_1"));
String touch_email = new
String( request.getParameter("touch_email").getBytes("8859_1"));
String remark=new String( request.getParameter("remark").getBytes("8859_1"));
String begin_time=begin_year+"-"+begin_month+"-"+begin_day;
String end_time=end_year+"-"+end_month+"-"+end_day;
try
{
if (pool.getConnectionSize() == 0)
{
pool.initializePool();
}
Connection con = null;
Statement stmt = null;
con = pool.getConnection();
stmt= con.createStatement();
String strAdd = "insert into meeting(num,title,begin_time,end_time,place,touch_man,touch_tel,touch_address,remark,touch_email) values('"+meeting_num+"','"+meeting_title+"','"+begin_time+"','"+end_time+"','"+place+"','"+touch_man+"','"+touch_tel+"','"+touch_address+"','"+remark+"','"+touch_email+"')";
stmt.executeUpdate(strAdd);
stmt.close();//关闭Statement对象
pool.releaseConnection(con);
response.sendRedirect("manager_meeting.jsp");
}
catch (Exception e)
{
out.println(e.getMessage());
}
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -