📄
字号:
范例checkin_meeting_ext.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><h1>用户会议信息录入</h1></title>
012</head>
013<body>
014<%
015String num = request.getParameter("num");
016String arrive_year = request.getParameter("arrive_year");
017String arrive_month = request.getParameter("arrive_month");
018String arrive_day = request.getParameter("arrive_day");
019String arrive_byway = request.getParameter("arrive_byway");
020String leave_year = request.getParameter("leave_year");
021String leave_month = request.getParameter("leave_month");
022String leave_day = request.getParameter("leave_day");
023String leave_byway = new
024String(request.getParameter("leave_byway").getBytes("8859_1"));
025String leave_destination= new
026String(request.getParameter("leave_destination").getBytes("8859_1"));
027String user_name= new
028String(request.getParameter("user_name").getBytes("8859_1"));
029String user_address= request.getParameter("user_address");
030String user_tel = request.getParameter("user_tel");
031String user_sex= request.getParameter("user_sex");
032String user_duty = new
033String(request.getParameter("user_duty").getBytes("8859_1"));
034String user_code = request.getParameter("user_code");
035String user_email= request.getParameter("user_email");
036String arrive_time=arrive_year+"-"+arrive_month+"-"+arrive_day;
037String leave_time=leave_year+"-"+leave_month+"-"+leave_day;
038try
039{
040 if (pool.getConnectionSize() == 0)
041{
042 pool.initializePool();
043}
044Connection con = null;
045Statement stmt = null;
046con = pool.getConnection();
047stmt= con.createStatement();
048 String strAdd = "insert into meetingperson(num,name,sex,duty,address,
049telephone,arrive_time,arrive_byway,leave_time,leave_byway,destination,code,
050email) values("+num+",'"+user_name+"','"+user_sex+"','"+user_duty+"',
051'"+user_address+"','"+user_tel+"','"+arrive_time+"','"+arrive_byway+"',
052'"+leave_time+"','"+leave_byway+"','"+leave_destination+"',
053'"+user_code+"','"+user_email+"')";
054stmt.executeUpdate(strAdd);
055 stmt.close();//关闭Statement对象
056 pool.releaseConnection(con);
057 response.sendRedirect("meeting_detail.jsp?num="+num);
058}
059catch (Exception e)
060{
061 out.println(e.getMessage());
062}
063 %>
064</body>
065</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -