sql记录

zhaowenxuan

2025-02-24 ec2bd151a3220b34eb7e33d43d25908b45ff349c

 ltkj-framework/src/main/java/com/ltkj/framework/interceptor/DBChangeInterceptor.java

@@ -6,6 +6,7 @@
import com.google.gson.Gson;
import com.ltkj.db.DataSourceConfig;
import com.ltkj.db.DataSourceContextHolder;
import com.ltkj.framework.config.DruidConfig;
import com.ltkj.hosp.domain.DictHosp;
import com.ltkj.hosp.service.IDictHospService;
import org.springframework.beans.factory.annotation.Autowired;
@@ -23,13 +24,15 @@
 * @Date: 2025/2/7 11:07
 */
@Component
@Order(2)
@Order(1)
public class DBChangeInterceptor implements HandlerInterceptor {

    @Autowired
    private IDictHospService dictHospService;
    @Autowired
    private DataSourceConfig dataSourceConfig;
//    @Autowired
//    private DruidConfig druidConfig;

    @Override
    public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws IOException {
@@ -40,18 +43,25 @@
            response.getWriter().write("{\"message\":\"401：找不到院区编号\"}");
            return false;
        }
        DataSourceContextHolder.setDataSourceKey("default");
        LambdaQueryWrapper<DictHosp> wrapper = new LambdaQueryWrapper<>();
        wrapper.eq(DictHosp::getCode,hospId);
        DictHosp hosp = dictHospService.getOne(wrapper);
        if (hosp == null || hosp.getDatabase() == null || hosp.getDatabase().trim().isEmpty()) {
            response.setStatus(HttpServletResponse.SC_UNAUTHORIZED);
            response.setContentType("application/json;charset=UTF-8");
            response.getWriter().write("{\"message\":\"401：找不到院区数据\"}");
//        DictHosp hosp = null;
        try {
            DataSourceContextHolder.setDataSourceKey("default");
            LambdaQueryWrapper<DictHosp> wrapper = new LambdaQueryWrapper<>();
            wrapper.eq(DictHosp::getCode,hospId);
            DictHosp hosp = dictHospService.getOne(wrapper);
            if (hosp == null || hosp.getDbname() == null || hosp.getDbname().trim().isEmpty()) {
                response.setStatus(HttpServletResponse.SC_UNAUTHORIZED);
                response.setContentType("application/json;charset=UTF-8");
                response.getWriter().write("{\"message\":\"401：找不到院区数据\"}");
                return false;
            }
            dataSourceConfig.addDataSource(hosp.getDbname());
//            druidConfig.addDataSource(hosp.getDbname());
            DataSourceContextHolder.setDataSourceKey(hosp.getDbname());
        } catch (IOException e) {
            return false;
        }
        dataSourceConfig.addDataSource(hosp.getDatabase());
        DataSourceContextHolder.setDataSourceKey(hosp.getDatabase());

        return true;
    }