book.jsp
来自「jsp的技术教程」· JSP 代码 · 共 158 行
JSP
158 行
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="workM" scope="page" class="test.faq" />
<%@ include file="function.inc.jsp"%>
<%!
public String getStr(String str)
{
try
{
String temp_p=str;
byte[] temp_t=temp_p.getBytes("GBK");
String temp=new String(temp_t,"ISO8859_1");
return temp;
}
catch(Exception e)
{
}
return "null";
}
%>
<html>
<head>
<title>[详细资料]</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF">
<table width="100%" border="1" cellspacing="0">
<tr bgcolor="#CCCCFF">
<td width="21%" colspan=2>
<div align="center"><b>详细资料</b></div>
</td>
</tr>
<%!
String name,author,content,publish_name,publish_address;
int language,commend,price,book_number,category;
String on_sale_time;
boolean good_price,cdrom;
%>
<%
String id;
id=request.getParameter("id");
String strSQL="SELECT * FROM book where id="+id;
ResultSet RSa = workM.executeQuery(strSQL);
//out.println(strSQL);
while (RSa.next()) {
name=getStr(RSa.getString("name"));
author=getStr(RSa.getString("author"));
language=(RSa.getInt("language"));
content=getStr(RSa.getString("content"));
category=(RSa.getInt("category"));
commend=(RSa.getInt("commend"));
publish_name=getStr(RSa.getString("publish_name"));
publish_address=getStr(RSa.getString("publish_address"));
cdrom=(RSa.getBoolean("cdrom"));
price=(RSa.getInt("price"));
on_sale_time=getStr(RSa.getString("on_sale_time"));
good_price=(RSa.getBoolean("good_price"));
book_number=(RSa.getInt("book_number"));
}
RSa.close();
%>
<tr>
<td bgcolor="#FFCCCC" width="21%">
<div align="right">书名:</div>
</td>
<td bgcolor="#33FFCC" width="79%"><%=name%></td>
</tr>
<tr>
<td bgcolor="#FFCCCC" width="21%">
<div align="right">作者:</div>
</td>
<td bgcolor="#33FFCC" width="79%"><%=author%></td>
</tr>
<tr>
<td bgcolor="#FFCCCC" width="21%">
<div align="right">语言:</div>
</td>
<td bgcolor="#33FFCC" width="79%"><%=lang(language)%></td>
</tr>
<tr>
<td bgcolor="#FFCCCC" width="30%">
<div align="right">内容简介:</div>
</td>
<td bgcolor="#33FFCC" width="79%"><%=content%></td>
</tr>
<tr>
<td bgcolor="#FFCCCC" width="21%">
<div align="right">所属的类别:</div>
</td>
<td bgcolor="#33FFCC" width="79%"><%=category(category)%></td>
</tr>
<tr>
<td bgcolor="#FFCCCC" width="21%">
<div align="right">推荐程度:</div>
</td>
<td bgcolor="#33FFCC" width="79%"><%=commend(commend)%></td>
</tr>
<tr>
<td bgcolor="#FFCCCC" width="21%">
<div align="right">出版社名称:</div>
</td>
<td bgcolor="#33FFCC" width="79%"><%=publish_name%></td>
</tr>
<tr>
<td bgcolor="#FFCCCC" width="21%">
<div align="right">出版社地址:</div>
</td>
<td bgcolor="#33FFCC" width="79%"><%=publish_address%></td>
</tr>
<tr>
<td bgcolor="#FFCCCC" width="21%">
<div align="right">是否配有光盘:</div>
</td>
<td bgcolor="#33FFCC" width="79%"><%=cd(cdrom)%></td>
</tr>
<tr>
<td bgcolor="#FFCCCC" width="21%">
<div align="right">价格:</div>
</td>
<td bgcolor="#33FFCC" width="79%"><%=price%></td>
</tr>
<tr>
<td bgcolor="#FFCCCC" width="21%">
<div align="right">上架时间:</div>
</td>
<td bgcolor="#33FFCC" width="79%"><%=YMD(on_sale_time)%></td>
</tr>
<tr>
<td bgcolor="#FFCCCC" width="21%">
<div align="right">是否是特价书:</div>
</td>
<td bgcolor="#33FFCC" width="79%"><%=price(good_price)%></td>
</tr>
<tr>
<td bgcolor="#FFCCCC" width="21%">
<div align="right">库存量:</div>
</td>
<td bgcolor="#33FFCC" width="79%"><%=book_number%>本</td>
</tr>
<tr bgcolor="#CCCCFF">
<td colspan=2> </td>
</tr>
<tr bgcolor="#CCCCFF">
<td colspan=2 align="center"><a href="shopcart.jsp?book_id=<%=id%>">放入购物车</a> | <a href="javascript:close();">关闭窗口</a></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?