?? bbslist.jsp
字號:
<font color="#FFFFFF"><%=iPageCurrent%>/<%=iPageCount%></font></p>
</td>
<td width="110" valign="middle" bgcolor="#000080">
<form method="GET" action="bbslist.jsp" style="margin-top: 0; margin-bottom: 0">
<p align="center" style="margin-top: 0; margin-bottom: 0"><font color="#FFFFFF">轉到:<input type="text" name="pages" size="3" value="1">頁<input type="submit" value="GO" name="GO"></font></p>
<input type="hidden" name="boardid" value="<%=boardid%>">
<input type="hidden" name="method" value="<%=method%>">
<input type="hidden" name="par" value="<%=par%>">
</form>
</td>
</tr>
</table>
</center>
</div>
<!--表頭部分結束 -->
<P></P>
<%
if (iPageCurrent>0) {%>
<div align="left">
<table border="0" width="600">
<tr>
<td width="100%">
<ul>
<%
sqlRst=bbs.listBbs(method,iPageSize,iPageCurrent,boardid,par);
while(sqlRst.next()){
bbsid=sqlRst.getInt("bbsid");
parentid=sqlRst.getInt("parentid");
child=sqlRst.getInt("child");
username=sqlRst.getString("username");
useremail=sqlRst.getString("useremail");
userip=sqlRst.getString("userip");
expression=sqlRst.getString("expression");
usersign=sqlRst.getString("usersign");
bbstopic=sqlRst.getString("bbstopic");
bbscontent=sqlRst.getString("bbscontent");
//dateandtime=sqlRst.getString("dateandtime");
dateandtime=sqlRst.getDate("dateandtime");
bbshits=sqlRst.getInt("bbshits");
length=sqlRst.getInt("length");
bbshot=sqlRst.getString("bbshot");
%>
<li>
<p align="left"><img border="0" src="images/<%=expression%>"><a href="bbsaddre.jsp?boardid=<%=boardid%>&bbsid=<%=bbsid%>" ><%=bbstopic%></a>
<<font color="#FF0000"><%if (length==0){%>無內容<%}else{%><%=length%>Bytes<%}%></font>>-【<a href="mailto:<%=useremail%>"><b><%=username%></b></a>】=<i><%=dateandtime%></i>=[ID:<%=bbsid%>點擊:<%=bbshits%>回復:<%=child%>]
<%if (bbshot.compareTo("ok")==0){%><font color="#FF0000">★</font><%}%>
<%if (delon=="true"){%><a href="delete.jsp?bbsid=<%=bbsid%>">刪除</a>
###<%if (bbshot.compareTo("ok")!=0) {%><a href="addfav.jsp?bbsid=<%=bbsid%>">加入精華區</a>
<%}else{%><a href="subfav.jsp?bbsid=<%=bbsid%>">從精華區刪除</a><%}}%>
<!--跟貼開始----------------------->
<%
if ((method==0)||(method==8)||(method==4)||(method==1)) {
//if (false){
//'0正常顯示 //'4 精華區顯示 //'8 管理員顯示 //'1搜索主題
rs=bbs.listBbsRe(bbsid); //：列出某貼的所有跟貼
while(rs.next()){
bbsid=rs.getInt("bbsid");
parentid=rs.getInt("parentid");
username=rs.getString("username");
useremail=rs.getString("useremail");
userip=rs.getString("userip");
expression=rs.getString("expression");
usersign=rs.getString("usersign");
bbstopic=rs.getString("bbstopic");
bbscontent=rs.getString("bbscontent");
//dateandtime=rs.getString("dateandtime");
dateandtime=rs.getDate("dateandtime");
bbshits=rs.getInt("bbshits");
length=rs.getInt("length");
%>
<ul>
<li type="circle">
<p align="left"><img border="0" src="images/<%=expression%>"><a href="bbsaddre.jsp?boardid=<%=boardid%>&bbsid=<%=parentid%>" ><%=bbstopic%></a>
<<font color="#FF0000"><%if (length==0){%>無內容<%}else{%><%=length%>Bytes<%}%></font>>-【<a href="mailto:<%=useremail%>"><b><%=username%></b></a>】=<i><%=dateandtime%></i>=</li>[ID:<%=bbsid%>點擊:<%=bbshits%>]
<%if (delon=="true") {%> <a href="delete.jsp?bbsid=<%=bbsid%>">刪除</a><%}%>
</ul>
<%
} //end while
rs.close();
} //end if
%>
<!--跟貼結束------------------------->
<hr size="0" color="#808080">
<%
} //全部記錄結束
sqlRst.close();
%>
</ul>
</td>
</tr>
</table>
</div>
<!--表頭部分 -->
<div align="center">
<center>
<table border="1" width="600" bordercolorlight="#000000" bordercolordark="#FFFFFF" bgcolor="#FAD185" cellspacing="0" cellpadding="3">
<tr>
<td width="30" bgcolor="#000080">
<p align="center"><a href="bbsadd.jsp?boardid=<%=boardid%>" target="_self"><font color="#FFFFFF">留言</font></a></p>
</td>
<td width="30" bgcolor="#000080">
<p align="center"><a href="bbslist.jsp?boardid=<%=boardid%>" target="_self"><font color="#FFFFFF">刷新</font></a></p>
</td>
<td width="30" bgcolor="#000080">
<p align="center"><a href="query.jsp"><font color="#FFFFFF">查詢</font></a></p>
</td>
<td width="100" bgcolor="#000080">
<p align="center"><a href="bbslist.jsp?boardid=<%=boardid%>&method=4"><font color="#FFFFFF">精華區</font></a></p>
</td>
<td width="200" bgcolor="#000080">
<p align="center">
<%if (iPageCount>1) {%><A HREF="bbslist.jsp?boardid=<%=boardid%>&pages=1&method=<%=method%>&par=<%=par%>">
<font color="#FFFFFF">首頁</font></A><%}%>
<%if (iPageLast!=0) {%>
<A HREF="bbslist.jsp?boardid=<%=boardid%>&pages=<%=iPageLast%>&method=<%=method%>&par=<%=par%>"><font color="#FFFFFF">上頁</font></A><%}%>
<%if (iPageNext!=0) {%>
<A HREF="bbslist.jsp?boardid=<%=boardid%>&pages=<%=iPageNext%>&method=<%=method%>&par=<%=par%>"><font color="#FFFFFF">下頁</font></A><%}%>
<%if (iPageCount>1) {%>
<A HREF="bbslist.jsp?boardid=<%=boardid%>&pages=<%=iPageCount%>&method=<%=method%>&par=<%=par%>"><font color="#FFFFFF">尾頁</font></A><%}%>
<font color="#FFFFFF"><%=iPageCurrent%>/<%=iPageCount%></font></p>
</td>
<td width="110" valign="middle" bgcolor="#000080">
<form method="GET" action="bbslist.jsp" style="margin-top: 0; margin-bottom: 0">
<p align="center" style="margin-top: 0; margin-bottom: 0"><font color="#FFFFFF">轉到:<input type="text" name="pages" size="3" value="1">頁<input type="submit" value="GO" name="GO"></font></p>
<input type="hidden" name="boardid" value="<%=boardid%>">
<input type="hidden" name="method" value="<%=method%>">
<input type="hidden" name="par" value="<%=par%>">
</form>
</td>
</tr>
</table>
</center>
</div>
<!--表頭部分結束 -->
<%}else{ //'屏蔽錯誤，如果頁面數為0，顯示如下信息
%>
很抱歉，沒有找到您所需要的記錄！請重新查詢！
<%
}%>
</body>
</html> ?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -