capstone训练营2018-1-5

Mysql重新总结：

一、	其他表：（刘文俊、刘佳业建表）
1、专业院系表：
 
增：INSERT INTO major(major_id,major_number,major_name,major_department)
	VALUE ()
删：DELETE FROM major WHERE major_number=
改：UPDATE major SET    WHEAR major_number=
查：SELECT major_id,major_number,major_name,major_department
	FROM major
	WHERE major_department=”计算机系”
3、	教师表：
 
增：INSERT INTO leader(led_id,lea_name,lea_post,lea_work)
	VALUE ()
删：DELETE FROM leader WHERE lea_id=
改：UPDATE leader SET    WHEAR lea_id=
查：SELECT led_id,lea_name,lea_post,lea_work
	FROM leader
	WHERE lea_post=”老师”
3、计划表
 
查询计算机系2018招生人数
SELECT sum(plan_number)plan_number FROM plan WHERE plan_maj in (
SELECT major_name from major WHERE major_department like "计算机系")

查询 是否 有错误数据
SELECT plan_maj FROM plan 
where plan_fractional >= 300 OR plan_number <= 0;
查询分数线小于220的专业
SELECT plan_maj,plan_fractional FROM plan 
where plan_fractional < 220
将计划招生时间修改为2018年
UPDATE plan SET plan_time = 2018
修改专业录取分数线
UPDATE plan SET plan_fractional = 280
WHERE  plan_maj = "计算机应用技术"

二、	报名表（张明成、沈朝群建表）
 
插入数据
INSERT INTO stu_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-31 12:00:00');
删：
DELETE  FROM stu_sign
WHERE stu_id=48;
	改：
UPDATE stu_sign SET  stu_name="张明成",stu_age=63 WHERE stu_id=5;
	查询报名表中第一志愿为计算机系的人

	SELECT * FROM stu_sign
	where stu_firstvolunteer in (
	SELECT major_name 
	from major 
	WHERE major_department="计算机系"
	)

	查询报名表中第一志愿为计算机系的人数
	SELECT count(stu_name)总人数 FROM stu_sign
	where stu_firstvolunteer in (
	SELECT major_name 
	from major 
	WHERE major_department="计算机系"
)
查询住址是辽宁省的人
SELECT  * FROM stu_sign
WHERE stu_address LIKE "辽宁%"
五、录取表
	
#插入数字媒体应用技术第一志愿
INSERT INTO stu_matriculate(stu_id,stu_name,stu_age,stu_professln,stu_graduateschool,achievement,stu_address,stu_telephone)
SELECT stu_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
FROM stu_achievement,plan,stu_sign
WHERE stu_achievement.stu_id=stu_sign.stu_id AND stu_sign.stu_firstvolunteer = plan.plan_maj AND plan_maj="数字媒体应用技术" 
AND achievement >= plan_fractional AND stu_sign.stu_age<=25
ORDER BY achievement DESC
LIMIT 0, 4
	
#插入数字媒体应用技术第二自愿
INSERT INTO stu_matriculate(stu_id,stu_name,stu_age,stu_professln,stu_graduateschool,achievement,stu_address,stu_telephone,volunteer)
SELECT stu_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"
FROM stu_achievement,plan,stu_sign
WHERE stu_achievement.stu_id=stu_sign.stu_id AND stu_sign.stu_nextvolunteer = plan.plan_maj AND plan_maj="电子商务" 
AND achievement >= plan_fractional AND stu_sign.stu_age<=25
ORDER BY achievement DESC
LIMIT 1, 1
#插入一条姓名叫赵四的信息
INSERT INTO stu_matriculate(stu_id,stu_name,stu_age,stu_professln,stu_graduateschool,achievement,stu_address,stu_telephone) VALUES(46,"赵四",21,"软件技术","第二高中",299,"辽宁鞍山市",15512365498)
#修改赵四的姓名为赵五
UPDATE stu_matriculate set stu_name = "赵五" WHERE stu_id = 46
#删除赵五的信息
DELETE FROM stu_matriculate WHERE stu_name = "赵五"
#查找数字媒体应用技术过分数线的学生信息
SELECT stu_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
FROM stu_achievement,plan,stu_sign
WHERE stu_achievement.stu_id=stu_sign.stu_id AND stu_sign.stu_firstvolunteer = plan.plan_maj AND plan_maj="数字媒体应用技术" 
AND achievement >= plan_fractional
ORDER BY achievement DESC

JAVA：

继承关键字extends

子类访问父类的成员形式：

1、子类的成员是直接从父类继承过来的：

（1）访问当前对象的数据成员：this.数据成员

（2）调用当前对象的成员方法：this.成员方法（参数）

2、子类对从父类继承过来的成员属性重新加载定义，称为属性隐藏。

     子类对从父类继承过来的成员方法重新加载定义，称为方法的重写（覆盖）：

（1）访问直接父类中被隐藏的数据成员：super.数据成员

（2）调用直接父类中被覆盖的成员方法：super.成员方法（参数）