重庆建设工程交易中心网站,徐州企业制作网站,网页设计添加图片插件,网页素材图文章目录一、通用部分1. 通用依赖2. 通用配置 yml二、 springboot3.x 集成通用mapper2.1. pom.xml2.2. yml2.3. mapper接口2.4. 启动类加MapperScan注解2.5. 启动类加ComponentScan注解三、 springboot3.x 集成通用Mybatis3.1. pom.xml3.2. yml3.3. mapper接口3.4. 启动类加Map…
文章目录一、通用部分1. 通用依赖2. 通用配置 yml二、 springboot3.x 集成通用mapper2.1. pom.xml2.2. yml2.3. mapper接口2.4. 启动类加MapperScan注解2.5. 启动类加ComponentScan注解三、 springboot3.x 集成通用Mybatis3.1. pom.xml3.2. yml3.3. mapper接口3.4. 启动类加MapperScan注解3.5. 启动类加ComponentScan注解四、 springboot3.x 集成通用MybatisPlus4.1. pom.xml4.2. yml4.3. mapper接口4.4. 启动类加MapperScan注解4.5. 启动类加ComponentScan注解一、通用部分
1. 通用依赖 dependencygroupIdcom.github.pagehelper/groupIdartifactIdpagehelper-spring-boot-starter/artifactIdversion1.2.5/version/dependencydependencygroupIdorg.mybatis.generator/groupIdartifactIdmybatis-generator-core/artifactIdversion1.3.2/version/dependencydependencygroupIdorg.mybatis.spring.boot/groupIdartifactIdmybatis-spring-boot-starter/artifactIdversion1.3.2/version/dependencydependencygroupIdcom.alibaba/groupIdartifactIddruid-spring-boot-starter/artifactIdversion1.1.10/version/dependencydependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactId/dependencydependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactIdoptionaltrue/optional/dependency2. 通用配置 yml
spring:datasource:username: rootpassword: rooturl: jdbc:mysql://127.0.0.1:3306/xxx?useUnicodetruecharacterEncodingUTF-8useSSLfalseautoReconnecttruefailOverReadOnlyfalseserverTimezoneCTTdriver-class-name: com.mysql.cj.jdbc.Drivertype: com.alibaba.druid.pool.DruidDataSourcedruid:# 下面为连接池的补充设置应用到上面所有数据源中# 初始化大小最小最大initial-size: 5min-idle: 5max-active: 20# 配置获取连接等待超时的时间max-wait: 60000stat-view-servlet:enabled: truelogin-username: adminlogin-password: adminallow:deny:url-pattern: /druid/*二、 springboot3.x 集成通用mapper
2.1. pom.xml dependencygroupIdtk.mybatis/groupIdartifactIdmapper/artifactIdversion4.0.3/version/dependency2.2. yml
mybatis:mapper-locations: classpath:mapper/*/*Mapper.xmltype-aliases-package: com.coderman.api.*.pojoconfiguration:map-underscore-to-camel-case: true2.3. mapper接口
package com.coderman.api.system.mapper;import com.coderman.api.system.pojo.User;
import tk.mybatis.mapper.common.Mapper;/*** Author gblfy* Date 2020/3/7 15:03* Version 1.0**/
public interface UserMapper extends MapperUser {
}
2.4. 启动类加MapperScan注解
import tk.mybatis.spring.annotation.MapperScan;
MapperScan(com.coderman.api.*.mapper)2.5. 启动类加ComponentScan注解
import org.springframework.context.annotation.ComponentScan;
ComponentScan(com.coderman.*)注扫描包例如扫描配置类上有Configuration注解的类
三、 springboot3.x 集成通用Mybatis
3.1. pom.xml dependencygroupIdorg.mybatis.spring.boot/groupIdartifactIdmybatis-spring-boot-starter/artifactIdversion1.3.2/version/dependency3.2. yml
mybatis:mapper-locations: classpath:mapper/*/*Mapper.xmltype-aliases-package: com.coderman.api.*.pojoconfiguration:map-underscore-to-camel-case: true3.3. mapper接口
package com.coderman.api.system.mapper;import com.coderman.api.system.pojo.User;
import tk.mybatis.mapper.common.Mapper;/*** Author gblfy* Date 2020/3/7 15:03* Version 1.0**/
public interface UserMapper{
}
3.4. 启动类加MapperScan注解
import org.mybatis.spring.annotation.MapperScan;
MapperScan(com.coderman.api.*.mapper)3.5. 启动类加ComponentScan注解
import org.springframework.context.annotation.ComponentScan;
ComponentScan(com.coderman.*)注扫描包例如扫描配置类上有Configuration注解的类
四、 springboot3.x 集成通用MybatisPlus
4.1. pom.xml !--Mybatis-Plus 启动器--dependencygroupIdcom.baomidou/groupIdartifactIdmybatis-plus-boot-starter/artifactIdversion3.3.1.tmp/version/dependency4.2. yml
#实体扫描多个package用逗号或者分号分隔
mybatis-plus:typeAliasesPackage: com.gblfy.springboot.mybatisplus.entitymapper-locations:- classpath*:com/gblfy/springboot/**/mapping/*.xml4.3. mapper接口
package com.gblfy.springboot.mybatisplus.mapper;import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.gblfy.springboot.mybatisplus.entity.User;
import org.apache.ibatis.annotations.Param;import java.util.List;public interface UserMapper extends BaseMapperUser {}
4.4. 启动类加MapperScan注解
import org.mybatis.spring.annotation.MapperScan;
MapperScan(com.gblfy.springboot.mybatisplus.mapper)4.5. 启动类加ComponentScan注解
import org.springframework.context.annotation.ComponentScan;
ComponentScan(com.coderman.*)注扫描包例如扫描配置类上有Configuration注解的类
