java 尝试从REST API返回对象列表时出错

cgfeq70w  于 2024-01-05  发布在  Java
关注(0)|答案(1)|浏览(265)

``我正在学习spring Boot ，并试图从我的API端点发送课程对象列表。但在检索课程对象列表的测试用例中，我得到以下错误：
第一个月
我的测试案例中，我得到了这个错误在 Postman 我收到的课程对象的列表。我填充数据库与以下data.sql文件
insert into course(id, name) values(99, 'DBMS');个
schema.sql DROP TABLE IF EXISTS课程;

  1. create table course (
  2.         id bigint not null,
  3.         name varchar(255) UNIQUE,
  4.         primary key (id)
  5.     );

个字符
所有其他测试用例都通过了，只有我提到的那个测试用例失败了。
testCase文件

  1. package com.jpa.hibernate.learnjpa;
  3. import org.junit.jupiter.api.Test;
  4. import org.springframework.beans.factory.annotation.Autowired;
  5. import org.springframework.boot.test.context.SpringBootTest;
  6. import org.springframework.boot.test.web.client.TestRestTemplate;
  7. import org.springframework.core.ParameterizedTypeReference;
  8. import org.springframework.http.HttpEntity;
  9. import org.springframework.http.HttpMethod;
  10. import org.springframework.http.HttpStatus;
  11. import org.springframework.http.ResponseEntity;
  12. import org.springframework.test.annotation.DirtiesContext;
  14. import com.jayway.jsonpath.DocumentContext;
  15. import com.jayway.jsonpath.JsonPath;
  16. import com.socgen.jpa.hibernate.learnjpa.entity.Course;
  17. import com.socgen.jpa.hibernate.learnjpa.repository.CourseRepository;
  19. import static org.assertj.core.api.Assertions.assertThat;
  21. import java.net.URI;
  22. import java.util.List;
  24. @SpringBootTest(webEnvironment = SpringBootTest.WebEnvironment.RANDOM_PORT)
  25. class LearnjpaApplicationTests {
  27.     @Autowired
  28.     TestRestTemplate restTemplate;
  29.     @Autowired
  30.     private CourseRepository courseRepository;
  32.     @Test
  33.     void ShouldReturnACourseOfGivenId() {
  34.         ResponseEntity<String> response = restTemplate.getForEntity("/course/99", String.class);
  35.         assertThat(response.getStatusCode()).isEqualTo(HttpStatus.OK);
  36.         DocumentContext documentContext = JsonPath.parse(response.getBody());
  37.         Number id = documentContext.read("$.id");
  38.         assertThat(id).isNotNull();
  39.         assertThat(id).isEqualTo(99);
  40.     }
  42.     @Test
  43.     void ShouldReturn404ForNonRegisteredIds() {
  44.         ResponseEntity<String> response = restTemplate.getForEntity("/course/1000", String.class);
  45.         assertThat(response.getStatusCode()).isEqualTo(HttpStatus.NOT_FOUND);
  46.     }
  48.     @Test
  49.     @DirtiesContext
  50.     void shouldReturnNoContentWhenDelete() {
  51.         ResponseEntity<Void> response = restTemplate.exchange("/course/99", HttpMethod.DELETE, null, Void.class);
  52.         assertThat(response.getStatusCode()).isEqualTo(HttpStatus.NO_CONTENT);
  53.     }
  55.     @Test
  56.     @DirtiesContext
  57.     void shouldReturnCreated() {
  58.         // creating the new course
  59.         Course course = new Course("CSE");
  60.         ResponseEntity<Void> response = restTemplate.postForEntity("/course/add", course, Void.class);
  61.         assertThat(response.getStatusCode()).isEqualTo(HttpStatus.CREATED);
  63.         // course was created
  64.         URI locationOfNewCourse = response.getHeaders().getLocation();
  65.         ResponseEntity<String> getResponse = restTemplate.getForEntity(locationOfNewCourse, String.class);
  66.         assertThat(getResponse.getStatusCode()).isEqualTo(HttpStatus.OK);
  68.         // making sure can't create duplicate course
  69.         ResponseEntity<Void> response2 = restTemplate.postForEntity("/course/add", course, Void.class);
  70.         assertThat(response2.getStatusCode()).isEqualTo(HttpStatus.BAD_REQUEST);
  71.     }
  73.     @Test
  74.     @DirtiesContext
  75.     void shouldUpdateAndReturnNewCourse() {
  76.         Course updatedCourse = new Course("NETWORKS");
  77.         updatedCourse.setId(99L);
  78.         HttpEntity<Course> requestObject = new HttpEntity<>(updatedCourse);
  79.         ResponseEntity<Course> updateResponse = restTemplate.exchange("/course/update/99", HttpMethod.PUT,
  80.                 requestObject, Course.class);
  81.         assertThat(updateResponse.getStatusCode()).isEqualTo(HttpStatus.CREATED);
  82.         assertThat(updateResponse.getBody()).isNotNull();
  83.         assertThat(updateResponse.getBody().getName()).isNotEqualTo("DBMS");
  84.         assertThat(updateResponse.getBody().getName()).isEqualTo("NETWORKS");
  85.     }
  87.     @Test
  88.     void shouldReturnAListOfAllCourses() {
  89.         // List<Course> result = courseRepository.findAllCoursesInTable();
  90.         // assertThat(result.size()).isEqualTo(2);
  91.         ResponseEntity<List<Course>> getResponse = restTemplate.exchange(
  92.                 "/all",
  93.                 HttpMethod.GET,
  94.                 null,
  95.                 new ParameterizedTypeReference<List<Course>>() {
  96.                 });
  98.         assertThat(getResponse.getStatusCode()).isEqualTo(HttpStatus.OK);
  99.         assertThat(getResponse.getBody()).isNotNull();
  100.         assertThat(getResponse.getBody().size()).isEqualTo(2); // Adjust the expected size as needed
  101.     }
  103. }

