📄 printlist.jsp
字号:
<%@ page contentType="application/msword" %>
<%@ page language="java" pageEncoding="GB2312"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="DBprint" scope="page" class="ConnBean.conn"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'printlist.jsp' starting page</title>
<STYLE type="text/css">
TH {
FONT-SIZE: 9pt; FONT-FAMILY: 宋体
}
TD {
FONT-SIZE: 9pt; FONT-FAMILY: 宋体
}
P {
FONT-SIZE: 9pt; FONT-FAMILY: 宋体
}
INPUT {
FONT-SIZE: 9pt; FONT-FAMILY: 宋体
}
BODY {
FONT-SIZE: 9pt; FONT-FAMILY: 宋体
}
TEXTAREA {
FONT-SIZE: 9pt; FONT-FAMILY: 宋体
}
SELECT {
FONT-SIZE: 9pt; FONT-FAMILY: 宋体
}
LI {
FONT-SIZE: 9pt; FONT-FAMILY: 宋体
}
TD {
LINE-HEIGHT: 150%
}
.pagectrloff {
DISPLAY: none; WIDTH: 100%; TEXT-ALIGN: center
}
.pagectrlon {
WIDTH: 100%; TEXT-ALIGN: center
}
.title {
FONT-WEIGHT: bold; FONT-SIZE: 16pt
}
TABLE.tableprint {
BORDER-RIGHT: #000000 0px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 0px solid
}
TABLE.tableprint TD {
BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 0px solid; BORDER-LEFT: #000000 0px solid; BORDER-BOTTOM: #000000 1px solid
}
.PAGEPRINT {
PAGE-BREAK-AFTER: always
}
</STYLE>
</head>
<body bgcolor="#FFFFE1">
<%
try{
String id1=request.getParameter("ID");
ResultSet rs3=null;
String strsql3="select * from userorderlist as a,orderlist as b where (a.OrderlistNo='"+id1+"') and a.OrderlistNo=b.OrderlistNo";
//out.print(strsql3);
rs3=DBprint.executeQuery(strsql3);
rs3.next();
%>
<P class="title" align="center"><%=rs3.getString("OrderlistNo") %></P>
<TABLE class=tableprint cellSpacing=0 cellPadding=5 width="100%" border=0>
<TBODY>
<TR>
<TD>下单日期：</TD>
<TD><%=rs3.getString("SubmitTime") %></TD>
<TD>订 货 人（用户名）：</TD>
<TD><%=rs3.getString("UserName") %></TD>
</TR>
<TR>
<TD>收 货 人（用户实名）：</TD>
<TD><%=rs3.getString("RealName") %></TD>
<TD>收货电话（用户电话）：</TD>
<TD><%=rs3.getString("Tel") %></TD>
</TR>
<TR>
<TD>详细地址：</TD>
<TD colSpan=3><%=rs3.getString("UserAddress") %></TD>
</TR>
<TR>
<TD width="15%">配送方式：</TD>
<TD width="35%">普通邮寄 </TD>
<TD width="15%">配送费用：</TD>
<TD align="right" width="35%">0.00 元</TD>
</TR>
<TR>
<TD width="15%">支付方式：</TD>
<TD width="35%">Westpay西部支付 </TD>
<TD width="15%">支付费用：</TD>
<TD align="right" width="35%">0.00 元</TD>
</TR>
<TR>
<TD>总计金额：</TD>
<TD align="right" colSpan="3">应付人民币：<%=rs3.getString("TotalPrice") %>元整</TD>
</TR>
</TBODY>
</TABLE>
<P class="title" align="center">订单详细信息</P>
<TABLE class="tableprint" cellSpacing=0 cellPadding=5 width="100%" border=0>
<TBODY>
<TR align="center">
<TD><B>商品编码</B></TD>
<TD><B>商品名称</B></TD>
<TD><B>商品价格（元）</B></TD>
<TD><B>数量</B></TD>
<TD><B>计量单位</B></TD>
</TR>
<TR align="center">
<TD><%=rs3.getString("BookNo") %></TD>
<TD><%=rs3.getString("BookName") %></TD>
<TD align="right"><%=rs3.getString("Price") %></TD>
<TD align="right"><%=rs3.getString("Number") %></TD>
<TD>本 </TD>
</TR>
</TBODY>
</TABLE>
<% }catch(Exception e){out.print(e);} %>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -