1、整合Spring\MyBatis需要引入MyBatis所需包及Spring所需核心包、spring-aop、spring-jdbc、spring-tx、mybatis-spring包
2、IDEA中使用pom.xml引入上述所需包
pom.xml
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
<scope>test</scope>
</dependency>
<!--以下四个包是Spring框架环境搭建所需包-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>4.3.8.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>4.3.8.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>4.3.8.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-expression</artifactId>
<version>4.3.8.RELEASE</version>
</dependency>
<!--Spring中用到的日志包-->
<dependency>
<groupId>commons-logging</groupId>
<artifactId>commons-logging</artifactId>
<version>1.2</version>
</dependency>
<!--导入MyBatis框架所需包-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.30</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.2.2</version>
</dependency>
<dependency>
<groupId>cglib</groupId>
<artifactId>cglib</artifactId>
<version>3.2.5</version>
</dependency>
<!--Spring+MyBatis整合所需包-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>4.3.8.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>3.1.2.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>3.1.2.RELEASE</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.1</version>
</dependency>
<!--servlet-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>4.3.8.RELEASE</version>
</dependency>
</dependencies>
3、数据库连接信息配置
mybatis配置文件中数据库配置信息:
使用Spring配置文件配置后的数据库连接信息:
<!--创建数据库连接,此处创建的类在包Spring-JDBC中-->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
<property name="url" value="jdbc:mysql://localhost:3306/mybatis"></property>
<property name="username" value="root"></property>
<property name="password" value="root"></property>
</bean>
此处创建数据库连接对象(org.springframework.jdbc.datasource.DriverManagerDataSource)来源包spring-jdbc中:
url、username、password等这些属性都是该类中的属性信息。
4、创建数据库连接信息的工厂类
myBatis中工厂类创建:
Spring中工厂类创建信息,此处需要用到mybatis-spring 的包:
<!--创建SqlSessionFactory工厂类对象,此处所需类在包mybatis-spring.. 中-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
</bean>
此处使用ref属性将数据库连接信息注入到工厂类中,使用工厂类的dataSource属性接收,使工厂类中有数据库连接信息;
工厂类对象(org.mybatis.spring.SqlSessionFactoryBean)创建:
5、映射文件扫描配置
Mybatis配置文件中映射文件扫描配置:
Spring中映射文件扫描配置,此处需要用到mybatis-spring包中的对象:
<!--扫描映射文件配置,此处所需类在包 mybatis-spring 包中-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="Demo01.dao.Interface"></property>
<!--引入工厂类对象,在此处引入主要是要把扫描的映射文件信息添加到工厂类对象类中-->
<property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
</bean>
创建扫描扫描所需的类对象(org.mybatis.spring.mapper.MapperScannerConfigurer),在该类中将需要扫描的包路径赋值给类中的属性basePackage,然后引入上述创建的工厂类对象,赋值给sqlSessionFactory属性,这样工厂类对象中就同时包含了映射文件扫描配置信息。
创建对象位置;
6、测试上述配置:
6.1、实体类
User.java
package Demo01.Model;
import java.util.Date;
public class User {
private Integer id;
private String username;
private char sex;
private String address;
private Date birthday;
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 char getSex() {
return sex;
}
public void setSex(char sex) {
this.sex = sex;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public Date getBirthday() {
return birthday;
}
public void setBirthday(Date birthday) {
this.birthday = birthday;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + '\'' +
", sex=" + sex +
", address='" + address + '\'' +
", birthday=" + birthday +
'}';
}
}
6.2、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="Demo01.dao.Interface.UserInfo">
<select id="queryAllUser" resultType="Demo01.Model.User">
select * from user
</select>
</mapper>
6.3、接口映射文件:
UserInfo.java
package Demo01.dao.Interface;
import Demo01.Model.User;
import java.util.List;
public interface UserInfo {
/**
* 查询所有的用户信息
*/
List<User> queryAllUser();
}
6.4、接口实现类:
UserImpl.java
package Demo01.dao;
import Demo01.Model.User;
import Demo01.dao.Interface.UserInfo;
import java.util.List;
public class UserImpl implements UserInfo {
private UserInfo user;
public UserInfo getUser() {
return user;
}
public void setUser(UserInfo user) {
this.user = user;
}
@Override
public List<User> queryAllUser() {
return user.queryAllUser();
}
}
6.5、使用Spring创建UserImpl实现类对象
在上述中,Spring中已经配置了接口映射文件的信息,因此在此处可以直接使用接口映射文件名称的首字母小写userInfo,并且使用ref属性赋值给实现类中的user属性使用。
<!--创建测试对象,测试上述配置是否正确-->
<bean id="userImpl" class="Demo01.dao.UserImpl">
<!--此处ref引入的是Demo01.dao.UserInfo.java 接口文件-->
<property name="user" ref="userInfo"></property>
</bean>
6.6、测试方法:
@Test
public void TestSpringMyBatis(){
ApplicationContext applicationContext = new ClassPathXmlApplicationContext("ApplicationSpringMyBatis.xml");
UserImpl user = applicationContext.getBean("userImpl", UserImpl.class);
List<User> list = user.queryAllUser();
for (User u:list
) {
System.out.println(u);
}
}
7、扩展介绍:
当使用web端进行开发时,使用tomcat部署项目,可以在webapp/web.xml中配置监听,当项目启动时自动加载Spring的配置文件,信息放在web端的contextConfigLocation容器中。
此处需要使用包spring-web:
<web-app version="3.0" xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd">
<display-name>Archetype Created Web Application</display-name>
<!--配置上下文文件-->
<context-param>
<param-name>contextConfigLocation</param-name>
<!--配置Spring的配置文件-->
<param-value>classpath:ApplicationSpringMyBatis.xml</param-value>
</context-param>
<!--封装一个监听,当使用tomcat启动项目时帮忙加载Spring的配置文件-->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
</web-app>
监听类 – org.springframework.web.context.ContextLoaderListener: