中-93CommonMapper.xml;160行

lxw

2023-10-31 4a687665280ee8c21aee3c20e1c325f6d8b87c8c

中-93CommonMapper.xml;160行

 src/main/java/com/whyc/mapper/CommonMapper.java

@@ -25,7 +25,7 @@

    String existTable(String dbName, String tableName);

    void truncate(String dbName, String tableName);
    //void truncate(String dbName, String tableName);

    void createTable4AlarmVoiceSet();


 src/main/java/com/whyc/service/StandardFeatureCurveService.java

@@ -97,7 +97,8 @@
               //mapper.createTable(titleNameUnion);
               subService.createTable(titleNameUnion);
           }else{ //存在表,先清空数据
               commonMapper.truncate("web_site", "tb_standard_feature_curve_"+titleNameUnion);
               //commonMapper.truncate("web_site", "tb_standard_feature_curve_"+titleNameUnion);
               subService.truncate("web_site", "tb_standard_feature_curve_"+titleNameUnion);
           }
           //mapper.insertBatch(titleNameUnion,curveList2);
           subService.insertBatch(titleNameUnion,curveList2);
@@ -621,11 +622,13 @@
        param.setUseralarmEn(0);
        param.setAlarmId(110119l);
        int flag=subService.updateParam(param);*/
        /*61*/
        /*61
        //List list=subService.serchisStandard(1000059);
        //List list=subService.serchCurrent(1000059);
        //List list=subService.getResInfoByBattGroupId(1000059);
        subService.deleteByTestRecordCount(1000059,1);
        subService.deleteByTestRecordCount(1000059,1);*/
        /*93*/
        subService.truncate("db_batt_testdata","tb_battresdata_1000003");
        return  new Response().setII(1,true,0,null);
    }
}

 src/main/java/com/whyc/service/SubTablePageInfoService.java

@@ -3173,4 +3173,10 @@
        sqlExecuteService.execute(sql);
    }

    //93-CommonMapper.xml;160行
    public void truncate(String dbName, String tableName){
        String sql="TRUNCATE "+dbName+".`"+tableName+"`";
        sqlExecuteService.execute(sql);
    }

}

 src/main/resources/mapper/CommonMapper.xml

@@ -157,9 +157,9 @@
        AppServer_Reinit_BattGroupData_FBO4831_EN = 1
        WHERE num > 0
    </update>
    <delete id="truncate">
    <!--<delete id="truncate">
        TRUNCATE ${dbName}.`${tableName}`
    </delete>
    </delete>-->

    <select id="getMaxValue" resultType="java.lang.Object">
        select max(${field}) from ${schema}.${table}