初始的首页
首先获取首页中头条展示内容的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;
}