如果你集成不了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());
}
}