MyBatis和Spring进行整合

怼烎@ 2022-06-12 07:58 139阅读 0赞

编写UserMapper.java：

package cn.cstor.mapper;
    
    import cn.cstor.pojo.User;
    
    public interface UserMapper { 
    	public User selectUserById(Integer id);
    }

编写UserMapper.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="cn.cstor.mapper.UserMapper">
    	<select id="selectUserById" parameterType="Integer" resultType="User">
    		select * from user where id = #{id}
    	</select>
    </mapper>

编写db.properties：

jdbc.driver:com.mysql.jdbc.Driver
    jdbc.url:jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf-8
    jdbc.username:root
    jdbc.password:root

编写SqlMapConfig.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>
    	
    	
    	
    	<typeAliases>
    		<package name="cn.cstor.pojo"/>
    	</typeAliases>
    
    	
    	<mappers>
    		<package name="cn.cstor.mapper"></package>
    	</mappers>
    	
    </configuration>

编写application.xml：

<?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:context="http://www.springframework.org/schema/context" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
    
    	<context:property-placeholder location="classpath:db.properties"/>
    	
    	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    		<property name="driverClassName" value="${jdbc.driver}"/>
    		<property name="url" value="${jdbc.url}"/>
    		<property name="username" value="${jdbc.username}"/>
    		<property name="password" value="${jdbc.password}"/>
    	</bean>
    	
    	
    	<bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
    		<property name="dataSource" ref="dataSource"/>
    		
    		<property name="configLocation" value="classpath:sqlMapConfig.xml"/>
    	</bean>
    	
    	
    	
    	
    	
    	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    		
    		<property name="basePackage" value="cn.cstor.mapper"/>
    	</bean>
    	
    </beans>

编写测试类：

package cn.cstor.junit;
    
    import org.junit.Test;
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    
    import cn.cstor.mapper.UserMapper;
    import cn.cstor.pojo.User;
    
    public class UserTest { 
    // 配合Mapper动态代理
    // @Test
    // public void test(){ 
    // ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");
    // UserMapper mapper = (UserMapper) ac.getBean("userMapper");
    // User user = mapper.selectUserById(110);
    // System.out.println(user);
    // }
    
    // 配合Mapper动态代理之扫描
    	@Test
    	public void test1() { 
    		ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");
    		UserMapper mapper = ac.getBean(UserMapper.class);
    		User user = mapper.selectUserById(110);
    		System.out.println(user);
    	}
    }

**注**：绝大多数情况下使用\*\*`Mapper动态代理之扫描`\*\* ，因为其直接扫描整个包下所有的Mapper，省去了多次定义的麻烦。

附录：

目录结构：

![这里写图片描述][format_png]