五.通用支持」」spring中使用MyBatis

3.MyBatis支持

3-1 POM配置

<dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.4.6</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>2.0.3</version> </dependency>

3-2 配置文件

1.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="dao.UserDao"> <sql id="userColumn"> id, username, password, phone, address </sql> <!-- Spring中通过扫包设置了别名 resultType中可以直接写别名就可以 如果没有设置需要写相对路径Entity.User --> <select id="selectAll" resultType="User"> select <include refid="userColumn"></include> from t_user </select> <insert id="insertUser" parameterType="User"> insert into t_user (username,password,phone,address) values (#{username},#{password},#{phone},#{address}) </insert> </mapper>

2.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> <!-- sqlSessionFactory中整合了mybatis-config的配置 但是mybatis-config的插件任然可以被使用 --> <typeAliases></typeAliases> <mappers></mappers> </configuration>

3.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" xmlns:tx="http://www.springframework.org/schema/tx" 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 http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd"> <!-- 读取propert配置文件 --> <context:property-placeholder location="classpath:dataSource.properties"/> <!-- 设置数据源 --> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <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> <!-- sqlSessionFactory中整合了mybatis-config的配置 --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <!-- 注入数据源 --> <property name="dataSource" ref="dataSource"/> <!-- 配置别名 扫包,在mapper中都可以直接使用类名--> <property name="typeAliasesPackage" value="entity"/> <!-- 注册mapper --> <property name="mapperLocations"> <list> <!--<value>classpath:mapper/UserMapper.xml</value>--> <!-- 支持通配符 --> <value>classpath:mapper/*.xml</value> </list> </property> <!-- 访问config配置 --> <!--<property name="configLocation" value="classpath:mybatis-config.xml"/>--> </bean> <!-- 配置UserDao --> <!-- 方式一:使用MapperFactoryBean生产对应的Mapper --> <!--<bean id="userDao" class="org.mybatis.spring.mapper.MapperFactoryBean">--> <!--&lt;!&ndash; 注入SqlSessionFactory &ndash;&gt;--> <!--<property name="sqlSessionFactory" ref="sqlSessionFactory"/>--> <!--&lt;!&ndash; 配置需要生产的接口是谁 &ndash;&gt;--> <!--<property name="mapperInterface" value="dao.UserDao"/>--> <!--</bean>--> <!-- 方式二:使用扫包的方式创建指定包下所有的Mapper 使用后处理bean对当前的工程做整体的操作 会自动扫描指定包下所有的接口 实现对这些接口的Mapper生产 生产出来的所有的Mapper其bean的id即为当前类名,首字母小写 --> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="dao"/> </bean> <!-- 事务配置 --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <!-- 注入数据源 --> <property name="dataSource" ref="dataSource"/> </bean> <!-- AOP2.X注解事务 --> <tx:annotation-driven transaction-manager="transactionManager"/> <context:component-scan base-package="service"/> </beans>

3-3 测试

package test; import entity.User; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import service.UserService; /** * Author:shixiaojun@itany.com * Date:2020/7/3-9:29 */ public class Test { public static void main(String[] args) { ApplicationContext ac = new ClassPathXmlApplicationContext("classpath:spring.xml"); // 方式一:使用MyBatis原始方式 // SqlSessionFactory factory = (SqlSessionFactory) ac.getBean("sqlSessionFactory"); // SqlSession session = factory.openSession(); // UserDao userDao = session.getMapper(UserDao.class); // 方式二:使用MapperFactoryBean获取对应的Mapper // UserDao userDao = (UserDao) ac.getBean("userDao"); // 方式三:使用扫包方式进行操作,bean的id为类名首字母小写 // UserDao userDao = (UserDao) ac.getBean("userDao"); // List<User> users = userDao.selectAll(); // for(User user : users){ // System.out.println(user); // } User user = new User(); user.setUsername("test4"); user.setPassword("666666"); user.setPhone("13945121238"); user.setAddress("江苏-南京"); // // userDao.insertUser(user); UserService userService = (UserService) ac.getBean("userServiceImpl"); System.out.println(userService); userService.regist(user); } }