📄 showdatail.jsp
字号:
<html>
<head>
<meta http-equiv=Content-Type content="text/html;charset=gb2312">
<title>显示文章内容</title>
</head>
<body bgcolor="pink">
<%@ page import="java.io.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<jsp:useBean id="bbsdb" scope="page" class="bbs.Bbsdb"/>
<%
String sn=null;
sn=request.getParameter("SerialNum");
if (sn==null)
sn="";
int num=o;
String snum=null;
snum=request.getParameter("Num");
int rnum=bbsdb.getRowNum("ever_user WHERE UID IN (SELECT UID FROM current_user WHERE SerialNum=\'"+sn+"\')");
if (rnum==0)
{
%>
您的帐号已经过期，请重新登录！<br>
<%
}
else
{
if (snum==null)
{
%>
<center><font size="6" color="purple">
欢迎进入本论坛!
</font></center>
<%
}
else
{
Integer tmpInt=new Integer(snum);
num=tmpInt.intValue();
ResultSet rs=null;
String sql=null;
String uid=null;
int howmany=0;
sql="SELECT * FROM ever_user WHERE UID IN(SELECT UID FROM current_user WHERE SerialNum=\'"+sn+"\')";
rs=bbsdb.executeQuery(sql);
while (rs.next())
{
uid=rs.getString("UID");
howmany=rs.getInt("HowMany");
}
rs.close();
howmany++;
sql="UPDATE ever_user SET HowMany= "+howmany+"WHERE UID=\'"+uid+"\'";
bbsdb.executeUpdate(sql);
sql="SELECT * FROM details WHERE Num="+num;
rs=bbs.executeQuery(sql);
int visittimes=0;
String duid=null;
String theme=null;
String email=null;
String date=null;
String homepage=null;
String content=null;
String child=null;
while (rs.next())
{
duid=rs.getString("UID");
visittimes=rs.getInt("VisitTimes");
theme=bbsdb.native2unicode(rs.getString("Theme"));
email=rs.getString("Email");
date=rs.getString("DateAndTime");
content=bbsdb.native2unicode(rs.getString("Content"));
child=rs.getString("Child");
}
rs.close();
visittimes++;
sql="UPDATE ever_user SET VisitTimes= "+visittimes+"WHERE Num="+num;
bbsdb.executeUpdate(sql);
%>
<table border="2" width="100%" cellspacing="4" height="163">
<tr>
<td width="100%" height="17">
<font color="#FF0080" face="隶书"><big>
文章标题:<b><%=theme%>
</b></big></font>
</td>
</tr>
<%
if (email==null)
{
%>
<tr>
<td width="100%" height="17">
<font color="#FF0080" face="隶书"><big>
文章作者 :<b><%=duid%>
</b></big></font>
</td>
</tr>
<%
}
else
{
%>
<tr>
<td width="100%" height="17">
<font color="#FF0080" face="隶书"><big>
文章作者 :<a href="mailto:<%=email%>"><b><%=duid%></a>
</big></font>
</td>
</tr>
<%
}
%>
<tr>
<td width="100%" height="17">
<font color="#FF0080" face="隶书"><big>
发表时间 :<%=date%>
</big></font>
</td>
</tr>
<%
if (homepage!=null)
{
%>
<tr>
<td width="100%" height="21">
<font color="#FF0080" face="隶书"><big>
个人主页 :<a href="<%=homepage%>"><%=homepage%></a>
</big></font>
</td>
</tr>
<%
}
%>
<tr>
<td width="100%" height="-1">
<%=content%>
</td>
</tr>
<%
if ((child!=null)&&(!child.equals("0")))
{
%>
<tr>
<td height="8">
<font color="#FF0080" face="隶书"><big>
已有回复:
</big></font>
</td>
</tr>
<tr>
<td width="100%" height="-1">
<bbsdb.showchild("<%=duid%>")>
</td>
</tr>
<%
}
%>
</table>
<p>
<font color="#0000FF" face="隶书">
<big><big><strong>
请回复:
</strong></big></big>
</font></p>
<form method="post" action="save.jsp">
<input type="hidden" name="parentid" value="<%=num%>">
<input type="hidden" name="SerialNum" value="<%=sn%>">
<p>
<font color="#FF0000" face="隶书">
<big>
主题：
</big></font>
<input type="text" name="Theme" size="50" value="RE:<%=THEME%>style="background-color:RGB(192,192,192);color:RGB(128,0,0)">
<br>
<font color="#FF0000" face="隶书">
<big>
内容:
</big></font>
<br>
<textarea rows="8" name="Content" cols="50" style="background-color:RGB(192,192,192);color:RGB(128,0,0)">
</textarea>
</p>
<p>
<input type="submit" name="B1" value="Submit">
<input type="reset" name="B2" value="Reset">
</form>
<%
}
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -