千峰商城-springboot项目搭建-12-tkMapper整合

最新推荐文章于 2023-01-13 13:13:09 发布

临易i

最新推荐文章于 2023-01-13 13:13:09 发布

阅读量131

点赞数

本文链接：https://blog.csdn.net/LYly_B/article/details/125723234

版权

本文档详细介绍了如何使用tkMapper在Spring Boot项目中创建数据访问层。首先创建新工程并配置数据库连接，然后引入tkMapper依赖，接着在启动类中启用tkMapper扫描。接着创建数据表、实体类和DAO接口，通过继承Mapper和MySqlMapper接口实现基本CRUD操作。最后通过单元测试验证插入数据功能。

摘要由CSDN通过智能技术生成

1.创建新工程tkmapper-demo。

勾选依赖

编写application.yml:

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/fmmall2?characterEncoding=utf-8
spring.datasource.username=root
spring.datasource.password=123456

mybatis.type-aliases-package=com.qfedu.tkmapperdemo.beans
mybatis.mapper-locations=classpath:mappers/*Mapper.xml

在com/qfedu/tkmapperdemo下创建包bean、dao，resource下创建包mapper。

添加tkMapper依赖

      <dependency>
            <groupId>tk.mybatis</groupId>
            <artifactId>mapper-spring-boot-starter</artifactId>
            <version>2.1.5</version>
        </dependency>

2.在启动类中使用tkMapper的@MapperScan注释，引用包名。

package com.qfedu.tkMapperdemo;

import tk.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.qfedu.tkmapperdemo.dao")
public class TkmapperDemoApplication {

    public static void main(String[] args) {
        SpringApplication.run(TkmapperDemoApplication.class, args);
    }

}

3.创建数据表

4.创建实体类

beans-User.java:

@Data
@NoArgsConstructor
@AllArgsConstructor
@ApiModel(value = "User对象",description = "买家信息")
public class User { private int userId; private String username; private String password; private String nickname; private String realname; private String userImg; private String userMobile; private String userEmail; private String userSex; private Date userBirth; private Date userRegtime; private Date userModtime; }

5.创建DAO接口

tkMapper已经完成了对单表的通用操作的封装。封装在Mapper接口和 MySqlMapper接口中。因此如果我们想要完成对单表的操作，只需自定义dao接口继承这两个接口。

dao-UserDAO.java:

public interface UserDAO extends Mapper<User>,MySqlMapper<User>{

}

6.测试

@RunWith(SpringRunner.class)
@SpringBootTest(classes = TkmapperDemoApplication.class)
public class UserDAOTest{

    @Autowired
    private UserDAO userDAO;

    @Test
    public void test(){
        User user = new User();
        user.setUsername("aaaa");
        user.setPassword("1111");
        user.setUserImg("img/default.png");
        user.setUserRegtime(new Date());
        user.setUserModtime(new Date());
        int i = userDAO.insert(user);
        System.out.println(i)
    }
}