listalltj.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>
<div align="center">
  <table width="766" border="0" align="center" cellpadding="0" cellspacing="0">
    <tr> 
      <td height="18">*--插图</td>
  </tr>
</table>
  <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(tjid) from scott.mztj order by tjtime 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 tjid,tjtitle from scott.mztj order by tjtime 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="dismztj.jsp?id=<%=rs.getString("tjid")%>"><%=rs.getString("tjtitle")%></a></td>
  </tr>
  <% i++;}
}
 %>
 </td></tr><tr bgcolor=#FFFFFF><td height=20 colspan=2><div align="left">                           
<p align='center' vAlign='bottom'>
				第<%=intPage%>页 &nbsp;&nbsp;&nbsp;共<%=intPageCount%>页&nbsp;&nbsp;&nbsp;
				<%if(intPage<intPageCount){%>
				<a href="listalltj.jsp?page=<%=intPage+1%>">下一页</a>&nbsp;&nbsp;&nbsp;
				<%}%>
				<%if(intPage>1){%>
				<a href="listalltj.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></div>
<%@ include file="foot.jsp"%>