mybatis 传递参数的9种方法

比眉伴天荒 2023-09-24 19:07 70阅读 0赞

<?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.mapper.UserMapper">
        
        <select id="getUserByNameAndAge" resultType="com.pojo.User">
            select * from user where name=#{param1} and age=#{param2}
        </select>
    
        
        <select id="getUserByNameAndAge2" resultType="com.pojo.User">
            select * from user where name=#{name} and age=#{age}
        </select>
    
        
        <select id="getUserByNameAndAge3" resultType="com.pojo.User">
            select * from user where name=#{name} and age=#{age}
        </select>
    
        
        <select id="getUserByNameAndAge4" resultType="com.pojo.User">
            select * from user where name=#{name} and age=#{age}
        </select>
    
    
        
        <select id="getUserByNameAndAge5" resultType="com.pojo.User" parameterType="com.alibaba.fastjson.JSONObject">
            select * from user where name=#{name} and age=#{age}
        </select>
    
        
        <select id="findUserList6" resultType="com.pojo.User">
            SELECT * from user where age in
            <foreach collection="list" open="(" separator="," close=")" item="user">
                #{user.name}
            </foreach>
        </select>
    
        
        <select id="findUserList7" resultType="com.pojo.User">
            SELECT * from course where userid =#{user.id} and teacher in
            <foreach collection="user.courseList" open="(" separator="," close=")" item="course">
                #{course.teacher}
            </foreach>
        </select>
    </mapper>

参考：

[( 这里还有2种 ) MyBatis - 传递参数 7 种方式\_放羊的牧码的博客-CSDN博客\_mybatis传值方式][_2_ _ MyBatis - _ 7 _-CSDN_mybatis]

[mybatis 传递参数的7种方法 - 苍青浪 - 博客园 (cnblogs.com)][mybatis _7_ - _ - _ _cnblogs.com]

[mybatis 传递参数的7种方法-蒲公英云 (dandelioncloud.cn)][mybatis _7_-_ _dandelioncloud.cn]

[_2_ _ MyBatis - _ 7 _-CSDN_mybatis]: https://lux-sun.blog.csdn.net/article/details/84101171?spm=1001.2101.3001.6650.3&utm_medium=distribute.pc_relevant.none-task-blog-2~default~OPENSEARCH~Rate-3-84101171-blog-129110992.pc_relevant_recovery_v2&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2~default~OPENSEARCH~Rate-3-84101171-blog-129110992.pc_relevant_recovery_v2&utm_relevant_index=4
[mybatis _7_ - _ - _ _cnblogs.com]: https://www.cnblogs.com/cangqinglang/p/14237361.html
[mybatis _7_-_ _dandelioncloud.cn]: https://www.dandelioncloud.cn/article/details/1471610420778852354