MybatisPlus与Mybatis

Mybatis

package com.example.springboot.mapper;

/**
 * 功能：是一个接口 用来操作数据库  未使用MybatisPlus的时候的写法
 * 作者：猛猛学
 * 日期：2024/4/11 16:01
 */

//import org.apache.catalina.User;

import com.example.springboot.entity.User;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
//通过@Mapper，这个注释，把这个interface的UserMapper注入到spring的容器里面
public interface UserMapper {

//    将user对象属性里的值插到数据库里去
//    ④最后通过一个sql去执行
    @Insert("insert into `user` (username,password,name,phone,email,address,avatar,role) " +
            "values (#{username},#{password},#{name},#{phone},#{email},#{address},#{avatar},#{role})")
    void insert(User user);

//    修改
    @Update("update `user` set username = #{username}, password = #{password}, name = #{name}, " +
            "phone=#{phone}, email=#{email}, address=#{address}, avatar=#{avatar} where id=#{id}")
    void updateUser(User user);

//    删除
    @Delete("delete from `user` where id = #{id}")//不写id的话就把整张表给删了
    void deleteUser(Integer id);

//    查询所有
    @Select("select * from `user`")
    List<User> selectAll();

//   倒序查询 desc
    @Select("select * from `user` order by id desc")
    List<User> selectDesc();

//    单条件查询
    @Select("select * from `user` where id = #{id} order by id desc")
    User selectById(Integer id);

//    多条件查询
    @Select("select * from `user` where username = #{username} and name = #{name} order by id desc")
    List<User> selectByMore(@Param("username") String username, @Param("name") String name);

//    模糊查询  多条件全模糊查询
    @Select("select * from `user` where username like concat('%', #{username},'%') and name like concat('%', #{name},'%') order by id desc")
    List<User> selectByLike(String username, String name);

//    分页模糊查询
    @Select("select * from `user` where username like concat('%', #{username}, '%') and name like concat('%', #{name}, '%') order by id desc limit #{skipNum}, #{pageSize}")
    List<User> selectByPage(@Param("skipNum") Integer skipNum, @Param("pageSize")Integer pageSize, @Param("username") String username, @Param("name") String name);

    @Select("select count(id) from `user` where username like concat('%', #{username}, '%') and name like concat('%', #{name}, '%') order by id desc")
    int selectCountByPage(@Param("username") String username, @Param("name") String name);

//    查询用户名username
    @Select("select * from `user` where username = #{username} order by id desc")
    User selectByUsername(String username);
}

MybatisPlus

package com.example.springboot.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.springboot.entity.User;

/**
 * 功能：是一个接口 用来操作数据库  MybatisPlus直接继承BaseMapper， BaseMapper里提供了现成的语句
 * 作者：猛猛学
 * 日期：2024/4/11 16:01
 */

public interface UserMapper extends BaseMapper<User> {

}