mybatis中数组和List使用下标取值以及传入多个参数时取值

刺骨的言语ヽ痛彻心扉 2024-04-23 03:18 66阅读 0赞

**记录**：416

**场景**：在mybatis中接口的入参是数组和List时，使用下标从数组和List取值。接口的入参有多个参数时取值，以及注解@Param使用。

**版本**：JDK 1.8,Spring Boot 2.6.3,mybatis-3.5.9。

**1.入参是数组时使用下标取值**

入参是数组时使用下标取值，和Java代码中数组使用下标取值一样。

**1.1Mapper接口**

@Repository
    public interface GetValueByIndexMapper {
      int insertCityByArray(long[] cityInfo);
    }

**1.2Mapper.xml**

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="com.hub.example.mapper.GetValueByIndexMapper">
      <insert id="insertCityByArray" parameterType="long[]">
          INSERT INTO t_city_index(CITY_ID, POPULATION, GROSS)
          VALUES (#{cityInfo[0]}, #{cityInfo[1]}, #{cityInfo[2]})
      </insert>
    </mapper>

**2.入参是List时使用下标取值**

入参是数组时使用下标取值，和Java代码中数组使用下标取值一样。

**2.1Mapper接口**

public interface GetValueByIndexMapper {
      int insertCityByList(List<Long> cityInfo);
    }

**2.2Mapper.xml**

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="com.hub.example.mapper.GetValueByIndexMapper">
      <insert id="insertCityByList" parameterType="java.util.List">
          INSERT INTO t_city_index(CITY_ID, POPULATION, GROSS)
          VALUES (#{cityInfo[0]}, #{cityInfo[1]}, #{cityInfo[2]})
      </insert>
    </mapper>

**3.入参有多个参数时取值**

入参有多个参数时取值，第一个参数时一个实体类，第二个参数时一个基本类型。使用@Param注解在接口的方法上指定MyBatis在XML中取值的参数名称。

**3.1Mapper接口**

public interface GetValueByIndexMapper {
      int insertCityMultipleArgs(@Param("cityArgs") CityArgs cityArgs, @Param("gross") long gross);
    }

**3.2Mapper.xml**

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="com.hub.example.mapper.GetValueByIndexMapper">
      <insert id="insertCityMultipleArgs">
          INSERT INTO t_city_index(CITY_ID, POPULATION, GROSS)
          VALUES (#{cityArgs.cityId}, #{cityArgs.population}, #{gross})
      </insert>
    </mapper>

**4.测试**

**4.1测试代码**

@Slf4j
    @RestController
    @RequestMapping("/hub/example/cityIndex")
    public class GetValueByIndexController {
      @Autowired
      private GetValueByIndexMapper getValueByIndexMapper;
      @GetMapping("/load01")
      public Object load01() {
        log.info("测试开始...");
        long[] paraList01 = new long[]{1L, 2L, 3L};
        getValueByIndexMapper.insertCityByArray(paraList01);
        List<Long> paraList02 = Arrays.asList(11L, 12L, 12L);
        getValueByIndexMapper.insertCityByList(paraList02);
        log.info("测试结束...");
        return "执行成功";
      }
      @GetMapping("/load02")
      public Object load02() {
        log.info("测试开始...");
        long[] paraList01 = new long[]{1L, 2L, 3L};
        CityArgs cityArgs = CityArgs.builder().cityId(111L).population(222L).build();
        long gross = 333L;
        getValueByIndexMapper.insertCityMultipleArgs(cityArgs,gross);
        log.info("测试结束...");
        return "执行成功";
      }
    }

**4.2测试URL**

URL01：http://127.0.0.1:18080/hub-example/hub/example/cityIndex/load01

URL02：http://127.0.0.1:18080/hub-example/hub/example/cityIndex/load02

**5.辅助**

**5.1实体对象**

@Data
    @Builder
    @NoArgsConstructor
    @AllArgsConstructor
    public class CityArgs {
        private Long cityId;
        private Long population;
    }

**5.2建表语句**

CREATE TABLE t_city_index (
      CITY_ID BIGINT(16) NOT NULL COMMENT '唯一标识',
      POPULATION BIGINT(16) DEFAULT NULL COMMENT '城市人口',
      GROSS BIGINT(20) DEFAULT NULL COMMENT '生产总值'
    ) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='城市信息表';

以上，感谢。

2023年4月18日