这篇文章主要介绍了Spring5整合Mybatis的使用案例,通过案例来了解Spring5与Mybatis整合的过程,需要的朋友可以参考一下。
1、建立PO
用于对数据库中数据的映射,使程序员更关注于对Java类的使用而不是数据库的操作。
package com.test.mybatis.po;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
/**
* @Description: 用户实体类
* @Author: Janson
* @Date: 2020/5/4 9:35
**/
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Person {
private int id;
private String name;
private int age;
}
2、建立Mapper
package com.test.mybatis.mapper;
import com.test.mybatis.po.Person;
/**
* @Description: 用户操作的映射文件(DAO)
* @Author: Janson
* @Date: 2020/5/4 9:43
**/
public interface PersonMapper {
/**
* 新增用户
* @param person
*/
void insertPerson(Person person);
/**
* 查询用户
* @param name
* @return
*/
Person getPerson(String name);
}
3、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"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
<!--配置数据源-->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://127.0.0.1:3306/user?serverTimezone=Asia/Shanghai" />
<property name="username" value="root" />
<property name="password" value="123456" />
<!--连接池启动时初始值-->
<property name="initialSize" value="1" />
<!--连接池的最大值-->
<property name="maxActive" value="300" />
<!--最大空闲值,当经过一个高峰时间后,连接池可以慢慢将已经用不到的连接慢慢释放一部分,一直减少到maxIdle为止-->
<property name="maxIdle" value="2"/>
<!--最小空闲值,当空闲的连接数少于阀值时,连接池就会预申请一些连接,以免洪峰来时来不及申请-->
<property name="minIdle" value="1"/>
</bean>
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="configLocation" value="classpath:Mybatis-Configuration.xml"></property>
<property name="dataSource" ref="dataSource"></property>
</bean>
<bean id="personMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
<property name="mapperInterface" value="com.test.mybatis.mapper.PersonMapper"></property>
<property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
</bean>
</beans>
4、Mybatis配置文件
<?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>
<typeAlias alias="Person" type="com.test.mybatis.po.Person" />
</typeAliases>
<mappers>
<mapper resource="PersonMapper.xml"></mapper>
</mappers>
</configuration>
5、映射文件
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.test.mybatis.mapper.PersonMapper">
<insert id="insertPerson" parameterType="Person">
insert into person(name, age)
values (#{name}, #{age})
</insert>
<select id="getPerson" resultType="Person" parameterType="java.lang.String">
select * from person where name=#{name}
</select>
</mapper>
6、测试类
package com.test;
import com.test.mybatis.mapper.PersonMapper;
import com.test.mybatis.po.Person;
import lombok.extern.slf4j.Slf4j;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
/**
* @Description: spring mybatis test
* @Author: Janson
* @Date: 2020/5/4 11:09
**/
@Slf4j
public class SpringMybatisTest {
public static void main(String[] args) {
ApplicationContext applicationContext = new ClassPathXmlApplicationContext("application.xml");
PersonMapper personMapper = (PersonMapper) applicationContext.getBean("personMapper");
Person p = new Person();
p.setName("test");
p.setAge(20);
personMapper.insertPerson(p);
Person person = personMapper.getPerson("test");
log.info("person:{}", person);
}
}
7、测试类输出结果
11:22:06.920 [main] INFO com.test.SpringMybatisTest - person:Person(id=3, name=test, age=20)
测试中我们看到,在Spring中使用Mybatis非常方便,用户甚至无法觉察自己正在使用Mybatis,而这一切相对于独立使用Mybatis时必须要做的各种冗余操作来说无非是大大简化了我们的工作量。
如果您觉得有帮助,欢迎收藏点赞哦 ~ ~ 多谢~