学生信息管理系统.docx

1、学生信息管理系统学生成绩管理系统组员： 工作分配：系统管理员对学生的管理、教师管理课程管理成绩处理、以最后的审查工作。：学生的课程选择、信息查询、密码修改、登陆、退出的工作。：对教师界面的开设课程、成绩提交，首页、我要留言的工作。：系统的文档，系统的头和尾界面的工作。：系统的美化。1.系统的主要功能系统登录，学生和教师信息的添加、修改和删除，学生留言，教师开课，学生选课，课表的显示，等功能。系统功能模块图如下：1.1、管理员登录功能模块1.2、教师登录功能模块图1.3、学生登录功能模块图2.系统的结构及部分代码说明结构图如下：其中msc.dao包是对向数据库里面添加、修改删除等操作；Msc.d

2、bc包是连接数据库的；Msc.slt包对登录、添加、删除、修改等的验证；Msc.util包对编码的过滤和设置；Msc.vo包是一些需要的javabean代码；Webroot是页面的实现代码；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.ServletExce

3、ption;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;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()

4、 super.destroy(); public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException response.setContentType(text/html); request.setCharacterEncoding(utf-8); response.setCharacterEncoding(utf-8); PrintWriter out = response.getWriter(); String id=request

5、.getParameter(id); String password=request.getParameter(password); String kind=request.getParameter(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();

6、 session.setAttribute(na,user.getName(); session.setAttribute(pa,user.getCode(); session.setAttribute(kind,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 i

7、f(kind.equals(student) if(password.equals(user.getCode() response.sendRedirect(student_frame.jsp); else response.setHeader(refresh,2;URL=login.jsp) ; out.print(密码错误！请重新登录.); else if(kind.equals(teacher) if(password.equals(user.getCode() response.sendRedirect(teacher_frame.jsp); else response.setHead

8、er(refresh,2;URL=login.jsp) ; out.print(密码错误！请重新登录.); catch (Exception e) response.setHeader(refresh,2;URL=login.jsp) ; out.print(用户); out.print(id); out.print(不存在！请重新登录.); out.flush(); out.close(); 验证成功跳转到admin_frame.jsp页面，可以进行对学生、教师、课程的管理等的操作。验证成功后进入的界面点击学生管理进入的页面这个界面可以对学生的添加，修改，删除查看留言等操作。点击相应的操作进

9、入相应的界面，进入学生管理加载admin_stu.jsp,进入教师管理加载admin_tea.jsp，进入课程管理加载admin_cou.jsp,在这里我们有学生管理页面进行说明，其他不在一一说明，它们是类似的代码。点击学生管理界面的添加、删除、修改等功能用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.R

10、equestDispatcher;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import msc.dao.*;import msc.vo.Student;public class student_slt extends HttpServlet public void doPost(HttpServletRe

11、quest request, HttpServletResponse 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); if(

12、delete.equalsIgnoreCase(action) doDelete(request,response); if(update.equalsIgnoreCase(action) doUpdate(request,response); public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException doPost(request,response); public void doAdd(HttpServletRequest r

13、equest, 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=request.getParameter(sn

14、ame); String smajor=request.getParameter(smajor); String sclass=request.getParameter(sclass); String scode=request.getParameter(scode); StudentDAO sdao=new StudentDAO(); UserDAO udao=new UserDAO(); try sdao.InsertStudent(sid, sname, smajor, sclass, scode); udao.InsertUser(sid, sname, scode, student)

15、; out.println(); out.println( A Servlet); out.println( ); out.print( 添加成功！ ); out.println( ); out.println(); catch (Exception e) /System.out.println(e.toString(); out.println(); out.println( A Servlet); out.println( ); out.print( 添加失败！ ); out.println( ); out.println(); out.flush(); out.close(); publ

16、ic void doDelete(HttpServletRequest 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);

17、 StudentDAO sdao=new StudentDAO(); UserDAO udao=new UserDAO(); try sdao.DeletebyID(sid); udao.DeletebyID(sid); out.println(); out.println(); out.println( A Servlet); out.println( ); out.print( 删除成功！ ); out.println( ); out.println(); catch (Exception e) / TODO Auto-generated catch block out.println()

18、; out.println(); out.println( A Servlet); out.println( ); out.print( 删除失败！ ); out.println( ); out.println(); out.flush(); out.close(); public void doUpdate(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException response.setContentType(text/html); request.setCh

19、aracterEncoding(utf-8); response.setCharacterEncoding(utf-8); PrintWriter out = response.getWriter(); String sid=request.getParameter(sid); String sname=request.getParameter(sname); String sclass=request.getParameter(sclass); String smajor=request.getParameter(smajor); String scode=request.getParame

20、ter(scode); UserDAO udao=new UserDAO(); StudentDAO sdao=new StudentDAO(); try sdao.UpdatebyID(sid, sname, smajor, sclass, scode); udao.UpdatebyID(sid, sname, scode, student); out.println(); out.println( A Servlet); out.println( ); out.print( 修改成功！ ); out.println( ); out.println(); catch (Exception e

21、) / TODO Auto-generated catch block out.println(); out.println( A Servlet); out.println( ); out.print( 修改失败！ ); out.println( ); out.println(); out.flush(); out.close(); 其中实现的数据库操作StudentDAO.java代码如下：package msc.dao;import java.sql.*;import java.util.Vector;import msc.vo.*;import msc.dbc.DataBaseConn

22、ection;public class StudentDAO public void InsertStudent(String sid,String sname,String smajor,String sclass,String scode) throws Exception String sql=INSERT INTO student(sid,sname,smajor,sclass,scode) VALUES(+sid+,+sname+,+smajor+,+sclass+,+scode+); Statement stmt=null; DataBaseConnection dbc=null;

23、 dbc=new DataBaseConnection(); try stmt=dbc.getConnection().createStatement(); stmt.executeUpdate(sql); stmt.close(); catch (Exception e) System.out.println(e.toString(); throw new Exception(插入中出现错误！); finally dbc.close(); public void DeletebyID(String sid) throws Exception String sql=DELETE FROM st

24、udent WHERE sid=+sid+; Statement stmt=null; DataBaseConnection dbc=null; dbc=new DataBaseConnection(); try stmt=dbc.getConnection().createStatement(); stmt.executeUpdate(sql); stmt.close(); catch (Exception e) throw new Exception(删除中出现错误！); finally dbc.close(); public Vector Select(String sid,String

25、 sclass,String smajor)throws Exception Vector 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 LIKE %+sclass+%; if(smajor!=) sql=sql+ and smajor LIKE %+smajor+%; else if(sclass!=) sql=sql1+ sclass LIKE %+sclass+%; if(smajor!=)