本文共 3630 字，大约阅读时间需要 12 分钟。

在控制台打印sql语句配置

mybatis-plus:  configuration:    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

插入一条数据

@Testpublic void insertPlus() {
       User user = new User().setUserName("James").setAge(36).setUserEmail("qqq@sql.com");    userMapper.insert(user);    System.out.println(user);}控制台：==>  Preparing: INSERT INTO tb_user ( userEmail, user_name, age ) VALUES ( ?, ?, ? ) ==> Parameters: qqq@sql.com(String), James(String), 36(Integer)<==    Updates: 1User(id=15, userName=James, age=36, userEmail=qqq@sql.com)

通过id更新信息

@Testpublic void updateByIdLoads() {
       User user = new User().setId(15L).setUserName("Kobe");    Integer insert = userMapper.updateById(user);    System.out.println("return insert value = " + insert);}控制台：==>  Preparing: UPDATE tb_user SET user_name=? WHERE id=? ==> Parameters: Kobe(String), 15(Long)<==    Updates: 1return insert value = 1

根据id批量删除

@Testpublic void deleteLoads() {
       List
   
     list = new ArrayList<>();    list.add(13L);    list.add(14L);    list.add(15L);    Integer insert = userMapper.deleteBatchIds(list);    System.out.println("return deleteBatchIds value = " + insert);}控制台：==>  Preparing: DELETE FROM tb_user WHERE id IN ( ? , ? , ? ) ==> Parameters: 13(Long), 14(Long), 15(Long)<==    Updates: 3return deleteBatchIds value = 3
   

根据id删除

@Testpublic void deleteByIdLoads() {
       Integer deleteById = userMapper.deleteById(12L);    System.out.println("return deleteById value = " + deleteById);}控制台：==>  Preparing: DELETE FROM tb_user WHERE id=? ==> Parameters: 12(Long)<==    Updates: 1return deleteById value = 1

通过多个条件进行实体list查询

@Testpublic void selectByMap() {
       HashMap
   
     map = new HashMap<>(16);    map.put("userEmail", "test1@baomidou.com");    map.put("age", 18);    List
    
      list2 = userMapper.selectByMap(map);    list2.forEach(System.out::println);    System.out.println("---------------黄金分割线---------------");    QueryWrapper
     
       queryWrapper = new QueryWrapper
      
       ().eq("age", 18).eq("user_name", "Tom");    List
       
      
     
    
   

分页查询

@Testpublic void selectPageLoads() {
       Page
   
     page = new Page<>(2,3);    IPage
    
      pageResult = userMapper.selectPage(page, null);    List
     
       recordsAge = pageResult.getRecords();    recordsAge.forEach(System.out::println);}控制台：==>  Preparing: SELECT COUNT(1) FROM tb_user ==> Parameters: <==    Columns: COUNT(1)<==        Row: 6==>  Preparing: SELECT id,userEmail,user_name,age FROM tb_user LIMIT ?,? ==> Parameters: 3(Long), 3(Long)<==    Columns: id, userEmail, user_name, age<==        Row: 4, test4@baomidou.com, Sandy, 21<==        Row: 5, test5@baomidou.com, Billie, 24<==        Row: 6, 123.qq.com, Tom, 18<==      Total: 3User(id=4, userName=Sandy, age=21, userEmail=test4@baomidou.com)User(id=5, userName=Billie, age=24, userEmail=test5@baomidou.com)User(id=6, userName=Tom, age=18, userEmail=123.qq.com)
     
    
   

更多用法可以查看源码。

转载地址：http://fgdhb.baihongyu.com/