📄 addnew_write.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);
text2 = OPDB.replace(text2,"\n","<br>");
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();
String sql1 = "insert into t_bbs(id,topid,boardid,topic,name,text,txtlong,face,type,email,linktopic,linkurl) values(SEQ_T_BBS.NEXTVAL,SEQ_T_BBS.CURRVAL,"+boardid+",'"+topic+"','"+username+"','"+text2+"',"+txtlong+","+face+",'"+type+"','"+email+"','"+linktopic+"','"+linkurl+"')";
OPDB.insert(conn,sql1);
%>
<p>您的帖子已发表！</p>
<p><a href="list.jsp?boardid=<%= boardid %>" target="boardList">刷新浏览</a> <a href="addnew.jsp?boardid=<%= boardid %>">继续发表</a></p>
<%
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);
OPDB.Close();
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -