购物车练习总结_import java.sql.*; public class productdao { publi-优快云博客

本文链接：https://blog.youkuaiyun.com/diao____si/article/details/130405130

购物车作业至此我也想不到如何继续拓展，后续的优化最多就是前端页面的优化尝试，感兴趣的同学可以尝试。在这里我把具体代码发一下，需要的同学可以参照一下：

这是总体结构：

bean：

package bean;

public class order {
	private int id;
	private user user;
	
	public order(user u){ this.user = u; }
	
	public int getid(){ return id; }
	public void setid(int id) { this.id = id; }
	
	public user getuser() { return user; }
	public void setuser(user u) { user = u; }
}

package bean;

public class orders {
	private int id;
    private int num;
    private Product product;
    //定义 product 属性
    private order order;
    
    public orders(Product p,int num)
    {
    	this.product = p;
    	this.num = num;
    }
    
    public int getid(){
    	return id;
    }
    
    public void setid(int id)
    {
    	this.id = id;
    }
    
    public int getnum() {
        return num;
    }
    
    public void setnum(int num) {
        this.num = num;
    }

    public Product getp() {
        return product;
    }

    public void setp(Product p) {
        this.product = p;
    }
    public Product getproduct()
    {
    	return product;
    }
    public void setorder(order o) { order = o; }
    public order getorder() { return order; }
}

package bean;

public class ordershow {
	
	public String productname;
	public int num;
	public int oid;
	
	public ordershow(String productname ,int num ,int oid)
	{
		this.productname = productname;
		this.num = num;
		this.oid = oid;
	}
	
	public void setname(String name){ this.productname = name; }
	public String getproductname(){ return this.productname; }
	public int getnum() { return num; }
	public int getoid() { return oid; }
}

package bean;

public class Product {
	public int id;
	public String name;
	public double price;
	
	public Product(int id ,String name ,double price)
	{
		this.id = id;
		this.name = name;
		this.price = price;
	}
	
	public int getid(){ return this.id; }
	public void setid(int id){ this.id = id; }
	
	public void setname(String name){ this.name = name; }
	public String getname(){ return this.name; }
	
	public void setprice(double price){ this.price = price; }
	public double getprice(){ return this.price; }
}

package bean;

public class user {
	private int id;
	private String name;
	private String password;
	
	public user(){};
	public user(int id ,String name ,String password)
	{
		this.id = id;
		this.name = name;
		this.password = password;
	}
	
	public int getid() { return this.id; }
	public void setid(int id) { this.id = id; }
	
	public String getname(){ return this.name; }
	public void setname(String name) { this.name = name; }
	
	public String getpassword() { return this.password; }
	public void setpassword(String password) { this.password = password; }
	
}

dao类：

package dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import bean.order;

public class order_delete {
	public void deleteall(int uid) {
		 
	    try {
	        Class.forName("com.mysql.jdbc.Driver");

	        Connection c = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/cart?characterEncoding=UTF-8",
	                "root", "123456");

	        String sql = "delete from order_ where uid = ?";

	        PreparedStatement ps = c.prepareStatement(sql);

	        ps.setInt(1, uid);

	        ps.execute();

	        ps.close();

	        c.close();

	    } catch (ClassNotFoundException e) {
	        e.printStackTrace();
	    } catch (SQLException e) {
	        e.printStackTrace();
	    }
	}
}

package dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import bean.order;

public class orderdao {

public void insert(order o) {
	 
    try {
        Class.forName("com.mysql.jdbc.Driver");

        Connection c = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/cart?characterEncoding=UTF-8",
                "root", "123456");

        String sql = "insert into order_ values(null,?)";

        PreparedStatement ps = c.prepareStatement(sql);

        ps.setInt(1, o.getuser().getid());

        ps.execute();

        ResultSet rs = ps.getGeneratedKeys();
        if (rs.next()) {
            int id = rs.getInt(1);
            o.setid(id);
        }

        ps.close();

        c.close();

    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}
}

package dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import bean.orders;

public class ordersdao {
	public void insert(orders oi) {
		 
        try {
            Class.forName("com.mysql.jdbc.Driver");
 
            Connection c = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/cart?characterEncoding=UTF-8",
                    "root", "123456");
 
            String sql = "insert into orderitem values(null,?,?,?)";
 
            PreparedStatement ps = c.prepareStatement(sql);
 
            ps.setInt(1,oi.getp().getid());
            ps.setInt(2,oi.getnum());
            ps.setInt(3,oi.getorder().getid());
             
            ps.execute();
 
            ps.close();
            c.close();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
         
    }
}

package dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import bean.ordershow;


public class ordersshowdao {
	public List<ordershow> show(int uid) {
		 List<ordershow> show = new ArrayList<ordershow>();
	    try {
	        Class.forName("com.mysql.jdbc.Driver");

	        Connection c = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/cart?characterEncoding=UTF-8",
	                "root", "123456");

	        String sql = "select product.name,orderitem.num,orderitem.oid from order_,orderitem,product where order_.id = orderitem.oid and orderitem.pid = product.id and order_.uid = ?";

	        PreparedStatement ps = c.prepareStatement(sql);

	        ps.setInt(1, uid);

	        ResultSet rs = ps.executeQuery();
	        
	        while(rs.next())
	        {
	        	String name = rs.getString(1);
	        	int num = rs.getInt(2);
	        	int oid = rs.getInt(3);
	        	
	        	ordershow od = new ordershow(name ,num ,oid);
	        	show.add(od);
	        }
	        ps.close();
			 c.close();
	    } catch (ClassNotFoundException e) {
	        e.printStackTrace();
	    } catch (SQLException e) {
	        e.printStackTrace();
	    }
	    return show;
	}
}

package dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import bean.Product;
import bean.user;

public class productdao {
	public int gettotal()
	{
		int total = 0;
		try{
			  Class.forName("com.mysql.jdbc.Driver");//加载数据库驱动
			  Connection c = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/cart?characterEncoding=UTF-8",
	          "root", "123456");//建立数据库连接
			  
			  String sql = "select count(*) from product";//查询product表中所有数据
			  PreparedStatement ps = c.prepareStatement(sql);//执行sql语句
			  ResultSet rs = ps.executeQuery();//获取sql语句执行的结果
			  
			  if (rs.next()) {
				    total = rs.getInt(1);
				}
			  
			  ps.close();
			  c.close();
		}catch (ClassNotFoundException e) {
          e.printStackTrace();
      } catch (SQLException e) {
          e.printStackTrace();
      }
		
		return total;
	}
	public List<Product> list(int start,int count)
	{
		List<Product> products = new ArrayList<Product>();//创建一个product类型的集合，
		//存储数据库的产品信息，返回给jsp页面显示
		try{
			  Class.forName("com.mysql.jdbc.Driver");//加载数据库驱动
			  Connection c = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/cart?characterEncoding=UTF-8",
	          "root", "123456");//建立数据库连接
			  
			  String sql = "select * from product limit ?,?";//查询product表中所有数据
			  PreparedStatement ps = c.prepareStatement(sql);//执行sql语句
			  ps.setInt(1, start);
			  ps.setInt(2, count);
			  ResultSet rs = ps.executeQuery();//获取sql语句执行的结果
			  
			  while(rs.next())//这里在存储结果时就可以直接调用我之前写的构造方法，不需要像教程那样一个一个变量的添加
			  {
				  int id = rs.getInt(1);
				  String name = rs.getString(2);
				  double price = rs.getDouble(3);
				  
				  Product p = new Product(id ,name ,price);
				  products.add(p);
			  }
			  
			  ps.close();
			  c.close();
		}catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return products;
    }
	
	public Product getproduct(int id)
	{
		Product p = null;
		
		try{
			Class.forName("com.mysql.jdbc.Driver");//加载数据库驱动
			  Connection c = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/cart?characterEncoding=UTF-8",
	          "root", "123456");//建立数据库连接
			  
			  String sql = "select * from product where id = ?";
			  
			  PreparedStatement ps = c.prepareStatement(sql);
			  ps.setInt(1 ,id);
			  
			  ResultSet rs = ps.executeQuery();
			  
			  if (rs.next()) p = new Product(id ,rs.getString(2) ,rs.getDouble(3));
			  
			  ps.close();
			  rs.close();
			  
		}
		catch (ClassNotFoundException e) {
        e.printStackTrace();
		} catch (SQLException e) {
        e.printStackTrace();
		}
		return p;
	}
}

package dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import bean.user;

