Слияние кода завершено, страница обновится автоматически
вместо нескольких при один-ко-многим запросе.
1.5.2
public void getPc() {
MPJLambdaWrapper<NetworkParam> wrapper = new MPJLambdaWrapper<>();
wrapper.selectAll(NetworkParam.class)
.selectCollection(Ddr.class, HardwareDto::getMemory)
.leftJoin(Ddr.class, Ddr::getId, NetworkParam::getId);
List<HardwareDto> hardwareDtos = baseMapper.selectJoinList(HardwareDto.class, wrapper);
hardwareDtos.forEach(System.out::println);
}
==> Preparing: SELECT a.id,a.time,a.hostName,a.domainName,a.gateway,a.ip,a.mac,a.dnsServers,a.intranet,a.internet,a1.id AS joina_id,a1.bankLabel,a1.capacity,a1.clockSpeed,a1.manufacturer,a1.memoryType,a1.partNumber,a1.serialNumber FROM NetworkParam a LEFT JOIN Ddr a1 ON (a1.id = a.id)
==> Parameters:
<== Columns: id, time, hostName, domainName, gateway, ip, mac, dnsServers, intranet, internet, joina_id, bankLabel, capacity, clockSpeed, manufacturer, memoryType, partNumber, serialNumber
<== Row: 7, null, 致知, 致知, 192.168.1.1, [192.168.1.92], b0:25:aa:74:61:ed, [192.168.10.8, 202.96.128.86], 1, 1, 7, BANK 0, 16 GiB, 5.6 GHz, Crucial Technology, DDR5, CT16G56C46S5.C8D, E91EEEE4
<== Row: 7, null, 致知, 致知, 192.168.1.1, [192.168.1.92], b0:25:aa:74:61:ed, [192.168.10.8, 202.96.128.86], 1, 1, 7, BANK 0, 16 GiB, 5.6 GHz, Crucial Technology, DDR5, CT16G56C46S5.C8D, E91D2F41
<== Row: 8, null, 致知, 致知, 192.168.1.1, [192.168.1.92], b0:25:aa:74:61:ed, [192.168.10.8, 202.96.128.86], 1, 1, 8, BANK 0, 16 GiB, 5.6 GHz, Crucial Technology, DDR5, CT16G56C46S5.C8D, E91EEEE4
<== Row: 8, null, 致知, 致知, 192.168.1.1, [192.168.1.92], b0:25:aa:74:61:ed, [192.168.10.8, 202.96.128.86], 1, 1, 8, BANK 0, 16 GiB, 5.6 GHz, Crucial Technology, DDR5, CT16G56C46S5.C8D, E91D2F41
<== Row: 9, null, 致知, 致知, 192.168.1.1, [192.168.1.92], b0:25:aa:74:61:ed, [192.168.10.8, 202.96.128.86], 1, 1, 9, BANK 0, 16 GiB, 5.6 GHz, Crucial Technology, DDR5, CT16G56C46S5.C8D, E91EEEE4
<== Row: 9, null, 致知, 致知, 192.168.1.1, [192.168.1.92], b0:25:aa:74:61:ed, [192.168.10.8, 202.96.128.86], 1, 1, 9, BANK 0, 16 GiB, 5.6 GHz, Crucial Technology, DDR5, CT16G56C46S5.C8D, E91D2F41
<== Total: 6
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@22efe67]
HardwareDto(id=7, time=null, hostName=致知, domainName=致知, gateway=192.168.1.1, ip=[192.168.1.92], mac=b0:25:aa:74:61:ed, dnsServers=[192.168.10.8, 202.96.128.86], intranet=true, internet=true, os=null, cpu=null, disp=null, memory=[Ddr(id=7, bankLabel=BANK 0, capacity=16 GiB, clockSpeed=5.6 GHz, manufacturer=Crucial Technology, memoryType=DDR5, partNumber=CT16G56C46S5.C8D, serialNumber=E91EEEE4)], hardDisk=null, graphicsCard=null)
HardwareDto(id=8, time=null, hostName=致知, domainName=致知, gateway=192.168.1.1, ip=[192.168.1.92], mac=b0:25:aa:74:61:ed, dnsServers=[192.168.10.8, 202.96.128.86], intranet=true, internet=true, os=null, cpu=null, disp=null, memory=[Ddr(id=8, bankLabel=BANK 0, capacity=16 GiB, clockSpeed=5.6 GHz, manufacturer=Crucial Technology, memoryType=DDR5, partNumber=CT16G56C46S5.C8D, serialNumber=E91EEEE4)], hardDisk=null, graphicsCard=null)
HardwareDto(id=9, time=null, hostName=致知, domainName=致知, gateway=192.168.1.1, ip=[192.168.1.92], mac=b0:25:aa:74:61:ed, dnsServers=[192.168.10.8, 202.96.128.86], intranet=true, internet=true, os=null, cpu=null, disp=null, memory=[Ddr(id=9, bankLabel=BANK 0, capacity=16 GiB, clockSpeed=5.6 GHz, manufacturer=Crucial Technology, memoryType=DDR5, partNumber=CT16G56C46S5.C8D, serialNumber=E91EEEE4)], hardDisk=null, graphicsCard=null)