create database if not exists `studentManageSystem_JSP`;
use studentManageSystem_JSP;
drop table if exists student;

CREATE TABLE student (
                         id INT AUTO_INCREMENT PRIMARY KEY,
                         name VARCHAR(50) NOT NULL COMMENT '学生姓名',
                         student_id VARCHAR(12) UNIQUE NOT NULL COMMENT '学号，格式252612000xx',
                         class VARCHAR(50) NOT NULL COMMENT '班级，如2025计算机科学与技术专升本A',
                         dormitory_number VARCHAR(10) COMMENT '宿舍号',
                         contact VARCHAR(20) COMMENT '联系方式'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='学生信息表';

INSERT INTO student (name, student_id, class, dormitory_number, contact) VALUES
                                                                             ('张三', '25261200001', '2025计算机科学与技术专升本A', '13256', '13800138001'),
                                                                             ('李四', '25261200002', '2025计算机科学与技术专升本A', '13256', '13800138002'),
                                                                             ('王五', '25261200003', '2025计算机科学与技术专升本A', '13257', '13800138003'),
                                                                             ('赵六', '25261200004', '2025计算机科学与技术专升本B', '13258', '13800138004'),
                                                                             ('钱七', '25261200005', '2025计算机科学与技术专升本B', '13259', '13800138005');