mybatis之接口方法多参数的三种实现方式

 关键代码举例：

DaoMapper.xml

    <!-- 传入多个参数时，自动转换为map形式 -->
    <insert id="insertByColumns" useGeneratedKeys="true" keyProperty="id">
        insert into user (id, name, age) values (NULL ,#{param1}, #{param2})
    </insert>
    <insert id="insertByZhuJie" useGeneratedKeys="true" keyProperty="id">
        insert into user (id, name, age) values (NULL ,#{name}, #{age})
    </insert>
    <insert id="insertByMap" useGeneratedKeys="true" keyProperty="id">
        insert into user (id, name, age) values (NULL ,#{name}, #{age})
    </insert>

 

UserDao.java

    // 插入数据；多参数三种方式：默认Map、使用Map传参和使用注解别名
    public int insertByColumns(String name, int age);
    public int insertByZhuJie(@Param("name") String name, @Param("age") int age);
    public int insertByMap(Map map);

 

TestDao.java

    //   多参数插入数据的三种方式
    @Test
    public void testInsertByColumns() {
        UserDao userDao = session.getMapper(UserDao.class);
        String name = "insertByColumns";
        int age = 33;
//        int n = userDao.insertByColumns(name, age);
//        int n = userDao.insertByZhuJie(name, age);

        Map map = new HashMap();
        map.put("name", name);
        map.put("age", age);
        int n = userDao.insertByMap(map);

        session.commit();
        System.out.println("插入数据name：" + name);
        System.out.println(n);
    }