【JSP开源代码栏目提醒】:网学会员为需要JSP开源代码的朋友们搜集整理了board.jsp相关资料,希望对各位网友有所帮助!
<%@ include file="conn.jsp"%>
<html>
<head>
<title>小论坛</title>
<%@ include file="an.htm"%>
<%@ include file="menu.jsp"%>
<%@ include file="login_include.jsp"%>
<%@ include file="menu_include.jsp"%>
<%@ include file="menulist_include.jsp"%>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="254"><a href="announce.jsp?boardid=<%=boardid%>"><img src="pic/h4.gif" alt="发表文章" title="发表文章" width="72" height="21" border="0"></a></td>
<td width="378"> </td>
<td width="128"><img src="pic/team2.gif" width="20" height="20">版主:<%=banzhu%></td>
</tr>
</table>
<table width="760" border="1" align="center" cellpadding="0" cellspacing="0" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF">
<tr align="center" class="p9">
<td width="6%" background="pic/h3.gif">序号</td>
<td width="39%" background="pic/h3.gif">标题</td>
<td width="10%" background="pic/h3.gif">回复</td>
<td width="8%" background="pic/h3.gif">点击</td>
<td width="9%" background="pic/h3.gif">发言人</td>
<td width="28%" background="pic/h3.gif">发言时间</td>
</tr>
<%
String sqlname;
int intPageSize;
int intRowCount;//记录总数
int intPageCount;//总页数
int intPage;//页面参数
String strPage;//定义变量用来传递page
int i,j;
intPageSize=11;//定义每页显示10条记录
strPage=request.getParameter("page");//取得当前的页码
if(strPage==null){//判断初始页面,如果没有显示记录,就置为第一页
intPage=1;
}else{
intPage=Integer.parseInt(strPage);//将strPage转化为整数
if(intPage<1) intPage=1;
}
sqlname="select count(layer) from scott.news where layer=1 and boardid='"+boardid+"' order by flag desc, sorttime desc";
ResultSet rt=stmt.executeQuery(sqlname);
rt.next();
intRowCount=rt.getInt(1);//取得整数保存与intRowCount变量中
intPageCount=(intRowCount+intPageSize-1)/intPageSize;//计算出总页数(记录总数+每页显示的记录-1)/每页显示的记录)
if(intPage>intPageCount)
intPage=intPageCount;
sqlname="select * from scott.news where layer=1 and boardid='"+boardid+"' order by bbs_id desc";
ResultSet rs=stmt.executeQuery(sqlname);//执行sql,按照时间先后排序显示
i=(intPage-1)*intPageSize;
for(j=0;j<i;j++)
rs.next();
%>
<%-- 设置intPage参数 --%>
<%if(intRowCount==0){%>
对不起,还没有数据!
<%}else{
i=1;
while(i<intPageSize && rs.next()){
%>
<tr align="center">
<td bgcolor="#e3f1d1" width="6%"><%=i%>
<td align="left" bgcolor="#e3f1d1" class="p9" width="39%"><a href="count_hits.jsp?bbs_id=<%=rs.getString("bbs_ID")%>&boardid=<%=boardid %>"><%=rs.getString("title")%></a></td>
<td bgcolor="#e3f1d1" class="p9" width="10%"><%=rs.getString("child")%></td>
<td bgcolor="#e3f1d1" class="p9" width="8%"><%=rs.getString("hits")%></td>
<td bgcolor="#e3f1d1" class="p9" width="9%"><a href="uerparticle.jsp?id=<%=rs.getString("user_name")%>"><%=rs.getString("user_name")%></a></td>
<td bgcolor="#e3f1d1" class="p9" width="28%"><%=rs.getString("submit_date")%></td>
</tr>
<% sql="select * from scott.news where layer=2 and parent_id='"+rs.getString("bbs_ID")+"' order by bbs_id";
ResultSet rst1=stmt1.executeQuery(sql);
while(rst1.next()) {
%>
<tr align="center">
<td bgcolor="#ffffff" width="6%">
<td align="left" bgcolor="#ffffff" class="p9" width="39%"><a href="count_hits.jsp?bbs_id=<%=rst1.getString("bbs_ID")%>&boardid=<%=boardid %>">
回复: <%=rst1.getString("title")%></a></td>
<td bgcolor="#ffffff" class="p9" width="10%"> </td>
<td bgcolor="#ffffff" class="p9" width="8%"><%=rst1.getString("hits")%></td>
<td bgcolor="#ffffff" class="p9" width="9%"><a href="uerparticle.jsp?id=<%=rst1.getString("user_name")%>"><%=rst1.getString("user_name")%></a></td>
<td bgcolor="#ffffff" class="p9" width="28%"><%=rst1.getString("submit_date")%></td>
</tr>
<%
}
i++;
}
}
%>
</table>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="346"><a href="announce.jsp?boardid=<%=boardid%>"><img src="pic/h4.gif" alt="发表文章" title="发表文章" width="72" height="21" border="0"></a></td>
<td width="414" class="p12"> <div align="right">
<p align='center' vAlign='bottom'>
第<%=intPage%>页 共<%=intPageCount%>页
<%if(intPage<intPageCount){%>
<a href="board.jsp?boardid=<%=boardid%>&page=<%=intPage+1%>">下一页</a>
<%}%>
<%if(intPage>1){%>
<a href="board.jsp?boardid=<%=boardid%>&page=<%=intPage-1%>">上一页</a>
<%}%>
</div></td>
</tr>
</table>
<%@ include file="foot.jsp"%>
<script language="javascript">
function openUser(id) {
var Win = window.open("dispuser.jsp?name="+id,"openScript","width=350,height=300,resizable=1,scrollbars=1,menubar=0,status=1" );
}
function openScript(url, width, height){
var Win = window.open(url,"openScript",'width=' + width + ',height=' + height + ',resizable=1,scrollbars=yes,menubar=no,status=yes' );
}
function openDis(bid,rid,id){
self.location="dispbbs.jsp?boardid="+bid+"&RootID="+rid+"&id="+id
}
function PopWindow()
{
openScript('messanger.jsp?action=newmsg',420,320);
}
var nn = !!document.layers;
var ie = !!document.all;
if (nn) {
netscape.security.PrivilegeManager.enablePrivilege("UniversalSystemClipboardAccess");
var fr=new java.awt.Frame();
var Zwischenablage = fr.getToolkit().getSystemClipboard();
}
function submitonce(theform){
//if IE 4+ or NS 6+
if (document.all||document.getElementById){
//screen thru every element in the form, and hunt down "submit" and "reset"
for (i=0;i<theform.length;i++){
var tempobj=theform.elements[i]
if(tempobj.type.toLowerCase()=="submit"||tempobj.type.toLowerCase()=="reset")
//disable em
tempobj.disabled=true
}
}
}
</script>
上一篇:
blogview.jsp
下一篇:
台湾海峡台风浪的数值模拟