java - 错误服务 Rest Spring Boot : java. util.NoSuchElementException:不存在值

Question

早上好，我在使用 spring boot 制作 REST web 服务时遇到问题，应用程序向我运行，但在呈现数据时它显示我好像该表不存在于数据库 ORACLE 中，我不知道如果是我在类的配置中遗漏了一些东西，我将继续附上我得到的答案:

当我咨询以获得所有客户时:

当我咨询以获得特定记录时:

我的代码

主类

package com.example.consulta;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class App {

    public static void main(String[] args) {
        SpringApplication.run(App.class, args);
    }
}

Controller

 package com.example.consulta.controller;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RestController;

import com.example.consulta.entity.Cliente;
import com.example.consulta.service.ClienteService;

@RestController
public class ClienteController {

    @Autowired
    private ClienteService  clienteService;

    @GetMapping("/allCliente")
    public List<Cliente> listarCliente(){
        return clienteService.findAll();
    }

    @GetMapping("/cliente/{cedula}")
    public Cliente detalleCliente(@PathVariable int cedula) {
        return  clienteService.findById(cedula);

    }

}

道

package com.example.consulta.DAO;
import org.springframework.data.repository.CrudRepository;

import com.example.consulta.entity.Cliente;

public interface ClienteDAO extends CrudRepository<Cliente, Integer>{
}

客户

package com.example.consulta.entity;

import javax.persistence.Entity;
import javax.persistence.Id;


@Entity
public class Cliente {

    @Id
    private int cedula;
    private String nombre;
    private String apellido;
    private String tipo_cliente;

    public int getCedula() {
        return cedula;
    }
    public void setCedula(int cedula) {
        this.cedula = cedula;
    }
    public String getNombre() {
        return nombre;
    }
    public void setNombre(String nombre) {
        this.nombre = nombre;
    }
    public String getApellido() {
        return apellido;
    }
    public void setApellido(String apellido) {
        this.apellido = apellido;
    }
    public String getTipo_cliente() {
        return tipo_cliente;
    }
    public void setTipo_cliente(String tipo_cliente) {
        this.tipo_cliente = tipo_cliente;
    }   

}

客户服务

package com.example.consulta.service;

import java.util.List;

import com.example.consulta.entity.Cliente;

public interface ClienteService {

    public List<Cliente> findAll();
    public Cliente findById(int cedula);

}

客户端服务实现

package com.example.consulta.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.example.consulta.DAO.ClienteDAO;
import com.example.consulta.entity.Cliente;

@Service

    public class ClienteServiceImpl implements ClienteService{

        @Autowired
        private ClienteDAO clienteDao;

        @Override
        @Transactional
        public List<Cliente> findAll() {
            return (List<Cliente>) clienteDao.findAll();
        }

        @Override
        public Cliente findById(int cedula) {
            return clienteDao.findById(cedula).get();
        }


    }

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.2.1.RELEASE</version>
    </parent>
    <groupId>com.example.consulta</groupId>
    <artifactId>ServiceConsultaCliente</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>ServiceConsultaCliente</name>
    <description>Demo project for Spring Boot</description>

    <properties>
        <java.version>1.8</java.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <!-- change it to oracle driver -->
        <dependency>
            <groupId>com.h2database</groupId>
            <artifactId>h2</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>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>
</project>

应用程序属性

spring.application.name=prueba-microservicio-cliente
spring.datasource.url=jdbc:oracle:thin:@//10.164.7.203:1521/ORCLPDB1.localdomain
spring.datasource.username=cesar
spring.datasource.password=xxxxx123
spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver
spring.jpa.hibernate.ddl-auto=update

附件证明我的表存在于用户 cesar 中，并且我可以使用 SQL Developer 进行连接:

创建表的SQL代码:

CREATE TABLE cliente(
        cedula NUMBER(10) NOT NULL,
        nombre varchar (15) NOT NULL,
        apellido varchar (15),
        tipo_cliente varchar(10) NOT NULL,
        PRIMARY KEY (cedula)
);

我是 spring boot 的新手，我正在测试用 docker 创建微服务，我必须将我的数据库放在一个容器中，我不知道它是否会影响

我的项目结构

Answer 1

我遇到了同样的错误，问题出在:

public Cliente findById(int cedula) {
        return clienteDao.findById(cedula).get();
}

我添加了这样的验证:

public Cliente findById(int cedula) {
        Optional<Cliente> client = clienteDao.findById(cedula);
        return client.isEmpty() ? null : client.get();
}

有了它，只有在找到客户时才调用 get() 函数。