七、集成MyBatis
什么是 Mybatis-Spring
*用到的技术:IOC
*MyBatis使用步骤:
- 定义dao接口,UserDao.java
- 定义mapper文件,UserMapper.xml
- 定义mybatis主配置文件,mybatis.xml
- mybatis自带的连接池功能较弱,通常开发会使用独立的连接池,交给Spring来创建
- 独立的连接池类的对象,使用阿里的druid连接池
- SqlSessionFactory对象
- 创建dao
- mybatis自带的连接池功能较弱,通常开发会使用独立的连接池,交给Spring来创建
- 创建dao的代理对象,UserDao dao = SqlSession.getMapper(UserDao.class)
- 通过读取 mybatis的主配置文件来创建SqlSessionFactory对象
- 调用SqlSessionFactory. openSession()方法来获取 SqlSession对象
1、实现步骤
- 创建maven项目
- 加入maven依赖
- spring依赖
- mybatis依赖
- mysql驱动
- spring的事务依赖
- mybatis和spring集成依赖(mybatis官方提供的,用来在spring项目中创建mybatis的SqlSessionFactory、dao对象的)
- 创建实体类
- 创建dao接口及mapper文件
- 创建mybatis主配置文件
- 创建Service接口及实现类,属性包含dao
- 创建spring配置文件(声明mybatis对象交给spring创建)
- 数据源(dataSource)
- SqlSessionFactory
- Dao对象
- 声明自定义的service
- 创建测试类,获取service对象,通过service对象完成对数据库的访问
2、项目结构
pom.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>hom.wang</groupId>
<artifactId>st-06-spring-mybatis</artifactId>
<version>1.0-SNAPSHOT</version>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>1.8</maven.compiler.source>
<maven.compiler.target>1.8</maven.compiler.target>
</properties>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>5.3.18</version>
</dependency>
<!-- spring事务 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>5.3.18</version>
</dependency>
<!-- jdbc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.3.18</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>
<!-- mysql驱动 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.29</version>
</dependency>
<!-- ali的数据库连接池 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.2.6</version>
</dependency>
</dependencies>
<build>
<!--目的是把src/main/java目录下的.xml文件包含到输出结果中(输出到classes目录下)-->
<resources>
<resource>
<!--所在目录-->
<directory>src/main/java</directory>
<!--包括目录下的.properties/.xml文件都会扫描到-->
<includes>
<include>**/*.xml</include>
<!--<include>**/*.properties</include>-->
</includes>
<filtering>false</filtering>
</resource>
</resources>
<!--指定jdk版本-->
<plugins>
<plugin>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.8.1</version>
<configuration>
<source>1.8</source>
<target>1.8</target>
</configuration>
</plugin>
</plugins>
</build>
</project>
data.User.java
package hom.wang.data;
public class User {
private Integer id;
private String name;
private String password;
}
service.UserService.java
package hom.wang.service;
import hom.wang.data.User;
import java.util.List;
public interface UserService {
int insertUser(User user);
List<User> selectUsers();
}
service.impl.UserServiceImpl.java
package hom.wang.service.impl;
import hom.wang.dao.UserDao;
import hom.wang.data.User;
import hom.wang.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
public class UserServiceImpl implements UserService {
private UserDao userDao;
public void setUserDao(UserDao userDao) {
this.userDao = userDao;
}
@Override
public int insertUser(User user) {
return userDao.insertUser(user);
}
@Override
public List<User> selectUsers() {
return userDao.selectUsers();
}
}
dao.UserDao.java
package hom.wang.dao;
import hom.wang.data.User;
import org.apache.ibatis.annotations.Mapper;
import java.util.List;
public interface UserDao {
int insertUser(User user);
List<User> selectUsers();
}
dao.UserMapper.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="hom.wang.dao.UserDao">
<!--namespace根据自己需要创建的的mapper的路径和名称填写-->
<insert id="insertUser">
insert into users values(#{id}, #{name}, #{password})
</insert>
<select id="selectUsers" resultType="hom.wang.data.User">
select id,name,password from users order by id desc
</select>
</mapper>
mybatis.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>
<!--stettings:控制mybatis全局行为-->
<settings>
<!--设置mybatis输出日志-->
<setting name="logImpl" value="STDOUT_LOGGING"/>
</settings>
<!--设置别名-->
<typeAliases>
<!--name:实体类所在包名-->
<package name="hom.wang.data"/>
</typeAliases>
<mappers>
<!-- 配置文件导入全部写在这里 -->
<mapper resource="hom/wang/dao/UserMapper.xml"/>
<!--name:包名(这个包所有.xml文件一次性全部加载)-->
<!--<package name="hom.wang.dao"/>-->
</mappers>
</configuration>
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"
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">
<!--声明数据源DataSource,用于连接数据库-->
<bean id="myDataSource" class="com.alibaba.druid.pool.DruidDataSource"
init-method="init" destroy-method="close">
<property name="url" value="jdbc:mysql://127.0.0.1:3306/ms_user"></property>
<property name="username" value="root"></property>
<property name="password" value="root"></property>
<property name="maxActive" value="20"></property>
</bean>
<!--声明mybatis提供的SqlSessionFactoryBean,用于创建SqlSessionFactory-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="myDataSource"></property>
<!--在spring配置文件中指定其他配置文件路径需要使用 classpath:-->
<property name="configLocation" value="classpath:mybatis.xml"></property>
</bean>
<!--创建dao对象,使用SqlSession的getMapper(UserDao.class)
MapperScannerConfigurer:在内部调用getMapper()生成每个dao接口的代理对象
-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!--指定SqlSessionFactory的id-->
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
<!--指定包名(dao所在的包名)
MapperScannerConfigurer会扫描这个包中的所有接口,
把每个接口都执行一次 getMapper()方法,得到每个接口的dao对象。
创建好的dao对象放入到 spring容器中
-->
<property name="basePackage" value="hom.wang.dao"></property>
</bean>
<bean id="userService" class="hom.wang.service.impl.UserServiceImpl">
<property name="userDao" ref="userDao"></property>
</bean>
</beans>
jdbc.properties
jdbc.url=jdbc:mysql://127.0.0.1:3306/ms_user
jdbc.username=root
jdbc.password=root
jdbc.maxActive=20
applicationContext-pro.xml [变更部分]
<context:property-placeholder location="classpath:jdbc.properties">
</context:property-placeholder>
<!--声明数据源DataSource,用于连接数据库-->
<bean id="myDataSource" class="com.alibaba.druid.pool.DruidDataSource"
init-method="init" destroy-method="close">
<!--使用属性配置文件中的数据,语法:${key}-->
<property name="url" value="${jdbc.url}"></property>
<property name="username" value="${jdbc.username}"></property>
<property name="password" value="${jdbc.password}"></property>
<property name="maxActive" value="${jdbc.maxActive}"></property>
</bean>
MyTest.java
package hom.wang;
import hom.wang.dao.UserDao;
import hom.wang.data.User;
import hom.wang.service.UserService;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import java.util.Arrays;
public class MyTest {
@Test
public void test(){
ApplicationContext ac =
new ClassPathXmlApplicationContext("applicationContext.xml");
//Arrays.stream(ac.getBeanDefinitionNames()).forEach(System.out::println);
for(String name : ac.getBeanDefinitionNames()){
System.out.println("容器中创建的bean:" + name + "--" + ac.getBean(name));
}
}
@Test
public void test_dao(){
//ApplicationContext ac =
// new ClassPathXmlApplicationContext("applicationContext.xml");
ApplicationContext ac =
new ClassPathXmlApplicationContext("applicationContext-pro.xml");
UserService userService = (UserService) ac.getBean("userService");
User user = new User(3, "aaa", "123");
int nums = userService.insertUser(user);
// spring和mybatis整合在一起使用,事务是自动提交的,无需执行Sqlsession.commit()
System.out.println(nums);
userService.selectUsers().stream().forEach(System.out::println);
}
}