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

怼烎@ 2022-07-13 08:14 175阅读 0赞

## Spring+Mybatis ##

**mybatis-spring.jar整合包**

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

结合

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

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

当然还有配置文件

还有引入 **mybatis-spring.jar**

在Spring配置中

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

SqlSessionFactoryBean组件，封装了创建SqlSession

![这里写图片描述][SouthEast 1]

用dbcp的连接池

![这里写图片描述][SouthEast 2]

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

即：用这个dbcp连接池的bean

<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接口

<bean id="costDao" class="org.mybatis.spring.mapper.MapperFactoryBean">
        <property name="mapperInterface" value="dao.CostDao"></property>
        
        <property name="sqlSessionFactory" ref="ssf"></property>
        </bean>
    
    
        <bean id="ssf" class="org.mybatis.spring.SqlSessionFactoryBean">
    
    
        
        <property name="dataSource" ref="dbcp"></property>
    
        
    
        <property name="mapperLocations" value="classpatch:entity/*.xml"></property>
        </bean>
    
    
        
    
        <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相同才可以

要把包也写上。

![这里写图片描述][SouthEast 3]

利用MapperFactoryBean

主要是配置文件：

<bean id="costDao" class="org.mybatis.spring.mapper.MapperFactoryBean">
        <property name="mapperInterface" value="dao.CostDao"></property>
        
        <property name="sqlSessionFactory" ref="ssf"></property>
        </bean>
    
    
        <bean id="ssf" class="org.mybatis.spring.SqlSessionFactoryBean">
    
    
        
        <property name="dataSource" ref="dbcp"></property>
    
        
    
        <property name="mapperLocations" value="entity/CostDao.xml"></property>
        </bean>
    
    
        
    
        <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生成

![这里写图片描述][SouthEast 4]

如下配置

<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        
        <property name="basePackage" value="dao"></property>
        
    
        <property name="sqlSessionFactory" ref="ssf"></property>
        </bean>
    
    
    
    
    
        <bean id="ssf" class="org.mybatis.spring.SqlSessionFactoryBean">
    
    
        
        <property name="dataSource" ref="dbcp"></property>
    
        
    
        <property name="mapperLocations" value="entity/CostDao.xml"></property>
        </bean>
    
    
        
    
        <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组件直接就可以用。测试类就是原来的测试类
        
        <property name="annotationClass" value="dao.annotation.mybatisdao"></property>

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

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

## 整合流程、总结 ##

![这里写图片描述][SouthEast 5]

## 先导入包： ##

![这里写图片描述][SouthEast 6]

## 导入配置文件 ##

## 编写对应数据库表的实体类 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">
    
        
        <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">
        
        <property name="dataSource" ref="dbcp"></property>
    
        
    
        <property name="mapperLocations" value="sql/UserDao.xml"></property>
        </bean>
    
    
    
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        
        <property name="basePackage" value="dao"></property>
        
        <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());
    
        }
    
    }

![这里写图片描述][SouthEast 7]

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

[SouthEast]: /images/20220713/c0fc754cf0f84651b464487229e33c59.png
[SouthEast 1]: /images/20220713/130d6b13519a4b55bd882860d88f0aaa.png
[SouthEast 2]: /images/20220713/8821db65c69b4ea4a86133bad8a3dca9.png
[SouthEast 3]: /images/20220713/3cf4f5e2813e4faa83f41629de248827.png
[SouthEast 4]: /images/20220713/84a7050d2d164b7ba9bac62c7a27d52d.png
[SouthEast 5]: /images/20220713/66ffd4c555e941228149fd8dca38c344.png
[SouthEast 6]: /images/20220713/6a82e4aafe854f0d990b2e88f0d4201a.png
[SouthEast 7]: /images/20220713/e4ef00abe525465297f69eab575edcf1.png