入門(mén)案例

創(chuàng)建測(cè)試數(shù)據(jù)庫(kù)和表

CREATE DATABASE `mybatis_plus` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; use `mybatis_plus`;CREATE TABLE `user` ( `id` bigint(20) NOT NULL COMMENT '主鍵ID',`name` varchar(30) DEFAULT NULL COMMENT '姓名', `age` int(11) DEFAULT NULL COMMENT '年齡', `email` varchar(50) DEFAULT NULL COMMENT '郵箱', PRIMARY KEY (`id`) )ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO user (id, name, age, email) VALUES (1, 'Jone', 18, 'test1@baomidou.com'), (2, 'Jack', 20, 'test2@baomidou.com'), (3, 'Tom', 28, 'test3@baomidou.com'),(4, 'Sandy', 21, 'test4@baomidou.com'), (5, 'Billie', 24, 'test5@baomidou.com');

創(chuàng)建SpringBoot工程

引入依賴

<!-- mybatis plus 啟動(dòng)器--><dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-boot-starter</artifactId><version>3.5.1</version></dependency><!-- lombok用于簡(jiǎn)化實(shí)體類開(kāi)發(fā)--><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId><optional>true</optional></dependency><!-- mysql驅(qū)動(dòng)--><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><scope>runtime</scope></dependency>

idea中安裝lombok插件

配置application.yml

spring:# 配置數(shù)據(jù)源信息datasource:# 配置數(shù)據(jù)源類型type: com.zaxxer.hikari.HikariDataSource# 配置連接數(shù)據(jù)庫(kù)的各個(gè)信息driver-class-name: com.mysql.cj.jdbc.Driverurl: jdbc:mysql://localhost:3306/mybatis_plus?serverTimezone=UTC&&characterEncoding=utf- 8&useSSL=falseusername: rootpassword: password

創(chuàng)建實(shí)體類

package com.xxxx.mybatisplus.pojo;import lombok.*;//@NoArgsConstructor //@AllArgsConstructor //@Getter //@Setter //@EqualsAndHashCode @Data public class User {// mybatis plus默認(rèn)用雪花算法, id 會(huì)比較長(zhǎng)private Long id;private String name;private Integer age;private String email;}

添加mapper

package com.xxxx.mybatisplus.mapper;import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.xxxx.mybatisplus.pojo.User;// 將類或者接口標(biāo)記為持久層組件 這樣就不會(huì)看見(jiàn)test類中的紅線警告了 @Repository public interface UserMapper extends BaseMapper<User> {}

在啟動(dòng)類上添加注解掃描mapper

package com.xxxx.mybatisplus;import org.mybatis.spring.annotation.MapperScan; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication;@SpringBootApplication// 掃描mapper接口所在的包 @MapperScan("com.xxxx.mybatisplus.mapper") public class MybatisplusApplication {public static void main(String[] args) {SpringApplication.run(MybatisplusApplication.class, args);}}

測(cè)試

package com.xxxx.mybatisplus;import com.xxxx.mybatisplus.mapper.UserMapper; import com.xxxx.mybatisplus.pojo.User; import org.junit.jupiter.api.Test; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.test.context.SpringBootTest;import java.util.List;@SpringBootTest public class MyBatisPlusTest {@Autowiredprivate UserMapper userMapper;@Testpublic void testSelectList(){// 通過(guò)條件構(gòu)造器查詢一個(gè)list集合,若沒(méi)有條件,則可以設(shè)置null為參數(shù)List<User> list = userMapper.selectList(null);list.forEach(System.out::println);}}

加入日志功能

加入配置

mybatis-plus:configuration:log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

總結(jié)

以上是生活随笔為你收集整理的[MyBatisPlus]入门案例的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。