基于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) );