capstone训练营2018-1-3

Mysql：总结：

报名表：（学生报名时）

名字、身份证、年龄、电话、地址、毕业学校、志愿一、志愿二、可以参加考试时间、资格审查、录取状态、（要求：增加、删除、修改）

学生报名表：

 

1.    增

#插入数据

INSERTINTOstu_sign(stu_name,stu_age,stu_idcard,stu_telephone,stu_address,stu_graduateschool,

stu_firstvolunteer,stu_nextvolunteer,stu_testtime1)

VALUES("王二",23,210311199806030712,15530154458,'辽宁省鞍山市','第二高中','软件技术','电子商务','2017-12-3112:00:00');

删：

DELETE  FROM stu_sign

WHEREstu_id=48;

改：UPDATE stu_signSET  stu_name="张明成",stu_age=63WHERE stu_id=5;

三、考场表：

  考场总表：（要求：不能重复、不能超过考场人最大数）

          年份、日期、报名表id、考场号、座位号

  考场表：

          考场号、最大人数、报名表id

考场总表

INSERTINTO `stu_examinationroom-all`

(stu_id,stu_name,stu_idcard,stu_testtime1,stu_qualification)

SELECTstu_id,stu_name,stu_idcard,stu_testtime1,stu_qualification

FROMstu_sign

 

#通过stu_examinationroom_all表获取学生的编号，姓名，身份证号，考试时间，考场号，座位号，并将考场为1的人分为一个考场

INSERTINTO `stu_examinationroom1`(stu_id,stu_name,stu_idcard,stu_testtime1,stu_roomnumber,stu_seatnumber )

SELECTstu_id,stu_name,stu_idcard,stu_testtime1,stu_roomnumber,stu_seatnumber

FROM`stu_examinationroom_all` WHERE stu_roomnumber = 1

 

#通过stu_examinationroom_all表获取学生的编号，姓名，身份证号，考试时间，考场号，座位号，并将考场为2的人分为一个考场

INSERTINTO `stu_examinationroom2`(stu_id,stu_name,stu_idcard,stu_testtime1,stu_roomnumber,stu_seatnumber )

SELECTstu_id,stu_name,stu_idcard,stu_testtime1,stu_roomnumber,stu_seatnumber

FROM`stu_examinationroom_all`

WHEREstu_roomnumber = 2

 

/*修改学号为1的考试时间，考试时间为2017-12-3012:00:00和2017-12-31 12:00:00*/

UPDATEstu_examinationroom_all SET stu_testtime1 = "2017-12-30 12:00:00"WHERE stu_id = 1

 

/*按学号查询*/

SELECT *FROM stu_examinationroom_all WHERE stu_id = 1

 

/*按名字查询*/

SELECT *FROM stu_examinationroom_all WHERE stu_name = "赵南宁"

 

 

 

四、成绩表：（要求：旷考、违纪、查询每个考场的出勤率、缺考率、每个考场的平均分）

 年、报名表id、成绩、

陈旭、赵南宁、马鑫（stu_achievement表）

#查询旷考人数

SELECTCOUNT(achievement)旷考人数

FROMstu_achievement

WHEREachievement=0

 

#查询旷考人员名单

SELECTstu_name

FROMstu_achievement

WHEREachievement = 0;

#每个考场的出勤率

 

SELECTCONCAT(TRUNCATE((1-COUNT(achievement)/25)*100,1) ,'%')出勤率

FROMstu_achievement

WHEREachievement=0

 

#缺勤率

SELECTCONCAT(TRUNCATE((COUNT(achievement)/25)*100,1) ,'%')缺勤率

FROMstu_achievement

WHEREachievement=0

 

#每个考场的平均分

 

SELECTAVG(achievement)考场1平均分

FROMstu_achievement

WHEREstu_roomnumber = 1

 

SELECTAVG(achievement)考场2平均分

FROMstu_achievement

WHEREstu_roomnumber = 2

 

