📄 findbyname.jsp
字号:
<%@page contentType="text/html"%>
<%@page pageEncoding="GB2312"%>
<%@ page language="java"import="java.sql.*" %>
<jsp:useBean class="czm.BookBean" id="book" scope="page"></jsp:useBean>
<HTML>
<HEAD>
<META http-equiv="Content-Style-Type" content="text/css">
<TITLE>
数据库 On Line -member:<%= session.getValue("memberID") %>
</TITLE>
<SCRIPT language="javaScript">
<!--
function openwin(str)
{ window.open("addcart.jsp?ISBN="+str,
"shoppingcart","width=300,height=200,resizable=1,scrollbars=2");
return;
}
//-->
</SCRIPT>
</HEAD>
<BODY BGCOLOR="#FFFFFF">
<form name="bookList" onSubmit="return check()">
<%
request.setCharacterEncoding("gb2312");
if (session.getValue("memberID") == null||"".equals(session.getValue("memberID"))){
%>
<H2 align="center">请先登录,然后再选书</H2>
<H2 align="center"><A href="default.html">登录</A></H2>
<%
}
else{
%>
<H1 align="center"><font size="+7" face="宋体">网上书店</font></H1>
<a href="booklist.jsp">返回图书列表</a>
<h4 align="left">查找结果如下:</h4>
<hr>
<table width="100%" border="1" cellspacing="0" bordercolor="#9999FF">
<tr bgcolor="#CCCCCC">
<td><font color="#3333FF">ISBN</font></td>
<td><font color="#3333FF">书名</font></td>
<td><font color="#3333FF">作者</font></td>
<td><font color="#3333FF">出版社</font></td>
<td><font color="#3333FF">定价</font></td>
<td> </td>
</tr>
<%
String bookname=request.getParameter("chaxun");
ResultSet rs1=null;
if(request.getParameter("mhjq").equals("jingque")){
rs1= book.getABookInfbyName(bookname);
}
else if(request.getParameter("mhjq").equals("mohu")){
rs1=book.getMohu(bookname);
}
while(rs1.next()){
String ISBN = rs1.getString(1);
%>
<tr>
<td><%=ISBN%></td>
<td><a href="bookinfo.jsp?ISBN=<%=ISBN%>"><%= rs1.getString(2)%></A></td>
<td><%= rs1.getString(3)%></td>
<td><%= rs1.getString(4)%></td>
<td><%= rs1.getString(5)%></td>
<td><a href="javascript:openwin('<%=ISBN%>')">加入购物车</a></td>
</tr>
<%
}
%>
</table>
<hr>
<table align="center" border="0">
<tbody>
<tr>
<td><a href="shoppingcart.jsp"><font color="#0000FF">查看购物车</font></a></td>
<td></td>
</tr>
</tbody>
</table>
<p> </p>
<%
rs1.close();
}
%>
</form>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -