双数据源

ZY

2025-04-28 0e49d5331f2cd5abaad2517cb508b412391b0672

双数据源

 src/main/java/com/zy/common/config/ds/PrimaryDataSourceConfig.java

@@ -1,7 +1,6 @@
package com.zy.common.config.ds;

import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import com.baomidou.mybatisplus.spring.MybatisSqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.context.annotation.Bean;
@@ -18,13 +17,13 @@

    @Bean(name = "primarySqlSessionFactory")
    @Primary
    public SqlSessionFactory primarySqlSessionFactory(@Qualifier("dataSource") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
    public MybatisSqlSessionFactoryBean primarySqlSessionFactory(@Qualifier("dataSource") DataSource dataSource) throws Exception {
        MybatisSqlSessionFactoryBean sessionFactory = new MybatisSqlSessionFactoryBean();
        sessionFactory.setDataSource(dataSource);
        // 设置MyBatis的Mapper XML文件路径
        sessionFactory.setMapperLocations(new PathMatchingResourcePatternResolver()
                .getResources("classpath:mapper/*.xml"));
        return sessionFactory.getObject();
                .getResources("classpath:mapper/asrs/*.xml"));
        return sessionFactory;
    }

    @Bean(name = "transactionManager")

 src/main/java/com/zy/common/config/ds/SecondaryDataSourceConfig.java

@@ -1,5 +1,6 @@
package com.zy.common.config.ds;

import com.baomidou.mybatisplus.spring.MybatisSqlSessionFactoryBean;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
@@ -16,13 +17,13 @@
public class SecondaryDataSourceConfig {

    @Bean(name = "secondarySqlSessionFactory")
    public SqlSessionFactory secondarySqlSessionFactory(@Qualifier("slaveDataSource") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
    public MybatisSqlSessionFactoryBean secondarySqlSessionFactory(@Qualifier("slaveDataSource") DataSource dataSource) throws Exception {
        MybatisSqlSessionFactoryBean  sessionFactory = new MybatisSqlSessionFactoryBean();
        sessionFactory.setDataSource(dataSource);
        // 设置MyBatis的Mapper XML文件路径
        sessionFactory.setMapperLocations(new PathMatchingResourcePatternResolver()
                .getResources("classpath:mapper/**/*.xml"));
        return sessionFactory.getObject();
                .getResources("classpath:mapper/nc/*.xml"));
        return sessionFactory;
    }

    @Bean(name = "secondaryTransactionManager")

 src/main/java/com/zy/nc/entity/NccSaleXsckmx.java

@@ -1,7 +1,9 @@
package com.zy.nc.entity;

import com.baomidou.mybatisplus.annotations.TableField;
import com.baomidou.mybatisplus.annotations.TableId;
import com.baomidou.mybatisplus.annotations.TableName;
import com.baomidou.mybatisplus.enums.IdType;
import lombok.Data;

import java.io.Serializable;
@@ -11,7 +13,8 @@
@TableName("ncc_sale_xsckmx")
public class NccSaleXsckmx implements Serializable {

    @TableId
    @TableId(value = "cgeneralbid", type = IdType.INPUT)
    @TableField("cgeneralbid")
    private String cgeneralbid;

    private String cszzbm;
@@ -64,7 +67,7 @@

    private String mlmc;

    private String wlu8Name;
    private String wlu8name;

    private String mlgg;


