mybatis 中test里面 应该为单引号套双引号

正确写法:test里面 应该为单引号套双引号

 

 

  1.  
    <select id="findTopicPresetByCompanyIDAndCategory" parameterType="map" resultType="com.seeyon.esn.entity.portal.TopicPreset">
  2.  
    select * from topicPreset where companyID = #{companyID}
  3.  
    <if test='category=="0" '> and (category is null or category = "0")</if>
  4.  
    <if test='category=="1" '> and category = "1"</if>
  5.  
posted @ 2018-09-20 14:30  java奋斗  阅读(1759)  评论(0编辑  收藏  举报