SpringBoot教程五配置Mysql使用Mybatis-plus

 

目录

 前言需求描述

1、查询MyBatis-Plus官网

2、添加最新版本的依赖

3、调用Iservice实现curd

4、相关的MySQL配置参数

---

前言需求描述

目前所有的业务场景都是用数据库来作为媒介来实现的。数据库在所有的业务系统里面都是不可或缺的，不论是关系型数据MySQL,Oracle还是非关系型数据Redis，MongDb都是经常使用的。只有这些熟悉之后，才能实现所有的业务操作！

1、查询MyBatis-Plus官网

MyBatis-Plus

2、添加最新版本的依赖

<mysql-connector-java.version>8.0.19</mysql-connector-java.version>

<mybatis-plus-generator.version>3.5.1</mybatis-plus-generator.version>

           <!--mybatis-plus-->
            <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>${mybatis-plus-boot-starter.version}</version>
            </dependency>
            
            <!--mybatis-plus代码生成所需的默认模板引擎-->
            <dependency>
                <groupId>org.apache.velocity</groupId>
                <artifactId>velocity-engine-core</artifactId>
                <version>${velocity.version}</version>
            </dependency>
           
            <!--mysql连接-->
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>${mysql-connector-java.version}</version>
            </dependency>

3、调用Iservice实现curd

public interface ViewLogDao extends IService<ViewLog> {


    List<ViewLog> getRandomViewLog();

}

@Service
public class ViewLogDaoImpl extends ServiceImpl<ViewLogMapper, ViewLog> implements ViewLogDao {

    @Autowired
    private ViewLogMapper viewLogMapper;

    @Override
    public  List<ViewLog>  getRandomViewLog() {
        LambdaQueryWrapper<ViewLog> queryBean = new LambdaQueryWrapper();
        List<ViewLog> list = viewLogMapper.selectList(queryBean);
        return  list;
    }
}

4、相关的MySQL配置参数

主要是做一些链接属性的配置

application-dao.yml

spring:
  datasource:
    dynamic:
      druid:
        filters: stat
      primary: master
      datasource:
        master:
          username: root
          password: Hello1234
          driver-class-name: com.mysql.cj.jdbc.Driver
          url: jdbc:mysql://10.106.0.155:3306/npp?useUnicode=true&characterEncoding=utf8&autoReconnect=true&useSSL=false&allowMultiQueries=true&zeroDateTimeBehavior=convertToNull&serverTimezone=Asia/Shanghai
        masterSlaveDataSource:
          username: tbm
          password: Tbm@123$
          driver-class-name: com.mysql.cj.jdbc.Driver
          url: jdbc:mysql://10.106.1.185:3306/npp?useUnicode=true&characterEncoding=utf8&autoReconnect=true&useSSL=false&allowMultiQueries=true&zeroDateTimeBehavior=convertToNull&serverTimezone=Asia/Shanghai
  profiles:
    include: sharding
mybatis-plus:
  config-location: classpath:config/mybatis-config.xml
  mapper-locations: classpath*:mapper/*.xml