我是spring新手，在通过spring-data-jpa连接springboot和mysql-db时遇到了这个问题

Question

我在邮递员中到达终点时得到了这个错误

@Entity
public class Products {
    @Id
    private String productId;
    private String productName;
    private double price;
    private String ownerId;
    private String imageURL;
    private String inStock;
}
//with getter setter and constructors

package com.akilan.juztradeapi.service;
import com.akilan.juztradeapi.entity.Products;
import com.akilan.juztradeapi.repo.ProductsRepo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class ProductsServiceImpl implements ProductsService {
   @Autowired
    private ProductsRepo productsRepo;

    @Override
    public List<Products> findAllProducts() {
        return productsRepo.findAll();
    }

    @Override
    public void createDepartment(Products products) {
        productsRepo.save(products);
    }
}

ProductsRepo

package com.akilan.juztradeapi.repo;

import com.akilan.juztradeapi.entity.Products;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

@Repository
public interface ProductsRepo extends JpaRepository<Products,String> {
}

Application.Properties

spring.datasource.username = root
spring.datasource.password = root
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.jpa.properties.hibernate.format_sql = true

Answer 1

谢谢您的帮助，问题是我错过了这个属性，这个属性是以自体方式创建表所必需的。

spring.jpa.hibernate.ddl-auto=update

Application.Properties

spring.datasource.url=jdbc:mysql://localhost:3306/tab
spring.datasource.username = root
spring.datasource.password = root
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.jpa.database-platform=org.hibernate.dialect.MySQL5InnoDBDialect
spring.jpa.hibernate.ddl-auto=update