Mybatis-Plus练习

MP练习

1.编辑mapper接口

public interface UserMapper extends BaseMapper<User> {
   
    List<User> findAll();

    @Insert("insert into demo_user (id,name,age,sex) value (null,#{name},#{age},#{sex})")
    void insertUser(User user);
    @Update("update demo_user set name = #{newName} where name=#{oldName}")
    void updateByname(String oldName, String newName);
    @Delete("delete from demo_user where name=#{name}")
    void deleteByName(String name);
}

2.添加日志

logging:
  level:
    com.jt.mapper: debug

3.查询

@SpringBootTest
public class TestMP {
   

    @Autowired
    private UserMapper userMapper;
	
	//根据id=23查询
    @Test
    public void select01() {
   
        User user = userMapper.selectById(23);
        System.out.println(user);
    }

    @Test
    public void select02() {
   
        User user = new User();
        user.setName("潘凤").setSex("男");
        QueryWrapper