DB_51Aspx/mysql.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

DROP DATABASE IF EXISTS ssmjg491;

CREATE DATABASE ssmjg491 default character set utf8mb4 collate utf8mb4_general_ci;

USE ssmjg491;

DROP TABLE IF EXISTS `xuesheng`;

CREATE TABLE `xuesheng` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`xueshengzhanghao` varchar(200) NOT NULL UNIQUE   COMMENT '学生账号',
	`xueshengxingming` varchar(200) NOT NULL   COMMENT '学生姓名',
	`sushehao` varchar(200)    COMMENT '宿舍号',
	`mima` varchar(200) NOT NULL   COMMENT '密码',
	`xingbie` varchar(200)    COMMENT '性别',
	`youxiang` varchar(200) NOT NULL   COMMENT '邮箱',
	`lianxidianhua` varchar(200) NOT NULL   COMMENT '联系电话',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='学生';

INSERT INTO xuesheng(xueshengzhanghao,xueshengxingming,sushehao,mima,xingbie,youxiang,lianxidianhua) VALUES('学生1','学生姓名1','宿舍号1','123456','男','773890001@qq.com','13823888881');
INSERT INTO xuesheng(xueshengzhanghao,xueshengxingming,sushehao,mima,xingbie,youxiang,lianxidianhua) VALUES('学生2','学生姓名2','宿舍号2','123456','男','773890002@qq.com','13823888882');
INSERT INTO xuesheng(xueshengzhanghao,xueshengxingming,sushehao,mima,xingbie,youxiang,lianxidianhua) VALUES('学生3','学生姓名3','宿舍号3','123456','男','773890003@qq.com','13823888883');
INSERT INTO xuesheng(xueshengzhanghao,xueshengxingming,sushehao,mima,xingbie,youxiang,lianxidianhua) VALUES('学生4','学生姓名4','宿舍号4','123456','男','773890004@qq.com','13823888884');
INSERT INTO xuesheng(xueshengzhanghao,xueshengxingming,sushehao,mima,xingbie,youxiang,lianxidianhua) VALUES('学生5','学生姓名5','宿舍号5','123456','男','773890005@qq.com','13823888885');
INSERT INTO xuesheng(xueshengzhanghao,xueshengxingming,sushehao,mima,xingbie,youxiang,lianxidianhua) VALUES('学生6','学生姓名6','宿舍号6','123456','男','773890006@qq.com','13823888886');

DROP TABLE IF EXISTS `sushehao`;

CREATE TABLE `sushehao` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`sushehao` varchar(200) NOT NULL UNIQUE   COMMENT '宿舍号',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='宿舍号';

INSERT INTO sushehao(sushehao) VALUES('宿舍号1');
INSERT INTO sushehao(sushehao) VALUES('宿舍号2');
INSERT INTO sushehao(sushehao) VALUES('宿舍号3');
INSERT INTO sushehao(sushehao) VALUES('宿舍号4');
INSERT INTO sushehao(sushehao) VALUES('宿舍号5');
INSERT INTO sushehao(sushehao) VALUES('宿舍号6');

DROP TABLE IF EXISTS `sushezhang`;

CREATE TABLE `sushezhang` (
	`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
	`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '创建时间',
	`sushezhangzhanghao` varchar(200) NOT NULL UNIQUE   COMMENT '宿舍长账号',
	`sushezhangxingming` varchar(200) NOT NULL   COMMENT '宿舍长姓名',
	`mima` varchar(200) NOT NULL   COMMENT '密码',
	`xingbie` varchar(200)    COMMENT '性别',
	`sushehao` varchar(200)    COMMENT '宿舍号',
	`lianxidianhua` varchar(200)    COMMENT '联系电话',
	`youxiang` varchar(200)    COMMENT '邮箱',
	PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='宿舍长';

INSERT INTO sushezhang(sushezhangzhanghao,sushezhangxingming,mima,xingbie,sushehao,lianxidianhua,youxiang) VALUES('宿舍长1','宿舍长姓名1','123456','男','宿舍号1','13823888881','773890001@qq.com');