📄 search.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="../top.jsp"%>
<%@ include file="../conn/conn.jsp"%>
<%@ include file="../conn/substring.jsp"%>
<%@ page import="com.lynews.news.*"%>
<%
String lei =request.getParameter("lei");
String key = request.getParameter("key");
if(key==null)key = "";
if(key.equals("供求信息关键字")){
key ="";
}
%>
<TABLE cellSpacing=0 cellPadding=0 width="750" align=center border=0>
<TBODY>
<TR>
<TD><IMG
src="../images/online_768.gif" width=750 border=0></TD></TR>
</TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="750" align=center border=0>
<TBODY>
<TR>
<TD bgColor=#ffffff>
<TABLE cellSpacing=0 cellPadding=0 width="100%" align=left
bgColor=#ff5d00 border=0>
<TBODY>
<TR>
<TD bgColor=#cccccc height=6></TD></TR>
<TR>
<TD height=30>
<TABLE height=30 cellSpacing=0 cellPadding=0 width=750 align=left
border=0>
<TBODY>
<TR>
<TD align=middle align=left>
<strong>
<DIV align=left><img src=../images/icon_point.gif><font color=ffffff size=3>
关于"<%=key%>"的<%if(Integer.parseInt((String)lei)==0){%>所有<%}%><%if(Integer.parseInt((String)lei)==1){%>供应<%}%><%if(Integer.parseInt((String)lei)==2){%>求购<%}%><%if(Integer.parseInt((String)lei)==3){%>代理<%}%><%if(Integer.parseInt((String)lei)==4){%>合作<%}%>信息
</font></strong>
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="blackbordernobottom">
<tr>
<td <%if(Integer.parseInt((String)lei)==0){%> class="buttoncolor" <%}%> class="norightbuttonborder"><a href="search.jsp?&lei=0&key=<%=request.getParameter("key")%>">所有信息</a></td>
<td <%if(Integer.parseInt((String)lei)==1){%> class="buttoncolor" <%}%> class="norightbuttonborder"><a href="search.jsp?lei=1&key=<%=request.getParameter("key")%>">供应信息</a></td>
<td <%if(Integer.parseInt((String)lei)==2){%> class="buttoncolor" <%}%> class="norightbuttonborder"><a href="search.jsp?lei=2&key=<%=request.getParameter("key")%>">求购信息</a></td>
<td <%if(Integer.parseInt((String)lei)==3){%> class="buttoncolor" <%}%> class="norightbuttonborder"><a href="search.jsp?lei=3&key=<%=request.getParameter("key")%>">代理信息</a></td>
<td <%if(Integer.parseInt((String)lei)==4){%> class="buttoncolor" <%}%> class="norightbuttonborder"><a href="search.jsp?lei=4&key=<%=request.getParameter("key")%>">合作信息</a></td>
</tr>
</table>
</TD></TR></TBODY></TABLE></DIV></TD></TR>
<TR>
<TD background=index.files/bg_navline.gif
height=5></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<body leftmargin="0" topmargin="0">
<div align="center">
<table width="750" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor=ffffff>
<tr>
<tr>
<td height="2"> </td>
</tr>
<tr>
<td height="10"> </td>
</tr>
<tr>
<td background="images/fl2_21.gif"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<%
stmt = con.createStatement() ;
if(Integer.parseInt((String)lei)==0){
rs=stmt.executeQuery("SELECT * from sjxx where (topic like '%"+key+"%' or content like '%"+key+"%') and ok=1 order by id desc");
}else{
rs=stmt.executeQuery("SELECT * from sjxx where (topic like '%"+key+"%' or content like '%"+key+"%') and lei='"+lei+"' and ok=1 order by id desc");
}
String pages = request.getParameter("page") ;
int pageInt = 1 ,i=0 ;
if(pages==null){}else{pageInt = Integer.parseInt(pages);}
while(i<20*(pageInt-1)&&rs.next()){i++ ;}
i=0;
int k = 1;
k++ ;
while(rs.next()&i<20){
i++ ;
%>
<tr <%if (k==2){k-- ;%>bgcolor=f3f3f3<%}else{%> bgcolor=ffffff<%k++ ;}%>>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="15" height="25"> </td>
<td width="15"> <div align="center"><img src="images/dswj_9.gif" width="9" height="9"></div></td>
<td class="fl"><strong><img src=../images/point.gif><a href="sjxx.jsp?id=<%=rs.getString("id")%>" target="_blank"><font color="blue">
<%if(key ==""){%><%=rs.getString("topic")%><%}else{%>
<%=ReplaceAll.replace(rs.getString("topic"),key,"<font color=#ff0000>"+key+"</font>")%>
<%}%>
</font></a></strong></td>
</tr>
<tr>
<td height="25"> </td>
<td><div align="center"><img src="images/fl2_24.gif" width="5" height="5"></div></td>
<td class="zl"><font color="#000000">[<font color="#8F1507"><%=rs.getString("fbtime")%></font>]</font></td>
</tr>
<tr>
<td height="25"> </td>
<td><div align="center"></div></td>
<td class="zl"><font color="#000000"><img src=../images/point1.gif>
<%if(key ==""){%><%=substringChinese(rs.getString("content"),0,300)%><%}else{%>
<%=ReplaceAll.replace((substringChinese(rs.getString("content"),0,300)),key,"<font color=#ff0000>"+key+"</font>")%>...
<%}%>
</font></td>
</tr>
<iframe frameborder=0 leftmargin=0 marginheight=0 marginwidth=0 scrolling=no src="html/<%=rs.getString("fileName")%>" topmargin=0 width=20 height=0></iframe>
<tr>
<td height="25"> </td>
<td><div align="center"><img src="images/fl2_24.gif" width="5" height="5"></div></td>
<td class="zl"><img src=../images/RedArrow.gif><font color="#000000">[<a href="sjxx.jsp?id=<%=rs.getString("id")%>" target="_blank"><font color=#ff6600>详细信息</a></font>]</font></td>
</tr>
<tr>
<td height="25"> </td>
<td><div align="center"><img src="images/fl2_24.gif" width="5" height="5"></div></td>
<td class="zl"><br></td>
</tr>
</table></td>
</tr>
<%
}
%>
<tr>
<td height="25"><img src="images/fl2_23.gif" width="573" height="6"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="60"><div align="right">
<table width="98%" height="33" border="0" cellpadding="0" cellspacing="0" align=right>
<tr>
<td bgcolor="F1F1F1"><table width="100%" border="0" cellspacing="0" cellpadding="0" align=right>
<%
if(Integer.parseInt((String)lei)==0){
rs=stmt.executeQuery("SELECT count(*) from sjxx where (topic like '%"+key+"%' or content like '%"+key+"%') and ok=1 order by id desc");
}else{
rs=stmt.executeQuery("SELECT count(*) from sjxx where (topic like '%"+key+"%' or content like '%"+key+"%') and lei='"+lei+"' and ok=1 order by id desc");
}
while(rs.next()) i = rs.getInt(1) ;
%>
<tr>
<td width="10"> </td>
<td width="300" class="zl"><font color="#000000">总共</font><font color="#FF0000"><%=i%></font><font color="#000000">条信息</font>
分<font color="#000000"><%=(i+20)/20%>页</font> 当前为<font color="#000000">第</font><font color="#FF0000"><%=pageInt%></font><font color="#000000">页</font>
</td>
<td width="10"> </td>
<td>
<td><form action="search.jsp" method="post">
<input name=key type="hidden" value="<%=request.getParameter("key")%>">
<input name=lei type="hidden" value="<%=lei%>">
第<input name="page" type=text size="2" value=<%=pageInt%>>页
<input name="page" type=submit size="2" value="Go">
</form></td>
<td>
<%if (pageInt>1){%><a href=search.jsp?page=<%=pageInt-1%>&key=<%=request.getParameter("key")%>&lei=<%=lei%>><%}%>[上一页]</a>
<%int bb=(i+20)/20;%><%if (pageInt<bb){%><a href=search.jsp?page=<%=pageInt+1%>&key=<%=request.getParameter("key")%>&lei=<%=lei%>><%}%>[下一页]</a></td>
<%
rs.close();
stmt.close();
con.close();
%>
<td width="10"> </td>
</tr>
</table></td>
</tr>
</table>
</div></td>
</tr>
</table></td>
<td width="188" valign="top"> <div align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center"><img src=../images/fl2_12.gif></div></td>
</tr>
<tr>
<td height="30"> <div align="center"></div></td>
</tr>
<tr>
<td><div align="center"><img src=../images/fl2_12.gif></div></td>
</tr>
<tr>
<td height="30"> <div align="center"></div></td>
</tr>
<tr>
<td><div align="center"><img src=../images/fl2_12.gif></div></td>
</tr>
<tr>
<td height="30"> <div align="center"></div></td>
</tr>
<tr>
<td><div align="center"><img src=../images/fl2_12.gif></div></td>
</tr>
<tr>
<td><div align="center"></div></td>
</tr>
<tr>
<td><div align="center"></div></td>
</tr>
<tr>
<td><div align="center"></div></td>
</tr>
</table>
</div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="84"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="2" bgcolor="dddddd"><img src="images/spacer.gif" width="1" height="1"></td>
</tr>
<tr>
<td height="82" valign="top" bgcolor="F1F1F1"> <div align="center">
<%@ include file="../end.jsp"%>
</div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -