软工随笔（软件工程日报）

package com.example.teamwebb.mapper;

import com.example.teamweb.model.Equipment;
import com.example.teamweb.model.Station;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface EquipmentMapper {
// 根据车站ID查询设备列表
@Select("SELECT e.*, s.stationName " +
"FROM incmsystem.equipment e " +
"JOIN incmsystem.station s ON e.station_id = s.stationId " +
"WHERE e.station_id = #{stationId} " +
"ORDER BY e.equipment_name")
List selectByStationId(Integer stationId);

// 查询所有车站
@Select("SELECT * FROM incmsystem.station ORDER BY stationName")
List<Station> selectAllStations();

// 根据设备ID查询设备详情
@Select("SELECT e.*, s.stationName FROM incmsystem.equipment e " +
        "JOIN incmsystem.station s ON e.station_id = s.stationId " +
        "WHERE e.equipment_id = #{equipmentId}")
Equipment selectById(Integer equipmentId);

@Select("SELECT e.*, s.stationName FROM incmsystem.equipment e " +
        "JOIN incmsystem.station s ON e.station_id = s.stationId " +
        "ORDER BY e.equipment_name")
List<Equipment> selectAllEquipment();

@Insert("INSERT INTO incmsystem.equipment (equipment_name, equipment_type, station_id, " +
        "equipment_status, installation_location, maintenance_record) " +
        "VALUES (#{equipmentName}, #{equipmentType}, #{stationId}, " +
        "#{equipmentStatus}, #{installationLocation}, #{maintenanceRecord})")
@Options(useGeneratedKeys = true, keyProperty = "equipmentId")
int insertEquipment(Equipment equipment);

@Update("UPDATE incmsystem.equipment SET " +
        "equipment_name = #{equipmentName}, " +
        "equipment_type = #{equipmentType}, " +
        "station_id = #{stationId}, " +
        "equipment_status = #{equipmentStatus}, " +
        "installation_location = #{installationLocation}, " +
        "maintenance_record = #{maintenanceRecord} " +
        "WHERE equipment_id = #{equipmentId}")
int updateEquipment(Equipment equipment);

@Delete("DELETE FROM incmsystem.equipment WHERE equipment_id = #{equipmentId}")
int deleteEquipment(Integer equipmentId);

}