08-MyBatis_与spring的整合之初步

骑猪看日落 2022-09-17 12:24 6阅读 0赞

MyBatis 与 Spring的整合

\- 1. 保证Spring能初始化

\- 2. 保证MyBatis能正常使用

\- 3. 再整合二者

# 0.源码下载 #

[MyBatis与Spring的初步整合-src.zip][MyBatis_Spring_-src.zip]

# 1. jar #

截图:

![SouthEast][]

# 2. spring容器的初始化 #

##  2.1 spring的配置文件 ApplicationContext.xml ##

参考文档 3.2.1 Configuration metadata  
位置:spring-framework-3.0.0.RELEASE  
|--docs\\spring-framework-reference\\htmlsingle

配置文件内容:

2.2 junit test

public class SpringTest {
    	ApplicationContext context;
    
    	@Before
    	public void sprintInit() {
    		context = new ClassPathXmlApplicationContext("ApplicationContext.xml");
    	}
    	
    	@Test
    	public void testSprintInit() {
    		System.out.println(context);
    	}	
    	
    }

# 3. 整合MyBatis #

##  3.1 MyBatis总配置文件 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>
    		<typeAlias type="com.hehe.mybatis.domain.User" alias="User"/>
    	</typeAliases>
    	<mappers>
    		
    		<mapper resource="com/hehe/mybatis/domain/User.xml" />
    	</mappers>
    </configuration>

##  3.2 实体与映射文件 ##

###  3.2.1 实体 与 表 ###

package com.hehe.mybatis.domain;
    
    public class User {
    
    	private String id;
    	private String name;
    	private String address;
    
    	@Override
    	public String toString() {
    		return "id=" + id + "\tname="+name+"\taddress="+address;
    	}
    
            // set / get 已省略
    }

-- drop database mybatis;
    
    CREATE DATABASE mybatis;
    
    USE mybatis;
    
    CREATE TABLE USER
    (
      id VARCHAR(36) PRIMARY KEY 	,
      NAME VARCHAR(64)		,
      address VARCHAR(128)	
    )
    
    INSERT INTO USER (id, NAME, address)
      VALUES("0001", "zhangsan", "Wuhan");
    INSERT INTO USER (id, NAME, address)
      VALUES("0002", "lisi", "Shanghai");  
      
    SELECT * FROM USER;

###  3.2.2 映射文件 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.hehe.mybatis.domain.User">
    
    	<resultMap id="userMap" type="User">
    		<id column="id" property="id"/>
    		<result column="name" property="name"/>
    		<result column="address" property="address"/>
    	</resultMap>
    
    	<select id="selectUserById" parameterType="string" resultMap="userMap">
    		select * from user where id = #{id}
    	</select>
    
    </mapper>

##  3.3 UserDao 与 UserDaoImpl ##

public interface UserDao {
    	
    	public User findUserById(String id);
    		
    }

public class UserDaoImpl extends SqlSessionDaoSupport implements UserDao {
    
    	@Override
    	public User findUserById(String id) {
    		return (User) super.getSqlSession().selectOne(
    				User.class.getName() + ".selectUserById", id);
    	}
    
    	public static void main(String[] args) {
    		System.out.println(User.class.getName());
    		//com.hehe.mybatis.domain.User
    	}
    }

##  3.4 DataSource 数据源 ##

<bean id="dataSource"  
class="org.springframework.jdbc.datasource.DriverManagerDataSource">  
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>  
<property name="url" value="jdbc:mysql:///mybatis"/>  
<property name="username" value="root"/>  
<property name="password" value="root"/>  
</bean>

##  3.5 SqlSessionFactoryBean 集成MyBatis ##

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
  
<property name="dataSource" ref="dataSource" />  
  
<property name="configLocation" value="classpath:sqlMapConfig.xml"/>  
</bean>

##  3.6 完整的 ApplicationContext.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"
    	xsi:schemaLocation="http://www.springframework.org/schema/beans
               http://www.springframework.org/schema/beans/spring-beans-3.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:///mybatis"/>
    		<property name="username" value="root"/>
    		<property name="password" value="root"/>
    	</bean>
    	
    	
    	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    		
    		<property name="dataSource" ref="dataSource" />
    		
    		<property name="configLocation" value="classpath:sqlMapConfig.xml"/>
    	</bean>
    	
    	<bean id="userDao" class="com.hehe.mybatis.dao.impl.UserDaoImpl">
    		<property name="sqlSessionFactory" ref="sqlSessionFactory" />
    	</bean>
    	
    </beans>

##  3.7 junit test  ##

public class UserDaoTest {
    	ApplicationContext context;
    
    	@Before
    	public void sprintInit() {
    		context = new ClassPathXmlApplicationContext("ApplicationContext.xml");
    	}
    	
    	@Test
    	public void testSprintInit() {
    		System.out.println(context);
    	}	
    	
    	@Test
    	public void testFindUserById() {
    		UserDao userDao = (UserDao) context.getBean("userDao");
    		User user = userDao.findUserById("0001");
    		System.out.println(user);
    	}	
    		
    	
    }

[MyBatis_Spring_-src.zip]: http://download.csdn.net/detail/wuqinfei_cs/6426923
[SouthEast]: /images/20220828/9df6923f9d4a4568ba42e6c4a5ce9969.png