java课程设计报告

信息工程学院《面向对象程序设计语言》课程设计报告题目基于java平台的学生成绩管理系统设计与实现专业班级姓名学号年月日湖北中医药大学目录一、课程设计的任务和要求 (3)二、需求分析 (3)三、设计思路 (3)四、设计 (4)五、与运行结果说明..................................................................................... 错误！未定义书签。

六、体会与小结 (10)七、文献 (10)八、（所有源代码） (11)一、课程设计的任务和要求使用Jsp+Bean+Servlet架构，设计一个简单的学生成绩管理系统。

数据包含学生基本信息、课程信息。

能实现学生信息和课程信息的查询、插入、修改和删除。

开发工具：jdk+tomcat+MySql通过本次课程设计掌握Java平台的基本开发模式。

二、需求分析（描述系统要实现哪些功能）具体功能系统框图：三、设计思路（阐述数据库的设计和功能如何实现）系统分为学生需求，老师需求，管理员需求三个模块，这三个模块的功能分别要满足以下需求：1、学生需求(1) 在第一时间查询自己所有的成绩(3)查询自己的上课信息及选课信息(4)修改登录密码2、老师的需求(1) 查询某一学生的所有成绩(2) 查询某一学生某一科成绩,该科平均成绩，所在名次，最高成绩，最低成绩(3) 查询某一班级的成绩(4) 录入自己所教授的那一科成绩(5) 修改登录密码3、管理员的需求(1) 查询某一学生的所有成绩(2) 查询某一学生某一科成绩,该科平均成绩，所在名次，最高成绩，最低成绩(3) 查询某一班级的成绩(5) 录入成绩和修改成绩(6) 对学生和老师信息进行管理和查询(7) 数据库管理根据上述需求建立数据库及功能界面，建立数据库和界面间以及界面和界面间的连接，逐一实现各功能需求。

四、详细设计（有哪些页面组成，每个页面有哪些组件构成，实现功能的组件所需的主要数据结构）课程信息表：成绩表：学生信息表：管理员信息表：老师信息表：五、调试与运行结果说明（阐述tomcat、mysql的配置，项目文件在tomcat中的位置，将运行界面制成图片粘贴在此部分）（1）登录：（2）、查看课程信息：（3）、修改学生信息（4）插入学生成绩（5）添加课程信息管理：连接数据库的类设计如下：package DateBase;import java.sql.Connection; import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class DbUtile {public Connection connection = null;public ResultSet resultSet = null;public Statement statement = null;private String Db_Driver = "com.mysql.jdbc.Driver";private String Db_url = "jdbc:mysql://localhost:3306/studentmanagesystem";private String Db_user = "root";private String Db_password = "sa";public DbUtile() { //构造方法连接数据库try{Class.forName(Db_Driver);connection =DriverManager.getConnection(Db_url,Db_user,Db_password);statement = connection.createStatement( );}catch(ng.ClassNotFoundException e) {System.out.println("加载驱动器有错误:" + e.getMessage( ));}catch(SQLException e) {System.out.println("连接数据库有错误:" + e.getMessage( ));}}public int executeInsert(String sql) { //插入记录int num = 0;System.out.println(sql);try {num = statement.executeUpdate(sql);}catch(SQLException ex) {System.out.println("执行插入有错误:" + ex.getMessage() );}return num;}public ResultSet executeQuery(String sql) { // 查询记录resultSet = null;try{resultSet = statement.executeQuery(sql);}catch(SQLException ex) {System.out.println("执行查询有错误:" + ex.getMessage() );}return resultSet;}public int executeDelete(String sql) { //删除记录int num = 0;try{num = statement.executeUpdate(sql);}catch(SQLException ex){System.out.println("执行删除有错误:" + ex.getMessage() );}return num;}public int executeUpdate(String sql) { //修改记录int num = 0;try {num=statement.executeUpdate(sql);}catch(SQLException ex) {System.out.println("执行修改有错误:" + ex.getMessage() );}return num;}public void close() { //关闭Connection对象try {if (resultSet != null)resultSet.close();statement.close();connection.close();}catch(Exception end) {System.out.println("执行关闭Connection对象有错误：" + end.getMessage( ) );}}}六、体会与小结在此次课程设计中，我深刻的感受到了基础知识的重要性，记得在写一些简单的代码的时候，感觉脑子里竟然空空白白的，在程序开发过程中，最重要的还是基础知识，如果基础知识不牢固的话，以后开发大型的系统的时候会感觉很吃力，所以，一定要注重基础知识的学习。

在此次的课程设计中，我学到很多在书本上学不到的东西，此次课程设计教给了我以后开发的一些步骤和经验，这些必将会使我受益良多。

但由于能力有限，实验中有部分功能未能实现，能力还需进一步加强。

七、参考文献参考书目：［1］张银鹤，刘治国.JSP动态网站开发实践教程[M].北京：清华大学出版社，2007. ［2］李保敏.动态网站设计与开发实用教程[M].北京：清华大学出版社，2012.［3］叶核亚.JA V A程序设计实用教程[M].北京：电子工业出版社，2010.八、（源代码）（1）、LoginServlet 登录控制package servlet;import java.io.IOException;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import DAO.ManageDAO;import DAOImpl.ManageDAOImpl;import Date.Manage;public class LoginServlet extends HttpServlet {public LoginServlet() {super();}public void destroy() {super.destroy(); // Just puts "destroy" string in log// Put your code here}public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {request.setCharacterEncoding("utf-8") ;response.setContentType("text/html");int n = Integer.parseInt(request.getParameter("n"));String id = request.getParameter("id");String password = request.getParameter("password");boolean b = false;if(n == 1){StudentDAO sd = new StudentDAOImpl();b = sd.login(id, password);if(b){HttpSession session = request.getSession();session.setAttribute("id", id);session.setAttribute("identity", "1");Student stu = sd.queryByID(id);session.setAttribute("stu", stu);response.sendRedirect("main.html");}elseresponse.sendRedirect("error.jsp");}else if(n == 2){TeacherDAO td = new TeacherDAOImpl();b = td.login(id, password);if(b){HttpSession session = request.getSession();session.setAttribute("identity", "2");session.setAttribute("id", id);Teacher tea = td.queryByID(id);session.setAttribute("tea", tea);response.sendRedirect("tea_main.html");}elseresponse.sendRedirect("error.jsp");}else{ManageDAO td = new ManageDAOImpl();b = td.login(id, password);if(b){HttpSession session = request.getSession();session.setAttribute("identity", "3");session.setAttribute("id", id);Manage man = td.queryByID(id);session.setAttribute("man", man);response.sendRedirect("man_main.html");}elseresponse.sendRedirect("error.jsp");}}public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doGet(request, response);}public void init() throws ServletException {// Put your code here}}（1）、InsertServlet 插入package servlet;import java.io.IOException;import java.io.PrintWriter;import java.util.Vector;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import DAO.TeacherDAO;import DAOImpl.TeacherDAOImpl;public class InputServlet extends HttpServlet {public InputServlet() {super();}public void destroy() {super.destroy(); // Just puts "destroy" string in log// Put your code here}public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {request.setCharacterEncoding("utf-8") ;response.setContentType("text/html");HttpSession session = request.getSession();String courseid = request.getParameter("courseid");String id = (String)session.getAttribute("id");int n = Integer.parseInt((String)session.getAttribute("len"));String grade1;String grade2;String grade;TeacherDAO td = new TeacherDAOImpl();for(int i = 0;i < n;i++){grade1 = request.getParameter("grade1"+(i+1));grade2 = request.getParameter("grade2"+(i+1));grade = request.getParameter("grade3"+(i+1));String stuid = request.getParameter("stuid"+(i+1));td.inputGrade(grade1, grade2, courseid, stuid, grade);}td.ranking(courseid, id);td.changeFinish(id, courseid);this.getServletConfig().getServletContext().getRequestDispatcher("/input_succes s.html").forward(request,response);}public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doGet(request, response);}public void init() throws ServletException {// Put your code here}}（2）、DeleteServlet 删除package servlet;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import DAO.ManageDAO;import DAO.StudentDAO;import DAO.TeacherDAO;import DAOImpl.ManageDAOImpl;import DAOImpl.StudentDAOImpl;import DAOImpl.TeacherDAOImpl;import Date.Student;import Date.Teacher;public class DelectServlet extends HttpServlet {private static final long serialVersionUID = 1L;public DelectServlet() {super();}public void destroy() {super.destroy(); // Just puts "destroy" string in log// Put your code here}public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doPost(request, response);}public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {request.setCharacterEncoding("utf-8") ;response.setContentType("text/html");String parameter = request.getParameter("parameter");if(parameter.equals("1")){String stuid = request.getParameter("stuid");StudentDAO sd = new StudentDAOImpl();Student student = sd.queryByID(stuid);if(student != null){request.setAttribute("parame","1");request.setAttribute("student", student);this.getServletConfig().getServletContext().getRequestDispatcher("/YNDelect.jsp ").forward(request,response);}else{request.setAttribute("parame","1");request.setAttribute("str","sheckStu.jsp");this.getServletConfig().getServletContext().getRequestDispatcher("/noPerson.jsp ").forward(request,response);}}else if(parameter.equals("2")){String stuid = request.getParameter("stuid");ManageDAO md= new ManageDAOImpl();md.delectStu(stuid);response.sendRedirect("operate_success.html");}else if(parameter.equals("3")){String teaid = request.getParameter("teaid");TeacherDAO td = new TeacherDAOImpl();Teacher teacher = td.queryByID(teaid);if(teacher != null){request.setAttribute("parame","2");request.setAttribute("teacher", teacher);this.getServletConfig().getServletContext().getRequestDispatcher("/YNDelect.jsp ").forward(request,response);}else{request.setAttribute("parame","2");request.setAttribute("str","sheckTea.jsp");this.getServletConfig().getServletContext().getRequestDispatcher("/noPerson.jsp ").forward(request,response);}}else{String teaid = request.getParameter("teaid");ManageDAO md= new ManageDAOImpl();md.delectTea(teaid);response.sendRedirect("operate_success.html");}}public void init() throws ServletException {// Put your code here}}（3）、QueryCourseServlet 查询package servlet;import java.io.IOException;import java.io.PrintWriter;import java.util.Iterator;import java.util.Vector;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import DAO.StudentDAO;import DAOImpl.StudentDAOImpl;import Date.Course;import Date.Score;import Date.Student;public class QueryCourseServlet extends HttpServlet {public QueryCourseServlet() {super();}public void destroy() {super.destroy(); // Just puts "destroy" string in log// Put your code here}public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doPost(request, response);}public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {request.setCharacterEncoding("utf-8") ;response.setContentType("text/html");HttpSession session = request.getSession();String id;String h = request.getParameter("n");String s = request.getParameter("s");if(s.equals("1")){id = (String)session.getAttribute("id");}else{id = request.getParameter("stuid");}StudentDAO sd = new StudentDAOImpl();Vector all = new Vector();all = sd.getCourse_all(id);if(h.equals("1")){request.setAttribute("vector",all);this.getServletConfig().getServletContext().getRequestDispatcher("/list_course.js p").forward(request,response);}else if(h.equals("2")){Iterator iter = all.iterator();Vector vec = new Vector();while(iter.hasNext()){Course course = (Course) iter.next();Score sco = new Score();sco.setId(course.getId());sco.setName(course.getName());String str[] = sd.getScore(id, course.getId());sco.setGrate1(str[0]);sco.setGrate2(str[1]);sco.setGrate(str[2]);sco.setCredit(str[3]);sco.setRanking(str[4]);vec.add(sco);}request.setAttribute("vector",vec);this.getServletConfig().getServletContext().getRequestDispatcher("/list_score.jsp ").forward(request,response);}else{request.setAttribute("vector",sd.getUnpass(id));this.getServletConfig().getServletContext().getRequestDispatcher("/list_unpass.js p").forward(request,response);}}public void init() throws ServletException {// Put your code here}}。