search.jsp

自己写的新闻发布系统

<%@page contentType="text/html; charset=ISO8859_1" language="java" %>
<jsp:useBean id="empire" scope="page" class="Eclass.jdbc_sql" />
<%@ include file="template/1_1.jsp" %>
<%
java.sql.ResultSet rs=null;
java.sql.ResultSet rs1=null;
String filename="search.jsp";
int pageno=0,page_line=8,line=20,start=0,num=0,offset=0;
int newsid=0,bclassid=0,classid=0,i=0;
int to_offset=0;
String big_options="",options="",select="",add1="";
String title="",time="",sear=request.getParameter("sear"),keyboard=request.getParameter("keyboard");
String search="",returnpage="",query="",show=request.getParameter("show"),add="",db_keyboard="";
if(request.getParameter("bclassid")==null)
{bclassid=0;}
else
{bclassid=Integer.parseInt(request.getParameter("bclassid"));}
if(request.getParameter("classid")==null)
{classid=0;}
else
{classid=Integer.parseInt(request.getParameter("classid"));}
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;//取得偏移量
add1=" (title like '%"+keyboard+"%' or newstext like '%"+keyboard+"%')";
search="&keyboard="+keyboard;
//分类
if(bclassid!=0)
{
add=" where bclassid="+bclassid+" and"+add1;
search+="&bclassid="+bclassid;
if(classid!=0)
{add=" where classid="+classid+" and"+add1;
search+="&classid="+classid;
}
}
else
{
add=" where"+add1;
}
//取得总条数
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";
rs=empire.query(query);
//---------------------去掉偏移
for(int k=1;k<=offset;k++)
{rs.next();}
to_offset=num-offset;//减去偏移量后所得的值
//取得页数
returnpage=empire.page1(num,line,page_line,start,pageno,search,filename);
%>
<script>
function change(obj)
{
self.location.href="search.jsp?bclassid="+obj.bclassid.value;
}
</script>
<link rel="stylesheet" href="../images/ebb.css" type="text/css">
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="1"  bgcolor="">
<tr><td>位置：<a href=/index.jsp>首页</a>&nbsp;--->&nbsp;搜索</td></tr></table>
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="1"  bgcolor="">
<tr><td><script src=js/NewsSearch1.js></script></td></tr></table><br>
<table width=95% align=center>
<%
for(int for_i=1;for_i<=to_offset&&for_i<=line;for_i++)
{
rs.next();
newsid=rs.getInt("newsid");
title=rs.getString("title");
time=rs.getString("time");
i++;
%>  
<tr bgcolor="#FFFFFF"> 
    <td> <%=i%>、<a href='data/<%=rs.getString("newspath")%>/<%=newsid%>.jsp' target=_blank><%=title%></a>&nbsp;击点:<%=rs.getInt("onclick")%>
    &nbsp;&nbsp;(<%=time%>)</td>
</tr>
<%
}
%>
</table>
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="1"  bgcolor="ffffff">
  <tr> <td><%=returnpage%></td></tr></table>
<%
rs.close();
empire.closestmt();
empire.closeconn();
%>
<%@ include file="template/1_2.jsp" %>