listworknet.jsp

JSP+ORACLE网站开发实例（下）.rar

<% String toptitle="所有新闻"; %>
<%@ include file="rscoon.jsp"%>
<%@ include file="mztop.jsp"%>
		   <script>
 function GoToWhere(s)
 {
 var d = s.options[s.selectedIndex].value;
 window.location=d;
 s.selectedIndex=0;
 }
</script>
<table width=766 border=0 align=center cellpadding=0 cellspacing=0> 
<%
String colors;
String sqlname;
int intPageSize;
int intRowCount;//记录总数
int intPageCount;//总页数
int intPage;//页面参数
String strPage;//定义变量用来传递page
int i,j;
intPageSize=10;//定义每页显示10条记录
strPage=request.getParameter("page");//取得当前的页码
if(strPage==null){//判断初始页面,如果没有显示记录,就置为第一页
intPage=1;
}else{
intPage=Integer.parseInt(strPage);//将strPage转化为整数
if(intPage<1) intPage=1;}

 sqlname="select count(id) from scott.worknet order by nettime 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 id,nettitle from scott.worknet order by nettime desc";
ResultSet rs=stmt.executeQuery(sqlname);//执行sql，按照时间先后排序显示
i=(intPage-1)*intPageSize;
for(j=0;j<i;j++)
rs.next();
%>
<%-- 设置intPage参数 --%>
  <%if(intRowCount==0){%>
		<tr><td>对不起，此版块暂无内容</td></tr>
		  <%}else{
			  i=0;
		while(i<intPageSize && rs.next()){%>
		<%-- 显示每页的数据 (根据i的值判断每页的5条记录) --%>
<% if(i%2==0){
			 colors="#FFFFFF";
		}else{
			 colors="#D6E8E9";
		}

  %>

<tr bgcolor="<%=colors%>">  
<td width='4%'><div align=center><img src=images/rj-tp3.gif width=10 height=10 align=absmiddle></div></td><td width=96% height=20><a href='worknet.jsp?id=<%=rs.getString("id")%>'><%=rs.getString("nettitle")%></a></td></tr>
       <% i++;}
}
 %>  
</td></tr><tr bgcolor=#FFFFFF><td height=20 colspan=2><p align='center' vAlign='bottom'>
				第<%=intPage%>页 &nbsp;&nbsp;&nbsp;共<%=intPageCount%>页&nbsp;&nbsp;&nbsp;
				<%if(intPage<intPageCount){%>
				<a href="listworknet.jsp?page=<%=intPage+1%>">下一页</a>&nbsp;&nbsp;&nbsp;
				<%}%>
				<%if(intPage>1){%>
				<a href="listworknet.jsp?page=<%=intPage-1%>">上一页</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
				<%}%>
				 </div> <div align=right><a href='javascript:window.close()'>【关闭窗口】</a></div></td></tr></table>
  <%@ include file="foot.jsp"%>