📄 myfavorties.jsp

📁 本论坛开发环境：jdk1.5+Tomcat5.5.17+sql server2000+Windows 2000 1、支持HTML内容编辑,支持网络贴图与附件上传等,支持多种版面风格. 2、论坛
💻 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/conn.jsp"%>
<%!String tlk1,alk,blk,BBS_Cate_Name_1,BBS_Cate_Name_2,nar1,nar2,BBS_Cate_Manager_Name,searchcontent;%>
<%
String layer_1 = request.getParameter("layer_1");
String layer_2 = request.getParameter("layer_2");
String sign = request.getParameter("sign");
String huati = request.getParameter("huati");
String qs = request.getParameter("qs");
String order_key = request.getParameter("order_key");

String searchkind = request.getParameter("searchkind");
ResultSet rs3;

String username=null;
String payuser=null;
String bz=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 href=userlogin.jsp>用户登录</a> - <a href=# onClick=javascript:popwin('getpwd.jsp?mode=1');return false>取回密码</a> - <a href=register.jsp>用户注册</a> - <a href=help.jsp>论坛指南</a>";
}
else
{
userinfo="&gt;&gt;&gt; 欢迎 <font color=#FF0000>"+username+" </font><a href=myfavorties.jsp?ext=y>退出</a> - <a href=moduserinfo.jsp>修改资料</a> - <a href=myfriend.jsp>我的好友</a> - <a href=mysms.jsp>我的信箱</a> - <a href=myfavorties.jsp>我的收藏夹</a> - <a href=main.jsp?searchkind=name&searchcontent="+username+">我发的贴子</a>";
}
%>
<HTML><HEAD>
<title>我的收藏夹</title>
<META http-equiv=Content-Type content=text/html;charset=gb2312>
</HEAD>
<script language=javascript src="../inc/cookies.js"></script>
<script>
//载入上次cookies记录的样式
var stylecook = getCookie("STYLESHOW");
var style;
var strstyle;
if(stylecook=="")
{
 stylecook=1;
}
else
{
 stylecook++;
}
style="main0"+stylecook+".css";
strstyle="<link href=\"../css/"+style+"\"  rel=\"stylesheet\" type=\"text/css\"> ";
document.write(strstyle);
</script>
<table width="99%" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr>
    <td class="maintbtr3"> <table width="100%" border=0 cellpadding=2 cellspacing=1 class="maintbbg">
        <tbody>
          <tr> 
            <td height="25" class="f12bg">&nbsp;<%=userinfo%></td>
          </tr>
          <tr> 
            <td height="26" class="maintbtr3"><div align="center">以下是你收藏的贴子列表</div></td>
          </tr>
        </tbody>
      </table>
      <table width="100%" border=0 cellpadding=2 cellspacing=1 align="center" class="maintbbg">
        <tbody>
          <tr align=middle class=f12> 
            <td width="6%" height="25" class="f12bg">点击</td>
            <td width="52%" class="f12bg" >论坛主题</td>
            <td width="5%" class="f12bg" >回复</td>
            <td width="11%" class="f12bg" >作者</td>
            <td width="25%" class="f12bg" >更新时间</td>
          </tr>
<%
String sql="select * from ftbbs_favorites,bbstitle where ftbbs_favorites.bbstitleid = bbstitle.id and ftbbs_favorites.clubuser_name='"+username+"' order by ftbbs_favorites.id desc";
ResultSet rs=stmt.executeQuery(sql);

int intPageSize; //一页显示的记录数
int intRowCount; //记录总数
int intPageCount; //总页数
int intPage; //待显示页码
String strPage;
int i;

intPageSize = 25;
strPage = request.getParameter("pages");
if(strPage==null){
intPage = 1;
}
else
{
intPage = Integer.parseInt(strPage);
if(intPage<1){ intPage = 1;}
}
rs.last(); 
intRowCount = rs.getRow(); 
intPageCount =(intRowCount+intPageSize-1) / intPageSize;
if(intPage>intPageCount) intPage = intPageCount;
if(intPageCount>0){
rs.absolute((intPage-1) * intPageSize+1); 
}
i = 0; 

if (intRowCount>0){
while(i< intPageSize && !rs.isAfterLast()){ 
int id=rs.getInt("id");
String repTime=rs.getString("redate");
String bbs_img_display=rs.getString("bbs_img_display");
String dTime=repTime.substring(2,16);
String ReTime;

String stsql="select top 1 user_id,rename from bbsmenu where pid="+id+" order by id desc";
Statement stmt3=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs3=stmt3.executeQuery(stsql);
if(rs3.next()){
ReTime=rs3.getString("user_id");
}
else{
ReTime="";
}
%>
          <tr align=middle> 
            <td width="6%" height="28" class="maintbtr1"><%=rs.getString("hit")%></td>
            <td width="52%" align=left valign="middle" class="maintbtr2">
              <%if(rs.getString("bbstop").equals("1")){%>
              <img src="images/ding.gif" width="15" height="13" align="absmiddle"> 
              <%}%>
              <%if(rs.getString("sign").equals("1")){%>
              <img src="images/jian.gif" width="15" height="13" align="absmiddle"> 
              <%}%>
              <%if(rs.getString("huati").equals("1")){%>
              <img src="images/jing.gif" width="15" height="13" align="absmiddle"> 
              <%}%>
              <%if(rs.getString("P_display").equals("0")){%>
              <img src="images/suo.gif" width="12" height="13" align="absmiddle"> 
              <%}%>
              <%if(rs.getInt("P_display")!=0 && rs.getInt("bbstop")!=1 && rs.getInt("sign")!=1 && rs.getInt("huati")!=1){%>
              <img src="../images/<%=rs.getString("picture")%>" width="19" height="19" align="absmiddle"> 
              <%}%>
			  <a class=f14 href="ftbbs.jsp?id=<%=id%>" target="_blank"><%=rs.getString("title")%></a>
			  <%if(rs.getString("bbs_img")!=null){%>
              <font color=red> [图]</font> 
              <%}%>
			</td>
            <td class="maintbtr1" width="7%" ><%=rs.getString("rep")%></td>
            <td class="maintbtr3" width="9%" ><a href="myfavorties.jsp?searchkind=user_id&searchcontent=<%=rs.getString("user_id")%>&layer_1=<%=rs.getString("boardid_1")%>"><%=rs.getString("user_id")%></a></td>
            <td class="maintbtr3" width="16%" align=left><%=dTime%><font color=red>|</font><%=ReTime%>
			</td>
          </tr>
<%
rs.next(); 
i++; 
  }  
rs.close();
stmt.close(); 
conn.close();
//}
%>
          <tr valign="top"> 
            <td colspan="6" class="f12bg"><table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
                <tr> 
                  <td align="left" width="322" class="f12bg">&nbsp; 
                    <%out.print("共<font color=red>"+intRowCount+"</font>个主题 <font color=red>"+intPageSize+"</font>/页 共<font color=red>"+intPageCount+"</font>页");%>
                    当前第<font color=red><%=intPage%></font>页 </td>
                  <td height="23" align="right" class="f12bg">&nbsp;
				    <%if(intPage<=1){%>
				    首页
				    <%}else{%>
                    <a href="myfavorties.jsp?pages=1">首页</a>
					<%}%>
                    <%if(intPage>1){%>
                    <a href="myfavorties.jsp?pages=<%=intPage-1%>">上一页</a> 
                    <%}else{%>
                    上一页 
                    <%
	                }%>
                    <%if(intPage<intPageCount){%>
                    <a href="myfavorties.jsp?pages=<%=intPage+1%>">下一页</a> 
                    <%}else{%>
                    下一页 
                    <%
	                }%>
				    <%if(intPageCount<=1||intPage==intPageCount){%>
				    尾页
				    <%}else{%>
                    &nbsp;<a href="myfavorties.jsp?pages=<%=intPageCount%>">尾页</a>&nbsp;
					<%}%>					
                    </td>
                </tr>
              </table></td>
          </tr>
<%}else{%>
          <tr class="maintbtr3"> 
            <td colspan=6 align=center height=25> 欢迎到本论坛发表贴子！ </td>
          </tr>
<%}%>
        </tbody>
      </table>
    </td>
  </tr>
</table>
<%@ include file="../inc/bbstail.jsp"%>
</BODY>
</HTML>
⌨️ 快捷键说明

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