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>&nbsp;</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 + -
显示快捷键?