📄 search.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage=""%>
<jsp:useBean id="conndb" scope="page" class="beans.connDB"/>
<jsp:useBean id="chstr" scope="page" class="beans.chStr"/>
<HTML>
<HEAD>
<TITLE>Site Title</TITLE>
<script language="javascript">
function nullOrNo(){
if((document.searchform.category.selectedIndex==0)&&(document.searchform.bookname.value.length==0)&&(document.searchform.publisher.value.length==0)&&(document.searchform.author.value.length==0)&&(document.searchform.pubdate1.value.length==0)&&(document.searchform.pubdate2.value.length==0))
{alert("请输入查询参数");
return;
}
document.searchform.submit();
}
</script>
<style type="../../web/text/css">
<!--
@import url("../../web/css_link.css");
@import url("../../web/text.css");
@import url("../../web/css_link.css");
-->
</style>
</HEAD>
<BODY BGCOLOR=#FFFFFF LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0>
<table width="100%" height="397" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="386" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="189" height="397" valign="top" background="../../web/images/side_back.jpg">
<table width="100%" height="398" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="398" valign="top" background="../../web/images/home_side.jpg">
</td>
</tr>
</table></td>
<td valign="top" bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td height="312" valign="top">
<p class="headingblue"> <strong><font size="2">==组合查询==</font></strong></p>
<form name="searchform" method="post" action="search_deal.jsp">
<table width="538" border="0" align="center" cellpadding="2" cellspacing="2">
<tr>
<td width="146" valign="middle" bgcolor="#CCCCCC">
<div align="right"><font size="2">商品类别:</font></div></td>
<td width="378" bgcolor="E0E0E0">
<%ResultSet rs=conndb.executeQuery("select * from categorydata");
if(!(rs.next())){out.println("暂无图书类别");%>
<%}else{%>
<select name="category">
<option value="请选择">请选择</option>
<%String category="";
String categoryname="";
rs.previous();
while(rs.next()){
categoryname=chstr.chStr(rs.getString(2));
%><option value="<%=categoryname%>"<%
try{category=chstr.chStr(request.getParameter("category"));}
catch(Exception e){category=categoryname;}
if(category==categoryname){out.println("select");}%>
><%=categoryname%></option>
<%}%>
</select>
<%}%> </td>
</tr>
<tr>
<td width="146" valign="middle" bgcolor="#CCCCCC">
<div align="right"><font size="2">按书名:</font></div></td>
<td width="378" bgcolor="E0E0E0"><input type="text" name="bookname"> </td>
</tr>
<tr>
<td width="146" valign="middle" bgcolor="#CCCCCC">
<div align="right"><font size="2">按出版社:</font></div></td>
<td width="378" bgcolor="E0E0E0"><input type="text" name="publisher"> </td>
</tr>
<tr>
<td width="146" valign="middle" bgcolor="#CCCCCC">
<div align="right"><font size="2">按作者:</font></div></td>
<td width="378" bgcolor="E0E0E0"><input type="text" name="author"> </td>
</tr>
<tr>
<td width="146" valign="top"> </td>
<td width="378" valign="top"> <input name="search" type="button" id="submit2" value="查询" onClick="nullOrNo()"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</td>
</tr>
</table></td>
</tr>
</table>
<div align="center"></div>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="1%" height="19" valign="top" background="../../web/images/link_bar_hold.jpg"><img src="../../web/images/link_bar_hold.jpg" width="9" height="23"></td>
<td width="99%" background="../../web/images/link_bar_hold.jpg"><div align="center">:
<a href="#">License Agreemen</a>t : <a href="#">Jobs</a> : <a href="#">Site
Map</a> :</div></td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000">
<tr>
<td height="34" bgcolor="#000000"><div align="center">
<p class="smWhite">2003 Copyright Information or webmaster information</p>
</div></td>
</tr>
</table>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -