Error creating bean with name 'orderController'-CodePudding

I am studying Spring Boot and I want to create a Rest Controller, and using a sql database, but there is a problem when I start the project :

Error: (the error text is great I will leave the link)

And code:

OrderController.java

package ***;


import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;
import java.util.Map;
import java.util.Optional;

@RestController
public class OrderController {

    @Autowired
    private  OrderRepository orderRep;

    @GetMapping("/")
    public List<Order> index(){
        return (List<Order>) orderRep.findAll();
    }

    @GetMapping("/{id}")
    public Order show(@PathVariable int id){
        Optional<Order> orderId= orderRep.findById(id);
        Order order = orderId.get();
        return order;
    }

    @PostMapping("/search")
    public List<Order> search(@RequestBody Map<String, String> body){
        String searchItem = body.get("item");
        return orderRep.findByTitleContainingOrContentContaining(searchItem);
    }

    @PostMapping("/")
    public Order create(@RequestBody Map<String, String> body){
        String item = body.get("item");
        int price = Integer.parseInt(body.get("price"));
        int quantity = Integer.parseInt(body.get("quantity"));

        return orderRep.save(new Order(item, price,quantity));
    }

    @PutMapping("/{id}")
    public Order update(@PathVariable String id, @RequestBody Map<String, String> body){
        int orderId = Integer.parseInt(id);
        // getting blog
        Optional<Order> order = orderRep.findById(orderId);
        order.get().setItem(body.get("item"));
        order.get().setPrice(Integer.parseInt(body.get("price")));
        order.get().setQuantity(Integer.parseInt("quantity"));
        return orderRep.save(order.get());


    }

    @DeleteMapping("/{id}")
    public boolean delete(@PathVariable int id){
        //int orderId = Integer.parseInt(id);
        orderRep.deleteById(id);
        return true;
    }


}

Order.java

package ***;

import javax.persistence.*;

@Entity
@Table(name = "orders")
public class Order {

    //Fields
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private int id;
    @Column(name = "item")
    private String item;
    @Column(name = "price")
    private int price;
    @Column(name = "quantity")
    private int quantity;


    //Constructors
    public Order() {  }

    public Order(String item, int price, int quantity) {
        this.setItem(item);
        this.setPrice(price);
        this.setQuantity(quantity);
    }

    public Order(int id, String item, int price, int quantity) {
        this.setId(id);
        this.setItem(item);
        this.setPrice(price);
        this.setQuantity(quantity);
    }


    //Object to string data
    @Override
    public String toString() {
        return "Order{"  
                "id="   getId()  
                ", item='"   getItem()   '\''  
                ", price='"   getPrice()   '\''  
                ", price='"   getQuantity()   '\''  
                '}';
    }


    //Getters & Setters
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getItem() {
        return item;
    }
    public void setItem(String item) {
        this.item = item;
    }
    public int getPrice() {
        return price;
    }
    public void setPrice(int price) {
        this.price = price;
    }
    public int getQuantity() {
        return quantity;
    }
    public void setQuantity(int quantity) {
        this.quantity = quantity;
    }

}

OrderRepository.java

package ***;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.repository.CrudRepository;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface OrderRepository extends CrudRepository<Order, Integer> {

    // custom query to search to blog post by title or content
    List<Order> findByTitleContainingOrContentContaining(String item);

}

application.properties

spring.jpa.hibernate.ddl-auto=update
spring.datasource.url=jdbc:mysql://${MYSQL_HOST:localhost}:3306/testvoy?useUnicode=true&serverTimezone=UTC&useSSL=true&verifyServerCertificate=false
spring.datasource.username=root
spring.datasource.password=
spring.datasource.driver-class-name =com.mysql.jdbc.Driver
#spring.jpa.show-sql: true

pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.5.5</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.test</groupId>
    <artifactId>project</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>project</name>
    <description>project</description>
    <properties>
        <java.version>11</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <scope>runtime</scope>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.restdocs</groupId>
            <artifactId>spring-restdocs-mockmvc</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.asciidoctor</groupId>
                <artifactId>asciidoctor-maven-plugin</artifactId>
                <version>1.5.8</version>
                <executions>
                    <execution>
                        <id>generate-docs</id>
                        <phase>prepare-package</phase>
                        <goals>
                            <goal>process-asciidoc</goal>
                        </goals>
                        <configuration>
                            <backend>html</backend>
                            <doctype>book</doctype>
                        </configuration>
                    </execution>
                </executions>
                <dependencies>
                    <dependency>
                        <groupId>org.springframework.restdocs</groupId>
                        <artifactId>spring-restdocs-asciidoctor</artifactId>
                        <version>${spring-restdocs.version}</version>
                    </dependency>
                </dependencies>
            </plugin>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

I would be grateful for any help, thanks in advance

CodePudding user response：

If you check the error, you can see that it comes from there:

List<Order> findByTitleContainingOrContentContaining(String item);

and if you read more closely to the error, you will see:

No property title found for type Order!;

inside here:

Caused by: org.springframework.data.repository.query.QueryCreationException: Could not create query for public abstract java.util.List com.test.project.OrderRepository.findByTitleContainingOrContentContaining(java.lang.String)! Reason: Failed to create query for method public abstract java.util.List com.test.project.OrderRepository.findByTitleContainingOrContentContaining(java.lang.String)! No property title found for type Order!; nested exception is java.lang.IllegalArgumentException: Failed to create query for method public abstract java.util.List com.test.project.OrderRepository.findByTitleContainingOrContentContaining(java.lang.String)! No property title found for type Order!

Infact, if you check your model, there is no title property