Spring-Boot框架使用Mybatis来实现增删改查------Spring-Boot框架

╰+攻爆jí腚メ 2024-02-28 00:44 19阅读 0赞

>     package com.powernode.springbootvue.controller;
>     
>     import com.powernode.springbootvue.Mapper.StudentMapper;
>     import com.powernode.springbootvue.entity.Student;
>     import org.springframework.beans.factory.annotation.Autowired;
>     import org.springframework.web.bind.annotation.GetMapping;
>     import org.springframework.web.bind.annotation.PostMapping;
>     import org.springframework.web.bind.annotation.RestController;
>     
>     import java.util.List;
>     
>     @RestController
>     public class StudentController
>     {
>         @Autowired
>         private StudentMapper studentMapper;
>         @GetMapping("/student")
>         public List<Student> getAllStudents()
>         {
>             return studentMapper.selectAll();
>         }
>         @PostMapping("/addStudent")
>         public String saveStudent(Student student)
>         {
>             System.out.println("我在这");
>             int i = studentMapper.insertStudent(student);
>             if(i > 0)
>             {
>                 return "插入成功";
>             }
>             else
>             {
>                 return "插入失败";
>             }
>         }
>     }
> 
>     package com.powernode.springbootvue.controller;
>     
>     import com.powernode.springbootvue.Mapper.StudentMapper;
>     import com.powernode.springbootvue.entity.Student;
>     import org.springframework.beans.factory.annotation.Autowired;
>     import org.springframework.web.bind.annotation.GetMapping;
>     import org.springframework.web.bind.annotation.PostMapping;
>     import org.springframework.web.bind.annotation.RestController;
>     
>     import java.util.List;
>     
>     @RestController
>     public class StudentController
>     {
>         @Autowired
>         private StudentMapper studentMapper;
>         @GetMapping("/student")
>         public List<Student> getAllStudents()
>         {
>             return studentMapper.selectAll();
>         }
>         @PostMapping("/addStudent")
>         public String saveStudent(Student student)
>         {
>             System.out.println("我在这");
>             int i = studentMapper.insertStudent(student);
>             if(i > 0)
>             {
>                 return "插入成功";
>             }
>             else
>             {
>                 return "插入失败";
>             }
>         }
>     }

>     package com.powernode.springbootvue.Mapper;
>     
>     import com.powernode.springbootvue.entity.Student;
>     import org.apache.ibatis.annotations.Insert;
>     import org.apache.ibatis.annotations.Mapper;
>     import org.apache.ibatis.annotations.Select;
>     
>     import java.util.List;
>     @Mapper
>     public interface StudentMapper
>     {
>         @Select("select * from t_student")
>         List<Student> selectAll();
>         @Insert("insert into t_student values(#{id},#{name},#{age},#{height},#{birth},#{sex})")
>         int insertStudent(Student student);
>     }
> 
>     package com.powernode.springbootvue.Mapper;
>     
>     import com.powernode.springbootvue.entity.Student;
>     import org.apache.ibatis.annotations.Insert;
>     import org.apache.ibatis.annotations.Mapper;
>     import org.apache.ibatis.annotations.Select;
>     
>     import java.util.List;
>     @Mapper
>     public interface StudentMapper
>     {
>         @Select("select * from t_student")
>         List<Student> selectAll();
>         @Insert("insert into t_student values(#{id},#{name},#{age},#{height},#{birth},#{sex})")
>         int insertStudent(Student student);
>     }

>     package com.powernode.springbootvue.entity;
>     
>     public class Student
>     {
>         private Long id;
>         private String name;
>         private int age;
>         private double height;
>         private String birth;
>         private char sex;
>     
>         @Override
>         public String toString() {
>             return "Student{" +
>                     "id=" + id +
>                     ", name='" + name + '\'' +
>                     ", age=" + age +
>                     ", height=" + height +
>                     ", birthday=" + birth +
>                     ", sex=" + sex +
>                     '}';
>         }
>     
>         public Long getId() {
>             return id;
>         }
>     
>         public void setId(Long id) {
>             this.id = id;
>         }
>     
>         public String getName() {
>             return name;
>         }
>     
>         public void setName(String name) {
>             this.name = name;
>         }
>     
>         public int getAge() {
>             return age;
>         }
>     
>         public void setAge(int age) {
>             this.age = age;
>         }
>     
>         public double getHeight() {
>             return height;
>         }
>     
>         public void setHeight(double height) {
>             this.height = height;
>         }
>     
>         public String getBirth() {
>             return birth;
>         }
>     
>         public void setBirth(String birth) {
>             this.birth = birth;
>         }
>     
>         public char getSex() {
>             return sex;
>         }
>     
>         public void setSex(char sex) {
>             this.sex = sex;
>         }
>     
>         public Student() {
>         }
>     
>         public Student(Long id, String name, int age, double height, String birth, char sex) {
>             this.id = id;
>             this.name = name;
>             this.age = age;
>             this.height = height;
>             this.birth = birth;
>             this.sex = sex;
>         }
>     }
> 
>     package com.powernode.springbootvue.entity;
>     
>     public class Student
>     {
>         private Long id;
>         private String name;
>         private int age;
>         private double height;
>         private String birth;
>         private char sex;
>     
>         @Override
>         public String toString() {
>             return "Student{" +
>                     "id=" + id +
>                     ", name='" + name + '\'' +
>                     ", age=" + age +
>                     ", height=" + height +
>                     ", birthday=" + birth +
>                     ", sex=" + sex +
>                     '}';
>         }
>     
>         public Long getId() {
>             return id;
>         }
>     
>         public void setId(Long id) {
>             this.id = id;
>         }
>     
>         public String getName() {
>             return name;
>         }
>     
>         public void setName(String name) {
>             this.name = name;
>         }
>     
>         public int getAge() {
>             return age;
>         }
>     
>         public void setAge(int age) {
>             this.age = age;
>         }
>     
>         public double getHeight() {
>             return height;
>         }
>     
>         public void setHeight(double height) {
>             this.height = height;
>         }
>     
>         public String getBirth() {
>             return birth;
>         }
>     
>         public void setBirth(String birth) {
>             this.birth = birth;
>         }
>     
>         public char getSex() {
>             return sex;
>         }
>     
>         public void setSex(char sex) {
>             this.sex = sex;
>         }
>     
>         public Student() {
>         }
>     
>         public Student(Long id, String name, int age, double height, String birth, char sex) {
>             this.id = id;
>             this.name = name;
>             this.age = age;
>             this.height = height;
>             this.birth = birth;
>             this.sex = sex;
>         }
>     }

