简易版商城项目的搭建11

package com.dao.impl; import com.dao.OrderDao; import com.entity.Address; import com.entity.Item; import com.entity.Orders; import com.entity.Product; import com.utils.DBUtils; import org.apache.commons.beanutils.*; import org.apache.commons.dbutils.QueryRunner; import org.apache.commons.dbutils.handlers.MapHandler; import org.apache.commons.dbutils.handlers.MapListHandler; import java.lang.reflect.InvocationTargetException; import java.sql.SQLException; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.*; public class OrderDaoImpl implements OrderDao { @Override public void insertOrders(Orders orders) { QueryRunner queryRunner = new QueryRunner(); try { queryRunner.update(DBUtils.getConnection(), "insert into orders (o_id,u_id,a_id,o_count,o_time," + "o_state) values (?,?,?,?,?,?)", orders.getOid(), orders.getUid(), orders.getAid(), orders.getOcount(), orders.getOtime(), orders.getOstate()); } catch (SQLException e) { throw new RuntimeException(e); } } @Override public void insertItems(List<Item> items) { QueryRunner queryRunner = new QueryRunner(); Object[][] param = new Object[items.size()][]; for (int i = 0; i < items.size(); i++) { Item item = items.get(i); param[i] = new Object[]{item.getOid(), item.getPid(), item.getIcount(), item.getInum()}; } try { queryRunner.batch(DBUtils.getConnection(), "insert into item (o_id,p_id,i_count,i_num) values (?,?,?,?)", param); } catch (SQLException e) { throw new RuntimeException(e); } } @Override public List<Orders> selectAllByUid(int uid) { QueryRunner queryRunner = new QueryRunner(); List<Orders> ordersList = new ArrayList<>(); try { ConvertUtils.register(new Converter() { @Override public Object convert(Class clazz, Object value) { // 如果字符串为null，则返回null if(value == null) return null; // 如果字符串为空格，则返回null String str = (String) value; if(str.trim().equals("")) return null; // 将字符串转为Date类型 SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); try { return format.parse(value.toString()); } catch (ParseException e) { e.printStackTrace(); } return new Date(); } }, Date.class); List<Map<String, Object>> query = queryRunner.query(DBUtils.getConnection(), "select o.o_id as oid,o.u_id as uid,o.a_id as aid,o.o_count as ocount,o.o_time as otime,o.o_state as ostate," + "a.a_name as aname,a.a_phone as aphone,a.a_detail as adetail,a.a_state as astate from address a join orders o on a.a_id=o.a_id where o.u_id=?", new MapListHandler(), uid); if (query == null) { return null; } for (Map<String, Object> map : query) { Orders orders = new Orders(); Address address = new Address(); BeanUtils.populate(orders, map); BeanUtils.populate(address, map); orders.setAddress(address); ordersList.add(orders); } } catch (SQLException e) { throw new RuntimeException(e); } catch (InvocationTargetException e) { throw new RuntimeException(e); } catch (IllegalAccessException e) { throw new RuntimeException(e); } return ordersList; } @Override public Orders selectOrdersByOid(String oid) { QueryRunner queryRunner=new QueryRunner(); try { ConvertUtils.register(new Converter() { @Override public Object convert(Class clazz, Object value) { // 如果字符串为null，则返回null if(value == null) return null; // 如果字符串为空格，则返回null String str = (String) value; if(str.trim().equals("")) return null; // 将字符串转为Date类型 SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); try { return format.parse(value.toString()); } catch (ParseException e) { e.printStackTrace(); } return new Date(); } }, Date.class); System.out.println(oid); Map<String, Object> map = queryRunner.query(DBUtils.getConnection(), "select o.o_id as oid,o.u_id as uid,o.a_id as aid,o.o_count as ocount,o.o_time as otime,o.o_state as ostate," + "a.a_name as aname,a.a_phone as aphone,a.a_detail as adetail,a.a_state as astate from address a join orders o on a.a_id=o.a_id where o.o_id=?", new MapHandler(),oid); System.out.println(map); Orders orders = new Orders(); Address address = new Address(); BeanUtils.populate(orders,map); BeanUtils.populate(address,map); orders.setAddress(address); return orders; } catch (SQLException e) { throw new RuntimeException(e); } catch (InvocationTargetException e) { throw new RuntimeException(e); } catch (IllegalAccessException e) { throw new RuntimeException(e); } } @Override //订单项和商品多表查询 public List<Item> selectItemsByOId(String oid) { QueryRunner queryRunner=new QueryRunner(); try { ConvertUtils.register(new Converter() { @Override public Object convert(Class clazz, Object value) { // 如果字符串为null，则返回null if(value == null) return null; // 如果字符串为空格，则返回null String str = (String) value; if(str.trim().equals("")) return null; // 将字符串转为Date类型 SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); try { return format.parse(value.toString()); } catch (ParseException e) { e.printStackTrace(); } return new Date(); } }, Date.class); List<Map<String, Object>> maps = queryRunner.query(DBUtils.getConnection(), "select p.p_id as pid,p.t_id as tid,p.p_name as pname,p.p_time as ptime,p.p_image as pimage,p.p_state as pstate," + "p.p_prize as pprize,p.p_info as pinfo,i.i_id as iid,i.i_count as icount,i.i_num as inum from product p join item i on p.p_id=i.p_id where i.o_id=?;", new MapListHandler(), oid); if (maps == null) { return null; } List<Item> items=new ArrayList<>(); for (Map<String, Object> map : maps) { Product product = new Product(); Item item = new Item(); BeanUtils.populate(product,map); BeanUtils.populate(item,map); item.setProduct(product);