admin_news.jsp

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

<%@ include file="admintop.jsp"%>
<%@ include file="isadmin.jsp"%>
<form name="form1" method="POST">
  <table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000">
    <tr bgcolor="#B1E1F3"> 
      <td height="30" colspan="4"> 
        <div align="center"><strong>所有民政新闻</strong></div></td>
  </tr>
  <tr> 
    <td width="53%"><div align="center">新闻文件名</div></td>
    <td width="27%"><div align="center">发布日期</div></td>
    <td width="10%"><div align="center">操作</div></td>
    <td width="10%"><div align="center">选择</div></td>
  </tr>
   <%String sqlname;
int intPageSize;
int intRowCount;//记录总数
int intPageCount;//总页数
int intPage;//页面参数
String strPage;//定义变量用来传递page
int i,j;
intPageSize=8;//定义每页显示8条记录
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.news order by times 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, nstitle,times from scott.news order by times 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 colspan='4'>暂无内容</td></tr>
		  <%}else{%>
		<%-- 显示每页的数据 (根据i的值判断每页的5条记录) --%>
		<%i=0;
		while(i<intPageSize && rs.next()){%>  


  
  <tr> 
    <td width="53%"><div align="center"><a href="../listnews.jsp?id=<%=rs.getString("id")%>" target="_blank"><%=rs.getString("nstitle")%></a></div></td>
    <td width="27%"><div align="center"><%=rs.getString("times")%></div></td>
    <td width="10%"><div align="center"><a href="editmznew.jsp?id=<%=rs.getString("id")%>">修改</a>/<a href="delmznews.jsp?id=<%=rs.getString("id")%>">删除</a></div></td>
    <td width="10%"><div align="center">
        <input type="checkbox" name="Board" id="<%=rs.getString("id")%>" style="font-size: 9pt">
      </div></td>
  </tr>
  <%  i++;} 
}
  %>
  <tr>
    <td colspan="4"> <div align="center"> &nbsp;&nbsp; <a href="addmznew.jsp" target="_blank">添加内容</a>&nbsp;&nbsp; 
          <input type="button" value="全 选" onclick="sltAll()" name=button1>
        &nbsp;&nbsp;
        <input type="button" value="清 空" onclick="sltNull()" name=button2>
        &nbsp;&nbsp;
        <input type="submit" value="删 除" name="tijiao" onclick="SelectChk('delmznews.jsp')">
      </div></td></tr>
  <tr> 
    <td colspan="4">
	<div align="right">                           
<p align='center' vAlign='bottom'>
				第<%=intPage%>页 &nbsp;&nbsp;&nbsp;共<%=intPageCount%>页&nbsp;&nbsp;&nbsp;
				<%if(intPage<intPageCount){%>
				<a href="admin_news.jsp?page=<%=intPage+1%>">下一页</a>&nbsp;&nbsp;&nbsp;
				<%}%>
				<%if(intPage>1){%>
				<a href="admin_news.jsp?page=<%=intPage-1%>">上一页</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
				<%}%>
				 </div>
	</td>
  </tr>
</table>
</form>
</body>
</html>