MACHINE_ID, EVALUATION_ROOM_ID, MACHINE_NAME, MACHINE_IP, MACHINE_MAC, MACHINE_TYPE, MACHINE_PORT, FTP_PORT, FTP_NAME, FTP_PWD, USED, USE_STATUS UPDATE obe_machine EVALUATION_ROOM_ID = #{ObeMachine.evaluationRoomId} , MACHINE_NAME = #{ObeMachine.machineName} , MACHINE_IP = #{ObeMachine.machineIp} , MACHINE_MAC = #{ObeMachine.machineMac} , MACHINE_TYPE = #{ObeMachine.machineType} , MACHINE_PORT = #{ObeMachine.machinePort} , FTP_PORT = #{ObeMachine.ftpPort} , FTP_NAME = #{ObeMachine.ftpName} , FTP_PWD = #{ObeMachine.ftpPwd} , USED = #{ObeMachine.used} , USE_STATUS = #{ObeMachine.useStatus} , MACHINE_ID = #{ObeMachine.id} insert into obe_machine ( MACHINE_ID, EVALUATION_ROOM_ID, MACHINE_NAME, MACHINE_IP, MACHINE_MAC, MACHINE_TYPE, MACHINE_PORT, FTP_PORT, FTP_NAME, FTP_PWD, USED, USE_STATUS ) values ( #{ObeMachine.id} , #{ObeMachine.evaluationRoomId} , #{ObeMachine.machineName} , #{ObeMachine.machineIp} , #{ObeMachine.machineMac} , #{ObeMachine.machineType} , #{ObeMachine.machinePort} , #{ObeMachine.ftpPort} , #{ObeMachine.ftpName} , #{ObeMachine.ftpPwd} , #{ObeMachine.used} , #{ObeMachine.useStatus} ) SELECT DISTINCT m.* FROM obe_machine m LEFT JOIN OBE_PROJECT_EVALUATION_ROOM r ON m.EVALUATION_ROOM_ID = r.EVALBID_ROOM_ID WHERE r.TENDER_ID = #{tenderId} AND m.USED = #{isUsed} AND m.MACHINE_TYPE = #{machineType} AND m.USE_STATUS = '01' SELECT m.* FROM ( SELECT r.* FROM OBE_EXPERT t JOIN AUTH_LOGIN_RECORD r ON t.USER_ID = r.USER_ID WHERE t.TENDER_ID = #{tenderId} #{loginTime}]]> ) tt JOIN obe_machine m ON tt.MAC = m.MACHINE_MAC; SELECT m.* FROM obe_machine m WHERE m.EVALUATION_ROOM_ID = #{roomeId} AND m.USE_STATUS = '01' ORDER BY m.MACHINE_IP DELETE FROM OBE_MACHINE WHERE EVALUATION_ROOM_ID = #{roomId}