📄 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 sql = "select SEQ_T_BBS.NEXTVAL as id from dual";
ResultSet rs = OPDB.select(conn,sql);
rs.next();
int id = rs.getInt("id");
rs.close();
String sql1 = "insert into t_bbs(id,topid,boardid,topic,name,text,txtlong,face,type,email,linktopic,linkurl) values("+id+","+id+","+boardid+",'"+topic+"','"+username+"','"+text2+"',"+txtlong+","+face+",'"+type+"','"+email+"','"+linktopic+"','"+linkurl+"')";
//out.print(sql1);
OPDB.insert(conn,sql1);
//经验值
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();
%>
<p>您的帖子已发表！现在您可以接着上传图片。图片格式为gif或jpg</p>
<FORM METHOD="POST" ACTION="upload.jsp?boardid=<%= boardid %>&id=<%= id %>" ENCTYPE="multipart/form-data">
<INPUT TYPE="FILE" NAME="upload" SIZE="50"><INPUT TYPE="submit" VALUE="图片上传" name="submit">
</FORM>
<p><a href="list.jsp?boardid=<%= boardid %>" target="boardList">刷新浏览</a> <a href="addnew.jsp?boardid=<%= boardid %>">继续发表</a></p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -