Jsp电子商务之七 订单篇2

从View页面，点击超链接查询订单,进入到控制器

OrderlistServlet 
 

package com.cart.web;
 

      import java.io.IOException;
      import java.util.*;
      import javax.servlet.ServletException;
      import javax.servlet.http.HttpServlet;
      import javax.servlet.http.HttpServletRequest;
      import javax.servlet.http.HttpServletResponse;
      import javax.servlet.http.HttpSession;
      import com.cart.entity.*;
      import com.cart.service.OrderService;
      public class OrderlistServlet extends HttpServlet {
     	@Override
     	protected void doGet(HttpServletRequest req, HttpServletResponse resp)
     			throws ServletException, IOException {
     		//从View来获取查询订单;
      		OrderService orderService=new OrderService();
      		Map<Order,ArrayList<Book>> map=(Map<Order,ArrayList<Book>>)orderService.getOrders(null, null);
      		HttpSession session=req.getSession();
      		session.setAttribute("map",map); //将订单map存放到session中；
     		//Iterator it=map.entrySet().iterator();
     		//System.out.println(map.entrySet().size());//长度为2是对的；
     		//下面如何获取订单对象和对应的图书详情信息呢;
     		//后台测试代码
      // Order key;
      // ArrayList<Book> value;
      // while(it.hasNext()){
      // Map.Entry<Order,ArrayList<Book>>entry=(Map.Entry<Order,ArrayList<Book>>)it.next();
      // key=entry.getKey();
      // value=entry.getValue();
      // 
      // System.out.println("订单"+key.getId());
      // System.out.println("书名\t\t价格\t数量\t总价");
      // for(Book book:value){
      // System.out.println(book.getBookname()+"/"+book.getImage()+"/"+book.getPrice()+"/"+book.getCount()+"/"+key.getTotal());
      // }
      // System.out.println();
      // }
      		resp.sendRedirect("orderlist.jsp");
      	}
     	@Override
     	protected void doPost(HttpServletRequest req, HttpServletResponse resp)
     			throws ServletException, IOException {
     		this.doGet(req, resp);
      	}
      }
  
 

      package com.cart.service;
      import java.sql.*;
      import java.util.ArrayList;
      import java.util.HashMap;
      import java.util.Map;
      import com.cart.dao.*;
      import com.cart.dao.impl.*;
      import com.cart.entity.Book;
      import com.cart.entity.Order;
      import com.cart.entity.Userinfo;
      import com.cart.util.DaoFactory;
      import com.cart.util.PageControler;
      public class OrderService {
     	//1.定义属性：对dao进行操作;
      	OrderDao orderDao=new OrderDaoImpl();
      	CartDao cartDao=new CartDaoImpl();
     	//2.对订单,进行增删该查
     	public void delCartAndSaveOrder(String sbid,Userinfo user,Order order){
     		//使用事务操作，业务层可以这样操作，对不同的dao操作；
      		Connection con=null;
      		PreparedStatement pstmt=null;
     		try{
      			StringBuilder sbSql=new StringBuilder();
      			sbSql.append("delete from cartitem where uid=? and bid in(");
      			sbSql.append(sbid);
      			sbSql.append(")");
      			String sql=sbSql.toString();
      			con=DaoFactory.getConnection();
      			pstmt=con.prepareStatement(sql);
      			con.setAutoCommit(false);//设置自动提交事务，为false
      			orderDao.insertOrder(order);//调用杀入订单方法；，同时删除原来的购物车数据方法；
      			Object[] params={user.getId()};
      			DaoFactory.setParams(pstmt, params);
      			DaoFactory.executeUpdate(sql, params);
      			System.out.println(sbSql);
      			con.commit();
      		}catch(Exception e){
      			e.printStackTrace();
      		}finally{
      			DaoFactory.closeAll(null, pstmt, con);
      		}
      	}
     	public int insertOrder(Order order){
     		//ct.deletecartItem(uid, bid);
     		return orderDao.insertOrder(order);
      	}
     	public int updateOrder(int id){
     		return orderDao.updateOrder(id);
      	}
     	public int deleteOrder(int id){
     		return orderDao.deleteOrder(id);
      	}
     	public Order findOrderById(int id){
     		return orderDao.findOrderById(id);
      	}
     	public Map <Order,ArrayList<Book>> getOrders(String sql, PageControler pager) {//获取多条订单并带有详情
     		Connection con = null;
      		Map <Order,ArrayList<Book>> rtn = new HashMap <Order,ArrayList<Book>>();
     		try {
      			con = DaoFactory.getConnection();
     			OrderDao orderDao = new OrderDaoImpl();
      			rtn = orderDao.getOrders(sql, pager);
      		} catch (SQLException e) {
      			e.printStackTrace();
      		} finally {
      			DaoFactory.closeAll(null, null, con);
      		}
     		return rtn;
      	}
      }
  
 

      package com.cart.dao.impl;
      import java.sql.*;
      import java.util.ArrayList;
      import java.util.HashMap;
      import java.util.List;
      import java.util.Map;
      import com.cart.dao.OrderDao;
      import com.cart.entity.Book;
      import com.cart.entity.Order;
      import com.cart.util.DaoFactory;
      import com.cart.util.PageControler;
      public class OrderDaoImpl implements OrderDao{
      	PreparedStatement pstmt=null;
      	Connection con=null;
     	public int deleteOrder(int id) {
     		return 0;
      	}
     	public Order findOrderById(int id) {
     		return null;
      	}
     	public int insertOrder(Order order)  {
     		//将你所获得的订单数据，插入到数据库；
     		int result=-1;
     		try {
      			String sql="insert orders(userid,createtime,total,address,phone,status)values(?,?,?,?,?,?)";
      			con=DaoFactory.getConnection();
      			pstmt=con.prepareStatement(sql);
      			Object[] params={order.getUserid(),order.getCreatetime(),order.getTotal(),order.getShipaddress(),order.getContactphone(),order.getStatus()};
      			DaoFactory.setParams(pstmt, params);
      			result=pstmt.executeUpdate();
      		} catch (SQLException e) {
      			e.printStackTrace();
      		}finally{
      			DaoFactory.closeAll(null, pstmt, con);
      		}
     		return result;
      	}
     	public int updateOrder(int id) {
     		return 0;
      	}
      、、//参数用于以后代码扩展
     	public Map<Order, ArrayList<Book>> getOrders(String sqlCon,
       PageControler pager) throws SQLException {
      		List<Order> rtn = new ArrayList<Order>(); //可能会存在1个客户有多个订单，对吧;
     		//String sql="select O.*,OD.* from orders O inner join orderdetails OD on O.id=OD.oid";
      		String sql="select O.id,o.createtime,o.total,od.count,od.transprice,b.bookname,b.price,b.image" +
     				" from orders o inner join orderdetails od on od.oid=o.id inner join book b on b.id=od.bid";
     		//新的三表连接，取得book的值；
      		con=DaoFactory.getConnection();
      		pstmt=con.prepareStatement(sql);
      		ResultSet rs=pstmt.executeQuery();//执行结果放rs结果集;
      		Map<Order,ArrayList<Book>> map=new HashMap<Order,ArrayList<Book>>();
      		Order order=new Order();//订单对象,用于接收客户的多个订单项；
     		while(rs.next()){
     			int id=rs.getInt("id");//记录上次的一个id;6,如果和现在的id一致，则视为一个order
     			//直接继续，添加书本;
     			if(id!=order.getId()){
      				order.setId(rs.getInt("id"));
      				order.setCreatetime(rs.getDate("createtime"));
      				order.setTotal(rs.getDouble("total"));
      			}
     			//这个可以做好，不同订单，对应不同商品即1:1关系；不适合1：M关系；
     			//到此为止，已经获得了，订单的关键要素点，下面需要获得相应的订单，对应的商品详情了;
      			Book book=new Book();
      			book.setCount(rs.getInt("count"));
      			book.setPrice(rs.getFloat("transprice"));
      			book.setImage(rs.getString("image"));
      			book.setBookname(rs.getString("bookname"));
     			//设置图书表，然后添加到ArrayList里面;
     			if(map.get(order)==null){
      				ArrayList list=new ArrayList();
      				list.add(book);
      				map.put(order, list);
      			}else{
     				//应该在order不为空的情况下判断，是否重复;
      				ArrayList list=map.get(order);
      				list.add(book);
      				map.put(order, list);
      			}
      		}
      		DaoFactory.closeAll(rs, pstmt, con);
     		return map;
      	}
      }
  
 

针对出现多个商品进入到一个订单的问题，已经给予解决了，其中的业务代码还可以继续修改，要继续等待哦。

      OrderDaoImpl
     	public Map<Order, ArrayList<ShoppingItem>> getOrders(String condition,
       PageControler pager) throws SQLException {
     		shoppingService ss = new shoppingService();
      		List<Order> rtn = new ArrayList<Order>(); //可能会存在1个客户有多个订单
      		String sql="select o.id,o.submittime,o.totalprice,b.bid,b.point,b.stock,di.bcount,b.bookname,b.b_price from d_order o inner join d_items di on di.orderId=o.id inner join d_books b on b.bid=di.bid";
     		//新的三表连接，取得book的值；
      		con=DaoFactory.getConnection();
      		pstmt=con.prepareStatement(sql);
      		ResultSet rs=pstmt.executeQuery();//执行结果放rs结果集;
      		Map<Order,ArrayList<ShoppingItem>> map=new HashMap<Order,ArrayList<ShoppingItem>>();
      		Order order=null;//订单对象,用于接收客户的多个订单项；
     		while(rs.next()){
     			if(order==null){
      				order=new Order(); //1.第一次，正常；
      				order.setId(rs.getInt("id"));
      				order.setSubmittime(rs.getString("submittime"));
      				order.setTotalprice(rs.getString("totalprice"));
     				ShoppingItem si = ss.declareShoppingItem(rs);
      				ArrayList list=new ArrayList();
      				list.add(si);
      				map.put(order, list);
      			}else{
     				if(order.getId()!=rs.getInt("id")){
      					order=new Order();
      					order.setId(rs.getInt("id"));
      					order.setSubmittime(rs.getString("submittime"));
      					order.setTotalprice(rs.getString("totalprice"));
     					ShoppingItem si = ss.declareShoppingItem(rs);
      					ArrayList list=new ArrayList();
      					list.add(si);
      					map.put(order, list);
      				}else{//证明是同一个订单;
     					ShoppingItem si = ss.declareShoppingItem(rs);
      					ArrayList list=map.get(order);
      					list.add(si);
      					map.put(order, list);
      				}
      			}
      		}
      		DaoFactory.closeAll(rs, pstmt, con);
     		return map;
      	}
  
 

文章来源: aaaedu.blog.csdn.net，作者：tea_year，版权归原作者所有，如需转载，请联系作者。

原文链接：aaaedu.blog.csdn.net/article/details/53706475