动态后端查询优化

yujian

2019-04-26 107f8855ed63da486be48ffebe7a51f38f41e6a0

动态后端查询优化

 fanli/src/main/java/com/yeshi/fanli/controller/TestController.java

@@ -115,7 +115,7 @@
    @RequestMapping(value = "testactivity")

    public void test2(PrintWriter out) {

        List<RecommendActivity> list = activityService.getRecommendActivityList(1, Constant.PAGE_SIZE);

        long count = activityService.getRecommendActivityCount();

        long count = activityService.getRecommendActivityCount(null);

        JSONObject data = new JSONObject();

        data.put("data", getGson().toJson(list));

        data.put("count", count);


 fanli/src/main/java/com/yeshi/fanli/controller/admin/ActivityAdminController.java

@@ -472,7 +472,7 @@
                }

            }

            

            int count = (int) activityService.getRecommendActivityCount();

            int count = (int) activityService.getRecommendActivityCount(key);



            int totalPage = count % Constant.PAGE_SIZE == 0 ? count / Constant.PAGE_SIZE : count / Constant.PAGE_SIZE + 1;

            PageEntity pe = new PageEntity(pageIndex, Constant.PAGE_SIZE, count, totalPage);


 fanli/src/main/java/com/yeshi/fanli/dao/mybatis/activity/RecommendActivityMapper.java

@@ -24,7 +24,7 @@

    List<RecommendActivity> getRecommendActivityList(@Param("start") long start, @Param("count") int count);

    long getRecommendActivityCount();
    long getRecommendActivityCount(@Param("title") String title);
    
    long getRecommendActivityEffectiveCount();


 fanli/src/main/java/com/yeshi/fanli/mapping/activity/RecommendActivityMapper.xml

@@ -56,20 +56,22 @@


    <select id="queryRecommendActivityList" resultMap="BaseResultMap">
        select * from yeshi_ec_activity_recommend 
        left join yeshi_ec_activity_user on ar_activity_uid=au_id
         where 1=1
             <if test="title != null and title != '' ">
                  ar_title like '%${title}%' 
             </if>
         order by ar_top desc,ar_order_by asc,ar_create_time desc 
         limit ${start},${count}
        SELECT * FROM yeshi_ec_activity_recommend t
        LEFT JOIN yeshi_ec_activity_user u ON t.ar_activity_uid=u.au_id
        WHERE 1=1
             <IF test="title != null and title != '' ">
                  AND t.ar_title LIKE '%${title}%' 
             </IF>
         ORDER BY t.ar_top DESC,t.ar_order_by ASC,t.ar_create_time DESC 
         LIMIT ${START},${COUNT}
    </select>

    <select id="getRecommendActivityCount" resultType="java.lang.Long">
        select
        count(ar_id)
        from yeshi_ec_activity_recommend
        SELECT IFNULL(COUNT(t.ar_id),0) FROM yeshi_ec_activity_recommend t
         WHERE 1=1
             <IF test="title != null and title != '' ">
                  AND t.ar_title LIKE '%${title}%' 
             </IF>
    </select>



 fanli/src/main/java/com/yeshi/fanli/service/impl/activity/ActivityServiceImpl.java

@@ -120,8 +120,8 @@
    }



    @Override

    public long getRecommendActivityCount() {

        return recommendActivityMapper.getRecommendActivityCount();

    public long getRecommendActivityCount(String title) {

        return recommendActivityMapper.getRecommendActivityCount(title);

    }



    @Override


 fanli/src/main/java/com/yeshi/fanli/service/inter/activity/ActivityService.java

@@ -159,7 +159,7 @@
     * 

     * @return

     */

    public long getRecommendActivityCount();

    public long getRecommendActivityCount(String title);



    

    public long getRecommendActivityCountCache();