sort_new.jsp

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

<%@ include file="admintop.jsp"%>
<%@ include file="isadmin.jsp"%>
<SCRIPT>
function checkForm(frm)
{
	if (frm.key.value == null || frm.key.value.length == 0) {
		alert("请输入要检索的关键字!");
		frm.keyword.focus();
		return false;
	}

	return true;
}  
</SCRIPT>
<form name="form1" method="POST">
  <table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000">
    <tr bgcolor="#B1E1F3"> 
    <%

	String  sql;
      String id=request.getParameter("id");   
	  String action1=request.getParameter("action");
	  String keys=request.getParameter("key"); 
	 sql="select * from scott.allsort order by id desc";
	    ResultSet rst=stmt.executeQuery(sql); 
	%>
	<td height="30" colspan="4"> <div align="center"><strong>请选择栏目:</strong>&nbsp;&nbsp;
	    <script>
 function GoToWhere(s)
 {
 var d = s.options[s.selectedIndex].value;
 window.location=d;
 s.selectedIndex=0;
 }
//-->
</script> <select  onChange=GoToWhere(this) name=select5 class="new">
       <option value="sort_new.jsp">所有栏目</option>
	   <% while(rst.next()) {  %>
        <option value="sort_new.jsp?id=<%=rst.getString("id")%>" ><%=rst.getString("sort")%></option>
        
        <% } %>
      </select> 
	</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(*) from scott.allarti order by id 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.allarti order by id 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="../listarti.jsp?id=<%=rs.getString("id")%>" target="_blank"><%=rs.getString("title")%></a></div></td>
    <td width="27%"><div align="center"><%=rs.getString("times")%></div></td>
    <td width="10%"><div align="center"><a href="editsortnew.jsp?id=<%=rs.getString("id")%>">修改</a>/<a href="delsortnew.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; <a href="addsortnew.jsp">添加新闻</a>&nbsp;&nbsp; 
         
        <input type="button" value="清 空" onclick="sltNull()" name=button2>
        &nbsp;&nbsp; 
        <input type="submit" value="删 除" name="tijiao" onclick="SelectChk('delsortnew.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="sort_new.jsp?page=<%=intPage+1%>">下一页</a>&nbsp;&nbsp;&nbsp;
				<%}%>
				<%if(intPage>1){%>
				<a href="sort_new.jsp?page=<%=intPage-1%>">上一页</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
				<%}%>
				 </div>
    </td>
  </tr>
</table>
</form>
<%@ include file="adminfoot.jsp"%>
</body>
</html>