>     <?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.7.8</version>
>             <relativePath/> 
>         </parent>
>         <groupId>com.powernode</groupId>
>         <artifactId>SpringBootVue</artifactId>
>         <version>0.0.1-SNAPSHOT</version>
>         <name>SpringBootVue</name>
>         <description>SpringBootVue</description>
>         <properties>
>             <java.version>17</java.version>
>         </properties>
>         <dependencies>
>             <dependency>
>                 <groupId>org.springframework.boot</groupId>
>                 <artifactId>spring-boot-starter-web</artifactId>
>             </dependency>
>             <dependency>
>                 <groupId>org.springframework.boot</groupId>
>                 <artifactId>spring-boot-starter-test</artifactId>
>                 <scope>test</scope>
>             </dependency>
>     
>             <dependency>
>                 <groupId>io.springfox</groupId>
>                 <artifactId>springfox-swagger2</artifactId>
>                 <version>2.9.2</version>
>             </dependency>
>             <dependency>
>                 <groupId>io.springfox</groupId>
>                 <artifactId>springfox-swagger-ui</artifactId>
>                 <version>2.9.2</version>
>             </dependency>
>             <dependency>
>                 <groupId>com.baomidou</groupId>
>                 <artifactId>mybatis-plus-boot-starter</artifactId>
>                 <version>3.5.3.1</version>
>             </dependency>
>             <dependency>
>                 <groupId>mysql</groupId>
>                 <artifactId>mysql-connector-java</artifactId>
>                 <version>8.0.33</version>
>             </dependency>
>             <dependency>
>                 <groupId>com.alibaba</groupId>
>                 <artifactId>druid-spring-boot-starter</artifactId>
>                 <version>1.2.16</version>
>             </dependency>
>         </dependencies>
>     
>         <build>
>             <plugins>
>                 <plugin>
>                     <groupId>org.springframework.boot</groupId>
>                     <artifactId>spring-boot-maven-plugin</artifactId>
>                 </plugin>
>             </plugins>
>         </build>
>     
>     </project>
> 
>     <?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.7.8</version>
>             <relativePath/> 
>         </parent>
>         <groupId>com.powernode</groupId>
>         <artifactId>SpringBootVue</artifactId>
>         <version>0.0.1-SNAPSHOT</version>
>         <name>SpringBootVue</name>
>         <description>SpringBootVue</description>
>         <properties>
>             <java.version>17</java.version>
>         </properties>
>         <dependencies>
>             <dependency>
>                 <groupId>org.springframework.boot</groupId>
>                 <artifactId>spring-boot-starter-web</artifactId>
>             </dependency>
>             <dependency>
>                 <groupId>org.springframework.boot</groupId>
>                 <artifactId>spring-boot-starter-test</artifactId>
>                 <scope>test</scope>
>             </dependency>
>     
>             <dependency>
>                 <groupId>io.springfox</groupId>
>                 <artifactId>springfox-swagger2</artifactId>
>                 <version>2.9.2</version>
>             </dependency>
>             <dependency>
>                 <groupId>io.springfox</groupId>
>                 <artifactId>springfox-swagger-ui</artifactId>
>                 <version>2.9.2</version>
>             </dependency>
>             <dependency>
>                 <groupId>com.baomidou</groupId>
>                 <artifactId>mybatis-plus-boot-starter</artifactId>
>                 <version>3.5.3.1</version>
>             </dependency>
>             <dependency>
>                 <groupId>mysql</groupId>
>                 <artifactId>mysql-connector-java</artifactId>
>                 <version>8.0.33</version>
>             </dependency>
>             <dependency>
>                 <groupId>com.alibaba</groupId>
>                 <artifactId>druid-spring-boot-starter</artifactId>
>                 <version>1.2.16</version>
>             </dependency>
>         </dependencies>
>     
>         <build>
>             <plugins>
>                 <plugin>
>                     <groupId>org.springframework.boot</groupId>
>                     <artifactId>spring-boot-maven-plugin</artifactId>
>                 </plugin>
>             </plugins>
>         </build>
>     
>     </project>

>     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.type=com.alibaba.druid.pool.DruidDataSource
>     spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
>     spring.datasource.url=jdbc:mysql://localhost:13306/powernode?useSSL=false
>     spring.datasource.username=root
>     spring.datasource.password=abc123
>     mybatis-plus.connfiguration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
> 
>     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.type=com.alibaba.druid.pool.DruidDataSource
>     spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
>     spring.datasource.url=jdbc:mysql://localhost:13306/powernode?useSSL=false
>     spring.datasource.username=root
>     spring.datasource.password=abc123
>     mybatis-plus.connfiguration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

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