Spring Boot整合MyBatis

最新推荐文章于 2025-05-12 09:53:19 发布

原创最新推荐文章于 2025-05-12 09:53:19 发布 · 267 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#Spring Boot整合MyBatis

spring boot 专栏收录该内容

17 篇文章

订阅专栏

本文详细介绍了如何在SpringBoot项目中整合MyBatis，包括添加依赖、配置数据源、创建持久化类、定义数据访问层接口、业务层类及控制器类，最后通过测试应用验证整合效果。

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

示例：Spring Boot整合MyBatis

修改pom.xml文件

增加web开发依赖配置

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

然后添加数据库驱动依赖配置

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

最后需要添加mybatis-spring-boot-starter

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

配置数据源

spring.datasource.url=jdbc:mysql://localhost:3306/spring_boot
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driverClassName=com.mysql.jdbc.Driver
spring.jpa.database=MySQL
spring.jpa.show-sql=true
spring.jpa.hibernate.naming-strategy=org.hibernate.cfg.ImprovedNamingStrategy
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect

创建持久化类

程序清单：/jpa/src/main/java/com/dwx/bean/User.java

package com.dwx.bean;
public class User {
	private Integer userId;
	private String userName;
	private String sex;
	private Integer age;
	public Integer getUserId() {
		return userId;
	}
	public void setUserId(Integer userId) {
		this.userId = userId;
	}
	public String getUserName() {
		return userName;
	}
	public void setUserName(String userName) {
		this.userName = userName;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public Integer getAge() {
		return age;
	}
	public void setAge(Integer age) {
		this.age = age;
	}
}

定义数据访问层接口

程序清单：/jpa/src/main/java/com/dwx/repository/UserRepository.java

package com.dwx.repository;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import com.dwx.bean.User;
public interface UserRepository {
	@Select("select * from t_user where userName=#{userName}")
	public User getByUserName(@Param("userName")String userName);
}

定义业务层类

程序清单：/jpa/src/main/java/com/dwx/service/UserService.java

package com.dwx.service;
import javax.annotation.Resource;
import org.springframework.stereotype.Service;
import com.dwx.bean.User;
import com.dwx.repository.UserRepository;
@Service
public class UserService {
	@Resource
	private UserRepository userRepository;
	
	public User getByUserName(String userName) {
		return userRepository.getByUserName(userName);
	}
}

定义控制器类

程序清单：/jpa/src/main/java/com/dwx/controller/UserController.java

package com.dwx.controller;
import javax.annotation.Resource;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.dwx.bean.User;
import com.dwx.service.UserService;
@RestController
@RequestMapping("/user")
public class UserController {
	@Resource
	private UserService userService;
	
	@RequestMapping("/getByUserName")
	public User getByUserName(String userName) {
		return userService.getByUserName(userName);
	}
}

修改启动类

程序清单：/jpa/src/main/java/com/dwx/JpaApplication.java

package com.dwx;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
//指定数据访问层接口的包名
@MapperScan("com.dwx.repository")
public class JpaApplication {
	public static void main(String[] args) {
		SpringApplication.run(JpaApplication.class, args);
	}
}

测试应用

启动Spring Boot项目，在浏览器中输入以下地址：http://localhost:8080/user/getByUserName?userName=jack