Springboot获取前端反馈信息并存入数据库的实现代码

<!--mybatis-->

<dependency>

   <groupId>org.mybatis.spring.boot</groupId>

   <artifactId>mybatis-spring-boot-starter</artifactId>

   <version> 2.0 . 1 </version>

</dependency>

spring:

  datasource:

   driver- class -name: com.mysql.cj.jdbc.Driver

   url: jdbc:mysql: //localhost:3306/yanan_user #写自己的数据库名

   username: root

   password: 123456 #自己的账号密码

mybatis:

  type-aliases- package : com.wjr.pojo

  configuration:

   log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

<form>

   <input type= "text" name= "name" placeholder= "请输入您的姓名" required= "" >

   <input type= "email" name= "email" placeholder= "请输入您的邮箱" required= "" >

   <input type= "text" name= "telephone" placeholder= "请输入您的联系方式" required= "" >

   <textarea name= "message" placeholder= "请您提出您的宝贵建议，我们将认真阅读" required= "" ></textarea>

   <input class= "btn1" type= "button" value= "提交" onclick= "send(this.form)" >

</form>

<script>

     function send(fdform){

       alert(fdform);

       var fdj = {name:fdform.name.value,email:fdform.email.value,telephone:fdform.telephone.value,message:fdform.message.value};

       $.ajax({

         url: "jsonfb" ,

         data:fdj,

         contentType: "application/json" ,

         type: "GET"

       })

     }

</script>

@Data //这里导入了lombok依赖

@Table (name = "feedback" )

public class Feedback {

   @Id

   //主键回填

   @KeySql (useGeneratedKeys = true )

   private int id;

   private String name;

   private String email;

   private String telephone;

   private String message;

}

@Repository

public interface FeedbackMapper {

   @Insert ({ "insert into feedback(name,email,telephone,message) values('${feedback.name}','${feedback.email}','${feedback.telephone}','${feedback.message}')" })

   int add( @Param ( "feedback" ) Feedback feedback);

}

public interface FeedbackService {

   int addFeedback(String name, String email, String telephone,String message);

}

@Service

public class FeedbackServiceImpl implements FeedbackService{

   @Autowired

   private FeedbackMapper feedbackMapper;

   @Override

   public int addFeedback(String name, String email, String telephone,String message){

     Feedback fb = new Feedback();

     fb.setName(name);

     fb.setMessage(message);

     fb.setTelephone(telephone);

     fb.setEmail(email);

     return feedbackMapper.add(fb);

   }

}

@Autowired

   FeedbackServiceImpl feedbackServiceImpl;

   @RequestMapping (value = "/jsonfb" ) //和ajax请求中url相对应

   public String json(Feedback feedback){

     System.out.println(feedback);

     int f = feedbackServiceImpl.addFeedback(feedback.getName(), feedback.getEmail(), feedback.getTelephone(), feedback.getMessage());

     return "contact" ;

   }

<?xml version= "1.0" encoding= "UTF-8" ?>

<project xmlns= "http://maven.apache.org/POM/4.0.0" xmlns:xsi= "http://HdhCmsTestw3.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.4 . 3 </version>

     <relativePath/> <!-- lookup parent from repository -->

   </parent>

   <groupId>com.wjr</groupId>

   <artifactId>yanan</artifactId>

   <version> 0.0 . 1 -SNAPSHOT</version>

   <name>yanan</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-web</artifactId>

     </dependency>

     <dependency>

       <groupId>org.springframework.boot</groupId>

       <artifactId>spring-boot-starter-test</artifactId>

       <scope>test</scope>

     </dependency>

     <dependency>

       <groupId>com.alibaba</groupId>

       <artifactId>druid</artifactId>

       <version> 1.1 . 6 </version>

     </dependency>

     <dependency>

       <groupId>org.springframework.boot</groupId>

       <artifactId>spring-boot-configuration-processor</artifactId>

       <optional> true </optional>

     </dependency>

<!--    mybatis-->

     <dependency>

       <groupId>org.mybatis.spring.boot</groupId>

       <artifactId>mybatis-spring-boot-starter</artifactId>

       <version> 2.0 . 1 </version>

     </dependency>

     <dependency>

       <groupId>org.projectlombok</groupId>

       <artifactId>lombok</artifactId>

     </dependency>

     <dependency>

       <groupId>mysql</groupId>

       <artifactId>mysql-connector-java</artifactId>

       <version> 8.0 . 23 </version>

     </dependency>

     <dependency>

       <groupId>tk.mybatis</groupId>

       <artifactId>mapper-spring-boot-starter</artifactId>

       <version> 2.1 . 5 </version>

     </dependency>

     <dependency>

       <groupId>junit</groupId>

       <artifactId>junit</artifactId>

       <scope>test</scope>

     </dependency>

     <dependency>

       <groupId>org.springframework.boot</groupId>

       <artifactId>spring-boot-starter-thymeleaf</artifactId>

     </dependency>

   </dependencies>

   <build>

     <plugins>

       <plugin>

         <groupId>org.springframework.boot</groupId>

         <artifactId>spring-boot-maven-plugin</artifactId>

       </plugin>

       <plugin>

         <groupId>org.apache.maven.plugins</groupId>

         <artifactId>maven-resources-plugin</artifactId>

         <version> 2.4 . 3 </version>

       </plugin>

     </plugins>

   </build>

</project>