📄 addgood.jsp
字号:
<%-- 斑竹增添文章到精华区 --%>
<html>
<head>
<title>加入精华</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="bbs.css">
</head>
<body bgcolor="#FF9900">
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="OPDB" scope="page" class="database.OPDB" />
<%
OPDB.connection();
Connection conn =OPDB.getConn();
String id = request.getParameter("id");
String boardid = request.getParameter("boardid");
String manager = (String) session.getValue("manager");
String writename = OPDB.AsciiToChineseString(request.getParameter("writename"));
//设置精华标志
if (manager != null && boardid.equals(manager)) {
String sql = "update t_bbs set good = 1 where id = " + id;
OPDB.update(conn,sql);
//作者加经验值
String sql2 = "";
int i = writename.indexOf(OPDB.AsciiToChineseString("[会员]"));
if (i != -1) {
writename = writename.substring(0,i);
sql2 = "update t_bbs_user set experience = experience + 10 where username = '" + writename + "' and usertype = 'Y'";
}
else {
sql2 = "update t_bbs_user set experience = experience + 10 where username = '" + writename + "' and usertype = 'N'";
}
OPDB.update(conn,sql2);
out.print("<p>该帖子已被加入精华区!!!</p>");
out.print("<a href=\"listgood.jsp?boardid="+boardid+"\" target=\"boardList\">去精华区</a> ");
out.print("<a href=\"javascript:window.close();\">关闭</a></p>");
}
else {
%>
<script language="javascript">
alert("您没有斑主权限，请登陆！");
window.location = "managerlogon.jsp"
</script>
<%
}
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -