SpringBoot通用mapper的使用
1.添加依耐
<!-- mysql驱动 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
<!-- 通用mapper -->
<dependency>
<groupId>tk.mybatis</groupId>
<artifactId>mapper-spring-boot-starter</artifactId>
<version>2.1.5</version>
</dependency>
CREATE TABLE `tb_category` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '类目id',
`name` varchar(32) NOT NULL COMMENT '类目名称',
`parent_id` bigint(20) NOT NULL COMMENT '父类目id,顶级类目填0',
`is_parent` tinyint(1) NOT NULL COMMENT '是否为父节点,0为否,1为是',
`sort` int(4) NOT NULL COMMENT '排序指数,越小越靠前',
PRIMARY KEY (`id`),
KEY `key_parent_id` (`parent_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1424 DEFAULT CHARSET=utf8 COMMENT='商品类目表,类目和商品(spu)是一对多关系,类目与品牌是多对多关系';
2.创建pojo
@Table(name="tb_category")
public class Category {
@Id
@GeneratedValue(strategy= GenerationType.IDENTITY)
private Long id;
private String name;
private Long parentId;
private Boolean isParent;// 注意isParent的get和set方法 阿里不推荐使用is开头的字段,会出现缺失的问题
private Integer sort;
// getter和setter略
}
3.创建mapper
public interface CategoryMapper extends Mapper<Category> {
}
4.测试
@SpringBootTest
class MapperDemoApplicationTests {
@Autowired
CategoryMapper categoryMapper;
@Test
void contextLoads() {
System.out.println("---------");
Category t = new Category();
t.setParentId(1L);
List<Category> select = categoryMapper.select(t);
if (select != null) {
System.out.println("------========---");
for (Category category : select) {
System.out.println(category.getName());
System.out.println(category.getIsParent());
}
}
}
}
测试结果
------========—
电子书刊
true
音像
true
英文原版
true
文艺
true
少儿
true