📄 shop.jsp

📁 网上服装店能让用户在该网站上对物品进行上传购买等操作。该设计为原版

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<%@ page import="com.bwm.db.Condb"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>订单显示页</title>
</head>
<link href="../css/style.css" rel="stylesheet">
<body>
<script language="javascript">
<!--
	function check(){
		form1.submit();
	}
-->
</script>
<br>
<table width="650" height="86" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#42CF39" bgcolor="#E8FFFF" class="tableBorder">
<form action="execu.jsp" name="form1" method="post">
  <tr align="center" bgcolor="#42CF39" >
    <td height="30" colspan="6" class="head">商品订购详单</td>
  </tr>
  <tr align="center">
    <td width="115" height="26">订单号</td>
    <td width="158" height="26">商品名称</td>
    <td width="70" height="26">商品价格</td>
    <td width="62" height="26">数量</td>
    <td width="95">总金额</td>
    <td width="95" height="26">是否执行</td>
  </tr>
 <%
	Condb con=new Condb();
	String sub=request.getParameter("sub");
	//String sq="select * from tb_Sub where Sub='"+sub+"'";
	String sql="select * from tb_Shop where Subid='"+sub+"'";
	ResultSet rs=con.executeQuery(sql);
	while(rs.next()){
%>
  <tr align="center">
    <td height="22"><%=rs.getString(1)%></td>
    <td height="22"><%=rs.getString(2)%></td>
    <td height="22"><%=rs.getInt(3)%></td>
    <td height="22"><%=rs.getInt(4)%></td>
    <td><%=rs.getInt(5)%></td>
    <td height="22"><input name="execu" type="checkbox" onClick="check()">
      是/否<input type="hidden" name="number" value="<%=sub%>"></td>
  </tr>
  </form>
  <%
  }con.close();
  %>
</table>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -