Java+Swing+Mysql学生宿舍管理系统

一、系统介绍

本系统实现了学生登录和管理员登录，学生可以登记入住，实现学生信息查询和修改，实现宿舍信息查询。管理实现学生信息增删改查，实现宿舍信息增删改查。

二、系统展示

1.用户登陆

2.寝室查询–学生

3.学生信息查询–学生

4.宿舍管理–管理员

5.学生信息管理–管理员

6.住宿管理–管理员

三、数据库建表语句

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80021
 Source Host           : localhost:3306
 Source Schema         : dormitoryswing

 Target Server Type    : MySQL
 Target Server Version : 80021
 File Encoding         : 65001

 Date: 23/11/2022 15:08:29
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for d_user
-- ----------------------------
DROP TABLE IF EXISTS `d_user`;
CREATE TABLE `d_user`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `userName` varchar(20) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
  `userPassword` varchar(20) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of d_user
-- ----------------------------
INSERT INTO `d_user` VALUES (1, 's1', '123');
INSERT INTO `d_user` VALUES (2, 'admin', '123');

-- ----------------------------
-- Table structure for room_message
-- ----------------------------
DROP TABLE IF EXISTS `room_message`;
CREATE TABLE `room_message`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `member` varchar(20) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
  `leader` varchar(20) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of room_message
-- ----------------------------
INSERT INTO `room_message` VALUES (2, '25109', '王宇');
INSERT INTO `room_message` VALUES (4, '25106', '张三');
INSERT INTO `room_message` VALUES (5, '25108', '刘宇');
INSERT INTO `room_message` VALUES (6, '251010', '李四');

-- ----------------------------
-- Table structure for student_message
-- ----------------------------
DROP TABLE IF EXISTS `student_message`;
CREATE TABLE `student_message`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
  `sex` varchar(10) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
  `yuanxi` varchar(20) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
  `classroom` varchar(20) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
  `dormitory` int(0) NULL DEFAULT NULL,
  `bed` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FK_student_message`(`dormitory`) USING BTREE,
  CONSTRAINT `FK_student_message` FOREIGN KEY (`dormitory`) REFERENCES `room_message` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of student_message
-- ----------------------------
INSERT INTO `student_message` VALUES (6, '李华阳', '男', '信工', '1', 5, 2);
INSERT INTO `student_message` VALUES (9, '刘宇', '男', '信工', '1', 5, 4);
INSERT INTO `student_message` VALUES (10, '戴康', '男', '信工', '1', 5, 1);
INSERT INTO `student_message` VALUES (11, '刁雨健', '男', '信工', '1', 5, 3);

SET FOREIGN_KEY_CHECKS = 1;

四、源码下载

点击下载
Java+Swing+Mysql学生宿舍管理系统