首頁后臺開發(fā)

Dao層的實(shí)現(xiàn)

• 新建一個(gè)HeadLineDao接口

public interface HeadLineDao {
    /**
     * 根據(jù)傳入的條件查詢
     * @param headLineCondition
     * @return
     */
    List<HeadLine> queryHeadLine(@Param("headLineCondition") HeadLine headLineCondition);
}

• mapper

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.imooc.o2o.dao.HeadLineDao">

    <select id="queryHeadLine" resultType="com.imooc.o2o.entity.HeadLine">
        SELECT
        line_id,
        line_name,
        line_link,
        line_img,
        priority,
        enable_status,
        create_time,
        last_edit_time
        FROM
        tb_head_line
        <where>
           <if test="headLineCondition.enableStatus != null">
               AND enable_status = #{headLineCondition.enableStatus}
           </if>
        </where>
        ORDER BY
        priority DESC
    </select>
</mapper>

• 測試
  發(fā)現(xiàn)數(shù)據(jù)哭著少了一列

ALTER TABLE tb_head_line ADD COLUMN line_img varchar(1000) DEFAULT NULL;

測試單元

    @Test
    public void testQueryArea() {
        HeadLine headLineCondition = new HeadLine();
        List<HeadLine> headLineList = headLineDao.queryHeadLine(headLineCondition);
        System.out.println(headLineList.size());
    }

image.png

ShopCategoryDao的改造

• 支持 parent_Id為空的情況奔害，返回一級level

<mapper namespace="com.imooc.o2o.dao.ShopCategoryDao">
    <select id="queryShopCategory" resultType="com.imooc.o2o.entity.ShopCategory">
        SELECT
        shop_category_id,
        shop_category_name,
        shop_category_desc,
        shop_category_img,
        priority,
        create_time,
        last_edit_time,
        parent_id
        FROM
        tb_shop_category
        <where>
            <if test="shopCategoryCondition == null">
                and parent_id is null
            </if>
            <if test="shopCategoryCondition!= null">
                and parent_id is not null
            </if>
            <if test="shopCategoryCondition != null and shopCategoryCondition.parentId!=null">
                and parent_id = #{shopCategoryCondition.parentId}
            </if>
        </where>
        ORDER BY
        priority DESC
    </select>

• 測試

    @Test
    public void testBQueryShopCategory() throws Exception {
        List<ShopCategory> shopCategoryList = shopCategoryDao.queryShopCategory(null);
        System.out.println(shopCategoryList.size());
    }

• 測試結(jié)果

  
  
  image.png

Service層實(shí)現(xiàn)

• 接口

public interface HeadLineService {
    /**
     * 根據(jù)傳入的條件返回指定的頭條列表
     * @param headLineCondition
     * @return
     * @throws IOException
     */
    List<HeadLine> getHeadLineList(HeadLine headLineCondition) throws IOException;
}

• 實(shí)現(xiàn)類

@Service
public class getHeadLineList implements HeadLineService{
    @Autowired
    private HeadLineDao headLineDao;
    
    @Override
    public List<HeadLine> getHeadLineList(HeadLine headLineCondition) throws IOException {
        List<HeadLine>  headLineList = headLineDao.queryHeadLine(headLineCondition);
        return  headLineList;
    }
}

Controller層的實(shí)現(xiàn)

• 新建在web下frontend包楷兽，新建MainPageController類

@Controller
@RequestMapping("/frontend")
public class MainPageController {
    @Autowired
    private ShopCategoryService shopCategoryService;

    @Autowired
    private HeadLineService headLineService;

    /**
     * 初始化前端展示的系統(tǒng)的主頁信息 包括獲取一級店鋪類別列表一級頭條
     * @return
     */
    @RequestMapping(value = "/listmainpageinfo", method = RequestMethod.GET)
    @ResponseBody
    private Map<String, Object> listMainPageInfo() {
        Map<String, Object> modelMap = new HashMap<>();
        List<ShopCategory> shopCategoryList = new ArrayList<>();

        try {
            // 獲取一級店鋪列表(即parentId為空的ShopCategory)
            shopCategoryList = shopCategoryService.getShopCategoryList(null);
            modelMap.put("shopCategoryList", shopCategoryList);
        } catch (Exception e) {
            modelMap.put("success", false);
            modelMap.put("errMsg", e.getMessage());
            return modelMap;
        }

        List<HeadLine> headLineList = new ArrayList<>();

        try {
            // 獲取狀態(tài)為1(可用的頭條列表)
            HeadLine headLineCondition = new HeadLine();
            headLineCondition.setEnableStatus(1);
            headLineList = headLineService.getHeadLineList(headLineCondition);
            modelMap.put("headLineList", headLineList);

        } catch (Exception e) {
            modelMap.put("success", false);
            modelMap.put("errMsg", e.getMessage());
            return modelMap;
        }

        modelMap.put("success", true);
        return modelMap;
    }

}

• 測試

  
  
  image.png

前端頁面展示

• 新建FrontendAdminControlle控制類

@Controller
@RequestMapping("/frontend")
public class FrontendAdminController {

    @RequestMapping(value = "index", method = RequestMethod.GET)
    private String index() {
        return "frontend/index";
    }
}

• 測試
  注意靜態(tài)文件的路徑
  如果圖片不放在靜態(tài)資源里的話，也可以通過tomcat解析路徑
  https://www.cnblogs.com/magic101/p/7756402.html
  
  image.png

店鋪列表

Dao層的實(shí)現(xiàn)

• 增加通過parent_id查詢

    <select id="queryShopList" resultMap="shopMap">
        SELECT
        s.shop_id,
        s.shop_name,
        s.shop_desc,
        s.phone,
        s.shop_img,
        s.priority,
        s.create_time,
        s.last_edit_time,
        s.enable_status,
        s.advice,
        a.area_id,
        a.area_name,
        sc.shop_category_id,
        sc.shop_category_name
        FROM
        tb_shop s,
        tb_area a,
        tb_shop_category sc
        <where>
            <if test="shopCondition.shopCategory != null and shopCondition.shopCategory.shopCategoryId != null">
                AND s.shop_category_id = #{shopCondition.shopCategory.shopCategoryId}
            </if>
            新增加的
            <if test="shopCondition.shopCategory != null 
                     and shopCondition.shopCategory.parent != null
                     and shopCondition.shopCategory.parent.shopCategoryId != null">
               AND s.shop_category_id IN (
                SELECT 
                shop_category_id 
                FROM 
                tb_shop_category
                WHERE 
                parent_id = #{shopCondition.shopCategory.parent.shopCategoryId}
                )
            </if>
            <if test="shopCondition.area != null and shopCondition.area.areaId != null">
                AND s.shop_area_id = #{shopCondition.areaId}
            </if>
            <if test="shopCondition.shopName != null">
                AND s.shop_name LIKE "%${shopCondition.shopName}%"
            </if>
            <if test="shopCondition.enableStatus != null">
                AND s.enable_status = #{shopCondition.enableStatus}
            </if>
            <if test="shopCondition.owner != null and shopCondition.owner.userId != null">
                AND s.owner_id = #{shopCondition.owner.userId}
            </if>
            AND
            s.area_id = a.area_id
            AND
            s.shop_category_id = sc.shop_category_id
    </where>
        ORDER BY
        s.priority DESC
        LIMIT #{rowIndex}, #{pageSize}
    </select>

同理count中也要增加

            <if test="shopCondition.shopCategory != null
                     and shopCondition.shopCategory.parent != null
                     and shopCondition.shopCategory.parent.shopCategoryId != null">
               AND s.shop_category_id IN (
                SELECT
                shop_category_id
                FROM
                tb_shop_category
                WHERE
                parent_id = #{shopCondition.shopCategory.parent.shopCategoryId}
                )
            </if>

Controller層的實(shí)現(xiàn)

• ShopListController

@Controller
@RequestMapping(value ="/frontend")
public class ShopListController {
    @Autowired
    ShopCategoryService shopCategoryService;

    @Autowired
    AreaService areaService;

    @Autowired
    ShopService shopService;

    @RequestMapping(value = "/listshoppageinfo", method = RequestMethod.GET)
    @ResponseBody
    private Map<String, Object> listShopPageInfo(HttpServletRequest request) {
        Map<String, Object> modelMap = new HashMap<>();
        // 試著從前端獲取parentId
        long parentId = HttpServletRequestUtil.getLong(request, "parent");
        List<ShopCategory> shopCategoryList = null;

        if (parentId != -1) {
            try {
                ShopCategory shopCategoryCondition = new ShopCategory();
                ShopCategory parent = new ShopCategory();
                parent.setShopCategoryId(parentId);
                shopCategoryCondition.setParent(parent);
                shopCategoryList = shopCategoryService.getShopCategoryList(shopCategoryCondition);
            } catch (Exception e) {
                modelMap.put("success", false);
                modelMap.put("errMsg", e.getMessage());
            }
        } else {
            try {
                // 如果parentId不存在 則取出所有一級ShopCategory
                shopCategoryList = shopCategoryService.getShopCategoryList(null);
            } catch (Exception e) {
                modelMap.put("success", false);
                modelMap.put("errMsg", e.getMessage());
            }
        }

        modelMap.put("shopCategoryList", shopCategoryList);

        List<Area>  areaList = null;

        try {
            // 獲取區(qū)域列表信息
            areaList = areaService.getAreaList();
            modelMap.put("areaList", areaList);
            modelMap.put("success", true);
        } catch (Exception e) {
            modelMap.put("success", false);
            modelMap.put("errMsg", e.getMessage());
        }

        return modelMap;
    }

    @RequestMapping(value = "/listshops", method = RequestMethod.GET)
    @ResponseBody
    private Map<String, Object> listShops(HttpServletRequest request) {
        Map<String, Object> modelMap = new HashMap<String, Object>();
        int pageIndex = HttpServletRequestUtil.getInt(request, "pageIndex");
        int pageSize = HttpServletRequestUtil.getInt(request, "pageSize");
        if ((pageIndex > -1) && (pageSize > -1)) {
            long parentId = HttpServletRequestUtil.getLong(request, "parentId");
            long shopCategoryId = HttpServletRequestUtil.getLong(request,
                    "shopCategoryId");
            int areaId = HttpServletRequestUtil.getInt(request, "areaId");
            String shopName = HttpServletRequestUtil.getString(request,
                    "shopName");
            Shop shopCondition = compactShopCondition4Search(parentId,
                    shopCategoryId, areaId, shopName);
            ShopExecution se = shopService.getShopList(shopCondition,
                    pageIndex, pageSize);
            modelMap.put("shopList", se.getShopList());
            modelMap.put("count", se.getCount());
            modelMap.put("success", true);
        } else {
            modelMap.put("success", false);
            modelMap.put("errMsg", "empty pageSize or pageIndex");
        }

        return modelMap;
    }

    private Shop compactShopCondition4Search(long parentId,
                                             long shopCategoryId, int areaId, String shopName) {
        Shop shopCondition = new Shop();
        if (parentId != -1L) {
            ShopCategory parentCategory = new ShopCategory();
            parentCategory.setShopCategoryId(parentId);
            // TODO
            // shopCondition.setParentCategory(parentCategory);
        }
        if (shopCategoryId != -1L) {
            ShopCategory shopCategory = new ShopCategory();
            shopCategory.setShopCategoryId(shopCategoryId);
            shopCondition.setShopCategory(shopCategory);
        }
        if (areaId != -1L) {
            Area area = new Area();
            area.setAreaId(areaId);
            shopCondition.setArea(area);
        }

        if (shopName != null) {
            shopCondition.setShopName(shopName);
        }
        shopCondition.setEnableStatus(1);
        return shopCondition;
    }
}

-測試

image.png

返回頁面

• 在FrontendAdminController中添加一個(gè)返回的頁面
  @RequestMapping(value = "shoplist", method = RequestMethod.GET)
  private String shopList() {
  return "frontend/shoplist";
  }

• 測試

  
  
  image.png

店鋪詳情頁面

Controller層

• 返回shopdetail頁面

    @RequestMapping(value = "shopdetail", method = RequestMethod.GET)
    private String shopDetail() {
        return "frontend/shopdetail";
    }

• 新建一個(gè)ShopDetailController類

@Controller
@RequestMapping("/frontend")
public class ShopDetailController {
    @Autowired
    private ShopService shopService;

    @Autowired
    private ProductService productService;

    @Autowired
    private ProductCategoryService productCategoryService;

    /**
     * 獲取店鋪信息以及該店鋪下的商品列別列表
     * @param request
     * @return
     */
    @RequestMapping(value = "/listshopdetailpageinfo", method = RequestMethod.GET)
    @ResponseBody
    private Map<String, Object> listShopDetailPageInfo(HttpServletRequest request) {

        Map<String, Object> modelMap = new HashMap<>();

        // 獲取前臺傳過來的shopId
        long shopId = HttpServletRequestUtil.getLong(request, "shopId");
        Shop shop = null;
        List<ProductCategory> productCategoryList = null;

        if (shopId != -1) {
            // 獲取店鋪Id為shopId的店鋪
            shop = shopService.getByShopId(shopId);
            // 獲取店鋪下面的商品類別列表
            productCategoryList = productCategoryService.getProductCategroyList(shopId);
            modelMap.put("shop", shop);
            modelMap.put("productCategoryList", productCategoryList);
            modelMap.put("success", true);
        } else {
            modelMap.put("success", false);
            modelMap.put("errMsg", "empty shopId");
        }
        return modelMap;
    }

    @RequestMapping(value = "/listproductsbyshop", method = RequestMethod.GET)
    @ResponseBody
    private Map<String, Object> listProductByShop(HttpServletRequest request) {
        Map<String, Object> modelMap = new HashMap<>();

        // 獲取頁碼
        int pageIndex = HttpServletRequestUtil.getInt(request, "pageIndex");
        // 獲取一頁需要的顯示條數(shù)
        int pageSize = HttpServletRequestUtil.getInt(request, "pageSize");
        // 獲取店鋪Id
        long shopId = HttpServletRequestUtil.getLong(request, "shopId");
        // 空值判斷
        if ((pageSize > -1) && (pageIndex > -1) && (shopId > -1)) {
            long productCategoryId = HttpServletRequestUtil.getLong(request,
                    "productCategoryId");
            String productName = HttpServletRequestUtil.getString(request,
                    "productName");
            Product productCondition = compactProductCondition4Search(shopId,
                    productCategoryId, productName);
            ProductExecution pe = productService.getProductList(
                    productCondition, pageIndex, pageSize);
            modelMap.put("productList", pe.getProductList());
            modelMap.put("count", pe.getCount());
            modelMap.put("success", true);
        } else {
            modelMap.put("success", false);
            modelMap.put("errMsg", "empty pageSize or pageIndex or shopId");
        }
        return modelMap;
    }

    private Product compactProductCondition4Search(long shopId,
                                                   long productCategoryId, String productName) {
        Product productCondition = new Product();
        Shop shop = new Shop();
        shop.setShopId(shopId);
        productCondition.setShop(shop);
        if (productCategoryId != -1L) {
            ProductCategory productCategory = new ProductCategory();
            productCategory.setProductCategoryId(productCategoryId);
            productCondition.setProductCategory(productCategory);
        }
        if (productName != null) {
            productCondition.setProductName(productName);
        }
        productCondition.setEnableStatus(1);
        return productCondition;
    }    
}

image.png

image.png