【项目】基于SaaS的餐掌柜项目实战阶段一基于SaaS的餐掌柜项目实战第1章基础架构搭建 3 技术预研 3.4 Mybatis-plus 3.4.2 代码演示

清疚 2024-03-23 14:30 7阅读 0赞

### 【项目】基于SaaS的餐掌柜项目实战 ###

#### 文章目录 ####

*   *  【项目】基于SaaS的餐掌柜项目实战
     *   *  阶段一 基于SaaS的餐掌柜项目实战
         *   *  第1章 基础架构搭建
             *  3 技术预研
             *   *  3.4 Mybatis-plus
                 *   *  3.4.2 代码演示

![在这里插入图片描述][8f336558f392435e813f6a65409ff6f1.png_pic_center]

#### 阶段一 基于SaaS的餐掌柜项目实战 ####

##### 第1章 基础架构搭建 #####

##### 3 技术预研 #####

###### 3.4 Mybatis-plus ######

###### 3.4.2 代码演示 ######

【3.4.2.1 导入测试工程】

1）导入资源文件夹中的**mybatisPlus-demo**测试工程

![在这里插入图片描述][c9cea51480f7405cad52b58c8f75c631.png_pic_center]

使用IDEA 直接打开

![在这里插入图片描述][3eafff470338487a99ea3e0c6a40b62f.png_pic_center]

修改pom

<?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>
    
        <groupId>com.itheima</groupId>
        <artifactId>mybatisPlus-demo</artifactId>
        <version>1.0-SNAPSHOT</version>
    
        
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.1.6.RELEASE</version>
            <relativePath/>
        </parent>
    
        <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.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>3.2.0</version>
            </dependency>
    
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <scope>runtime</scope>
            </dependency>
            
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.1.6</version>
            </dependency>
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <version>1.18.10</version>
                <scope>provided</scope>
            </dependency>
            <dependency>
                <groupId>commons-codec</groupId>
                <artifactId>commons-codec</artifactId>
                <version>1.10</version>
            </dependency>
        </dependencies>
    </project>

![在这里插入图片描述][92e75ab9b1184a998793939c62cfa5cc.png_pic_center]

2）**修改配置文件**

spring:
      application:
        name: mybatisPlus-demo
      datasource:
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://192.168.88.162:3306/mybatisplus?useSSL=false
        username: root
        password: 123456
    logging:
      level:
        com.itheima: debug
    server:
      port: 9300

![在这里插入图片描述][2f6baa6ebb9b4bfc9a7d4d8236d93f3e.png_pic_center]

【3.4.2.2 创建数据库和实体类映射】

先启动一个新的容器，mysql容器

docker run -d -p 3306:3306 -v /home/mysql/conf:/etc/mysql/conf.d -v /home/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 --name mysql mysql

![在这里插入图片描述][4eea61a37edd4efbba6d3aa71ecb57b3.png_pic_center]

使用可视化工具连接

![在这里插入图片描述][9f34576e8ee343cda83b349e2b5be8b4.png_pic_center]

创建`mybatisPlus` 数据库

![在这里插入图片描述][ad3f63859f8b4dc9a7ca739625112900.png_pic_center]

字符集那些都可以 保持默认

创建`t_user`表

create table `t_user`(
    	`id` varchar(32) not null,
    	`username` varchar(20) default null,
    	`password` varchar(64) default null,
    	primary key (`id`)
    ) engine=InnoDB default charset=utf8;

![在这里插入图片描述][304bc967bf614f53a6a2464b55984d67.png_pic_center]

![在这里插入图片描述][ff942a0b49c24bf1aa155bc89053192b.png_pic_center]

mybatis-plus 提供了 相关操作注解如下：

@TableName： 设置当前实体类映射的表名
    
    @TableId：设置主键字段映射
          
    @TableField：设置普通字段映射

package com.itheima.entity;
    
    import com.baomidou.mybatisplus.annotation.IdType;
    import com.baomidou.mybatisplus.annotation.TableField;
    import com.baomidou.mybatisplus.annotation.TableId;
    import com.baomidou.mybatisplus.annotation.TableName;
    import lombok.Data;
    
    @Data
    @TableName("t_user")
    public class User {
        
    
        @TableId(type = IdType.ID_WORKER_STR)
        private String id;
    
        @TableField(value = "username") // //数据库名字一致或者驼峰可以忽略
        private String username;
    
        @TableField(value = "password")
        private String password;
    
    }

![在这里插入图片描述][6e9b8e729be14519ab1ad5b123465563.png_pic_center]

【3.4.2.3 通用层封装实现】

Mybaits-plus提供了两种通用CRUD接口的实现，分别对应service层与dao层。

**1）通用Mapper封装**

常用方法如下：

*  Insert
 *  Delete
 *  Update
 *  Select

使用示例：

1）`dao包下新建mapper接口`

package com.itheima.dao;
    
    import com.baomidou.mybatisplus.core.mapper.BaseMapper;
    import com.itheima.entity.User;
    import org.apache.ibatis.annotations.Mapper;
    
    @Mapper
    public interface UserMapper extends BaseMapper<User> {
        
    }

![在这里插入图片描述][c62defcc32f3435c89927010d5e87fd3.png_pic_center]

2）`启动类添加dao层扫描`

package com.itheima;
    
    import org.apache.ibatis.annotations.Mapper;
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    
    @SpringBootApplication
    @MapperScan("com.itheima.dao") // dao层扫描
    public class MybatisPlusDemoApplication {
        
    
        public static void main(String[] args) {
        
            SpringApplication.run(MybatisPlusDemoApplication.class,args);
        }
    }

![在这里插入图片描述][d0d3562146ae407dbffb3ee3b2685b33.png_pic_center]

3）测试

package com.itheima;
    
    import com.itheima.dao.UserMapper;
    import com.itheima.entity.User;
    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.annotation.Rollback;
    import org.springframework.test.context.junit4.SpringRunner;
    
    @SpringBootTest
    @RunWith(SpringRunner.class)
    public class DaoTest {
        
    
        @Autowired
        private UserMapper userMapper;
    
        // 新增
        @Test
        @Rollback(false)
        public void addTest() {
        
            User user = new User();
            user.setUsername("zhangsan");
            user.setPassword("123");
            userMapper.insert(user);
        }
    }

运行测试

![在这里插入图片描述][200ed4b73036491f8abc5ae432f417d2.png_pic_center]

查看数据库

![在这里插入图片描述][e6a92329aba04b1bbd690ea6aceac2d4.png_pic_center]

没问题

查询操作：

@Test
        public void queryTest(){
        
            User user = userMapper.selectById("1647168529243365378");
            System.out.println(user);
        }

运行结果

![在这里插入图片描述][6d5fb0edd721402b871b905883ba191d.png_pic_center]

没问题。

**2）通用servcie封装**

常用方法如下：

*  Save
 *  SaveOrUpdate
 *  Remove
 *  Update
 *  Get
 *  List
 *  Page
 *  Count
 *  Chain

1）`添加service接口`

package com.itheima.service;
    
    import com.baomidou.mybatisplus.extension.service.IService;
    import com.itheima.entity.User;
    
    public interface UserService extends IService<User> {
        
    }

![在这里插入图片描述][b59f65ed5d8d427d81d6f2c11b437ba3.png_pic_center]

2）`添加service接口实现类`

package com.itheima.service.impl;
    
    import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
    import com.itheima.dao.UserMapper;
    import com.itheima.entity.User;
    import com.itheima.service.UserService;
    import org.springframework.stereotype.Service;
    
    @Service("userService")
    public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements UserService {
        
    }

![在这里插入图片描述][ad5b9103230e4f1a98b49d5440e39257.png_pic_center]

3）`测试`

package com.itheima;
    
    import com.itheima.entity.User;
    import com.itheima.service.UserService;
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.beans.factory.annotation.Qualifier;
    import org.springframework.boot.test.context.SpringBootTest;
    import org.springframework.test.annotation.Rollback;
    import org.springframework.test.context.junit4.SpringRunner;
    
    @SpringBootTest
    @RunWith(SpringRunner.class)
    public class ServiceTest {
        
    
        @Autowired
        @Qualifier("userService")
        private UserService userService;
    
        @Test
        @Rollback(false)
        public void addTest() {
        
            User user = new User();
            user.setUsername("wangwu");
            user.setPassword("123");
            userService.save(user);
        }
    
    }

运行结果

![在这里插入图片描述][473e6edb2b094ac597062d6667bfe610.png_pic_center]

查看数据库

![在这里插入图片描述][df2ec5a68f5c4442ba7ede48215a82d1.png_pic_center]

查询测试

@Test
        public void queryTest() {
        
            User user = userService.getById("1647183088607821825");
            System.out.println(user);
        }

运行结果

![在这里插入图片描述][77584f5d6c3a4a248e3e4666daa2bae5.png_pic_center]

没问题

4）密码加密

@Test
        @Rollback(false)
        public void addTest() {
        
            User user = new User();
            user.setUsername("lisi");
            //user.setPassword("123");
            user.setPassword(Md5Crypt.md5Crypt("123".getBytes()));
            userService.save(user);
        }

运行结果

![在这里插入图片描述][41c612bf60e0461db29c2f1da6722950.png_pic_center]

查看数据库

![在这里插入图片描述][54a58caa70024b8498975fccb9139447.png_pic_center]

密文保存。

[8f336558f392435e813f6a65409ff6f1.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/33423f9b083c4b94a40945d67d884be4.png
[c9cea51480f7405cad52b58c8f75c631.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/c1af483493fe4f059240967bfefc9c51.png
[3eafff470338487a99ea3e0c6a40b62f.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/111f49e7f20b49cc89dfd158376ed54e.png
[92e75ab9b1184a998793939c62cfa5cc.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/6255989b7c774b58a2bf30a2b85fcf1a.png
[2f6baa6ebb9b4bfc9a7d4d8236d93f3e.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/c70c6ee2284b49f38d8c8c2e97b1396f.png
[4eea61a37edd4efbba6d3aa71ecb57b3.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/e20583ef32244fd68458df5af335f61d.png
[9f34576e8ee343cda83b349e2b5be8b4.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/80d589314a65415b96b4a8283dde6465.png
[ad3f63859f8b4dc9a7ca739625112900.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/f96d9e0f049b41ae98d94076da402264.png
[304bc967bf614f53a6a2464b55984d67.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/6fa0d844b340477cb2c18bbadef498bd.png
[ff942a0b49c24bf1aa155bc89053192b.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/34eba2354a3b4bafbd3e54eb63651000.png
[6e9b8e729be14519ab1ad5b123465563.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/d4232a4610e24fd1b855fdb4ed64eae7.png
[c62defcc32f3435c89927010d5e87fd3.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/4a6a803b0b234f088f081eb3ef367e48.png
[d0d3562146ae407dbffb3ee3b2685b33.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/495f174a9c7a480183d95f31f577be5c.png
[200ed4b73036491f8abc5ae432f417d2.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/299d3a262bdb4f65b776ab968dd0b25f.png
[e6a92329aba04b1bbd690ea6aceac2d4.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/0ae4e2d27d7e4e79981dd55d3145bfa9.png
[6d5fb0edd721402b871b905883ba191d.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/25e8377788904a85a785ff07101d7cb3.png
[b59f65ed5d8d427d81d6f2c11b437ba3.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/6eb32a53fa8f42b3a65842b53ac2247e.png
[ad5b9103230e4f1a98b49d5440e39257.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/e6db8abc908f4e2bb0cd17812a24abbc.png
[473e6edb2b094ac597062d6667bfe610.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/5566564ce0cc44a98b103230cf61fce5.png
[df2ec5a68f5c4442ba7ede48215a82d1.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/2b622e97a8144ab4a3702c48a12b465f.png
[77584f5d6c3a4a248e3e4666daa2bae5.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/1ca41a0b772e43e4ab3dd2b5620d0c3a.png
[41c612bf60e0461db29c2f1da6722950.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/1aa645758db8410a91bac9b5e539b2c0.png
[54a58caa70024b8498975fccb9139447.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/f66752d4033549a9b151432115bdf3f5.png