修改文件时同时修改存在数据库的数据

lxw

2022-10-19 7d69500440ca5ed8ed92937754e425241fcbfa37

修改文件时同时修改存在数据库的数据

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

@@ -1,6 +1,7 @@
package com.whyc.mapper;

import com.whyc.pojo.FileParam;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;
@@ -14,4 +15,6 @@
    int deleteParamByFileId(int fileId);
    //删除所有文件参数
    void deleteParamByStationId(int stationId);
    //修改文件对应的数据库数据
    void updateParamByFileUrl(@Param("fileParam") FileParam fileParam, @Param("filePath") String filePath);
}

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

@@ -117,6 +117,8 @@
        if(map.size()>0){
            bl=XmlFileOpreate.writeXml(map,filePath);
        }
        //修改文件对应的数据库数据
        paramMapper.updateParamByFileUrl(fileParam,filePath);
        return new Response().setII(1,bl,map,"修改文件");
    }
    //通过修改属性窗口值来修改文件值

 src/main/resources/mapper/FileParamMapper.xml

@@ -1,6 +1,20 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.whyc.mapper.FileParamMapper">
    <update id="updateParamByFileUrl">
        update tb_file_param p,tb_file_info i set
            p.upload_time=#{fileParam.uploadTime},p.test_time=#{fileParam.testTime},p.version=#{fileParam.version},
            p.upload_flag=#{fileParam.uploadFlag},p.batt_group_name=#{fileParam.battGroupName},p.batt_brand=#{fileParam.battBrand},
            p.batt_model=#{fileParam.battModel},p.batt_batch=#{fileParam.battBatch},p.batt_station=#{fileParam.battStation},
            p.battline_name=#{fileParam.battlineName},p.batt_tha=#{fileParam.battTha},p.batt_errFlag=#{fileParam.battErrflag},p.batt_testNum=#{fileParam.battTestnum},
            p.batt_faultNum=#{fileParam.battFaultnum},p.batt_cap=#{fileParam.battCap},p.batt_count=#{fileParam.battCount},
            p.batt_vol=#{fileParam.battVol},p.batt_res=#{fileParam.battRes},p.group_num=#{fileParam.groupNum},
            p.volLowCoeK1=#{fileParam.volLowCoeK1},p.volHighCoeK2=#{fileParam.volHighCoeK2},p.resGoodCoeK3=#{fileParam.resGoodCoeK3},
            p.resBadCoeK4=#{fileParam.resBadCoeK4},p.sample_percent=#{fileParam.samplePercent},p.highTempAlarm=#{fileParam.highTempAlarm},
            p.chainRes=#{fileParam.chainRes},p.evaluation_mode=#{fileParam.evaluationMode},p.factor_disabled=#{fileParam.factorDisabled}
        where p.file_id=i.file_id
          and i.file_url=#{filePath}
    </update>
    <delete id="deleteParamByFileId">
        delete from tb_file_param where  file_id=#{fileId}
    </delete>