首页 > 其他 > 详细

mybatic 结果为null,返回0

时间:2016-11-27 22:27:40      阅读:239      评论:0      收藏:0      [点我收藏+]

 

返回空容易产生异常,当值为null时,返回为0的写法

<select id="getBookWordCountBookPssAndChapterLockOrPass" resultType="LONG" parameterType="STRING">
        select  COALESCE(sum(word_count),0) as word_count
        from t_news_count 
        WHERE 
        chapter_id  in 
        ( SELECT chapter_id 
          from t_content_chapter  
          WHERE 
          book_id = #{book_id,jdbcType=VARCHAR} 
          AND  
          ( status = 3 OR status = 1) ) 
        AND 
        ( 3 = (SELECT current_state 
               FROM t_content_metadata 
               WHERE  book_id = #{book_id,jdbcType=VARCHAR} ) 
        ) 
    </select>

 

mybatic 结果为null,返回0

原文:http://www.cnblogs.com/caer/p/6106993.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!