sqlserver拿视图数据存储mysql表 同时配置三个从库

lige

2023-12-12 d0fb64d4f70c6fbf782018c928555be517bf7066

sqlserver拿视图数据存储mysql表
同时配置三个从库

 ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java

@@ -4,12 +4,8 @@
import com.ltkj.common.core.domain.AjaxResult;
import com.ltkj.common.enums.DataSourceType;
import com.ltkj.framework.datasource.DynamicDataSourceContextHolder;
import com.ltkj.hosp.service.LtkjMiddleDetailService;
import com.ltkj.hosp.service.LtkjMiddleHeadService;
import com.ltkj.hosp.service.TjvLtkjvtjpatService;
import com.ltkj.hosp.sqlDomain.LtkjMiddleDetail;
import com.ltkj.hosp.sqlDomain.LtkjMiddleHead;
import com.ltkj.hosp.sqlDomain.LtkjTjPat;
import com.ltkj.hosp.service.*;
import com.ltkj.hosp.sqlDomain.*;
import com.ltkj.hosp.mapper.TestMapper;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
@@ -34,20 +30,36 @@

    @Resource
    private LtkjMiddleHeadService headService;
    @Resource
    private LtkjExamJcbgdService ltkjExamJcbgdService;
    @Resource
    private LtkjExamJcsqdService ltkjExamJcsqdService;
    @Resource
    private LtkjHybgdService ltkjHybgdService;
    @Resource
    private LtkjHysqdService ltkjHysqdService;


    @GetMapping("/getMiddleDetail")
    @ApiOperation(value = "查看列表")
    public AjaxResult getMiddleDetail() {
        List<LtkjMiddleDetail> list = testMapper.getMiddleDetail();
        DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
        for (LtkjMiddleDetail ltkjMiddleDetail : list) {
            final boolean save = middleDetailService.save(ltkjMiddleDetail);
        }
        DynamicDataSourceContextHolder.clearDataSourceType();
        return AjaxResult.success(list);
    }


    @GetMapping("/getMiddleHead")
    @ApiOperation(value = "查看列表")
    public AjaxResult getMiddleHead() {
        List<LtkjMiddleHead> list = testMapper.getMiddleHead();
        DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
        for (LtkjMiddleHead ltkjMiddleHead : list) {
            final boolean save = headService.save(ltkjMiddleHead);
        }
        DynamicDataSourceContextHolder.clearDataSourceType();
        return AjaxResult.success(list);
    }

@@ -60,15 +72,62 @@


    @GetMapping("/getTjPat")
    @ApiOperation(value = "查看列表")
    public AjaxResult getTjPat() {
        List<LtkjTjPat> list = testMapper.getTjPat();
        DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
        for (LtkjTjPat ltkjTjPat : list) {
            final boolean save = tjvLtkjvtjpatService.save(ltkjTjPat);
        }
        DynamicDataSourceContextHolder.clearDataSourceType();
        return AjaxResult.success(list);
    }

    @GetMapping("/getExamJcbgd")
    public AjaxResult getExamJcbgd() {
        List<LtkjExamJcbgd> list = testMapper.getExamJcbgd();
        DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
        for (LtkjExamJcbgd ltkjExamJcbgd : list) {
            final boolean save = ltkjExamJcbgdService.save(ltkjExamJcbgd);
        }
        DynamicDataSourceContextHolder.clearDataSourceType();
        return AjaxResult.success(list);
    }

    @GetMapping("/getExamJcsqd")
    public AjaxResult getExamJcsqd() {
        List<LtkjExamJcsqd> list = testMapper.getExamJcsqd();
        DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
        for (LtkjExamJcsqd ltkjExamJcsqd : list) {
            final boolean save = ltkjExamJcsqdService.save(ltkjExamJcsqd);
        }
        DynamicDataSourceContextHolder.clearDataSourceType();
        return AjaxResult.success(list);
    }

    @GetMapping("/getHybgd")
    public AjaxResult getHybgd() {
        List<LtkjHybgd> list = testMapper.getHybgd();
        DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
        for (LtkjHybgd ltkjHybgd : list) {
            final boolean save = ltkjHybgdService.save(ltkjHybgd);
        }
        DynamicDataSourceContextHolder.clearDataSourceType();
        return AjaxResult.success(list);
    }

    @GetMapping("/getHysqd")
    public AjaxResult getHysqd() {
        List<LtkjHysqd> list = testMapper.getHysqd();
        DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
        for (LtkjHysqd ltkjHysqd : list) {
            final boolean save = ltkjHysqdService.save(ltkjHysqd);
        }
        DynamicDataSourceContextHolder.clearDataSourceType();
        return AjaxResult.success(list);
    }


    @GetMapping("/getLtkjTjPatById")
    @ApiOperation(value = "根据id查,存进mysql")
    public AjaxResult getLtkjTjPatById(String id) {
        LtkjTjPat one = testMapper.getTjPatById(id);
        DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
@@ -79,7 +138,6 @@


    @GetMapping("/getMiddleDetailById")
    @ApiOperation(value = "根据id查,存进mysql")
    public AjaxResult getMiddleDetailById(String id) {
        LtkjMiddleDetail one = testMapper.getMiddleDetailById(id);
        DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
@@ -90,7 +148,6 @@


    @GetMapping("/getMiddleHeadById")
    @ApiOperation(value = "根据id查,存进mysql")
    public AjaxResult getMiddleHeadById(String id) {
        LtkjMiddleHead one = testMapper.getMiddleHeadById(id);
        DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
@@ -99,4 +156,40 @@
        return AjaxResult.success(save);
    }


    @GetMapping("/getExamJcbgdById")
    public AjaxResult getExamJcbgdById(String id) {
        LtkjExamJcbgd one = testMapper.getExamJcbgdById(id);
        DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
        final boolean save = ltkjExamJcbgdService.save(one);
        DynamicDataSourceContextHolder.clearDataSourceType();
        return AjaxResult.success(save);
    }

    @GetMapping("/getExamJcsqdById")
    public AjaxResult getExamJcsqdById(String id) {
        LtkjExamJcsqd one = testMapper.getExamJcsqdById(id);
        DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
        final boolean save = ltkjExamJcsqdService.save(one);
        DynamicDataSourceContextHolder.clearDataSourceType();
        return AjaxResult.success(save);
    }

    @GetMapping("/getHybgdById")
    public AjaxResult getHybgdById(String id) {
        LtkjHybgd one = testMapper.getHybgdById(id);
        DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
        final boolean save = ltkjHybgdService.save(one);
        DynamicDataSourceContextHolder.clearDataSourceType();
        return AjaxResult.success(save);
    }

    @GetMapping("/getHysqdById")
    public AjaxResult getHysqdById(String id) {
        LtkjHysqd one = testMapper.getHysqdById(id);
        DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
        final boolean save = ltkjHysqdService.save(one);
        DynamicDataSourceContextHolder.clearDataSourceType();
        return AjaxResult.success(save);
    }
}

 ltkj-admin/src/main/resources/application-druid.yml

@@ -13,7 +13,23 @@
        #password: Root_ltkj123
        password: Root_ltkj123
      # 从库数据源
      slave:
      slavepacs:
        # 从数据源开关/默认关闭
        enabled: true
        driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver
        url: jdbc:sqlserver://192.168.0.111:1433;DatabaseName=Testlg
        username: sa
        password: admin123
      # 从库数据源
      slavehis:
        # 从数据源开关/默认关闭
        enabled: true
        driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver
        url: jdbc:sqlserver://192.168.0.111:1433;DatabaseName=Testlg
        username: sa
        password: admin123
      # 从库数据源
      slavelis:
        # 从数据源开关/默认关闭
        enabled: true
        driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver

 ltkj-common/src/main/java/com/ltkj/common/enums/DataSourceType.java

@@ -14,5 +14,11 @@
    /**
     * 从库
     */
    SLAVE
    SLAVE_PACS,


    SLAVE_HIS,


    SLAVE_LIS,
}

 ltkj-framework/src/main/java/com/ltkj/framework/config/DruidConfig.java

