MybatisPlus入门之快速入门
生活随笔
收集整理的這篇文章主要介紹了
MybatisPlus入门之快速入门
小編覺得挺不錯的,現(xiàn)在分享給大家,幫大家做個參考.
CREATE TABLE `user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT 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;-- 插入數(shù)據(jù)
INSERT INTO `user` (`id`, `name`, `age`, `email`) VALUES ('1', 'Jone', '18',
'test1@learn.com');
INSERT INTO `user` (`id`, `name`, `age`, `email`) VALUES ('2', 'Jack', '20',
'test2@learn.com');
INSERT INTO `user` (`id`, `name`, `age`, `email`) VALUES ('3', 'Tom', '28',
'test3@learn.com');
INSERT INTO `user` (`id`, `name`, `age`, `email`) VALUES ('4', 'Sandy', '21',
'test4@learn.com');
INSERT INTO `user` (`id`, `name`, `age`, `email`) VALUES ('5', 'Billie', '24',
'test5@learn.com');
<?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
http://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.1.0.RELEASE</version></parent><groupId>cn.learn.mybatisplus</groupId><artifactId>learn-mybatis-plus</artifactId><version>1.0-SNAPSHOT</version><dependencies><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-test</artifactId><scope>test</scope></dependency><!--mybatis-plus的springboot支持--><dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-boot-starter</artifactId><version>3.0.5</version></dependency><!--mysql驅(qū)動--><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.47</version></dependency><!--簡化代碼的工具包--><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId><optional>true</optional><version>1.18.4</version></dependency></dependencies><build><plugins><plugin><groupId>org.springframework.boot</groupId><artifactId>spring-boot-maven-plugin</artifactId></plugin></plugins></build></project>
spring.application.name = learn-mybatis-plusspring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/haoke?useUnicode=true&characterEncoding=utf8&autoReconnect=true&allowMultiQueries=true&useSSL=false
spring.datasource.username=root
spring.datasource.password=123456
package cn.learn.mybatisplus.pojo;public class User {private Long id;private String name;private Integer age;private String email;public Long getId() {return id;}public void setId(Long id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public Integer getAge() {return age;}public void setAge(Integer age) {this.age = age;}public String getEmail() {return email;}public void setEmail(String email) {this.email = email;}@Overridepublic String toString() {return "User{" +"id=" + id +", name='" + name + '\'' +", age=" + age +", email='" + email + '\'' +'}';}
}
package cn.learn.mybatisplus.mapper;import cn.learn.mybatisplus.pojo.User;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;public interface UserMapper extends BaseMapper<User> {}
package cn.learn.mybatisplus;import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.context.annotation.Bean;@MapperScan("cn.learn.mybatisplus.mapper") //設(shè)置mapper接口的掃描包
@SpringBootApplication
public class MyApplication {/*** 分頁插件*/@Beanpublic PaginationInterceptor paginationInterceptor() {return new PaginationInterceptor();}public static void main(String[] args) {SpringApplication.run(MyApplication.class, args);}}
package cn.learn.mybatisplus.mapper;import cn.learn.mybatisplus.pojo.User;
import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;import java.util.List;@RunWith(SpringRunner.class)
@SpringBootTest
public class UserMaperTest {@Autowiredprivate UserMapper userMapper;@Testpublic void testSelect(){List<User> users = this.userMapper.selectList(null);for (User user : users) {System.out.println(user);}}@Testpublic void testSelectById(){User user = this.userMapper.selectById(3L);System.out.println(user);}@Testpublic void testSelectByLike(){QueryWrapper<User> wrapper = new QueryWrapper<User>();wrapper.like("name", "o");List<User> list = this.userMapper.selectList(wrapper);for (User user : list) {System.out.println(user);}}@Testpublic void testSelectByLe(){QueryWrapper<User> wrapper = new QueryWrapper<User>();wrapper.le("age", 20);List<User> list = this.userMapper.selectList(wrapper);for (User user : list) {System.out.println(user);}}@Testpublic void testSave(){User user = new User();user.setAge(25);user.setEmail("zhangsan@qq.com");user.setName("zhangsan");int count = this.userMapper.insert(user);System.out.println("新增數(shù)據(jù)成功! count => " + count);}@Testpublic void testDelete(){this.userMapper.deleteById(7L);System.out.println("刪除成功!");}@Testpublic void testUpdate(){User user = new User();user.setId(6L);user.setName("lisi");this.userMapper.updateById(user);System.out.println("修改成功!");}@Testpublic void testSelectPage() {Page<User> page = new Page<>(2, 2);IPage<User> userIPage = this.userMapper.selectPage(page, null);System.out.println("總條數(shù) ------> " + userIPage.getTotal());System.out.println("當(dāng)前頁數(shù) ------> " + userIPage.getCurrent());System.out.println("當(dāng)前每頁顯示數(shù) ------> " + userIPage.getSize());List<User> records = userIPage.getRecords();for (User user : records) {System.out.println(user);}}}
?
總結(jié)
以上是生活随笔為你收集整理的MybatisPlus入门之快速入门的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。
- 上一篇： MybatisPlus入门之介绍
- 下一篇： MybatisPlus入门Lombok的