public class userdao {
	public static void main(String[] args) {
		user u = new userdao().getuser("h", "1282");//判断是否找到了user里的数据，这样写的好处就是没找到不会报错。教程的方法没找到会报错
		if (u != null) {
		    System.out.println(u.getname());
		}
    }
    public user getuser(String name ,String password)
    {
    	user u = null;
    	try {
    		Class.forName("com.mysql.jdbc.Driver");//加载数据库驱动
			Connection c = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/cart?characterEncoding=UTF-8",
	          "root", "123456");//建立数据库连接
 
            String sql = "select * from user where name = ? and password = ?";
            PreparedStatement ps = c.prepareStatement(sql);
 
            ps.setString(1, name);
            ps.setString(2, password);
            ResultSet rs = ps.executeQuery();//如果找到了就会返回一个指针，如果没找到就会返回false
 
            if (rs.next()) {
                 u = new user(rs.getInt(1), name, password);
            }
    	
            ps.close();
            c.close();
            
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    	return u;
    }
    public void add(user u)
    {
    	try {
    		Class.forName("com.mysql.jdbc.Driver");//加载数据库驱动
			Connection c = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/cart?characterEncoding=UTF-8",
	          "root", "123456");//建立数据库连接
 
            String sql = "insert into user values (null,?,?)";
            PreparedStatement ps = c.prepareStatement(sql);
 
            ps.setString(1, u.getname());
            ps.setString(2, u.getpassword());
            ps.execute();
    	
            ps.close();
            c.close();
            
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

servlet类

package servlet;

import java.io.IOException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import bean.order;
import bean.orders;
import bean.user;
import dao.order_delete;
import dao.orderdao;
import dao.ordersdao;

@WebServlet("/delete")
public class delete extends HttpServlet {
	private static final long serialVersionUID = 1L;
	
	protected void service(HttpServletRequest request ,HttpServletResponse response)
			throws ServletException,IOException{
				
				user u = (user) request.getSession().getAttribute("user");//从session中获取user
				if (null == u)//如果从session中没有找到用户的登录记录，就返回登录界面要求登录
				{
					response.sendRedirect("login.jsp");
					return;
				}
				
				new order_delete().deleteall(u.getid());//调用相应的dao
				
				response.setContentType("text/html; charset=UTF-8");
				response.sendRedirect("show");
			}
}

package servlet;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@WebServlet("/listorder")
public class listorder extends HttpServlet {
	private static final long serialVersionUID = 1L;
	protected void service(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
        request.getRequestDispatcher("listorder.jsp").forward(request, response);
    }
}

package servlet;

import java.io.IOException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import bean.Product;
import dao.productdao;

@WebServlet("/listproduct")
public class listproduct extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
	protected void service(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		
		int start = 0 ,cnt = 4;
		try {
            start = Integer.parseInt(request.getParameter("start"));
        } catch (NumberFormatException e) {}
		
		int next = start + cnt;
		int pre = start - cnt;
		int total = new productdao().gettotal();
		
		int last;
		if (total % cnt == 0) last = total - cnt;
		else
			last = total / cnt * cnt;
		
		pre = pre < 0 ? 0 : pre;
		next = next > last ? last : next;
		
		request.setAttribute("next", next);
        request.setAttribute("pre", pre);
        request.setAttribute("last", last);
		
		List<Product> product = new productdao().list(start ,cnt);
		request.setAttribute("products", product);
		request.getRequestDispatcher("productlist.jsp").forward(request, response);
    }
}

package servlet;

import java.io.IOException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import bean.order;
import bean.orders;
import bean.user;
import dao.orderdao;
import dao.ordersdao;

@WebServlet("/ordercreate")
public class ordercreate extends HttpServlet {
	private static final long serialVersionUID = 1L;
   
