?? showdet.jsp
字號:
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<%@ page import="Model.DataOperation" %>
<%--
The taglib directive below imports the JSTL library. If you uncomment it,
you must also add the JSTL library to the project. The Add Library... action
on Libraries node in Projects view can be used to add the JSTL 1.1 library.
--%>
<%--
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<p align="left">--%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>E-Book Store</title>
</head>
<body>
<jsp:useBean id="DataOperation" class="Model.DataOperation" scope="page"/>
<%
String ISBN=request.getParameter("ISBN");
Connection con=DataOperation.getConnection();
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from Book,publisher,writes,author,category where book.ISBN='"+ISBN+"' and Book.publisherid=publisher.publisherid" +
" and book.isbn=writes.isbn and writes.authorid=author.authorid and category.categoryid=book.categoryid");
while(rs.next()) {
%>
</p>
<p align="right">
<table width="100%" style="text-align: right" height="289">
<tr>
<td width="36%" bgcolor="#DDDDDD">
<p align="left">
<img src="<%=rs.getString("image")%>" width="186" height="276">
</td>
<td width="63%" bgcolor="#DDDDDD">
<table width="101%" border="0" height="285">
<tr>
<td width="46%" bgcolor="#DDDDDD" height="49">
作者
</td>
<td width="52%" bgcolor="#FFFFFF" align="left" height="49">
<p align="left">
<%
out.println(rs.getString("AuthorName"));
%>
</td>
</tr>
<tr>
<td bgcolor="#DDDDDD" height="36">
<p align="left">
出版社 <td bgcolor="#FFFFFF" align="left" height="36">
<p align="left">
<%
out.println(rs.getString("PublisherName"));
%>
</td>
</tr>
<tr>
<td bgcolor="#DDDDDD" height="27">
<p align="left">出版時間</td>
<td bgcolor="#FFFFFF" align="left" height="27">
<p align="left"> <%
out.println(rs.getString("PublicationDate"));
%> </td>
</tr>
<tr>
<td bgcolor="#DDDDDD" height="28">
<p align="left">版次</td>
<td bgcolor="#FFFFFF" align="left" height="28">
<p align="left">
<%
out.println(rs.getString("Editon"));
%>
</td>
</tr>
<tr>
<td bgcolor="#DDDDDD">
<p align="left">ISBN</td>
<td bgcolor="#FFFFFF" align="left">
<p align="left">
<%
out.println(rs.getString("ISBN"));
%>
</td>
</tr>
<tr>
<td bgcolor="#DDDDDD">
<p align="left">定價</td>
<td bgcolor="#FFFFFF" align="left">
<%
out.println(rs.getString("price"));
%>
</td>
</tr>
<tr>
<td bgcolor="#DDDDDD">
<p align="left">內容簡介</td>
<td bgcolor="#FFFFFF" align="left">
<%
out.println(rs.getString("BookDescription"));
%>
</td>
</tr>
</table></td>
</tr>
</table>
<%}%>
</p>
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -