本文共 3803 字，大约阅读时间需要 12 分钟。

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

详细教程请看：

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: 8081spring:  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、测试类

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