Spring集成Mybatis
Spring集成Mybatis其核心是将SqlSessionFactory交由Spring管理,并由 Spring管理对dao接口的代理实现。 导入mybatisjar包
创建新的ssm项目为例文件结构如下
1.添加jar包(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>org.example</groupId>
<artifactId>ssm</artifactId>
<version>1.0-SNAPSHOT</version>
<properties>
<maven.compiler.source>8</maven.compiler.source>
<maven.compiler.target>8</maven.compiler.target>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>5.2.2.RELEASE</version>
</dependency>
<!-- spring-jdbc-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.2.2.RELEASE</version>
</dependency>
<!-- 阿里数据源-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.10</version>
</dependency>
<!-- mysql驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.16</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.2</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.1</version>
</dependency>
</dependencies>
</project>
2.配置sqlSessionFactiory(spring.xml)
<!-- spring管理生成SqlSessionFactory-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<property name="configLocation" value="classpath:mybatis.xml"></property>
<!-- 指定配置文件-->
<property name="mapperLocations" value="classpath:mappers/*Mapper.xml">
<!-- 指定文件地址-->
</property>
</bean>
生成接口代理(spring.xml)
<!-- spring管理生成接口代理对象-->
<bean id="mapperFactory" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="org.example.dao"></property>
<!-- 对指定包下的接口进行扫描,并生成接口代理的对象-->
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory">
</property>
</bean>
完整spring.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
https://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
">
<!-- 开启注解扫描 对指定包下的注解进行扫描 ,检查添加spring类注解标签的类-->
<context:component-scan base-package="org.example" ></context:component-scan>
<context:property-placeholder location="config.properties"/>
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
<!-- 方法一:通过配置文件配置数据源-->
<!-- <property name="driverClassName" value="com.mysql.jdbc.cj.Driver"/>-->
<!-- <property name="url" value="数据库连接/>-->
<!-- <property name="username" value="root"/>-->
<!-- <property name="password" value="root"/>-->
<!-- <property name="initialSize" value="1"/>-->
<!-- <property name="maxActive" value="1"/>-->
<!-- 方法二:通过注解配置数据源-->
<property name="driverClassName" value="${driverClassName}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
<property name="initialSize" value="${initialSize}"/>
<property name="maxActive" value="${maxActive}"/>
</bean>
<!-- spring管理生成SqlSessionFactory-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<property name="configLocation" value="classpath:mybatis.xml"></property>
<!-- 指定配置文件-->
<property name="mapperLocations" value="classpath:mappers/*Mapper.xml">
<!-- 指定文件地址-->
</property>
</bean>
<!-- spring管理生成接口代理对象-->
<bean id="mapperFactory" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="org.example.dao"></property>
<!-- 对指定包下的接口进行扫描,并生成接口代理的对象-->
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory">
</property>
</bean>
</beans>
注:对应的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>
<settings>
<!-- 打印日志-->
<setting name="logImpl" value="STDOUT_LOGGING"/>
<!-- 开启驼峰命名规则-->
<setting name="mapUnderscoreToCamelCase" value="true"/>
</settings>
<!-- 为类配置起别名-->
<typeAliases>
<!-- 下面别名怎么引用呢? 直接在xml文件中使用别名就可以了-->
<typeAlias type="org.example.model.Admin" alias="Admin"/>
</typeAliases>
</configuration>
3.再service类中注入Dao代理接口
@Service("loginService")
public class LoginService {
@Autowired
LoginDao loginDao;
public Admin login(Admin admin){
return loginDao.login(admin);
}
}
4.测试类
package org.example.test;
import org.example.model.Admin;
import org.example.service.LoginService;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
public class test {
public static void main(String[] args) {
ApplicationContext context = new ClassPathXmlApplicationContext("spring.xml");
Admin admin = context.getBean("admin", Admin.class);
admin.setAccount("admin");
admin.setPassword("111");
LoginService loginService = context.getBean("loginService", LoginService.class);
Admin result = loginService.login(admin);
System.out.println(result);
}
}