📄 checkin_meeting_ext.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><h1>用户会议信息录入</h1></title>
</head>
<body>
<%
String num = request.getParameter("num");
String arrive_year = request.getParameter("arrive_year");
String arrive_month = request.getParameter("arrive_month");
String arrive_day = request.getParameter("arrive_day");
String arrive_byway =new String( request.getParameter("arrive_byway").getBytes("8859_1"));
String leave_year = request.getParameter("leave_year");
String leave_month = request.getParameter("leave_month");
String leave_day = request.getParameter("leave_day");
String leave_byway = new String(request.getParameter("leave_byway").getBytes("8859_1"));
String leave_destination= new String(request.getParameter("leave_destination").getBytes("8859_1"));
String user_name= new String(request.getParameter("user_name").getBytes("8859_1"));
String user_address=new String( request.getParameter("user_address").getBytes("8859_1"));
String user_tel = request.getParameter("user_tel");
String user_sex= new String(request.getParameter("user_sex").getBytes("8859_1"));
String user_duty = new String(request.getParameter("user_duty").getBytes("8859_1"));
String user_code = request.getParameter("user_code");
String user_email= request.getParameter("user_email");
String arrive_time=arrive_year+"-"+arrive_month+"-"+arrive_day;
String leave_time=leave_year+"-"+leave_month+"-"+leave_day;
try
{
if (pool.getConnectionSize() == 0)
{
pool.initializePool();
}
Connection con = null;
Statement stmt = null;
con = pool.getConnection();
stmt= con.createStatement();
String strAdd = "insert into meetingperson(num,name,sex,duty,address,telephone,arrive_time,arrive_byway,leave_time,leave_byway,destination,code,email) values("+num+",'"+user_name+"','"+user_sex+"','"+user_duty+"','"+user_address+"','"+user_tel+"','"+arrive_time+"','"+arrive_byway+"','"+leave_time+"','"+leave_byway+"','"+leave_destination+"','"+user_code+"','"+user_email+"')";
stmt.executeUpdate(strAdd);
stmt.close();//关闭Statement对象
pool.releaseConnection(con);
response.sendRedirect("meeting_detail.jsp?num="+num);
}
catch (Exception e)
{
out.println(e.getMessage());
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -