#

lsh

2023-03-04 d6b7f4ce20197e5bcc91c9e952bcc10420fb4128

 src/main/java/com/zy/common/service/erp/ErpSqlServer.java

@@ -1,6 +1,7 @@
package com.zy.common.service.erp;

import com.core.common.Cools;
import com.zy.core.News;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@@ -130,14 +131,14 @@
            {
                pstm = conn.prepareStatement(sql);
            } else {
                log.error("更新ERP中间表失败===>>数据库连接conn为空");
                log.error("更新ERP中间表失败===>>" + sql);
                News.error("更新ERP中间表失败===>>数据库连接conn为空");
                News.error("更新ERP中间表失败===>>" + sql);
            }
            return pstm.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
            log.error("更新ERP中间表失败===>>" + sql);
            log.error("更新ERP中间表失败===>>" + e);
            News.error("更新ERP中间表失败===>>" + sql);
            News.error("更新ERP中间表失败===>>" + e);
            return 0;
        } finally {
            release();
@@ -173,7 +174,7 @@
            Class.forName(erpDbProperties.getDriver_class_name()).newInstance();
            conn = DriverManager.getConnection(erpDbProperties.getUr(), erpDbProperties.getUsername(), erpDbProperties.getPassword());
        } catch (Exception e) {
            log.error("获取ERP数据库连接失败");
            News.error("获取ERP数据库连接失败");
            e.printStackTrace();
            throw new RuntimeException("获取ERP数据库连接失败");
        }
@@ -183,7 +184,7 @@
//                Class.forName(erpDbProperties.getDriver_class_name()).newInstance();
//                this.conn = DriverManager.getConnection(erpDbProperties.getUr(), erpDbProperties.getUsername(), erpDbProperties.getPassword());
//            } catch (Exception e) {
//                log.error("获取ERP数据库连接失败");
//                News.error("获取ERP数据库连接失败");
//                e.printStackTrace();
//                throw new RuntimeException("获取ERP数据库连接失败");
//            }