spring-mybatis整合_mybatis-spring pom-优快云博客

本文链接：https://blog.youkuaiyun.com/m0_55995610/article/details/123990710

这篇博客详细介绍了如何整合spring和mybatis。首先强调理解spring的ioc和aop概念，以及mybatis简化jdbc操作的功能。整合过程包括下载所需依赖，编写UserMapper接口和XML文件，以及创建实现类。在mybatis的基础上，spring-mybatis需要额外的impl类来实现接口方法。同时，展示了UserMapper接口、XML配置和实体类的创建，并说明mybatis-config.xml可以融入到spring-dao.xml中。

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

整合spring-mybatis前首先要了解，spring和mybatis的相关知识，我们知道，spring最重要的一点是ioc和aop，ioc主要是依赖注入,而aop则是切面，主要是代理模式，理解起来需要了解代理模式的相关知识。而mybatis则主要是简化了jdbc的代码。将在Java类中的代码融合在xml中，省去了写实现接口的方法。
在使用spring-mybatis时需要对照官方文档下载对于的依赖包，以下是pom.xml的代码

  <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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>com.atlin</groupId>
  <artifactId>Mybatis-Spring</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>war</packaging>
    	<dependencies>
    		<dependency>
	    <groupId>junit</groupId>
	    <artifactId>junit</artifactId>
	    <version>4.13.2</version>
	    <scope>test</scope>
	</dependency>
   		<dependency>
	  <groupId>org.mybatis</groupId>
	  <artifactId>mybatis-spring</artifactId>
	  <version>2.0.7</version>
	</dependency>
	   	<dependency>
	    <groupId>javax.annotation</groupId>
	    <artifactId>javax.annotation-api</artifactId>
	    <version>1.3.2</version>
	</dependency>
   		<dependency>
	  <groupId>org.mybatis</groupId>
	  <artifactId>mybatis</artifactId>
	  <version>3.5.2</version>
	</dependency>
	<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
	<dependency>
	    <groupId>mysql</groupId>
	    <artifactId>mysql-connector-java</artifactId>
	    <version>5.1.47</version>
	</dependency>
   	<dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjrt</artifactId>
            <version>1.9.6</version>
        </dependency>
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.9.6</version>
        </dependency>
        <dependency>
            <groupId>aopalliance</groupId>
            <artifactId>aopalliance</artifactId>
            <version>1.0</version>
	</dependency>
  		<dependency>
	    <groupId>org.springframework</groupId>
	    <artifactId>spring-web</artifactId>
	    <version>5.2.3.RELEASE</version>
	</dependency>
	
		<!-- https://mvnrepository.com/artifact/org.springframework/spring-context -->
	<dependency>
	    <groupId>org.springframework</groupId>
	    <artifactId>spring-context</artifactId>
	    <version>5.2.3.RELEASE</version>
	</dependency>
	
	<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
	<dependency>
	    <groupId>org.springframework</groupId>
	    <artifactId>spring-jdbc</artifactId>
	    <version>5.2.3.RELEASE</version>
	</dependency>
  	</dependencies>
<build>
	<plugins>
		<plugin>
			<groupId>org.apache.maven.plugins</groupId>
			<artifactId>maven-war-plugin</artifactId>
			<version>3.2.1</version>
		</plugin>
	</plugins>
	        <resources>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
</build>
  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>16</maven.compiler.source>
    <maven.compiler.target>16</maven.compiler.target>
  </properties>
</project>

UserMapper接口和UserMapper.xml主要是用于写接口和sql代码，在mybatis只需要写这两个类，但是在整合spring-mybatis则需要多写一个impl类，继承接口实现方法，作用和mybatis中的util工具类类似，具体原理详见源码。
UserMapper接口

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.atlin.pojo.User;

public interface UserMapper {
public List<User> select();
public User queryById(String id);
public void inser_User(User user);
}

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.atlin.dao.UserMapper">
<select id="select" resultType="com.atlin.pojo.User">
select * from user
 </select>
 <select id="queryById" parameterType="String"  resultType="com.atlin.pojo.User">
 select * from user where name=#{id}
 </select>
 <insert id="inser_User" parameterType="com.atlin.pojo.User">
 insert into user value(#{name},#{password})
 </insert>
</mapper>

impl
import java.util.List;

import org.mybatis.spring.SqlSessionTemplate;

import com.atlin.pojo.User;

public class UserMapperImpl implements UserMapper{
private SqlSessionTemplate sqlSession;

	public void setSqlSession(SqlSessionTemplate sqlSession) {
	this.sqlSession = sqlSession;
}

	public List<User> select() {
		// TODO Auto-generated method stub
		UserMapper mapper=sqlSession.getMapper(UserMapper.class);
		mapper.inser_User(new User("kb","kc"));
		return mapper.select();
	}

	public User queryById(String id) {
		UserMapper mapper=sqlSession.getMapper(UserMapper.class);
		//mapper.select();
		return mapper.queryById(id);
	}

	public void inser_User(User user) {
		// TODO Auto-generated method stub
		
	}

}

实体类(一般写在pojo下)，如果使用lombok，用注解@Data可以省去set,get方法

public class User {
	public String name;
	public String password;

	public User() {
		super();
	}


	public User(String name, String password) {
		super();
		this.name = name;
		this.password = password;
	}


	public String getName() {
		return name;
	}


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


	public String getPassword() {
		return password;
	}


	public void setPassword(String password) {
		this.password = password;
	}


	@Override
	public String toString() {
		return "User [name=" + name + ", password=" + password + "]";
	}
}

在mybatis中我们需要写mybatis-config.xml，在spring中可以将mybatis-config.xml写入spring-dao.xml中，以下是mybatis-config.xml和spring-dao.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
	<mappers>
		<mapper resource="com/atlin/dao/UserMapper.xml"/>
  	</mappers>
</configuration>

<?xml version='1.0' encoding='UTF-8' ?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
       xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
	   http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
       http://www.springframework.org/schema/aop
       http://www.springframework.org/schema/aop/spring-aop-4.0.xsd
       http://www.springframework.org/schema/tx
       http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
       http://www.springframework.org/schema/context
       http://www.springframework.org/schema/context/spring-context-4.0.xsd">



 <!-- 
  <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
 <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
  <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=false&amp;useUnicode=true&amp;characterEncoding=UTF-8&amp;serverTimezone=GMT%2B8"/>
   <property name="username" value="root"/>
    <property name="password" value="roat"/>
 </bean>

  -->
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
     <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
	  <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=false&amp;useUnicode=true&amp;characterEncoding=UTF-8&amp;serverTimezone=GMT%2B8"/>
	   <property name="username" value="xxx"/>
	    <property name="password" value="xxx"/>
	 </bean>
 <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
   <property name="dataSource" ref="dataSource" />
   <property name="configLocation" value="classpath:mybatis-config.xml"/>
</bean>
<!-- 配置 -->
<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg index="0" ref="sqlSessionFactory"/>
</bean>
<bean id="userMapper" class="com.atlin.dao.UserMapperImpl">
<property name="sqlSession" ref="sqlSession"/>
</bean>
<!-- 开启事务 以下代码可以省，主要为了保证事务正确，用到aop切面-->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>
    <tx:advice id="txAdvice" transaction-manager="transactionManager">
    	<tx:attributes>
    		<tx:method name="*"/>
    	</tx:attributes>
    </tx:advice>
    <aop:config>
     <aop:pointcut expression="execution(* com.atlin.dao.*.*(..))" id="txPointCut"/>
     <aop:advisor advice-ref="txAdvice" pointcut-ref="txPointCut"/>
    </aop:config>
</beans>

运行程序

public void test() {
	ApplicationContext context=new ClassPathXmlApplicationContext("spring-dao.xml");
	UserMapper usermapper=context.getBean("userMapper",UserMapper.class);
	List<User> use=usermapper.select();
	System.out.println(use);
}