📄 checkasp.jsp
字号:
rs4.last();
intRowCount = rs4.getRow();
//计算总页数
intPageCount =(intRowCount+intPageSize-1) / intPageSize;
//调整待显示的页码
if(intPage>intPageCount) intPage = intPageCount;
if(intPageCount>0){
//将记录指针定位到待显示页的第一条记录上
rs4.absolute((intPage-1) * intPageSize+1);
//显示数据
i = 0;
while(i< intPageSize && !rs4.isAfterLast()){
reid=rs4.getInt("id");
reuser_id=rs4.getString("rename");
bbs_img=rs4.getString("bbs_img");
String repTime=rs4.getString("date");
String dTime=repTime.substring(0,16);
String asql="select clubuser_id,clubuser_name,clubuser_reg_date,jingyuan,tili,userimg,signname,bbsmanager from clubuser where clubuser_name='"+rs4.getString("rename")+"'";
Statement stmt5=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs5=stmt5.executeQuery(asql);
if(rs5.next())
{
jingyuan=rs5.getInt("jingyuan");
tili=rs5.getInt("tili");
img=rs5.getString("userimg");
reg_date=rs5.getString("clubuser_reg_date");
signname=htmln(rs5.getString("signname"));
if(signname==null)
signname="你还没有签名，可以从修改资料中加入自已的签名";
}
else
{
jingyuan=0;
tili=100;
img="cache37.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>";}
%>
<table border="0" width="99%" cellspacing="0" cellpadding="0" class="table002" align="center">
<tr>
<td width="20%" height="22" valign="middle"><img src="../bbs/userheadimg/icon0.gif" width="20" height="20" align="absbottom">
第 <font color="#660033">
<script>document.write(addnum())</script>
</font> 楼</td>
<td class="new14"><b>Re：<%=title%></b></td>
</tr>
</table>
<table border="0" width="99%" cellspacing="0" cellpadding="0" align="center" style="table-layout:fixed; word-break:break-all">
<tr>
<td width="20%" rowspan="2" valign="top" class=td002> <div align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> <div align="center"> <img src="../bbs/userheadimg/<%=img%>" width="84" height="84"></div></td>
</tr>
<tr>
<td height="20">·网名：<%=rs4.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">·注册：<%=rs5.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=<%=reuser_id%>>发送短信</a>
<a class=a03 href=../bbs/friendbbs.jsp?id=<%=TitleID%>&File=<%=htmfilename%>&postuser=<%=reuser_id%>>加为好友</a></td>
</tr>
</table>
</div></td>
<td valign="top" class="td004"> <table width="100%" border="0" cellspacing="3" cellpadding="3" style="TABLE-LAYOUT:fixed; word-break:break-all">
<tr>
<td class="td004" valign="top"> <%=rs4.getString("remenu")%></td>
</tr>
<%if(rs4.getString("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><%=rs4.getString("bbs_img_text")%>
</div></td>
</tr>
<%}%>
<%}%>
</table></td>
</tr>
<tr>
<td valign="bottom" class="td004"> <table width="100%" border="0" cellspacing="5" cellpadding="0">
<%if(rs4.getString("img_url_display").equals("1")){%>
<tr>
<td><div align="right"><%=rs4.getString("img_url")%></div></td>
</tr>
<%}%>
<tr>
<td height="1" background="../bbs/userheadimg/bg_text1.gif"> </td>
</tr>
<tr>
<td> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="60" height="36" valign="top"> <div align="center"><img src="../bbs/userheadimg/icon3.gif" width="45" height="32"></div></td>
<td class="C03"> <font color=#568AC2><%=signname%></font></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" background="../bbs/userheadimg/bg_text1.gif"></td>
</tr>
<tr>
<td> <table width="100%" border=0 cellspacing=0 cellpadding=0>
<tr>
<td width="69%" class=new14><font color="#000000"> [<a class=a03 href=../bbs/delbbs.jsp?id=<%=TitleID%>&postnum=<%=postnum+1%>&File=<%=htmfilename%>&postuser=<%=reuser_id%>&reid=<%=reid%>>删除</a>][<a class=a03 href=../bbs/topbbs.jsp?id=<%=TitleID%>&postnum=<%=postnum+1%>&File=<%=htmfilename%>&postuser=<%=reuser_id%>>置顶</a>][<a class=a03 href=../bbs/tjbbs.jsp?id=<%=TitleID%>&postnum=<%=postnum+1%>&File=<%=htmfilename%>&postuser=<%=reuser_id%>>推荐</a>][<a class=a03 href=../bbs/jpbbs.jsp?id=<%=TitleID%>&postnum=<%=postnum+1%>&File=<%=htmfilename%>&postuser=<%=reuser_id%>>精华</a>][<a class=a03 href="../bbs/lockbbs.jsp?id=<%=TitleID%>&postnum=<%=postnum+1%>&File=<%=htmfilename%>&postuser=<%=reuser_id%>">加锁</a>][<a class=a03 href=javascript:; onClick=yinyong('<%=reid%>')>引用</a>][<a class=a03 href="../bbs/editpost.jsp?id=<%=TitleID%>&postnum=<%=postnum+1%>&File=<%=htmfilename%>&postuser=<%=reuser_id%>&reid=<%=reid%>">编辑</a>]</font></td>
<td width="31%"> <div align="right"> <IMG src="../images/bbs_ip.gif" width="13" height="15"> <%=dTime%> </div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<%
rs4.next();
i++;
}
}
rs4.close();
%>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="49%" height="25" class=td005> <div align="left">
<%out.print("共<font color=red>"+intRowCount+"</font>条回复 <font color=red>"+intPageSize+"</font>/页 共<font color=red>"+intPageCount+"</font>页");%>
当前第<font color=red><%=intPage%></font>页 </div></td>
<td width="51%" class=td005> <div align="right">
<%if(intPage<=1){%>
首页
<%}else{%>
<a href="checkasp.jsp?pages=1&id=<%=pid%>">首页</a>
<%}%>
<%if(intPage>1){%>
<a href="checkasp.jsp?pages=<%=intPage-1%>&id=<%=pid%>">上一页</a>
<%}else{%>
上一页
<%
}%>
<%if(intPage<intPageCount){%>
<a href="checkasp.jsp?pages=<%=intPage+1%>&id=<%=pid%>">下一页</a>
<%}else{%>
下一页
<%}%>
<%if(intPageCount<=1||intPage==intPageCount){%>
尾页
<%}else{%>
<a href="checkasp.jsp?pages=<%=intPageCount%>&id=<%=pid%>">尾页</a>
<%}%>
</div></td>
</tr>
</table>
<TABLE align=center border=0 cellPadding=0 cellSpacing=0 width="99%">
<TBODY>
<TR>
<TD vAlign=top>
<DIV align=center>
<TABLE align=center border=0 cellPadding=0 cellSpacing=0 width="100%">
<FORM action=../bbs/recheck.jsp encType=multipart/form-data method=post name=form1 onsubmit="return CheckForm(this)">
<TR>
<TD class=td001 colSpan=2 height=25> <DIV align=center><B>回 复：<%=title%></B></DIV></TD>
</TR>
<TR>
<TD align=right vAlign=middle><div align="center">
<table width="100%" cellspacing="0">
<tr>
<td width="20%" class=td005><div align="right">回复内容：</div></td>
<td height=200 width="80%" class=td005> <TEXTAREA type="hidden" rows=1 cols=1 name="remenu" style="position:absolute;left:0;visibility:hidden;"></textarea>
<SCRIPT src="../htmledit/wbTextBox/ubbhtml.js"></SCRIPT>
</td>
</tr>
<TR>
<TD height="28" align=right class=td005>上传图片：</TD>
<TD class=td003><INPUT name=bbs_img type=file>
<FONT color=#990000><span class="fontnote">(允许上传gif,jpg类型的图片)</span></FONT></TD>
</TR>
<TR>
<TD height="28" align=right class=td005>图片说明：</TD>
<TD class=td003><INPUT maxLength=100 name=bbs_img_text size=63> </TD>
</TR>
<!--
<TR bgcolor="#F2F8FF">
<TD width="151"></TD>
<TD width="588" height="25"><FONT COLOR="#990000">说明：您上传的图片需经过网站的审核通过后，才能在论坛显示。</FONT></TD>
</TR>
-->
<tr valign="middle">
<td height="30" colspan=2 align=center class=td003>
<INPUT name=id type=hidden value="<%=TitleID%>"> <INPUT name=BoardID_1 type=hidden value="<%=BoardID_1%>">
<INPUT name=BoardID_2 type=hidden value="<%=BoardID_2%>"> <input class=button type=Submit value="提交回复" name=submit1>
<input class=button name=B2 type=reset value=全部重写>
</td>
</tr>
</table>
</div></TD>
</TR>
</FORM>
</TABLE>
</DIV></TD></TR></TABLE>
<script language="JavaScript" src="../inc/bbstail.js"></script>
<div class="Menu_popup" id="Menu_MemberTools">
<div class=menuitems>
<a class=a03 href=../bbs/canneltopbbs.jsp?id=<%=TitleID%>&postnum=0&File=<%=htmfilename%>&postuser=<%=rs.getString("name")%>>取消置顶</a>
<br><a class=a03 href=../bbs/canneltjbbs.jsp?id=<%=TitleID%>&postnum=0&File=<%=htmfilename%>&postuser=<%=rs.getString("name")%>>取消推荐</a>
<br><a class=a03 href=../bbs/canneljhbbs.jsp?id=<%=TitleID%>&postnum=0&File=<%=htmfilename%>&postuser=<%=rs.getString("name")%>>取消精华</a>
<br><a class=a03 href=../bbs/unlockbbs.jsp?id=<%=TitleID%>&postnum=0&File=<%=htmfilename%>&postuser=<%=rs.getString("name")%>>取消加锁</a>
</div>
</div>
</BODY>
</HTML>
<%
stmt1.close();
stmt2.close();
stmt3.close();
stmt4.close();
conn.close();
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -