{"id":248,"date":"2026-05-05T21:57:58","date_gmt":"2026-05-05T13:57:58","guid":{"rendered":"https:\/\/larkdrop.cafe\/?p=248"},"modified":"2026-05-22T16:51:39","modified_gmt":"2026-05-22T08:51:39","slug":"spring-mybatis","status":"publish","type":"post","link":"https:\/\/larkdrop.cafe\/index.php\/2026\/05\/05\/spring-mybatis\/","title":{"rendered":"Spring MyBatis"},"content":{"rendered":"\n

Spring\u6574\u5408MyBatis<\/h2>\n\n\n\n

\u5f15\u5165\u4f9d\u8d56<\/h3>\n\n\n\n
<dependencies>\n    <!-- Spring 6.x \u5bf9\u5e94\u4f7f\u7528 MyBatis-Spring 3.0.x -->\n    <dependency>\n        <groupId>org.mybatis<\/groupId>\n        <artifactId>mybatis-spring<\/artifactId>\n        <version>3.0.5<\/version>\n    <\/dependency>\n\n    <!-- Spring JDBC -->\n    <dependency>\n        <groupId>org.springframework<\/groupId>\n        <artifactId>spring-jdbc<\/artifactId>\n        <version>6.2.15<\/version>\n    <\/dependency>\n\n    <!-- \u6570\u636e\u5e93\u8fde\u63a5\u6c60 -->\n    <dependency>\n        <groupId>com.alibaba<\/groupId>\n        <artifactId>druid<\/artifactId>\n        <version>1.2.11<\/version>\n    <\/dependency>\n\n    <!-- MySQL\u9a71\u52a8 -->\n    <dependency>\n        <groupId>mysql<\/groupId>\n        <artifactId>mysql-connector-java<\/artifactId>\n        <version>8.0.33<\/version>\n    <\/dependency>\n\n    <!-- MyBatis -->\n    <dependency>\n        <groupId>org.mybatis<\/groupId>\n        <artifactId>mybatis<\/artifactId>\n        <version>3.5.14<\/version>\n    <\/dependency>\n<\/dependencies><\/code><\/pre>\n\n\n\n
\u914d\u7f6e\u7c7b<\/h3>\n\n\n\n
@Configuration\n@ComponentScan(\"com.example\")\n@MapperScan(\"com.example.mapper\")  \/\/ \u626b\u63cfMapper\u63a5\u53e3\npublic class AppConfiguration {\n\n    \/**\n     * \u6ce8\u518c\u6570\u636e\u6e90\n     *\/\n    @Bean\n    public DataSource dataSource() {\n        DruidDataSource dataSource = new DruidDataSource();\n        dataSource.setDriverClassName(\"com.mysql.cj.jdbc.Driver\");\n        dataSource.setUrl(\"jdbc:mysql:\/\/localhost:3306\/mydb?useUnicode=true&characterEncoding=utf-8\");\n        dataSource.setUsername(\"root\");\n        dataSource.setPassword(\"123456\");\n        return dataSource;\n    }\n\n    \/**\n     * \u6ce8\u518cSqlSessionFactory\n     *\/\n    @Bean\n    public SqlSessionFactoryBean sqlSessionFactory(DataSource dataSource) {\n        SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();\n        factoryBean.setDataSource(dataSource);\n        return factoryBean;\n    }\n}<\/code><\/pre>\n\n\n\n
\u5982\u679c\u4f60\u4e0d\u60f3\u76f4\u63a5\u5728\u914d\u7f6e\u7c7b\u4e0a\u4f7f\u7528 @MapperScan<\/code>\uff0c\u4e5f\u53ef\u4ee5\u628a\u626b\u63cf\u5668\u672c\u8eab\u6ce8\u518c\u4e3a\u5bb9\u5668\u4e2d\u7684\u7ec4\u4ef6\u3002\u8fd9\u6837\u505a\u7684\u672c\u8d28\uff0c\u662f\u628a\u201c\u626b\u63cf\u54ea\u4e2a\u5305\u4e0b\u7684 Mapper \u63a5\u53e3\u201d\u8fd9\u4ef6\u4e8b\u4ea4\u7ed9\u4e00\u4e2a\u4e13\u95e8\u7684 MapperScannerConfigurer<\/code> \u7ec4\u4ef6\u6765\u5b8c\u6210\u3002<\/p>\n\n\n\n
@Configuration\n@ComponentScan(\"com.example\")\npublic class AppConfiguration {\n\n    @Bean\n    public MapperScannerConfigurer mapperScannerConfigurer() {\n        MapperScannerConfigurer configurer = new MapperScannerConfigurer();\n        configurer.setBasePackage(\"com.example.mapper\");\n        return configurer;\n    }\n\n    @Bean\n    public DataSource dataSource() {\n        DruidDataSource dataSource = new DruidDataSource();\n        dataSource.setDriverClassName(\"com.mysql.cj.jdbc.Driver\");\n        dataSource.setUrl(\"jdbc:mysql:\/\/localhost:3306\/mydb?useUnicode=true&characterEncoding=utf-8\");\n        dataSource.setUsername(\"root\");\n        dataSource.setPassword(\"123456\");\n        return dataSource;\n    }\n\n    @Bean\n    public SqlSessionFactoryBean sqlSessionFactory(DataSource dataSource) {\n        SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();\n        factoryBean.setDataSource(dataSource);\n        return factoryBean;\n    }\n}<\/code><\/pre>\n\n\n\n
\u4e24\u79cd\u5199\u6cd5\u7684\u76ee\u6807\u662f\u4e00\u81f4\u7684\uff1a\u90fd\u662f\u628a Mapper \u63a5\u53e3\u6ce8\u518c\u4e3a Spring \u5bb9\u5668\u4e2d\u7684\u4ee3\u7406\u5bf9\u8c61\u3002\u533a\u522b\u53ea\u662f\u4e00\u4e2a\u66f4\u504f\u6ce8\u89e3\u58f0\u660e\uff0c\u4e00\u4e2a\u66f4\u504f\u663e\u5f0f\u914d\u7f6e\u3002<\/p>\n\n\n\n
Mapper\u63a5\u53e3\u4e0e\u4f7f\u7528<\/h3>\n\n\n\n
\/\/ Mapper\u63a5\u53e3\n@Mapper\npublic interface UserMapper {\n    @Select(\"SELECT * FROM user WHERE id = #{id}\")\n    User selectById(Integer id);\n\n    @Insert(\"INSERT INTO user(name, age) VALUES(#{name}, #{age})\")\n    int insert(User user);\n}\n\n\/\/ Service\u76f4\u63a5\u4f7f\u7528\n@Service\npublic class UserServiceImpl implements UserService {\n\n    @Autowired\n    private UserMapper userMapper;  \/\/ \u76f4\u63a5\u6ce8\u5165\u4f7f\u7528\n\n    @Override\n    public User getUserById(Integer id) {\n        return userMapper.selectById(id);\n    }\n}<\/code><\/pre>\n\n\n\n
\u6574\u5408\u539f\u7406<\/h3>\n\n\n\n
\"Spring<\/div>
Spring \u6574\u5408 MyBatis \u7684\u7ec4\u4ef6\u8c03\u7528\u94fe\u8def\u56fe<\/figcaption><\/figure>\n\n\n\n
\u6700\u5e95\u5c42\u5148\u51c6\u5907\u00a0DataSource<\/code>\uff0c\u5b83\u8d1f\u8d23\u63d0\u4f9b\u6570\u636e\u5e93\u8fde\u63a5\uff1b\u5728\u5b83\u4e4b\u4e0a\uff0cSqlSessionFactoryBean<\/code>\u00a0\u8d1f\u8d23\u628a MyBatis \u7684\u4f1a\u8bdd\u5de5\u5382\u4ea4\u7ed9 Spring \u7ba1\u7406\uff1b\u518d\u5f80\u4e0a\uff0cMapper \u63a5\u53e3\u4f1a\u88ab\u626b\u63cf\u5e76\u6ce8\u518c\u6210\u53ef\u6ce8\u5165\u7684\u4ee3\u7406\u5bf9\u8c61\uff1b\u6700\u540e Service \u5c42\u76f4\u63a5\u6ce8\u5165\u8fd9\u4e9b Mapper \u4ee3\u7406\u5bf9\u8c61\u5b8c\u6210\u6570\u636e\u5e93\u8bbf\u95ee\u3002\u4e5f\u5c31\u662f\u8bf4\uff0c\u4e1a\u52a1\u5c42\u5e76\u4e0d\u4f1a\u76f4\u63a5\u64cd\u4f5c JDBC \u6216\u00a0SqlSession<\/code>\uff0c\u800c\u662f\u901a\u8fc7 Spring \u5bb9\u5668\u628a\u6574\u6761\u6301\u4e45\u5c42\u8c03\u7528\u94fe\u4e32\u63a5\u8d77\u6765\u3002<\/p>\n\n\n\n
\u6838\u5fc3\u6982\u5ff5<\/strong>\uff1aSpring \u6574\u5408 MyBatis \u7684\u5173\u952e\uff0c\u4e0d\u662f\u96f6\u6563\u8bb0\u4f4f\u51e0\u4e2a\u6ce8\u89e3\uff0c\u800c\u662f\u7406\u89e3\u6570\u636e\u6e90\u3001\u4f1a\u8bdd\u5de5\u5382\u3001Mapper \u4ee3\u7406\u5bf9\u8c61\u548c Service \u8c03\u7528\u4e4b\u95f4\u662f\u5982\u4f55\u88ab Spring \u4e32\u8d77\u6765\u7684\u3002<\/p>\n\n\n\n
Spring\u6838\u5fc3\u63a5\u53e3<\/h2>\n\n\n\n
    \n
  • PlatformTransactionManager \u5e73\u53f0\u4e8b\u52a1\u7ba1\u7406\u5668<\/strong><\/li>\n\n\n\n
  • TransactionStatus \u4e8b\u52a1\u72b6\u6001<\/li>\n\n\n\n
  • TransactionDefinition \u4e8b\u52a1\u5b9a\u4e49<\/li>\n<\/ul>\n\n\n\n
    \u4e8b\u52a1\u57fa\u7840\u56de\u987e<\/h3>\n\n\n\n
    \u9636\u6bb5<\/th>JDBC\u4ee3\u7801<\/th>MySQL\u547d\u4ee4<\/th><\/tr><\/thead>
    \u5f00\u542f\u4e8b\u52a1<\/strong><\/td>conn.setAutoCommit(false)<\/code><\/td>START TRANSACTION<\/code><\/td><\/tr>
    \u63d0\u4ea4\u4e8b\u52a1<\/strong><\/td>conn.commit()<\/code><\/td>COMMIT<\/code><\/td><\/tr>
    \u56de\u6eda\u4e8b\u52a1<\/strong><\/td>conn.rollback()<\/code><\/td>ROLLBACK<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    \u540e\u7eed\u5728\u8fde\u63a5\u6c60\u7684\u5185\u5bb9\u4e2d\uff0c\u662fDataSource\u6765\u7ba1\u7406connection\uff0c\u4e5f\u5c31\u662f\u8bf4\u8c01\u7ba1\u7406\u4e86DataSource\u8c01\u5c31\u7ba1\u7406\u4e86\u4e8b\u52a1\u3002<\/p>\n\n\n\n
    \u90a3\u4e48\u8c01\u7ba1\u7406\u4e86DataSource\u5462\uff0c\u6211\u4eec\u63a5\u4e0b\u6765\u7ee7\u7eed\u6765\u770b\u4e8b\u52a1\u7684\u6838\u5fc3\u63a5\u53e3<\/p>\n\n\n\n
    PlatformTransactionManager \u5e73\u53f0\u4e8b\u52a1\u7ba1\u7406\u5668<\/h3>\n\n\n\n
    \u5e73\u53f0\u4e8b\u52a1\u7ba1\u7406\u5668\uff0cSpring\u8981\u7ba1\u7406\u4e8b\u52a1\uff0c\u5fc5\u987b\u4f7f\u7528\u4e8b\u52a1\u7ba1\u7406\u5668 \u6709\u591a\u79cd\u5b9e\u73b0\uff0c\u901a\u8fc7\u5b9e\u73b0\u6b64\u63a5\u53e3\uff0cSpring\u53ef\u4ee5\u7ba1\u7406\u4efb\u4f55\u5b9e\u73b0\u4e86\u8fd9\u4e9b\u63a5\u53e3\u7684\u4e8b\u52a1\u3002 \u5f00\u53d1\u4eba\u5458\u53ef\u4ee5\u4f7f\u7528\u7edf\u4e00\u7684\u7f16\u7a0b\u6a21\u578b\u6765\u63a7\u5236\u7ba1\u7406\u4e8b\u52a1\u3002<\/p>\n\n\n\n
    \u5e38\u89c1\u7684\u4e8b\u52a1\u7ba1\u7406\u5668\u7684\u5b9e\u73b0 DataSourceTransactionManager\uff0cjdbc\u5f00\u53d1\u65f6\u4e8b\u52a1\u7ba1\u7406\u5668\uff0c\u4f7f\u7528JdbcTemplate\u3001MyBatis\uff08SSM\uff09 HibernateTransactionManager\uff0cHibernate\u5f00\u53d1\u65f6\u4e8b\u52a1\u7ba1\u7406\u5668\uff0c\u6574\u5408Hibernate\uff08SSH\uff09<\/p>\n\n\n\n
    public interface PlatformTransactionManager extends TransactionManager {\n  \/\/ \u5f00\u542f\u4e8b\u52a1\n    TransactionStatus getTransaction(@Nullable TransactionDefinition var1) throws TransactionException;\n  \/\/ \u63d0\u4ea4\u4e8b\u52a1\n    void commit(TransactionStatus var1) throws TransactionException;\n  \/\/ \u56de\u6eda\u4e8b\u52a1\n    void rollback(TransactionStatus var1) throws TransactionException;\n}<\/code><\/pre>\n\n\n\n
    TransactionStatus \u4e8b\u52a1\u72b6\u6001<\/h3>\n\n\n\n
    \u83b7\u53d6\u4e8b\u52a1\u7684\u72b6\u6001\uff08\u56de\u6eda\u70b9\u3001\u662f\u5426\u5b8c\u6210\u3001\u662f\u5426\u65b0\u4e8b\u52a1\u3001\u662f\u5426\u56de\u6eda\uff09\u5c5e\u6027\uff0c\u662f\u4e00\u4e2a\u8fc7\u7a0b\u503c<\/p>\n\n\n\n
    public interface TransactionStatus extends TransactionExecution, SavepointManager, Flushable {\n  boolean hasSavepoint();\n\n  void flush();\n}<\/code><\/pre>\n\n\n\n
    \u63d0\u4f9b\u4e86\u5173\u4e8e\u4e8b\u52a1\u72b6\u6001\u7684\u65b9\u6cd5<\/p>\n\n\n\n
    \"image-20240829143413595\"\/<\/div>
    image-20240829143413595<\/figcaption><\/figure>\n\n\n\n
    TransactionDefinition \u4e8b\u52a1\u5b9a\u4e49<\/h3>\n\n\n\n
    \u5b9a\u4e49\u4e8b\u52a1\u7684\u540d\u79f0\u3001\u9694\u79bb\u7ea7\u522b\u3001\u4f20\u64ad\u884c\u4e3a\u3001\u8d85\u65f6\u65f6\u95f4\u957f\u77ed\u3001\u53ea\u8bfb\u5c5e\u6027\u7b49<\/p>\n\n\n\n
    public interface TransactionDefinition {\n  int PROPAGATION_REQUIRED = 0;\n  int PROPAGATION_SUPPORTS = 1;\n  int PROPAGATION_MANDATORY = 2;\n  int PROPAGATION_REQUIRES_NEW = 3;\n  int PROPAGATION_NOT_SUPPORTED = 4;\n  int PROPAGATION_NEVER = 5;\n  int PROPAGATION_NESTED = 6;\n  int ISOLATION_DEFAULT = -1;\n  int ISOLATION_READ_UNCOMMITTED = 1;\n  int ISOLATION_READ_COMMITTED = 2;\n  int ISOLATION_REPEATABLE_READ = 4;\n  int ISOLATION_SERIALIZABLE = 8;\n  int TIMEOUT_DEFAULT = -1;\n\n  default int getPropagationBehavior() {\n    return 0;\n  }\n\n  default int getIsolationLevel() {\n    return -1;\n  }\n\n  default int getTimeout() {\n    return -1;\n  }\n\n  default boolean isReadOnly() {\n    return false;\n  }\n\n  @Nullable\n  default String getName() {\n    return null;\n  }\n\n  static TransactionDefinition withDefaults() {\n    return StaticTransactionDefinition.INSTANCE;\n  }\n}<\/code><\/pre>\n\n\n\n
    \u624b\u52a8\u7ba1\u7406\u4e8b\u52a1<\/h3>\n\n\n\n
    DataSource\u7ba1\u7406\u4e86\u4e8b\u52a1\uff0c\u800cPlatformTransactionManager\u4f9d\u8d56\u4e8eDataSource\u7ec4\u4ef6\uff0c\u5176\u5b9e\u662fPlatformTransactionManager\u5bf9\u5e94\u7684\u5b9e\u4f8b\u6765\u7ba1\u7406\u4e8b\u52a1\u3002<\/p>\n\n\n\n
    \u6211\u4eec\u5411\u5bb9\u5668\u4e2d\u6ce8\u518c\u4e00\u4e2aDataSourceTransactionManager(\u5b83\u662fPlatformTransactionManager\u7684\u5b9e\u73b0\u7c7b)\uff0c\u6ce8\u518c\u8fd9\u4e2a\u7ec4\u4ef6\u7684\u65f6\u5019\u9700\u8981\u4f9d\u8d56\u4e8eDataSource\u7ec4\u4ef6\u3002<\/p>\n\n\n\n
    \/\/ \u5e73\u53f0\u4e8b\u52a1\u7ba1\u7406\u5668\uff0cSpring\u8981\u7ba1\u7406\u4e8b\u52a1\uff0c\u5fc5\u987b\u8981\u4f7f\u7528\u5230\u8fd9\u4e2a\u7ec4\u4ef6\n\/\/ dataSource\u5c31\u662f\u8fde\u63a5\u6c60\n\/\/ \u7ba1\u7406\u4e8b\u52a1\uff0c\u5176\u5b9e\u5c31\u662f\u7ba1\u7406\u8fde\u63a5\n@Bean\npublic PlatformTransactionManager transactionManager(DataSource dataSource) {\n  DataSourceTransactionManager transactionManager = new DataSourceTransactionManager();\n  transactionManager.setDataSource(dataSource);\n  return transactionManager;\n}<\/code><\/pre>\n\n\n\n
    \u624b\u52a8\u7ba1\u7406\u4e8b\u52a1\u4e5f\u5c31\u610f\u5473\u7740\u4f7f\u7528PlatformTransactionManager\u63d0\u4f9b\u7684\u65b9\u6cd5\u6765\u7ba1\u7406\u4e8b\u52a1<\/p>\n\n\n\n
    @Service\npublic class MarketAccountServiceImpl implements MarketAccountService {\n\n  @Autowired\n  AccountMapper accountMapper;\n\n  \/\/ \u4ece\u5bb9\u5668\u4e2d\u83b7\u53d6\u5e73\u53f0\u4e8b\u52a1\u7ba1\u7406\u5668\u7ec4\u4ef6(DataSourceTransactionManager)\n  @Autowired\n  PlatformTransactionManager transactionManager;\n\n  @Override\n  public int transfer(Integer fromId, Integer destId, Integer money) {\n    \/\/ \u5148\u67e5\u8be2\u51fa\u6765\u4fe1\u606f\n    MarketAccount fromAccount = accountMapper.selectByPrimaryKey(fromId);\n    MarketAccount destAccount = accountMapper.selectByPrimaryKey(destId);\n\n    \/\/ fromAccount\u5b83\u7684\u94b1 \u5c11\u4e86\n    fromAccount.setMoney(fromAccount.getMoney() - money);\n    fromAccount.setUpdateTime(LocalDateTime.now());\n    \/\/ destAccount\u5b83\u7684\u94b1 \u591a\u4e86\n    destAccount.setMoney(destAccount.getMoney() + money);\n    destAccount.setUpdateTime(LocalDateTime.now());\n\n    TransactionStatus transactionStatus = null;\n    try {\n      \/\/ \u5f00\u542f\u4e8b\u52a1\n      transactionStatus = transactionManager.getTransaction(TransactionDefinition.withDefaults());\n      \/\/ \u6267\u884c\u66f4\u65b0\u64cd\u4f5c\n      accountMapper.updateByPrimaryKeySelective(fromAccount);\n      \/\/ \u5236\u9020\u5f02\u5e38\n      int i = 1 \/ 0;\n      accountMapper.updateByPrimaryKeySelective(destAccount);\n      \/\/ \u63d0\u4ea4\u4e8b\u52a1\n      transactionManager.commit(transactionStatus);\n    } catch (Exception e) {\n      \/\/ \u56de\u6eda\u4e8b\u52a1\n      transactionManager.rollback(transactionStatus);\n      throw new RuntimeException(e);\n    }\n    return 0;\n  }\n\n}<\/code><\/pre>\n\n\n\n
    \u90a3\u4e48\u5982\u679c\u8bf4\u5176\u4ed6\u7684\u65b9\u6cd5\u4e5f\u505a\u7c7b\u4f3c\u7684\u4e8b\u60c5\u5462<\/p>\n\n\n\n
    \u4e5f\u5728\u6267\u884c\u4e1a\u52a1\u4ee3\u7801\u4e4b\u524d\u5f00\u542f\u4e8b\u52a1\uff0c\u7136\u540e\u5bf9\u4e1a\u52a1\u4ee3\u7801\u589e\u52a0try-catch\uff0c\u5982\u679c\u6267\u884c\u6210\u529f\u63d0\u4ea4\u4e8b\u52a1\uff0c\u5931\u8d25\u5219\u56de\u6eda\u4e8b\u52a1<\/p>\n\n\n\n
    TransactionStatus transactionStatus = null;\ntry {\n  transactionStatus = transactionManager.getTransaction(TransactionDefinition.withDefaults());\n  \/\/ \u6838\u5fc3\u4e1a\u52a1\n  transactionManager.commit(transactionStatus);\n} catch (Exception e) {\n  transactionManager.rollback(transactionStatus);\n  throw new RuntimeException(e);\n}<\/code><\/pre>\n\n\n\n
    \u6bd4\u5982\u4e0b\u9762\u7684\u4e00\u4e2a\u4fee\u6539\u4e1a\u52a1<\/p>\n\n\n\n
    @Override\npublic int modify(Integer id, Integer money) {\n  TransactionStatus transactionStatus = null;\n  try {\n    transactionStatus = transactionManager.getTransaction(TransactionDefinition.withDefaults());\n    MarketAccount marketAccount = new MarketAccount();\n    marketAccount.setId(id);\n    marketAccount.setMoney(money);\n    accountMapper.updateByPrimaryKeySelective(marketAccount);\n    transactionManager.commit(transactionStatus);\n  } catch (Exception e) {\n    transactionManager.rollback(transactionStatus);\n    throw new RuntimeException(e);\n  }\n  return 0;\n}<\/code><\/pre>\n\n\n\n
    \u8fd9\u91cc\u7684\u65b9\u6cd5\u90fd\u4f7f\u7528\u76f8\u540c\u7684\u4e1a\u52a1\uff0c\u8fd9\u65f6\u5019\u6211\u4eec\u8981\u60f3\u8981AOP\u6280\u672f<\/p>\n\n\n\n
    \u8981\u589e\u52a0\u4e8b\u52a1\u7684\u65b9\u6cd5 \u653e\u5165\u5230\u5207\u5165\u70b9<\/strong><\/p>\n\n\n\n
    \u4e8b\u52a1\u7684\u4e1a\u52a1 \u5c31\u662f\u901a\u77e5<\/strong><\/p>\n\n\n\n
    Spring\u5176\u5b9e\u4e5f\u63d0\u4f9b\u4e86\u5bf9\u5e94\u7684\u65b9\u6848\uff0c\u90a3\u5c31\u662fSpring\u4e8b\u52a1\\<\/p>\n\n\n\n
    Spring\u58f0\u660e\u5f0f\u4e8b\u52a1<\/h2>\n\n\n\n
    \u542f\u7528\u58f0\u660e\u5f0f\u4e8b\u52a1<\/h3>\n\n\n\n
    @Configuration\n@ComponentScan(\"com.example\")\n@MapperScan(\"com.example.mapper\")\n@EnableTransactionManagement  \/\/ \u5f00\u542f\u58f0\u660e\u5f0f\u4e8b\u52a1\npublic class AppConfiguration {\n\n    \/\/ ... DataSource\u914d\u7f6e\n\n    \/\/ ... SqlSessionFactory\u914d\u7f6e\n\n    \/**\n     * \u6ce8\u518c\u4e8b\u52a1\u7ba1\u7406\u5668\uff08\u5fc5\u987b\uff09\n     *\/\n    @Bean\n    public PlatformTransactionManager transactionManager(DataSource dataSource) {\n        DataSourceTransactionManager manager = new DataSourceTransactionManager();\n        manager.setDataSource(dataSource);\n        return manager;\n    }\n}<\/code><\/pre>\n\n\n\n
     @Transactional \u4f7f\u7528<\/h3>\n\n\n\n
    @Service\npublic class TransferServiceImpl implements TransferService {\n\n    @Autowired\n    private AccountMapper accountMapper;\n\n    \/**\n     * @Transactional\u8ba9\u65b9\u6cd5\u5728\u4e8b\u52a1\u4e2d\u6267\u884c\n     * - \u65b9\u6cd5\u6267\u884c\u524d\uff1a\u5f00\u542f\u4e8b\u52a1\n     * - \u65b9\u6cd5\u6b63\u5e38\u7ed3\u675f\uff1a\u63d0\u4ea4\u4e8b\u52a1\n     * - \u65b9\u6cd5\u629b\u51fa\u5f02\u5e38\uff1a\u56de\u6eda\u4e8b\u52a1\n     *\/\n    @Transactional\n    @Override\n    public void transfer(String from, String to, Double amount) {\n        \/\/ \u6263\u6b3e\n        accountMapper.decreaseBalance(from, amount);\n\n        \/\/ \u6a21\u62df\u5f02\u5e38\n        \/\/ int i = 1 \/ 0;  \/\/ \u8fd9\u884c\u4f1a\u5bfc\u81f4\u4e8b\u52a1\u56de\u6eda\n\n        \/\/ \u6536\u6b3e\n        accountMapper.increaseBalance(to, amount);\n    }\n}<\/code><\/pre>\n\n\n\n
    \u58f0\u660e\u5f0f\u4e8b\u52a1\u539f\u7406<\/h3>\n\n\n\n
    \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n\u2502           @Transactional\u65b9\u6cd5              \u2502\n\u2502                                          \u2502\n\u2502   \u8c03\u7528\u65f6\u5b9e\u9645\u6267\u884c\u7684\u662f\u4ee3\u7406\u5bf9\u8c61\u7684\u65b9\u6cd5\uff1a          \u2502\n\u2502                                          \u2502\n\u2502   1. \u5f00\u542f\u4e8b\u52a1                             \u2502\n\u2502       \u2193                                  \u2502\n\u2502   2. \u6267\u884c\u4e1a\u52a1\u65b9\u6cd5                          \u2502\n\u2502       \u2193                                  \u2502\n\u2502   3. \u5224\u65ad\u7ed3\u679c\uff1a                            \u2502\n\u2502      \u251c\u2500 \u6b63\u5e38\u7ed3\u675f \u2192 \u63d0\u4ea4\u4e8b\u52a1                \u2502\n\u2502      \u2514\u2500 \u629b\u51fa\u5f02\u5e38 \u2192 \u56de\u6eda\u4e8b\u52a1                \u2502\n\u2502                                          \u2502\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518<\/code><\/pre>\n\n\n\n
    \u8fd9\u5f20\u56fe\u7684\u5173\u952e\u4e0d\u662f\u8bb0\u4f4f\u4e09\u4e2a\u6b65\u9aa4\uff0c\u800c\u662f\u5148\u7406\u89e3\uff1a\u5f53\u65b9\u6cd5\u88ab @Transactional<\/code> \u6807\u8bb0\u540e\uff0c\u5916\u90e8\u8c03\u7528\u65f6\u771f\u6b63\u8fdb\u5165\u7684\u5e76\u4e0d\u662f\u539f\u59cb\u4e1a\u52a1\u5bf9\u8c61\uff0c\u800c\u662f Spring \u751f\u6210\u7684\u4ee3\u7406\u5bf9\u8c61\u3002\u4ee3\u7406\u5bf9\u8c61\u4f1a\u5148\u51b3\u5b9a\u662f\u5426\u5f00\u542f\u4e8b\u52a1\uff0c\u518d\u53bb\u8c03\u7528\u771f\u5b9e\u4e1a\u52a1\u65b9\u6cd5\uff1b\u65b9\u6cd5\u8fd4\u56de\u540e\uff0c\u6839\u636e\u6267\u884c\u7ed3\u679c\u51b3\u5b9a\u63d0\u4ea4\u8fd8\u662f\u56de\u6eda\u3002\u4e5f\u5c31\u662f\u8bf4\uff0c\u4e8b\u52a1\u63a7\u5236\u903b\u8f91\u59cb\u7ec8\u5305\u88f9\u5728\u4e1a\u52a1\u65b9\u6cd5\u5916\u56f4\uff0c\u800c\u4e0d\u662f\u5199\u6b7b\u5728\u4e1a\u52a1\u4ee3\u7801\u5185\u90e8\u3002<\/p>\n\n\n\n
    Spring\u901a\u8fc7AOP\u751f\u6210\u4ee3\u7406\u5bf9\u8c61\uff0c\u5bf9@Transactional<\/code>\u65b9\u6cd5\u505a\u73af\u7ed5\u589e\u5f3a\uff1a<\/p>\n\n\n\n
      \n
    • \u65b9\u6cd5\u6267\u884c\u524d\uff1a\u8c03\u7528PlatformTransactionManager.getTransaction()<\/code>\u5f00\u542f\u4e8b\u52a1<\/li>\n\n\n\n
    • \u65b9\u6cd5\u6267\u884c\u540e\uff1a\u8c03\u7528commitTransactionAfterReturning()<\/code>\u63d0\u4ea4\u4e8b\u52a1<\/li>\n\n\n\n
    • \u629b\u51fa\u5f02\u5e38\u65f6\uff1a\u8c03\u7528completeTransactionAfterThrowing()<\/code>\u56de\u6eda\u4e8b\u52a1<\/li>\n<\/ul>\n\n\n\n
      @Transactional \u5c5e\u6027<\/h3>\n\n\n\n
      \u5c5e\u6027<\/th>\u8bf4\u660e<\/th>\u9ed8\u8ba4\u503c<\/th><\/tr><\/thead>
      propagation<\/code><\/td>\u4e8b\u52a1\u4f20\u64ad\u884c\u4e3a<\/td>Propagation.REQUIRED<\/code><\/td><\/tr>
      isolation<\/code><\/td>\u4e8b\u52a1\u9694\u79bb\u7ea7\u522b<\/td>Isolation.DEFAULT<\/code><\/td><\/tr>
      readOnly<\/code><\/td>\u662f\u5426\u53ea\u8bfb\u4e8b\u52a1<\/td>false<\/code><\/td><\/tr>
      timeout<\/code><\/td>\u8d85\u65f6\u65f6\u95f4\uff08\u79d2\uff09<\/td>-1<\/code>\uff08\u65e0\u9650\u5236\uff09<\/td><\/tr>
      rollbackFor<\/code><\/td>\u54ea\u4e9b\u5f02\u5e38\u89e6\u53d1\u56de\u6eda<\/td>RuntimeException<\/code>\u3001Error<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      @Transactional(\n    propagation = Propagation.REQUIRED,\n    isolation = Isolation.READ_COMMITTED,\n    readOnly = false,\n    timeout = 30,\n    rollbackFor = Exception.class\n)\npublic void transfer(...) { }\n\n<\/code><\/pre>\n\n\n\n
      \u6838\u5fc3\u6982\u5ff5<\/strong>\uff1a\u58f0\u660e\u5f0f\u4e8b\u52a1\u7684\u4ef7\u503c\u5728\u4e8e\u628a\u201c\u5f00\u542f\u4e8b\u52a1\u3001\u63d0\u4ea4\u4e8b\u52a1\u3001\u56de\u6eda\u4e8b\u52a1\u201d\u8fd9\u5957\u56fa\u5b9a\u6d41\u7a0b\u4ece\u4e1a\u52a1\u4ee3\u7801\u4e2d\u62bd\u79bb\u51fa\u6765\uff0c\u8ba9\u5f00\u53d1\u8005\u53ea\u5173\u6ce8\u4e1a\u52a1\u8fb9\u754c\u3002<\/p>\n\n\n\n
      \u4e8b\u52a1\u4f20\u64ad\u884c\u4e3a<\/h2>\n\n\n\n
      \u4ec0\u4e48\u662f\u4f20\u64ad\u884c\u4e3a<\/h3>\n\n\n\n
      \u4e8b\u52a1\u4f20\u64ad\u884c\u4e3a\u5b9a\u4e49\u4e86\uff1a\u5f53\u4e00\u4e2a\u4e8b\u52a1\u65b9\u6cd5\u8c03\u7528\u53e6\u4e00\u4e2a\u4e8b\u52a1\u65b9\u6cd5\u65f6\uff0c\u4e8b\u52a1\u5982\u4f55\u4f20\u64ad<\/strong>\u3002<\/p>\n\n\n\n
      @Service\npublic class ServiceA {\n    @Autowired\n    private ServiceB serviceB;\n\n    @Transactional  \/\/ \u5f00\u542f\u4e8b\u52a1T1\n    public void methodA() {\n        \/\/ ... \u64cd\u4f5c\u6570\u636e\u5e93\n        serviceB.methodB();  \/\/ \u8c03\u7528\u53e6\u4e00\u4e2a\u4e8b\u52a1\u65b9\u6cd5\n    }\n}\n\n@Service\npublic class ServiceB {\n    @Transactional  \/\/ \u600e\u4e48\u5904\u7406\uff1f\u52a0\u5165T1\uff1f\u65b0\u5efaT2\uff1f\n    public void methodB() {\n        \/\/ ... \u64cd\u4f5c\u6570\u636e\u5e93\n    }\n}<\/code><\/pre>\n\n\n\n
      7\u79cd\u4f20\u64ad\u884c\u4e3a<\/h3>\n\n\n\n
      \u4f20\u64ad\u884c\u4e3a<\/th>\u542b\u4e49<\/th>\u4f7f\u7528\u573a\u666f<\/th><\/tr><\/thead>
      REQUIRED<\/strong>\uff08\u9ed8\u8ba4\uff09<\/td>\u5f53\u524d\u6709\u4e8b\u52a1\u5219\u52a0\u5165\uff0c\u65e0\u5219\u65b0\u5efa<\/td>\u5927\u591a\u6570\u573a\u666f<\/td><\/tr>
      REQUIRES_NEW<\/strong><\/td>\u59cb\u7ec8\u65b0\u5efa\u4e8b\u52a1\uff0c\u6302\u8d77\u5f53\u524d\u4e8b\u52a1<\/td>\u9700\u8981\u72ec\u7acb\u63d0\u4ea4\/\u56de\u6eda<\/td><\/tr>
      NESTED<\/strong><\/td>\u5f53\u524d\u6709\u4e8b\u52a1\u5219\u521b\u5efa\u5d4c\u5957\u4e8b\u52a1\uff08\u4fdd\u5b58\u70b9\uff09<\/td>\u5b50\u4e8b\u52a1\u53ef\u5355\u72ec\u56de\u6eda<\/td><\/tr>
      SUPPORTS<\/strong><\/td>\u6709\u4e8b\u52a1\u5219\u52a0\u5165\uff0c\u65e0\u5219\u4ee5\u975e\u4e8b\u52a1\u6267\u884c<\/td>\u4e0d\u5f3a\u5236\u8981\u6c42\u4e8b\u52a1<\/td><\/tr>
      NOT_SUPPORTED<\/strong><\/td>\u4ee5\u975e\u4e8b\u52a1\u6267\u884c\uff0c\u6302\u8d77\u5f53\u524d\u4e8b\u52a1<\/td>\u4e0d\u9700\u8981\u4e8b\u52a1\u7684\u65b9\u6cd5<\/td><\/tr>
      MANDATORY<\/strong><\/td>\u5f3a\u5236\u8981\u6c42\u5b58\u5728\u4e8b\u52a1\uff0c\u65e0\u5219\u629b\u5f02\u5e38<\/td>\u5fc5\u987b\u5728\u4e8b\u52a1\u4e2d\u6267\u884c<\/td><\/tr>
      NEVER<\/strong><\/td>\u5f3a\u5236\u8981\u6c42\u65e0\u4e8b\u52a1\uff0c\u6709\u5219\u629b\u5f02\u5e38<\/td>\u4e0d\u5141\u8bb8\u5728\u4e8b\u52a1\u4e2d\u6267\u884c<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      REQUIRED\uff08\u9ed8\u8ba4\uff09<\/h3>\n\n\n\n
      @Service\npublic class ServiceA {\n    @Autowired\n    private ServiceB serviceB;\n\n    @Transactional  \/\/ \u9ed8\u8ba4REQUIRED\uff0c\u65b0\u5efa\u4e8b\u52a1T1\n    public void methodA() {\n        serviceB.methodB();  \/\/ \u52a0\u5165T1\uff0c\u4e0d\u65b0\u5efa\u4e8b\u52a1\n    }\n}\n\n@Service\npublic class ServiceB {\n    @Transactional  \/\/ \u9ed8\u8ba4REQUIRED\n    public void methodB() {\n        \/\/ \u590d\u7528methodA\u7684\u4e8b\u52a1T1\n    }\n}<\/code><\/pre>\n\n\n\n
      \u7279\u70b9<\/strong>\uff1a<\/p>\n\n\n\n
        \n
      • methodA\u548cmethodB\u5171\u7528\u540c\u4e00\u4e2a\u4e8b\u52a1<\/li>\n\n\n\n
      • \u4efb\u4e00\u65b9\u6cd5\u629b\u51fa\u5f02\u5e38\uff0c\u6574\u4e2a\u4e8b\u52a1\u56de\u6eda<\/li>\n<\/ul>\n\n\n\n
        REQUIRES_NEW<\/h3>\n\n\n\n
        @Service\npublic class ServiceA {\n    @Autowired\n    private ServiceB serviceB;\n\n    @Transactional\n    public void methodA() {\n        \/\/ \u5728\u4e8b\u52a1T1\u4e2d\n        serviceB.methodB();  \/\/ \u6302\u8d77T1\uff0c\u65b0\u5efaT2\n        \/\/ \u6062\u590dT1\n    }\n}\n\n@Service\npublic class ServiceB {\n    @Transactional(propagation = Propagation.REQUIRES_NEW)\n    public void methodB() {\n        \/\/ \u5728\u72ec\u7acb\u7684\u4e8b\u52a1T2\u4e2d\n    }\n}<\/code><\/pre>\n\n\n\n
        \u7279\u70b9<\/strong>\uff1a<\/p>\n\n\n\n
          \n
        • methodB\u5728\u72ec\u7acb\u4e8b\u52a1T2\u4e2d\u6267\u884c<\/li>\n\n\n\n
        • T1\u548cT2\u4e92\u4e0d\u5f71\u54cd\uff0c\u5404\u81ea\u63d0\u4ea4\u6216\u56de\u6eda<\/li>\n\n\n\n
        • \u9002\u7528\u573a\u666f<\/strong>\uff1a\u65e5\u5fd7\u8bb0\u5f55\uff0c\u65e0\u8bba\u4e3b\u4e1a\u52a1\u6210\u529f\u4e0e\u5426\u90fd\u8981\u8bb0\u5f55<\/li>\n<\/ul>\n\n\n\n
          NESTED<\/h3>\n\n\n\n
          @Service\npublic class ServiceA {\n    @Autowired\n    private ServiceB serviceB;\n\n    @Transactional\n    public void methodA() {\n        \/\/ \u5916\u5c42\u4e8b\u52a1\n        serviceB.methodB();  \/\/ \u521b\u5efa\u5d4c\u5957\u4e8b\u52a1\uff08\u4fdd\u5b58\u70b9\uff09\n        \/\/ \u7ee7\u7eed\u5916\u5c42\u4e8b\u52a1\n    }\n}\n\n@Service\npublic class ServiceB {\n    @Transactional(propagation = Propagation.NESTED)\n    public void methodB() {\n        \/\/ \u5d4c\u5957\u4e8b\u52a1\n    }\n}<\/code><\/pre>\n\n\n\n
          \u7279\u70b9<\/strong>\uff1a<\/p>\n\n\n\n
            \n
          • \u5b50\u4e8b\u52a1\u56de\u6eda\u4e0d\u5f71\u54cd\u7236\u4e8b\u52a1<\/li>\n\n\n\n
          • \u7236\u4e8b\u52a1\u56de\u6eda\uff0c\u5b50\u4e8b\u52a1\u4e5f\u56de\u6eda<\/li>\n\n\n\n
          • \u57fa\u4e8eJDBC\u4fdd\u5b58\u70b9\uff08Savepoint\uff09\u5b9e\u73b0<\/li>\n<\/ul>\n\n\n\n
            \u4e09\u8005\u5bf9\u6bd4<\/strong>\uff1a<\/p>\n\n\n\n
            REQUIRED:                    REQUIRES_NEW:                NESTED:
            \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510                  \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510                  \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510
            \u2502methodA  \u2502                  \u2502methodA  \u2502                  \u2502methodA  \u2502
            \u2502(\u4e8b\u52a1T1) \u2502                  \u2502(\u4e8b\u52a1T1) \u2502                  \u2502(\u4e8b\u52a1T1) \u2502
            \u2502    \u2193    \u2502                  \u2502    \u2193    \u2502                  \u2502    \u2193    \u2502
            \u2502methodB  \u2502                  \u2502\u6302\u8d77T1   \u2502                  \u2502\u4fdd\u5b58\u70b91  \u2502
            \u2502(\u5171\u7528T1) \u2502                  \u2502    \u2193    \u2502                  \u2502    \u2193    \u2502
            \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518                  \u2502methodB  \u2502                  \u2502methodB  \u2502
                                         \u2502(\u4e8b\u52a1T2) \u2502                  \u2502(\u5d4c\u5957\u4e8b\u52a1)\u2502
                                         \u2502    \u2193    \u2502                  \u2502    \u2193    \u2502
                                         \u2502\u6062\u590dT1   \u2502                  \u2502\u56de\u6eda\u5230    \u2502
                                         \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518                  \u2502\u4fdd\u5b58\u70b91   \u2502
                                                                      \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518

            <\/code><\/pre>\n\n\n\n
            \u6838\u5fc3\u6982\u5ff5<\/strong>\uff1a\u4f20\u64ad\u884c\u4e3a\u672c\u8d28\u4e0a\u662f\u5728\u56de\u7b54\u201c\u4e00\u4e2a\u4e8b\u52a1\u65b9\u6cd5\u8c03\u7528\u53e6\u4e00\u4e2a\u4e8b\u52a1\u65b9\u6cd5\u65f6\uff0c\u5230\u5e95\u5171\u7528\u539f\u4e8b\u52a1\u3001\u6302\u8d77\u539f\u4e8b\u52a1\uff0c\u8fd8\u662f\u5728\u539f\u4e8b\u52a1\u5185\u90e8\u5efa\u7acb\u4fdd\u5b58\u70b9\u201d\u3002<\/p>\n\n\n\n
            \u6838\u5fc3\u6ce8\u89e3\u901f\u67e5\u8868<\/h2>\n\n\n\n
            \u6ce8\u89e3<\/th>\u4f5c\u7528<\/th>\u4f7f\u7528\u4f4d\u7f6e<\/th><\/tr><\/thead>
            @MapperScan<\/code><\/td>\u626b\u63cfMyBatis Mapper\u63a5\u53e3<\/td>\u914d\u7f6e\u7c7b<\/td><\/tr>
            @EnableTransactionManagement<\/code><\/td>\u5f00\u542f\u58f0\u660e\u5f0f\u4e8b\u52a1<\/td>\u914d\u7f6e\u7c7b<\/td><\/tr>
            @Transactional<\/code><\/td>\u6807\u8bb0\u4e8b\u52a1\u65b9\u6cd5<\/td>\u7c7b\/\u65b9\u6cd5<\/td><\/tr>
            @Mapper<\/code><\/td>\u6807\u8bb0Mapper\u63a5\u53e3<\/td>\u63a5\u53e3<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
            <\/p>\n","protected":false},"excerpt":{"rendered":"
            Spring\u6574\u5408MyBatis \u5f15\u5165\u4f9d\u8d56 \u914d\u7f6e\u7c7b \u5982\u679c\u4f60\u4e0d\u60f3\u76f4\u63a5\u5728\u914d\u7f6e\u7c7b\u4e0a\u4f7f\u7528 @MapperSca […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[18,14,17],"class_list":["post-248","post","type-post","status-publish","format-standard","hentry","category-learn","tag-spring","tag-14","tag-17"],"_links":{"self":[{"href":"https:\/\/larkdrop.cafe\/index.php\/wp-json\/wp\/v2\/posts\/248","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/larkdrop.cafe\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/larkdrop.cafe\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/larkdrop.cafe\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/larkdrop.cafe\/index.php\/wp-json\/wp\/v2\/comments?post=248"}],"version-history":[{"count":2,"href":"https:\/\/larkdrop.cafe\/index.php\/wp-json\/wp\/v2\/posts\/248\/revisions"}],"predecessor-version":[{"id":250,"href":"https:\/\/larkdrop.cafe\/index.php\/wp-json\/wp\/v2\/posts\/248\/revisions\/250"}],"wp:attachment":[{"href":"https:\/\/larkdrop.cafe\/index.php\/wp-json\/wp\/v2\/media?parent=248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/larkdrop.cafe\/index.php\/wp-json\/wp\/v2\/categories?post=248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/larkdrop.cafe\/index.php\/wp-json\/wp\/v2\/tags?post=248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}