SpringBoot 集成 MyBatis 增删改查实战教程

"下面是一个 Spring Boot 集成 MyBatis 的增删改查案例：\n\n1. 首先，在 pom.xml 文件中添加以下依赖：\n\nxml\n<dependencies>\n <!-- Spring Boot Starter Web -->\n <dependency>\n <groupId>org.springframework.boot</groupId>\n <artifactId>spring-boot-starter-web</artifactId>\n </dependency>\n \n <!-- MyBatis Starter -->\n <dependency>\n <groupId>org.mybatis.spring.boot</groupId>\n <artifactId>mybatis-spring-boot-starter</artifactId>\n </dependency>\n \n <!-- MySQL Connector -->\n <dependency>\n <groupId>mysql</groupId>\n <artifactId>mysql-connector-java</artifactId>\n </dependency>\n</dependencies>\n\n\n2. 创建一个数据库表，并在 application.properties 文件中配置数据库连接信息：\n\nproperties\nspring.datasource.url=jdbc:mysql://localhost:3306/mydb\nspring.datasource.username=root\nspring.datasource.password=123456\nspring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver\n\n\n3. 创建一个实体类 User.java，表示数据库表的一条记录：\n\njava\npublic class User {\n private Long id;\n private String name;\n private Integer age;\n\n // 省略 getter 和 setter 方法\n}\n\n\n4. 创建一个 Mapper 接口 UserMapper.java，定义增删改查方法：\n\njava\n@Mapper\npublic interface UserMapper {\n @Select("SELECT * FROM user")\n List<User> findAll();\n\n @Insert("INSERT INTO user(name, age) VALUES(#{name}, #{age})")\n void insert(User user);\n\n @Update("UPDATE user SET name=#{name}, age=#{age} WHERE id=#{id}")\n void update(User user);\n\n @Delete("DELETE FROM user WHERE id=#{id}")\n void delete(Long id);\n}\n\n\n5. 创建一个 Service 类 UserService.java，调用 Mapper 接口方法：\n\njava\n@Service\npublic class UserService {\n @Autowired\n private UserMapper userMapper;\n\n public List<User> findAll() {\n return userMapper.findAll();\n }\n\n public void insert(User user) {\n userMapper.insert(user);\n }\n\n public void update(User user) {\n userMapper.update(user);\n }\n\n public void delete(Long id) {\n userMapper.delete(id);\n }\n}\n\n\n6. 创建一个 Controller 类 UserController.java，处理 HTTP 请求：\n\njava\n@RestController\npublic class UserController {\n @Autowired\n private UserService userService;\n\n @GetMapping("/users")\n public List<User> getUsers() {\n return userService.findAll();\n }\n\n @PostMapping("/users")\n public void addUser(@RequestBody User user) {\n userService.insert(user);\n }\n\n @PutMapping("/users/{id}")\n public void updateUser(@PathVariable Long id, @RequestBody User user) {\n user.setId(id);\n userService.update(user);\n }\n\n @DeleteMapping("/users/{id}")\n public void deleteUser(@PathVariable Long id) {\n userService.delete(id);\n }\n}\n\n\n7. 运行 Spring Boot 应用，访问以下 URL 进行增删改查操作：\n\n- GET /users：获取所有用户\n- POST /users：添加用户\n- PUT /users/{id}：更新用户\n- DELETE /users/{id}：删除用户\n\n这样，就完成了一个 Spring Boot 集成 MyBatis 的增删改查案例。\n\n