📄 research.jsp
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- **************************************************************
**项目名称：网上书店管理端 ************************
**内容：图书查询结果 ************************
**此页作者：luic ************************
**完成日期：2004/4/26 ************************
**修改： 调试通过 ************************
**说明：本页实现通过关键字查询图书， ************************
** 然后显示查询结果 ************************
** ************************
**************************************************************
-->
<%@ page contentType="text/html; charset=GBK"%>
<%@ page import="java.sql.*" %>
<%
String searchkey=request.getParameter("searchkey"); //查询关键字
String condition=request.getParameter("action"); //查询关键字的值
String strCondition=new String();
if(condition.equals("1"))
strCondition="书名";
else if(condition.equals("2"))
strCondition="图书编号";
String sql="SELECT * FROM book WHERE ";
if(strCondition.equals("书名"))
sql=sql+"bookName='";
else if(strCondition.equals("图书编号"))
sql=sql+"bookID='";
sql=sql+searchkey;
sql=sql+"'";
//out.println(sql);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:bookStore");
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery(sql);
%>
<HTML><HEAD><TITLE>网上商店</TITLE>
<STYLE>HTML {
TEXT-DECORATION: none
}
A:link {
COLOR: #000000; TEXT-DECORATION: underline
}
A:active {
COLOR: #000000; TEXT-DECORATION: underline
}
A:visited {
COLOR: #000000; TEXT-DECORATION: underline
}
A:hover {
COLOR: rgb(0,147,43); TEXT-DECORATION: underline
}
EM {
FONT-SIZE: 16pt; FONT-STYLE: normal; FONT-FAMILY: CourierNew
}
A {
FONT-SIZE: 9pt
}
TD {
FONT-SIZE: 9pt
}
P {
FONT-SIZE: 9pt
}
.hh INPUT {
BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; BORDER-BOTTOM: 1px solid; BACKGROUND-COLOR: #ffffff
}
</STYLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD>
<BODY text=#000000 vLink=#000000 aLink=#000000 link=#000000 bgColor=#ffffff
leftMargin=0 topMargin=0 MARGINHEIGHT="0" MARGINWIDTH="0">
<TABLE cellSpacing=0 cellPadding=0 width=776 align=center border=0>
<TBODY>
<TR>
<TD><IMG height=63 src="images/guide_0.gif" width=238></TD>
<TD><IMG height=63 src="images/guide_1.gif" width=538></TD></TR>
<TD><IMG height=35 src="images/guide_2.gif" width=238></TD>
<TD background=images/guide_3.gif height=35>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD colSpan=2 height=10><IMG height=13 src="images/space.gif"
width=10></TD></TR>
<TR>
<TD width="8%"> </TD>
<TD width="92%"><FONT color=#ffffff>■ 图书查询结果</FONT></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=776 align=center border=0 height="414">
<TBODY>
<TD vAlign=top width=195 bgColor=#ffffff height=48>
<TABLE height=48 cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<td width="99%" height="48" bgcolor="#99CC66">
<p align="left"> <font face="黑体" size="4">
功能列表 </font>
</td></TR></TBODY></TABLE></TD>
<TD vAlign=top width=581 bgColor=#ffffff height=414 rowspan="2" bordercolor="#8EEB32">
<TABLE cellSpacing=4 cellPadding=0 width="100%" border=0>
<TBODY>
<TR vAlign=top>
<TD height=389><TABLE cellSpacing=0 cellPadding=0 width="98%" align=center
border=0>
<TBODY>
<TR bgColor=#99cc66>
<TD width=52 height=24>
<DIV align=center>图书编号</DIV></TD>
<TD width=99 height=24>
<DIV align=center>图书名称</DIV></TD>
<TD width=46 height=24>
<DIV align=center>作者</DIV></TD>
<TD width=85 height=24>
<DIV align=center>出版社</DIV></TD>
<TD width=76 height=24>
<p align="center">图书类型</TD>
<TD width=44 height=24>
<DIV align=center>库存量</DIV></TD>
<TD width=64 height=24>
<DIV align=center>图书价格</DIV></TD>
<TD width=46 height=24>
<DIV align=center>修改</DIV></TD>
<TD width=46 height=24>
<DIV align=center>删除</DIV></TD></TR>
<%
while(rs.next()){
String bookID=rs.getString("bookID");
%>
<TR bgColor=#f3f3f3>
<TD width=52 height=20>
<DIV align=center><FONT color=#FF0000><%=bookID%> </FONT></DIV></TD>
<TD width=99 height=20>
<DIV align=center><%=rs.getString("bookName")%></DIV></TD>
<TD width=46 height=20>
<p align="center"><%=rs.getString("bookAuthor")%></TD>
<TD width=85 height=20>
<p align="center"><%=rs.getString("publisher")%></TD>
<TD width=76 height=20>
<p align="center"><%=rs.getString("bookSort")%></TD>
<TD class=hh width=44 height=20>
<p align="center"><%=rs.getString("stockNum")%></TD></FORM>
<TD class=bb width=64 height=20>
<DIV align=center><FONT color=#000000>￥<%=rs.getString("bookPrice")%> </FONT></DIV></TD>
<TD class=bb width=46 height=20>
<DIV align=center>
<INPUT onclick="window.open('maintainBook.jsp?id=<%=bookID%>','browseorder','width=776,height=500')" type=button value=修改 name=Button>
</DIV></TD>
<TD class=bb width=46 height=20>
<DIV align=center><INPUT onclick="window.open('delBook.jsp?id=<%=bookID%>','browseorder','width=776,height=500')" type=button value=删除 name=Button22>
</DIV></TD></TR>
<% }
rs.close();
stmt.close();
con.close();
%>
</TBODY></TABLE><BR>
<P align=center>
<P align=left><BR
clear=all><BR></P><FONT
color=#000000> </FONT></TD></TR></TBODY></TABLE> <tr>
<TD vAlign=top width=195 bgColor=#ffffff height=366>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#FFFFFF" width="100%" id="AutoNumber1" bgcolor="#bede9e" height="266">
<tr>
<td width="100%" height="19">
<p align="center">【 <a href="addBook.htm">添加图书</a>】
</td>
</tr>
<tr>
<td width="100%" height="19">
<p align="center">【<a target="mainBody" href="delBook.jsp">
</a><a href="dealBook.jsp">删除图书</a>】
</td>
</tr>
<tr>
<td width="100%" height="19">
<p align="center"> 【<a href="modifyRoomPre.jsp" target="mainBody">
</a><a href="dealBook.jsp">维护图书</a>】
</td>
</tr>
<tr>
<td width="100%" height="19">
【<a href="roomList.jsp" target="mainBody">
</a><a href="userView.jsp">用户管理</a>】
</td>
</tr>
<tr>
<td width="100%" height="19">
【<a href="userList.jsp" target="mainBody">
</a><a href="dealOrder.jsp">订单处理</a>】
</td>
</tr>
<tr>
<td width="100%" height="19"> 【<a target="mainBody" href="updatePwd.jsp">
密码更改</a>】
</td>
</tr>
<tr>
<td width="100%" height="19">
【<a target="mainBody" href="logout.jsp">
退出管理</a>】
</td>
</tr>
</table></TD>
</tr>
</TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=776 align=center border=0>
<TBODY>
<TR bgColor=#89c86a>
<TD><IMG height=1 src="images/space.gif" width=10></TD></TR>
<TR>
<TD height=1><IMG height=1 src="images/space.gif" width=10></TD></TR>
<TR bgColor=#89c86a>
<TD> </TD></TR></TBODY></TABLE>
<div align="center">
<table border="0" style="border-collapse: collapse" width="776" id="table1" cellpadding="0">
<tr>
<td>
<p align="center">
<br>
版权所有 ◎2003－2004 All rights resevered</td>
</tr>
</table>
</div>
</BODY></HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -