Spring整合myBatis(传统方式)

一 概述

• 需要从spring容器中获取sqlFactorySession对象

• 传统方式通过调用sqlSession定义的方法来操作数据库

• Spring要管理的对象：sqlSessionFactory（org.mybatis.spring.SqlSessionFactoryBean位于整合包）

二 案例代码

1.导jar包

    - spring相关
    - mybatis相关
    - spring和mybatis整合包
    - 数据库驱动包
    - 连接池jar包

2.配置文件

• spring的配置文件applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"
xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
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-4.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">

    <!-- 加载配置文件 -->
    <context:property-placeholder location="classpath:db.properties" />
    <!-- 配置dataSource数据库连接池 -->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
    destroy-method="close">
        <property name="driverClassName" value="${jdbc.driver}" />
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.username}" />
        <property name="password" value="${jdbc.password}" />
        <property name="maxActive" value="10" />
        <property name="maxIdle" value="5" />
    </bean>

    <!-- mapper配置 -->
    <!-- 让spring管理sqlsessionfactory 使用mybatis和spring整合包中的 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- 数据库连接池 -->
            <property name="dataSource" ref="dataSource" />
        <!-- 加载mybatis的全局配置文件 -->
        <property name="configLocation" value="classpath:myBatis/SqlMapConfig.xml" />
    </bean>

    <bean id="userDao" class="com.itheima.dao.UserDao">
        <property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
    </bean>
</beans>

• 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>
        <package name="com.itheima.pojo"/>
    </typeAliases>

    <!-- 加载映射文件 -->
    <mappers>
        <mapper resource="sqlMap/User.xml"/>
    </mappers>
</configuration>

• 映射文件(写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="com.itheima.mapperTest.UserDao">

    <select id="findUserWithOrders" resultType="User">
        SELECT 
            *
        from user 
    </select>
</mapper>

3.写代码

• (1)pojo类

import java.io.Serializable;
import java.util.Date;
import java.util.List;

public class User implements Serializable {
    private Integer id;
    private String username;// 用户姓名
    private String sex;// 性别
    private Date birthday;// 生日
    private String address;// 地址
    private List<Orders> orders;
    public List<Orders> getOrders() {
        return orders;
    }
    public void setOrders(List<Orders> orders) {
        this.orders = orders;
    }
    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 getSex() {
        return sex;
    }
    public void setSex(String sex) {
        this.sex = sex;
    }
    public Date getBirthday() {
        return birthday;
    }
    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }
    public String getAddress() {
        return address;
    }
    public void setAddress(String address) {
        this.address = address;
    }
    @Override
    public String toString() {
        return "User [id=" + id + ", username=" + username + ", sex=" + sex
                + ", birthday=" + birthday + ", address=" + address + "]";
    }

}

• 2.dao层代码
• 接口定义

import java.util.List;

import com.itheima.pojo.User;

public interface IUserDao {
    public List<User> findAllUser();
}

• 实现类

package com.itheima.dao;

import java.util.List;

import org.apache.ibatis.session.SqlSession;
import org.mybatis.spring.support.SqlSessionDaoSupport;

import com.itheima.pojo.User;

public class UserDao extends SqlSessionDaoSupport implements IUserDao{ //1. 需要继承SqlSessionDaoSupport

    @Override
    public List<User> findAllUser() {
        SqlSession session = this.getSqlSession();  // 父类的sqlSessionFactory变量，需要依赖注入，配置文件配置
        List<User> list = session.selectList("findUserWithOrders"); //传统方式调用sqlSession定义的方法来操作数据库
        //2. 不能关闭SqlSession，让spring容器来完成
        //session.close();
        return list;
    }

}

4.测试

package test;

import java.util.List;

import org.junit.Before;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.itheima.dao.UserDao;
import com.itheima.pojo.User;

public class SmTest {

    private ApplicationContext applicationContext;

    @Before
    public void init() throws Exception {
        //初始化spring容器
        applicationContext = new ClassPathXmlApplicationContext("classpath:spring/applicationContext.xml");
    }

    @Test
    public void testSM01(){
        UserDao userDao = applicationContext.getBean(UserDao.class);
        List<User> list = userDao.findAllUser();
        for (User user : list) {
            System.out.println(user.getUsername());
        }
    }
}