sql多表联查java

最新推荐文章于 2024-07-19 17:34:15 发布

一起逃去看海吧

最新推荐文章于 2024-07-19 17:34:15 发布

阅读量147

点赞数 1

文章标签： sql java 数据库

本文链接：https://blog.csdn.net/PHPneweer/article/details/136917277

版权

文章描述了一个SQL查询在数据库中通过多表联接获取Device相关信息的过程，并介绍了如何将查询结果映射到自定义的Device实体类中，以便于进一步的数据处理和分析。

摘要由CSDN通过智能技术生成

SELECT
    u.id  ,
    u.uname  ,
    d.dname  ,
    u.em  ,
    s.stats  
FROM
    unit u
JOIN
    danwei d ON u.did = d.did
JOIN
    stats s ON u.zid = s.zid

mapper

<resultMap id="ResultLian" type="Device">
        <id property="id" column="设备ID" />
        <result property="name" column="设备名称" />
        <result property="unit" column="所属单位" />
        <result property="email" column="Email" />
        <result property="status" column="状态" />
    </resultMap>


    <!-- 定义查询语句 -->
    <select id="selectLian" resultMap="ResultLian">
    SELECT
        u.id ,
        u.uname ,
        d.dname ,
        u.em ,
        s.stats
    FROM
        unit u
    JOIN
        danwei d ON u.did = d.did
    JOIN
        stats s ON u.zid = s.zid

</select>

(Device必须是实体类包下的）因为联表查的时、产生的对象与原本对象不符、需要自己手写一个

package com.ruoyi.system.domain;

import com.ruoyi.common.annotation.Excel;

/**
 * @authorGH
 * @company www.1248163489.com
 */
public class Device {
    /**
     *
     *@param
     */
//    <id property="id" column="设备ID" />
//        <result property="name" column="设备名称" />
//        <result property="unit" column="所属单位" />
//        <result property="email" column="Email" />
//        <result property="status" column="状态" />
    private static final long serialVersionUID = 1L;


    /**  */
    private Long id;

    /** $column.columnComment */
    private String uname;

    private String em;

    private String unit;

    private Long stats;

    @Override
    public String toString() {
        return "Device{" +
                "id=" + id +
                ", uname='" + uname + '\'' +
                ", em='" + em + '\'' +
                ", unit='" + unit + '\'' +
                ", stats=" + stats +
                '}';
    }

    public Device(Long id, String uname, String em, String unit, Long stats) {
        this.id = id;
        this.uname = uname;
        this.em = em;
        this.unit = unit;
        this.stats = stats;
    }

    public static long getSerialVersionUID() {
        return serialVersionUID;
    }

    public Long getId() {
        return id;
    }

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

    public String getUname() {
        return uname;
    }

    public void setUname(String uname) {
        this.uname = uname;
    }

    public String getEm() {
        return em;
    }

    public void setEm(String em) {
        this.em = em;
    }

    public String getUnit() {
        return unit;
    }

    public void setUnit(String unit) {
        this.unit = unit;
    }

    public Long getStats() {
        return stats;
    }

    public void setStats(Long stats) {
        this.stats = stats;
    }
}