当前位置：首页 > 文章列表 > 数据库 > MySQL > Mybatis-配置和整合

Mybatis-配置和整合

来源：SegmentFault 2023-02-24 14:52:16 0浏览收藏

来到golang学习网的大家，相信都是编程学习爱好者，希望在这里学习数据库相关编程知识。下面本篇文章就来带大家聊聊《Mybatis-配置和整合》，介绍一下MySQL、Java、数据库、jdbc、mybatis，希望对大家的知识积累有所帮助，助力实战开发！

正文

一. Mybatis工程搭建

1. 创库建表

首先创建一个名为test的

CREATE TABLE book(
    id INT(11) PRIMARY KEY AUTO_INCREMENT,
    b_name VARCHAR(255) NOT NULL,
    b_price FLOAT NOT NULL
)

然后往book表插入三条数据，插入语句如下所示。

INSERT INTO book (b_name, b_price) VALUES ("Math", 20.5)
INSERT INTO book (b_name, b_price) VALUES ("English", 21.5)
INSERT INTO book (b_name, b_price) VALUES ("Water Margin", 30.5)

上述数据用于

<dependency><groupid>org.mybatis</groupid><a target='_blank'  href='https://www.17golang.com/gourl/?redirect=MDAwMDAwMDAwML57hpSHp6VpkrqbYLx2eayza4KafaOkbLS3zqSBrJvPsa5_0Ia6sWuR4Juaq6t9nq5roGCUgXpusdyfa5hlmtrGjJ3Nkbu2qZvfZZrEm2hmtH15pZGBi6zHprOifauEz757hpSHp6VpkrqbYLx2eayza4KafaOkbLS3zqSBrJvPsa5_0Ia6sWuR4Jtt' rel='nofollow'>MyBatis XML配置</a>，里面有关于</p><pre class="brush:go;">@Data
public class Book {

    private long id;
    private String bookName;
    private float bookPrice;

}

5. 映射接口和映射文件

由于在

public interface BookMapper {

    List<book> selectAllBooks();

}</book>

映射文件

<?xml version="1.0" encoding="UTF-8" ?><mapper namespace="com.mybatis.learn.dao.BookMapper"><resultmap id="bookResultMap" type="com.mybatis.learn.entity.Book"><result column="b_name" property="bookName"></result><result column="b_price" property="bookPrice"></result></resultmap><select id="selectAllBooks" resultmap="bookResultMap">
        SELECT
        b.id, b.b_name, b.b_price
        FROM
        book b
    </select></mapper>

由于maven默认不会将src/main/java下的非

<build><resources><resource><directory>src/main/java</directory><includes><include>**/*.xml</include></includes><filtering>false</filtering></resource></resources></build>

6. 工程结构

整个工程结构如下所示。

其中

public class MybatisTest {

    public static void main(String[] args) throws Exception {
        String resource = "mybatis-config.xml";
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder()
                .build(Resources.getResourceAsStream(resource));
        SqlSession sqlSession = sqlSessionFactory.openSession();
        BookMapper bookMapper = sqlSession.getMapper(BookMapper.class);
        List<book> books = bookMapper.selectAllBooks();
        books.forEach(book -> System.out.println(book.toString()));
    }

}</book>

这里特别注意

<dependency><groupid>org.mybatis.spring.boot</groupid><artifactid>mybatis-spring-boot-starter</artifactid><version>2.1.3</version></dependency>

最后测试时采用基于rest工具调用接口的方式来触发对数据库的操作，因此还需要引入web依赖，如下所示。

<dependency><groupid>org.springframework.boot</groupid><artifactid>spring-boot-starter-web</artifactid><version>2.4.1</version></dependency>

在使用了

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/test?characterEncoding=utf-8&serverTimezone=UTC&useSSL=false
    username: root
    password: root

mybatis:
  configuration:
    use-generated-keys: true

本节中，映射接口

@SpringBootApplication
@MapperScan("com.mybatis.learn.dao")
public class MybatisLearnApplication {

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

}

至此整合已经结束，整个工程结构如下所示。

service层和controller层用于测试。

@Service
public class MybatisService {

    @Autowired
    private BookMapper bookMapper;

    public List<book> selectAllBooks() {
        return bookMapper.selectAllBooks();
    }

}</book>

在成功完成整合之后，可以从

@RestController
public class MybatisController {

    @Autowired
    private MybatisService mybatisService;

    @RequestMapping(value = "/api/v1/selectall", method = RequestMethod.GET)
    public ResponseEntity<list>> selectAllBooks() {
        List<book> books;
        try {
            books = mybatisService.selectAllBooks();
        } catch (Exception e) {
            return new ResponseEntity(null, HttpStatus.INTERNAL_SERVER_ERROR);
        }
        return new ResponseEntity(books, HttpStatus.OK);
    }

}</book></list>

最后基于rest工具调用接口，结果如下所示。