📄 post.jsp
字号:
<%@ page pageEncoding="GB18030"%>
<%@ page import="java.sql.*,com.bjsxt.bbs.*"%>
<%
request.setCharacterEncoding("GBK");
String action = request.getParameter("action");
if (action != null && action.trim().equals("post")) {
String title = request.getParameter("title");
System.out.println(title);
String cont = request.getParameter("cont");
System.out.println(cont);
Connection conn = DB.getConn();
boolean autoCommit = conn.getAutoCommit();
conn.setAutoCommit(false);
int rootId = -1;
String sql = "insert into article values (null, ?, ?, ?, ?, now(), ?)";
PreparedStatement pstmt = DB.prepareStmt(conn, sql, Statement.RETURN_GENERATED_KEYS);
pstmt.setInt(1, 0);
pstmt.setInt(2, rootId);
pstmt.setString(3, title);
pstmt.setString(4, cont);
pstmt.setInt(5, 0);
pstmt.executeUpdate();
ResultSet rsKey = pstmt.getGeneratedKeys();
rsKey.next();
rootId = rsKey.getInt(1);
Statement stmt = DB.createStmt(conn);
stmt.executeUpdate("update article set rootid = " + rootId + " where id = " + rootId);
conn.commit();
conn.setAutoCommit(autoCommit);
DB.close(pstmt);
DB.close(stmt);
DB.close(conn);
response.sendRedirect("article.jsp");
}
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>发表新主题</title>
<meta http-equiv="content-type" content="text/html; charset=GBK">
<link rel="stylesheet" type="text/css" href="images/style.css"
title="Integrated Styles">
<script language="JavaScript" type="text/javascript"
src="images/global.js"></script>
<!-- fckeditor -->
<!-- 为了速度而没有使用fckeditor -->
<!-- end of fckeditor -->
<link rel="alternate" type="application/rss+xml" title="RSS"
href="http://bbs.chinajavaworld.com/rss/rssmessages.jspa?threadID=744236">
</head>
<body>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tbody>
<tr>
<td width="40%">
<img src="images/header-stretch.gif" alt="" border="0" height="57"
width="100%">
</td>
<td width="1%">
<img src="images/header-right.gif" alt="" height="57" border="0">
</td>
</tr>
</tbody>
</table>
<br>
<div id="jive-flatpage">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tbody>
<tr valign="top">
<td width="99%">
<p class="jive-breadcrumbs">
<a href="http://bbs.chinajavaworld.com/index.jspa">首页</a> »
<a
href="http://bbs.chinajavaworld.com/forumindex.jspa?categoryID=1">ChinaJavaWorld技术论坛|Java世界_中文论坛</a>
»
<a
href="http://bbs.chinajavaworld.com/category.jspa?categoryID=2">Java
2 Platform, Standard Edition (J2SE)</a> »
<a
href="http://bbs.chinajavaworld.com/forum.jspa?forumID=20&start=0">Java语言*初级版</a>
</p>
<p class="jive-page-title">
发表新主题
<br>
</p>
</td>
<td width="1%">
<div class="jive-accountbox"></div>
</td>
</tr>
</tbody>
</table>
<div class="jive-buttons">
<br>
</div>
<br>
<table border="0" cellpadding="0" cellspacing="0" width="930"
height="61">
<tbody>
<tr valign="top">
<td width="99%">
<div id="jive-message-holder">
<div class="jive-message-list">
<div class="jive-table">
<div class="jive-messagebox">
<form action="post.jsp" method="post">
<input type="hidden" name="action" value="post" />
标题：
<input type="text" name="title">
<br>
内容：
<textarea name="cont" rows="15" cols="80"></textarea>
<br>
<input type="submit" value="submit" />
</form>
</div>
</div>
</div>
<div class="jive-message-list-footer">
<br>
</div>
</div>
</td>
<td width="1%">
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -