導入mybatis依賴
|
1
2
3
4
5
6
|
<!--mybatis--><dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>2.0.1</version></dependency> |
yml實現mybatis依賴
|
1
2
3
4
5
6
7
8
9
10
|
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 |
編寫前端代碼
自行導入jQuery包，并調用
（form表單）
|
1
2
3
4
5
6
7
|
<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> |
（ajax請求）
|
1
2
3
4
5
6
7
8
9
10
11
12
|
<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> |
編寫數據庫信息
|
1
2
3
4
5
6
7
8
9
10
11
12
|
@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;} |
編寫insert方法（mapper層接口）
|
1
2
3
4
5
|
@Repositorypublic 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);} |
編寫接口（service層）
|
1
2
3
|
public interface FeedbackService { int addFeedback(String name, String email, String telephone,String message);} |
編寫接口實現（serviceImpl層）
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
@Servicepublic 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); }} |
接收信息并存入數據庫（controller層）
|
1
2
3
4
5
6
7
8
|
@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"; } |
pom.xml完整依賴
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
|
<?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.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> |
注：一個簡單的實現獲取前端反饋信息存入數據庫操作，自行嘗試，如果有報錯，請看注解是否正確，還可能存在各種版本問題；
到此這篇關于Springboot獲取前端反饋信息并存入數據庫的實現代碼的文章就介紹到這了,更多相關Springboot數據庫內容請搜索服務器之家以前的文章或繼續瀏覽下面的相關文章希望大家以后多多支持服務器之家！
原文鏈接：https://blog.csdn.net/weixin_46046339/article/details/115285160
