springboot整合mybatis

最新推荐文章于 2024-05-30 16:50:04 发布

北极熊不在北极

最新推荐文章于 2024-05-30 16:50:04 发布

阅读量780

点赞数 1

文章标签： mybatis spring boot java

本文链接：https://blog.csdn.net/u010197591/article/details/129383841

版权

一、创建好springboot项目

https://blog.csdn.net/u010197591/article/details/129320594

二、在pom文件中添加依赖

        <dependency>
            <groupId>com.mysql</groupId>
            <artifactId>mysql-connector-j</artifactId>
            <scope>runtime</scope>
        </dependency>

        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.3.0</version>
        </dependency>

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.6</version>
        </dependency>

三、在application.yml配置文件添加连接信息

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/spring_demo?serverTimeZone=UTC
    username: root
    password: root
    type: com.alibaba.druid.pool.DruidDataSource

四、写个dao

package com.liuyc.dao;

import com.liuyc.domain.Book;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface BookDao {

    @Select("select id , book_name bookName , author , type , description from book")
     List<Book> getBooks();
}

五、写个测试类试一试

package com.liuyc;

import com.liuyc.dao.BookDao;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

@SpringBootTest
public class DaoTest {

    @Autowired
    private BookDao bookDao;

    @Test
    public void getBooks(){
        System.out.println(bookDao.getBooks());
    }
}

测试结果：