📄 ftbbs.jsp

📁 本论坛开发环境：jdk1.5+Tomcat5.5.17+sql server2000+Windows 2000 1、支持HTML内容编辑,支持网络贴图与附件上传等,支持多种版面风格. 2、论坛
💻 JSP
📖 第 1 页 / 共 3 页
字号:
12 3 下一页
<%@ 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 username=null;
String userinfo;
Cookie temp=null;
Cookie[] cookies=request.getCookies();
int cookidlen=cookies.length;
for(int i=0;i<cookidlen;i++)
{
temp=cookies[i];
if(temp.getName().equals("clubusername")) {
username=temp.getValue();
}
}

if(username==""||username==null||username.equals("")||username.equals(null))
{
userinfo="&gt;&gt;&gt; <font color=#FF0000>游客 </font> 你还未登录 - <a class=a03 href=../default.jsp?n=login>用户登录</a> - <a class=a03 href=# onClick=javascript:popwin('getpwd.jsp?mode=1');return false>取回密码</a> - <a class=a03 href=../default.jsp?n=regist>用户注册</a> - <a class=a03 href=../default.jsp?n=help>论坛指南</a> - <a class=a03 href=../default.jsp>返回首页</a>";
}
else
{
userinfo="&gt;&gt;&gt; 欢迎 <font color=#FF0000>"+username+" </font><a class=a03 href=../default.jsp?n=ext>退出论坛</a> - <a class=a03 href=../default.jsp?n=userinfo>修改资料</a> - <a class=a03 href=../default.jsp?n=friend>我的好友</a> - <a class=a03 href=../default.jsp?n=sms>我的信箱</a> - <a class=a03 href=../default.jsp?n=favorties>我的收藏夹</a> - <a class=a03 href=main.jsp?searchkind=name&searchcontent="+username+">我发的贴子</a> - <a class=a03 href=../default.jsp>返回首页</a>";
}

String Sql_kind="select top 1 * from ftbbsconfig where id=1";
Statement stmt02=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs7=stmt02.executeQuery(Sql_kind);
if(rs7.next()){
siteurl=rs7.getString("bbs_domain");
}

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>
<script language=javascript src="../inc/cookies.js"></script>
<script>
var stylecook = getCookie("STYLESHOW");
var style;
var strstyle;
if(stylecook=="")
{
 stylecook=1;
}
else
{
 stylecook++;
}
style="ftbbs0"+stylecook+".css";
strstyle="<link href=\"../css/"+style+"\"  rel=\"stylesheet\" type=\"text/css\"> ";
document.write(strstyle);
</script>

<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 bordercolor=#ffffff cellspacing=0 cellpadding=5 width=755 align=center border=0>
  <tbody>
    <tr> 
      <td width=90><a href="../default.jsp" target=_blank><img src=../images/logo.gif width=90 height=35 border=0></a></td>
      <td> <table cellspacing=0 cellpadding=0 width=100% border=0>
          <tbody>
            <tr> 
              <td class=Toptitlelist align=right><%=userinfo%></td>
            </tr>
            <tr> 
              <td height=3><spacer height=1 type=block></td>
            </tr>
            <tr> 
              <td background=../images/dotbg.gif height=1><spacer height=1 type=block></td>
            </tr>
          </tbody>
        </table></td>
    </tr>
  </tbody>
</table>
12 3 下一页
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -