📄 savepost.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="err.jsp" %>
<jsp:useBean id="yy" scope="page" class="yy.jdbc"/>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<%!String sql,Note_Singid,Note_Title,Note_Content,Note_Icon,Note_Signid,Board_id,Return_Id;%>
<%
Note_Tile=request.getParameter("title");
Note_Title=yy.ex_chinese(Note_Title);
Note_Content=request.getParameter("content");
Note_Content=yy.ex_chinese(Note_Content);
Note_Icon=request.getParameter("iocn");
Note_Singid=request.getParameter("singid");
Board_Id=request.getParameter("fid");
Return_Id=request.getParameter("returnid");
if(Return_Id.toString().equals("null"))
Return_Id="0";
//帖子标题或内容不能为空
if(Note_Title.equals("")||Note_Content.equals(""))
{
response.sendRedirect("err.jsp?id=1");
}else
{
Connection con=yy.getConn();
Statement stmt=con.createStatement();
if(Return_Id!="0"){
sql="update Card set Reply_Time=Reply_Times+1 where Card_Id="+Return_Id;
stmt.executeUpdate(sql);
sql="update Forum set Card_Quantity=Card_Quantiry+1,latest_User='"+session.getValue("UserName")+"',latest_Time='"+yy.getTime()+"'where Forum_Id="+Board_Id;
stmt.executeUpdate(sql);
}
else{
sql="update Fprum set Card_Quantity=Card_Quantity+1,latest_User='"+session.getValue("UserName")+"',Title='"+yy.getTime()+"'where Forum_Id="+Board_Id;
stmt.executeUpdate(sql);
}
sql="update Users set SC_Times=SC_Times+1 where User_Name='"+session.getValue("UserName")+"'";
stmt.executeUpdate(sql);
sql="insert into Card(Board_Id,Reply_Id,Card_Name,Card_Content,Create_Time,Card_Author,Card_Length,Show_Sign,Card_Image,IP,Reply_User,Reply_Time)";
sql=sql+"values("+Board_Id+","+Return_Id+",'"+Note_Title+"','"+Note_Content+"','"+yy.getTime()+"','"+session.getValue("UserName")+"',"+Note_Content.length()+","+Note_Singid+",'"+Note_Icon+"','"+request.getRemoteHost()+"','"+session.getValue("UserName")+"','"+yy.getTime()+"')";
stmt.executeUpdate(sql);
if(Return_Id=="0")
{
%>
<font size=2 color="blue">您的帖子发表成功，正在处理您的信息，稍后自动返回
</font><meta http-equiv='refresh' content='2;url=board.jsp?fid=<%=Board_Id%>'>
<%
}
else
{
%>
<font size=2 color="blue">您的帖子发表成功，正在处理您的信息，稍后自动返回
</font><meta http-equiv='refresh' content='2;url=shownote.jsp?fid=<%=Board_Id%>¬eid=<%=Return_Id%>'>
<%
}
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -