Mybatis篇-（七）Mybatis-Spring整合

深碍√TFBOYSˉ_ 2023-10-04 12:46 10阅读 0赞

## 七、Mybatis-Spring整合 ##

> Spring-SpringMVC-Mybatis初整合

*  Mybatis-Spring整合适配包的下载

[点击下载][Link 1]

*  创建一个动态web工程

[点击查看创建过程][Link 2]

*  导入相应的jar包  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ1NDA4Mzkw_size_16_color_FFFFFF_t_70]
 *  引入mybatis的配置

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>
    
    	<settings>
    		<setting name="mapUnderscoreToCamelCase" value="true"/>
    
            
            <setting name="lazyLoadingEnabled" value="true"/>
            <setting name="aggressiveLazyLoading" value="false"/>
    
    		<setting name="cacheEnabled" value="true"/>
    	</settings>
    
    
    	<databaseIdProvider type="DB_VENDOR">
    		
    		<property name="MySQL" value="mysql"/>
    		<property name="Oracle" value="oracle"/>
    		<property name="SQL Server" value="sqlserver"/>
    	</databaseIdProvider>
    
    
    </configuration>

EmployeeMapper.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="com.cvzhanshi.mybatis.dao.EmployeeMapper">
    	
    	<select id="getEmpById" resultType="com.cvzhanshi.mybatis.entity.Employee">
    		select id,last_name lastName,email,gender from employee where id = #{id}
    	</select>
    
    
    	<select id="getEmps" resultType="com.cvzhanshi.mybatis.entity.Employee">
    		select id,last_name,email,gender from employee
    	</select>
    
    	
    	
    	<insert id="addEmp" parameterType="com.cvzhanshi.mybatis.entity.Employee">
    		insert into employee(last_name,email,gender)
    		values(#{lastName},#{email},#{gender})
    	</insert>
    </mapper>

dbconfig.properties

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/mybatis
    jdbc.username=root
    jdbc.password=cvzhanshi

*  SpringMVC配置文件的编写

web.xml中添加

<servlet>
            <servlet-name>spring</servlet-name>
            <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
            <load-on-startup>1</load-on-startup>
        </servlet>
        <servlet-mapping>
            <servlet-name>spring</servlet-name>
            <url-pattern>/</url-pattern>
        </servlet-mapping>

web.xml目录下创建spring-servlet.xml

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"
           xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
           xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
           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
                                http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd">
    
        
        <context:component-scan base-package="com.cvzhanshi.mybatis">
            <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller" />
        </context:component-scan>
    
        
        <context:property-placeholder location="classpath:dbconfig.properties" />
        
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close">
            <property name="url" value="${jdbc.url}" />
            <property name="username" value="${jdbc.username}" />
            <property name="password" value="${jdbc.password}" />
            <property name="driverClassName" value="${jdbc.driver}" />
        </bean>
    
        
        <bean id="dataSourceTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <property name="dataSource" ref="dataSource"></property>
        </bean>
    
        
        <tx:annotation-driven transaction-manager="dataSourceTransactionManager"/>
    
        
        
        <bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
            <property name="dataSource" ref="dataSource"></property>
            
            <property name="configLocation" value="classpath:mybatis-config.xml"></property>
            
            <property name="mapperLocations" value="classpath:mybatis/mapper/*.xml"></property>
        </bean>
    
        
        <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
            <constructor-arg name="sqlSessionFactory" ref="sqlSessionFactoryBean"></constructor-arg>
            <constructor-arg name="executorType" value="BATCH"></constructor-arg>
        </bean>
    
    
        
        <mybatis-spring:scan base-package="com.cvzhanshi.mybatis.dao"/>
    
        
    </beans>

*  整合测试

index.jsp

<a href="getemps">查询所有员工</a>

EmployeeController.java（控制器）

@Controller
    public class EmployeeController {
        
    
        @Autowired
        private EmployeeService employeeService;
    
        @RequestMapping("/getemps")
        public String getEmps(Map<String,Object> map){
        
            List<Employee> emps = employeeService.getEmps();
            map.put("allEmps",emps);
            return "list";
        }
    }

EmployeeService.java（服务层）

@Service
    public class EmployeeService {
        
    
        @Autowired
        private EmployeeMapper employeeMapper;
    
        @Transactional
        public List<Employee> getEmps(){
        
            Employee employee = new Employee(null, "test", "dsadsa", "1");
            //测试事务管理
            //employeeMapper.addEmp(employee);
            //int a  = 1/0;
            return employeeMapper.getEmps();
        }
    
    }

EmployeeMapper.java（dao层）

public interface EmployeeMapper {
        
    
    
    
    	public Employee getEmpById(Integer id);
    
    	public List<Employee> getEmps();
    
    	public void addEmp(Employee employee);
    
    }

Employee.java（entity）

public class Employee implements Serializable {
        
        private Integer id;
        private String lastName;
        private String email;
        private String gender;
        private Department dept;
        ...
        }

list.jsp

<body>
        <table cellpadding="1">
            <tr>
                <th>id</th>
                <th>lastName</th>
                <th>email</th>
                <th>gender</th>
            </tr>
            <c:forEach items="${allEmps}" var="emp">
                <tr>
                    <td>${emp.id}</td>
                    <td>${emp.lastName}</td>
                    <td>${emp.email}</td>
                    <td>${emp.gender}</td>
                </tr>
            </c:forEach>
        </table>
    </body>

运行结果  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ1NDA4Mzkw_size_16_color_FFFFFF_t_70 1]

*  测试事务管理是否可以回滚

只需修改service

@Service
    public class EmployeeService {
        
    
        @Autowired
        private EmployeeMapper employeeMapper;
    
        @Transactional
        public List<Employee> getEmps(){
        
            Employee employee = new Employee(null, "test", "dsadsa", "1");
            //测试事务管理
            employeeMapper.addEmp(employee);
            int a  = 1/0;
            return employeeMapper.getEmps();
        }
    
    }

运行结果  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ1NDA4Mzkw_size_16_color_FFFFFF_t_70 2]

当出现异常时数据回滚，信息并未插入数据库中

[Link 1]: https://mvnrepository.com/artifact/org.mybatis/mybatis-spring/2.0.6?__cf_chl_captcha_tk__=17f7ee68806f13706b7d6df3f94bd1990628c32f-1620444786-0-AYCg5PXjzXWvaSGltZ0LEuStRri9egfMeE8wJxMl9mSt_jFT9-fGkknJBwAJY74y2m8iI4BcnsrIMrZQGYJewkvVURtGo8X0p8MT5D8lY3gC70G0M7GjEYcPhbaRXbstB4P9spqkGePdbIfMZKAscqFmdiTAHxtCM6TbRwNe2exzfFM66t01NvoksvprComAZIjmRi93u6r76jvPbAzPeRQhratCCq5RY2PF_ZPUeX5y_c8FfOQSBsUc2-pX7N-zTyaEAkCekA331_EtHe0unptRfX43JifAWxEfpk2DR1yOxyR5JgmFxwPMAkUdWLG7s3sE9kkR0C-REDiyTlhWP_fmrwql5-6NqgfldDGR0oy_d4WkOTRbhnjWGDnGU2WhZBCRKq-oTanmXy--IzPoPpdai3xBrCyJiDhoQVBz-u67WNNxPVWg-CBF_ejvjsoP46ADfk4xYjX_1buqdYsJJg1C8CzTPtcPFKgcQanUBfQR59y0HV5tak84EiTGAUOK6e-SFVyDM5rHbj5e4-eTtaxLyQxDpyrhtrrkhAe8MpU2Mfa1fo_VCp0CGNac6ZnzH8f9LoK3zdxLRZC3WHQmgDSoayvs09XBeYZGfJKmm358U004DifjqlbUPYAAtQHhKptvy3TNrhRZ10pHXW6tT_fRy__s5By1seThYrABLNLcFq8NMXGvZhNjHY8HmxMsqjksWY8MSVXQtOKAFkPHyUKUea6ZKYWdA2YQCTUm5vms
[Link 2]: https://blog.csdn.net/qq_45408390/article/details/116144065
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ1NDA4Mzkw_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20210508122021943.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ1NDA4Mzkw,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ1NDA4Mzkw_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20210508121954910.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ1NDA4Mzkw,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ1NDA4Mzkw_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20210508121942554.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ1NDA4Mzkw,size_16,color_FFFFFF,t_70