Spring-Boot框架后端部分查询所有电影信息并以json形式回传------Spring-Boot框架

短命女 2024-02-26 06:23 9阅读 0赞

>     CREATE DATABASE SpringBootVue;
>     USE SpringBootVue;
>     CREATE TABLE t_movie(id BIGINT PRIMARY KEY AUTO_INCREMENT,title VARCHAR(255),rating DOUBLE);
>     INSERT INTO t_movie(id,title,rating) VALUES(NULL,"金刚狼",8.7);
>     INSERT INTO t_movie(id,title,rating) VALUES(NULL,"变形金刚",8.6)
>     INSERT INTO t_movie(id,title,rating) VALUES(NULL,"蜘蛛侠",8.7)
>     SELECT * FROM t_movie
> 
> CREATE DATABASE SpringBootVue;  
> USE SpringBootVue;  
> CREATE TABLE t\_movie(id BIGINT PRIMARY KEY AUTO\_INCREMENT,title VARCHAR(255),rating DOUBLE);  
> INSERT INTO t\_movie(id,title,rating) VALUES(NULL,"金刚狼",8.7);  
> INSERT INTO t\_movie(id,title,rating) VALUES(NULL,"变形金刚",8.6)  
> INSERT INTO t\_movie(id,title,rating) VALUES(NULL,"蜘蛛侠",8.7)  
> SELECT \* FROM t\_movie

>     package com.example.springbootvue.POJO;
>     
>     import com.baomidou.mybatisplus.annotation.IdType;
>     import com.baomidou.mybatisplus.annotation.TableId;
>     import com.baomidou.mybatisplus.annotation.TableName;
>     
>     @TableName("t_movie")
>     public class Movie
>     {
>         @TableId(type = IdType.AUTO)
>         private Integer id;
>         private String title;
>         private Double rating;
>     
>         @Override
>         public String toString() {
>             return "Movie{" +
>                     "id=" + id +
>                     ", title='" + title + '\'' +
>                     ", rating=" + rating +
>                     '}';
>         }
>     
>         public Integer getId() {
>             return id;
>         }
>     
>         public void setId(Integer id) {
>             this.id = id;
>         }
>     
>         public String getTitle() {
>             return title;
>         }
>     
>         public void setTitle(String title) {
>             this.title = title;
>         }
>     
>         public Double getRating() {
>             return rating;
>         }
>     
>         public void setRating(Double rating) {
>             this.rating = rating;
>         }
>     
>         public Movie() {
>         }
>     
>         public Movie(Integer id, String title, Double rating) {
>             this.id = id;
>             this.title = title;
>             this.rating = rating;
>         }
>     }
> 
>     package com.example.springbootvue.POJO;
>     
>     import com.baomidou.mybatisplus.annotation.IdType;
>     import com.baomidou.mybatisplus.annotation.TableId;
>     import com.baomidou.mybatisplus.annotation.TableName;
>     
>     @TableName("t_movie")
>     public class Movie
>     {
>         @TableId(type = IdType.AUTO)
>         private Integer id;
>         private String title;
>         private Double rating;
>     
>         @Override
>         public String toString() {
>             return "Movie{" +
>                     "id=" + id +
>                     ", title='" + title + '\'' +
>                     ", rating=" + rating +
>                     '}';
>         }
>     
>         public Integer getId() {
>             return id;
>         }
>     
>         public void setId(Integer id) {
>             this.id = id;
>         }
>     
>         public String getTitle() {
>             return title;
>         }
>     
>         public void setTitle(String title) {
>             this.title = title;
>         }
>     
>         public Double getRating() {
>             return rating;
>         }
>     
>         public void setRating(Double rating) {
>             this.rating = rating;
>         }
>     
>         public Movie() {
>         }
>     
>         public Movie(Integer id, String title, Double rating) {
>             this.id = id;
>             this.title = title;
>             this.rating = rating;
>         }
>     }

>     package com.example.springbootvue.Mapper;
>     
>     import com.baomidou.mybatisplus.core.mapper.BaseMapper;
>     import com.example.springbootvue.POJO.Movie;
>     import org.mapstruct.Mapper;
>     
>     @Mapper
>     public interface MovieMapper extends BaseMapper<Movie>
>     {
>     
>     }
> 
>     package com.example.springbootvue.Mapper;
>     
>     import com.baomidou.mybatisplus.core.mapper.BaseMapper;
>     import com.example.springbootvue.POJO.Movie;
>     import org.mapstruct.Mapper;
>     
>     @Mapper
>     public interface MovieMapper extends BaseMapper<Movie>
>     {
>     
>     }

>     package com.example.springbootvue.Controller;
>     
>     import com.example.springbootvue.Mapper.MovieMapper;
>     import com.example.springbootvue.POJO.Movie;
>     import org.springframework.beans.factory.annotation.Autowired;
>     import org.springframework.web.bind.annotation.GetMapping;
>     import org.springframework.web.bind.annotation.RestController;
>     
>     import java.util.List;
>     
>     @RestController
>     public class MovieController
>     {
>         @Autowired
>         private MovieMapper MovieMapper;
>     
>         @GetMapping("/Movie/find")
>         public List<Movie> find()
>         {
>             return MovieMapper.selectList(null);
>         }
>     }
> 
>     package com.example.springbootvue.Controller;
>     
>     import com.example.springbootvue.Mapper.MovieMapper;
>     import com.example.springbootvue.POJO.Movie;
>     import org.springframework.beans.factory.annotation.Autowired;
>     import org.springframework.web.bind.annotation.GetMapping;
>     import org.springframework.web.bind.annotation.RestController;
>     
>     import java.util.List;
>     
>     @RestController
>     public class MovieController
>     {
>         @Autowired
>         private MovieMapper MovieMapper;
>     
>         @GetMapping("/Movie/find")
>         public List<Movie> find()
>         {
>             return MovieMapper.selectList(null);
>         }
>     }

>     spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
>     spring.servlet.multipart.max-file-size=10MB
>     spring.servlet.multipart.max-request-size=10MB
>     spring.web.resources.static-locations=/upload/
>     spring.mvc.pathmatch.matching-strategy=ant\_path\_matcher
>     spring.datasource.driver-class-name=com.mysql.jdbc.Driver
>     spring.datasource.url=jdbc:mysql://localhost:13306/SpringBootVue?useSSL=false
>     spring.datasource.username=root
>     spring.datasource.password=abc123
>     mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
>     server.port=8088
> 
>     spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
>     spring.servlet.multipart.max-file-size=10MB
>     spring.servlet.multipart.max-request-size=10MB
>     spring.web.resources.static-locations=/upload/
>     spring.mvc.pathmatch.matching-strategy=ant\_path\_matcher
>     spring.datasource.driver-class-name=com.mysql.jdbc.Driver
>     spring.datasource.url=jdbc:mysql://localhost:13306/SpringBootVue?useSSL=false
>     spring.datasource.username=root
>     spring.datasource.password=abc123
>     mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
>     server.port=8088

>     package com.example.springbootvue;
>     
>     import org.mybatis.spring.annotation.MapperScan;
>     import org.springframework.boot.SpringApplication;
>     import org.springframework.boot.autoconfigure.SpringBootApplication;
>     
>     @SpringBootApplication
>     @MapperScan(value = "com.example.springbootvue.Mapper")
>     public class SpringBootVueApplication {
>     
>         public static void main(String[] args) {
>             SpringApplication.run(SpringBootVueApplication.class, args);
>         }
>     }