MyBatis处理动态设置表名

我为杰伦代言

已于 2022-10-28 19:28:33 修改

阅读量744

点赞数

分类专栏： MyBatis 文章标签： mybatis

于 2022-10-26 21:25:05 首次发布

本文链接：https://blog.csdn.net/weixin_52385232/article/details/127540441

版权

MyBatis 专栏收录该内容

53 篇文章 0 订阅

订阅专栏

MyBatis处理动态设置表名

SpecialSQLMapper 接口

public interface SpecialSQLMapper {
    /**
     * 动态设置表名，查询当前用户信息
     * @param tableName
     * @return
     */
    List<User> getUserList(@Param("tableName") String tableName);
}

MyBatis的映射文件 SpecialSQLMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.atguigu.mybatis.mapper.SpecialSQLMapper">
    <!--List<User> getUserList(@Param("tableName") String tableName);-->
    <select id="getUserList" resultType="User">
        select * from ${tableName}
    </select>
</mapper>

测试

public class SpecialSQLMapperTest {
    @Test
    public void testGetUserList(){
        SqlSession sqlSession = SqlSessionUtil.getSqlSession();
        SpecialSQLMapper mapper = sqlSession.getMapper(SpecialSQLMapper.class);
        List<User> list = mapper.getUserList("t_user");
        list.forEach(System.out::println);
    }
}