##t_college表： ##t_status表： ##t_student: ##t_user: ##创建数据库，表和插入数据的代码如下： /* Navicat Premium Data Transfer
Source Server : localhost Source Server Type : MySQL Source Server Version : 50562 Source Host : localhost:3306 Source Schema : student Target Server Type : MySQL Target Server Version : 50562 File Encoding : 65001 Date: 01/07/2020 10:46:25 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_college -- ---------------------------- DROP TABLE IF EXISTS `t_college`; CREATE TABLE `t_college` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '学校名称', `president` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '校长', `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '建校时间', `telephone` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系电话', `email` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '电子邮箱', `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '通讯地址', `profile` varchar(10000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学校简介', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of t_college -- ---------------------------- INSERT INTO `t_college` VALUES (1, '泸州职业技术学院', '杨宗伟', '2003-04-03 09:23:45', '0830-3150397', 'lzy2003@lzy.com', '泸州市龙马潭区长桥路2号', '泸州职业技术学院是经四川省人民政府批准、国家教育部备案的综合性公办普通高等学校。以全日制高职专科学历教育为主，兼顾成人学历教育、中外合作学历教育和社会培训，具有接收外国留学生资质和聘请外教专家资格。学校坐落于激流澎湃的长江之滨、沱江之畔，开设39个高职专科专业，在校生近15000人，占地1271亩，建设总投资25亿元，建筑总面积60万平方米，建筑总投资和办学条件跃居全省专科学校前列。'); -- ---------------------------- -- Table structure for t_status -- ---------------------------- DROP TABLE IF EXISTS `t_status`; CREATE TABLE `t_status` ( `id` int(11) NOT NULL AUTO_INCREMENT, `college` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '学校名称', `version` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '系统版本', `author` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '作者', `telephone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系电话', `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '通讯地址', `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of t_status -- ---------------------------- INSERT INTO `t_status` VALUES (1, '泸职院 ', 'V1.0', 'yw', '13842136987', '泸职院信息工程学院', '41255@qq.com'); -- ---------------------------- -- Table structure for t_student -- ---------------------------- DROP TABLE IF EXISTS `t_student`; CREATE TABLE `t_student` ( `id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '学号', `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名', `sex` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '性别', `age` int(11) DEFAULT NULL COMMENT '年龄', `department` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '系部', `class` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '班级', `telephone` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系电话', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of t_student -- ---------------------------- INSERT INTO `t_student` VALUES ('19070014', '林琳', '女', 21, '人文学院', '19畜牧兽医1班', '18812569789'); INSERT INTO `t_student` VALUES ('19070097', '谢小梅', '女', 19, '信息工程学院', '19大数据1班', '147523956784'); INSERT INTO `t_student` VALUES ('19070101', '张华生', '男', 20, '信息工程学院', '19软件技术1班', '13312569854'); INSERT INTO `t_student` VALUES ('19070102', '刘雪梅', '女', 21, '信息工程学院', '19软件技术1班', '13369586963'); INSERT INTO `t_student` VALUES ('19070103', '何东', '男', 19, '信息工程学院', '19计算机技术1班', '18936589635'); INSERT INTO `t_student` VALUES ('19070104', '康勇', '男', 18, '信息工程学院', '19计算机技术2班', '18936585745'); INSERT INTO `t_student` VALUES ('19070105', '赵琳', '女', 21, '人文学院', '19畜牧兽医1班', '18812569635'); INSERT INTO `t_student` VALUES ('19070106', '王春', '女', 20, '艺术学院', '19园林技术1班', '134569852635'); INSERT INTO `t_student` VALUES ('19070107', '吴苇', '女', 20, '建筑工程学院', '19建筑工程1班', '133698541254'); INSERT INTO `t_student` VALUES ('19070108', '陈飞', '男', 20, '人文学院', '19文秘2班', '135698541254'); INSERT INTO `t_student` VALUES ('19070109', '董成山', '男', 21, '商学院', '19市场营销3班', '135485214526'); INSERT INTO `t_student` VALUES ('19070110', '刘小梅', '女', 19, '信息工程学院', '19大数据1班', '147523956456'); INSERT INTO `t_student` VALUES ('19070189', '张雪梅', '女', 21, '信息工程学院', '19软件技术1班', '13369586741'); INSERT INTO `t_student` VALUES ('19070204', '陈华生', '男', 20, '信息工程学院', '19软件技术1班', '13312569854'); INSERT INTO `t_student` VALUES ('19070207', '王东', '男', 19, '信息工程学院', '19计算机技术1班', '18936589852'); INSERT INTO `t_student` VALUES ('19070369', '刘春', '女', 20, '艺术学院', '19园林技术1班', '134569852456'); INSERT INTO `t_student` VALUES ('19070417', '廖勇', '男', 18, '信息工程学院', '19计算机技术2班', '18936585963'); INSERT INTO `t_student` VALUES ('19070580', '吴刚', '男', 21, '郎酒学院', '19酿造3班', '135487034986'); INSERT INTO `t_student` VALUES ('19070621', '韩小月', '女', 20, '商学院', '19电商1班', '135485216325'); INSERT INTO `t_student` VALUES ('19070807', '江梅', '女', 21, '人文学院', '19小教1班', '1832419146'); INSERT INTO `t_student` VALUES ('19070813', '肖成山', '男', 21, '商学院', '19市场营销3班', '135485214951'); INSERT INTO `t_student` VALUES ('19070830', '高苇', '女', 20, '建筑工程学院', '19建筑工程1班', '133698541123'); INSERT INTO `t_student` VALUES ('19070909', '王刚', '男', 21, '郎酒学院', '19酿造3班', '135487034526'); INSERT INTO `t_student` VALUES ('19070921', '王飞', '男', 20, '人文学院', '19文秘2班', '135698541753'); INSERT INTO `t_student` VALUES ('19070990', '端木寒', '女', 20, '艺术学院', '19舞蹈1', '134929752782'); INSERT INTO `t_student` VALUES ('19071187', '张龙', '男', 20, '建筑工程学院', '19工程测量2班', '133636441254'); INSERT INTO `t_student` VALUES ('19071419', '上官龙', '男', 20, '建筑工程学院', '19工程测量2班', '133636441965'); INSERT INTO `t_student` VALUES ('19075107', '李晓', '女', 19, '建筑工程学院', '19建筑工程1班', '133698541254'); INSERT INTO `t_student` VALUES ('19075794', '东方晓', '女', 19, '建筑工程学院', '19建筑工程1班', '133698541745'); -- ---------------------------- -- Table structure for t_user -- ---------------------------- DROP TABLE IF EXISTS `t_user`; CREATE TABLE `t_user` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID', `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户名', `password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户密码', `telephone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系电话', `register_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '注册时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of t_user -- ---------------------------- INSERT INTO `t_user` VALUES (1, 'admin', 'admin', '15888781123', '2020-07-01 09:19:22'); INSERT INTO `t_user` VALUES (2, '王霞', '111111', '13990901140', '2020-07-01 09:20:06'); INSERT INTO `t_user` VALUES (3, '段誉', '222222', '12345678941', '2020-07-01 09:20:36'); INSERT INTO `t_user` VALUES (4, '郑琳', '333333', '14784523698', '2020-07-01 09:21:06'); INSERT INTO `t_user` VALUES (5, '李红', '444444', '12478945321', '2020-07-01 09:21:38'); INSERT INTO `t_user` VALUES (6, '唐安', '555555', '74123456985', '2020-07-01 09:22:02'); INSERT INTO `t_user` VALUES (7, '李国', '666666', '12376983245', '2020-07-01 09:22:23'); INSERT INTO `t_user` VALUES (8, '王平', '777777', '13974568231', '2020-07-01 09:22:50'); SET FOREIGN_KEY_CHECKS = 1;