📄 shownews.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<style type="text/css">
<!-- @import url(images/css.css); -->
</style>
<script language="JavaScript">
function show(a)
{
window.open("newspage.jsp?show="+a,"body","scrollbars=yes,width=500,height=500");
}
</script>
<%
String sql="";
String assort="";
String sqland="";
String key=request.getParameter("key");
if(key.equals("all"))
{ sql="select * from news order by id desc"; }
if(key.equals("pic"))
{ sql="select * from news where chkpic='"+"0"+"' order by id desc"; }
if(key.equals("txt"))
{ sql="select * from news where chkpic='"+"1"+"' order by id desc"; }
if(key.equals("search"))
{
String news=request.getParameter("news");
String field=request.getParameter("field");
field=new String(field.getBytes("ISO8859_1"),"GBK");
if(news.equals("pic"))
{
assort=" chkpic='"+"0"+"' ";
sqland=" and ";
}
if(news.equals("type"))
{
assort=" chkpic='"+"1"+"' ";
sqland=" and ";
}
sql="select * from news where "+assort+sqland+" title like '%"+field+"%' order by id desc";
}
%>
<body leftmargin="0" topmargin="0">
<table border=0 cellPadding=0 cellSpacing=0 width=560>
<%
int pagesize=15;
int allcount;
int allpage;
int intpage;
int i;
String strpage=request.getParameter("page");
if(strpage==null)
{
intpage=1;
}
else{
intpage=Integer.parseInt(strpage);
if(intpage<1) intpage=1;
}
ResultSet rs=data.executeQuery(sql);
int all=0;
while(rs.next())
{ all++; }
allcount=all;
allpage=(allcount+pagesize-1)/pagesize;
if(intpage>allpage) intpage=allpage;
if(allpage>0)
{
rs.absolute((intpage-1)*pagesize+1);
int id=rs.getInt("id");
%>
<tr>
<td width="40" height=25><div align="center"><%=id%></div></td>
<td width="270"> <a href="javascript:show(<%=id%>)"><%=rs.getString("title")%></a></td>
<td width="70"><div align="center"><font color="#999999"><%=rs.getString("addid")%></font></div></td>
<td width="100"><div align="center"><%=rs.getString("addtime").substring(0,10)%></div></td>
<td width="80"><div align="center"><%=rs.getInt("counter")%></div></td>
</tr>
<tr>
<td background="images/news_dot_line.gif" colSpan=6 height=3></td>
</tr>
<%
i=1;
id=0;
String title="";
String addid="";
String addtime="";
int counter=0;
while(i<pagesize && rs.next())
{
id=rs.getInt("id");
title=rs.getString("title");
addid=rs.getString("addid");
addtime=rs.getString("addtime").substring(0,10);
counter=rs.getInt("counter");
%>
<tr>
<td width="40" height=25><div align="center"><%=id%></div></td>
<td width="270"> <a href="javascript:show(<%=id%>)"><%=title%></a></td>
<td width="70"><div align="center"><font color="#999999"><%=addid%></font></div></td>
<td width="100"><div align="center"><%=addtime%></div></td>
<td width="80"><div align="center"><%=counter%></div></td>
</tr>
<tr>
<td background="images/news_dot_line.gif" colSpan=6 height=3></td>
</tr>
<%
i++;
}}%>
</table>
<form action="" method="post">
<div align="center">当前<font color="#FF0000"><%=intpage%></font>/<font color="#FF0000"><%=allpage%></font>页，每页<font color="#FF0000"><%=pagesize%></font>条
<%if(intpage>1)
{
if(intpage==1)
{%>
<a href="shownews.jsp?page=<%=intpage-1%>&key=<%=key%>">上一页 </a>
<%} else{%>
<a href="shownews.jsp?page=<%=1%>&key=<%=key%>">最前页</a><a href="shownews.jsp?page=<%=intpage-1%>&key=<%=key%>"> 上一页</a>
<%}}%>
<%
if(intpage<allpage)
{
if(intpage==allpage)
{%>
<a href="shownews.jsp?page=<%=intpage+1%>&key=<%=key%>">下一页</a>
<%}else{%>
<a href="shownews.jsp?page=<%=intpage+1%>&key=<%=key%>">下一页 </a><a href="shownews.jsp?page=<%=allpage%>&key=<%=key%>">最后页</a>
<%}}%>
</div>
</form>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -