java实训日志01

一、安装录屏软件

（一）下载软件

	licecap 128-install.exe

**

（二）安装软件

   双击安装程序图标，进入安装导向

二、使用录屏软件

三、安装XMind软件

（一）下载XMind软件

（二）安装XMind软件

四、创建思维导图

（一）启动XMind

（二）新建思维导图

（三）查看PNG图片

五、绘制学生管理系统功能结构图

六、系统运行效果图

七、学生管理系统项目结构图

查看项目结构

八、项目开发实现步骤

（一）创建数据库与表

1.创建数据库

2.创建学校表

• 创建学校表SQL语句

CREATE TABLE `t_college`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' 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;

3.创建状态表

-创建状态表SQL语句

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 '年龄',
  `class` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '班级',
  `department` 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;

4.创建学生表

• 创建学生表t_student

• 创建学生表SQL语句

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 '年龄',
  `class` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '班级',
  `department` 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;

5.创建用户表

-建表SQl语句

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;

-添加表记录SQL语句

INSERT INTO `t_user` VALUES (1, 'admin', 'admin', '15888781123', '2021-03-06 12:00:46');
INSERT INTO `t_user` VALUES (2, '王霞', '111111', '13990901140', '2021-04-01 13:00:49');
INSERT INTO `t_user` VALUES (3, '段誉', '222222', '12345678907', '2021-05-07 14:00:53');
INSERT INTO `t_user` VALUES (4, '郑琳', '333333', '13989891123', '2021-08-13 15:01:22');
INSERT INTO `t_user` VALUES (5, '李红', '444444', '15888781123', '2021-12-06 08:01:00');
INSERT INTO `t_user` VALUES (6, '唐安', '555555', '13853452232', '2021-11-22 06:01:27');
INSERT INTO `t_user` VALUES (7, '李国', '666666', '1234567890', '2021-10-12 21:03:54');
INSERT INTO `t_user` VALUES (8, '王平', '777777', '1234500000', '2021-06-06 17:01:12');

• 查看用户表记录
  

6.导出SQL脚本

7.导入SQL脚本

• 删除student数据库，重新创建student数据库

• 运行SQL文件