登录
当前位置： 首页 > 知识库问答 >
问题：

hibernate HQL中的联接

徐新荣
2023-03-14

我有以下mysql查询：

SELECT s.file, sheet, s.messagetemplate,s.time_to_run,s.frequency,s.schedule_name, t.Value 
FROM  s   INNER JOIN  tFrequencies t ON s.frequencyId=t.id

import java.io.Serializable;
import java.util.List;
import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;    
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.validation.constraints.NotNull;
import javax.validation.constraints.Size;
import javax.xml.bind.annotation.XmlRootElement;

/**
 *
 * @author support
 */
@Entity
@Table(name = "tFrequencies")
@XmlRootElement
@NamedQueries({
    @NamedQuery(name = "TFrequencies.findAll", query = "SELECT t FROM TFrequencies t")
    , @NamedQuery(name = "TFrequencies.findById", query = "SELECT t FROM TFrequencies t WHERE t.id = :id")
    , @NamedQuery(name = "TFrequencies.findByValue", query = "SELECT t FROM TFrequencies t WHERE t.value = :value")
    , @NamedQuery(name = "TFrequencies.findByDescription", query = "SELECT t FROM TFrequencies t WHERE t.description = :description")})
public class TFrequencies implements Serializable {

    private static final long serialVersionUID = 1L;
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Basic(optional = false)
    @Column(name = "id")
    private Integer id;
    @Basic(optional = false)
    @NotNull
    @Size(min = 1, max = 11)
    @Column(name = "Value")
    private String value;
    @Basic(optional = false)
    @NotNull
    @Size(min = 1, max = 100)
    @Column(name = "Description")
    private String description;

    private List <tEXCELSMSTOSENDSchedule> schedule;

    public TFrequencies() {
    }

    public TFrequencies(Integer id) {
        this.id = id;
    }

    public TFrequencies(Integer id, String value, String description) {
        this.id = id;
        this.value = value;
        this.description = description;
    }

    public Integer getId() {
        return id;
    }

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

    public String getValue() {
        return value;
    }

    public void setValue(String value) {
        this.value = value;
    }

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }

    public List<tEXCELSMSTOSENDSchedule> getSchedule() {
        return schedule;
    }

    public void setSchedule(List<tEXCELSMSTOSENDSchedule> schedule) {
        this.schedule = schedule;
    }



    @Override
    public int hashCode() {
        int hash = 0;
        hash += (id != null ? id.hashCode() : 0);
        return hash;
    }

    @Override
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof TFrequencies)) {
            return false;
        }
        TFrequencies other = (TFrequencies) object;
        if ((this.id == null && other.id != null) || (this.id != null && !this.id.equals(other.id))) {
            return false;
        }
        return true;
    }

    @Override
    public String toString() {
        return "com.mspace1.model.TFrequencies[ id=" + id + " ]";
    }
    public static void main(String [] args){

    }
}
/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.mspace1.model;

import java.io.Serializable;
import java.util.Date;
import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Lob;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
import javax.validation.constraints.NotNull;
import javax.validation.constraints.Size;
import javax.xml.bind.annotation.XmlRootElement;

/**
 *
 * @author support
 */
