000a17b6a392001c106cba6f486f209c

来自「一个超市管理系统,提供一些基本简单的操作,JSP+APACHE+ORCALE实现」· 代码 · 共 53 行

TXT
53
字号
<%@ page language="java" contentType="text/html; charset=gb2312"
    pageEncoding="gb2312"%>
<%@ page import="java.sql.*" %><!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></head><body>
<jsp:useBean id="dbcon" scope="session" class="bb.Dbcon" />
<jsp:useBean id="pro_array" scope="session" class="bb.pro_array" />
<table border=0 bordercolor="#FF0000"  align="center">
<%
  int l=pro_array.getI();
  ResultSet rs=null;
  float pay=0f;
  
  Connection con=dbcon.getConn();
  String a=null;
  for(int n=1;n<l;n++)
  { 
	String pro_id=pro_array.products[n];
	String sql="select * from tpb.product where pro_id='"+pro_id+"'";
    Statement stmt=con.createStatement();
    rs=stmt.executeQuery(sql);
    rs.next();
%>
   <tr>
     <td><%=rs.getString("pro_name") %></td>
      <td><%=rs.getString("price") %></td>
   </tr>
<% 
  pay+=rs.getFloat("price");
  }
%>
   <tr>
     <td>总额</td>
      <td><%=pay %></td>
   </tr>
<%rs.close();
  stmt.close();
  dbcon.Close();
%>
<%
  pro_array.resetPro_array();
  pro_array.resetI();
%>
<a href="test.jsp">返回</a>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?