Spring 整合Mybatis的配置文件 太过爱你忘了你带给我的痛 2021-09-21 16:02 277阅读 0赞 ### 目录 ### * 编写配置文件 * * mybatis-config.xml * spring-dao.xml * sqlSession 注入到实现类中的两种方式 * * 第一种 set方法注入类 * 第二种 继承 SqlSessionDaoSupport * 测试 * 依赖 # 编写配置文件 # ## mybatis-config.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> <typeAliases> <package name="com.pro.pojo"/> </typeAliases> </configuration> ## spring-dao.xml ## 注意这里需要绑定上面的 mybatis-config.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" xsi:schemaLocation="http://www.springframework.org/schema/beans https://www.springframework.org/schema/beans/spring-beans.xsd"> <!--1. 配置数据源替换mybatis数据源 dataSource: 使用Spring的数据源替换Mybatis的配置 c3p0 dbcp druid 我们这里使用Spring提供的JDBC: org.springframework.jdbc.datasource.DriverManagerDataSource --> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=true&useUnicode=true&characterEncoding=utf8"/> <property name="username" value="root"/> <property name="password" value="123456"/> </bean> <!--2. SqlSessionFactory 关联 Mybatis--> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource"/> <!--关联/绑定 mybatis 配置文件--> <property name="configLocation" value="classpath:mybatis-config.xml"/> <!--绑定 Mapper.xml, 也可以放到 mybatis-config.xml 中去做--> <property name="mapperLocations" value="classpath:com/pro/dao/*.xml"/> </bean> <!--3. 注册 SqlSessionTemplate 关联 SqlSessionFactory SqlSessionTemplate: 就是我们使用的 sqlSession --> <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate"> <!--只能使用构造器注入, 因为它没有set方法--> <constructor-arg index="0" ref="sqlSessionFactory"/> </bean> <!--4. 绑定bean, 注入参数--> <!--set注入参数--> <bean id="userMapper" class="com.pro.dao.UserMapperImpl"> <property name="sqlSession" ref="sqlSession"/> </bean> <!--继承 SqlSessionDaoSupport 类--> <bean id="userMapper2" class="com.pro.dao.UserMapperImpl2"> <!--sqlSessionFactory 和 sqlSessionTemplate 两个参数选一个注入就行--> <!--<property name="sqlSessionTemplate" ref="sqlSession"/>--> <property name="sqlSessionFactory" ref="sqlSessionFactory"/> </bean> </beans> # sqlSession 注入到实现类中的两种方式 # ## 第一种 set方法注入类 ## 这个类需要在Spring容器中注入 public class UserMapperImpl implements UserMapper { // 在原来我们使用 sqlSession, 现在都使用 sqlSessionTemplate private SqlSessionTemplate sqlSession; public void setSqlSession(SqlSessionTemplate sqlSession) { this.sqlSession = sqlSession; } @Override public List<User> getUserList() { UserMapper mapper = sqlSession.getMapper(UserMapper.class); return mapper.getUserList(); } } ## 第二种 继承 SqlSessionDaoSupport ## 这个类需要在Spring容器中注入 public class UserMapperImpl2 extends SqlSessionDaoSupport implements UserMapper { @Override public List<User> getUserList() { // 继承 SqlSessionDaoSupport 类之后, 可以直接拿到 getSqlSession() SqlSession sqlSession = getSqlSession(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); return mapper.getUserList(); } } # 测试 # import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; public class MyTest { @Test public void getUserList() throws IOException { ApplicationContext context = new ClassPathXmlApplicationContext("spring-dao.xml"); // 测试set注入 // UserMapper userMapper = context.getBean("userMapper", UserMapper.class); // 测试继承 SqlSessionDaoSupport 类 UserMapper userMapper = context.getBean("userMapper2", UserMapper.class); for (User user : userMapper.getUserList()) { System.out.println(user); } } } # 依赖 # <dependencies> <!-- 单元测试--> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.13</version> </dependency> <!-- mysql驱动--> <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.2</version> </dependency> <!-- spring相关依赖--> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>5.2.0.RELEASE</version> </dependency> <!--spring 操作数据库需要一个 spring-jdbc 的包--> <!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>5.2.0.RELEASE</version> </dependency> <!-- aspectJ AOP 织入器--> <dependency> <groupId>org.aspectj</groupId> <artifactId>aspectjweaver</artifactId> <version>1.9.4</version> </dependency> <!-- mybatis-spring整合包--> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>2.0.2</version> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <version>1.18.10</version> </dependency> </dependencies> <build> <resources> <resource> <directory>src/main/java</directory> <includes> <include>**/*.properties</include> <include>**/*.xml</include> </includes> <filtering>true</filtering> </resource> </resources> </build>
还没有评论,来说两句吧...