GUI学生信息管理系统-java实训项目1

步骤

一，创建数据库student

二， 创建状态表t_college,t_status,t_student,t_user.

三，转存SQL文件。

一，创建数据库student

二， 创建状态表t_college,t_status,t_student,t_user.

三，转存sql文件。

查看SQL文件 student.sql

/*

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/ 11:30:05

*/

SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;

– Table structure for t_college

DROP TABLE IF EXISTSt_college;

CREATE TABLEt_college(

idint(11) NOT NULL,

namevarchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘学校名称’,

presidentvarchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘校长’,

start_timetimestamp NULL DEFAULT NULL COMMENT ‘建校时间’,

telephonevarchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘联系电话’,

emailvarchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘电子邮箱’,

addressvarchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘通讯地址’,

profilevarchar(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 INTOt_collegeVALUES (1, ‘泸州职业技术学院’, ‘杨宗伟’, ‘-04-23 00:00:00’, ‘0830-3150397’, ‘lzy@’, ‘泸州市龙马潭区长桥路2号’, ‘泸州职业技术学院是经四川省人民政府批准、国家教育部备案的综合性公办普通高等学校。以全日制高职专科学历教育为主，兼顾成人学历教育、中外合作学历教育和社会培训，具有接收外国留学生资质和聘请外教专家资格。\r\n\r\n二、悠久历史’);

– Table structure for t_status

DROP TABLE IF EXISTSt_status;

CREATE TABLEt_status(

idint(11) NOT NULL,

collegevarchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘学校名称’,

versionvarchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘系统版本’,

authorvarchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘作者’,

telephonevarchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘联系电话’,

addressvarchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘通讯地址’,

emailvarchar(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 INTOt_statusVALUES (1, ‘泸职院’, ‘v1.0’, ‘车昭勇’, ‘18483518775’, ‘泸职院信息工程系’, ‘1484781242@’);

– Table structure for t_student

DROP TABLE IF EXISTSt_student;

CREATE TABLEt_student(

idvarchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘学号’,

namevarchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘姓名’,

sexvarchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘性别’,

ageint(11) NULL DEFAULT NULL COMMENT ‘年龄’,

departmentvarchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘系部’,

classvarchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘班级’,

telephonevarchar(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 INTOt_studentVALUES (‘1916’, ‘张宁’, ‘男’, 21, ‘国际学院’, ‘19英教2班’, ‘15864354776’);

INSERT INTOt_studentVALUES (‘1916’, ‘易江’, ‘男’, 20, ‘国际学院’, ‘19英教2班’, ‘15887695243’);

INSERT INTOt_studentVALUES (‘1916’, ‘王腾’, ‘女’, 20, ‘国际学院’, ‘19英教2班’, ‘12345875545’);

INSERT INTOt_studentVALUES (‘1916’, ‘蔡荣’, ‘女’, 19, ‘商学院’, ‘19市场营销1班’, ‘15568767677’);

INSERT INTOt_studentVALUES (‘1916’, ‘刘星’, ‘男’, 21, ‘商学院’, ‘19市场营销1班’, ‘15647984646’);

INSERT INTOt_studentVALUES (‘1916’, ‘张聪’, ‘男’, 18, ‘商学院’, ‘19市场营销1班’, ‘16897897465’);

INSERT INTOt_studentVALUES (‘19242’, ‘陈晨’, ‘女’, 20, ‘信息工程学院’, ‘19软件2班’, ‘19849798466’);

INSERT INTOt_studentVALUES (‘19242001’, ‘李刚’, ‘男’, 20, ‘信息工程学院’, ‘19软件1班’, ‘15649884637’);

INSERT INTOt_studentVALUES (‘19242002’, ‘王超’, ‘男’, 19, ‘信息工程学院’, ‘19软件1班’, ‘18794646984’);

INSERT INTOt_studentVALUES (‘1924’, ‘吴琳’, ‘女’, 19, ‘信息工程学院’, ‘19软件2班’, ‘18798464647’);

INSERT INTOt_studentVALUES (‘19252001’, ‘王朝’, ‘男’, 20, ‘信息工程学院’, ‘19计应1班’, ‘19849841654’);

INSERT INTOt_studentVALUES (‘1925’, ‘张弓’, ‘男’, 20, ‘信息工程学院’, ‘19计应1班’, ‘19847984578’);

INSERT INTOt_studentVALUES (‘1925’, ‘陈静’, ‘女’, 20, ‘信息工程学院’, ‘19计应1班’, ‘18984847846’);

INSERT INTOt_studentVALUES (‘19252046’, ‘王芳’, ‘女’, 19, ‘信息工程学院’, ‘19计应2班’, ‘14894894548’);

INSERT INTOt_studentVALUES (‘1927’, ‘杨帆’, ‘男’, 20, ‘信息工程学院’, ‘19大数据2班’, ‘16849845465’);

INSERT INTOt_studentVALUES (‘1927’, ‘曹植’, ‘男’, 20, ‘信息工程学院’, ‘19大数据1班’, ‘15489416547’);

INSERT INTOt_studentVALUES (‘19272046’, ‘何芳’, ‘女’, 18, ‘信息工程学院’, ‘19大数据1班’, ‘16848465445’);

INSERT INTOt_studentVALUES (‘19302001’, ‘李帅’, ‘男’, 19, ‘国际学院’, ‘19英教1班’, ‘18475123641’);

INSERT INTOt_studentVALUES (‘1930’, ‘焦宇’, ‘女’, 19, ‘国际学院’, ‘19英教1班’, ‘13456784345’);

INSERT INTOt_studentVALUES (‘1930’, ‘杨颖’, ‘女’, 20, ‘国际学院’, ‘19英教1班’, ‘15874563258’);

INSERT INTOt_studentVALUES (‘1930’, ‘武瑞’, ‘男’, 18, ‘国际学院’, ‘19英教1班’, ‘15878965645’);

INSERT INTOt_studentVALUES (‘19302038’, ‘张明’, ‘男’, 19, ‘国际学院’, ‘19英教2班’, ‘13467874567’);

INSERT INTOt_studentVALUES (‘19302046’, ‘吴梅’, ‘女’, 20, ‘国际学院’, ‘19英教2班’, ‘12358987576’);

INSERT INTOt_studentVALUES (‘19302048’, ‘王松’, ‘男’, 20, ‘国际学院’, ‘19英教1班’, ‘13684566978’);

INSERT INTOt_studentVALUES (‘19382001’, ‘林国瑞’, ‘男’, 19, ‘人文学院’, ‘19小学教育2班’, ‘19354343742’);

INSERT INTOt_studentVALUES (‘1938’, ‘阮建安’, ‘男’, 20, ‘人文学院’, ‘19语文教育1班’, ‘1345345.3453’);

INSERT INTOt_studentVALUES (‘1938’, ‘李梦琪’, ‘女’, 18, ‘人文学院’, ‘19小学教育1班’, ‘14786734534’);

INSERT INTOt_studentVALUES (‘1938’, ‘张吉惟’, ‘女’, 20, ‘人文学院’, ‘19小学教育1班’, ‘18373543454’);

INSERT INTOt_studentVALUES (‘1938’, ‘顾盼山’, ‘男’, 20, ‘人文学院’, ‘19小学教育1班’, ‘16378345374’);

INSERT INTOt_studentVALUES (‘1938’, ‘杨万福’, ‘男’, 18, ‘人文学院’, ‘19小学教育1班’, ‘13786785454’);

INSERT INTOt_studentVALUES (‘1938’, ‘马云’, ‘男’, 20, ‘人文学院’, ‘19小学教育1班’, ‘12768783754’);

INSERT INTOt_studentVALUES (‘19382099’, ‘林子帆’, ‘男’, 20, ‘人文学院’, ‘19语文教育2班’, ‘15347537874’);

INSERT INTOt_studentVALUES (‘19382111’, ‘刘柏宏’, ‘男’, 20, ‘人文学院’, ‘19语文教育1班’, ‘13734534445’);

INSERT INTOt_studentVALUES (‘19382116’, ‘林雅南’, ‘女’, 19, ‘人文学院’, ‘19语文教育1班’, ‘17637534534’);

INSERT INTOt_studentVALUES (‘19382148’, ‘江奕云’, ‘男’, 19, ‘人文学院’, ‘19语文教育1班’, ‘16783737454’);

INSERT INTOt_studentVALUES (‘19382156’, ‘林玟书’, ‘女’, 19, ‘人文学院’, ‘19小学教育2班’, ‘18345343444’);

INSERT INTOt_studentVALUES (‘1946’, ‘白莲女’, ‘女’, 19, ‘商学院’, ‘19市场营销1班’, ‘19849816546’);

INSERT INTOt_studentVALUES (‘1946’, ‘孙橙红’, ‘女’, 19, ‘商学院’, ‘19市场营销2班’, ‘14278634535’);

INSERT INTOt_studentVALUES (‘1946’, ‘嘉大林’, ‘男’, 20, ‘商学院’, ‘19电子商务1班’, ‘14276784345’);

INSERT INTOt_studentVALUES (‘19462048’, ‘郑成姿’, ‘女’, 18, ‘商学院’, ‘19电子商务1班’, ‘14373783543’);

INSERT INTOt_studentVALUES (‘19462056’, ‘张国富’, ‘男’, 21, ‘商学院’, ‘19电子商务1班’, ‘14378373453’);

INSERT INTOt_studentVALUES (‘19462184’, ‘张虎宝’, ‘男’, 20, ‘商学院’, ‘19市场营销2班’, ‘14276783543’);

INSERT INTOt_studentVALUES (‘19462564’, ‘王璐’, ‘女’, 20, ‘商学院’, ‘19电子商务1班’, ‘14275378354’);

INSERT INTOt_studentVALUES (‘19661233’, ‘邱欣怡’, ‘女’, 19, ‘郎酒学院’, ‘19酿酒2班’, ‘1.3453453431’);

INSERT INTOt_studentVALUES (‘1966’, ‘刘姿婷’, ‘女’, 18, ‘郎酒学院’, ‘19酒店管理1班’, ‘14375343434’);

INSERT INTOt_studentVALUES (‘1966’, ‘吉茹定’, ‘女’, 21, ‘郎酒学院’, ‘19酒店管理1班’, ‘13783783453’);

INSERT INTOt_studentVALUES (‘1966’, ‘黄文隆’, ‘女’, 21, ‘郎酒学院’, ‘19酒店管理1班’, ‘17367343543’);

INSERT INTOt_studentVALUES (‘1966’, ‘谢彦文’, ‘女’, 21, ‘郎酒学院’, ‘19酒店管理1班’, ‘13783683434’);

INSERT INTOt_studentVALUES (‘19662066’, ‘林威绿’, ‘男’, 20, ‘郎酒学院’, ‘19酿酒1班’, ‘13837543453’);

INSERT INTOt_studentVALUES (‘19662100’, ‘吕致盈’, ‘女’, 20, ‘郎酒学院’, ‘19酒店管理2班’, ‘12373743434’);

INSERT INTOt_studentVALUES (‘19662111’, ‘蔡志远’, ‘男’, 18, ‘郎酒学院’, ‘19酒店管理2班’, ‘13734534534’);

INSERT INTOt_studentVALUES (‘19662176’, ‘邓威育’, ’ 男’, 19, ‘郎酒学院’, ‘19酿酒1班’, ‘13439345345’);

INSERT INTOt_studentVALUES (‘19666666’, ‘夏志豪’, ‘男’, 20, ‘郎酒学院’, ‘19酒店管理1班’, ‘13783453435’);

– Table structure for t_user

DROP TABLE IF EXISTSt_user;

CREATE TABLEt_user(

idint(11) NOT NULL COMMENT ‘用户ID’,

usernamevarchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘用户名’,

passwordvarchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘用户密码’,

telephonevarchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘联系电话’,

register_timetimestamp 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 INTOt_userVALUES (1, ‘admin’, ‘admin’, ‘15888781123’, ‘-06-29 10:27:20’);

INSERT INTOt_userVALUES (2, ‘王鑫’, ‘111111’, ‘15349851247’, ‘-06-28 06:28:20’);

INSERT INTOt_userVALUES (3, ‘李丽’, ‘222222’, ‘13358745245’, ‘-06-29 07:29:15’);

INSERT INTOt_userVALUES (4, ‘张三’, ‘333333’, ‘15234875621’, ‘-06-28 06:29:56’);

INSERT INTOt_userVALUES (5, ‘李四’, ‘444444’, ‘15879846487’, ‘-06-28 08:30:26’);

INSERT INTOt_userVALUES (6, ‘李思’, ‘555555’, ‘18745269784’, ‘-06-27 05:31:16’);

INSERT INTOt_userVALUES (7, ‘刘德’, ‘666666’, ‘18754948741’, ‘-06-27 08:32:36’);

INSERT INTOt_userVALUES (8, ‘关羽’, ‘777777’, ‘18789464897’, ‘-06-27 10:33:16’);

INSERT INTOt_userVALUES (9, ‘袁飞’, ‘888888’, ‘16841684897’, ‘-06-27 09:33:41’);

INSERT INTOt_userVALUES (10, ‘曹振’, ‘999999’, ‘18947981436’, ‘-06-26 12:34:20’);

INSERT INTOt_userVALUES (11, ‘杨腾飞’, ‘111222’, ‘16547461464’, ‘-06-25 13:34:58’);

INSERT INTOt_userVALUES (12, ‘唐安’, ‘111333’, ‘18498794647’, ‘-06-25 10:36:11’);

SET FOREIGN_KEY_CHECKS = 1;

感谢指导老师华卫老师。