	protected void service(HttpServletRequest request ,HttpServletResponse response)
	throws ServletException,IOException{
		
		user u = (user) request.getSession().getAttribute("user");//从session中获取user
		if (null == u)//如果从session中没有找到用户的登录记录，就返回登录界面要求登录
		{
			response.sendRedirect("login.jsp");
			return;
		}
		
		order o = new order(u);
		new orderdao().insert(o);//把订单保存到order_表中
		
		List<orders> os = (List<orders>) request.getSession().getAttribute("ois");
		for (orders oss : os)
		{
			oss.setorder(o);
			new ordersdao().insert(oss);//把购买的产品数据加入orderitem表
		}
		
		 os.clear();
         
	     response.setContentType("text/html; charset=UTF-8");
	     response.getWriter().println("订单创建成功");
	}
}

package servlet;

import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import bean.orders;

@WebServlet("/orderdelete")
public class orderdelete extends HttpServlet {
	private static final long serialVersionUID = 1L;
    protected void service (HttpServletRequest request ,HttpServletResponse response)
    throws ServletException,IOException{
    	
    	int id = Integer.parseInt(request.getParameter("pid"));//拿到jsp页面传过来的需要删除的订单项产品id
    	List<orders> ois = (List<orders>) request.getSession().getAttribute("ois");//拿到已经保存的所有订单项
    	List<orders> od = new ArrayList<>();//再创建一个集合用来保存需要删除的订单项
    	
    	if (null != ois)
    	{
    		for (orders o : ois){
    			if (o.getp().getid() == id) od.add(o);//找到目标订单项就加入创建的集合
    		}
    	}
    	
    	ois.removeAll(od);//删除所有目标订单项
    	response.sendRedirect("listorder");
    }
}

package servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import bean.orders;
import bean.Product;
import dao.productdao;


@WebServlet("/ordersadd")
public class ordersadd extends HttpServlet {
	private static final long serialVersionUID = 1L;
	protected void service(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
 
		response.setContentType("text/html;charset=UTF-8");
        int num = Integer.parseInt(request.getParameter("num"));
        int pid = Integer.parseInt(request.getParameter("pid"));//获取id和num
        
        Product p = new productdao().getproduct(pid);//找到product信息
        orders oi = new orders(p ,num);

		List<orders> ois = (List<orders>) request.getSession().getAttribute("ois");//从session中看看能不能找到已有的集合
 
        if (null == ois) {//如果该账户未曾有过集合，就创建一个新的
            ois = new ArrayList<orders>();
            request.getSession().setAttribute("ois", ois);
        }
 
        int flag = 0;
        for (orders o : ois) {//遍历集合，看看当前购买的商品是再次购买还是第一次购买，如果是再次购买只更新num即可
            if (o.getp().getid() == oi.getp().getid()) {
                o.setnum(o.getnum() + oi.getnum());
                flag = 1;
                break;
            }
        }
 
        if (flag != 1)//如果是第一次购买，给集合中加入当前订单项类
            ois.add(oi);
 
        response.sendRedirect("listorder");
    }
}

package servlet;

import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import bean.Product;
import bean.ordershow;
import bean.user;
import dao.ordersshowdao;
import dao.productdao;


@WebServlet("/show")
public class show extends HttpServlet {
	private static final long serialVersionUID = 1L;
	protected void service(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		user u = (user) request.getSession().getAttribute("user");
		List<ordershow> l = new ordersshowdao().show(u.getid());
		request.setAttribute("list", l);
		request.getRequestDispatcher("show.jsp").forward(request, response);
    }	
}

package servlet;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import bean.user;
import dao.userdao;
@WebServlet("/userlogin")
public class userlogin extends HttpServlet {

	private static final long serialVersionUID = 1L;

	protected void service(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
        String name = request.getParameter("name");
        String password = request.getParameter("password");
        user user = new userdao().getuser(name, password);
        if (user != null) {
            request.getSession().setAttribute("user", user);
            response.sendRedirect("listproduct");
        } else
            response.sendRedirect("login.jsp");
    }
}

package servlet;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import bean.user;
import dao.userdao;

@WebServlet("/zhuce")
public class zhuce extends HttpServlet {
	private static final long serialVersionUID = 1L;
    
	protected void service(HttpServletRequest request ,HttpServletResponse response)
	throws ServletException,IOException{
		
		request.setCharacterEncoding("utf-8");
		String name = request.getParameter("name");
        String password = request.getParameter("password");
        
        user u = new user();
        u.setname(name);
        u.setpassword(password);
        
        new userdao().add(u);
        response.sendRedirect("login.jsp");
	}
}

jsp页面：

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" import="java.util.*"%>
 
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
 <script src="https://how2j.cn/study/js/jquery/2.0.0/jquery.min.js"></script>
<link href="https://how2j.cn/study/css/bootstrap/3.3.6/bootstrap.min.css" rel="stylesheet">
<script src="https://how2j.cn/study/js/bootstrap/3.3.6/bootstrap.min.js"></script>
<script>
$(function(){
    $("a").addClass("btn btn-default btn-xs");
     
});</script>
  <div align="center">
   <p style = "font-size:30px"> 购物车 </p>
  </div>
<table style="width:500px; margin:44px auto" class="table table-striped table-bordered table-hover  table-condensed" >
    <tr>
        <td>商品名称</td>
        <td>单价</td>
        <td>数量</td>
        <td>小计</td>
        <td>删除</td>
    </tr>
    <c:forEach items="${ois}" var="oi" varStatus="st">
        <tr>
            <td>${oi.product.name}</td>
            <td>${oi.product.price}</td>
            <td>${oi.num}</td>
            <td>${oi.product.price * oi.num}</td>
            <td><a href="orderdelete?pid=${oi.product.id}" style = "font-size:20px">删除</a></td>
        </tr>
    </c:forEach>
    
