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 + -
显示快捷键?