型
课程实体

  1. package com.jpa.hibernate.learnjpa.entity;
  3. import jakarta.persistence.Column;
  4. import jakarta.persistence.Entity;
  5. import jakarta.persistence.GeneratedValue;
  6. import jakarta.persistence.Id;
  7. import jakarta.persistence.Table;
  9. @Entity
  10. @Table(name = "course")
  11. public class Course {
  12.     @Id
  13.     @GeneratedValue
  14.     private Long id;
  15.     
  16.     @Column(unique = true)
  17.     private String name;
  19.     public Course(String name){
  20.         this.name = name;
  21.     }
  22.     
  23.     public Course(){
  25.     }
  27.     // getters and setters
  28.     public Long getId() {
  29.         return id;
  30.     }
  31.     public String getName() {
  32.         return name;
  33.     }
  34.     public void setId(Long id) {
  35.         this.id = id;
  36.     }
  37.     public void setName(String name) {
  38.         this.name = name;
  39.     }
  40.     @Override
  41.     public String toString() {
  42.         return name + " " + id;
  43.     }
  44. }

型
课程库

  1. package com.jpa.hibernate.learnjpa.repository;
  3. import org.springframework.stereotype.Repository;
  4. import org.springframework.data.jpa.repository.JpaRepository;
  5. import org.springframework.data.jpa.repository.Query;
  7. import com.socgen.jpa.hibernate.learnjpa.entity.Course;
  9. import java.util.List;
  10. import java.util.Optional;
  13. @Repository
  14. public interface CourseRepository extends JpaRepository<Course, Long> {
  15.     Optional<Course> findById(Long id);
  16.     void deleteById(Long id); //does nothing if ID not found
  17.     Optional<Course> findByName(String name);
  19.     @Query(value = "select * from course", nativeQuery = true)
  20.     List<Course> findAllCoursesInTable();
  22.     
  23. }

