Spring-Mybatis整合篇

Spring-Mybatis整合

这里用的是maven项目，所以在配置之前需要先引入依赖。

		<!--引入该依赖会引入spring所依赖的所有jar包-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>5.3.5</version>
        </dependency>
        <!--方便实体类的get、set等方法的组件，用@Data标识就行-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.20</version>
            <scope>provided</scope>
        </dependency>
        <!--打印日志所需的依赖-->
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.12</version>
        </dependency>
        <!-- 连接数据库所需的依赖-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>
        <!-- mybatis的依赖-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.7</version>
        </dependency>
        <!-- mybatis和spring整合所需的依赖-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>2.0.6</version>
        </dependency>

1、整体步骤

• 配置pom.xml依赖
• 新建mybatis-config.xml核心配置文件
• 编写接口，添加一个方法，添加mybatis注解，用于测试mybatis和数据库连接打通
• dao 接口引入mybatis-config.xml中
• 编写测试类，创建SqlSessionFactoryBuilder, SqlSessionFactory, SqlSession ,getMapper();
• 添加spring-mybatis.xml文件
  • 配置数据源
  • 配置sqlSessionFactoryBean
  • 配置DAO接口所在包

<!--配置数据源-->
 <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
     <property name="user" value="${usernamex}"/>
     <property name="password" value="${password}"/>
     <property name="jdbcUrl" value="${url}"/>
     <property name="driverClass" value="${driver}"/>
 </bean>
 <!--配置sqlSessionFactoryBean，给出mybatis配置所在的位置-->
 <bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean" >
     <property name="dataSource" ref="dataSource"/>
     <property name="configLocation" value="mybatis-config.xml"/>
 </bean>

<!--配置Dao所在的包，获取对象-->
 <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
     <property name="sqlSessionFactoryBeanName" value="sessionFactory"></property>
     <property name="basePackage" value="com.wdzl.demo05"/>
 </bean>

2、具体操作

2.1、打通mybatis

2.1.1、核心配置文件mybatis-config.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>
<!--引入存放数据源参数的配置文件，若没有配置文件，
	则在数据源处直接写配置信息即可-->
    <properties resource="db.properties"/>
<!--给包起别名-->
    <typeAliases>
        <package name="com.liu.pojo"></package>
    </typeAliases>
<!--连接数据库的参数-->
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${username}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>
<!--映射文件-->
    <mappers>
        <mapper resource="com/liu/demo05/dao/IUserDao.xml"></mapper>
    </mappers>
</configuration>

2.1.2、IUserDao接口

public interface IUserDao {
	//插入语句
    int save(User user);
}

2,1,3、接口映射文件IUserDao.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
      PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
      "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.liu.demo05.dao.IUserDao">
  <insert id="save" parameterType="user">
      insert into user (user_name,user_password) values (#{user_name},#{user_password})
  </insert>
</mapper>

2.1.4、UserService

@Service
public class UserService {
    @Autowired
    private IUserDao iUserDao;
    public int add(User user){
        return iUserDao.save(user);
    }
    public List<User> select(){
        return iUserDao.select();
    }
}

2.1.5、UserController

@Controller
public class UserController {
    @Autowired
    private UserService userService;
    public int add(){
        User user = new User();
        user.setUser_name("温客行");
        user.setUser_password("456123");
        return userService.add(user);
    }
}

2.1.6、实体类

@Data
public class User {
    private String user_name;
    private String user_password;
}

2.2、配置整合文件

2.2.1、spring-mybatis配置

<?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"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">

    <!--扫描所有的组件-->
    <context:component-scan base-package="com.liu.demo05"></context:component-scan>

    <!--引入配置文件-->
    <context:property-placeholder location="db.properties"/>

    <!--数据源-->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="user" value="${usernamex}"/>
        <property name="password" value="${password}"/>
        <property name="jdbcUrl" value="${url}"/>
        <property name="driverClass" value="${driver}"/>
    </bean>

    <!--sqlSessionFactory工厂-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"></property>
        <!--将对mybatis的配置通知给spring容器-->
        <property name="configLocation" value="mybatis-config.xml"></property>
    </bean>

    <!--将dao接口交给容器管理，生成代理对象，即通过接口生成代理对象，交给容器管理-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
        <!--扫描这个包下的所有接口-->
        <property name="basePackage" value="com.liu.demo05.dao"></property>
    </bean>

</beans>

2.2.2、测试类

public class TestSpringMybatis {
    @Test
    public void test(){
        ApplicationContext context = new ClassPathXmlApplicationContext("spring-mybatis.xml");
        //打印出被容器管理的所有对象
        String[] beanDefinitionNames = context.getBeanDefinitionNames();
        for (String beanDefinitionName : beanDefinitionNames) {
            System.out.println(beanDefinitionName);
        }
        UserController userController = context.getBean("userController", UserController.class);
        userController.add();

    }
}