java修改本地数据库虚拟数据

package com.supcon.mare.tankinfo.controller;

import com.supcon.mare.tankinfo.entity.*;
import com.supcon.mare.tankinfo.repository.*;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.Iterator;

/**
 * @author: zhaoxu
 * @date: 2020/10/19 10:25
 */
@RestController
@RequestMapping("/oms")
public class update {
    @Autowired
    OtherDeviceManageRepository otherDeviceManageRepository;
    @Autowired
    BlindPlateManageRepository blindPlateManageRepository;
    @Autowired
    FlowmeterManageRepository flowmeterManageRepository;
    @Autowired
    HeadManageRepository headManageRepository;
    @Autowired
    IntersectionManageRepository intersectionManageRepository;
    @Autowired
    OffPageConnectorManageRepository offPageConnectorManageRepository;
    @GetMapping("otherDeviceUpdate")
    public void updateTanks() {
        Iterator<OtherDeviceEntity> all = otherDeviceManageRepository.findAll().iterator();
        int name=1;
        int name1=1;
        while(all.hasNext()){
            int random = (int) (Math.random()*(2-1+1)+1);
            int code = (int) (Math.random()*(9999999-1000000+1)+1000000);
            int switcht =(int) (Math.random()*(999999-100000+1)+100000);
            int tankAreaId = (int) (Math.random()*(20-1+1)+1);

            OtherDeviceEntity next = all.next();
            next.setOtherDeviceCode("OD_"+String.valueOf(code));
            next.setSwitchTag("S_"+switcht);
            next.setTankAreaId(Long.valueOf(tankAreaId));
            if(random==1){
                next.setDeviceStatus("正常");
                next.setStartDevice(1);
                next.setOtherDeviceName("汽车站"+String.valueOf(name));
                next.setRemark("汽车站"+String.valueOf(name));
                next.setEndDevice(1);
                name++;
            }
            else{
                next.setDeviceStatus("维修");
                next.setStartDevice(0);
                next.setOtherDeviceName("码头"+String.valueOf(name1));
                next.setRemark("码头"+String.valueOf(name1));
                next.setEndDevice(0);
                name1++;
            }
            otherDeviceManageRepository.save(next);

        }
    }
    @GetMapping("offPageConnectorManageRepository")
    public void offPageConnectorManageRepository() {
        Iterator<OffPageConnectorEntity> all = offPageConnectorManageRepository.findAll().iterator();
        int name = 1;
        while(all.hasNext()){
            int random = (int) (Math.random()*(2-1+1)+1);
            int code = (int) (Math.random()*(9999999-1000000+1)+1000000);
            int switcht =(int) (Math.random()*(999999-100000+1)+100000);
            int tankAreaId = (int) (Math.random()*(20-1+1)+1);
            TankAreaEntity tankAreaEntity = new TankAreaEntity();
            TankAreaEntity tankAreaRelationEntity = new TankAreaEntity();
            tankAreaEntity.setId(Long.valueOf(tankAreaId));


            OffPageConnectorEntity next = all.next();
            next.setConnectorCode("OPC_"+String.valueOf(code));
            next.setConnectorName("页间连接符_"+String.valueOf(name));
            next.setRemark("页间连接符_"+String.valueOf(name));
            int tankAreaRelation = (int) (Math.random()*(20-1+1)+1);
            for(int i=0;i<1000000000;i++){
                tankAreaRelation = (int) (Math.random()*(20-1+1)+1);
                if(tankAreaRelation!=tankAreaId){
                    break;
                }
            }
            tankAreaRelationEntity.setId(Long.valueOf(tankAreaRelation));
            next.setTankAreaRelation(tankAreaRelationEntity);
            next.setTankArea(tankAreaEntity);

            next.setSwitchTag("S_"+switcht);
            if(random==1){
                next.setDeviceStatus("正常");
                next.setStartDevice(1);
                next.setEndDevice(1);
            }
            else{
                next.setDeviceStatus("维修");
                next.setStartDevice(0);
                next.setEndDevice(0);
            }
            offPageConnectorManageRepository.save(next);
            name++;
        }
    }
    @GetMapping("intersectionManageRepository")
    public void intersectionManageRepository() {
        Iterator<IntersectionInfoEntity> all = intersectionManageRepository.findAll().iterator();
        int name = 1;
        while(all.hasNext()){
            int random = (int) (Math.random()*(2-1+1)+1);
            int code = (int) (Math.random()*(9999999-1000000+1)+1000000);
            int switcht =(int) (Math.random()*(999999-100000+1)+100000);
            int tankAreaId = (int) (Math.random()*(20-1+1)+1);

            IntersectionInfoEntity next = all.next();
            next.setIntersectionCode("IS_"+String.valueOf(code));
            next.setIntersectionName("交汇点_"+String.valueOf(name));
            next.setRemark("交汇点_"+String.valueOf(name));
            next.setSwitchTag("S_"+switcht);
            next.setTankAreaId(Long.valueOf(tankAreaId));
            if(random==1){
                next.setDeviceStatus("正常");
                next.setMedium("原油");
                next.setOccupied(1);
            }
            else{
                next.setDeviceStatus("维修");
                next.setMedium("汽油");
                next.setOccupied(0);
            }
            intersectionManageRepository.save(next);
            name++;
        }
    }
    @GetMapping("headManageRepository")
    public void headManageRepository() {
        Iterator<HeadInfoEntity> all = headManageRepository.findAll().iterator();
        int name = 1;
        while(all.hasNext()){
            int random = (int) (Math.random()*(2-1+1)+1);
            int code = (int) (Math.random()*(9999999-1000000+1)+1000000);
            int switcht =(int) (Math.random()*(999999-100000+1)+100000);
            int tankAreaId = (int) (Math.random()*(20-1+1)+1);
            HeadInfoEntity next = all.next();
            next.setHeadCode("H_"+String.valueOf(code));
            next.setHeadName("封头_"+String.valueOf(name));
            next.setRemark("封头_"+String.valueOf(name));
            next.setPreviewTag("P_"+switcht);
            next.setTankAreaId(Long.valueOf(tankAreaId));
            if(random==1){
                next.setDeviceStatus("正常");

            }
            else{
                next.setDeviceStatus("维修");
            }
            headManageRepository.save(next);
            name++;
        }
    }
    @GetMapping("flowmeterManageRepository")
    public void flowmeterManageRepository() {
        Iterator<FlowmeterInfoEntity> all = flowmeterManageRepository.findAll().iterator();
        int name = 1;
        while(all.hasNext()){
            int random = (int) (Math.random()*(3-1+1)+1);
            int code = (int) (Math.random()*(9999999-1000000+1)+1000000);
            int switcht =(int) (Math.random()*(999999-100000+1)+100000);
            int tankAreaId = (int) (Math.random()*(20-1+1)+1);
            int cs = (int) (Math.random()*(999999-100000+1)+100000);

            FlowmeterInfoEntity next = all.next();
            next.setFlowmeterCode("FM_"+String.valueOf(code));
            next.setFlowmeterName("流量计_"+String.valueOf(name));
            next.setRemark("流量计_"+String.valueOf(name));
            next.setSwitchTag("S_"+switcht);
            next.setTankAreaId(Long.valueOf(tankAreaId));
            next.setCurrentSpeed("CS_"+String.valueOf(cs));
            next.setValid(1);
            if(random==1){
                next.setDeviceStatus("正常");
                next.setCumulativeFlowMax("500000吨");
                next.setCumulativeFlowMin("3吨");
                next.setCumulativeFlowTotal("21564吨");
                next.setCurrentSpeedMax("5吨/秒");
                next.setCurrentSpeedMin("1吨/秒");
                next.setOccupied(1);
                next.setFlowmeterType("质量流量计");
            }
            else if(random==2){
                next.setDeviceStatus("维修");
                next.setCumulativeFlowMax("400000吨");
                next.setCumulativeFlowMin("2吨");
                next.setCumulativeFlowTotal("19845吨");
                next.setCurrentSpeedMax("4吨/秒");
                next.setCurrentSpeedMin("0.5吨/秒");
                next.setOccupied(1);
                next.setFlowmeterType("质量流量计");
            }
            else{
                next.setDeviceStatus("停用");
                next.setCumulativeFlowMax("300000吨");
                next.setCumulativeFlowMin("3吨");
                next.setCumulativeFlowTotal("39546吨");
                next.setCurrentSpeedMax("3吨/秒");
                next.setCurrentSpeedMin("0.8吨/秒");
                next.setOccupied(0);
                next.setFlowmeterType("体积流量计");
            }
            flowmeterManageRepository.save(next);
            name++;
        }
    }
    @GetMapping("blindPlateManageRepository")
    public void blindPlateManageRepository() {
        Iterator<BlindPlateEntity> all = blindPlateManageRepository.findAll().iterator();
        int name=1;
        while(all.hasNext()){
            int random = (int) (Math.random()*(2-1+1)+1);
            int code = (int) (Math.random()*(9999999-1000000+1)+1000000);
            int switcht =(int) (Math.random()*(999999-100000+1)+100000);
            int tankAreaId = (int) (Math.random()*(20-1+1)+1);

            BlindPlateEntity next = all.next();
            next.setBlindCode("OD_"+String.valueOf(code));
            next.setBlindName("盲板_"+String.valueOf(name));
            next.setRemark("盲板_"+String.valueOf(name));
            next.setSwitchTag("S_"+switcht);
            next.setTankAreaId(Long.valueOf(tankAreaId));
            if(random==1){
                next.setDeviceStatus("正常");
            }
            else{
                next.setDeviceStatus("维修");
            }
            blindPlateManageRepository.save(next);
            name++;
        }
    }

}