SELECTAVG(achievement)成绩,stu_roomnumber

FROMstu_achievement

GROUP BYstu_roomnumber=1,stu_roomnumber=2

 

#增加成绩

INSERTINTOstu_achievement(stu_id,stu_name,stu_idcard,discipline,stu_roomnumber,stu_seatnumber,chinese,math,english,achievement)

VALUES("46","某某",2362736273672,0,2,29,80,80,80,240)

五、录取表：（要求：查询、与成绩表相连、）

          专业、报名表id、成绩、专业分数线、录取人数

二次录取表

张洪建、沈超群（stu_matriculate）

#插入数字媒体应用技术第一志愿

INSERTINTOstu_matriculate(stu_id,stu_name,stu_age,stu_professln,stu_graduateschool,achievement,stu_address,stu_telephone)

SELECTstu_sign.stu_id,stu_sign.stu_name,stu_sign.stu_age,stu_sign.stu_firstvolunteer,stu_sign.stu_graduateschool,achievement,stu_sign.stu_address,stu_sign.stu_telephone

FROMstu_achievement,plan,stu_sign

WHEREstu_achievement.stu_id=stu_sign.stu_id AND stu_sign.stu_firstvolunteer =plan.plan_maj AND plan_maj="数字媒体应用技术"

ANDachievement >= plan_fractional

ORDER BYachievement DESC

LIMIT 0,2

 

#插入数字媒体应用技术第二自愿

INSERTINTO stu_matriculate

SELECTstu_sign.stu_id,stu_sign.stu_name,stu_sign.stu_age,stu_sign.stu_nextvolunteer,stu_sign.stu_graduateschool,achievement,stu_sign.stu_address,stu_sign.stu_telephone,"1"

FROMstu_achievement,plan,stu_sign

WHEREstu_achievement.stu_id=stu_sign.stu_id AND stu_sign.stu_nextvolunteer =plan.plan_maj AND plan_maj="数字媒体应用技术"

ANDachievement >= plan_fractional

ORDER BYachievement DESC

LIMIT 2,1

 

#查找数字媒体应用技术过分数线的学生信息

SELECTstu_sign.stu_id,stu_sign.stu_name,stu_sign.stu_age,stu_sign.stu_firstvolunteer,stu_sign.stu_graduateschool,achievement,stu_sign.stu_address,stu_sign.stu_telephone

FROMstu_achievement,plan,stu_sign

WHEREstu_achievement.stu_id=stu_sign.stu_id AND stu_sign.stu_firstvolunteer =plan.plan_maj AND plan_maj="数字媒体应用技术"

ANDachievement >= plan_fractional

ORDER BYachievement DESC

#插入一条姓名叫赵四的信息

INSERTINTO stu_matriculate(stu_id,stu_name,stu_age,stu_professln,stu_graduateschool,achievement,stu_address,stu_telephone)VALUES(46,"赵四",21,"软件技术","第二高中",299,"辽宁鞍山市",15512365498)

#修改赵四的姓名为赵五

UPDATEstu_matriculate set stu_name = "赵五" WHERE stu_id= 46

#删除赵五的信息

DELETEFROM stu_matriculate WHERE stu_name = "赵五"

Java：

面向对象语言的基本特征
抽象和封装
继承性
多态性

新建系统变量JAVA_HOME 和CLASSPATH 
变量名：JAVA_HOME 
变量值：C:\Program Files\Java\jdk1.7.0
变量名：CLASSPATH 
变量值：.;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\lib\tools.jar;
注意自己安装的jdk路径
选择“系统变量”中变量名为“Path”的环境变量，双击该变量，把JDK安装路径中bin目录的绝对路径，添加到Path变量的值中，并使用半角的分号和已有的路径进行分隔。 
变量名：Path 
变量值：%JAVA_HOME%\bin;%JAVA_HOME%\jre\bin;

在命令行cmd里输入JAVAC可以查看jdk是否安装成功