mybatis 之 resultType="Integer"

public class EcPromoteRuleAdditionalNew extends BaseBO {


    private String[] promoteRuleIds;

    public String[] getPromoteRuleIds() {
        return promoteRuleIds;
    }

    public void setPromoteRuleIds(String[] promoteRuleIds) {
        this.promoteRuleIds = promoteRuleIds;
    }

}

 


if (!allUsedPromoteRuleIds.equals("")) { allUsedPromoteRuleIds = allUsedPromoteRuleIds.substring(0, allUsedPromoteRuleIds.lastIndexOf(",")); } // 根据促销规则查询是否不支持货到付款 if (allUsedPromoteRuleIds != null && !allUsedPromoteRuleIds.equals("")) { EcPromoteRuleAdditionalNew promoteRuleAdditional = new EcPromoteRuleAdditionalNew(); promoteRuleAdditional.setPromoteRuleIds(allUsedPromoteRuleIds .split(",")); Integer count = myecService .getAdditionalKDFHCount(promoteRuleAdditional);
<!-- 根据促销规则查询附加优惠是否支持货到付款 -->
  <select id="getAdditionalKDFHCount"  resultType="Integer" parameterType="EcPromoteRuleAdditionalNew">
           select count(1)
         from ec_promote_rule_new pr,
              ec_promote_rule_ADDITIONAL_NEW pra
         where pr.promote_rule_id = pra.promote_rule_id
               and pra.additional_type = 'FKFS'
               and pra.additional_value = 'KDFH'
                <if test="promoteRuleIds != null">
                    and pra.PROMOTE_RULE_ID in
                    <foreach collection="promoteRuleIds" index="index" item="item" open="(" separator="," close=")">
                           #{item}
                     </foreach>
                </if>
  </select>