@Entity
@Table(catalog = "dbSMS", schema = "")
@XmlRootElement
@NamedQueries({
    @NamedQuery(name = "tEXCELSMSTOSENDSchedule.findAll", query = "SELECT t FROM tEXCELSMSTOSENDSchedule t")
    , @NamedQuery(name = "tEXCELSMSTOSENDSchedule.findById", query = "SELECT t FROM tEXCELSMSTOSENDSchedule t WHERE t.id = :id")
    , @NamedQuery(name = "tEXCELSMSTOSENDSchedule.findBySheet", query = "SELECT t FROM tEXCELSMSTOSENDSchedule t WHERE t.sheet = :sheet")
    , @NamedQuery(name = "tEXCELSMSTOSENDSchedule.findByMobileColumn", query = "SELECT t FROM tEXCELSMSTOSENDSchedule t WHERE t.mobileColumn = :mobileColumn")
    , @NamedQuery(name = "tEXCELSMSTOSENDSchedule.findByTimeTosend", query = "SELECT t FROM tEXCELSMSTOSENDSchedule t WHERE t.timeTosend = :timeTosend")
    , @NamedQuery(name = "tEXCELSMSTOSENDSchedule.findByUser", query = "SELECT t FROM tEXCELSMSTOSENDSchedule t WHERE t.user = :user")
    , @NamedQuery(name = "tEXCELSMSTOSENDSchedule.findBySource", query = "SELECT t FROM tEXCELSMSTOSENDSchedule t WHERE t.source = :source")
    , @NamedQuery(name = "tEXCELSMSTOSENDSchedule.findByDeliverFrequency", query = "SELECT t FROM tEXCELSMSTOSENDSchedule t WHERE t.deliverFrequency = :deliverFrequency")
    , @NamedQuery(name = "tEXCELSMSTOSENDSchedule.findByTimeToRun", query = "SELECT t FROM tEXCELSMSTOSENDSchedule t WHERE t.timeToRun = :timeToRun")
    , @NamedQuery(name = "tEXCELSMSTOSENDSchedule.findByProcessed", query = "SELECT t FROM tEXCELSMSTOSENDSchedule t WHERE t.processed = :processed")
    , @NamedQuery(name = "tEXCELSMSTOSENDSchedule.findByFrequency", query = "SELECT t FROM tEXCELSMSTOSENDSchedule t WHERE t.frequency = :frequency")
    , @NamedQuery(name = "tEXCELSMSTOSENDSchedule.findByFrequencyId", query = "SELECT t FROM tEXCELSMSTOSENDSchedule t WHERE t.frequencyId = :frequencyId")
, @NamedQuery(name = "tEXCELSMSTOSENDSchedule.findByFrequencyName", query = "SELECT t FROM tEXCELSMSTOSENDSchedule t WHERE t.frequencyName = :frequencyName")})
public class tEXCELSMSTOSENDSchedule implements Serializable {





    private static final long serialVersionUID = 1L;
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Basic(optional = false)
    @Column(nullable = false)

    private Integer id;
    @Basic(optional = false)
    @NotNull
    @Lob
    @Size(min = 1, max = 65535)
    @Column(nullable = false, length = 65535)
    private String file;
    @Basic(optional = false)
    @NotNull
    @Size(min = 1, max = 50)
    @Column(nullable = false, length = 50)
    private String sheet;
    @Basic(optional = false)
    @NotNull
    @Size(min = 1, max = 20)
    @Column(nullable = false, length = 20)
    private String mobileColumn;
    @Basic(optional = false)
    @NotNull
    @Lob
    @Size(min = 1, max = 65535)
    @Column(nullable = false, length = 65535)
    private String messagetemplate;
    @Basic(optional = false)
    @NotNull
    @Column(nullable = false)
    @Temporal(TemporalType.TIMESTAMP)
    private Date timeTosend;
    @Basic(optional = false)
    @NotNull
    @Size(min = 1, max = 20)
    @Column(nullable = false, length = 20)
    private String user;
    @Basic(optional = false)
    @NotNull
    @Size(min = 1, max = 20)
    @Column(nullable = false, length = 20)
    private String source;
    @Basic(optional = false)
    @NotNull
    @Column(nullable = false)
    private int deliverFrequency;
    @Column(name = "time_to_run")
    @Temporal(TemporalType.TIMESTAMP)
    private Date timeToRun;
    @Basic(optional = false)
    @NotNull
    @Column(nullable = false)
    private short processed;
    @Basic(optional = false)
    @NotNull
    @Column(nullable = false)
    private short frequency;
    @Basic(optional = false)
    @NotNull
    @Column(nullable = false)
    private int frequencyId;
    @Basic(optional = false)
    @NotNull
    @Lob
    @Size(min = 1, max = 65535)
    @Column(name = "schedule_name", nullable = false, length = 65535)
    private String scheduleName;
    private String frequencyName;
    public tEXCELSMSTOSENDSchedule() {
    }

    public tEXCELSMSTOSENDSchedule(Integer id) {
        this.id = id;
    }

    public tEXCELSMSTOSENDSchedule(Integer id, String file, String sheet, String mobileColumn, String messagetemplate, Date timeTosend, String user, String source, int deliverFrequency, short processed, short frequency, int frequencyId,String frequencyName, String scheduleName) {
        this.id = id;
        this.file = file;
        this.sheet = sheet;
        this.mobileColumn = mobileColumn;
        this.messagetemplate = messagetemplate;
        this.timeTosend = timeTosend;
        this.user = user;
        this.source = source;
        this.deliverFrequency = deliverFrequency;
        this.processed = processed;
        this.frequency = frequency;
        this.frequencyId = frequencyId;
        this.scheduleName = scheduleName;
        this.frequencyName=frequencyName;
    }

    public Integer getId() {
        return id;
    }

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

    public String getFile() {
        return file;
    }

    public void setFile(String file) {
        this.file = file;
    }

    public String getSheet() {
        return sheet;
    }

    public void setSheet(String sheet) {
        this.sheet = sheet;
    }

    public String getMobileColumn() {
        return mobileColumn;
    }

    public void setMobileColumn(String mobileColumn) {
        this.mobileColumn = mobileColumn;
    }

    public String getMessagetemplate() {
        return messagetemplate;
    }

    public void setMessagetemplate(String messagetemplate) {
        this.messagetemplate = messagetemplate;
    }

    public Date getTimeTosend() {
        return timeTosend;
    }

    public void setTimeTosend(Date timeTosend) {
        this.timeTosend = timeTosend;
    }

    public String getUser() {
        return user;
    }

    public void setUser(String user) {
        this.user = user;
    }

    public String getSource() {
        return source;
    }

    public void setSource(String source) {
        this.source = source;
    }

    public int getDeliverFrequency() {
        return deliverFrequency;
    }

    public void setDeliverFrequency(int deliverFrequency) {
        this.deliverFrequency = deliverFrequency;
    }

    public Date getTimeToRun() {
        return timeToRun;
    }

    public void setTimeToRun(Date timeToRun) {
        this.timeToRun = timeToRun;
    }

    public short getProcessed() {
        return processed;
    }

    public void setProcessed(short processed) {
        this.processed = processed;
    }

    public short getFrequency() {
        return frequency;
    }

    public void setFrequency(short frequency) {
        this.frequency = frequency;
    }

    public int getFrequencyId() {
        return frequencyId;
    }

    public void setFrequencyId(int frequencyId) {
        this.frequencyId = frequencyId;
    }

    public String getScheduleName() {
        return scheduleName;
    }

    public void setScheduleName(String scheduleName) {
        this.scheduleName = scheduleName;
    }

    public String getFrequencyName() {
        return frequencyName;
    }

    public void setFrequencyName(String frequencyName) {
        this.frequencyName = frequencyName;
    }

    @Override
    public int hashCode() {
        int hash = 0;
        hash += (id != null ? id.hashCode() : 0);
        return hash;
    }

    @Override
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof tEXCELSMSTOSENDSchedule)) {
            return false;
        }
        tEXCELSMSTOSENDSchedule other = (tEXCELSMSTOSENDSchedule) object;
        if ((this.id == null && other.id != null) || (this.id != null && !this.id.equals(other.id))) {
            return false;
        }
        return true;
    }

    @Override
    public String toString() {
        return "com.mspace1.model.tEXCELSMSTOSENDSchedule[ id=" + id + " ]";
    }

}

我已经编辑了我的问题，以添加我正在使用的两个实体。第一个实体包含频率，我想要加入从另一个实体选择的项目。TFrequency表有一个不变的常量值。这个频率使用ID映射到tEXCELSMSTOSENDSchedule实体。但是，我希望从tfrequence中选择name，而不是映射的id。然后我用它来填充我的数据表。我需要创建第三个实体吗？我不知道这是如何工作的，我一直在尝试加入周围，但没有成功。

共有1个答案

苏骏
2023-03-14

要以“hibernate方式”执行此操作，您需要在实体中映射tfrequences表，以便从tfrequences获取值，创建与tfrequences的关系。

之后，如果不需要返回整个实体TexcelsMstosEndSchedule，可以执行以下操作：

SELECT s FROM tEXCELSMSTOSENDSchedule s 
JOIN s.tFrequencies t
where t.id = :idFrequency

查询返回结果后，可以通过TExcelsMstosendSchedule访问TFrequences中的值:

tEXCELSMSTOSENDSchedule.getTFrequencies().getValue();

如果您不想返回整个实体，则只能使用对象数组、Hibernate元组或特定的Dto来传递所需的信息。使用Dto，代码如下所示：

List<PostDTO> postDTOs = entityManager.createQuery(
"select new " +
"   com.páckage.ExcelDto("+
"       s.file, " +
"       s.sheet " + //TODO add the other attributes
"   ) " +
"from tEXCELSMSTOSENDSchedule s JOIN s.tFrequencies t" +
"where t.id = :idFrequency")
.setParameter("idFrequency", 1).getResultList();

也可以通过ResultTransformer在没有实体的情况下（使用本机SQL)，将信息传递给DTO。

 类似资料：
  • HibernateHQL内部联接子选择

    我得到了下面的SQL，我想将其转换为有效的HQL。这方面的问题是，不允许根据文档加入子查询。尽管这些是旧文档（v3.3），但在hibernate 5.3中，这一节似乎仍然适用。 我想出了这个HQL： 尝试执行此HQL查询会导致此异常 这将提示 在. 有没有办法加入HQL中的子查询？如果不是，那么获得与具有HQL的SQL相同的结果的最佳方法是什么？ 我不擅长转换

  • HibernateHQL连接提取不递归提取

    我有以下查询和方法 使用< code >域作为 我希望这个查询能够获取

  • CodeIgniter中的联接查询

    问题内容： 这个问题已经在这里有了答案 ： 在同一网页上显示两个表的数据 （1个答案） 7年前关闭。 我在CodeIgniter中使用联接查询，但无法使其正常工作。它仅显示一个表数据，而不显示其他表数据。我是CodeIgniter的新手，无法解决此问题。请别人帮我。提前谢谢。 看法 控制器 模型 编辑 的结果 是一个如下数组： 表结构 证书 cid（PRIMARY），姓名，second_name，

  • 联接中的子查询

    我需要从数据库中选择具有活动地址的公司(address.address_status_id=1）。如果地址不活动，则地址列应包含NULL。 有没有一种方法可以重新表述SQL语句，使它可以用JPA/QueryDSL表示？ 编辑：我们将使用Oracle DB和Hibernate JPA provider（如果它能起作用的话）。

  • Kafka streams联接中的RecordTooLargeException

    我有一个KStream x KStream连接，它正在中断，但有以下例外。 尽管如此，我尝试将属性设置为，即30MB。我不希望推荐记录超过这个限制。但是，代码还是崩溃了。 我不能更改Kafka集群中的配置，但如果需要，我可以更改Kafka中相关主题的属性。 有人能建议我还能试试什么吗？ 如果什么都不起作用，我愿意忽略这样的超大信息。但是，我不知道处理这个的方法。 执行连接的代码如下所示。 是连接的

  • sql联接中联接列顺序的最佳实践？

    问题内容： 在我的办公室里，关于sql联接中联接列的顺序正在进行很大的讨论。我很难解释它，所以我只介绍两个sql语句。考虑到sql最佳实践，哪个更好？ 或者 因此，在联接的ON部分中，是否编写是否重要？ 问题答案： 此处的最佳实践是选择一个并 在团队中 坚持使用。就我个人而言，我更喜欢它，因为它对我来说似乎更干净。

相关问答

Apache Ignite中的联接查询CSS中的内联SVGhibernate中的多个联接回迁Azure CosmosDB SQL API中的左联接TypeORM中的内部联接查询

相关文章

Python中的语法列表联接Sequelize ORM中联接表的条件Django中的完全外部联接内部联接与选择联接中的SQL语句之间的区别angular.js中的内联条件

相关阅读

中山联通前端（实习）TP-link 普联&联洲面经中移物联网一面凉经中移物联网-技术运维中国联通 IT岗一面 面经

相关工具

OpenNTF 联盟影视联盟携程酒店联盟接口SDK容联云通讯API的开发工具集最小物联网系统

相关文档

云联壹云文档中心互联网面试笔记五天入门物联网物联网安全百科一步步搭建物联网系统
快捷导航： 新手教程 算法原理 架构设计 Java进阶 数据库进阶 大厂专栏 面试经验 编程笔记 编程问答 所有专题 文档资料 工具软件 电子书籍 小牛导航
在线工具： 房贷计算器 个税计算器 Linux命令查询 Json格式化 正则表达式 颜色转换 AES加解密 SHA1加密 MD5加密 毒鸡汤 字数统计 随机密码生成 进制转换 Base64编解码 励志句子
Copyright © 2019-2024 小牛知识库@xnip.cn. All Rights Reserved.