admin_tj.jsp

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

<%@ include file="admintop.jsp"%>
<%@ include file="isadmin.jsp"%>
<form name="form1" method="POST">
  <table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000">
    <tr bgcolor="#B1E1F3"> 
      <th height="30" colspan="4"> <div align="center"><strong>所有统计文件</strong></div></th>
  </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(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,tjtime 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 colspan='4'>暂无内容</td></tr>
		  <%}else{%>
		<%-- 显示每页的数据 (根据i的值判断每页的5条记录) --%>
		<%i=0;
		while(i<intPageSize && rs.next()){%>  

  <tr> 
    <td width="53%"><div align="center"><%=rs.getString("tjtitle")%></div></td>
    <td width="27%"><div align="center"><%=rs.getString("tjtime")%></div></td>
    <td width="10%"><div align="center"><a href="edittj.jsp?id=<%=rs.getString("tjid")%>">修改</a>/<a href="deltj.jsp?id=<%=rs.getString("tjid")%>">删除</a></div></td>
    <td width="10%"><div align="center">
        <input type="checkbox" name="Board" id="<%=rs.getString("tjid")%>" style="font-size: 9pt">
      </div></td>
  </tr>
 <%  i++;} 
}%>
  <tr>
    <td colspan="4"> <div align="center"> &nbsp;&nbsp; <a href="addtj.jsp">添加统计文件</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('deltj.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_tj.jsp?page=<%=intPage+1%>">下一页</a>&nbsp;&nbsp;&nbsp;
				<%}%>
				<%if(intPage>1){%>
				<a href="admin_tj.jsp?page=<%=intPage-1%>">上一页</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
				<%}%>
				 </div>
				 </td>
  </tr>
</table>
</form>
</body>
</html>