首页 > 代码库 > mybatis 之 resultType="Integer"
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>
mybatis 之 resultType="Integer"
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。