📄 goods_sendno.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java"%>
<%@ page import="java.sql.*"%>
<jsp:useBean scope="page" id="form" class="mypkg.form" />
<%
//获取当前访问用户的用户名
String s_UserName = (String) session.getAttribute("UserName");
if(s_UserName == null)
{
s_UserName = "";
}
ResultSet rs = form.showsendno();%>
<!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 rel=stylesheet type=text/css href="../lib/book.css">
</head>
<body bgcolor="#F4FFFE">
<form name="form1" method="post" action="user_form.jsp">
<label>
<br>
<br>
<div align="center">
<table width="774" height="227" cellspacing="0" cellpadding="0"
border="1">
<tr bgcolor="#0066ff">
<td height="40" align="center" colspan="8">
<font color="#ff0000"> 等待发货的订单</font>
</td>
</tr>
<tr>
<td width="13%" align="center">
订单号
</td>
<td width="13%" align="center">
购买者
</td>
<td width="21%" height="25" align="center">
<font color="#0000ff">图书名称</font>
</td>
<td width="12%" height="25" align="center">
<font color="#0000ff">图书作者</font>
</td>
<td width="13%" height="25" align="center">
<font color="#0000ff">出版社</font>
</td>
<td width="8%" align="center">
<font color="#0000ff">价格</font>
</td>
<td width="10%" height="25" align="center">
<font color="#0000ff">购买数量</font>
</td>
<td width="10%" height="25" align="center">
<font color="#0000ff">发货</font>
</td>
</tr>
<%
//循环显示所有购物信息
while (rs.next()) {
int i_BuyNumber = rs.getInt("BuyNumber");
String name = rs.getString("BookName");
String username = rs.getString("UserName");
String author = rs.getString("Author");
String pub = rs.getString("Pub");
int userid = rs.getInt("UserID");
int bookid = rs.getInt("BookID");
float price = rs.getFloat("Price");
long danhao = rs.getLong("FormID");
%>
<tr>
<td width="13%" align="left"><%=danhao%>
</td>
<td width="13%" align="left">
<a href="user_detail.jsp?UserID=<%=userid%>" target="_self"><%=username%></a>
<input type="hidden" name="username" value="<%=username%>">
</td>
<td width="21%" height="25" align="left">
<font color="#0000ff"></font><a
href="book_detail.jsp?BookID=<%=bookid%>" target="_self"><%=name%></a>
<input type="hidden" name="name" value="<%=name%>">
</td>
<td width="12%" height="25" align="left">
<%=author%></td>
<td width="13%" height="25" align="left">
<%=pub%></td>
<td width="8%" align="left"><%=price%></td>
<td width="10%" height="25" align="center"><%=i_BuyNumber%></td>
<td width="10%" height="25" align="center">
<a href="send.jsp?BookID=<%=bookid%>&UserID=<%=userid%>"
target="_self">发货</a>
<br>
</td>
</tr>
<%
}
%>
</table>
<p>
<%
rs.close();
%>
</p>
</div>
</label>
<br>
<div align="center">
<label>
</label>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -