pzb_sql.txt

我实习时候的设计

--通过scid显示当前教师的所有课程及对应学生的信息
SELECT sc.scid,c.courseid,c.coursename,s.studentid,s.name,sc.score FROM teacher t,course c,sc sc,student s WHERE t.teachername=c.teachername AND c.courseid=sc.courseid AND sc.studentid=s.studentid AND t.teacherid=?;

--通过scid显示当前教师的所有课程及对应学生的信息
SELECT sc.scid,c.courseid,c.coursename,s.studentid,s.name,sc.score FROM course c,sc sc,student s WHERE sc.courseid=c.courseid AND  sc.studentid=s.studentid AND sc.scid=?;

--根据scid修改score
UPDATE sc SET score=? where scid=?;