📄 do_msg.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java"%>
<jsp:useBean id="databean" scope="session" class="ConnBean.conn" />
<%@ page import="java.sql.*"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.util.Vector"%>
<%@ page import="cart.buyList"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>留言</title>
</head>
<body>
<%
String username = (String) session.getAttribute("user");
String sql1 = "select * from userinfo where UserName='" + username + "'";
ResultSet rs1 = databean.executeQuery(sql1);
if (rs1.next()) {
String id = rs1.getString("UserID");
String title = request.getParameter("title");
String time = request.getParameter("time");
String text = request.getParameter("text");
String sql = "insert into leaveword(UserID,LeaverName,LeaverTime,Context,LeaverTitle) values('"
+ id
+ "','"
+ username
+ "','"
+ time
+ "','"
+ text
+ "','"
+ title
+ "')";
int temp = databean.executeUpdate(sql);
if (temp > 0) {
out
.println("<script language='javascript'>alert('留言成功，请及时查看回复。');window.location.href='message.jsp';</script>");
} else {
out
.println("<script language='javascript'>alert('留言失败');history.back();</script>");
}
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -