初始的首页
首先获取首页中头条展示内容的List
然后还要获取一级店铺类别,用来将店铺分类展示
Dao层
获取头条信息
/** * 通过传入的查询条件,查询头条信息 * @param headLineCondition * @return */ List<HeadLine> queryHeadLine(@Param( "headLineCondition" ) HeadLine headLineCondition);
<select id="queryHeadLine" resultType="com.shop.bean.HeadLine"> SELECT line_id, line_name, line_link, line_img, priority, status, create_time, last_edit_time FROM head_line <where> <if test="headLineCondition.status != null"> and status=#{headLineCondition.status} </if> </where> ORDER BY priority DESC </select>
获取店铺类别信息
/** * 获取店铺类别 * @param shopCategoryCondition * @return */ List<ShopCategory> queryShopCategory(@Param("shopCategoryCondition") ShopCategory shopCategoryCondition);
<select id="queryShopCategory" resultType="com.shop.bean.ShopCategory"> SELECT shop_category_id, shop_category_name, shop_category_desc, shop_category_img, priority, create_time, last_edit_time, parent_id FROM 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.parent != null"> AND parent_id = #{shopCategoryCondition.parent.shopCategoryId} </if> </where> ORDER BY priority DESC </select>
Service层
头条信息
/** * 根据查询条件返回头条列表 * @param headLineCondition * @return */ List<HeadLine> getHeadLineList(HeadLine headLineCondition);
public List<HeadLine> getHeadLineList(HeadLine headLineCondition) { return headLineDao.queryHeadLine( headLineCondition ); }
店铺类别
/** * 根据查询条件获取店铺类别列表 * @param shopCategoryCondition * @return */ List<ShopCategory>getShopCategoryList(ShopCategory shopCategoryCondition);
public List<ShopCategory> getShopCategoryList(ShopCategory shopCategoryCondition) { return shopCategoryDao.queryShopCategory( shopCategoryCondition ); }
Controller层
/** * 初始化前端展示系统信息,包括一级店铺类别列表信息和头条列表 * @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{ //传入null时(parentId为null),获取的时一级店铺类别 shopCategoryList = shopCategoryService.getShopCategoryList( null ); modelMap.put( "shopCategoryList", shopCategoryList ); }catch(Exception e){ modelMap.put( "success", false ); modelMap.put( "errMsg", e.toString() ); return modelMap; } List<HeadLine> headLineList = new ArrayList<>( ); try{ //获取 status == 1 的头条列表,用于在首页的头条展示 HeadLine headLineCondition = new HeadLine(); headLineCondition.setStatus( 1 ); headLineList = headLineService.getHeadLineList( headLineCondition ); modelMap.put( "headLineList", headLineList ); } catch(Exception e){ modelMap.put( "success", false ); modelMap.put( "errMsg", e.toString() ); return modelMap; } modelMap.put( "success", true ); return modelMap; }