Spring Boot：从数据库表结构到书籍信息查询全流程代码实现

好的，下面是实现这些需求的代码示例。 1. BookController 类 ```java import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import java.util.List; @RestController @RequestMapping("/books") public class BookController { private final BookService bookService; @Autowired public BookController(BookService bookService) { this.bookService = bookService; } @GetMapping("/all") public List<Book> findAll() { return bookService.findAll(); } } ``` 2. BookService 接口和 BookServiceImpl 实现类 BookService 接口 ```java import java.util.List; public interface BookService { List<Book> findAll(); } ``` BookServiceImpl 实现类 ```java import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; @Service public class BookServiceImpl implements BookService { private final BookMapper bookMapper; @Autowired public BookServiceImpl(BookMapper bookMapper) { this.bookMapper = bookMapper; } @Override public List<Book> findAll() { return bookMapper.findAll(); } } ``` 3. BookMapper 数据库访问接口 ```java import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Select; import java.util.List; @Mapper public interface BookMapper { @Select("SELECT * FROM books") List<Book> findAll(); } ``` 4. Book 实体类 ```java public class Book { private int id; private String title; private String author; private double price; private int stock; // Getters and Setters public int getId() { return id; } public void setId(int id) { this.id = id; } public String getTitle() { return title; } public void setTitle(String title) { this.title = title; } public String getAuthor() { return author; } public void setAuthor(String author) { this.author = author; } public double getPrice() { return price; } public void setPrice(double price) { this.price = price; } public int getStock() { return stock; } public void setStock(int stock) { this.stock = stock; } } ``` 5. Spring Boot 主应用类（如果需要） ```java import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; @SpringBootApplication public class BookApplication { public static void main(String[] args) { SpringApplication.run(BookApplication.class, args); } } ``` 6. application.properties 配置文件（如果需要） ```properties spring.datasource.url=jdbc:mysql://localhost:3306/your_database_name?useSSL=false&serverTimezone=UTC spring.datasource.username=your_username spring.datasource.password=your_password spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver mybatis.mapper-locations=classpath:mapper/*.xml ``` 以上代码展示了如何创建一个 Spring Boot 应用程序来查询所有书籍信息并返回 JSON 格式的数据。请确保你已经配置好数据库连接，并且 MyBatis 的依赖已经添加到你的项目中。 ######[AI写代码神器 | 983点数解答 | 2024-12-13 08:43:29]