早上好，我在使用 Spring Boot 制作 REST Web 服务时遇到问题，应用程序向我运行，但是在呈现数据时，它向我显示好像该表不存在于数据库 ORACLE 中，我不知道它是否存在我在类的配置中遗漏了一些东西，我附上我得到的答案的延续：
When I consult to get all the clients:
当我查询以获得特定记录时：
My Code
主班
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);
}
}
控制器
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);
}
}
DAO
package com.example.consulta.DAO;
import org.springframework.data.repository.CrudRepository;
import com.example.consulta.entity.Cliente;
public interface ClienteDAO extends CrudRepository<Cliente, Integer>{
}
Cliente
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 创建微服务，我必须将数据库放在容器中，我不知道这是否会影响
我的项目的结构
我遇到了同样的错误，问题出在：
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();
}
有了它，只有在找到 Client 时才调用 get() 函数。