<!--事务,集成了连接池-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<!--mysql驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<!--mybatis-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.0.1</version>
</dependency>
<!--通用mapper-->
<dependency>
<groupId>tk.mybatis</groupId>
<artifactId>mapper-spring-boot-starter</artifactId>
<version>2.0.4</version>
</dependency>
- 首先引入依赖
- 配置yml文件,连接池信息
#mapper别名配置 mybatis: type-aliases-package:com.bs.pojo spring: datasource: url: jdbc:mysql://localhost:3306/bs username: root password: root
- 在启动类中加入@mapperScan来扫描mapper注入,注意要用tx包
@MapperScan("com.bs.springbootdome.mapper")
- 在mapper包中,写一个接口继承mapper<>然后就生效了
import com.bs.springbootdome.pojo.User; import tk.mybatis.mapper.common.Mapper; /** * @author Administrator * @date 2019/7/22 0022 19:36 * @PackageName:springbootdome * @ClassName: 描述: */ public interface TestMapper extends Mapper<User> { }
- 在实体类中加入注解
@Table(name="tb_category") @Data public class Category { @Id @KeySql(useGeneratedKeys=true) private Long id; private String name; private Long parentId; private Boolean isParent; private Integer sort; }
其中@table 关联的表名
@id 主键字段
@keysql =true 可以返回自动添加的id