springboot 整合mybatis_spring boot mybatis 整合-优快云博客

本文链接：https://blog.youkuaiyun.com/caideb/article/details/81707455

本文介绍如何在Spring Boot项目中整合MyBatis框架，包括配置POM依赖、设置数据源、定义实体类、创建Mapper接口及XML映射文件，并实现简单的数据查询功能。

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

1.pom文件

<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>1.5.2.RELEASE</version>
	</parent>

	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter</artifactId>
		</dependency>

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>

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

		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
		</dependency>
	</dependencies>

2.application.properties

spring.datasource.url=jdbc:mysql://localhost:3306/test
spring.datasource.username=root
spring.datasource.password=HlztLhy
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

mybatis.mapper-locations= classpath:mapper/*.xml

3.java代码

模型

package com.knife.bootmybatis;

public class User {

	private int id;
	private String name;
	private String pw;
	private int state;

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getPw() {
		return pw;
	}

	public void setPw(String pw) {
		this.pw = pw;
	}

	public int getState() {
		return state;
	}

	public void setState(int state) {
		this.state = state;
	}

	public String toString() {
		return "id:" + id + " name:" + name;
	}
}

mapper

package com.knife.bootmybatis;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface UserMapper {
	public List<User> all();
}

xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.knife.bootmybatis.UserMapper">

	<select id="all" resultType="com.knife.bootmybatis.User">
		<![CDATA[
			select * from user
		]]>
	</select>

</mapper>

controller

package com.knife.bootmybatis;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

@Controller
public class C {

	@Autowired
	private UserMapper dao;
	
	@RequestMapping("list")
	@ResponseBody
	public List<User> getUser(){
		return dao.all();
	}
}

app入口程序

package com.knife.bootmybatis;


import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;


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

4.执行