mybaits 中没有else要用chose when otherwise 代替
<choose> <when test="isHotProduct!= null and isHotProduct == 'Y'.toString()"> AND wd.is_hot_product = 'Y' </when> <otherwise> AND wd.is_hot_product IS NULL OR wd.is_hot_product ='N' </otherwise> </choose>
<choose> <when test="isHotProduct!= null and isHotProduct == 'Y'.toString()"> AND wd.is_hot_product = 'Y' </when> <otherwise> AND wd.is_hot_product IS NULL OR wd.is_hot_product ='N' </otherwise> </choose>