SpringBoot中ORM组件通过JAP组件的使用

ORM开发规范能够有效的解耦合业务逻辑与数据库操作逻辑，降低维护项目代码的难度。
ORM规范封装于JAP组件，通过引入JpaRepository接口来实现。

一、创建项目，引入相关依赖。

运行环境：ideal、springboot 2.6.3、jdk1.8
为了适应本机环境，在创建项目的时候引入相关服务源进行降级
https://start.aliyun.com/

按照默认创建项目。
引入依赖

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>com.mysql</groupId>
            <artifactId>mysql-connector-j</artifactId>
            <version>8.0.32</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
            <version>2.6.13</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
    </dependencies>

本次测试项目结构

二、确认数据库结构，编写yml文件

spring:
  jpa:
    show-sql: true
    hibernate:
      ddl-auto: validate
  datasource:
    url: jdbc:mysql://localhost:3306/stock?useSSL=false&serverTimezone=UTC
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver

三、编写实体类

需要与数据库一致，需要主键

package com.test.model;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

/**
 * @Author:     沐槿
 * @Description:  业务实体类
 * 通过注解和Stock表数据关联
 * @Date:    2025/12/15 14:37
 * @Version:    1.0
 */
@Entity
@Table(name="Stock")
public class Stock {

    @Id//通过@Id定义主键
    private int id;

    @Column(name="name")
    private String name;

    @Column(name="num")
    private int num;

    @Column(name="description")
    private String description;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public int getNum() {
        return num;
    }

    public void setNum(int num) {
        this.num = num;
    }

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }
}

四、编写Repo类（或Dao类）实现JPA接口

package com.test.repo;

import com.test.model.Stock;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Component;
import java.util.List;

/**
 * @Author:     沐槿
 * @Description:  TODO  
 * @Date:    2025/12/15 14:38
 * @Version:    1.0
 */
// 用@Component注解放入Spring容器中
@Component
public interface StockRepo extends JpaRepository<Stock, Integer> {
    //JPA将根据这个方法自动拼接查询语句
    public List<Stock> findByName(String name);
    //删除库存信息
    @Override
    public void delete(Stock stock);

    @Override
    void deleteById(Integer id);

    //新增或更新库存
    @Override
    public Stock save(Stock stock);
}

五、编写控制器类与业务逻辑类

控制器类

package com.test.controller;
import com.test.model.Stock;
import com.test.service.StockService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;

/**
 * @Author:     沐槿
 * @Description:  TODO  
 * @Date:    2025/12/15 14:37
 * @Version:    1.0
 */
@RestController
public class Controller {
    @Autowired
    StockService stockService;

    @RequestMapping("/getStockByName/{name}")
    public List<Stock> getStockByName(@PathVariable("name") String name){
        return stockService.findByName(name);
    }

    @RequestMapping("/getAllStocks")
    public List<Stock> getAllStocks(){
        return stockService.getAllStock();
    }

    @RequestMapping("/deleteStock")
    public void deleteStock(){
        stockService.delete();
    }

    @RequestMapping("/deleteStockById()")
    public void deleteStockById(@PathVariable String ID){
        stockService.deleteStockById(Integer.valueOf(ID));
    }
    //
    @RequestMapping ("/insertStock")
    public Stock insertStock(){
        return stockService.insertStock();
    }
    //修改库存信息
    @RequestMapping("/updateStock")
    Stock UpdateStock(){
        return stockService.updateStock();
    }
}

业务逻辑类

package com.test.service;
import com.test.model.Stock;
import com.test.repo.StockRepo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;

/**
 * @Author:     沐槿
 * @Description:  TODO  
 * @Date:    2025/12/15 14:38
 * @Version:    1.0
 */
@Service
public class StockService {
    @Autowired
    StockRepo stockRepo;

    public List<Stock> findByName(String name) {
        return stockRepo.findByName(name);
    }

    public List<Stock> getAllStock() {
        return stockRepo.findAll();
    }

    public void delete() {
        Stock delStock=stockRepo.getOne(10);
        stockRepo.delete(delStock);
    }

    public void deleteStockById(Integer integer) {
        stockRepo.deleteById(integer);
    }

    public Stock insertStock() {
        Stock stock=new Stock();
        stock.setId(10);
        stock.setName("test");
        stock.setDescription("test");
        return stockRepo.save(stock);
    }

    public Stock updateStock() {
        Stock stock = stockRepo.getOne(10);
        stock.setNum(50);
        return stockRepo.save(stock);
    }
}

六、启动服务，测试性能

URL请求
http://localhost:8080/控制器类的请求地址以及相关数据
例如：
URL请求
http://localhost:8080/getStockByName/computer
运行结果
[{“id”:1,“name”:“computer”,“num”:10,“description”:“Good”}]