Spring-Mybaits整合
先上核心配置总结模版套用就完事了
将 SqlSessionFactory、Mapper、Service 都交给SpringIOC容器管理
导入依赖
applicationContext.xml配置 (mybatis全部拿到applicationContext里面)
开启Spring注解扫描
<context:component-scan base-package="com.ying"/>
引入外部的配置文件
<context:property-placeholder location="classpath:db.properties"/>
创建Druid连接池对象
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
druid连接配置
SqlSessionFactoryBean对象 处理Mybatis相关对象
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
属性注入
注入数据源(必须)
<property name="dataSource" ref="dataSource"/>
mybatis配置
mybatis核心配置文件
- 第一种:配置一个mybatis核心配置文件,然后在这里引用(在xml配置文件中引入其他的配置文件需要加上classpath:)
<property name="configLocation" value="classpath:mybatis-config.xml"></property>
- 第二种:mybatis的核心配置文件可以不用写了,直接在spring中进行属性注入
类型别名配置
<property name="typeAliasesPackage" value="com.ying.pojo"/>
mapper映射文件配置
<property name="mapperLocations" value="com/ying/mapper/*.xml"/>
关联com/ying/mapper文件夹下所有的mapper映射文件settings配置
<property name="configuration" ref="configuration"/>
plugins配置
<property name="plugins">
<bean class="com.github.pagehelper.PageInterceptor">
</bean></property>
configuration <bean…>
<bean id="configuration" class="org.apache.ibatis.session.Configuration">
- 日志配置 开启mybatis自带的日志
<property name="logImpl" value="org.apache.ibatis.logging.stdout.StdOutImpl"/>
- 全局懒加载配置
<property name="lazyLoadingEnabled" value="true"></property>
MapperScannerConfigurer
将所有的Mapper添加到SpringIOC容器中
Mapper是接口(接口不能创建对象):Mybatis的底层用到了动态代理技术,会创建Mapper接口的实现类
MapperScannerConfigurer:将所有的Mapper接口的实现类添加到SpringIoc容器中
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <!--如果以后Mapper映射文件与Mapper接口在同一级目录,那么就无需指定--> <property name="basePackage" value="com.sun.mapper"/> </bean>
以下是细分示例
Spring与Mybaits
1.1 导入依赖
<dependencies>
<!-- 持久层依赖 数据库相关 -->
<!-- 数据库驱动依赖 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
<!-- Mybatis依赖 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.4</version>
</dependency>
<!-- druid连接池依赖 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.10</version>
</dependency>
<!-- Spring依赖 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>5.3.6</version>
</dependency>
<!-- Spring和Mybatis整合依赖 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.2</version>
</dependency>
<!-- Spring整合持久层依赖 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.3.6</version>
</dependency>
<!-- 其他依赖 -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.12</version>
</dependency>
</dependencies>
1.2 配置SqlSessionFactory
<!-- SqlSessionFactoryBean用来整合Mybatis的类 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 配置mybatis数据源连接池 -->
<property name="dataSource" ref="dataSource"/>
<!-- 配置mybatis的配置信息 -->
<!-- <property name="typeAliasesPackage" value="com.ying.pojo"/> -->
<!-- <property name="mapperLocations" value="classpath:com/ying/mapper/*.xml"/> -->
<!-- 加载mybatis的配置文件 -->
<property name="configLocation" value="classpath*:mybatis-config.xml"/>
</bean>
1.3 配置MapperScannerConfigurer
管理创建Mapper对象,存入工厂管理
扫描所有Mapper接口,去构建Mapper实现
将Mapper实现存入工厂管理
Mapper实现对象在工厂中的id是:“首字母小写的-接口的类名”,
例如:UseMapper==>userMapper , OrderMapper==>orderMapper
<!--
MapperScannerConfigurer扫描所有的mapper映射文件,
并且将Mapper接口创建并交给Spring容器 (要保证接口和映射的名称一致、路径一致)
-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.ying.mapper"/>
</bean>
1.4 配置Service
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserMapper mapper;
@Override
public List<User> getAll() {
return mapper.getAll();
}
}
1.5 测试
public class SMTest {
@Test
public void test01(){
ApplicationContext ac =
new ClassPathXmlApplicationContext("applicationContext.xml");
UserServiceImpl userServiceImpl = ac.getBean("userServiceImpl", UserServiceImpl.class);
List<User> userList = userServiceImpl.getAll();
userList.stream().forEach(System.out::println);
}
}
2 Spring细节补充
2.1 导入外部配置文件
db.propertis
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql:///java2101
jdbc.username=root
jdbc.password=123456
applicationContext.xml
<!-- 引入外部的配置文件 -->
<context:property-placeholder location="classpath:db.properties"/>
<!-- 获取外部的配置文件中的属性值 格式:${key} 注意:不能使用username -->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
<property name="driverClassName" value="${jdbc.driver}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</bean>
2.2 将配置文件分离
applicationContext.xml Spring主配置文件
applicationContext-dao.xml Spring整合Mybatis的配置文件
applicationContext-xxx.xml 未来Spring整合其他技术的配置文件
applicationContext.xml
<!-- 引入其他Spring的配置文件 -->
<!--整合Mybatis -->
<import resource="classpath:applicationContext-dao.xml"/>
applicationContext-dao.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">
<!-- 引入外部的配置文件 -->
<context:property-placeholder location="classpath:db.properties"/>
<!-- Spring整合Mybatis -->
<!-- 配置Druid数据源 -->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
<property name="driverClassName" value="${jdbc.driver}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</bean>
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 配置数据源 -->
<property name="dataSource" ref="dataSource"/>
<!-- mybatis的配置 -->
<property name="configLocation" value="classpath:mybatis-config.xml"/>
</bean>
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.ying.mapper"/>
</bean>
</beans>
2.3 Spring整合Mybatis后的日志
Mybatis核心配置文件
<configuration>
<!-- 设置mybatis日志 -->
<settings>
<setting name="logImpl" value="STDOUT_LOGGING"/>
</settings>
<!-- 设置类型别名 -->
<typeAliases>
<package name="com.ying.pojo"/>
</typeAliases>
</configuration>
Spring配置文件中引入
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 配置数据源 -->
<property name="dataSource" ref="dataSource"/>
<!-- mybatis的配置 -->
<property name="configLocation" value="classpath:mybatis-config.xml"/>
</bean>
3 Spring整合Junit
导入依赖
<!-- Spring单元测试依赖 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>5.3.6</version>
</dependency>
测试类
@RunWith(SpringJUnit4ClassRunner.class) //使用Spring来执行单元测试
@ContextConfiguration("classpath:applicationContext.xml") //加载spring的配置文件
public class SMTest {
@Autowired
private UserService userService;
@Test
public void test01(){
List<User> userList = userService.getAll();
userList.stream().forEach(System.out::println);
}
}
4 纯注解开发
常见的注解(还有上面的几个注解):
- @Configuration 表示当前这个类是Spring配置类
- @ComponentScan 扫描指定包上的注解
- @Import 引入其他的配置类
- @Bean 将创建的对象添加到SpringIOC容器
- @Value 将值注入到属性中
- @PropertySource 导入外部的Properties配置文件键
主配置类
@Configuration // 表示当前这个类是一个spring配置类(相当于applicationContext.xml)
@ComponentScan("com.ying") //开启注解扫描
@Import(MybatisConfiguration.class) //引入其他的spring的配置类
public class SpringConfiguration {
}
Spring整合Mybatis配置类
@Configuration
@PropertySource(value={"classpath:db.properties"})
@Import(MapperScannerConfigurerConfiguration.class)
public class MybatisConfiguration {
@Value("${jdbc.driver}") //获取配置文件中值,并且注入变量
private String driver;
@Value("${jdbc.url}")
private String url;
@Value("${jdbc.username}")
private String username;
@Value("${jdbc.password}")
private String password;
@Bean("dataSource") //将当前方法返回的对象交给Spring容器
public DataSource getDataSource(){
DruidDataSource druidDataSource = new DruidDataSource();
druidDataSource.setDriverClassName(driver);
druidDataSource.setUrl(url);
druidDataSource.setUsername(username);
druidDataSource.setPassword(password);
return druidDataSource;
}
@Bean
public SqlSessionFactoryBean getSqlSessionFactoryBean(DataSource dataSource){
SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
//设置数据源
sqlSessionFactoryBean.setDataSource(dataSource);
//设置Mybatis的信息
sqlSessionFactoryBean.setConfigLocation(new ClassPathResource("mybatis-config.xml"));
return sqlSessionFactoryBean;
}
}
@Configuration
public class MapperScannerConfigurerConfiguration {
@Bean
public MapperScannerConfigurer getMapperScannerConfigurer(){
MapperScannerConfigurer mapperScannerConfigurer = new MapperScannerConfigurer();
mapperScannerConfigurer.setBasePackage("com.ying.mapper");
return mapperScannerConfigurer;
}
}
或者直接使用@MapperScan(“com.ying.mapper”)注解代替MapperScannerConfigurer类
@Configuration
@PropertySource(value={"classpath:db.properties"})
@MapperScan("com.ying.mapper")
public class MybatisConfiguration {
@Value("${jdbc.driver}") //获取配置文件中值,并且注入变量
private String driver;
@Value("${jdbc.url}")
private String url;
@Value("${jdbc.username}")
private String username;
@Value("${jdbc.password}")
private String password;
@Bean("dataSource") //将当前方法返回的对象交给Spring容器
public DataSource getDataSource(){
DruidDataSource druidDataSource = new DruidDataSource();
druidDataSource.setDriverClassName(driver);
druidDataSource.setUrl(url);
druidDataSource.setUsername(username);
druidDataSource.setPassword(password);
return druidDataSource;
}
@Bean
public SqlSessionFactoryBean getSqlSessionFactoryBean(DataSource dataSource){
SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
//设置数据源
sqlSessionFactoryBean.setDataSource(dataSource);
//设置Mybatis的信息
sqlSessionFactoryBean.setConfigLocation(new ClassPathResource("mybatis-config.xml"));
return sqlSessionFactoryBean;
}
}