mybatis配置不用记_mybatis配置记不住-优快云博客

本文链接：https://blog.youkuaiyun.com/void_String/article/details/125204221

本文详细介绍了Mybatis的配置过程，包括数据库连接池的设置、配置文件的编写、Mapper XML文件的配置以及在微服务环境中的应用。通过实例解析每个步骤，助你轻松掌握Mybatis配置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1数据库连接池

spring.datasource.url=jdbc:mysql://localhost:3306/mall_pms?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
spring.datasource.username=root
spring.datasource.password=root

#logging.level.en.tedu.csmall.product:trace

<!-- 数据库连接池 -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.1.21</version>
</dependency>

2.配置设置


spring.profiles.active=dve

spring.datasource.type=com.alibaba.druid.pool.DruidDataSource


mybatis.mapper-locations=classpath:mapper/*.xml

3.配置 mapper 文件下的 xxx.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="en.tedu.csmall.product.webapi.mapper.CategoryMapper">

    



</mapper>

4.yml 文件

server:
  port: 9527

spring:
  profiles:
    active: dev
mybatis:
  configuration:
    cache-enabled: false
    map-underscore-to-camel-case: true
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl 
  mapper-locations:
    - classpath:mapper/*.xml   # 路径
knife4j:
  enable: true   # 增强模式

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/cart_stock?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai&allowMultiQueries=true
    username: root
    password: root

5.微服务中的配置

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/csmall_db?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai&allowMultiQueries=true
    username: root
    password: root

  application:
    name: nacos-cart-webapi
  cloud:
    nacos:
      discovery:
        server-addr: localhost:8848    # 注册中心

  kafka:  #kafka 配置
    consumer:
      group-id: kafka
    bootstrap-servers: localhost:9092
dubbo:            
  protocol:
    port: -1
    name: dubbo
  registry:
    address: nacos://localhost:8848
  consumer:
    check: false
seata:
  tx-service-group: camall-group
  service:
    vgroup-mapping:
      csmall_grop: default
    grouplist:
      default: localhost:8091