五、SpringBoot3整合Mybatis
|
26
|
0
|
springboot

840 字
|
16 分钟

五、SpringBoot3整合Mybatis

1、步骤

  1. 导入依赖：在您的Spring Boot项目的构建文件（如pom.xml）中添加MyBatis和数据库驱动的相关依赖。例如，如果使用MySQL数据库，您需要添加MyBatis和MySQL驱动的依赖。
  2. 配置数据源：在application.properties或application.yml中配置数据库连接信息，包括数据库URL、用户名、密码、mybatis的功能配置等。
  3. 创建实体类：创建与数据库表对应的实体类。
  4. 创建Mapper接口：创建与数据库表交互的Mapper接口。
  5. 创建Mapper接口SQL实现： 可以使用mapperxml文件或者注解方式
  6. 创建程序启动类
  7. 注解扫描：在Spring Boot的主应用类上添加@MapperScan注解，用于扫描和注册Mapper接口。
  8. 使用Mapper接口：在需要使用数据库操作的地方，通过依赖注入或直接实例化Mapper接口，并调用其中的方法进行数据库操作。

2、整合实战

1、导入依赖

1、注意：在1.2.20之后的druid配置就支持SpringBoot3中的配置参数了

2、依赖

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.atguigu</groupId>
    <artifactId>springboot-base-mybatis-05</artifactId>
    <version>1.0-SNAPSHOT</version>

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

    <properties>
        <maven.compiler.source>17</maven.compiler.source>
        <maven.compiler.target>17</maven.compiler.target>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    </properties>

    <dependencies>
        <!--  web开发的场景启动器 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <!-- 数据库相关配置启动器 jdbctemplate 事务相关-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>

        <!-- druid启动器的依赖  -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.2.20</version>
        </dependency>

        <!-- 驱动类-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.28</version>
        </dependency>

        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.28</version>
        </dependency>

        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>3.0.1</version>
        </dependency>
<!--        aop的-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-aop</artifactId>
        </dependency>

    </dependencies>

    <!--    SpringBoot应用打包插件-->
    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

2、配置文件

1、如下配置

spring:
  datasource:
    # 连接池类型
    type: com.alibaba.druid.pool.DruidDataSource

    # Druid的其他属性配置 springboot3整合情况
    url: jdbc:mysql://localhost:3306/manager
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver

mybatis:
  #指定mapper.xml配置文件的位置
  mapper-locations: classpath:mappers/*.xml
  #指定实体类所在的包，自动扫描包下边的实体类，自动将实体类与mapper.xml进行绑定
  type-aliases-package: com.atguigu.pojo
  configuration:
    map-underscore-to-camel-case: true #开启驼峰式
    auto-mapping-behavior: full #开启自动映射，深层
    log-impl: org.apache.ibatis.logging.slf4j.Slf4jImpl #开启日志

3、实现类准备

1、Teacher类

package com.atguigu.pojo;

import lombok.Data;

@Data
public class Teacher {

    private Integer id;
    private String username;
    private String password;
    private String name;
    private String role;
}

4、Mapper接口

1、UserMapper.java接口

package com.atguigu.mapper;

import com.atguigu.pojo.Teacher;

import java.util.List;

public interface UserMapper {

    List<Teacher> queryAll();

    int delete(int id);

}

5、Mapper接口的实现（XML）文件

1、位置：resources/mapper/UserMapper.xml

2、代码UserMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!-- namespace等于mapper接口类的全限定名,这样实现对应 -->
<mapper namespace="com.atguigu.mapper.UserMapper">
    <select id="queryAll" resultType="teacher">
        select * from teacher;
    </select>

    <delete id="delete">
        delete from teacher where id = #{id}
    </delete>
</mapper>

6、编写启动类和接口扫描注解

1、实现

package com.atguigu;

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

@SpringBootApplication
@MapperScan("com.atguigu.mapper")// 扫描mapper接口
public class Main {
    public static void main(String[] args) {
        SpringApplication.run(Main.class, args);
    }
}

7、三层架构

1、UserController.java代码

package com.atguigu.controller;

import com.atguigu.mapper.UserMapper;
import com.atguigu.pojo.Teacher;
import com.atguigu.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;

@RestController
@RequestMapping("user")
public class UserController {

    @Autowired
    private UserService userService;

    @GetMapping("/{id}")
    public void deleteUser(@PathVariable("id") int id){
        userService.delete(id);
    }
}

2、Userservice.java接口

package com.atguigu.service;

public interface UserService {
    int delete(int id);
}

3、UserServiceImpl.java实现类

package com.atguigu.service.impl;

import com.atguigu.mapper.UserMapper;
import com.atguigu.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

@Service
public class UserServiceImpl implements UserService {
    @Autowired
    private UserMapper userMapper;

    @Override
    @Transactional
    public int delete(int id) {
        int row =userMapper.delete(id);
//        int  s = 1/0;
        return row;
    }
}

4、UserMapper.java代码

package com.atguigu.mapper;

import com.atguigu.pojo.Teacher;

import java.util.List;

public interface UserMapper {

    int delete(int id);
}

5、UserMapper.xml文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!-- namespace等于mapper接口类的全限定名,这样实现对应 -->
<mapper namespace="com.atguigu.mapper.UserMapper">
    <select id="queryAll" resultType="teacher">
        select * from teacher;
    </select>

    <delete id="delete">
        delete from teacher where id = #{id}
    </delete>
</mapper>

6、测试

3、声明式事务整合配置

1、导入依赖

1、依赖

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

2、注意

  • SpringBoot项目会自动配置一个 DataSourceTransactionManager
  • 所以我们只需在方法（或者类）加上 @Transactional 注解，就自动纳入 Spring 的事务管理了

3、例子

@Transactional
public void update(){
    User user = new User();
    user.setId(1);
    user.setPassword("test2");
    user.setAccount("test2");
    userMapper.update(user);
}

4、AOP整合配置

1、依赖导入

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

2、例子

1、整体和上面的整合实战一样

2、这里着重讲AOP的实例配置

3、实现

package com.atguigu.advice;

import org.aspectj.lang.JoinPoint;
import org.aspectj.lang.annotation.Aspect;
import org.aspectj.lang.annotation.Before;
import org.springframework.core.annotation.Order;
import org.springframework.stereotype.Component;

/**
 * 切片
 */
@Component
@Aspect
@Order(5)
public class LogAdvice {
    @Before("execution(* com..service.*.*(..))")
    public void before(JoinPoint joinPoint){
        String className = joinPoint.getTarget().getClass().getSimpleName();
        String methodName = joinPoint.getSignature().getName();
        System.out.println("LogAdvice.before: "+className+"."+methodName+"()");
        System.out.println("LogAdvice.before: 开始事务...");
    }
}
暂无评论

发送评论 编辑评论 


				

			

						

				

					

						

							

								
							

							
						

					

				

				

					

						

							

								
							

							
						

					

				

				

					

						

							

								
							

							
							
													

					

				

			

			
			

				

					
				

			

				

											

							
							
						

																				
					
											
						

	

		
|´・ω・)ノ
ヾ(≧∇≦*)ゝ
(☆ω☆)
（╯‵□′）╯︵┴─┴
￣﹃￣
(/ω＼)
∠( ᐛ 」∠)＿
(๑•̀ㅁ•́ฅ)
→_→
୧(๑•̀⌄•́๑)૭
٩(ˊᗜˋ*)و
(ノ°ο°)ノ
(´இ皿இ｀)
⌇●﹏●⌇
(ฅ´ω`ฅ)
(╯°A°)╯︵○○○
φ(￣∇￣o)
ヾ(´･ ･｀｡)ノ"
( ง ᵒ̌皿ᵒ̌)ง⁼³₌₃
(ó﹏ò｡)
Σ(っ °Д °;)っ
( ,,´･ω･)ﾉ"(´っω･｀｡)
╮(╯▽╰)╭
o(*////▽////*)q
＞﹏＜
( ๑´•ω•) "(ㆆᴗㆆ)
😂
😀
😅
😊
🙂
🙃
😌
😍
😘
😜
😝
😏
😒
🙄
😳
😡
😔
😫
😱
😭
💩
👻
🙌
🖕
👍
👫
👬
👭
🌚
🌝
🙈
💊
😶
🙏
🍦
🍉
😣
Source: github.com/k4yt3x/flowerhd
	

	

		
颜文字
Emoji
小恐龙
花!
	


									

			

			
			
		

	






上一篇
下一篇