@@ -91,9 +91,25 @@
    }

    @Bean
    @ConfigurationProperties("spring.datasource.druid.slave")
    @ConditionalOnProperty(prefix = "spring.datasource.druid.slave", name = "enabled", havingValue = "true")
    public DataSource slaveDataSource(DruidProperties druidProperties) {
    @ConfigurationProperties("spring.datasource.druid.slavehis")
    @ConditionalOnProperty(prefix = "spring.datasource.druid.slavehis", name = "enabled", havingValue = "true")
    public DataSource slaveHisDataSource(DruidProperties druidProperties) {
        DruidDataSource dataSource = DruidDataSourceBuilder.create().build();
        return druidProperties.dataSource(dataSource);
    }

    @Bean
    @ConfigurationProperties("spring.datasource.druid.slavelis")
    @ConditionalOnProperty(prefix = "spring.datasource.druid.slavelis", name = "enabled", havingValue = "true")
    public DataSource slaveDataLisSource(DruidProperties druidProperties) {
        DruidDataSource dataSource = DruidDataSourceBuilder.create().build();
        return druidProperties.dataSource(dataSource);
    }

    @Bean
    @ConfigurationProperties("spring.datasource.druid.slavepacs")
    @ConditionalOnProperty(prefix = "spring.datasource.druid.slavepacs", name = "enabled", havingValue = "true")
    public DataSource slaveDataPacsSource(DruidProperties druidProperties) {
        DruidDataSource dataSource = DruidDataSourceBuilder.create().build();
        return druidProperties.dataSource(dataSource);
    }
@@ -103,7 +119,9 @@
    public DynamicDataSource dataSource(DataSource masterDataSource) {
        Map<Object, Object> targetDataSources = new HashMap<>();
        targetDataSources.put(DataSourceType.MASTER.name(), masterDataSource);
        setDataSource(targetDataSources, DataSourceType.SLAVE.name(), "slaveDataSource");
        setDataSource(targetDataSources, DataSourceType.SLAVE_HIS.name(), "slaveHisDataSource");
        setDataSource(targetDataSources, DataSourceType.SLAVE_LIS.name(), "slaveDataLisSource");
        setDataSource(targetDataSources, DataSourceType.SLAVE_PACS.name(), "slaveDataPacsSource");
        return new DynamicDataSource(masterDataSource, targetDataSources);
    }


 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcbgdMapper.java

New file
@@ -0,0 +1,17 @@
package com.ltkj.hosp.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.common.annotation.DataSource;
import com.ltkj.common.enums.DataSourceType;
import com.ltkj.hosp.sqlDomain.LtkjExamJcbgd;
import org.apache.ibatis.annotations.Mapper;

/**
 * @Company: 西安路泰科技有限公司
 * @Author: lige
 * @Date: 2023/12/11 17:56
 */
@Mapper
@DataSource(value = DataSourceType.MASTER)
public interface LtkjExamJcbgdMapper extends BaseMapper<LtkjExamJcbgd> {
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcsqdMapper.java

New file
@@ -0,0 +1,18 @@
package com.ltkj.hosp.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.common.annotation.DataSource;
import com.ltkj.common.enums.DataSourceType;
import com.ltkj.hosp.sqlDomain.LtkjExamJcbgd;
import com.ltkj.hosp.sqlDomain.LtkjExamJcsqd;
import org.apache.ibatis.annotations.Mapper;

/**
 * @Company: 西安路泰科技有限公司
 * @Author: lige
 * @Date: 2023/12/11 17:56
 */
@Mapper
@DataSource(value = DataSourceType.MASTER)
public interface LtkjExamJcsqdMapper extends BaseMapper<LtkjExamJcsqd> {
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHybgdMapper.java

New file
@@ -0,0 +1,18 @@
package com.ltkj.hosp.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.common.annotation.DataSource;
import com.ltkj.common.enums.DataSourceType;
import com.ltkj.hosp.sqlDomain.LtkjExamJcsqd;
import com.ltkj.hosp.sqlDomain.LtkjHybgd;
import org.apache.ibatis.annotations.Mapper;

/**
 * @Company: 西安路泰科技有限公司
 * @Author: lige
 * @Date: 2023/12/11 17:56
 */
@Mapper
@DataSource(value = DataSourceType.MASTER)
public interface LtkjHybgdMapper extends BaseMapper<LtkjHybgd> {
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjHysqdMapper.java

New file
@@ -0,0 +1,18 @@
package com.ltkj.hosp.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.common.annotation.DataSource;
import com.ltkj.common.enums.DataSourceType;
import com.ltkj.hosp.sqlDomain.LtkjExamJcsqd;
import com.ltkj.hosp.sqlDomain.LtkjHysqd;
import org.apache.ibatis.annotations.Mapper;

/**
 * @Company: 西安路泰科技有限公司
 * @Author: lige
 * @Date: 2023/12/11 17:56
 */
@Mapper
@DataSource(value = DataSourceType.MASTER)
public interface LtkjHysqdMapper extends BaseMapper<LtkjHysqd> {
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java

@@ -3,9 +3,7 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.common.annotation.DataSource;
import com.ltkj.common.enums.DataSourceType;
import com.ltkj.hosp.sqlDomain.LtkjMiddleDetail;
import com.ltkj.hosp.sqlDomain.LtkjMiddleHead;
import com.ltkj.hosp.sqlDomain.LtkjTjPat;
import com.ltkj.hosp.sqlDomain.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
@@ -18,28 +16,67 @@
 * @Date: 2023/12/11 14:51
 */
@Mapper
@DataSource(value = DataSourceType.SLAVE)
public interface TestMapper{

    @Select("SELECT * FROM tjv_Ltkj_middle_detail")
    @DataSource(value = DataSourceType.SLAVE_HIS)
    public List<LtkjMiddleDetail> getMiddleDetail();

    @DataSource(value = DataSourceType.SLAVE_LIS)
    @Select("SELECT * FROM tjv_Ltkj_middle_head")
    public List<LtkjMiddleHead> getMiddleHead();

//    @Select("SELECT * FROM tjv_LTKJVBJITEM")
//    public List<LtkjVbjitem> getVbjitem();

    @DataSource(value = DataSourceType.SLAVE_PACS)
    @Select("SELECT * FROM tjv_LTKJVTJPAT")
    public List<LtkjTjPat> getTjPat();

    @DataSource(value = DataSourceType.SLAVE_HIS)
    @Select("SELECT * FROM tjv_exam_jcbgd")
    public List<LtkjExamJcbgd> getExamJcbgd();

    @DataSource(value = DataSourceType.SLAVE_HIS)
    @Select("SELECT * FROM tjv_exam_jcsqd")
    public List<LtkjExamJcsqd> getExamJcsqd();


    @DataSource(value = DataSourceType.SLAVE_HIS)
    @Select("SELECT * FROM tjv_Ltkj_hybgd")
    public List<LtkjHybgd> getHybgd();

    @DataSource(value = DataSourceType.SLAVE_HIS)
    @Select("SELECT * FROM tjv_Ltkj_hysqd")
    public List<LtkjHysqd> getHysqd();


    @DataSource(value = DataSourceType.SLAVE_HIS)
    @Select("SELECT * FROM tjv_LTKJVTJPAT where pat_id=#{id}")
    public LtkjTjPat getTjPatById(String id);

    @DataSource(value = DataSourceType.SLAVE_HIS)
    @Select("SELECT * FROM tjv_Ltkj_middle_detail where fdetall_id=#{id}")
    public LtkjMiddleDetail getMiddleDetailById(String id);

    @DataSource(value = DataSourceType.SLAVE_HIS)
    @Select("SELECT * FROM tjv_Ltkj_middle_head where fead_id=#{id}")
    public LtkjMiddleHead getMiddleHeadById(String id);

    @DataSource(value = DataSourceType.SLAVE_HIS)
    @Select("SELECT * FROM tjv_exam_jcbgd  where tmh=#{id}")
    public LtkjExamJcbgd getExamJcbgdById(String id);

    @DataSource(value = DataSourceType.SLAVE_HIS)
    @Select("SELECT * FROM tjv_exam_jcsqd  where tjh=#{id}")
    public LtkjExamJcsqd getExamJcsqdById(String id);


    @DataSource(value = DataSourceType.SLAVE_HIS)
    @Select("SELECT * FROM tjv_Ltkj_hybgd  where tmh=#{id}")
    public LtkjHybgd getHybgdById(String id);

    @DataSource(value = DataSourceType.SLAVE_HIS)
    @Select("SELECT * FROM tjv_Ltkj_hysqd  where tmh=#{id}")
    public LtkjHysqd getHysqdById(String id);
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjExamJcbgdService.java

New file
@@ -0,0 +1,13 @@
package com.ltkj.hosp.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ltkj.hosp.sqlDomain.LtkjExamJcbgd;
import com.ltkj.hosp.sqlDomain.LtkjMiddleHead;

/**
 * @Company: 西安路泰科技有限公司
 * @Author: lige
 * @Date: 2023/12/11 17:57
 */
public interface LtkjExamJcbgdService extends IService<LtkjExamJcbgd> {
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjExamJcsqdService.java

New file
@@ -0,0 +1,13 @@
package com.ltkj.hosp.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ltkj.hosp.sqlDomain.LtkjExamJcbgd;
import com.ltkj.hosp.sqlDomain.LtkjExamJcsqd;

/**
 * @Company: 西安路泰科技有限公司
 * @Author: lige
 * @Date: 2023/12/11 17:57
 */
public interface LtkjExamJcsqdService extends IService<LtkjExamJcsqd> {
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjHybgdService.java

New file
@@ -0,0 +1,13 @@
package com.ltkj.hosp.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ltkj.hosp.sqlDomain.LtkjExamJcsqd;
import com.ltkj.hosp.sqlDomain.LtkjHybgd;

/**
 * @Company: 西安路泰科技有限公司
 * @Author: lige
 * @Date: 2023/12/11 17:57
 */
public interface LtkjHybgdService extends IService<LtkjHybgd> {
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjHysqdService.java

New file
@@ -0,0 +1,13 @@
package com.ltkj.hosp.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.ltkj.hosp.sqlDomain.LtkjHybgd;
import com.ltkj.hosp.sqlDomain.LtkjHysqd;

/**
 * @Company: 西安路泰科技有限公司
 * @Author: lige
 * @Date: 2023/12/11 17:57
 */
public interface LtkjHysqdService extends IService<LtkjHysqd> {
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcbgdServiceImpl.java

New file
@@ -0,0 +1,21 @@
package com.ltkj.hosp.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ltkj.hosp.mapper.LtkjExamJcbgdMapper;
import com.ltkj.hosp.mapper.LtkjMiddleDetailMapper;
import com.ltkj.hosp.service.LtkjExamJcbgdService;
import com.ltkj.hosp.service.LtkjMiddleDetailService;
import com.ltkj.hosp.sqlDomain.LtkjExamJcbgd;
import com.ltkj.hosp.sqlDomain.LtkjMiddleDetail;
import org.springframework.stereotype.Service;

/**
 * 病种+意见Service业务层处理
 *
 * @author ltkj_赵佳豪&李格
 * @date 2023-08-30
 */
@Service
public class LtkjExamJcbgdServiceImpl extends ServiceImpl<LtkjExamJcbgdMapper, LtkjExamJcbgd> implements LtkjExamJcbgdService {

}

 ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java

New file
@@ -0,0 +1,21 @@
package com.ltkj.hosp.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ltkj.hosp.mapper.LtkjExamJcbgdMapper;
import com.ltkj.hosp.mapper.LtkjExamJcsqdMapper;
import com.ltkj.hosp.service.LtkjExamJcbgdService;
import com.ltkj.hosp.service.LtkjExamJcsqdService;
import com.ltkj.hosp.sqlDomain.LtkjExamJcbgd;
import com.ltkj.hosp.sqlDomain.LtkjExamJcsqd;
import org.springframework.stereotype.Service;

/**
 * 病种+意见Service业务层处理
 *
 * @author ltkj_赵佳豪&李格
 * @date 2023-08-30
 */
@Service
public class LtkjExamJcsqdServiceImpl extends ServiceImpl<LtkjExamJcsqdMapper, LtkjExamJcsqd> implements LtkjExamJcsqdService {

}

 ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjHybgdServiceImpl.java

New file
@@ -0,0 +1,21 @@
package com.ltkj.hosp.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ltkj.hosp.mapper.LtkjExamJcsqdMapper;
import com.ltkj.hosp.mapper.LtkjHybgdMapper;
import com.ltkj.hosp.service.LtkjExamJcsqdService;
import com.ltkj.hosp.service.LtkjHybgdService;
import com.ltkj.hosp.sqlDomain.LtkjExamJcsqd;
import com.ltkj.hosp.sqlDomain.LtkjHybgd;
import org.springframework.stereotype.Service;

/**
 * 病种+意见Service业务层处理
 *
 * @author ltkj_赵佳豪&李格
 * @date 2023-08-30
 */
@Service
public class LtkjHybgdServiceImpl extends ServiceImpl<LtkjHybgdMapper, LtkjHybgd> implements LtkjHybgdService {

}

 ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjHysqdServiceImpl.java

New file
@@ -0,0 +1,21 @@
package com.ltkj.hosp.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ltkj.hosp.mapper.LtkjExamJcsqdMapper;
import com.ltkj.hosp.mapper.LtkjHysqdMapper;
import com.ltkj.hosp.service.LtkjExamJcsqdService;
import com.ltkj.hosp.service.LtkjHysqdService;
import com.ltkj.hosp.sqlDomain.LtkjExamJcsqd;
import com.ltkj.hosp.sqlDomain.LtkjHysqd;
import org.springframework.stereotype.Service;

/**
 * 病种+意见Service业务层处理
 *
 * @author ltkj_赵佳豪&李格
 * @date 2023-08-30
 */
@Service
public class LtkjHysqdServiceImpl extends ServiceImpl<LtkjHysqdMapper, LtkjHysqd> implements LtkjHysqdService {

}

 ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjExamJcbgd.java

New file
@@ -0,0 +1,16 @@
package com.ltkj.hosp.sqlDomain;

import lombok.Data;

/**
 * @Company: 西安路泰科技有限公司
 * @Author: lige
 * @Date: 2023/12/11 16:37
 */
@Data
public class LtkjExamJcbgd {
    private String tmh;
    private String bgImg;
    private String bgUrl;
    private String bgNr;
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjExamJcsqd.java

New file
@@ -0,0 +1,23 @@
package com.ltkj.hosp.sqlDomain;

import lombok.Data;

/**
 * @Company: 西安路泰科技有限公司
 * @Author: lige
 * @Date: 2023/12/11 16:37
 */
@Data
public class LtkjExamJcsqd {
    private String tjh;
    private String tmh;
    private String jclx;
    private String jczlx;
    private String bgys;
    private String bgysid;
    private String sqsj;
    private String jcxmmc;
    private String jcxmid;
    private String bw;
    private String jgzt;
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjHybgd.java

New file
@@ -0,0 +1,26 @@
package com.ltkj.hosp.sqlDomain;

import lombok.Data;

/**
 * @Company: 西安路泰科技有限公司
 * @Author: lige
 * @Date: 2023/12/11 16:37
 */
@Data
public class LtkjHybgd {
    private String tmh;
    private String jcxmid;
    private String jcxm;
    private String tdh;
    private String jyjg;
    private String jgdw;
    private String fwzdz;
    private String fwzgz;
    private String fwz;
    private String jysj;
    private String jyys;
    private String shsj;
    private String shys;
    private String tpurl;
}

 ltkj-hosp/src/main/java/com/ltkj/hosp/sqlDomain/LtkjHysqd.java

New file
@@ -0,0 +1,21 @@
package com.ltkj.hosp.sqlDomain;

import lombok.Data;

/**
 * @Company: 西安路泰科技有限公司
 * @Author: lige
 * @Date: 2023/12/11 16:37
 */
@Data
public class LtkjHysqd {
    private String tjh;
    private String tmh;
    private String bbbh;
    private String bbmc;
    private String xmid;
    private String xmmc;
    private String sqsj;
    private String sqys;
    private String jgsj;
}