学生信息管理系统

1、学生成绩管理系统组员： 工作分配：系统管理员对学生的管理、教师管理课程管理成绩处理、以最后的审查工作。：学生的课程选择、信息查询、密码修改、登陆、退出的工作。：对教师界面的开设课程、成绩提交，首页、我要留言的工作。：系统的文档，系统的头和尾界面的工作。：系统的美化。1.系统的主要功能系统登录，学生和教师信息的添加、修改和删除，学生留言，教师开课，学生选课，课表的显示，等功能。系统功能模块图如下：学生信息管理系统管理员登录学生登录教师登录1.1、管理员登录功能模块管理员登录学生管理添加学生信息删除学生信息查询学生信息修改学生信息查看学生留言教师管理添加教师信息删除教师信息修改教师信息查询教师信息

2、教师管理添加课程信息删除课程信息修改课程信息查询课程信息1.2、教师登录功能模块图成绩提交信息查询修改密码教师管理开设课程课程查询提交课程删除课程以开设课程未提交课程已提交课程个人信息他人信息1.3、学生登录功能模块图课程选择课程查询提交课程删除课程课表显示成绩查询他人成绩留言查看留言学生登录信息查询密码修改我要留言2.系统的结构及部分代码说明结构图如下：其中msc.dao包是对向数据库里面添加、修改删除等操作；msc.dbc包是连接数据库的；msc.slt包对登录、添加、删除、修改等的验证；msc.util包对编码的过滤和设置；msc.vo包是一些需要的javabean代码；webroot是

3、页面的实现代码；3.界面部分实现代码及验证系统登录界面如果是管理员登录跳登录验证login_conf验证其中验证代码如下：package msc.slt;import java.io.ioexception;import java.io.printwriter;import java.text.dateformat;import java.util.date;import javax.servlet.servletexception;import javax.servlet.http.httpservlet;import javax.servlet.http.httpservletreques

4、t;import javax.servlet.http.httpservletresponse;import javax.servlet.http.httpsession;import msc.vo.*;import msc.dao.*;public class login_conf extends httpservlet public login_conf() super();public void destroy() super.destroy();public void dopost(httpservletrequest request, httpservletresponse resp

5、onse)throws servletexception, ioexception response.setcontenttype(text/html);request.setcharacterencoding(utf-8);response.setcharacterencoding(utf-8);printwriter out = response.getwriter();string id=request.getparameter(id);string password=request.getparameter(password);string kind=request.getparame

6、ter(kind);userdao udao=new userdao();user user=null;try user=udao.check(id,kind);if(user.getid().equals(id)httpsession session;session=request.getsession(true); session.setattribute(id,user.getid();session.setattribute(na,user.getname();session.setattribute(pa,user.getcode();session.setattribute(kin

7、d,user.getkind();if(kind.equals(admin)if(password.equals(user.getcode()response.sendredirect(admin_frame.jsp);else response.setheader(refresh,2;url=login.jsp) ; out.print(密码错误！请重新登录.);else if(kind.equals(student)if(password.equals(user.getcode()response.sendredirect(student_frame.jsp);elseresponse.s

8、etheader(refresh,2;url=login.jsp) ;out.print(密码错误！请重新登录.);else if(kind.equals(teacher)if(password.equals(user.getcode()response.sendredirect(teacher_frame.jsp);elseresponse.setheader(refresh,2;url=login.jsp) ;out.print(密码错误！请重新登录.); catch (exception e) response.setheader(refresh,2;url=login.jsp) ;ou

9、t.print(用户); out.print(id);out.print(不存在！请重新登录.);out.flush();out.close();验证成功跳转到admin_frame.jsp页面，可以进行对学生、教师、课程的管理等的操作。验证成功后进入的界面点击学生管理进入的页面这个界面可以对学生的添加，修改，删除查看留言等操作。点击相应的操作进入相应的界面，进入学生管理加载admin_stu.jsp,进入教师管理加载admin_tea.jsp，进入课程管理加载admin_cou.jsp,在这里我们有学生管理页面进行说明，其他不在一一说明，它们是类似的代码。点击学生管理界面的添加、删除、修改等

10、功能用student_slf.java进行验证，代码如下：package msc.slt;import java.io.ioexception;import java.io.printwriter;import java.sql.sqlexception;import java.util.vector;import javax.servlet.requestdispatcher;import javax.servlet.servletexception;import javax.servlet.http.httpservlet;import javax.servlet.http.httpser

11、vletrequest;import javax.servlet.http.httpservletresponse;import msc.dao.*;import msc.vo.student;public class student_slt extends httpservlet public void dopost(httpservletrequest request, httpservletresponse response)throws servletexception, ioexception response.setcontenttype(text/html);request.se

12、tcharacterencoding(utf-8);response.setcharacterencoding(utf-8); string action = request.getparameter(action); if (new.equalsignorecase(action) doadd(request,response); if(delete.equalsignorecase(action) dodelete(request,response); if(update.equalsignorecase(action)doupdate(request,response); public

13、void doget(httpservletrequest request, httpservletresponse response) throws servletexception, ioexception dopost(request,response); public void doadd(httpservletrequest request, httpservletresponse response) throws servletexception, ioexception response.setcontenttype(text/html);request.setcharacter

14、encoding(utf-8);response.setcharacterencoding(utf-8);printwriter out = response.getwriter();string sid=request.getparameter(sid);string sname=request.getparameter(sname);string smajor=request.getparameter(smajor);string sclass=request.getparameter(sclass);string scode=request.getparameter(scode);stu

15、dentdao sdao=new studentdao();userdao udao=new userdao();try sdao.insertstudent(sid, sname, smajor, sclass, scode);udao.insertuser(sid, sname, scode, student);out.println();out.println( a servlet);out.println( );out.print( 添加成功！ );out.println( );out.println(); catch (exception e) /system.out.println

16、(e.tostring();out.println();out.println( a servlet);out.println( );out.print( 添加失败！ );out.println( );out.println();out.flush();out.close(); public void dodelete(httpservletrequest request, httpservletresponse response) throws servletexception, ioexception response.setcontenttype(text/html); request.

17、setcharacterencoding(utf-8); response.setcharacterencoding(utf-8); printwriter out = response.getwriter(); string sid=request.getparameter(sid); studentdao sdao=new studentdao(); userdao udao=new userdao(); try sdao.deletebyid(sid); udao.deletebyid(sid); out.println(); out.println(); out.println( a

18、servlet); out.println( ); out.print( 删除成功！ ); out.println( ); out.println(); catch (exception e) / todo auto-generated catch block out.println(); out.println(); out.println( a servlet); out.println( ); out.print( 删除失败！ ); out.println( ); out.println(); out.flush(); out.close();public void doupdate(h

19、ttpservletrequest request, httpservletresponse response) throws servletexception, ioexception response.setcontenttype(text/html); request.setcharacterencoding(utf-8); response.setcharacterencoding(utf-8); printwriter out = response.getwriter(); string sid=request.getparameter(sid); string sname=requ

20、est.getparameter(sname); string sclass=request.getparameter(sclass); string smajor=request.getparameter(smajor); string scode=request.getparameter(scode); userdao udao=new userdao(); studentdao sdao=new studentdao(); try sdao.updatebyid(sid, sname, smajor, sclass, scode);udao.updatebyid(sid, sname,

21、scode, student);out.println(); out.println( a servlet); out.println( ); out.print( 修改成功！ ); out.println( ); out.println(); catch (exception e) / todo auto-generated catch blockout.println(); out.println( a servlet); out.println( ); out.print( 修改失败！ ); out.println( ); out.println();out.flush();out.cl

22、ose();其中实现的数据库操作studentdao.java代码如下：package msc.dao;import java.sql.*;import java.util.vector;import msc.vo.*;import msc.dbc.databaseconnection;public class studentdao public void insertstudent(string sid,string sname,string smajor,string sclass,string scode) throws exceptionstring sql=insert into s

23、tudent(sid,sname,smajor,sclass,scode) values(+sid+,+sname+,+smajor+,+sclass+,+scode+);statement stmt=null;databaseconnection dbc=null;dbc=new databaseconnection(); trystmt=dbc.getconnection().createstatement();stmt.executeupdate(sql);stmt.close();catch (exception e)system.out.println(e.tostring();th

24、row new exception(插入中出现错误！);finally dbc.close();public void deletebyid(string sid) throws exceptionstring sql=delete from student where sid=+sid+;statement stmt=null;databaseconnection dbc=null;dbc=new databaseconnection();trystmt=dbc.getconnection().createstatement();stmt.executeupdate(sql);stmt.cl

25、ose();catch (exception e)throw new exception(删除中出现错误！);finally dbc.close();public vector select(string sid,string sclass,string smajor)throws exceptionvector all=new vector();string sql1=select * from student where;string sql=null;if(sid!=)sql=sql1+ sid like %+sid+%;if(sclass!=)sql=sql+ and sclass l

26、ike %+sclass+%;if(smajor!=)sql=sql+ and smajor like %+smajor+%;elseif(sclass!=)sql=sql1+ sclass like %+sclass+%;if(smajor!=)sql=sql+ and smajor like %+smajor+%;elseif(smajor!=)sql=sql1+ smajor like %+smajor+%;elsesql=select * from student;sql=sql+ order by egrade desc;statement stmt=null;databasecon

27、nection dbc=null;dbc=new databaseconnection();trystmt = dbc.getconnection().createstatement();resultset rs = stmt.executequery(sql);while(rs.next() student stu=new student();stu.setsid(rs.getstring(sid);stu.setsname(rs.getstring(sname);stu.setsmajor(rs.getstring(smajor);stu.setsclass(rs.getstring(sc

28、lass);stu.settcredit(rs.getdouble(tcredit);stu.settcreditjd(rs.getdouble(tcreditjd);stu.setocredit(rs.getdouble(ocredit);stu.setacredit(rs.getdouble(acredit);stu.setegrade(rs.getdouble(egrade);stu.setmajorpm(rs.getint(majorpm);stu.setclasspm(rs.getint(classpm);stu.setscode(rs.getstring(scode);all.ad

29、delement(stu);rs.close();stmt.close(); catch (exception e) throw new exception(查询中出现错误！); finally dbc.close();return all;public string selectbysid(string sid) throws exceptionstring sname=null;string sql=select sname from student where sid=+sid+ ;statement stmt=null;databaseconnection dbc=null;dbc=n

30、ew databaseconnection();try stmt=dbc.getconnection().createstatement();resultset rs=stmt.executequery(sql);while(rs.next()sname=rs.getstring(sname);rs.close();stmt.close(); catch (exception e) / todo: handle exceptionthrow new exception(查询中出错！);finallydbc.close();return sname;public void updatebyid(

31、string sid,string sname,string smajor,string sclass,string scode) throws exceptionstring sql=update student set sname=+sname+,smajor=+smajor+,sclass=+sclass+,scode=+scode+ where sid=+sid+;statement stmt=null;databaseconnection dbc=null;dbc=new databaseconnection();trystmt=dbc.getconnection().creates

32、tatement();stmt.executeupdate(sql);stmt.close();catch (exception e)throw new exception(修改中出现错误！);finally dbc.close();public void changecode(string sid,string scode) throws exceptionstring sql=update student set scode=+scode+ where sid=+sid+;statement stmt=null;databaseconnection dbc=null;dbc=new dat

33、abaseconnection();trystmt=dbc.getconnection().createstatement();stmt.executeupdate(sql);stmt.close();catch (exception e)throw new exception(修改中出现错误！);finally dbc.close();教师登录的界面及功能：学生登录的界面及功能：教师登录可以进行开设课程、成绩提交、信息查询等功能。实现功能代码： 课程查询 提交课程 a href=teacher_cho_seted.jsp?tid= target=main已开设课程 删除课程 功能的验证代码：

34、package msc.slt;import java.io.ioexception;import java.io.printwriter;import javax.servlet.*；import msc.dao.scdao;import msc.dao.studentdao;import msc.dao.teacherdao;import msc.dao.userdao;public class teacher_slt extends httpservlet boolean flag;public void dopost(httpservletrequest request, httpse

35、rvletresponse response)throws servletexception, ioexception response.setcontenttype(text/html);request.setcharacterencoding(utf-8);response.setcharacterencoding(utf-8); string action = request.getparameter(action); if (new.equalsignorecase(action) doadd(request,response); flag=true; if(delete.equals

36、ignorecase(action) dodelete(request,response); flag=true; if(update.equalsignorecase(action)doupdate(request,response);flag=true; public void doget(httpservletrequest request, httpservletresponse response)throws servletexception, ioexception dopost(request,response);public void doadd(httpservletrequ

37、est request, httpservletresponse response)throws servletexception, ioexception response.setcontenttype(text/html);request.setcharacterencoding(utf-8);response.setcharacterencoding(utf-8);printwriter out = response.getwriter();string tid=request.getparameter(tid);string tname=request.getparameter(tna

38、me);string tcode=request.getparameter(tcode);teacherdao tdao=new teacherdao();userdao udao=new userdao();try tdao.insertteacher(tid, tname,tcode);udao.insertuser(tid, tname, tcode, teacher);out.println();out.println( a servlet);out.println( );out.print( 添加成功！ );out.println( );out.println(); catch (exception e) / todo auto-generated catch blockout.println();out.println( a servlet);out.println( );out.print( 添加失败！ );out.println( );out.println();o