📄 replayok.jsp
字号:
<%@ page language="java" contentType="text/html; charset=gbk" %>
<%@ page import="java.sql.*" %>
<%
request.setCharacterEncoding("gbk");
%>
<%
int id = Integer.parseInt(request.getParameter("id"));
int rootid = Integer.parseInt(request.getParameter("rootid"));
String title = request.getParameter("title");
String cont = request.getParameter("cont");
title = title.trim();
cont = cont.trim();
if (title.equals("")) {
out.println("标题不能为空!");
return;
}
if (cont.equals("")) {
out.println("内容不能为空！");
return;
}
cont = cont.replaceAll("\n", "<br>");
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:MySQL://localhost/bbs?user=root&password=yuanshuai");
conn.setAutoCommit(false);
Statement st = conn.createStatement();
PreparedStatement ps = conn.prepareStatement("insert into article values (null,?,?,?,?, now(), 0)");
ps.setInt(1, id);
ps.setInt(2, rootid);
ps.setString(3, title);
ps.setString(4, cont);
ps.executeUpdate();
st.executeUpdate("update article set isleaf=1 where id="+id);
conn.commit();
conn.setAutoCommit(true);
st.close();
ps.close();
conn.close();
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<title>感谢您的回复</title>
</head>
<body text="red">
<center>
<h2>感谢您的回复</h2>
<table border="5">
<tr><td align="left"><font color="blue">你回复的主题是:</font></td><td><%=title %></td></tr>
<tr><td align="left"><font color="green">你回复的内容是:</font></td><td><%=cont %></td></tr>
</table>
<p>页面会在10秒钟后自动跳转到留言板，如果没有自动进行<p>
请手动点击些处<a href="ShowArticleTree.jsp">返回</a>
</center>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -