jsp模拟购物车

来源:互联网 发布:win8动态桌面软件 编辑:程序博客网 时间:2024/05/01 08:39
<%@ page contentType="text/html;charset=UTF-8" language="java"
import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE HTML >
<html>
<head>
<title>在线购物</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="在线购物,购物车,商品一览">
<meta http-equiv="description" content="jsp开发购物车">
</head>
<body>
<%
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection(
"jdbc:mysql://127.0.0.1:3306/mydatabase", "root", "123456");
String sql = "select * from shop";
PreparedStatement pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
%>
<h2>在线购物</h2>
<hr />
<table border="1" width="600">
<tr>
<tr bgcolor="#dddddd">
<td align="center" width="80">商品缩图</td>
<td align="center" colspan="4">商品摘要></td>
<td align="center" width="100">在线购买</td>
</tr>
<%
String  num,name, price, info;
String s,str;
int i=101;
while (rs.next()) 
{
num = rs.getString("SP_NO").trim();
name = rs.getString("SP_NAME").trim();
price = rs.getString("SP_PRICE").trim();
info = rs.getString("SP_INFO").trim();
s=i+"";
str=s.substring(1);
%>
<tr>
<%
out.println("<td>图片:<img src=../image/"+str+".jpg width='80' height='90'>"+"</td>");
%>
<td>商品编号:<%=num%></td>
<td>商品名称:<%=name%></td>
<td>商品价格:<%=price%></td>
<td>商品简介:<%=info%></td>
<td><a href="buy.jsp?op='add'&num=number">放入购物车</a></td>
</tr>
<%
}
%>
</table>
<br />
<a href="cart.jsp">查看购物车</a>&nbsp;&nbsp;
<a href="buy.jsp?op=clear">清空购物车</a>
</body>
</html>
0 0
原创粉丝点击