MyBatis_与spring的整合之初步

今天药忘吃喽~ 2023-10-16 19:47 8阅读 0赞

MyBatis 与 Spring的整合

\- 1. 保证Spring能初始化

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

\- 3. 再整合二者

## 0.源码下载 ##

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

## 1. jar ##

截图:

![Center][]

## 2. spring容器的初始化 ##

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

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

配置文件内容:

<?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">
    	
    </beans>

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
[Center]: https://img-blog.csdn.net/20140327172932781?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvemhvdXpoaXdlbmdhbmc=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center