<?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:p="http://www.springframework.org/schema/p" xmlns:aop="http://www.springframework.org/schema/aop"

       xmlns:tx="http://www.springframework.org/schema/tx" xmlns:context="http://www.springframework.org/schema/context"

       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd

      http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd

      http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd

      http://www.springframework.org/schema/context  http://www.springframework.org/schema/context/spring-context-4.0.xsd">

    <!--启用扫描机制，并指定扫描对应的包-->

    <context:annotation-config/>

    <context:component-scan base-package="com.ssm.chapter13.*"/>

    <!-- 数据库连接池 -->

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">

        <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>

        <property name="url" value="jdbc:mysql://localhost:3306/springmvc?useSSL=false&amp;serverTimezone=Hongkong&amp;characterEncoding=utf-8&amp;autoReconnect=true"/>

        <property name="username" value="root"/>

        <property name="password" value="123456"/>

        <property name="maxActive" value="255"/>

        <property name="maxIdle" value="5"/>

        <property name="maxWait" value="10000"/>

    </bean>

    <!-- 集成MyBatis -->

    <bean id="SqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

        <property name="dataSource" ref="dataSource"/>

        <!--指定MyBatis配置文件-->

        <property name="configLocation" value="classpath:ssm/chapter13/mybatis-config.xml"/>

    </bean>

    <!-- 事务管理器配置数据源事务 -->

    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

        <property name="dataSource" ref="dataSource"/>

    </bean>

    <!-- 使用注解定义事务 -->

    <tx:annotation-driven transaction-manager="transactionManager"/>

    <!-- 采用自动扫描方式创建mapper bean -->

    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">

        <property name="basePackage" value="com.ssm.chapter13"/>

        <property name="SqlSessionFactory" ref="SqlSessionFactory"/>

        <property name="annotationClass" value="org.springframework.stereotype.Repository"/>

    </bean>

</beans>

package com.ssm.chapter13.pojo;

public class Role {

    private Long id;

    private String roleName;

    private String note;

}

<?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.ssm.chapter13.mapper.RoleMapper">

    <insert id="insertRole" parameterType="com.ssm.chapter13.pojo.Role">

        insert into t_role (role_name, note)

        values (#{roleName}, #{note})

    </insert>

</mapper>

package com.ssm.chapter13.mapper;

import com.ssm.chapter13.pojo.Role;

import org.springframework.stereotype.Repository;

@Repository

public interface RoleMapper {

    public int insertRole(Role role);

}

<?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>

    <!-- 指定映射器路径 -->

    <mappers>

        <mapper resource="ssm/chapter13/mapper/RoleMapper.xml"/>

    </mappers>

</configuration>

public interface RoleService {

    public int insertRole(Role role);

}

public interface RoleListService {

    public int insertRoleList(List<Role> roleList);

}

@Service

public class RoleServiceImpl implements RoleService {

    @Autowired

    private RoleMapper roleMapper;

    @Override

    @Transactional(propagation = Propagation.REQUIRES_NEW, isolation = Isolation.READ_COMMITTED)

    public int insertRole(Role role) {

        return roleMapper.insertRole(role);

    }

}

@Service

public class RoleListServiceImpl implements RoleListService {

    Logger log = Logger.getLogger(RoleListServiceImpl.class);

    @Autowired

    private RoleService roleService;

    @Override

    @Transactional(propagation = Propagation.REQUIRED, isolation = Isolation.READ_COMMITTED)

    public int insertRoleList(List<Role> roleList) {

        int count = 0;

        for (Role role : roleList) {

            try {

                count += roleService.insertRole(role);

            } catch (Exception ex) {

                log.info(ex);

            }

        }

        return count;

    }

}

public class Chapter13Main {

    public static void main(String[] args) {

        ApplicationContext ctx = new ClassPathXmlApplicationContext("ssm/chapter13/spring-cfg.xml");

        RoleListService roleListService = ctx.getBean(RoleListService.class);

        List<Role> roleList = new ArrayList<Role>();

        for (int i = 1; i <= 2; i++) {

            Role role = new Role();

            role.setRoleName("role_name_" + i);

            role.setNote("note_" + i);

            roleList.add(role);

        }

        int count = roleListService.insertRoleList(roleList);

        System.out.println(count);

    }

}