 src/main/resources/application.yml

@@ -33,11 +33,7 @@
    password: 123456
    driver-class-name: com.mysql.cj.jdbc.Driver

mybatis-plus:
  mapper-locations:
    - classpath:mapper/*.xml
    - classpath*:mapper2/*.xml
  type-aliases-package: com.zy.**


logging:
  path: /stock/out/@pom.build.finalName@/logs

 src/main/resources/mapper/asrs/AdjDetlMapper.xml

 src/main/resources/mapper/asrs/ApiLogMapper.xml

 src/main/resources/mapper/asrs/ApiMapper.xml

 src/main/resources/mapper/asrs/AutoMoveMapper.xml

 src/main/resources/mapper/asrs/BasCrnErrorMapper.xml

 src/main/resources/mapper/asrs/BasCrnOptMapper.xml

 src/main/resources/mapper/asrs/BasCrnStatusMapper.xml

 src/main/resources/mapper/asrs/BasCrnpMapper.xml

 src/main/resources/mapper/asrs/BasDevpMapper.xml

 src/main/resources/mapper/asrs/BasErrLogMapper.xml

 src/main/resources/mapper/asrs/BasLocStsMapper.xml

 src/main/resources/mapper/asrs/BasPlcerrorMapper.xml

 src/main/resources/mapper/asrs/BasProcessProceduresMapper.xml

 src/main/resources/mapper/asrs/BasQualityTestingMapper.xml

 src/main/resources/mapper/asrs/BasWhsMapper.xml

 src/main/resources/mapper/asrs/BasWrkIotypeMapper.xml

 src/main/resources/mapper/asrs/BasWrkStatusMapper.xml

 src/main/resources/mapper/asrs/ConfigMapper.xml

 src/main/resources/mapper/asrs/DocLogMapper.xml

 src/main/resources/mapper/asrs/DocTypeMapper.xml

 src/main/resources/mapper/asrs/HostMapper.xml

 src/main/resources/mapper/asrs/LocCheckMapper.xml

 src/main/resources/mapper/asrs/LocDetlMapper.xml

 src/main/resources/mapper/asrs/LocMastMapper.xml

 src/main/resources/mapper/asrs/LocOwnerMapper.xml

 src/main/resources/mapper/asrs/LocRuleMapper.xml

 src/main/resources/mapper/asrs/ManLocDetlMapper.xml

 src/main/resources/mapper/asrs/MatMapper.xml

 src/main/resources/mapper/asrs/NodeMapper.xml

 src/main/resources/mapper/asrs/OperateLogMapper.xml

 src/main/resources/mapper/asrs/OrderDetlMapper.xml

 src/main/resources/mapper/asrs/OrderDetlPakinMapper.xml

 src/main/resources/mapper/asrs/OrderDetlPakoutMapper.xml

 src/main/resources/mapper/asrs/OrderMapper.xml

 src/main/resources/mapper/asrs/OrderPakinMapper.xml

 src/main/resources/mapper/asrs/OrderPakoutMapper.xml

 src/main/resources/mapper/asrs/OrderSettleMapper.xml

 src/main/resources/mapper/asrs/PackMapper.xml

 src/main/resources/mapper/asrs/PermissionMapper.xml

 src/main/resources/mapper/asrs/RequestLogMapper.xml

 src/main/resources/mapper/asrs/ResourceMapper.xml

 src/main/resources/mapper/asrs/RoleMapper.xml

 src/main/resources/mapper/asrs/RolePermissionMapper.xml

 src/main/resources/mapper/asrs/RoleResourceMapper.xml

 src/main/resources/mapper/asrs/RowLastnoMapper.xml

 src/main/resources/mapper/asrs/RowLastnoTypeMapper.xml

 src/main/resources/mapper/asrs/SaasLogMapper.xml

 src/main/resources/mapper/asrs/StaDescMapper.xml

 src/main/resources/mapper/asrs/StkPlcmMapper.xml

 src/main/resources/mapper/asrs/TagMapper.xml

 src/main/resources/mapper/asrs/TrayCodeMapper.xml

 src/main/resources/mapper/asrs/UserLoginMapper.xml

 src/main/resources/mapper/asrs/UserMapper.xml

 src/main/resources/mapper/asrs/ViewInOutMapper.xml

 src/main/resources/mapper/asrs/ViewStayTimeMapper.xml

 src/main/resources/mapper/asrs/ViewStockUseMapper.xml

 src/main/resources/mapper/asrs/ViewWorkInMapper.xml

 src/main/resources/mapper/asrs/WaitPakinLogMapper.xml

 src/main/resources/mapper/asrs/WaitPakinMapper.xml

 src/main/resources/mapper/asrs/WrkDetlLogMapper.xml

 src/main/resources/mapper/asrs/WrkDetlMapper.xml

 src/main/resources/mapper/asrs/WrkLastnoMapper.xml

 src/main/resources/mapper/asrs/WrkMastExecuteLogMapper.xml

 src/main/resources/mapper/asrs/WrkMastExecuteMapper.xml

 src/main/resources/mapper/asrs/WrkMastFourWarVehicleLogMapper.xml

 src/main/resources/mapper/asrs/WrkMastFourWarVehicleMapper.xml

 src/main/resources/mapper/asrs/WrkMastLogMapper.xml

 src/main/resources/mapper/asrs/WrkMastMapper.xml

 src/main/resources/mapper/nc/NccSaleXsckmxMapper.xml

@@ -2,6 +2,11 @@
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.zy.nc.mapper.NccSaleXsckmxMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.zy.nc.entity.NccSaleXsckmx">
        <id column="cgeneralbid" property="cgeneralbid" />


    </resultMap>

</mapper>