栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

Hibernate关联映射

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

Hibernate关联映射

任务要求:
需要提交XML格式的映射文件和实现相应操作的Java源文件代码,数据库所有表结构需截图上传。hibernate.cfg.xml和HibernateUtil代码无需提交。

任务描述:
在任务01的基础上完成房屋租赁系统中房主(HouseOwner)和房屋(House)实体之间的单向一对多关联关系映射,假设系统中一个租赁者可以租赁多个房屋,一个房屋可以被多个租赁者合租,完成租赁者(Tenant)和房屋(House)实体之间的双向多对多关联关系映射,并选择合适的检索方法实现相关查询方法,已知房主和租赁者属性如下所示,以下每种操作都需要单独封装为一个方法(尽量考虑方法形参和返回值的合理性):

public class HouseOwner {

	private Integer id;
	private String name;//房主姓名
	private String phone;//房主电话
	private Set houses = new HashSet();
	......
}

public class Tenant {
	private Integer tenantId;//租赁者id
	private String name;//租赁者姓名
	private String gender;//租赁者性别
	private String phone;//租赁者电话
	private List houses = new ArrayList();
	……
}

1、 根据房主id查询房主信息并为其添加房屋信息。
2、 保存房主时级联保存其所有房屋信息。
3、 删除房主时级联删除房屋信息。
4、 根据租赁者姓名、电话和房屋id进行租房操作。
5、 根据租赁者姓名、电话和房屋id进行退租操作。
6、 根据房主姓名查询其所有房屋的所有租户,方法中需将所有租户信息打印到控制台。
7、 查询房租在某个区间的某种类型的房屋个数,如查询房屋为1500-2000之间的两室两厅的房屋个数。

House.java:

package com.hibernate.entity;

import java.util.HashSet;
import java.util.Set;

public class House {

	private Integer houseId;// 房屋ID
	private String address;// 房屋地址
	private String type;// 如:三室两厅、两室两厅等
	private float area;// 房屋面积
	private int rental;// 租金

	private Set tenantSet = new HashSet();

	public Set getTenantSet() {
		return tenantSet;
	}

	public void setTenantSet(Set tenantSet) {
		this.tenantSet = tenantSet;
	}

	public Integer getHouseId() {
		return houseId;
	}

	public void setHouseId(Integer houseId) {
		this.houseId = houseId;
	}

	public String getAddress() {
		return address;
	}

	public void setAddress(String address) {
		this.address = address;
	}

	public String getType() {
		return type;
	}

	public void setType(String type) {
		this.type = type;
	}

	public float getArea() {
		return area;
	}

	public void setArea(float area) {
		this.area = area;
	}

	public int getRental() {
		return rental;
	}

	public void setRental(int rental) {
		this.rental = rental;
	}

	public House() {
		super();
	}

	public House(Integer houseId, String address, String type, float area, int rental) {
		super();
		this.houseId = houseId;
		this.address = address;
		this.type = type;
		this.area = area;
		this.rental = rental;
	}

	@Override
	public String toString() {
		return "House [houseId=" + houseId + ", address=" + address + ", type=" + type + ", area=" + area + ", rental="
				+ rental + "]";
	}

}

HouseOwner.java:

package com.hibernate.entity;

import java.util.HashSet;
import java.util.Set;

public class HouseOwner {

	private Integer id;
	private String name;// 房主姓名
	private String phone;// 房主电话
	private Set houses = new HashSet();

	public Integer getId() {
		return id;
	}

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

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getPhone() {
		return phone;
	}

	public void setPhone(String phone) {
		this.phone = phone;
	}

	public Set getHouses() {
		return houses;
	}

	public void setHouses(Set houses) {
		this.houses = houses;
	}

	@Override
	public String toString() {
		return "HouseOwner [id=" + id + ", name=" + name + ", phone=" + phone + "]";
	}

}

Tenant.java:

package com.hibernate.entity;

import java.util.ArrayList;
import java.util.List;

public class Tenant {

	private Integer tenantId;// 租赁者id
	private String name;// 租赁者姓名
	private String gender;// 租赁者性别
	private String phone;// 租赁者电话
	private List houses = new ArrayList();

	public Integer getTenantId() {
		return tenantId;
	}

	public void setTenantId(Integer tenantId) {
		this.tenantId = tenantId;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getGender() {
		return gender;
	}

	public void setGender(String gender) {
		this.gender = gender;
	}

	public String getPhone() {
		return phone;
	}

	public void setPhone(String phone) {
		this.phone = phone;
	}

	public List getHouses() {
		return houses;
	}

	public void setHouses(List houses) {
		this.houses = houses;
	}

	@Override
	public String toString() {
		return "Tenant [tenantId=" + tenantId + ", name=" + name + ", gender=" + gender + ", phone=" + phone + "]";
	}

}

House.hbm.xml:




	
	
		
		
			
		
		
		
		
		
		
		
		
			
			
		
	

HouseOwner.hbm.xml:




	
	
		
		
			
		
		
		
		
		
			
			
		
	

Tenant.hbm.xml:




	
	
		
		
			
		
		
		
		
		
		
		
			
			
			
		
	

Test.java:

package com.hibernate.ui;

import java.util.List;
import java.util.Set;

import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.query.Query;

import com.hibernate.entity.House;
import com.hibernate.entity.HouseOwner;
import com.hibernate.entity.Tenant;
import com.hibernate.util.HibernateUtil;

public class Test {

	public static void main(String[] args) {

		// 1、根据房主id查询房主信息并为其添加房屋信息
		House house1 = new House();
		house1.setAddress("河北省石家庄市裕华区");
		house1.setType("三室一厅");
		house1.setArea(120);
		house1.setRental(2400);
		addHouseToOwner(new Integer(1), house1);

		// 2、保存房主时级联保存其所有房屋信息
		HouseOwner owner = new HouseOwner();
		owner.setName("宋亚轩");
		owner.setPhone("15632489700");
		House house2 = new House();
		house2.setAddress("河北省石家庄市长安区");
		house2.setType("两室一厅");
		house2.setArea(100);
		house2.setRental(1800);
		owner.getHouses().add(house2);
		House house3 = new House();
		house3.setAddress("河北省石家庄市桥西区");
		house3.setType("两室两厅");
		house3.setArea(140);
		house3.setRental(2000);
		owner.getHouses().add(house3);
		saveOwnerAndHouse(owner);

		// 3、删除房主时级联删除房屋信息
		deleteOwnerAndHouse(3);

		// 4、根据租赁者姓名、电话和房屋id进行租房操作
		rentHouse("虞书欣", "15689472300", 1);

		// 5、根据租赁者姓名、电话和房屋id进行退租操作
		cancelHouse("虞书欣", "15689472300", 1);

		// 6、根据房主姓名查询其所有房屋的所有租户,方法中需将所有租户信息打印到控制台
		getAllTenantByOwnerName("丁程鑫");

		// 7、查询房租在某个区间的某种类型的房屋个数
		getHouseNum("三室两厅", 2000, 3000);

		// 关闭SessionFactory
		HibernateUtil.closeSessionFactory();
	}

	
	public static void addHouseToOwner(int houseOwnerId, House house) {
		Session session = HibernateUtil.openSession();
		Transaction transaction = session.beginTransaction();

		HouseOwner houseOwner = session.get(HouseOwner.class, houseOwnerId);
		System.out.println(houseOwner);

		houseOwner.getHouses().add(house);
		session.save(houseOwner);

		transaction.commit();
		session.close();
	}

	
	public static void saveOwnerAndHouse(HouseOwner owner) {
		Session session = HibernateUtil.openSession();
		Transaction transaction = session.beginTransaction();

		session.save(owner);

		transaction.commit();
		session.close();
	}

	
	public static void deleteOwnerAndHouse(int houseOwnerId) {
		Session session = HibernateUtil.openSession();
		Transaction transaction = session.beginTransaction();

		HouseOwner houseOwner = session.get(HouseOwner.class, new Integer(houseOwnerId));
		session.delete(houseOwner);

		transaction.commit();
		session.close();
	}

	
	public static void rentHouse(String name, String phone, int houseId) {
		Session session = HibernateUtil.openSession();
		Transaction transaction = session.beginTransaction();

		Tenant tenant = new Tenant();
		tenant.setName(name);
		tenant.setPhone(phone);

		String hql = "from Tenant where name=:name and phone=:phone";

		Query query = session.createQuery(hql);
		query.setProperties(tenant);

		if (query.uniqueResult() == null) {// 第一次租房
			House house = session.get(House.class, new Integer(houseId));

			house.getTenantSet().add(tenant);
			tenant.getHouses().add(house);

			session.save(tenant);
		} else {
			Tenant tenant1 = (Tenant) query.uniqueResult();

			House house1 = session.get(House.class, new Integer(houseId));

			house1.getTenantSet().add(tenant1);
			tenant1.getHouses().add(house1);

			session.save(tenant1);
		}

		transaction.commit();
		session.close();
	}

	
	public static void cancelHouse(String name, String phone, int houseId) {
		Session session = HibernateUtil.openSession();
		Transaction transaction = session.beginTransaction();

		Tenant tenant = new Tenant();
		tenant.setName(name);
		tenant.setPhone(phone);

		String hql = "from Tenant where name=:name and phone=:phone";

		Query query = session.createQuery(hql);
		query.setProperties(tenant);
		Tenant tenant1 = (Tenant) query.uniqueResult();

		House house = session.get(House.class, new Integer(houseId));

		tenant1.getHouses().remove(house);

		session.flush();

		// 当租赁者没有租房时,应将之从表中删除
		int num = tenant1.getHouses().size();
		if (num == 0) {
			session.delete(tenant1);
		}

		transaction.commit();
		session.close();
	}

	
	public static void getAllTenantByOwnerName(String ownerName) {
		Session session = HibernateUtil.openSession();

		String hql = "from HouseOwner where name=:name";

		Query query = session.createQuery(hql);
		query.setParameter("name", ownerName);

		HouseOwner owner = (HouseOwner) query.uniqueResult();
		Set houseSet = owner.getHouses();
		for (House house : houseSet) {
			Set tenantSet = house.getTenantSet();
			for (Tenant tenant : tenantSet) {
				System.out.println(tenant);
			}
		}

		session.close();
	}

	
	public static void getHouseNum(String type, int beginRental, int endRental) {
		Session session = HibernateUtil.openSession();

		String hql = "from House where type=:type and rental between :beginRental and :endRental";

		Query query = session.createQuery(hql);
		query.setParameter("type", type);
		query.setParameter("beginRental", beginRental);
		query.setParameter("endRental", endRental);

		List housList = query.list();
		System.out.println("房屋的个数为:" + housList.size());

		session.close();
	}

}

数据库表结构:
1)house表:
表结构设计:

初始数据:

2)house_owner表:
表结构设计:

初始数据:

3)tenant表:

4)house_tenant表:

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/937245.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号