<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.lang.Math.*"%><%@ include file="checkvalidadmin.jsp"%>
<jsp:useBean id="conn" scope="page" class="db.ConnOracle"/>
<%!
ResultSet rs = null;
ResultSet rs2 = null;
ResultSet rsTmp = null;
String sql = "";
int PageSize = 6;
int Page = 1;
int totalPage = 1;
String str = ""; String priv_ok = "";public String ShowOnePage(ResultSet rs, int Page,int PageSize){
str = "";
//先将记录指针定位到相应的位置
try{
rs.absolute((Page-1)*PageSize+1);
//int posion = (Page-1) * PageSize+1;
//rs.absolute(posion); //设置游标的值
}catch(SQLException e){
}
for(int iPage = 1; iPage<=PageSize;iPage++){
str+= ShowOneRecord(rs,Page);
try{
if(!rs.next()) break;
}catch(Exception e){}
}
return str;
}//显示单行记录子模块,由于要将当前页码传递到后面的修改和删除页码,
//因此,下面的showOneRecord方法多了第二个参数public String ShowOneRecord(ResultSet rs,int Page ){ String tt = "";
int endindex =28;//在默认情况下显示新闻标题中的前28个汉字字符
String tmp="";
try{
tt+="<form action=newschange.jsp method=post><tr>";
tt+="<td height=25 align=center valign=middle bgcolor=#ffffff><input type=hidden name=newsid value="+rs.getInt("newsid")+">";
//tt+="<input type=hidden name=Page value="+Page+">";
tt+=rs.getInt("newsid");
//tt+="<input type=hidden name=newsid value="+rs.getInt("newsid")+"</td>";
tt+="</td>";
//格式化新闻标题
tmp = rs.getString("newstitle");
if(tmp.length() < endindex){
endindex = tmp.length();
}
tt+="<td align=center valign=middle bgcolor=#ffffff ><A href=newsedit.jsp?oid="+rs.getInt("newsid")+" target=_blank title="+rs.getString("newstitle")+">";
//新闻标题格式化
tt+=tmp.substring(0,endindex);
tt+="</A></td>";
tt+="<td align=center valign=middle bgcolor=#ffffff>"+rs.getString("newstype")+"</td>";
tt+="<td align=center valign=middle bgcolor=#ffffff>"+rs.getString("newstime")+"</td>";
tt+="<td align=center valign=middle bgcolor=#ffffff><input type=checkbox name=newsflag";
if(rs.getInt("newsflag")==1){
tt+=" checked"; }
tt+="></td>";
tt+="<td align=center valign=middle bgcolor=#ffffff>";
tt+="<input type=checkbox name=flag";
if(rs.getInt("flag")==1){
tt+=" checked"; }
tt+=" ></td>";
tt+="<td align=center valign=middle bgcolor=#ffffff><input type=Submit value=审核 name=oper></td>";
tt+="<td align=center valign=middle bgcolor=#ffffff><input type=Submit value=置顶 name=oper></td>";
//tt+="<td align=center valign=middle><input type=Submit value=修改 name=oper></td>";
tt+="<td align=center valign=middle bgcolor=#ffffff><input type=Submit value=删除 name=oper></td>";
tt+="</tr></form>";
}catch(SQLException e){}
return tt;
}%><%
// sql = "select * from jyzd_news";
sql = "select * from jyzd_news order by newstime desc";
try{
rs = conn.executeQuery(sql);
}catch(Exception e){
out.println("访问新闻表数据出错!");
return;
}
if(! rs.next()){
out.println("系统中暂时还没有新闻!");
return;
}
%>
<html>
<head>
<title>新闻编辑 - Power by Rabin !</title>
<link rel="stylesheet" type="text/css" href="styles.css">
</head>
<body>
<CENTER>
<%@ include file="top.jsp"%>
<%
priv_ok = (String)request.getSession(true).getAttribute("adminpriv");
if (priv_ok!=null&&priv_ok.equals("admin")||priv_ok.equals("check")){
%>
<%
//获取新闻分类列表
rs2=conn.executeQuery("select typeid,typename from jyzd_type");
if (!rs2.next()){
out.println("<center>");
out.println("数据库中还没有新闻分类!<BR>");
out.println("单击这里<a href=javascript:history.back()>返回</a><br>");
out.println("</center>");
}else{
%>
<table border=0><TR>
<% do{ %>
<td width=70>[<a href="newscheck.jsp?tid=<%=rs2.getInt("typeid")%>"><%=rs2.getString("typename")%></a>]</td>
<%}while(rs2.next());%>
</TR></table>
<%
rs2.close();
} //获取新闻分类结束%>
<table width="80%" border="0" cellspacing="1" cellpadding="1" bgcolor="#336699">
<tr>
<td height=25 align=center valign=middle widht=10% bgcolor="#ffffff">编号</td>
<td align=center valign=middle width=40% bgcolor="#ffffff">新闻标题 (点击标题编辑)</td>
<td align=center valign=middle width=10% bgcolor="#ffffff">新闻分类</td>
<td align=center valign=middle width=10% bgcolor="#ffffff">发布时间</td>
<td align=center valign=middle width=5% bgcolor="#ffffff">审核</td>
<td align=center valign=middle width=5% bgcolor="#ffffff">置顶</td>
<td colspan=3 align=center valign=middle width=20% bgcolor="#ffffff">操 作</td>
</tr>
<%
rsTmp = conn.executeQuery("select count(*) as mycount from jyzd_news");
rsTmp.next();
int totalrecord = rsTmp.getInt("mycount");
if (totalrecord % PageSize == 0) totalPage = totalPage / PageSize; //如果是当前页码的整数倍
else totalPage = (int) Math.floor(totalrecord / PageSize)+1; //如果最后还余一页
if(totalPage==0) totalPage = 1;
rsTmp.close();
try{
if(request.getParameter("Page")==null||request.getParameter("Page").equals("")){
Page = 1;
}else{
Page = Integer.parseInt(request.getParameter("Page"));
//捕获用户浏览器地址栏直接输入类似于Page = sdfsdfsdf 等非法信息所造成的异常
}
}catch(NumberFormatException e){
Page = 1;
}
if (Page<1) Page=1;
if (Page>totalPage) Page =totalPage;
%>
<%
//显示动态分页内容
out.println(ShowOnePage(rs,Page,PageSize));
// rs.next();
%>
</table>
<table border=0 align=center>
<FORM action="newscheck.jsp" method="GET">
<tr><td align=center>
<%
if(Page!=1){
out.println("| <a href=newscheck.jsp?Page=1>第一页</a> |");
out.println("<a href=newscheck.jsp?Page="+(Page-1)+">上一页</a> |");
}
if(Page!=totalPage){
out.println("<a href=newscheck.jsp?Page="+(Page+1)+">下一页</a> |");
out.println("<a href=newscheck.jsp?Page="+totalPage+">最后一页</a> |");
}
rs.close();
%>
输入页数:<INPUT type="text" Name="Page" size=3> 页数:<font color="Red"><%=Page%>/<%=totalPage%></font>
新闻总数:<font color="red"><%=totalrecord%></font>
</td></tr>
</FORM >
</table>
<%
} else{
out.println("对不起,您的权限不足!<br>");
out.println("单击这里<a href= javascript:history.back()>返回</a><br>");
}
%>
<%@ include file="buttom.html"%> </CENTER>
</body>
</html>
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.lang.Math.*"%><%@ include file="checkvalidadmin.jsp"%>
<jsp:useBean id="conn" scope="page" class="db.ConnOracle"/>
<%!
ResultSet rs = null;
ResultSet rs2 = null;
ResultSet rsTmp = null;
String sql = "";
int PageSize = 6;
int Page = 1;
int totalPage = 1;
String str = ""; String priv_ok = "";public String ShowOnePage(ResultSet rs, int Page,int PageSize){
str = "";
//先将记录指针定位到相应的位置
try{
rs.absolute((Page-1)*PageSize+1);
//int posion = (Page-1) * PageSize+1;
//rs.absolute(posion); //设置游标的值
}catch(SQLException e){
}
for(int iPage = 1; iPage<=PageSize;iPage++){
str+= ShowOneRecord(rs,Page);
try{
if(!rs.next()) break;
}catch(Exception e){}
}
return str;
}//显示单行记录子模块,由于要将当前页码传递到后面的修改和删除页码,
//因此,下面的showOneRecord方法多了第二个参数public String ShowOneRecord(ResultSet rs,int Page ){ String tt = "";
int endindex =28;//在默认情况下显示新闻标题中的前28个汉字字符
String tmp="";
try{
tt+="<form action=newschange.jsp method=post><tr>";
tt+="<td height=25 align=center valign=middle bgcolor=#ffffff><input type=hidden name=newsid value="+rs.getInt("newsid")+">";
//tt+="<input type=hidden name=Page value="+Page+">";
tt+=rs.getInt("newsid");
//tt+="<input type=hidden name=newsid value="+rs.getInt("newsid")+"</td>";
tt+="</td>";
//格式化新闻标题
tmp = rs.getString("newstitle");
if(tmp.length() < endindex){
endindex = tmp.length();
}
tt+="<td align=center valign=middle bgcolor=#ffffff ><A href=newsedit.jsp?oid="+rs.getInt("newsid")+" target=_blank title="+rs.getString("newstitle")+">";
//新闻标题格式化
tt+=tmp.substring(0,endindex);
tt+="</A></td>";
tt+="<td align=center valign=middle bgcolor=#ffffff>"+rs.getString("newstype")+"</td>";
tt+="<td align=center valign=middle bgcolor=#ffffff>"+rs.getString("newstime")+"</td>";
tt+="<td align=center valign=middle bgcolor=#ffffff><input type=checkbox name=newsflag";
if(rs.getInt("newsflag")==1){
tt+=" checked"; }
tt+="></td>";
tt+="<td align=center valign=middle bgcolor=#ffffff>";
tt+="<input type=checkbox name=flag";
if(rs.getInt("flag")==1){
tt+=" checked"; }
tt+=" ></td>";
tt+="<td align=center valign=middle bgcolor=#ffffff><input type=Submit value=审核 name=oper></td>";
tt+="<td align=center valign=middle bgcolor=#ffffff><input type=Submit value=置顶 name=oper></td>";
//tt+="<td align=center valign=middle><input type=Submit value=修改 name=oper></td>";
tt+="<td align=center valign=middle bgcolor=#ffffff><input type=Submit value=删除 name=oper></td>";
tt+="</tr></form>";
}catch(SQLException e){}
return tt;
}%><%
// sql = "select * from jyzd_news";
sql = "select * from jyzd_news order by newstime desc";
try{
rs = conn.executeQuery(sql);
}catch(Exception e){
out.println("访问新闻表数据出错!");
return;
}
if(! rs.next()){
out.println("系统中暂时还没有新闻!");
return;
}
%>
<html>
<head>
<title>新闻编辑 - Power by Rabin !</title>
<link rel="stylesheet" type="text/css" href="styles.css">
</head>
<body>
<CENTER>
<%@ include file="top.jsp"%>
<%
priv_ok = (String)request.getSession(true).getAttribute("adminpriv");
if (priv_ok!=null&&priv_ok.equals("admin")||priv_ok.equals("check")){
%>
<%
//获取新闻分类列表
rs2=conn.executeQuery("select typeid,typename from jyzd_type");
if (!rs2.next()){
out.println("<center>");
out.println("数据库中还没有新闻分类!<BR>");
out.println("单击这里<a href=javascript:history.back()>返回</a><br>");
out.println("</center>");
}else{
%>
<table border=0><TR>
<% do{ %>
<td width=70>[<a href="newscheck.jsp?tid=<%=rs2.getInt("typeid")%>"><%=rs2.getString("typename")%></a>]</td>
<%}while(rs2.next());%>
</TR></table>
<%
rs2.close();
} //获取新闻分类结束%>
<table width="80%" border="0" cellspacing="1" cellpadding="1" bgcolor="#336699">
<tr>
<td height=25 align=center valign=middle widht=10% bgcolor="#ffffff">编号</td>
<td align=center valign=middle width=40% bgcolor="#ffffff">新闻标题 (点击标题编辑)</td>
<td align=center valign=middle width=10% bgcolor="#ffffff">新闻分类</td>
<td align=center valign=middle width=10% bgcolor="#ffffff">发布时间</td>
<td align=center valign=middle width=5% bgcolor="#ffffff">审核</td>
<td align=center valign=middle width=5% bgcolor="#ffffff">置顶</td>
<td colspan=3 align=center valign=middle width=20% bgcolor="#ffffff">操 作</td>
</tr>
<%
rsTmp = conn.executeQuery("select count(*) as mycount from jyzd_news");
rsTmp.next();
int totalrecord = rsTmp.getInt("mycount");
if (totalrecord % PageSize == 0) totalPage = totalPage / PageSize; //如果是当前页码的整数倍
else totalPage = (int) Math.floor(totalrecord / PageSize)+1; //如果最后还余一页
if(totalPage==0) totalPage = 1;
rsTmp.close();
try{
if(request.getParameter("Page")==null||request.getParameter("Page").equals("")){
Page = 1;
}else{
Page = Integer.parseInt(request.getParameter("Page"));
//捕获用户浏览器地址栏直接输入类似于Page = sdfsdfsdf 等非法信息所造成的异常
}
}catch(NumberFormatException e){
Page = 1;
}
if (Page<1) Page=1;
if (Page>totalPage) Page =totalPage;
%>
<%
//显示动态分页内容
out.println(ShowOnePage(rs,Page,PageSize));
// rs.next();
%>
</table>
<table border=0 align=center>
<FORM action="newscheck.jsp" method="GET">
<tr><td align=center>
<%
if(Page!=1){
out.println("| <a href=newscheck.jsp?Page=1>第一页</a> |");
out.println("<a href=newscheck.jsp?Page="+(Page-1)+">上一页</a> |");
}
if(Page!=totalPage){
out.println("<a href=newscheck.jsp?Page="+(Page+1)+">下一页</a> |");
out.println("<a href=newscheck.jsp?Page="+totalPage+">最后一页</a> |");
}
rs.close();
%>
输入页数:<INPUT type="text" Name="Page" size=3> 页数:<font color="Red"><%=Page%>/<%=totalPage%></font>
新闻总数:<font color="red"><%=totalrecord%></font>
</td></tr>
</FORM >
</table>
<%
} else{
out.println("对不起,您的权限不足!<br>");
out.println("单击这里<a href= javascript:history.back()>返回</a><br>");
}
%>
<%@ include file="buttom.html"%> </CENTER>
</body>
</html>
ShowOnePage
函数看不出哪里有问题