<>Java Training program ： The first training course
When the teacher introduced the training program, I felt that there were many contents , At the same time, it is still very difficult . But I still want to try to do this training project well . This is my study Java First training since , It is also an opportunity for me to review and summarize my previous knowledge , At the same time, it is also a practical battle to improve their mastery and application of knowledge .
<> one , Task of this training course
<>1, Build Baidu brain map framework for this training
Imagine the general function and operation of this training
<>2, Creating databases and tables
<>（1）, establish student database
* Database adoption utf-8 Save by encoding method
<>（2）, Create school table
* establish （t_college surface ）
* towards t_college Insert data in table INSERT INTO `t_college` VALUES (1, ' Luzhou vocational and Technical College ', ' Yangzongwei ',
'2003-04-23 00:00:00', '0830-3150397', '[email protected]', ' Changqiao Road, Longmatan District, Luzhou City 2 number ',
' Luzhou vocational and technical college is approved by the people's Government of Sichuan Province , Comprehensive public colleges and universities registered by the Ministry of Education . Give priority to full-time higher vocational college education , Give consideration to adult academic education , Sino foreign cooperative academic education and social training , Qualified to accept foreign students and employ foreign teachers and experts . The school is located on the Bank of the surging Yangtze River , By the Tuojiang River , open 39 Higher Vocational College Majors , Students near 15000 people , Land occupation 1271 Mu , Total construction investment 25 RMB100mn , Total building area 60 10000 square meters , The total construction investment and school running conditions leapt to the forefront of colleges in the province .');
<>（3）, Create status table
* establish t_status surface
* towards t_status Insert data in table
INSERT INTO t_status VALUES (1, ‘ Luzhou Vocational College ’, ‘V1.0’, ‘ Huangliwen ’, ‘15182774579’,
‘ Information Engineering College of Luzhou Vocational College ’, ‘[email protected]’);
<>（4）, Create student table
* establish t_student surface
* towards t_student Insert data in table INSERT INTO `t_student` VALUES ('19204091', ' Huang Yun ', ' male ', 18,
'2019 Accrued 1 class ', ' School of Information Engineering ', '17318654033'); INSERT INTO `t_student` VALUES
('19204188', ' Zhang hang ', ' male ', 19, '2019 Accrued 3 class ', ' School of Information Engineering ', '15808230272'); INSERT INTO
`t_student` VALUES ('19204189', ' Huangxiaohui ', ' male ', 17, '2019 Accrued 2 class ', ' School of Information Engineering ',
'15182614160'); INSERT INTO `t_student` VALUES ('19204193', ' Zhoutianyu ', ' male ', 18,
'2019 Accrued 3 class ', ' School of Information Engineering ', '15281314950'); INSERT INTO `t_student` VALUES
('19204196', ' Wushuanglong ', ' male ', 18, '2019 Accrued 5 class ', ' School of Information Engineering ', '15283002142'); INSERT INTO
`t_student` VALUES ('19204204', ' Leitinghao ', ' male ', 19, '2019 Accrued 4 class ', ' School of Information Engineering ',
'18584193725'); INSERT INTO `t_student` VALUES ('19204205', ' Laixiaotong ', ' female ', 19,
'2019 Accrued 3 class ', ' School of Information Engineering ', '15828814625'); INSERT INTO `t_student` VALUES
('19204207', ' Duyulu ', ' female ', 19, '2019 English religion 1 class ', ' International College ', '18716175667'); INSERT INTO
`t_student` VALUES ('19204212', ' Prophet Wei ', ' male ', 18, '2019 English religion 2 class ', ' International College ',
'15228935822'); INSERT INTO `t_student` VALUES ('19204219', ' Shubin ', ' male ', 20,
'2019 English religion 3 class ', ' International College ', '18383036430'); INSERT INTO `t_student` VALUES ('19204221',
' Liyushan ', ' male ', 22, '2019 English religion 2 class ', ' International College ', '15908362754'); INSERT INTO `t_student`
VALUES ('19204225', ' Yan Guichuan ', ' male ', 18, '2019 English religion 1 class ', ' International College ', '17360565517'); INSERT
INTO `t_student` VALUES ('19204233', ' Linzhengchuan ', ' male ', 18, '2019 primary-school education 1 class ', ' College of Humanities ',
'18715895290'); INSERT INTO `t_student` VALUES ('19204234', ' Chentong ', ' male ', 18,
'2019 primary-school education 2 class ', ' College of Humanities ', '15108181750'); INSERT INTO `t_student` VALUES ('19204236',
' Wang Chuan ', ' male ', 17, '2019 primary-school education 3 class ', ' College of Humanities ', '15328400375'); INSERT INTO `t_student`
VALUES ('19204237', ' Wumengying ', ' female ', 19, '2019 primary-school education 3 class ', ' College of Humanities ', '18048681302'); INSERT
INTO `t_student` VALUES ('19204269', ' Zhuhongju ', ' female ', 19, '2019 primary-school education 3 class ', ' College of Humanities ',
'15760637644'); INSERT INTO `t_student` VALUES ('19204295', ' Chenjiang ', ' female ', 20,
'2019 primary-school education 3 class ', ' College of Humanities ', '18283412467'); INSERT INTO `t_student` VALUES ('19204301',
' Wangliangman ', ' female ', 10, '2019 electromechanical 3 class ', ' College of Mechanical Engineering ', '18380917891'); INSERT INTO `t_student`
VALUES ('19204302', ' Denglijuan ', ' female ', 19, '2019 electromechanical 3 class ', ' College of Mechanical Engineering ', '15183047291');
INSERT INTO `t_student` VALUES ('19204305', ' Leiyi ', ' female ', 19, '2019 electromechanical 3 class ',
' College of Mechanical Engineering ', '19161537841'); INSERT INTO `t_student` VALUES ('19205010', ' Yuan Tao ',
' male ', 19, '2019 electromechanical 3 class ', ' College of Mechanical Engineering ', '18090544532'); INSERT INTO `t_student` VALUES
('19205019', ' Yuanxiaolong ', ' male ', 18, '2019 electromechanical 3 class ', ' College of Mechanical Engineering ', '15760086865'); INSERT INTO
`t_student` VALUES ('19205059', ' Jia Yangqing ', ' female ', 19, '2019 Electric response 3 class ', ' School of Electronic Engineering ',
'13541336205'); INSERT INTO `t_student` VALUES ('19205091', ' Chenqiufan ', ' male ', 18,
'2019 Electric response 3 class ', ' School of Electronic Engineering ', '18383067893'); INSERT INTO `t_student` VALUES
('19205177', ' Peng Hui ', ' female ', 18, '2019 Electric response 3 class ', ' School of Electronic Engineering ', '13064386657'); INSERT INTO
`t_student` VALUES ('19205178', ' ZhangYanlin ', ' female ', 18, '2019 Electric response 3 class ', ' School of Electronic Engineering ',
'18784994152'); INSERT INTO `t_student` VALUES ('19205183', ' Tangjiaming ', ' male ', 19,
'2019 Electric response 3 class ', ' School of Electronic Engineering ', '15908394072'); INSERT INTO `t_student` VALUES
('19205211', ' Liu Yu ', ' male ', 19, '2019 Electric response 3 class ', ' School of Electronic Engineering ', '19908253971'); INSERT INTO
`t_student` VALUES ('19232301', ' Li Bing ', ' male ', 20, '2019 Digital media 1 class ', ' School of art and media ',
'18919889973'); INSERT INTO `t_student` VALUES ('19232303', ' Li Qi ', ' female ', 18,
'2019 Marketing 2 class ', ' Business School ', '18465639847'); INSERT INTO `t_student` VALUES ('19232304',
' Zhangqiqi ', ' female ', 19, '2019 Marketing 1 class ', ' Business School ', '28373738292'); INSERT INTO `t_student`
VALUES ('19232308', ' Zhang Yuan ', ' female ', 20, '2019 electromechanical 2 class ', ' College of Mechanical Engineering ', '13474647888'); INSERT
INTO `t_student` VALUES ('19232316', ' Zhangqidong ', ' male ', 18, '2019 Marketing 1 class ', ' Business School ',
'13468998779'); INSERT INTO `t_student` VALUES ('19232319', ' Lisandong ', ' male ', 20,
'2019 electromechanical 2 class ', ' College of Mechanical Engineering ', '12874648399'); INSERT INTO `t_student` VALUES
('19232392', ' Zhang Yun ', ' male ', 19, '2019 Marketing 1 class ', ' Business School ', '14790463884'); INSERT INTO
`t_student` VALUES ('19242005', ' Che Zhaoyong ', ' male ', 19, '2019 online retailers 3 class ', ' Business School ',
'18483518775'); INSERT INTO `t_student` VALUES ('19242006\r\n', ' Luoronghan ', ' male ', 18,
'2019 online retailers 3 class ', ' Business School ', '17380873970'); INSERT INTO `t_student` VALUES ('19242009',
' Kangxin ', ' female ', 19, '2019 online retailers 3 class ', ' Business School ', '17713750616'); INSERT INTO `t_student`
VALUES ('19242020', ' Zhaoxulin ', ' male ', 19, '2019 Digital media 3 class ', ' School of art and media ', '18384389937');
INSERT INTO `t_student` VALUES ('19242033', ' Peidong ', ' male ', 18, '2019 Digital media 1 class ',
' School of art and media ', '19137925638'); INSERT INTO `t_student` VALUES ('19242048', ' Deng Cong ',
' male ', 18, '2019 Digital media 3 class ', ' School of art and media ', '18782682231'); INSERT INTO `t_student` VALUES
('19242066', ' Zhang Xi ', ' female ', 19, '2019 Marketing 1 class ', ' Business School ', '13467858424'); INSERT INTO
`t_student` VALUES ('19242067', ' Liyaqiao ', ' female ', 18, '2019 Digital media 3 class ', ' School of art and media ',
'18381590816'); INSERT INTO `t_student` VALUES ('19242073', ' Li Yun ', ' male ', 19,
'2019 Digital media 3 class ', ' School of art and media ', '18328974944'); INSERT INTO `t_student` VALUES
('19242095', ' Liuyaling ', ' female ', 19, '2019 Digital media 3 class ', ' School of art and media ', '19283746478'); INSERT INTO
`t_student` VALUES ('19242096', ' Chenyangmin ', ' female ', 20, '2019 Accrued 3 class ', ' School of Information Engineering ',
'15923369098'); INSERT INTO `t_student` VALUES ('19242097', ' Leiping ', ' male ', 18,
'2019 Accrued 3 class ', ' School of Information Engineering ', '13929387646'); INSERT INTO `t_student` VALUES
('19242098', ' Likunhua ', ' male ', 19, '2019 Electric response 3 class ', ' School of Electronic Engineering ', '15283268376'); INSERT INTO
`t_student` VALUES ('19242099', ' Zhangdadong ', ' male ', 20, '2019 electromechanical 2 class ', ' College of Mechanical Engineering ',
'15838824597');
<>（5）, Create user table
* establish t_user surface
* towards t_user Insert data in table INSERT INTO `t_user` VALUES (1, 'admin', 'admin',
'15888781123', '2020-06-06 11:00:46'); INSERT INTO `t_user` VALUES (2, ' Wang Xia ',
'111111', '13990901140', '2020-06-06 11:00:49'); INSERT INTO `t_user` VALUES
(3, ' duan yu ', '222222', '12345678907', '2020-06-06 11:00:53'); INSERT INTO `t_user`
VALUES (4, ' Zhenglin ', '333333', '13989891123', '2020-06-06 11:01:22'); INSERT INTO
`t_user` VALUES (5, ' Li Hong ', '444444', '15888781123', '2020-06-06 11:01:00');
INSERT INTO `t_user` VALUES (6, ' Tang an ', '555555', '13853452232', '2020-06-06
11:01:27'); INSERT INTO `t_user` VALUES (7, ' Li Guo ', '666666', '1234567890',
'2020-06-06 11:03:54'); INSERT INTO `t_user` VALUES (8, ' Wang Ping ', '777777',
'1234500000', '2020-06-06 11:01:12');
<>(6) Redeposit sql file
* This step is mainly used to delete the data in the table when writing the project , We run sql File can get the original table and data to avoid re creation
* preservation SQL Document method ——Navicat Selected in student Database right click > Select Save as SQL file > Select storage location
Technology