吴健
2024-11-16 d1851ded02d6f253ed2ca1459c4e514102c975d5
add sql
已修改3个文件
19 ■■■■■ 文件已修改
billion-admin/src/main/resources/application-druid.yml 12 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
billion-generator/src/main/java/com/billion/generator/controller/GenController.java 4 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
billion-main/src/main/java/com/billion/main/bs/workshop/service/impl/BsWorkshopServiceImpl.java 3 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
billion-admin/src/main/resources/application-druid.yml
@@ -6,16 +6,16 @@
        druid:
            # 主库数据源
            master:
                url: jdbc:mysql://127.0.0.1:3306/billion-db?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
                url: jdbc:mysql://192.168.0.189:3306/billion-db-base?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
                username: root
                password: root
                password: 123456
            # 从库数据源
            slave:
                # 从数据源开关/默认关闭
                enabled: false
                url:
                username:
                password:
                enabled: true
                url: jdbc:mysql://192.168.0.189:3306/billion-db-self?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
                username: root
                password: 123456
            # 初始连接数
            initialSize: 5
            # 最小连接池数量
billion-generator/src/main/java/com/billion/generator/controller/GenController.java
@@ -6,6 +6,9 @@
import java.util.List;
import java.util.Map;
import javax.servlet.http.HttpServletResponse;
import com.billion.common.annotation.DataSource;
import com.billion.common.enums.DataSourceType;
import org.apache.commons.io.IOUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.access.prepost.PreAuthorize;
@@ -84,6 +87,7 @@
     */
    @PreAuthorize("@ss.hasPermi('tool:gen:list')")
    @GetMapping("/db/list")
    @DataSource(value = DataSourceType.SLAVE)
    public TableDataInfo dataList(GenTable genTable)
    {
        startPage();
billion-main/src/main/java/com/billion/main/bs/workshop/service/impl/BsWorkshopServiceImpl.java
@@ -3,6 +3,8 @@
import java.util.List;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.billion.common.annotation.DataSource;
import com.billion.common.enums.DataSourceType;
import com.billion.common.utils.DateUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@@ -17,6 +19,7 @@
 * @date 2024-11-12
 */
@Service
@DataSource(value = DataSourceType.SLAVE)
public class BsWorkshopServiceImpl extends ServiceImpl<BsWorkshopMapper, BsWorkshop> implements IBsWorkshopService
{
    @Autowired