springboot整合tkmapper以及遇到的大坑：

最新推荐文章于 2023-03-06 14:47:40 发布

zhongbai-

最新推荐文章于 2023-03-06 14:47:40 发布

阅读量296

点赞数

CC 4.0 BY-SA版权

文章标签： spring boot java

本文链接：https://blog.youkuaiyun.com/sjgllllll/article/details/121055252

本文介绍了如何使用Spring Boot和MyBatis快速搭建项目，包括依赖引入、数据源配置、DAO接口实现及Mapper扫描。通过实例展示了UserDao的创建和测试类的编写，适合初学者入门数据库操作实践。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

第一步：先创建springboot项目

第二步：导入依赖：

<dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>tk.mybatis</groupId>
            <artifactId>mapper-spring-boot-starter</artifactId>
            <version>2.1.5</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.2.0</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.22</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.17</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.22</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
        </dependency>
    </dependencies>

第三步：创建相应的包（dao，entity，mapper等）：

第四步：配置文件application.yml

spring:
  datasource:
    druid:
      driver-class-name: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://127.0.0.1:3306/shopmall?serverTimezone=GMT%2B8&useUnicode=true&&characterEncoding=UTF-8
      username: root
      password: 123456
      initial-size: 1
      min-idle: 1
      max-active: 20
mybatis:
  mapper-locations: classpath:mappers/*Mapper.xml
  type-aliases-package: com.abtu.entity

server:
  port: 8083

Dao层代码：需要继承（Mapper<>,MySqlMapper<>）

@Repository
public interface UserDao extends Mapper<Users>, MySqlMapper<Users> {

}

启动类需要添加MapperScan注解

注意MapeperScande注解一定要映入tkMapper的：tk.mybatis.spring.annotation.MapperScan;

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

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

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

}

编写测试类：

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

    @Autowired
    UserDao userDao;

    @Test
    public void contextLoads() {
        Users user = new Users();
        user.setUsername("5654654654");
        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);
    }
   
}

完成！！！！