基于Java Swing + MySQL的学生住宿管理系统的设计与实现

本项目是数据库课程的结课项目，基于JavaSwing + MySQL实现的学生住宿管理系统，系统开发较完善，不仅实现了对数据库的基本增删改查，同时拥有对数据库信息进行统计并生成报表的功能，下面让我们来详细了解一下：

1.系统主界面

2.学生管理

3.房间管理4.租赁合同管理5.统计报表功能

6.数据库设计SQL如下：

-- 创建数据库 CREATE DATABASE IF NOT EXISTS student_accommodation; USE student_accommodation; -- 创建职工表 CREATE TABLE IF NOT EXISTS staff ( staff_id INT PRIMARY KEY, staff_name VARCHAR(50), contact_info VARCHAR(50), position VARCHAR(50) ); -- 创建公寓表 CREATE TABLE IF NOT EXISTS apartments ( apartment_id INT PRIMARY KEY, room_type VARCHAR(50) ); -- 创建厅室表 CREATE TABLE IF NOT EXISTS halls ( hall_id INT PRIMARY KEY, staff_id INT, FOREIGN KEY (staff_id) REFERENCES staff(staff_id) ); -- 创建房间表 CREATE TABLE IF NOT EXISTS rooms ( room_id INT PRIMARY KEY, hall_id INT, apartment_id INT, accommodation_id INT, room_status VARCHAR(20) DEFAULT '可用', is_full BOOLEAN DEFAULT FALSE, rent_per_semester DECIMAL(10, 2), FOREIGN KEY (hall_id) REFERENCES halls(hall_id), FOREIGN KEY (apartment_id) REFERENCES apartments(apartment_id) ); -- 创建学生表 CREATE TABLE IF NOT EXISTS students ( student_id INT PRIMARY KEY, student_name VARCHAR(50), student_number VARCHAR(20), age INT, gender VARCHAR(10), class_name VARCHAR(50), contact_info VARCHAR(50) ); -- 创建发票表 CREATE TABLE IF NOT EXISTS invoices ( invoice_id INT PRIMARY KEY, status VARCHAR(20) DEFAULT '未支付', amount DECIMAL(10, 2), invoice_date DATE ); -- 创建欠款提示表 CREATE TABLE IF NOT EXISTS payment_reminders ( reminder_id INT PRIMARY KEY, reminder_count INT DEFAULT 0, reminder_date DATE, status VARCHAR(20) DEFAULT '未处理' ); -- 创建租赁合同表 CREATE TABLE IF NOT EXISTS leases ( contract_id INT PRIMARY KEY, start_date DATE, end_date DATE, lease_duration INT, rent DECIMAL(10, 2), payment_status VARCHAR(20) DEFAULT '未支付', signing_date DATE, student_id INT, hall_id INT, room_id INT, invoice_id INT, reminder_id INT, FOREIGN KEY (student_id) REFERENCES students(student_id), FOREIGN KEY (hall_id) REFERENCES halls(hall_id), FOREIGN KEY (room_id) REFERENCES rooms(room_id), FOREIGN KEY (invoice_id) REFERENCES invoices(invoice_id), FOREIGN KEY (reminder_id) REFERENCES payment_reminders(reminder_id) );