📄 update_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) {
out.print("连接已中断!");
}
int id = Integer.parseInt(request.getParameter("id"));
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(text,"\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 boardid = request.getParameter("boardid");
String sql1 = "update t_bbs set topic='"+topic+"',text='"+text2+"',txtlong="+txtlong+",face="+face+",type='"+type+"',email='"+email+"',linktopic='"+linktopic+"',linkurl='"+linkurl+"' where id="+id;
//out.print(sql1);
OPDB.update(conn,sql1);
%>
<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 + -