    <c:if test="${!empty ois}">
		<tr>
			<td colspan="5" align="right">
				<a href="ordercreate" style = "font-size:35px">生成订单</a>
			</td>
		</tr>
	</c:if>

</table>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" import="java.util.*"%>
 
<!DOCTYPE html>
<style>
	.button{
		width:200px;
		height:90px;
		text-decoration:none;
		font: bold 50px 黑体;
		color:black;
		background-color: #EEEEEE;
		border:1px solid black;
	}
</style>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
 <body style="width: 100%;height: 500px;">
	<div style="margin:200px 600px;">
		<form action="userlogin" method="post" style="font-size:50px">
    		姓名： <input type="text" name="name" style="height:45px;width:400px;"> <br>
    		密码： <input type="password" name="password" style="height:45px;width:400px;"> <br>
    		<br>
    		<input type="submit" value="登录" style="font-size:50px;width:130px;height:70px;">
    		<a href="zhuce.jsp" class="button">注册</a>
		</form>
	</div>
</body>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" import="java.util.*"%>
 
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
 <script src="https://how2j.cn/study/js/jquery/2.0.0/jquery.min.js"></script>
<link href="https://how2j.cn/study/css/bootstrap/3.3.6/bootstrap.min.css" rel="stylesheet">
<script src="https://how2j.cn/study/js/bootstrap/3.3.6/bootstrap.min.js"></script>
<script>
$(function(){
    $("a").addClass("btn btn-default btn-xs");
     
});</script>
<c:if test="${!empty user}">
  <div align="center">
   <p style = "font-size:30px"> 当前用户: ${user.name}</p>
  </div>
  <div align="center">
  	<a href="show" style = "font-size:35px">查看订单记录</a>
  </div>
</c:if>
<table style="width:600px;margin:44px auto" class="table table-striped table-bordered table-hover  table-condensed" >
    <tr>
        <td style="text-align: center;">id</td>
        <td style="text-align: center;">名称</td>
        <td style="text-align: center;">价格</td>
        <td style="text-align: center;">购买</td>
    </tr>
    <c:forEach items="${products}" var="product" varStatus="st">
        <tr>
            <td>${product.id}</td>
            <td>${product.name}</td>
            <td>${product.price}</td>
            <td>
            <form action="ordersadd" method ="post">
            	数量<input type = "text" name="num" value = "1" style="width:40px;">
            		<input type = "hidden" value = "${product.id}" name = "pid">
            		<input type="submit" value="购买" >
            </form>
            </td>
        </tr>
    </c:forEach>
</table>
<nav>
    <ul class="pager">
        <li><a href="?start=0" style = "font-size:20px">首  页</a></li>
        <li><a href="?start=${pre}" style = "font-size:20px">上一页</a></li>
        <li><a href="?start=${next}" style = "font-size:20px">下一页</a></li>
        <li><a href="?start=${last}" style = "font-size:20px">末  页</a></li>
    </ul>           
</nav>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" import="java.util.*"%>
 
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
 <script src="https://how2j.cn/study/js/jquery/2.0.0/jquery.min.js"></script>
<link href="https://how2j.cn/study/css/bootstrap/3.3.6/bootstrap.min.css" rel="stylesheet">
<script src="https://how2j.cn/study/js/bootstrap/3.3.6/bootstrap.min.js"></script>
<script>
$(function(){
    $("a").addClass("btn btn-default btn-xs");
});</script>
<c:if test="${!empty user}">
  <div align="center">
   <p style = "font-size:30px"> 当前用户: ${user.name}</p>
  </div>
  <div align="center">
  	<a href="delete" style = "font-size:35px">删除订单记录</a>
  </div>
</c:if>
<table style="width:600px;margin:44px auto" class="table table-striped table-bordered table-hover  table-condensed" >
    <tr>
        <td style="text-align: center;">产品信息</td>
        <td style="text-align: center;">购买数量</td>
        <td style="text-align: center;">订单id</td>
    </tr>
    <c:forEach items="${list}" var="l" varStatus="st">
        <tr>
            <td>${l.productname}</td>
            <td>${l.num}</td>
            <td>${l.oid}</td>
        </tr>
    </c:forEach>
</table>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" import="java.util.*"%>
 
<!DOCTYPE html>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
 <body style="width: 100%;height: 500px;">
	<div style="margin:200px 600px;">
		<form action="zhuce" method="post" style="font-size:50px">
    		姓名： <input type="text" name="name" style="height:45px;width:400px;"> <br>
    		密码： <input type="password" name="password" style="height:45px;width:400px;"> <br>
    		<br>
    		<input type="submit" value="注册" style="font-size:50px;width:130px;height:70px;">
		</form>
	</div>
</body>