springboot—Mapper注解版—多个参数查询需要加上@Param

最新推荐文章于 2024-06-23 13:13:58 发布

鲸鱼姐

最新推荐文章于 2024-06-23 13:13:58 发布

阅读量4.5k

点赞数 2

CC 4.0 BY-SA版权

分类专栏： springboot mybatis

本文链接：https://blog.youkuaiyun.com/zhaolulu916/article/details/95179891

@Mapper
public interface UserMapper {
    @Select("select * from t_user where id = #{id}")
    public User getUserById(Integer id);


    @Options(useGeneratedKeys = true,keyProperty = "id") //加入自增主键
    @Insert("insert into t_user(username,password,employeeNum,departmentId) values(#{username},#{password},#{employeeNum},#{departmentId})")
    public int insertUser(User user);

    @Delete("delete from t_user where id=#{id}")
    public int deleteById(Integer id);

    @Update("update t_user set username=#{username},password=#{password} where id=#{id}")
    public int updateUser(User user);

    @Select("select * from t_user")
    public List<User> getALLUsers();

    @Select("select u.*,r.rolename from t_user u left join t_role_user ru on u.id=ru.user_id left join t_role r on ru.role_id=r.id where username=#{username}")
    public List<Role> findByUserName(String username);


    @Select("select * from t_user where username like CONCAT('%',#{name},'%'