一、搭建springboot項(xiàng)目
1.1、file ——> new ——> project——> spring initializr——> next——> next——> next——> finish
注意選擇包依賴關(guān)系
二、springboot整合mybatis.mysql
2.1、整體結(jié)構(gòu)
2.2、設(shè)置所需要的依賴
即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
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
|
<?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.2</version> <relativepath/> <!-- lookup parent from repository --> </parent> <groupid>springboot-web04</groupid> <artifactid>demo</artifactid> <version>0.0.1-snapshot</version> <name>demo</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-data-jdbc</artifactid> </dependency> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-jdbc</artifactid> </dependency> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-thymeleaf</artifactid> </dependency> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-web</artifactid> </dependency> <dependency> <groupid>mysql</groupid> <artifactid>mysql-connector-java</artifactid> <scope>runtime</scope> </dependency> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-test</artifactid> <scope>test</scope> </dependency><!--下面的都是我加的--> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-jdbc</artifactid> </dependency> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-thymeleaf</artifactid> </dependency> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-web</artifactid> </dependency> <dependency> <groupid>org.mybatis.spring.boot</groupid> <artifactid>mybatis-spring-boot-starter</artifactid> <version>2.1.3</version> </dependency> <dependency> <groupid>mysql</groupid> <artifactid>mysql-connector-java</artifactid> </dependency> <dependency> <groupid>org.projectlombok</groupid> <artifactid>lombok</artifactid> <version>1.18.12</version> <scope>provided</scope> </dependency> <dependency> <groupid>com.alibaba</groupid> <artifactid>druid</artifactid> <version>1.2.1</version> </dependency> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-test</artifactid> <scope>test</scope> <exclusions> <exclusion> <groupid>org.junit.vintage</groupid> <artifactid>junit-vintage-engine</artifactid> </exclusion> </exclusions> </dependency> <dependency> <groupid>org.xmlunit</groupid> <artifactid>xmlunit-core</artifactid> </dependency> <dependency> <groupid>org.mybatis</groupid> <artifactid>mybatis</artifactid> <version>3.4.6</version> </dependency> </dependencies> <build> <plugins> <plugin> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-maven-plugin</artifactid> </plugin> </plugins> </build></project> |
2.3、設(shè)置application.yml文件與pplication.properties文件
在resources目錄下新建yml文件，用于存放數(shù)據(jù)庫(kù)連接需要的一些數(shù)據(jù)
|
1
2
3
4
5
6
|
spring: datasource: driver-class-name: com.mysql.cj.jdbc.driver url: jdbc:mysql://localhost:3306/mybatis?servertimezone=gmt%2b8&usessl=true username: root //數(shù)據(jù)庫(kù) password: sm1208 //密碼 |
在application.properties文件中加入
|
1
2
3
4
5
6
7
8
|
#端口號(hào)server.port=8080#druid數(shù)據(jù)庫(kù)連接池type=com.alibaba.druid.pool.druiddatasource#清除緩存spring.thymeleaf.cache=false#配置mappermybatis.mapper-locations=classpath:mapper/*.xml |
2.4、在pojo下的新建類userlogin
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
package springbootweb04.demo.pojo;import lombok.allargsconstructor;import lombok.data;import lombok.noargsconstructor;@data@allargsconstructor@noargsconstructorpublic class userlogin { private string username; private string password; public string getusername() { return username; }} |
2.5、新建數(shù)據(jù)庫(kù)，名為mybatis，創(chuàng)建用戶表，名為userlogin，創(chuàng)建username、password字段
2.5.1、數(shù)據(jù)庫(kù)名可以隨意，不過(guò)要與application.yml文件中的一致
2.5.2、idea中連接數(shù)據(jù)庫(kù)
database——> +——> data source——> mysql
2.6、mapper層
新建userloginmapper接口
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
package springbootweb04.demo.mapper;import org.apache.ibatis.annotations.mapper;import org.springframework.stereotype.repository;import springbootweb04.demo.pojo.userlogin;import java.util.list;@mapper@repositorypublic interface userloginmapper { //查詢 public list<userlogin> queryall(); //添加數(shù)據(jù) public int add(userlogin userlogin); //根據(jù)用戶名查詢數(shù)據(jù) public userlogin querybyname(string username);} |
2.7、resources目錄下的mapper目錄
在resources目錄下新建mapper目錄，并在這個(gè)目錄下新建userloginmapper.xml文件
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
<?xml version="1.0" encoding="utf-8" ?><!doctype mapper public "-//mybatis.org//dtd mapper 3.0//en" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="springbootweb04.demo.mapper.userloginmapper"> <select id="queryall" resulttype="springbootweb04.demo.pojo.userlogin"> select * from userlogin </select> <insert id="add" parametertype="springbootweb04.demo.pojo.userlogin"> insert into userlogin values (#{username},#{password}) </insert> <select id="querybyname" resulttype="springbootweb04.demo.pojo.userlogin"> select * from userlogin where username = #{username} </select></mapper> |
2.8、測(cè)試
在test.java.springbootweb04.demo類中，測(cè)試是否能聯(lián)通數(shù)據(jù)庫(kù)，沒(méi)有報(bào)錯(cuò)說(shuō)明成功。
|
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
|
package springbootweb04.demo;import org.junit.jupiter.api.test;import org.springframework.boot.test.context.springboottest;import springbootweb04.demo.mapper.userloginmapper;import springbootweb04.demo.pojo.userlogin;import org.springframework.beans.factory.annotation.autowired;import javax.sql.datasource;import java.sql.connection;import java.sql.sqlexception;import java.util.list;@springboottestclass demoapplicationtests { @autowired datasource datasource; @test void contextloads() throws sqlexception { system.out.println(datasource.getclass()); connection connection = datasource.getconnection(); system.out.println(connection); //template模板，拿來(lái)即用 connection.close(); } @autowired userloginmapper userloginmapper; @test public void totest(){ list<userlogin> userlogins = userloginmapper.queryall(); userlogins.foreach(e-> system.out.println(e)); }} |
2.9、services層
在services下新建接口userloginservicesi和類userloginservicesimpl
userloginservicesi接口：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
package springbootweb04.demo.services;import springbootweb04.demo.pojo.userlogin;import java.util.list;public interface userloginservicesi { //查詢 public list<userlogin> queryall(); //添加數(shù)據(jù) public int add(userlogin userlogin); //根據(jù)用戶名查詢數(shù)據(jù) public userlogin querybyname(string username);} |
userloginservicesimpl類
|
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
|
package springbootweb04.demo.services;import springbootweb04.demo.mapper.userloginmapper;import springbootweb04.demo.pojo.userlogin;import org.springframework.beans.factory.annotation.autowired;import org.springframework.stereotype.service;import java.util.list;@servicepublic class userloginservicesimpl implements userloginservicesi { @autowired userloginmapper userloginmapper; @override public list<userlogin> queryall() { return userloginmapper.queryall(); } @override public int add(userlogin userlogin) { return userloginmapper.add(userlogin); } @override public userlogin querybyname(string username) { return userloginmapper.querybyname(username); }} |
2.a、conteoller層
編寫(xiě)mycontroller類
|
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
|
package springbootweb04.demo.controller;import springbootweb04.demo.pojo.userlogin;import springbootweb04.demo.services.userloginservicesimpl;import org.springframework.beans.factory.annotation.autowired;import org.springframework.stereotype.controller;import org.springframework.ui.model;import org.springframework.web.bind.annotation.requestmapping;@controllerpublic class mycontroller { @autowired userloginservicesimpl userloginservicesimpl; @requestmapping("/tologin") public string tologin(){ return "login"; } @requestmapping("/loginsuccess") public string loginsuccess(model model, userlogin userlogin){ //先查詢看該用戶名是否存在 userlogin userlogin1 = userloginservicesimpl.querybyname(userlogin.getusername()); if(userlogin1 != null){ // 如果查詢的用戶不為空 system.out.println(userlogin1.tostring()); return "success"; } else{ //返回到登錄頁(yè)面 model.addattribute("data","該用戶不存在，請(qǐng)先注冊(cè)"); return "login"; } } //登錄界面 @requestmapping("/toregister") public string toregister(){ return "register"; } @requestmapping("/registersuccess") public string toregistersuccess(model model,userlogin userlogin){ //將賬號(hào)密碼加入到數(shù)據(jù)庫(kù)中 int add = userloginservicesimpl.add(userlogin); system.out.println("數(shù)據(jù)插入成功！"); model.addattribute("data","注冊(cè)成功，請(qǐng)登錄！"); return "login"; }} |
三、編寫(xiě)前端頁(yè)面
將以下三個(gè)頁(yè)面放在templates下面
login.html：登錄頁(yè)面
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
<!doctype html><html lang="en" xmlns:th="http://www.thymeleaf.org"><head> <meta charset="utf-8"> <title>title</title></head><body style="background: aqua"><div align="center"> <br><br><h2>登錄界面</h2><br><br> <span th:text="${data}" style="text-color:red;font-size: 10px"></span> <form method="get" action="/loginsuccess"> 用戶名:<input type="text" name="username" placeholder="請(qǐng)輸入用戶名" required/><br><br> 密碼：<input type="text" name="password" placeholder="請(qǐng)輸入密碼" required/><br><br> <input type="submit" value="登錄"> </form> <br> <form method="get" action="/toregister"> <input type="submit" value="注冊(cè)"> </form></div></body></html> |
register.html:注冊(cè)頁(yè)面
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
<!doctype html><html lang="en" xmlns:th="http://www.thymeleaf.org"><head> <meta charset="utf-8"> <title>title</title></head><body style="background: aqua"><div align="center"> <br><br>注冊(cè)界面<br><br> <form method="get" action="/registersuccess"> 用戶名:<input type="text" name="username" placeholder="請(qǐng)輸入用戶名" required/><br><br> 密碼：<input type="text" name="password" placeholder="請(qǐng)輸入密碼" required/><br><br> 確認(rèn)密碼：<input type="text" name="password2" placeholder="請(qǐng)輸入密碼" required/><br><br> <input type="submit" value="注冊(cè)"> </form></div></body></html> |
success.html：成功界面
|
1
2
3
4
5
6
7
8
9
10
|
<!doctype html><html lang="en"><head> <meta charset="utf-8"> <title>title</title></head><body></body></html> |
四、運(yùn)行測(cè)試
:localhost:8080/tologin
到此這篇關(guān)于idea下創(chuàng)建springboot+mybatis+mysql項(xiàng)目實(shí)現(xiàn)動(dòng)態(tài)登錄與注冊(cè)功能的文章就介紹到這了,更多相關(guān)springboot+mybatis+mysql動(dòng)態(tài)登錄與注冊(cè)內(nèi)容請(qǐng)搜索服務(wù)器之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持服務(wù)器之家！
原文鏈接：https://blog.csdn.net/qq_51808107/article/details/113834293
