中-ElePriceMapper.xml;22行

lxw

2023-10-30 8e61b077398cd19dfeee6b7f6531df908a29c99a

中-ElePriceMapper.xml;22行

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

@@ -12,7 +12,7 @@

    int deleteEleprice(@Param("tableName")String tableName);

    int deleteByNum(@Param("tableName")String tableName,@Param("num") int num);
    //int deleteByNum(@Param("tableName")String tableName,@Param("num") int num);

    List<ElePrice> getList(@Param("tableName") String tableName);


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

@@ -5,6 +5,7 @@
import com.whyc.dto.Response;
import com.whyc.mapper.ElePriceMapper;
import com.whyc.pojo.ElePrice;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
@@ -14,6 +15,9 @@
public class ElePriceService {
    @Resource
    private ElePriceMapper mapper;

    @Autowired
    private SubTablePageInfoService subService;

    public Response addElePriceList(List<ElePrice> list){
        if (list!=null&&list.size()>0){
@@ -51,7 +55,8 @@
    public Response delete (List<ElePrice> list){
        if(list!=null&& list.size()>0){
            for (ElePrice e:list) {
                mapper.deleteByNum("tb_eleprice_"+ e.getTmpId(),e.getNum());
                //mapper.deleteByNum("tb_eleprice_"+ e.getTmpId(),e.getNum());
                subService.deleteByNum("tb_eleprice_"+ e.getTmpId(),e.getNum());
            }
        }
        return new Response().set(1,true,"删除成功");

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

@@ -514,7 +514,10 @@
        list.add(sf2);
        subService.insertBatch("122v150ah_0.15c",list);
        subService.createTable("123v150ah_0.15c");*/
        subService.delete(1000094,1);
        /*6
        subService.delete(1000094,1);*/
        /*7*/
        subService.deleteByNum("tb_eleprice_1014",5);
        return  new Response().setII(1,true,null,null);
    }
}

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

@@ -1977,4 +1977,10 @@
        String sql="delete from  db_fbo_testdata.tb_fbotestdata_"+battGroupId+" where test_record_count = "+testRecordCount+" ";
        sqlExecuteService.execute(sql);
    }

    //7-ElePriceMapper.xml;22行
    public void deleteByNum(String tableName, int num){
        String sql=" delete from web_site."+tableName+" where num = "+num+" ";
        sqlExecuteService.execute(sql);
    }
}

 src/main/resources/mapper/ElePriceMapper.xml

@@ -19,9 +19,9 @@
        delete from web_site.${tableName}
    </delete>

    <delete id="deleteByNum">
    <!--<delete id="deleteByNum">
        delete from web_site.${tableName} where num = #{num}
    </delete>
    </delete>-->
    <select id="getList" resultType="com.whyc.pojo.ElePrice">
        select * from web_site.${tableName} order by tmp_starttime asc
    </select>