如何使用Java SprinBoot CrudRepository在JSON列的MySQL中插入/更新行

<dependencies>
    <!-- Spring Data JPA -->
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-jpa</artifactId>
    </dependency>
    <!-- MySQL驱动 -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
    </dependency>
</dependencies>

@Entity
@Table(name = "your_table_name")
public class YourEntity {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Column(columnDefinition = "json")
    private String jsonData;

    // Getters and setters
}

public interface YourEntityRepository extends CrudRepository<YourEntity, Long> {
}

@Service
public class YourService {
    @Autowired
    private YourEntityRepository repository;

    public void saveOrUpdateData(YourEntity entity) {
        repository.save(entity);
    }
}

YourEntity entity = new YourEntity();
entity.setJsonData("{\"key\": \"value\"}");
yourService.saveOrUpdateData(entity);