do_msg.jsp
来自「java + sqlserver2000编写的一个网上购书系统,实现了一些基本的」· JSP 代码 · 共 52 行
JSP
52 行
<%@ 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 + =
减小字号Ctrl + -
显示快捷键?