select p.* from t_pms p where 1=1 and plantSeq = #{plantSeq} and ip = #{ip} select m.*, p.name as plantName from t_pms m, t_plant p where m.plantSeq = p.seq and m.plantSeq = #{plantSeq} update t_pms set ip = #{ip}, port = #{port}, pmsStatus = #{pmsStatus}, startIdx = #{startIdx}, pmsMaker = #{pmsMaker}, pmsModel = #{pmsModel}, pcsMaker = #{pcsMaker}, pcsVolume = #{pcsVolume}, pcsQuantity = #{pcsQuantity}, batteryMaker = #{batteryMaker}, batteryModel = #{batteryModel}, batteryVolume = #{batteryVolume}, batteryQuantity = #{batteryQuantity}, msgGroupPcs = #{msgGroupPcs}, msgGroupBattery = #{msgGroupBattery}, updateDatetime = now() where plantSeq = #{plantSeq} insert into t_pms ( plantSeq, ip, port, pmsStatus, startIdx, pmsMaker, pmsModel, pcsMaker, pcsVolume, pcsQuantity, batteryMaker, batteryModel, batteryVolume, batteryQuantity, msgGroupPcs, msgGroupBattery, createDateTime, updateDatetime ) values ( #{plantSeq}, #{ip}, #{port}, #{pmsStatus}, #{startIdx}, #{pmsMaker}, #{pmsModel}, #{pcsMaker}, #{pcsVolume}, #{pcsQuantity}, #{batteryMaker}, #{batteryModel}, #{batteryVolume}, #{batteryQuantity}, #{msgGroupPcs}, #{msgGroupBattery}, now(), now() )