ruoyi—vue为基础新建连表接口

domain

//ProcedureEquipmentInfo.java
package com.ruoyi.system.domain;

public class ProcedureEquipmentInfo {
    private Long id;
    private Long equipmentId;
    private String equipmentName;

    // 构造方法
    public ProcedureEquipmentInfo() {
    }

    public ProcedureEquipmentInfo(Long id, Long equipmentId, String equipmentName) {
        this.id = id;
        this.equipmentId = equipmentId;
        this.equipmentName = equipmentName;
    }

    // Getters 和 Setters
    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }



    public Long getEquipmentId() {
        return equipmentId;
    }

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

    public String getEquipmentName() {
        return equipmentName;
    }

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

Mapper.xml

<?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.ruoyi.system.mapper.ProcedureEquipmentMapper">
    
    <resultMap type="ProcedureEquipment" id="ProcedureEquipmentResult">
        <result property="id"    column="Id"    />
        <result property="procedureId"    column="procedure_id"    />
        <result property="equipmentId"    column="equipment_id"    />
        <result property="remark"    column="remark"    />
    </resultMap>

    <sql id="selectProcedureEquipmentVo">
        select Id, procedure_id, equipment_id, remark from procedure_equipment
    </sql>


    <select id="getEquipmentIdAndEquipmentNameOnProcedureId" resultType="ProcedureEquipmentInfo">
        SELECT pe.id AS id, e.id AS equipmentId, e.equipment_name AS equipmentName
        FROM equipment e
                 INNER JOIN procedure_equipment pe ON e.id = pe.equipment_id
        WHERE pe.procedure_id = #{id}
    </select>

</mapper>

Mapper

public interface ProcedureEquipmentMapper 
{

    public List<ProcedureEquipmentInfo> getEquipmentIdAndEquipmentNameOnProcedureId(Long id);
}

servicelmpl

@Service
public class ProcedureEquipmentServiceImpl implements IProcedureEquipmentService 
{
    @Autowired
    private ProcedureEquipmentMapper procedureEquipmentMapper;

    
    @Override
    public List<ProcedureEquipmentInfo> getEquipmentIdAndEquipmentNameOnProcedureId(Long id) {
        return procedureEquipmentMapper.getEquipmentIdAndEquipmentNameOnProcedureId(id);
    }

}

service

public interface IProcedureEquipmentService 
{



    List<ProcedureEquipmentInfo> getEquipmentIdAndEquipmentNameOnProcedureId(Long id);

}

controller

@RestController
@RequestMapping("/system/ProcedureEquipment")
public class ProcedureEquipmentController extends BaseController
{
    @Autowired
    private IProcedureEquipmentService procedureEquipmentService;

    

    @GetMapping("/getEquipmentIdAndEquipmentNameOnProcedureId/{id}")
    public List<ProcedureEquipmentInfo> getEquipmentIdAndEquipmentNameOnProcedureId(@PathVariable("id") Long id) {
        return procedureEquipmentService.getEquipmentIdAndEquipmentNameOnProcedureId(id);
    }
}

测试及返回