Mybatis多参数查询方法，多个参数类型相同

1.通过注解形式

dao中的代码如下：

Integer selectGoodScoreByGoodIdAndOrderId(@Param(value="goodId")Integer goodId,@Param(value="orderId")Integer orderId);

映射xml文件配置

<select id="selectGoodScoreByGoodIdAndOrderId" resultType="java.lang.Integer" parameterType="java.lang.Integer">
        SELECT g.GOOD_SCORE from good_estimate g where g.GOOD_ID =#{goodId,jdbcType=INTEGER} and g.ORDER_ID = #{orderId,jdbcType=INTEGER}
  </select>

service的代码如下：

Integer goodScore = goodEstimateMapper.selectGoodScoreByGoodIdAndOrderId(Integer
                              .valueOf(goodId), Integer
                               .valueOf(orderId));

2.通过参数占位符的形式

dao中的代码如下：

Integer selectGoodScoreByGoodIdAndOrderId(Integer goodId,Integer orderId);

映射xml文件配置

<select id="selectGoodScoreByGoodIdAndOrderId" resultType="java.lang.Integer" parameterType="java.lang.Integer">

        SELECT g.GOOD_SCORE from good_estimate g where g.GOOD_ID =#{param1} and g.ORDER_ID = #{param2}
  </select>

service的代码如下：

Integer goodScore = goodEstimateMapper.selectGoodScoreByGoodIdAndOrderId(Integer
                              .valueOf(goodId), Integer
                               .valueOf(orderId))

3.通过键值对map形式

Integer selectGoodScoreByGoodIdAndOrderId(Map<String, Object> map);

映射xml文件配置

<select id="selectGoodScoreByGoodIdAndOrderId" resultType="java.lang.Integer" parameterType="java.util.Map">
        SELECT g.GOOD_SCORE from good_estimate g where g.GOOD_ID =#{goodId} and g.ORDER_ID = #{orderId}
  </select>

service的代码如下：

  Map<String, Object> paramMap2 = new HashMap<String, Object>();

         paramMap2.put("goodId",goodId);
         paramMap2.put("orderId",orderId);
  Integer goodScore = goodEstimateMapper.selectGoodScoreByGoodIdAndOrderId(paramMap2);

4.通过如果参数的个数超过5个建议为javaBean的形式

package  com.test.params

public class Good{

 private String goodId;

 private String orderId;

    public String getGoodId() {
        return goodId;
    }

    public void setGoodId(String goodId) {
        this.goodId = goodId;
    }

    public String getOrderId() {
        return orderId;
    }

    public void setOrderId(String orderId) {
        this.orderId = orderId;
    }

}

dao:

Integer selectGoodScoreByGoodIdAndOrderId(Good params);

xml

<select id="selectGoodScoreByGoodIdAndOrderId" resultType="java.lang.Integer" parameterType="com.test.params.Good">
        SELECT g.GOOD_SCORE from good_estimate g where g.GOOD_ID =#{goodId} and g.ORDER_ID = #{orderId}
</select>