listnews.jsp

自己写的新闻发布系统

<%@page contentType="text/html; charset=gb2312" language="java" %>
<%
String news_location="listnews";
%>
<%@ include file="session.jsp" %>
<jsp:useBean id="empire" scope="page" class="Eclass.jdbc_sql" />
<%
java.sql.ResultSet rs=null;
java.sql.ResultSet rs1=null;
String filename="ListNews.jsp";
int pageno=0,page_line=8,line=20,start=0,num=0,offset=0;
int newsid=0;
String title="",time="",sear=request.getParameter("sear"),keyboard=request.getParameter("keyboard");
String search="",returnpage="",query="",show=request.getParameter("show"),add="",db_keyboard="";
if(keyboard==null)
{keyboard="";}
if(sear==null)
{sear="";}
if(show==null)
{show="0";}
if(request.getParameter("page")!=null)
{pageno=Integer.parseInt(request.getParameter("page"));}
if(request.getParameter("start")!=null)
{start=Integer.parseInt(request.getParameter("start"));}
offset=start+line*pageno;//取得偏移量
//搜索
if(sear.equals("1"))
{db_keyboard=new String(keyboard.getBytes("gb2312"),"ISO8859-1");
if(show.equals("0"))
{add=" where (title like '%"+db_keyboard+"%') or (newstext like '%"+db_keyboard+"%')";}
else if(show.equals("1"))
{add=" where (title like '%"+db_keyboard+"%')";}
else
{add=" where (newstext like '%"+db_keyboard+"%')";}
search="&sear=1&show="+show+"&keyboard="+keyboard;
}
//取得总条数
query="select count(*) as total from enews_news"+add;
rs1=empire.query(query);
rs1.next();
num=rs1.getInt("total");
rs1.close();
//显示记录
query="select newsid,title,time,newspath,onclick from enews_news"+add+" order by newsid desc limit "+offset+","+line;
rs=empire.query(query);
//取得页数
returnpage=empire.page1(num,line,page_line,start,pageno,search,filename);
%>
<link rel="stylesheet" href="../images/ebb.css" type="text/css">
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="1"  bgcolor="">
  <form name=form1 method=post action=ListNews.jsp><input type=hidden name=sear value=1><tr><td>搜索：<input type=text name=keyboard>
<select name=show><option value=0>所有</option><option value=1>新闻标题</option><option value=2>新闻内容</option></select>
<input type=submit name=submit value="搜索">
</td></tr></form></table>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="1"  bgcolor="3370A6">
  <tr> 
    <td width="4%"><div align="center"><font color=ffffff>ID</font></div></td>
    <td width="55%"><div align="center"><font color=ffffff>标题</font></div></td>
    <td width="26%"><div align="center"><font color=ffffff>发布时间</font></div></td>
    <td width="8%"><div align="center"><font color=ffffff>修改</font></div></td>
    <td width="7%"><div align="center"><font color=ffffff>删除</font></div></td>
  </tr>
<%
while(rs.next())
{newsid=rs.getInt("newsid");
title=rs.getString("title");
time=rs.getString("time");
%>  
<tr bgcolor="#FFFFFF"> 
    <td> <div align="center"><%=newsid%></div></td>
    <td> <div align="left"><a href='../data/<%=rs.getString("newspath")%>/<%=newsid%>.jsp' target=_blank><%=title%></a>&nbsp;(击点:<%=rs.getInt("onclick")%>)</div></td>
    <td> <div align="center"><%=time%></div></td>
    <td> <div align="center"><a href=AddNews.jsp?action=EditNews&newsid=<%=newsid%>>修改</a></div></td>
    <td> <div align="center"><a href=AddNews.jsp?action=DelNews&newsid=<%=newsid%> onclick="return confirm('确认要删除？');">删除</a></div></td>
  </tr>
<%
}
%>
</table>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="1"  bgcolor="ffffff">
  <tr> <td><%=returnpage%></td></tr></table>
<%
rs.close();
empire.closestmt();
empire.closeconn();
%>