目录

 前言需求描述

1、查询MyBatis-Plus官网

2、添加最新版本的依赖

3、调用Iservice实现curd

4、相关的MySQL配置参数

前言需求描述

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

1、查询MyBatis-Plus官网

MyBatis-Plus

2、添加最新版本的依赖

8.0.19

3.5.1

           
            <dependency>
                <groupId>com.baomidougroupId>
                <artifactId>mybatis-plus-boot-starterartifactId>
                <version>${mybatis-plus-boot-starter.version}version>
            dependency>
            
            
            <dependency>
                <groupId>org.apache.velocitygroupId>
                <artifactId>velocity-engine-coreartifactId>
                <version>${velocity.version}version>
            dependency>
           
            
            <dependency>
                <groupId>mysqlgroupId>
                <artifactId>mysql-connector-javaartifactId>
                <version>${mysql-connector-java.version}version>
            dependency>

3、调用Iservice实现curd

public interface ViewLogDao extends IService {
 
 
    List getRandomViewLog();
 
}

@Service
public class ViewLogDaoImpl extends ServiceImpl implements ViewLogDao {
 
    @Autowired
    private ViewLogMapper viewLogMapper;
 
    @Override
    public  List  getRandomViewLog() {
        LambdaQueryWrapper queryBean = new LambdaQueryWrapper();
        List 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