任务要求:
需要提交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表:



