上第一次实训课感想

上第一次Java实训课感想

第一天开始实训，有点担心自己不会做，但第一天分配的任务比我想象的要简单一点，是用navicat创建数据表，用到了mysql的知识。
比较麻烦的就是给表导入数据，因为数据比较多，所以比较麻烦，但总体来说还好。
然后用百度脑图创建了一张思维导图，如下图
如下是数据表
/*
Navicat Premium Data Transfer

Source Server : java_mysql
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: 29/06/2020 11:16:15
*/

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,
name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘学校名称’,
president varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘校长’,
start_time timestamp NULL DEFAULT NULL COMMENT ‘建校时间’,
telephone varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘联系电话’,
email varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘电子邮箱’,
address varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘通讯地址’,
profile varchar(10000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘学校简介’,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

---

– Records of t_college

---

INSERT INTO t_college VALUES (1, ‘泸州职业技术学院’, ‘贺元成’, ‘2003-04-23 00:00:00’, ‘0830-3150397’, ‘lzy2003@lzy.com’, ‘泸州市龙马潭区长桥路2号’, ‘泸州职业技术学院是经四川省人民政府批准、国家教育部备案的综合性公办普通高等学校。以全日制高职专科学历教育为主，兼顾成人学历教育、中外合作学历教育和社会培训，具有接收外国留学生资质和聘请外教专家资格。学校坐落于激流澎湃的长江之滨、沱江之畔，开设39个高职专科专业，在校生近15000人，占地1271亩，建设总投资25亿元，建筑总面积60万平方米，建筑总投资和办学条件跃居全省专科学校前列。\r\n————————————————\r\n版权声明：本文为CSDN博主「howard2005」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。\r\n原文链接：https://blog.csdn.net/howard2005/java/article/details/106555706’);

---

– Table structure for t_status

---

DROP TABLE IF EXISTS t_status;
CREATE TABLE t_status (
id int(11) NOT NULL,
college varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘学校名称’,
version varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘系统版本’,
author varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘作者’,
telephone varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘联系电话’,
address varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘通讯地址’,
email varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

---

– Records of t_status

---

INSERT INTO t_status VALUES (1, ‘泸职院’, ‘V5.5’, ‘邓力涓’, ‘15183047291’, ‘泸职院信息工程系’, ‘3329885854.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 COMMENT ‘学号’,
name varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘姓名’,
sex varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘性别’,
age int(11) NULL DEFAULT NULL COMMENT ‘年龄’,
department varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘系部’,
class varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘班级’,
telephone varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 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 (‘19204001’, ‘程刚’, ‘男’, 20, ‘信息工程学院’, ‘19计应2班’, ‘15183044271’);
INSERT INTO t_student VALUES (‘19204002’, ‘李毅’, ‘男’, 19, ‘人文学院’, ‘19小教3班’, ‘15183037591’);
INSERT INTO t_student VALUES (‘19204003’, ‘钟磊’, ‘男’, 20, ‘人文学院’, ‘19小教2班’, ‘13700654987’);
INSERT INTO t_student VALUES (‘19204004’, ‘吴昕’, ‘女’, 19, ‘商学院’, ‘19会计1班’, ‘13700986421’);
INSERT INTO t_student VALUES (‘19204005’, ‘李阳’, ‘男’, 19, ‘商学院’, ‘19营销2班’, ‘13543301654’);
INSERT INTO t_student VALUES (‘19204006’, ‘程杰’, ‘男’, 19, ‘商学院’, ‘19会计2班’, ‘13978561130’);
INSERT INTO t_student VALUES (‘19204007’, ‘吴刚’, ‘男’, 19, ‘人文学院’, ‘19小教1班’, ‘13567548740’);
INSERT INTO t_student VALUES (‘19204008’, ‘吴玲’, ‘女’, 19, ‘信息工程学院’, ‘19大数据1班’, ‘13978781130’);
INSERT INTO t_student VALUES (‘19204009’, ‘武陵’, ‘男’, 19, ‘人文学院’, ‘19小教1班’, ‘15148754210’);
INSERT INTO t_student VALUES (‘19204101’, ‘王菲’, ‘女’, 18, ‘信息工程学院’, ‘19软件1班’, ‘15148791020’);
INSERT INTO t_student VALUES (‘19204102’, ‘程俊’, ‘男’, 20, ‘信息工程学院’, ‘19软件2班’, ‘13700785321’);
INSERT INTO t_student VALUES (‘19204103’, ‘向刚’, ‘男’, 20, ‘信息工程学院’, ‘19计应1班’, ‘13948343016’);
INSERT INTO t_student VALUES (‘19204201’, ‘李文’, ‘男’, 19, ‘信息工程学院’, ‘19计应2班’, ‘15143204101’);
INSERT INTO t_student VALUES (‘19204202’, ‘华晨’, ‘男’, 19, ‘信息工程学院’, ‘19大数据1班’, ‘15183047285’);
INSERT INTO t_student VALUES (‘19204210’, ‘李强’, ‘男’, 19, ‘信息工程学院’, ‘19大数据2班’, ‘15182403121’);
INSERT INTO t_student VALUES (‘19204212’, ‘李刚’, ‘男’, 20, ‘信息工程学院’, ‘19计应2班’, ‘15183044214’);
INSERT INTO t_student VALUES (‘19204213’, ‘王武’, ‘男’, 19, ‘人文学院’, ‘19小教3班’, ‘13587875478’);
INSERT INTO t_student VALUES (‘19204214’, ‘钱森’, ‘男’, 20, ‘人文学院’, ‘19小教2班’, ‘13954875413’);
INSERT INTO t_student VALUES (‘19204215’, ‘李锐’, ‘女’, 19, ‘商学院’, ‘19会计1班’, ‘15145678945’);
INSERT INTO t_student VALUES (‘19204216’, ‘邓刚’, ‘男’, 19, ‘商学院’, ‘19营销2班’, ‘13545678945’);
INSERT INTO t_student VALUES (‘19204217’, ‘田新海’, ‘男’, 19, ‘商学院’, ‘19会计2班’, ‘13786541345’);
INSERT INTO t_student VALUES (‘19204218’, ‘张海洋’, ‘男’, 19, ‘人文学院’, ‘19小教1班’, ‘13712345676’);
INSERT INTO t_student VALUES (‘19204220’, ‘汪梅’, ‘女’, 19, ‘信息工程学院’, ‘19大数据1班’, ‘13954878654’);
INSERT INTO t_student VALUES (‘19204221’, ‘张杰’, ‘男’, 19, ‘人文学院’, ‘19小教1班’, ‘13545135789’);
INSERT INTO t_student VALUES (‘19204230’, ‘程成’, ‘女’, 18, ‘信息工程学院’, ‘19软件1班’, ‘13745464874’);
INSERT INTO t_student VALUES (‘19204231’, ‘苟大海’, ‘男’, 20, ‘信息工程学院’, ‘19软件2班’, ‘13578945648’);
INSERT INTO t_student VALUES (‘19204232’, ‘汪洋’, ‘男’, 20, ‘商学院’, ‘19营销2班’, ‘13547895465’);
INSERT INTO t_student VALUES (‘19204233’, ‘李洋’, ‘男’, 19, ‘建筑工程学院’, ‘19测量1班’, ‘13548784564’);
INSERT INTO t_student VALUES (‘19204234’, ‘苟新成’, ‘男’, 18, ‘建筑工程学院’, ‘19装饰2班’, ‘13748645447’);
INSERT INTO t_student VALUES (‘19204305’, ‘姜赫’, ‘男’, 20, ‘建筑工程学院’, ‘19建工1班’, ‘15187644577’);
INSERT INTO t_student VALUES (‘19204330’, ‘戴碧玉’, ‘女’, 20, ‘商学院’, ‘19会计1班’, ‘15178645447’);
INSERT INTO t_student VALUES (‘19204331’, ‘江河’, ‘男’, 19, ‘商学院’, ‘19营销2班’, ‘15123487523’);
INSERT INTO t_student VALUES (‘19204332’, ‘蒋宇呈’, ‘女’, 19, ‘商学院’, ‘19会计2班’, ‘15745467454’);
INSERT INTO t_student VALUES (‘19204333’, ‘姜懿轩’, ‘男’, 19, ‘商学院’, ‘19电商1班’, ‘15748645454’);
INSERT INTO t_student VALUES (‘19204334’, ‘贺辞’, ‘男’, 20, ‘人文学院’, ‘19小教1班’, ‘15148745487’);
INSERT INTO t_student VALUES (‘19204335’, ‘李春华’, ‘男’, 19, ‘信息工程学院’, ‘19大数据1班’, ‘13745648786’);
INSERT INTO t_student VALUES (‘19204336’, ‘贾贺’, ‘男’, 20, ‘人文学院’, ‘19小教2班’, ‘13945678754’);
INSERT INTO t_student VALUES (‘19204337’, ‘徐宝才’, ‘男’, 19, ‘信息工程学院’, ‘19软件1班’, ‘15245867874’);
INSERT INTO t_student VALUES (‘19204338’, ‘薛平贵’, ‘男’, 19, ‘信息工程学院’, ‘19软件2班’, ‘18745648745’);
INSERT INTO t_student VALUES (‘19204339’, ‘上官宇轩’, ‘男’, 19, ‘商学院’, ‘19会计2班’, ‘19954874547’);
INSERT INTO t_student VALUES (‘19204340’, ‘岳云’, ‘男’, 19, ‘建筑工程学院’, ‘19造价1班’, ‘18345787455’);
INSERT INTO t_student VALUES (‘19204341’, ‘贾迎春’, ‘女’, 19, ‘建筑工程学院’, ‘19建工1班’, ‘17745678784’);
INSERT INTO t_student VALUES (‘19204342’, ‘岳飞’, ‘男’, 19, ‘建筑工程学院’, ‘19装饰1班’, ‘17745578784’);
INSERT INTO t_student VALUES (‘19204343’, ‘张飞’, ‘男’, 18, ‘商学院’, ‘19营销1班’, ‘17723468874’);
INSERT INTO t_student VALUES (‘19204344’, ‘诸葛青’, ‘男’, 20, ‘建筑工程学院’, ‘19软件1班’, ‘18344675487’);
INSERT INTO t_student VALUES (‘19204345’, ‘黄美佳’, ‘女’, 19, ‘建筑工程学院’, ‘19软件2班’, ‘13946578748’);
INSERT INTO t_student VALUES (‘19204346’, ‘王默’, ‘男’, 20, ‘建筑工程学院’, ‘19计应1班’, ‘18354875457’);
INSERT INTO t_student VALUES (‘19204347’, ‘程思思’, ‘女’, 18, ‘建筑工程学院’, ‘19计应2班’, ‘18345787874’);
INSERT INTO t_student VALUES (‘19204348’, ‘王思思’, ‘女’, 18, ‘建筑工程学院’, ‘19大数据1班’, ‘15154578784’);
INSERT INTO t_student VALUES (‘19204349’, ‘彭贺’, ‘男’, 19, ‘建筑工程学院’, ‘19计应4班’, ‘15147878745’);

---

– Table structure for t_user

---

DROP TABLE IF EXISTS t_user;
CREATE TABLE t_user (
id int(11) NOT NULL COMMENT ‘用户ID’,
username varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘用户名’,
password varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘用户密码’,
telephone varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘联系电话’,
register_time timestamp NULL DEFAULT NULL COMMENT ‘注册时间’,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

---

– Records of t_user

---

INSERT INTO t_user VALUES (1, ‘admin’, ‘admin’, ‘15888781123’, ‘2020-03-11 15:27:12’);
INSERT INTO t_user VALUES (2, ‘王霞’, ‘111111’, ‘13998854542’, ‘2020-04-17 10:28:06’);
INSERT INTO t_user VALUES (3, ‘段誉’, ‘222222’, ‘13545478658’, ‘2020-05-22 10:28:48’);
INSERT INTO t_user VALUES (4, ‘郑琳’, ‘333333’, ‘15183487954’, ‘2020-05-28 11:29:24’);
INSERT INTO t_user VALUES (5, ‘李宏’, ‘444444’, ‘15154687974’, ‘2020-05-30 08:30:07’);
INSERT INTO t_user VALUES (6, ‘唐庆’, ‘555555’, ‘13700598464’, ‘2020-06-02 16:31:04’);
INSERT INTO t_user VALUES (7, ‘李嘉’, ‘666666’, ‘13758469854’, ‘2020-06-10 10:31:44’);
INSERT INTO t_user VALUES (8, ‘王平’, ‘777777’, ‘15145874545’, ‘2020-06-10 10:50:43’);

SET FOREIGN_KEY_CHECKS = 1;