SpringBoot整合MyBatis-Plus（齐名插件tk.mapper）

如果你集成不了mybatis-plus的话建议使用mybatis的 tk.mapper插件

 或者Hibernate、Spring Data JPA

详细教程请看：SpringBoot整合MyBatis-Plus3.1详细教程 - 叶知秋qw - 博客园

1、导包

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <!-- MYSQL -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!-- mybatisPlus 核心库 -->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.1.0</version>
        </dependency>
		<dependency>
			<groupId>com.baomidou</groupId>
			<artifactId>mybatis-plus-annotation</artifactId>
			<version>3.1.2</version>
		</dependency>
		<dependency>
			<groupId>com.baomidou</groupId>
			<artifactId>mybatis-plus-extension</artifactId>
			<version>3.1.2</version>
		</dependency>

        <!--lombok-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <!--<version>1.16.10</version>-->
        </dependency>


        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
    </dependencies>

亲爱的别忘了加mybatis-plus-extension包

2、yml配置

server:
  port: 8081

spring:
  datasource:
    #driver-class-name: com.mysql.jdbc.Driver
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/whadmin-jar?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false&serverTimezone=GMT%2B8
    username: root
    password: root
    #type: com.alibaba.druid.pool.DruidDataSource

# mybatis-plus相关配置
mybatis-plus:
  # xml扫描，多个目录用逗号或者分号分隔（告诉 Mapper 所对应的 XML 文件位置）
  mapper-locations: classpath:mapper/*.xml
  # 以下配置均有默认值,可以不设置
  global-config:
    db-config:
      #主键类型 AUTO:"数据库ID自增" INPUT:"用户输入ID",ID_WORKER:"全局唯一ID (数字类型唯一ID)", UUID:"全局唯一ID UUID";
      id-type: auto
      #字段策略 IGNORED:"忽略判断"  NOT_NULL:"非 NULL 判断")  NOT_EMPTY:"非空判断"
      field-strategy: NOT_EMPTY
      #数据库类型
      db-type: MYSQL
  configuration:
    # 是否开启自动驼峰命名规则映射:从数据库列名到Java属性驼峰命名的类似映射
    map-underscore-to-camel-case: true
    # 如果查询结果中包含空值的列，则 MyBatis 在映射的时候，不会映射这个字段
    call-setters-on-nulls: true
    # 这个配置会将执行的sql打印出来，在开发或测试的时候可以用
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

3、主配置类

@SpringBootApplication
@MapperScan(basePackages = {"cn.etc.sys.mapper"})
public class WhadminJarApplication {

}

4、SysUserMapper

public interface SysUserMapper extends BaseMapper<SysUser> {
}

5、SysUserServiceIntf接口层

public interface SysUserServiceIntf extends IService<SysUser> {
}

6、SysUserServiceImpl实现类

@Transactional(rollbackFor = Exception.class)
@Service("SysUserService")
public class SysUserServiceImpl extends ServiceImpl<SysUserMapper, SysUser> implements SysUserServiceIntf {

}

7、SysUser实体类

@Data
@TableName("t_sys_user")
public class SysUser implements Serializable {
    private static final long serialVersionUID = 1L;

	@TableId(type = IdType.AUTO)
	private String userId; //主键id

	private String userName; //用户名

	private String loginName; //登录名

	private String loginPwd; //登录密码

	private String userType; //用户类型

	private String isLocked; //是否允许登录(需要授权)

	private String loginKey; //登录编码
}

8、测试类

@SpringBootTest
class WhadminJarApplicationTests {

    @Autowired
    private SysUserServiceIntf sysUserServiceIntf;

    @Test
    void contextLoads() {
        String userId = "222222222222222222222222222222222222";
        SysUser sysUser = sysUserServiceIntf.getById(userId);
        System.out.println(sysUser.toString());
    }

}