Spring整合MyBatis

Spring整合MyBatis

1. 整合前的各部分
2. jar包
3. 项目3

整合前：

spring-context
mybatis
mysql-jdbc
整合包:
mybatis-spring
spring-jdbc
druid数据源

MyBatis

主配置文件：
	实体类别名
	JDBC数据源四大参数
	mapper扫描:扫描映射文件所在的包
映射文件：
API
	SqlSessionFactory	
	SqlSession
	.commit()

需要的jar包

<dependencies>
        <!--单元测试-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.9</version>
            <scope>test</scope>
        </dependency>
        <!--mysql-jdbc驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.35</version>
        </dependency>
        <!--mybatis核心包-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.2</version>
        </dependency>
        <!--log4j-->
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.12</version>
        </dependency>
        <!--日志适配包-->
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-log4j12</artifactId>
            <version>1.7.21</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.2.15.RELEASE</version>
        </dependency>
        <!-- Spring整合MyBatis的核心包 -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>2.0.2</version>
        </dependency>
        <!--Spring框架的JDBC支持-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.2.15.RELEASE</version>
        </dependency>
        <!--第三方数据源Druid,C3P0,DBCP-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.10</version>
        </dependency>

    </dependencies>

spring配置文件

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

        <!--配置SqlSessionFactoryBean,创建SqlSessionFactory对象-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!--实体类别名配置-->
        <property name="typeAliasesPackage" value="com.woniuxy.entity" />
        <property name="dataSource" ref="dataSource" />
    </bean>

    <!--配置数据源  DBCP C3P0 -->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="${jdbc.className}" />
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.user}" />
        <property name="password" value="${jdbc.password}" />
    </bean>

    <context:property-placeholder location="classpath:db.properties" />

    <!--MapperScannerConfigurer，创建sqlSession，扫描basePackage对应的包，
        自动生产Doa接口的实现类,默认的id就是   StudentDao      studentDao
    -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.woniuxy.dao" />
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />

    </bean>

</beans>

Mybatis的主配置文件和工具类不需要了

测试类

public class StudentDaoTest {
	
	StudentDao studentDao;

	
	
	@Before
	public void setup() {
		ApplicationContext ac=new ClassPathXmlApplicationContext("applicationContext.xml");
		studentDao= (StudentDao) ac.getBean("studentDao");
	}

Service

public class StudentServiceImpl  implements StudentService {

    private StudentDao studentDao;

    public void setStudentDao(StudentDao studentDao) {
        this.studentDao = studentDao;
    }

    @Override
    public void addStduent(Student student) {
        studentDao.insertStudent(student);
    }

    @Override
    public Student getStudentById(int id) {
        return studentDao.selectStudentById(id);
    }
}

<bean id="studentService" class="com.woniuxy.service.impl.StudentServiceImpl">
        <property name="studentDao" ref="studentDao" />
    </bean>