型
CourseController

  1. package com.jpa.hibernate.learnjpa.controller;
  3. import org.springframework.web.bind.annotation.RequestMapping;
  4. import org.springframework.web.bind.annotation.RestController;
  5. import org.springframework.web.util.UriComponentsBuilder;
  7. import com.socgen.jpa.hibernate.learnjpa.Services.CourseService;
  8. import com.socgen.jpa.hibernate.learnjpa.entity.Course;
  10. import java.net.URI;
  11. import java.util.List;
  13. import org.springframework.beans.factory.annotation.Autowired;
  14. import org.springframework.http.ResponseEntity;
  15. import org.springframework.web.bind.annotation.DeleteMapping;
  16. import org.springframework.web.bind.annotation.GetMapping;
  17. import org.springframework.web.bind.annotation.PathVariable;
  18. import org.springframework.web.bind.annotation.PostMapping;
  19. import org.springframework.web.bind.annotation.RequestBody;
  20. import org.springframework.web.bind.annotation.PutMapping;
  22. @RestController
  23. @RequestMapping("/course")
  24. public class CourseController {
  25.     @Autowired
  26.     private CourseService courseService;
  28.     @GetMapping("/{id}")
  29.     public ResponseEntity<Course> getCourseById(@PathVariable Long id) {
  30.         Course course = courseService.findById(id);
  31.         if(course == null){
  32.             return ResponseEntity.notFound().build();
  33.         }
  34.         return ResponseEntity.ok(course);
  35.     }
  37.     // getting all the courses 
  38.     @GetMapping("/all")
  39.     public ResponseEntity<List<Course>> getAllCourses() {
  40.         return ResponseEntity.ok().body(courseService.getAllCourses());
  41.     }
  42.     
  43.     @DeleteMapping("/{id}")
  44.     public ResponseEntity<Void> deleteCourseById(@PathVariable Long id){
  45.         if(courseService.deleteById(id)) return ResponseEntity.noContent().build();
  46.         return ResponseEntity.notFound().build();        
  47.     }
  48.     
  49.     @PostMapping("/add")
  50.     public ResponseEntity<Void> addCourse(@RequestBody Course course, UriComponentsBuilder ucb) {
  51.         Course newCourse = courseService.addNewCourse(course);
  52.         if(newCourse != null){
  53.             URI locationOfNewCourse = ucb.path("course/{id}").buildAndExpand(newCourse.getId()).toUri();
  54.             return ResponseEntity.created(locationOfNewCourse).build();
  55.         }
  56.         return ResponseEntity.badRequest().build();   
  57.     }
  58.     @PutMapping("update/{id}")
  59.     public ResponseEntity<Course> putMethodName(@PathVariable String id, @RequestBody Course course, UriComponentsBuilder ucb) {
  60.         Course updatedCourse = courseService.updateCourse(course);
  61.         return ResponseEntity.created(null).body(updatedCourse);
  62.     }
  63. }

型
课程服务

  1. package com.jpa.hibernate.learnjpa.Services;
  3. import java.util.List;
  4. import com.jpa.hibernate.learnjpa.entity.Course;
  6. public interface CourseService {
  7.     Course findById(Long id);
  8.     Boolean deleteById(Long id); //returns true if any object was deleted else returns false
  9.     Course addNewCourse(Course course);
  10.     Course updateCourse(Course course);
  11.     List<Course> getAllCourses();
  12. }

型
CourseServiceImpl

  1. package com.jpa.hibernate.learnjpa.Services;
  3. import java.util.List;
  4. import java.util.Optional;
  6. import org.slf4j.Logger;
  7. import org.slf4j.LoggerFactory;
  8. import org.springframework.beans.factory.annotation.Autowired;
  9. import org.springframework.stereotype.Service;
  11. import com.socgen.jpa.hibernate.learnjpa.entity.Course;
  12. import com.socgen.jpa.hibernate.learnjpa.repository.CourseRepository;
  14. @Service
  15. public class CourseServiceImp implements CourseService {
  16.    
  17.     Logger logger = LoggerFactory.getLogger(this.getClass());
  19.     @Autowired
  20.     CourseRepository courseRepository;
  22.     @Override
  23.     public Course findById(Long id) {
  24.         Optional<Course> course = courseRepository.findById(id);
  25.         logger.info(course.toString());
  26.         if(course.isPresent()) return course.get();
  27.         return null;
  28.     }
  30.     @Override
  31.     public Boolean deleteById(Long id) {
  32.         Optional<Course> course = courseRepository.findById(id);
  33.         if(!course.isPresent()) return false;
  34.         courseRepository.deleteById(id);
  35.         return true;
  36.     }
  38.     @Override
  39.     public Course addNewCourse(Course course) {
  40.         Optional<Course> courseExists = courseRepository.findByName(course.getName());
  41.         if(courseExists.isPresent()) return null;
  42.         Course newCourse = courseRepository.save(course);
  43.         return newCourse;
  44.     }
  46.     @Override
  47.     public Course updateCourse(Course course) {
  48.         Course updatedCourse = courseRepository.save(course);
  49.         return updatedCourse;
  50.     }
  52.     @Override
  53.     public List<Course> getAllCourses() {
  54.         return courseRepository.findAllCoursesInTable();
  55.     }
  57. }

型
pom.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="http://maven.apache.org/POM/4.0.0"
  3.     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.     xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  5.     <modelVersion>4.0.0</modelVersion>
  6.     <parent>
  7.         <groupId>org.springframework.boot</groupId>
  8.         <artifactId>spring-boot-starter-parent</artifactId>
  9.         <version>3.2.1</version>
  10.         <relativePath /> <!-- lookup parent from repository -->
  11.     </parent>
  12.     <groupId>com.socgen.jpa.hibernate</groupId>
  13.     <artifactId>learnjpa</artifactId>
  14.     <version>0.0.1-SNAPSHOT</version>
  15.     <name>learnjpa</name>
  16.     <description>Demo project for Spring Boot</description>
  17.     <properties>
  18.         <java.version>17</java.version>
  19.     </properties>
  20.     <dependencies>
  22.         <dependency>
  23.             <groupId>org.springframework.boot</groupId>
  24.             <artifactId>spring-boot-starter-actuator</artifactId>
  25.         </dependency>
  27.         <dependency>
  28.             <groupId>org.springframework.boot</groupId>
  29.             <artifactId>spring-boot-starter-data-jpa</artifactId>
  30.         </dependency>
  32.         <dependency> 
  33.             <groupId>org.springframework.boot</groupId> 
  34.             <artifactId>spring-boot-starter-data-jdbc</artifactId>
  35.         </dependency> 
  36.         
  37.         <dependency>
  38.             <groupId>org.springframework.boot</groupId>
  39.             <artifactId>spring-boot-starter-web</artifactId>
  40.         </dependency>
  42.         <dependency>
  43.             <groupId>org.springframework.boot</groupId>
  44.             <artifactId>spring-boot-devtools</artifactId>
  45.             <scope>runtime</scope>
  46.             <optional>true</optional>
  47.         </dependency>
  49.         <dependency>
  50.             <groupId>com.h2database</groupId>
  51.             <artifactId>h2</artifactId>
  52.             <scope>runtime</scope>
  53.         </dependency>
  54.         <dependency>
  55.             <groupId>org.springframework.boot</groupId>
  56.             <artifactId>spring-boot-starter-test</artifactId>
  57.             <scope>test</scope>
  58.         </dependency>
  60.         <dependency>
  61.             <groupId>com.fasterxml.jackson.core</groupId>
  62.             <artifactId>jackson-databind</artifactId>
  63.         </dependency>
  64.         
  65.     </dependencies>
  67.     <build>
  68.         <plugins>
  69.             <plugin>
  70.                 <groupId>org.springframework.boot</groupId>
  71.                 <artifactId>spring-boot-maven-plugin</artifactId>
  72.             </plugin>
  74.             <plugin>
  75.                 <groupId>org.apache.maven.plugins</groupId>
  76.                 <artifactId>maven-surefire-plugin</artifactId>
  77.                 <version>3.2.3</version>
  78.             </plugin>
  80.         </plugins>
  81.     </build>
  83. </project>

型
我不知道我做错了什么，因为当我尝试在postman中测试它时，端点工作。可能是测试用例的一些问题。

Java

1条答案

按热度按时间
6rvt4ljy

6rvt4ljy1#

您忘记了/course前缀，

  1. ResponseEntity<List<Course>> getResponse = restTemplate.exchange("/course/all", /* rest of params */);

字符串
哦，当测试控制器时，看看MockMvc。

赞(0）分享  回复(0）举报  2024-01-05
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com