📄 checkasp.jsp
字号:
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.text.*"%>
<%@ include file="../inc/ftbbstohtml.jsp"%>
<%@ include file="../inc/conn.jsp"%>
<%!String jibie,touxian,siteurl;%>
<%
String BoardID_1,BoardID_2,bbs_img,bbs_img_display,title,zhiye,htmfilename,postnum,BBS_Cate_Name1,BBS_Cate_Name2,BBS_Cate_Manager_Name,postuser,File;
String clubuser_reg_date,img,signname,reg_date,reuser_id;
ResultSet rs,rs1,rs2,rs3,rs6,rs7;
int jingyuan,tili,reid;
String pid = request.getParameter("id");
String TitleID=request.getParameter("id");
String Sql_kind="select * from config where kind=1 order by id asc";
Statement stmt02=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs7=stmt02.executeQuery(Sql_kind);
if(rs7.next()){
siteurl=rs7.getString("content");
}
Statement stmt01=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql2="update bbstitle set hit=hit+1 where id="+pid;
stmt01.executeUpdate(sql2);
String sql="select * from bbstitle where id='"+pid+"' order by bbstop desc,redate";
rs=stmt.executeQuery(sql);
rs.next();
BoardID_1=rs.getString("BoardID_1");
BoardID_2=rs.getString("BoardID_2");
bbs_img=rs.getString("bbs_img");
bbs_img_display=rs.getString("bbs_img_display");
title=rs.getString("title");
zhiye=rs.getString("zhiye");
htmfilename=rs.getString("htmfilename");
postnum=rs.getString("postnum");
//rs.close();
String str="select BBS_Cate_Name,BBS_Cate_Manager_Name from BBS_Cate where BBS_Cate_ID='"+BoardID_1+"'";
Statement stmt1=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs1=stmt1.executeQuery(str);
rs1.next();
BBS_Cate_Name1=rs1.getString("BBS_Cate_Name"); //一级类别名称
BBS_Cate_Manager_Name=rs1.getString("BBS_Cate_Manager_Name"); //一级类别板主姓名
String sqlstr="select BBS_Cate_Name,BBS_Cate_Manager_Name from BBS_Cate where BBS_Cate_ID='"+BoardID_2+"'";
Statement stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs2=stmt2.executeQuery(sqlstr);
rs2.next();
BBS_Cate_Name2=rs2.getString("BBS_Cate_Name"); //二级类别名称
BBS_Cate_Manager_Name=rs2.getString("BBS_Cate_Manager_Name"); //二级类别板主姓名
String str1="select * from clubuser where clubuser_name='"+rs.getString("name")+"'";
Statement stmt3=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs3=stmt3.executeQuery(str1);
if(rs3.next())
{
jingyuan=rs3.getInt("jingyuan");
tili=rs3.getInt("tili");
img=rs3.getString("userimg");
clubuser_reg_date=rs3.getString("clubuser_reg_date");
signname=htmln(rs3.getString("signname"));
if(signname==null){
signname="你还没有签名，可以从修改资料中加入自已的签名";
}
}
else
{
jingyuan=0;
tili=100;
img="cache5.gif";
signname="你还没有签名，可以从修改资料中加入自已的签名";
}
if(jingyuan<=50)
{
touxian="小野人";
}
if(jingyuan>50&&jingyuan<=150)
{
touxian="野人";
}
if(jingyuan>150&&jingyuan<=500)
{
touxian="土人";
}
if(jingyuan>500&&jingyuan<=1000)
{
touxian="咕噜";
}
if(jingyuan>1000&&jingyuan<=2000)
{
touxian="大咕噜";
}
if(jingyuan>2000&&jingyuan<=4000)
{
touxian="咕噜队长";
}
if(jingyuan>4000&&jingyuan<=8000)
{
touxian="初级守卫";
}
if(jingyuan>8000&&jingyuan<=10000)
{
touxian="守卫队长";
}
if(jingyuan>10000&&jingyuan<=11000)
{
touxian="斗士";
}
if(jingyuan>11000&&jingyuan<=12000)
{
touxian="大斗士";
}
if(jingyuan>12000&&jingyuan<=14000)
{
touxian="斗士长";
}
if(jingyuan>14000&&jingyuan<=16000)
{
touxian="骑士";
}
if(jingyuan>16000&&jingyuan<=18000)
{
touxian="青铜骑士";
}
if(jingyuan>18000&&jingyuan<=20000)
{
touxian="白银骑士";
}
if(jingyuan>20000&&jingyuan<=22000)
{
touxian="黄金骑士";
}
if(jingyuan>22000&&jingyuan<=24000)
{
touxian="圣骑士";
}
if(jingyuan>24000&&jingyuan<=26000)
{
touxian="神秘头衔";
}
if(jingyuan>26000&&jingyuan<=28000)
{
touxian="神秘头衔";
}
if(jingyuan>28000)
{
touxian="神秘头衔";
}
if(jingyuan<=50)
{jibie="<img src=../bbs/userheadimg/class1.gif width=63 height=10>";}
if(jingyuan>50&&jingyuan<=150)
{jibie="<img src=../bbs/userheadimg/class2.gif width=63 height=10>";}
if(jingyuan>150&&jingyuan<=500)
{jibie="<img src=../bbs/userheadimg/class3.gif width=63 height=10>";}
if(jingyuan>500&&jingyuan<=1000)
{jibie="<img src=../bbs/userheadimg/class4.gif width=63 height=10>";}
if(jingyuan>1000&&jingyuan<=2000)
{jibie="<img src=../bbs/userheadimg/class5.gif width=63 height=10>";}
if(jingyuan>2000&&jingyuan<=4000)
{jibie="<img src=../bbs/userheadimg/class6.gif width=63 height=10>";}
if(jingyuan>4000&&jingyuan<=8000)
{jibie="<img src=../bbs/userheadimg/class7.gif width=63 height=10>";}
if(jingyuan>8000&&jingyuan<=10000)
{jibie="<img src=../bbs/userheadimg/class8.gif width=63 height=10>";}
if(jingyuan>10000&&jingyuan<=11000)
{jibie="<img src=../bbs/userheadimg/class9.gif width=63 height=10>";}
if(jingyuan>11000&&jingyuan<=12000)
{jibie="<img src=../bbs/userheadimg/class10.gif width=63 height=10>";}
if(jingyuan>12000&&jingyuan<=14000)
{jibie="<img src=../bbs/userheadimg/class11.gif width=63 height=10>";}
if(jingyuan>14000&&jingyuan<=16000)
{jibie="<img src=../bbs/userheadimg/class12.gif width=63 height=10>";}
if(jingyuan>16000&&jingyuan<=18000)
{jibie="<img src=../bbs/userheadimg/class13.gif width=63 height=10>";}
if(jingyuan>18000&&jingyuan<=20000)
{jibie="<img src=../bbs/userheadimg/class14.gif width=63 height=10>";}
if(jingyuan>20000&&jingyuan<=22000)
{jibie="<img src=../bbs/userheadimg/class15.gif width=63 height=10>";}
if(jingyuan>22000&&jingyuan<=24000)
{jibie="<img src=../bbs/userheadimg/class16.gif width=63 height=10>";}
if(jingyuan>24000&&jingyuan<=26000)
{jibie="<img src=../bbs/userheadimg/class17.gif width=63 height=10>";}
if(jingyuan>26000&&jingyuan<=28000)
{jibie="<img src=../bbs/userheadimg/class18.gif width=63 height=10>";}
if(jingyuan>28000)
{jibie="<img src=../bbs/userheadimg/class19.gif width=63 height=10>";}
%>
<HTML>
<HEAD>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<title><%=title%></title>
<LINK href="../css/xmwuye.css" rel=stylesheet type=text/css>
<script language="javascript" src="../js/resizeImages.js"></script>
<script language="javascript" src="../js/numjs.js"></script>
<script language = "JavaScript" src ="../inc/Main.js"></script>
<META content="MSHTML 5.00.3700.6699" name=GENERATOR></HEAD><BODY leftMargin=8 topMargin=3>
<!--Begin0-->
<div class=menuskin id=popmenu onmouseover="clearhidemenu()" onmouseout="dynamichide(event)" style="Z-index:100"></div>
<TABLE align=center class="table001" border=0 cellPadding=0 cellSpacing=0 width="99%"><TR>
<TD height=25 width="65%"><IMG src="../images/bbs_t1.gif" align="absmiddle">
主题位置：<A class=a03 href=main.jsp>论坛首页</a>>><A class=a03 href=main.jsp?layer_1=<%=BoardID_1%>><%=BBS_Cate_Name1%></A>>><a class=a03 href=main.jsp?layer_1=<%=BoardID_1%>&layer_2=<%=BoardID_2%>><%=BBS_Cate_Name2%></A>
<a class=a03 href=fbht.jsp?layer_1=<%=BoardID_1%>&layer_2=<%=BoardID_2%>>发布新贴</A></TD>
<TD height=22 width="35%"><IMG align=absMiddle height=16 src="../bbs/images/posttitle.gif" width=16>
版 主：<%=BBS_Cate_Manager_Name%></TD>
</TR></TABLE>
<TABLE align="center" border=0 cellPadding=0 cellSpacing=0 width="99%" style="table-layout:fixed; word-break:break-all">
<TBODY>
<TR>
<TD class=td002 rowSpan=5 vAlign=top width="20%"><DIV align=center>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR>
<TD height=22><DIV align=center>楼 主</DIV></TD>
</TR>
<TR>
<TD> <DIV align=center><IMG height=84 src=../bbs/userheadimg/<%=img%> width=84></DIV></TD>
</TR>
<TR>
<TD height=20>·网名：<%=rs.getString("user_id")%></TD>
</TR>
<TR>
<TD height=20>·头衔：<%=touxian%></TD>
</TR>
<TR>
<TD height=20>·级别：<%=jibie%></TD>
</TR>
<TR>
<TD height=20>·资历：<%=tili%></TD>
</TR>
<TR>
<TD height=20>·经验：<%=jingyuan%></TD>
</TR>
<TR>
<TD height=20>·注册：<%=rs3.getString("clubuser_reg_date").substring(0,10)%></TD>
</TR>
<TR>
<TD height=20>·<a class=a03 href=../bbs/smsbbs.jsp?id=<%=TitleID%>&File=<%=htmfilename%>&postuser=<%=rs.getString("name")%>>发送短信</a>
<a class=a03 href=../bbs/friendbbs.jsp?id=<%=TitleID%>&File=<%=htmfilename%>&postuser=<%=rs.getString("name")%>>加为好友</a>
</TD>
</TR>
<TR>
</TBODY>
</TABLE>
</DIV></TD>
</TR>
<TR>
<TD class="td004" vAlign=top> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="22" valign="middle" class=td003><B>主 题：<%=rs.getString("title")%></B></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="3" cellpadding="3" style="TABLE-LAYOUT:fixed; word-break:break-all"><tr>
<td class="td004" valign="top"> <%=rs.getString("menu")%></td>
</tr>
</table>
</TD>
</TR>
<%if(bbs_img_display.equals("1")){%>
<%if(bbs_img!=null){%>
<TR>
<TD class="td004" vAlign=top><div align="center"> <img src="../upfile/<%=bbs_img%>" border=0 resize="1" class=c03 vspace=5><BR>
<%=rs.getString("bbs_img_text")%>
</div></TD>
</TR>
<%}%>
<%}%>
<TR>
<TD class="td004" vAlign=bottom><TABLE border=0 cellPadding=0 cellSpacing=5 width="100%">
<TBODY>
<%if(rs.getString("img_url_display").equals("1")){%>
<TR>
<TD><div align="right"><%=rs.getString("img_url")%></div></TD>
</TR>
<%}%>
<TR>
<TD>本文地址：
<script>thisurl('<%=siteurl%>bbs/checkasp.jsp?id=<%=TitleID%>','../bbs/checkasp.jsp?id=<%=TitleID%>');</script></TD>
</TR>
<TR>
<TD>
<script>copyright('<%=zhiye%>','<%=rs.getString("name")%>','<%=rs.getString("user_id")%>');</script></TD>
</TR>
<TR>
<TD background="../bbs/images/bg_text1.gif" height="1"></TD>
</TR>
<TR>
<TD> <TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR>
<TD height=36 vAlign=top width=60> <DIV align=center><IMG height=32 src="../bbs/userheadimg/icon3.gif" width=45></DIV></TD>
<TD class=C03><FONT color=#568ac2><%=signname%></FONT></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD background="../bbs/images/bg_text1.gif" height="1"></TD>
</TR>
<TR>
<TD height="18" align=left class=new14>
<table width="100%" border=0 cellspacing=0 cellpadding=0>
<tr>
<td width="67%" class=new14><font color="#000000"> [<a class=a03 href=../bbs/signbbs.jsp?id=<%=TitleID%>&postnum=0&File=<%=htmfilename%>&postuser=<%=rs.getString("name")%>>删除</a>][<a class=a03 href=../bbs/topbbs.jsp?id=<%=TitleID%>&postnum=0&File=<%=htmfilename%>&postuser=<%=rs.getString("name")%>>置顶</a>][<a class=a03 href=../bbs/tjbbs.jsp?id=<%=TitleID%>&postnum=0&File=<%=htmfilename%>&postuser=<%=rs.getString("name")%>>推荐</a>][<a class=a03 href=../bbs/jpbbs.jsp?id=<%=TitleID%>&postnum=0&File=<%=htmfilename%>&postuser=<%=rs.getString("name")%>>精华</a>][<a class=a03 href="../bbs/lockbbs.jsp?id=<%=TitleID%>&postnum=<%=postnum+1%>&File=<%=htmfilename%>&postuser=<%=rs.getString("name")%>">加锁</a>][<a class=a03 href="../bbs/editpost.jsp?id=<%=TitleID%>&postnum=0&File=<%=htmfilename%>&postuser=<%=rs.getString("name")%>">编辑</a>]<a onMouseOver="showmenu(event,'','Menu_MemberTools')" class="a03" href="#">[取消]</a></font></td>
<td width="33%"><div align="right"> <IMG src="../images/bbs_ip.gif"> <%=rs.getString("date").substring(0,16)%> </div></td>
</tr>
</table></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
</TBODY>
</TABLE>
<%
String str2="select * from bbsmenu where pid="+pid+" and deleted=0 order by id asc";
Statement stmt4=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs4=stmt4.executeQuery(str2);
int intPageSize; //一页显示的记录数
int intRowCount; //记录总数
int intPageCount; //总页数
int intPage; //待显示页码
String strPage;
int i;
//设置一页显示的记录数
intPageSize = 20;
//取得待显示页码
strPage = request.getParameter("pages");
if(strPage==null){
//表明在QueryString中没有page这一个参数，此时显示第一页数据
intPage = 1;
}
else
{
//将字符串转换成整型
intPage = Integer.parseInt(strPage);
if(intPage<1){ intPage = 1;}
}
//获取记录总数
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -