搭建mybatis-plus框架并進行數據庫添加
mybatis-plus（簡稱 mp）是一個 mybatis 的增強工具，在 mybatis 的基礎上只做增強不做改變，為簡化開發、提高效率而生。
1.搭建環境
jdk：jdk1.8.0_261
idea：intellij idea
maven：apache-maven-3.3.6
mysql：mysql-5.5.61
2.項目搭建
3.配置maven
4.項目結構
創建數據庫
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
create database tzy03;use tzy03;create table user( id int(11) primary key auto_increment, name varchar(50), pass varchar(50), );insert into user(name,passs) values('tom','1215');select * from user; |
新建完成以后，打開pom.xml后添加以下依賴：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
<dependency> <groupid>com.baomidou</groupid> <artifactid>mybatis-plus-boot-starter</artifactid> <version>3.4.0</version> </dependency> <dependency> <groupid>mysql</groupid> <artifactid>mysql-connector-java</artifactid> <version>5.1.49</version> </dependency> <dependency> <groupid>org.projectlombok</groupid> <artifactid>lombok</artifactid> <version>1.18.12</version> <scope>provided</scope> </dependency> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-test</artifactid> </dependency> |
5.配置 mapperscan 注解
掃描mapper層
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
package com.tzy.demo;import org.mybatis.spring.annotation.mapperscan;import org.springframework.boot.springapplication;import org.springframework.boot.autoconfigure.springbootapplication;@mapperscan("com.tzy.demo.mapper")@springbootapplicationpublic class demoapplication { public static void main(string[] args) { springapplication.run(demoapplication.class, args); }} |
成功界面
6.創建實體
|
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
|
package com.tzy.demo.pojo;import com.baomidou.mybatisplus.annotation.tablefield;import com.baomidou.mybatisplus.annotation.tableid;public class user { @tableid(value = "id") public int id; @tablefield(value = "name") public string name; @tablefield(value = "pass") public string pass; @override public string tostring() { return "user{" + "id=" + id + ", name='" + name + '\'' + ", pass='" + pass + '\'' + '}'; } public user(){} public int getid() { return id; } public void setid(int id) { this.id = id; } public string getname() { return name; } public void setname(string name) { this.name = name; } public string getpass() { return pass; } public void setpass(string pass) { this.pass = pass; }} |
7.創建接口
|
1
2
3
4
5
6
7
8
9
10
|
package com.tzy.demo.mapper;import com.baomidou.mybatisplus.core.mapper.basemapper;import com.tzy.demo.pojo.user;import org.springframework.stereotype.repository;@repositorypublic interface userdao extends basemapper<user> {} |
8.測試
在test文件里自動生成demoapplicationtests類里往數據庫中添加數據進行測試。
|
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
|
package com.tzy.demo;import com.tzy.demo.mapper.userdao;import com.tzy.demo.pojo.user;import org.junit.jupiter.api.test;import org.springframework.beans.factory.annotation.autowired;import org.springframework.boot.test.context.springboottest;@springboottestclass demoapplicationtests { @autowired private userdao userdao; @test void insert(){ user user1=new user(); user1.setname("田哲沅"); user1.setpass("1218"); int result=userdao.insert(user1); system.out.println("result:"+result); system.out.println(user1);//id會自動回填到user對象中 } } |
成功界面
8.1 updatebyid
需求信息：將id為1的員工的姓名更改為"tzy"
|
1
2
3
4
5
6
7
8
|
@test void testupdatebyid() { user user2=userdao.selectbyid(1); user2.setname("tzy"); int result = userdao.updatebyid(user2); system.out.println(result); }} |
8.2 selectbyid
查詢id為1的員工信息
|
1
2
3
4
5
6
|
@test void selectbyid() { user user2=userdao.selectbyid(1); system.out.println(user2); }} |
8.3 deletebyid
刪除id為1的員工信息
|
1
2
3
4
5
|
@test void testdeletebyid() { int result = userdao.deletebyid(1); system.out.println(result); } |
到此這篇關于搭建mybatis-plus框架并進行數據庫增刪改查的文章就介紹到這了,更多相關mybatis-plus數據庫增刪改查內容請搜索服務器之家以前的文章或繼續瀏覽下面的相關文章希望大家以后多多支持服務器之家！
原文鏈接：https://blog.csdn.net/it1880456/article/details/114680208
