📄 orderlist.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,bean.DBClass" errorPage="" %>
<!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=gb2312">
<title>订单列表</title>
<link href="source/bookshop.css" rel="stylesheet" type="text/css">
</head>
<% if((session.getAttribute("userId")==null)&&(session.getAttribute("adminId")==null)) { %>
<jsp:forward page="/notLogin.jsp" />
<% } else { %>
<body>
<div align="center">
<p> </p>
<table width="713" border="0" >
<tr>
<td background="source/glbnav_background.gif" bgcolor="#FFFFFF" > </td>
</tr>
<tr>
<td height="11" bgcolor="#FFFFFF" >
<table width="100%" border="0">
<tr>
<td width="150"><div align="center">书名</div></td>
<td width="150"><div align="center">作者</div></td>
<td width="150"><div align="center">出版社</div></td>
<td width="82"><div align="center">单价</div></td>
<td width="63"><div align="center">数量</div></td>
<td width="86"><div align="center">共计</div></td>
</tr>
<tr>
<td colspan="6"><hr></td>
</tr>
<%
String id=request.getParameter("id");
String query="SELECT * FROM orderlist,book WHERE orderlist.id = "+ "\'"+ id+ "\' AND orderlist.book=book.id";
DBClass db=new DBClass();
db.connect();
ResultSet resultset=db.executeQuery(query);
while (resultset.next()){
String name=resultset.getString("name");
String author=resultset.getString("author");
String publisher=resultset.getString("publisher");
String price=resultset.getString("price");
String sum=resultset.getString("sum");
float money=Integer.parseInt(sum)*Float.parseFloat(price);
%>
<tr>
<td height="22"><div align="center"><%= name %></div></td>
<td><div align="center"><%= author %></div></td>
<td><div align="center"><%= publisher %></div></td>
<td><div align="center">¥<%= price %></div></td>
<td><div align="center"><%= sum %></div></td>
<td><div align="center">¥<%= money %></div></td></tr>
<%
}
db.closeConnection();
%>
</table>
</td>
</tr>
<tr>
<td height="5" background="source/glbnav_background.gif" bgcolor="#FFFFFF" > </td>
</tr>
</table>
</div>
</body>
<% } %>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -