Spring+MyBatis整合、接口实现组件两种方法、整合流程

Spring+Mybatis

mybatis-spring.jar整合包

MapperFactoryBean组件，封装了根据Mapper映射器接口生成实现组件的功能

结合

先把包都引入 ioc aop dao dbcp 当然在之前的Mybatis下增加的

当然还有配置文件

还有引入 mybatis-spring.jar

在Spring配置中

<!-- 可以根据给定的Mapper接口生成实现组件 -->    <bean id="costDao" class="org.mybatis.spring.mapper.MapperFactoryBean">    <property name="mapperInterface" value="dao.CostDao"></property>    </bean>

实现一个组件就要写一个这个bean
那个dao.CostDao接口就是之前写的接口。让他根据这个接口实现组件

SqlSessionFactoryBean组件，封装了创建SqlSession

用dbcp的连接池

就是不用MyBatis的配置文件了。用的dbcp的连接池

即：用这个dbcp连接池的bean

<!-- 定义dbcp的DataSource -->    <bean id="dbcp" class="org.apache.commons.dbcp.BasicDataSource">    <property name="username" value="root"></property>    <property name="password" value="root"></property>    <property name="url" value="jdbc:mysql:///jsd1507db"></property>    <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>    </bean>    替代：mybatis的配置文件   <environments default="development">          <environment id="development">              <transactionManager type="JDBC" />              <dataSource type="POOLED">                  <property name="driver" value="com.mysql.jdbc.Driver" />                  <property name="url" value="jdbc:mysql://localhost/jsd1507db" />                  <property name="username" value="root" />                  <property name="password" value="root" />              </dataSource>          </environment>      </environments>  

这几个关系

DataSource(dbcp)
SqlSessionFactoryBean(ssf)
注入dataSource
注入sql定义文件
MapperFactoryBean(costDAO)
注入sqlsessionfactory
注入CostDao接口

    <!-- 可以根据给定的Mapper接口生成实现组件 -->    <bean id="costDao" class="org.mybatis.spring.mapper.MapperFactoryBean">    <property name="mapperInterface" value="dao.CostDao"></property>    <!-- 指定sqlsession资源 -->    <property name="sqlSessionFactory" ref="ssf"></property>    </bean>    <bean id="ssf" class="org.mybatis.spring.SqlSessionFactoryBean">    <!-- 注入dataSource    用连接池获取-->    <property name="dataSource" ref="dbcp"></property>    <!-- 注入SQL语句文件   用*号代替，那么就可以加载多个xml文件了 -->    <property name="mapperLocations" value="classpatch:entity/*.xml"></property>    </bean>    <!-- 定义dbcp的DataSource -->    <bean id="dbcp" class="org.apache.commons.dbcp.BasicDataSource">    <property name="username" value="root"></property>    <property name="password" value="root"></property>    <property name="url" value="jdbc:mysql:///jsd1507db"></property>    <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>    </bean>

一定要注意！！！！！！！！！！！！

编写的Mapper接口的名字要和Mapper.xml文件中的namespace相同才可以

<mapper namespace="dao.CostDao">

要把包也写上。

利用MapperFactoryBean

主要是配置文件：

<!-- 可以根据给定的Mapper接口生成实现组件 -->    <bean id="costDao" class="org.mybatis.spring.mapper.MapperFactoryBean">    <property name="mapperInterface" value="dao.CostDao"></property>    <!-- 指定sqlsession资源 -->    <property name="sqlSessionFactory" ref="ssf"></property>    </bean>    <bean id="ssf" class="org.mybatis.spring.SqlSessionFactoryBean">    <!-- 注入dataSource    用连接池获取-->    <property name="dataSource" ref="dbcp"></property>    <!-- 注入SQL语句文件   用*号代替，那么就可以加载多个xml文件了 -->    <property name="mapperLocations" value="entity/CostDao.xml"></property>    </bean>    <!-- 定义dbcp的DataSource -->    <bean id="dbcp" class="org.apache.commons.dbcp.BasicDataSource">    <property name="username" value="root"></property>    <property name="password" value="root"></property>    <property name="url" value="jdbc:mysql:///jsd1507db"></property>    <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>    </bean>

测试类：package test;import java.util.List;import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;import dao.CostDao;import entity.Cost;public class TestCostDao {    public static void main(String[] args){        String conf ="applicationContext.xml";        ApplicationContext ac = new ClassPathXmlApplicationContext(conf);        CostDao costDao = ac.getBean("costDao",CostDao.class);        List<Cost> list =costDao.findAll();        for(Cost cost:list){            System.out.println("name:"+cost.getName());        }    }}

sql语句文件Mapper<?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="dao.CostDao">    <select id="findAll" resultType="entity.Cost">    select * from cost    </select>    <select id="findPage" parameterType="int" resultType="entity.Cost">    select * from cost limit #{page},5    </select>    <select id="findMap" resultType="Map">    select cost_id,name from cost    </select>    </mapper>

MapperScannerConfigurer

这个组件封装了批量生成Mapper组件的功能
批量为每一个dao生成

如下配置

<!-- 可以根据指定路径批量生成Dao实现 -->    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">    <!-- 扫描dao下所有接口，批量生成实现 -->    <property name="basePackage" value="dao"></property>    <!-- 自动注入sqlsessionfactory -->    <property name="sqlSessionFactory" ref="ssf"></property>    </bean>    <bean id="ssf" class="org.mybatis.spring.SqlSessionFactoryBean">    <!-- 注入dataSource    用连接池获取-->    <property name="dataSource" ref="dbcp"></property>    <!-- 注入SQL语句文件   用*号代替，那么就可以加载多个xml文件了 -->    <property name="mapperLocations" value="entity/CostDao.xml"></property>    </bean>    <!-- 定义dbcp的DataSource -->    <bean id="dbcp" class="org.apache.commons.dbcp.BasicDataSource">    <property name="username" value="root"></property>    <property name="password" value="root"></property>    <property name="url" value="jdbc:mysql:///jsd1507db"></property>    <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>    </bean>也会生成一个costDAO组件直接就可以用。测试类就是原来的测试类    <!-- 若不是想让全部的dao里的都实现的话就如下。有定义的注解的才会实现 .没有就不会实现-->    <property name="annotationClass" value="dao.annotation.mybatisdao"></property>

即创建个接口的话如果有@mybatisdao 。这个是自己的写的。就是上面value的值的最后。

Dao接口实现可以是框架字段给生成。(就是利用如上的两种方式)
也可以是自己编写利用 SqlSessionTemplate组件

整合流程、总结

先导入包：

导入配置文件

编写对应数据库表的实体类 entity.User

package entity;import java.io.Serializable;public class User implements Serializable{    private Integer id;    private String username;    private String pwd;    private String name;    private String gender;    public Integer getId() {        return id;    }    public void setId(Integer id) {        this.id = id;    }    public String getUsername() {        return username;    }    public void setUsername(String username) {        this.username = username;    }    public String getPwd() {        return pwd;    }    public void setPwd(String pwd) {        this.pwd = pwd;    }    public String getName() {        return name;    }    public void setName(String name) {        this.name = name;    }    public String getGender() {        return gender;    }    public void setGender(String gender) {        this.gender = gender;    }}

然后编写SQL文件

<?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="dao.UserDao">    <select id="findByName" parameterType="String" resultType="entity.User">    select * from user where username=#{username}    </select>    </mapper>

编写接口Mapper

package dao;import entity.User;public interface UserDao {    public User findByName(String name);}

！！！进行配置：

<?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:util="http://www.springframework.org/schema/util"      xmlns:jee="http://www.springframework.org/schema/jee" xmlns:tx="http://www.springframework.org/schema/tx"    xmlns:jpa="http://www.springframework.org/schema/data/jpa" xmlns:mvc="http://www.springframework.org/schema/mvc"    xsi:schemaLocation="        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd        http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-3.2.xsd        http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.2.xsd        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.2.xsd        http://www.springframework.org/schema/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa-1.3.xsd        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd">    <!-- 定义dbcp -->    <bean id="dbcp" class="org.apache.commons.dbcp.BasicDataSource">    <property name="username" value="root"></property>    <property name="password" value="root"></property>    <property name="url" value="jdbc:mysql:///jsd1507db"></property>    <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>    </bean>    <bean id="ssf" class="org.mybatis.spring.SqlSessionFactoryBean">    <!-- 注入dataSource    用连接池获取-->    <property name="dataSource" ref="dbcp"></property>    <!-- 注入SQL语句文件   用*号代替，那么就可以加载多个xml文件了 -->    <property name="mapperLocations" value="sql/UserDao.xml"></property>    </bean>    <bean  class="org.mybatis.spring.mapper.MapperScannerConfigurer">    <!-- 扫描dao下所有接口，批量生成实现 -->    <property name="basePackage" value="dao"></property>    <!-- 自动注入sqlsessionfactory -->    <property name="sqlSessionFactory" ref="ssf"></property>    </bean></beans>

测试类

package test;import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;import dao.UserDao;import entity.User;public class TestUserDao {    public static void main(String[] args){        String conf ="applicationContext.xml";        ApplicationContext ac = new ClassPathXmlApplicationContext(conf);        UserDao userDao = ac.getBean("userDao",UserDao.class);        User user = userDao.findByName("Recar");        System.out.println("pwd: "+user.getPwd());    }}

一定要注意细节配置。还有 <mapper namespace="dao.UserDao">
的namespace一定要是包加接口名！！！