MyBatis多参数问题(@Param和arg和param)

最新推荐文章于 2024-02-01 13:12:42 发布

添砖

最新推荐文章于 2024-02-01 13:12:42 发布

阅读量903

点赞数 1

文章标签： sql mysql dba

本文链接：https://blog.csdn.net/Joash_Wu/article/details/122024251

版权

三者等价

@Repository
public interface UserMapper {
    @Select("SELECT * FROM user WHERE username=#{username} AND age=#{age}")
    public User findUser01(@Param("username") String username, @Param("age") Integer age);

    @Select("SELECT * FROM user WHERE username=#{arg0} AND age=#{arg1}")
    public User findUser02(String username,Integer age);

    @Select("SELECT * FROM user WHERE username=#{param1} AND age=#{param2}")
    public User findUser03(String username,Integer age);
}