📄 save.jsp
字号:
<html>
<head>
<meta http-equiv=Content-Type content="text/html;charset=gb2312">
<title>保存文章</title>
</head>
<%@ page import="java.io.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<jsp:useBean id="bbsdb" scope="page" class="bbs.Bbsdb"/>
<body bgcolor="pink">
<%
String sn=null;
sn=request.getParameter("SerialNum");
if (sn==null)
sn="";
String content=null;
content=bbsdb.native2nuicode(request.getParameter("Content"));
if (content==null)
content="";
ResultSet rs=null;
String sql=null;
String uid=null;
String email=null;
String homepage=null;
String argu="";
String theme=bbsdb.native2unicode(request.getParameter("Theme"));
String parentid=request.getParameter("parentid");
if (theme==null)
theme="";
if (parentid==null)
parentid="";
if (theme.equals(""))
{
if (parentid.equals(""))
argu="";
else
argu="?parentid="+parentid;
%>
<p>
<font color="#FF0000" face="隶书">
<big><big><strong>
请输入新文章:
</strong></big></big>
</font></p>
<form method="post" action="save.jsp<%=argu%>">
<input type="hidden" name="SerialNum" value="<%=sn%>">
<p>
<big>
<font face="隶书" color="#FF00FF">
请输入文章主题:
</font>
<strong><font color="#FF00FF">:
</font><strong>
<input type="text" name="Theme" size="31" style=style="background-color:RGB(192,192,192);color:RGB(128,0,0)">
<br>
<font face="隶书" color="#FF00FF">
请输入文章内容
</font>
<strong><font color="#FF00FF">:
</font></strong>
<textarea rows="10" name="Content" cols="50" style="background-color:RGB(192,192,192);color:RGB(128,0,0)">
</textarea>
<br>
<p>
<input type="Submit" value="发表" name="B1">
<input type="Reset" value="取消" name="B2">
</P>
</form>
<%
out.close();
}
int rnum=bbsdb.getRowNum("ever_user WHERE UID IN (SELECT * FROM current_user WHERE SerialNum=\'"+sn+"\')");
if (rnum==0)
{
%>
<font color="purple" size="5">您还没有注册过，请选注册新用户进入!
</font><br>
<%
out.close();
}
else
{
sql="SELECT * FROM ever_user WHERE UID IN (SELECT UID FROM current_user WHERE SerialNum=\'"+sn+"\')";
rs=bbsdb.executeQuery(sql);
int essay=0;
while (rs.next())
{
uid=rs.getString("UID");
email=rs.getString("Email");
essay=rs.getInt("Essay");
homepage=rs.getString("HomePage");
}
rs.close();
essay++;
sql="UPDATE ever_user SET Essay="+essay+"WHERE UID =\'"+uid+"\'";
bbsdb.executeUpdate(sql);
}
String now=Calendar.getInstance().getTime().toString();
sql="INSERT INTO details(LEVELS,Child,UID,Email,Theme,DateAndTime,VALUES(1,\'0\',\'"+uid+"\',\'"+email+"\',\'"+theme+"\',\'"+now+"\',\'"+content.length()+"\',\'"+homepage+"\',\'"+content+"\');";
bbsdb.executeUpdate(sql);
if(!parentid.equals(""))
{
sql="SELECT * FROM details WHERE Num=\'"+parentid+"\'";
rs=bbsdb.executeQuery(sql);
String child=null;
int levels=0;
while (rs.next())
{
child=rs.getString("Child");
levels=rs.getInt("Levels");
}
rs.close();
levels++;
sql="UPDATE details SET Child=\'"+child+"\',Levels=\'"+levels+"\' WHERE Num= "+parentid;
bbsdb.executeUpdate(sql);
}
%>
<p><big>
<font face="隶书">
<a href="list.jsp?SerialNum="<%=sn%>" target="top">
及时刷新
</a>
</font>
</big>
</p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -