MyBatisPlus

MyBatisPlus（簡稱MP）是一個基于MyBatis的增強工具庫，簡化了MyBatis的開發，提供了很多實用的功能和特性，如自動生成SQL、通用CRUD操作、分頁插件、條件構造器、代碼生成器等。它不僅簡化了開發過程，還提高了開發效率，使得開發者能夠更專注于業務邏輯的實現而非繁瑣的SQL操作。MyBatisPlus廣泛應用于Java項目中，尤其是基于MyBatis的數據庫訪問層開發。

依賴

<!--mybatis-plus-->
<dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-boot-starter</artifactId><version>3.5.3.1</version>
</dependency>

掃描Mapper

@SpringBootApplication
@MapperScan("com.mybatis.mybatisplusdemo.mapper")  //掃描mapper
public class MyBatisPlusDemoApplication {public static void main(String[] args) {SpringApplication.run(MyBatisPlusDemoApplication.class, args);}
}

數據表

實體類

@Data
@TableName("employee_235") //映射的表名
public class Emp {private  int id;private  String name;private  String tele;private  char gender;private Date birthday;private  float salary;private  String post;private  int depNo;
}

Mapper接口

@Mapper
public interface EmpMapper extends BaseMapper<Emp> { }

Controller

@RestController
@RequestMapping("/emp")
public class EmpController {@Autowiredprivate EmpMapper empMapper ;@GetMapping("/list")public Result getEmpList(){List<Emp> list= empMapper.selectList(null);return  Result.success("獲取成功",list);}
}

{"code":200,"meg":"獲取成功","data":[{"id":2024021,"name":"王德法","tele":"1335645465","gender":"男","birthday":"2024-03-21T16:00:00.000+00:00","salary":7544.0,"post":"審核員","depNo":1},{"id":2024091,"name":"張大炮","tele":"13333354634","gender":"男","birthday":"2024-03-22T16:00:00.000+00:00","salary":7557.0,"post":"審核員","depNo":2},{"id":2024101,"name":"李二牛","tele":"13354676765","gender":"男","birthday":"2024-03-23T16:00:00.000+00:00","salary":4574.0,"post":"審核員","depNo":3},{"id":2024185,"name":"張三鳳","tele":"13354654543","gender":"男","birthday":"2024-03-20T16:00:00.000+00:00","salary":5201.0,"post":"審核員","depNo":3}]}