学生在线选课系统包括教师和学生模块

create procedure selstu @sid varchar(50) as select * from student where sid=@sid create proc selchcour as select course.crname,course.crid,teacher.tname,course.crcre,course.crper from course,teacher,tc where tc.crid=course.crid and tc.tid=teacher.tid create proc seltcid @t_c_id varchar(50) as select * from tc where tcid=@t_c_id create proc addcourse (@crid varchar(50), @crname varchar(50), @crper int, @crcre int, @crkind varchar(50), @crelse varchar(50) ) as insert into course(crid,crname,crper,crcre,crkind,crelse) values(@crid,@crname,@crper,@crcre,@crkind,@crelse)