目录

 前言需求描述

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

           
            
                com.baomidou
                mybatis-plus-boot-starter
                ${mybatis-plus-boot-starter.version}
            
            
            
            
                org.apache.velocity
                velocity-engine-core
                ${velocity.version}
            
           
            
            
                mysql
                mysql-connector-java
                ${mysql-connector-java.version}
            

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