思维导图##在Navicat中创建数据库和表使用MySQL
##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', '泸州市龙马潭区长桥路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');
-- ----------------------------
-- 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;
更多推荐
Java实训学生信息管理系统——（一）数据库,表创建
发布评论