📄 mrok.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.lang.*,java.util.*,java.sql.*" %>
<html>
<title>小小的太阳</title>
<body>
<body style="color: #0000000">
<div align="center">
<table border="3" borderColor="#ffffff" borderColorDark="#ffffff" borderColorLight="#ffffff" cellSpacing="0" height="1008" style="BORDER-BOTTOM-COLOR: #ffffff; BORDER-BOTTOM-STYLE: solid; BORDER-LEFT-COLOR: #ffffff; BORDER-LEFT-STYLE: solid; BORDER-RIGHT-COLOR: #ffffff; BORDER-RIGHT-STYLE: solid; BORDER-TOP-COLOR: #ffffff; BORDER-TOP-STYLE: solid" width="892">
<tbody>
<tr>
<td align="middle" bgColor="#ccccff" height="1" width="80%">
<%@ include file="head.html" %>
</td>
</tr>
<tr>
<td align="center" bgcolor="#fccccc" height="1" width="80%" colspan="2">
<jsp:include page="head.jsp" />
</jsp:include>
</td>
</tr>
<tr>
<td align="middle" bgColor="#ccffff" height="557" width="884">
<table border="1" width="90%" height="1" bordercolorlight="#f308080" style="border-style: solid" bordercolordark="#f308080" bordercolor="#f308080" cellspacing="1" cellpadding="0" >
<tr>
<td align="left" height="1" width="10%"><b><font color="#FFCC00">书名代号</font></b></td>
<td align="left" height="1" width="20%"><b><font color="#FFCC00">书 名</font></b></td>
<td align="left" height="1" width="12%"><b><font color="#FFCC00">作 者</font></b></td>
<td align="left" height="1" width="20%"><b><font color="#FFCC00">出版社</font></b></td>
<td align="left" height="1" width="12%"><b><font color="#FFCC00">出版时间</font></b></td>
<td align="left" height="1" width="7%"><b><font color="#FFCC00">价 格(元)</font></b></td>
<td align="left" height="1" width="7%"><b><font color="#FFCC00">数 量</font></b></td>
<td align="left" height="1" width="12%"><b><font color="#FFCC00">买入一册</font></b></td>
</tr>
<jsp:useBean id="DbLink" scope="page" class="MyBook.DbLink" />
<%
String YHM = request.getParameter("YHM");
String GLCS = request.getParameter("GLCS");
%>
<form method="post" action="TJFK.jsp?YHM=<%= YHM %>&GLCS=<%= GLCS %>">
<%
DbLink.DbLink("sa","123456","MyDataBase");
ResultSet RST = DbLink.DbQuery("select ZBDH from Book");
int i=0;
while(RST.next())
{
String ZBDH = RST.getString("ZBDH");
String SRSL = request.getParameter(ZBDH);
if (SRSL.equals(""))
{
SRSL ="0";
}
if (! SRSL.equals("0"))
{
out.println("<input type=\"hidden\" name="+ZBDH+" value="+SRSL+">");
ResultSet rs = DbLink.DbQuery("select SM,ZBDH,ZZ,JG,SL,CBS,CBSJ from Book where ZBDH='"+ZBDH+"'");
while(rs.next())
{
String SM =rs.getString("SM");
String ZZ =rs.getString("ZZ");
float JG = rs.getFloat("JG");
int SL = rs.getInt("SL");
String CBS =rs.getString("CBS");
String CBSJ = rs.getString("CBSJ").substring(0,10);
int MRSL = Integer.parseInt(SRSL);
if (SL < MRSL)
{
response.sendRedirect("BWSD.jsp?YHM="+YHM+"&GLCS="+GLCS+"&Param=ReBack");
}
i++;
out.println("<tr><font color=#000000 size=3><td align=\"left\" height=\"1\" width=\"10%\">"
+ ZBDH
+"</td><td align=\"left\" height=\"1\" width=\"20%\">"
+ SM
+"</td><td align=\"left\" height=\"1\" width=\"12%\">"
+ZZ
+"</td><td align=\"left\" height=\"1\" width=\"20%\">"
+CBS
+"</td><td align=\"left\" height=\"1\" width=\"12%\">"
+CBSJ+
"</td><td align=\"left\" height=\"1\" width=\"7%\">"
+ JG
+"</td><td align=\"left\" height=\"1\" width=\"7%\">"
+ SL
+"</td><td align=\"left\" height=\"1\" width=\"12%\">"
+ SRSL
+"</td></font></tr>");
}
rs.close();
}
}
RST.close();
if (i == 0)
{
response.sendRedirect("BWSD.jsp?YHM="+YHM+"&GLCS="+GLCS+"&Param=Empty");
}
%>
<tr>
<td height="1" colspan="8" align="center">
<a href="BWSD.jsp?YHM=<%= YHM %> &GLCS=<%= GLCS %>">重新购买 </a>
</td>
</tr>
<tr>
<td height="1" colspan="8" align="center">
<input type="Submit" value="提交付款">
</td>
</tr>
</form>
</table>
</td>
</tr>
<tr>
<td align="middle" bgColor="#ccccff" height="1" width="80%">
<%@ include file = "botton.html" %>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -