orderitem.jsp

来自「一个网上购书系统」· JSP 代码 · 共 51 行

JSP

51 行

<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="incoming/common.jsp"%>
<%@ include file="incoming/check.jsp"%>
<html>
<head>
<title>网上书店</title>
<link href="incoming/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<%@ include file="incoming/header.jsp"%> 
<br><a class="title">订单详细信息</a><br>
<%
	String orderid = new String(request.getParameter("orderid").trim().getBytes("ISO-8859-1"));
	String userid = (String)session.getValue("userid");
	
	DBSQLManager dbsm = new DBSQLManager();
	String sql="SELECT a.ISBN, a.BOOK_NUM, b.TITLE, b.AUTHOR, b.PUBLISHER, b.PRICE FROM orderitem AS a, bookinfo AS b WHERE a.ISBN=b.ISBN AND a.ORDER_ID='"+orderid+"'";
	dbsm.setSqlStr(sql);
	dbsm.executeQuery();
	ResultSet rs=dbsm.getRs();
%>

<table width="700" border="1" cellpadding="0" cellspacing="0">
  <tr>
    <td width="88" height="30"><div align="center">ISBN</div></td>
    <td width="259"><div align="center">书名</div></td>
    <td width="135"><div align="center">作者</div></td>
    <td width="125"><div align="center">出版社</div></td>
    <td width="39"><div align="center">单价</div></td>
    <td width="40"><div align="center">数量</div></td>
  </tr>
<%     while(rs.next()) 
		{
%>

  <tr>
    <td><div align="center"><%=rs.getString("ISBN")%></div></td>
    <td><div align="center"><%=rs.getString("TITLE")%></div></td>
    <td><div align="center"><%=rs.getString("AUTHOR")%></div></td>
    <td><div align="center"><%=rs.getString("PUBLISHER")%></div></td>
    <td><div align="center"><%=rs.getString("PRICE")%></div></td>
    <td><div align="center"><%=rs.getString("BOOK_NUM")%></div></td>
  </tr>
 <%}
 	dbsm.close();
 %> 
</table>
<%@ include file="incoming/footer.jsp"%>  
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C

搜索代码Ctrl + F

全屏模式F11

增大字号Ctrl + =

减小字号Ctrl + -

显示快捷键?

orderitem.jsp

orderitem.jsp - 源码说明

⌨️ 快捷键说明