📄 follow.jsp
字号:
<html>
<head>
<title>跟随发言</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="bbs.css">
</head>
<body bgcolor="#FFF9F0">
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="OPDB" scope="page" class="database.OPDB" />
<%
OPDB.connection();
Connection conn =OPDB.getConn();
String username = (String) session.getValue("username");
if (username == null) {
username = OPDB.AsciiToChineseString("过客");
}
int boardid = Integer.parseInt(request.getParameter("boardid"));
String topic = OPDB.AsciiToChineseString(request.getParameter("topic").trim());
topic = OPDB.replace(topic);
String text = OPDB.AsciiToChineseString(request.getParameter("text").trim());
String text2 = OPDB.replace(text,"\n","<br>");
text2 = OPDB.replace(text2);
int txtlong = text.length();
int face = Integer.parseInt(request.getParameter("face"));
String type = OPDB.AsciiToChineseString(request.getParameter("type").trim());
String email = request.getParameter("email").trim();
String linktopic = OPDB.AsciiToChineseString(request.getParameter("linktopic").trim());
linktopic = OPDB.replace(linktopic);
String linkurl = request.getParameter("linkurl").trim();
int topid = Integer.parseInt(request.getParameter("topid"));
int layer = Integer.parseInt(request.getParameter("layer"));
layer++;
int bbsorder = Integer.parseInt(request.getParameter("bbsorder"));
bbsorder++;
String writename = OPDB.AsciiToChineseString(request.getParameter("writename"));
String sql = "update t_bbs set bbsorder = bbsorder+1 where boardid = " + boardid + " and bbsorder >= " + bbsorder;
OPDB.update(conn,sql);
String sql1 = "insert into t_bbs(id,topid,boardid,topic,name,text,txtlong,face,type,layer,bbsorder) values(SEQ_T_BBS.NEXTVAL,"+topid+","+boardid+",'"+topic+"','"+username+"','"+text2+"',"+txtlong+","+face+",'"+type+"',"+layer+","+bbsorder+")";
OPDB.insert(conn,sql1);
if (OPDB.getSuccess()) {
// 发帖子,加3点经验
String sql2 = "";
int i = username.indexOf(OPDB.AsciiToChineseString("[会员]"));
if (i != -1) {
username = username.substring(0,i);
sql2 = "update t_bbs_user set experience = experience + 3 where username = '" + username + "' and usertype = 'Y'";
}
else {
sql2 = "update t_bbs_user set experience = experience + 3 where username = '" + username + "' and usertype = 'N'";
}
OPDB.update(conn,sql2);
// 被人跟帖,原作者加1点经验
String sql3 = "";
i = writename.indexOf(OPDB.AsciiToChineseString("[会员]"));
if (i != -1) {
writename = writename.substring(0,i);
sql3 = "update t_bbs_user set experience = experience + 1 where username = '" + writename + "' and usertype = 'Y'";
}
else {
sql3 = "update t_bbs_user set experience = experience + 1 where username = '" + writename + "' and usertype = 'N'";
}
OPDB.update(conn,sql3);
%>
<p>您的帖子已发表！</p>
<p><a href="list.jsp?boardid=<%= boardid %>" target="boardList">刷新浏览</a> <a href="addnew.jsp?boardid=<%= boardid %>">继续发表</a></p>
<%
}
OPDB.Close();
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -