美文网首页
第9章 前端系统的展示

第9章 前端系统的展示

作者: cuzz_ | 来源:发表于2018-05-08 13:42 被阅读0次

首页后台开发

Dao层的实现

  • 新建一个HeadLineDao接口
public interface HeadLineDao {
    /**
     * 根据传入的条件查询
     * @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>
  • 测试
    发现数据哭着少了一列
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());
    }
  • 测试结果


    image.png

Service层实现

  • 接口
public interface HeadLineService {
    /**
     * 根据传入的条件返回指定的头条列表
     * @param headLineCondition
     * @return
     * @throws IOException
     */
    List<HeadLine> getHeadLineList(HeadLine headLineCondition) throws IOException;
}
  • 实现类
@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层的实现

  • 新建在web下frontend包,新建MainPageController类
@Controller
@RequestMapping("/frontend")
public class MainPageController {
    @Autowired
    private ShopCategoryService shopCategoryService;

    @Autowired
    private HeadLineService headLineService;

    /**
     * 初始化前端展示的系统的主页信息 包括获取一级店铺类别列表一级头条
     * @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 {
            // 获取状态为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";
    }
}

店铺列表

Dao层的实现

  • 增加通过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层的实现

  • 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 {
            // 获取区域列表信息
            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中添加一个返回的页面
    @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";
    }
  • 新建一个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");
        // 获取一页需要的显示条数
        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

相关文章

  • 第9章 前端系统的展示

    首页后台开发 Dao层的实现 新建一个HeadLineDao接口 mapper 测试发现数据哭着少了一列 测试单元...

  • 个人博客搭建

    记录一下个人博客的搭建: 1.核心思想1.1博客分为前端展示页面以及后端博客管理系统前端主要负责展示博客,后端负责...

  • Web前端开发,利用HTML5 Canvas实现监控系统页面展示

    今天我们将向您展示如何创建前端监控系统。 在这里相信有许多想要学习web前端的同学,大家可以+下web前端学习分享...

  • 第2章 项目设计和框架搭建

    系统功能模块划分 学习目标 明确各模块的职责 了解各模块所涉及的对象 前端展示系统 店家管理系统 超级管理员系统 ...

  • 推荐引擎系统功能模块分析

    推荐引擎系统的主要模块分为数据收集、用户建模、物品建模、推荐算法、混合模块、结果存储、前端展示和查询引擎。推荐系统...

  • 前后端分离_分页

    在分页类编写数据,展示前端实现跳转 你的数据样式 前端接收数据,展示

  • 项目沟通之面对面沟通案例

    公司业务迁移,前端从版本A切换到版本B,变化的主要是前端展示,底层系统基本没变。从业务方的角度,是想知道A和B版本...

  • 狂神

    前端展示 后台存储数据数据结构 算法数据库DB 数据库管理系统DBMS 表 行 列 数据...

  • 前端开发和后端开发有什么区别

    前端开发和后端开发的区别在于: 一、展示方式不同 1、前端开发主要做的是用户所能看到的前端展示界面。 2、后端开发...

  • 学习资源免费领取

    赠人玫瑰,手有余香。下面是我精心整理的一些资源,欢迎领取。 web前端视频:前端资源展示-1前端资源展示2 后续资...

网友评论

      本文标题:第9章 前端系统的展示

      本文链接:https://www.haomeiwen.com/subject/hnomrftx.html