?? checkasp.jsp
字號:
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ 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;long reid=0;
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.getObject("content").toString();
}
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.getObject("BoardID_1").toString();
BoardID_2=rs.getObject("BoardID_2").toString();
bbs_img=rs.getObject("bbs_img").toString();
bbs_img_display=rs.getObject("bbs_img_display").toString();
title=rs.getObject("title").toString();
zhiye=rs.getObject("zhiye").toString();
htmfilename=rs.getObject("htmfilename").toString();
postnum=rs.getObject("postnum").toString();
//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="咕嚕隊(duì)長";
}
if(jingyuan>4000&&jingyuan<=8000)
{
touxian="初級守衛(wèi)";
}
if(jingyuan>8000&&jingyuan<=10000)
{
touxian="守衛(wèi)隊(duì)長";
}
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%>>發(fā)布新貼</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>·網(wǎng)名：<%=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>·經(jīng)驗(yàn)：<%=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.getObject("name")%>>發(fā)送短信</a>
<a class=a03 href=../bbs/friendbbs.jsp?id=<%=TitleID%>&File=<%=htmfilename%>&postuser=<%=rs.getObject("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.getObject("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.getObject("menu")%></td>
</tr>
</table>
</TD>
</TR>
<%if(bbs_img_display.equals("1")){%>
<%if(!bbs_img.equals("0")){%>
<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.getObject("img_url_display").toString().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.getObject("name")%>','<%=rs.getObject("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.getObject("name")%>>刪除</a>][<a class=a03 href=../bbs/topbbs.jsp?id=<%=TitleID%>&postnum=0&File=<%=htmfilename%>&postuser=<%=rs.getObject("name")%>>置頂</a>][<a class=a03 href=../bbs/tjbbs.jsp?id=<%=TitleID%>&postnum=0&File=<%=htmfilename%>&postuser=<%=rs.getObject("name")%>>推薦</a>][<a class=a03 href=../bbs/jpbbs.jsp?id=<%=TitleID%>&postnum=0&File=<%=htmfilename%>&postuser=<%=rs.getObject("name")%>>精華</a>][<a class=a03 href="../bbs/lockbbs.jsp?id=<%=TitleID%>&postnum=<%=postnum+1%>&File=<%=htmfilename%>&postuser=<%=rs.getObject("name")%>">加鎖</a>][<a class=a03 href="../bbs/editpost.jsp?id=<%=TitleID%>&postnum=0&File=<%=htmfilename%>&postuser=<%=rs.getObject("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("date1").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; //一頁顯示的記錄數(shù)
int intRowCount; //記錄總數(shù)
int intPageCount; //總頁數(shù)
int intPage; //待顯示頁碼
String strPage;
int i;
//設(shè)置一頁顯示的記錄數(shù)
intPageSize = 20;
//取得待顯示頁碼
strPage = request.getParameter("pages");
if(strPage==null){
//表明在QueryString中沒有page這一個(gè)參數(shù)，此時(shí)顯示第一頁數(shù)據(jù)
intPage = 1;
}
else
{
//將字符串轉(zhuǎn)換成整型
intPage = Integer.parseInt(strPage);
if(intPage<1){ intPage = 1;}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -