Spring Boot 水果表 CRUD API 示例 - 使用 MySQL 数据库

///'以下是一个使用Spring Boot框架和MySQL数据库的简单水果表的代码项目示例。//n//n首先，创建一个名为Fruit的实体类，表示水果表的每一行记录。//n//njava//nimport javax.persistence.Entity;//nimport javax.persistence.GeneratedValue;//nimport javax.persistence.GenerationType;//nimport javax.persistence.Id;//n//n@Entity//npublic class Fruit {//n @Id//n @GeneratedValue(strategy = GenerationType.AUTO)//n private Long id;//n//n private String name;//n private double price;//n private int quantity;//n//n public Fruit() {//n }//n//n public Fruit(String name, double price, int quantity) {//n this.name = name;//n this.price = price;//n this.quantity = quantity;//n }//n//n // 省略getter和setter方法//n}//n//n//n接下来，创建一个名为FruitRepository的接口，继承JpaRepository，用于对水果表进行数据库操作。//n//njava//nimport org.springframework.data.jpa.repository.JpaRepository;//n//npublic interface FruitRepository extends JpaRepository<Fruit, Long> {//n}//n//n//n然后，创建一个名为FruitController的控制器类，用于处理HTTP请求和响应。//n//njava//nimport org.springframework.beans.factory.annotation.Autowired;//nimport org.springframework.web.bind.annotation.*;//n//nimport java.util.List;//n//n@RestController//n@RequestMapping(/'/fruits/')//npublic class FruitController {//n @Autowired//n private FruitRepository fruitRepository;//n//n @GetMapping(/'//')//n public List<Fruit> getAllFruits() {//n return fruitRepository.findAll();//n }//n//n @GetMapping(/'/{id}/')//n public Fruit getFruitById(@PathVariable Long id) {//n return fruitRepository.findById(id).orElse(null);//n }//n//n @PostMapping(/'//')//n public Fruit createFruit(@RequestBody Fruit fruit) {//n return fruitRepository.save(fruit);//n }//n//n @PutMapping(/'/{id}/')//n public Fruit updateFruit(@PathVariable Long id, @RequestBody Fruit updatedFruit) {//n Fruit fruit = fruitRepository.findById(id).orElse(null);//n if (fruit != null) {//n fruit.setName(updatedFruit.getName());//n fruit.setPrice(updatedFruit.getPrice());//n fruit.setQuantity(updatedFruit.getQuantity());//n return fruitRepository.save(fruit);//n }//n return null;//n }//n//n @DeleteMapping(/'/{id}/')//n public void deleteFruit(@PathVariable Long id) {//n fruitRepository.deleteById(id);//n }//n}//n//n//n最后，创建一个名为Application的主类，用于启动Spring Boot应用。//n//njava//nimport org.springframework.boot.SpringApplication;//nimport org.springframework.boot.autoconfigure.SpringBootApplication;//n//n@SpringBootApplication//npublic class Application {//n public static void main(String[] args) {//n SpringApplication.run(Application.class, args);//n }//n}//n//n//n以上是一个简单的Spring Boot水果表的代码项目示例。你可以根据自己的需求进行修改和扩展。记得在application.properties文件中配置数据库连接信息。//n/