package com.txgl.entity;

import java.beans.SimpleBeanInfo;
import java.io.Serializable;

public class RoomEquipmentEntity  extends SimpleBeanInfo implements Serializable{
    /**
     * 
     */
    private static final long serialVersionUID = 1L;
  
    private Long roomEquipmentId;
    private Long engineRoomId;
    private Long equipmentId;
    private int equipmentLeft;
    private int equipmentTop;
    private int equipmentNum;
    private String equipmentName;
    
    public RoomEquipmentEntity() {
        super();
    }

    public RoomEquipmentEntity(Long roomEquipmentId, Long engineRoomId, Long equipmentId, int equipmentLeft,
            int equipmentTop, int equipmentNum, String equipmentName) {
        super();
        this.roomEquipmentId = roomEquipmentId;
        this.engineRoomId = engineRoomId;
        this.equipmentId = equipmentId;
        this.equipmentLeft = equipmentLeft;
        this.equipmentTop = equipmentTop;
        this.equipmentNum = equipmentNum;
        this.equipmentName = equipmentName;
    }

    public String getEquipmentName() {
        return equipmentName;
    }
    
    public void setEquipmentName(String equipmentName) {
        this.equipmentName = equipmentName;
    }

    public Long getRoomEquipmentId() {
        return roomEquipmentId;
    }

    public void setRoomEquipmentId(Long roomEquipmentId) {
        this.roomEquipmentId = roomEquipmentId;
    }

    public Long getEngineRoomId() {
        return engineRoomId;
    }

    public void setEngineRoomId(Long engineRoomId) {
        this.engineRoomId = engineRoomId;
    }

    public Long getEquipmentId() {
        return equipmentId;
    }

    public void setEquipmentId(Long equipmentId) {
        this.equipmentId = equipmentId;
    }

    public int getEquipmentLeft() {
        return equipmentLeft;
    }

    public void setEquipmentLeft(int equipmentLeft) {
        this.equipmentLeft = equipmentLeft;
    }

    public int getEquipmentTop() {
        return equipmentTop;
    }

    public void setEquipmentTop(int equipmentTop) {
        this.equipmentTop = equipmentTop;
    }

    public int getEquipmentNum() {
        return equipmentNum;
    }

    public void setEquipmentNum(int equipmentNum) {
        this.equipmentNum = equipmentNum;
    }

    }
}

package com.txgl.mapper.db1;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.apache.ibatis.annotations.UpdateProvider;

import com.txgl.entity.RoomEquipmentEntity;import com.txgl.provider.EngineRoomProvider;



public interface EngineRoomMapper {

    /**
     * 删除
     * @param equipmentIds
     */
    public void removeRoomEquipments(List<String> equipmentIds);
}

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.txgl.mapper.db1.EngineRoomMapper">
    <resultMap id="BaseResultMap" type="com.txgl.entity.RoomEquipmentEntity">
        <id column="roomEquipmentId" property="roomEquipmentId" jdbcType="BIGINT" />
        <result column="engineRoomId" property="engineRoomId" jdbcType="BIGINT" />
        <result column="equipmentId" property="equipmentId" jdbcType="BIGINT" />
    </resultMap>

    <delete id="removeRoomEquipments" parameterType="java.util.List">
        DELETE FROM ENGINEROOM_EQUIPMENT eq WHERE eq.equipmentId in 
        <foreach item="item" index="index" collection="list" open="(" separator="," close=")">
            #{item}
        </foreach>
    </delete>


</mapper>