Mapper 接口如何传递多个参数？

阳光穿透心脏的1/2处 2022-12-13 11:29 112阅读 0赞

*  方式一、接口中传多个参数，在 xml 中使用 \#\{param0\}、\#\{param1\}…
 *  方式二、使用 @param 注解指定名称，在 xml 中使用 \#\{名称\}
 *  方式三、多个参数封装到 Java bean 中
 *  方式四、多个参数指定 key，put 到 Map 中

//方式一
    //java
    System.out.println("------ selectUserByParamIndex ------");
    user = userMapper.selectUserByParamIndex(31, "ConstXiong1");
    System.out.println(user);
    //xml
    < select id="selectUserByParamIndex" resultType="constxiong.po.User">
        select * from user where id = #{arg0} and name = #{arg1}
    < /select>
    
    
    //方式二
    //java
    System.out.println("------ selectUserByAnnotation ------");
    user = userMapper.selectUserByAnnotation(31, "ConstXiong1");
    System.out.println(user);
    //xml
    < select id="selectUserByAnnotation" resultType="constxiong.po.User">
        select * from user where id = #{id} and name = #{name}
    < /select>
    
    
    //方式三
    //java
    System.out.println("------ selectUserByPo ------");
    user = userMapper.selectUserByPo(new User(31, "ConstXiong1"));
    System.out.println(user);
    //xml
    < select id="selectUserByPo" resultType="constxiong.po.User" parameterType="constxiong.po.User">
        select * from user where id = #{id} and name = #{name}
    < /select>
    
    
    //方式四
    //java
    System.out.println("------ selectUserByMap ------");
    Map<String, Object> param = new HashMap<>();
    param.put("id", 31);
    param.put("name", "ConstXiong1");
    user = userMapper.selectUserByMap(param);
    System.out.println(user);
    //xml
    < select id="selectUserByMap" resultType="constxiong.po.User">
        select * from user where id = #{id} and name = #{name}
    < /select>

打印结果

------ selectUserByParamIndex ------
    User{id=31, name='ConstXiong1', mc='null'}
    ------ selectUserByAnnotation ------
    User{id=31, name='ConstXiong1', mc='null'}
    ------ selectUserByPo ------
    User{id=31, name='ConstXiong1', mc='null'}
    ------ selectUserByMap ------
    User{id=31, name='ConstXiong1', mc='null'}

--------------------

### 【Java面试题与答案】整理推荐 ###

*  [基础与语法][Link 1]
 *  [集合][Link 2]
 *  [网络编程][Link 3]
 *  [并发编程][Link 4]
 *  [Web][]
 *  [安全][Link 5]
 *  [设计模式][Link 6]
 *  [框架][Link 7]
 *  [算法与数据结构][Link 8]
 *  [异常][Link 9]
 *  [文件解析与生成][Link 10]
 *  [Linux][]
 *  [MySQL][]
 *  [Oracle][]
 *  [Redis][]
 *  [Dubbo][]

[Link 1]: https://www.javanav.com/interview/93b0069472fd479393006c0e73043fc4.html
[Link 2]: https://www.javanav.com/interview/4147d95e693945e7a50345fd33ec817e.html
[Link 3]: https://www.javanav.com/interview/68a57ffc78de4133bb890bdd502ac418.html
[Link 4]: https://www.javanav.com/interview/36a24fa3258e45c89873f474ce914912.html
[Web]: https://www.javanav.com/interview/4e27cb63adb440c6825a159d35cf4010.html
[Link 5]: https://www.javanav.com/interview/03affb2ce3f04fda8853f714e5764906.html
[Link 6]: https://www.javanav.com/interview/07a32a9ff17a4006a53550ce658cafed.html
[Link 7]: https://www.javanav.com/interview/5c466456e9b54ab0a749b5948e51f1d3.html
[Link 8]: https://www.javanav.com/interview/943f917041ee4f05add24539f5b861b2.html
[Link 9]: https://www.javanav.com/interview/d3f058cfc05d4c6dadd821b622e84d36.html
[Link 10]: https://www.javanav.com/interview/67a50996c28f418e83b109ea42fc3eff.html
[Linux]: https://www.javanav.com/interview/00cccb81729540d1923bd0a0ef49533a.html
[MySQL]: https://www.javanav.com/interview/d311e78502a845f1a4bb307bd6aec2b3.html
[Oracle]: https://www.javanav.com/interview/5f29e9677edf4a16be3dce30d257c9ab.html
[Redis]: https://www.javanav.com/interview/066c62b3af4d4827b2243a822c3084a9.html
[Dubbo]: https://www.javanav.com/interview/9a3e7a7740324757abaab953f7ebc455.html