学生成绩管理系统servlet + jsp + mvc

-------------------------------------------------------------------------------------------- 1、数据库设计部分 01、平均值的存储过程 create procedure pro_avg @stuid char(9) as begin select s.studentid , s.Sname , AVG(sc.score) as avgscore from student s ,selectcourse sc where s.studentid=sc.studentid group by s.studentid , s.Sname having s.studentid=@stuid end exec pro_avg '01'; 02、根据课程查看信息 create procedure pro_class @Cname varchar(20) as begin select s.studentid , s.Sname , c.Cname , sc.score from student s ,course c ,selectcourse sc where s.studentid=sc.studentid and c.courseid=sc.courseid and c.Cname=@Cname end exec pro_class 'Java程序设计'; （注）03、采用c3p0连接数据库上传到服务器时，需要将驱动包放置到jdk的jre里面。 Tomcat默认编码为ISO8859-1，若要修改编码，则需修改CharEncodingFilter.java里面的解码的编码。 04、数据库的分页查询 (以每页 5 条数据为例) select top 5 * from student where studentid not in (select top 5*(页数减 1 ) studentid from student order by studentid asc) order by studentid asc --------------------------------------------------------------------------------------------