Hibernate连表查询

最新推荐文章于 2023-04-29 15:59:46 发布

Williamwhc

最新推荐文章于 2023-04-29 15:59:46 发布

阅读量2.7k

点赞数 1

分类专栏： Hibernate

本文链接：https://blog.csdn.net/qq_40285302/article/details/79890832

版权

这篇博客介绍了如何使用Hibernate框架进行连表查询，包括配置文件设置、实体类定义、映射文件编写以及测试HQL查询语句。通过示例展示了查询员工和对应部门信息的过程。

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

1.整体架构

2.所需要的jar包

3.hibernate.cfg.xml文件

<?xml version='1.0' encoding='utf-8'?>

<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

<session-factory>


<property name="connection.driver_class">oracle.jdbc.OracleDriver</property>
<property name="connection.url">jdbc:oracle:thin:@localhost:1521:orcl</property>
<property name="connection.username">jack</property>
<property name="connection.password">8888</property>

<property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
<property name="show_sql">true</property>
<property name="format_sql">true</property>

<mapping resource="com/entity/Emp.hbm.xml"/>
<mapping resource="com/entity/Dept.hbm.xml"/>
</session-factory>

</hibernate-configuration>

4.实体类Emp和Dept

Emp实体类

package com.entity;

import java.util.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name="emp")
public class Emp {

private Integer empid;
private String ename;
private String job;
private Date hiredate;
private Double sal;
private Double comm;
private Integer deptid;

public Emp() {
super();
}

public Emp(String ename, Date hiredate, Double sal) {
super();
this.ename = ename;
this.hiredate = hiredate;
this.sal = sal;
}

public Emp(String ename, String job, Date hiredate, Double sal, Double comm, Integer deptid) {
super();
this.ename = ename;
this.job = job;
this.hiredate = hiredate;
this.sal = sal;
this.comm = comm;
this.deptid = deptid;
}

public Emp(Integer empid, String ename, String job, Date hiredate,