Spring之整合Mybatis

一、

 

 Spring-Mybatis.jar下载官网：https://mvnrepository.com/artifact/org.mybatis/mybatis-spring/1.3.1

所需jar包：

 

创建applicationContext.xml文件：

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

	<bean id="config" class="org.springframework.beans.factory.config.PreferencesPlaceholderConfigurer">
		<property name="locations">
			<array>
				<value>classpath:db.properties</value>
			</array>
		</property>
	</bean>

	<bean id="studentMapper" class="org.ruangong.dao.impl.StudentDaoImpl">
		<property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
	</bean>
	
	<bean id="studentService" class="org.ruangong.service.impl.StudentServiceImpl">
		<property name="studentMapper" ref="studentMapper"></property>
	</bean>

<!-- 配置数据库信息（替代mybatis的配置文件conf.xml） -->
	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
		<property name="driverClassName" value="${driver}"></property>
		<property name="url" value="${url}"></property>
		<property name="username" value="${username}"></property>
		<property name="password" value="${password}"></property>
		<property name="maxActive" value="${maxActive}"></property>
		<property name="maxIdle" value="${maxIdle}"></property>
	</bean>
	
<!-- 在SpringIoc容器中 创建Mybatis的核心类sqlsessionfactory -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource"></property>
		<!-- 加载Mybatis配置文件 -->
		<property name="configLocation" value="classpath:conf.xml"></property>
	</bean>
</beans>

　　

 

 StudentMapper.xml:

<?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="org.ruangong.mapper.StudentMapper">
	 <select id="queryPersonById" resultType="org.ruangong.entity.Student" parameterType="int">
	 	select * from person where id = #{id}
	 </select>
	 <insert id="addStudent" parameterType="org.ruangong.entity.Student">
	 	insert into student(id,name,age) values(#{stuNo},#{stuName},#{stuAge})
	 </insert>
</mapper>

　　StudentMapper.java:

package org.ruangong.mapper;

import org.ruangong.entity.Student;

public interface StudentMapper {
	public void addStudent(Student student);
}

　StudentDaoImpl.java:

package org.ruangong.dao.impl;

import org.apache.ibatis.session.SqlSession;
import org.mybatis.spring.support.SqlSessionDaoSupport;
import org.ruangong.entity.Student;
import org.ruangong.mapper.StudentMapper;

public class StudentDaoImpl extends SqlSessionDaoSupport implements StudentMapper{

	@Override
	public void addStudent(Student student) {
		// TODO Auto-generated method stub
		SqlSession session = super.getSqlSession();
		StudentMapper stuDao = session.getMapper(StudentMapper.class);
		stuDao.addStudent(student);
	}

}

　实体类student.java:

package org.ruangong.entity;

public class Student {
	private int StuNo;
	private String StuName;
	private int stuAge;
	public int getStuNo() {
		return StuNo;
	}
	public void setStuNo(int stuNo) {
		StuNo = stuNo;
	}
	public String getStuName() {
		return StuName;
	}
	public void setStuName(String stuName) {
		StuName = stuName;
	}
	public int getStuAge() {
		return stuAge;
	}
	public void setStuAge(int stuAge) {
		this.stuAge = stuAge;
	}
}

　　IStudentService.java:

package org.ruangong.service;

import org.ruangong.entity.Student;

public interface IStudentService {
	public void addStudent(Student student);
}

　　StudentServiceImpl.java:

package org.ruangong.service.impl;

import org.ruangong.entity.Student;
import org.ruangong.mapper.StudentMapper;
import org.ruangong.service.IStudentService;

public class StudentServiceImpl implements IStudentService{
	private StudentMapper studentMapper;
	@Override
	public void addStudent(Student student) {
		// TODO Auto-generated method stub
		studentMapper.addStudent(student);
	}
	public void setStudentMapper(StudentMapper studentMapper) {
		this.studentMapper = studentMapper;
	}

}

　　conf.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>
	<!-- 数据库信息 -->
	
	<!-- 加载映射文件信息 -->
	<mappers>
		<mapper resource="org/ruangong/mapper/studentMapper.xml"/>
	</mappers>
</configuration>

　　db.properties:

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/jcc?characterEncoding=UTF-8
username=root
password=
maxIdle=1000
maxActive=500

　Test.java:

package org.ruangong.test;

import org.ruangong.entity.Student;
import org.ruangong.service.IStudentService;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

public class Test {
public static void main(String []args){
	ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
	IStudentService studentService = (IStudentService)context.getBean("studentService");
	Student student = new Student();
	student.setStuNo(20173681);
	student.setStuName("靳晨晨");
	student.setStuAge(21);
	studentService.addStudent(student);
}
}

　　

 在applicationContext.xml文件中配置mapper.xml路径，可以删除conf.xml文件：

-- 在SpringIoc容器中 创建Mybatis的核心类sqlsessionfactory -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource"></property>
		 <!-- 加载Mybatis配置文件 -->
		<!-- <property name="configLocation" value="classpath:conf.xml"></property> -->
		<!-- 加载mapper.xml路径 -->
		<property name="mapperLocations" value="org/ruangong/mapper/*.xml"></property>
	</bean>

　省略StudentDaoImpl实现类。

在applicationContext.xml文件中将

<!-- 第一种方式生成mapper对象 -->
	<!-- <bean id="studentMapper" class="org.ruangong.dao.impl.StudentDaoImpl">
		<property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
	</bean> -->
	
	<!-- 第二种方式生成Mapper对象 -->
	<bean id="studentMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
		<property name="mapperInterface" value="org.ruangong.mapper.StudentMapper"></property>
		<property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
	</bean>

　　换第二种方式。缺点：每个mapper都需要配置一次。

如果有多个mapper.xml文件配置多个mapper对象很费劲，所以我们使用第三种方法。

<!-- 第一种方式生成mapper对象 -->
	<!-- <bean id="studentMapper" class="org.ruangong.dao.impl.StudentDaoImpl">
		<property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
	</bean> -->
	
	<!-- 第二种方式生成Mapper对象 -->
	<!-- <bean id="studentMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
		<property name="mapperInterface" value="org.ruangong.mapper.StudentMapper"></property>
		<property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
	</bean> -->
	
	<!-- 第三种方式生成Mapper对象  	约定：批量产生Mapper对在SpringIOC中的id值默认就是接口名 -->
	<bean id="Mappers" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
		<!-- 指定批量产生哪个包中的mapper对象 -->
		<property name="basePackage" value="org.ruangong.mapper"></property>
	</bean>

　　注意第三种方式可以省略StudentDaoImpl.java文件。