学生成绩管理系统项目实报告.doc

实训课项目实训手册 开课学院：计算机信息学院专业：软件技术组号：01姓名：学号：1031005117实训指导教师： *呼和浩特职业学院 2012年 6 月11日6 月15 日实训任务书项目名称学生成绩管理系统实训场地7机房组名及人员名单（每组4-5人）设备及实训耗材电脑一实训条件：开发电脑若干台：安装Java WEB开发环境SVN服务器1台：以方便团队合作开发。 局域网络环境。二实训说明： 开发项目的具体名称，分组后由学生自主提出。经指导教师审核通过后，并立项开发。三实训目的： 整个项目开发过程，完全以企业开发模式进行。通过本次项目实训，培养学生的团队合作和解决问题的思路，提高学生的项目开发能力。为就业打好基础。四实训任务要求（具体说明并附采分点）1、确定需求、编写文档（4课时）10分2、框架设计、编写文档（4课时）20分3、详细设计、编写文档（4课时）15分4、代码编写（8课时） 45分5、测试（4课时） 10分6、项目答辩（4课时）学生成绩管理系统实训报告一实训步骤（根据实训任务要求编写）3.详细设计在整个学生成绩管理系统中我主要负责课程维护的模块，详细设计如下：数据库表设计如下：4、课程表Course中文名称字段名类型长度空/非空约束课程号C_No自动编号Not null主键课程编号C_Id文本10Not null课程名称C_Name文本10Not null功能模块设计如下：课程维护课程删除课程查询课程添加课程修改4.课程维护模块代码：视图（View）代码：SelectCourse.jsp base href= 课程查询页面 !- 课程名称：课程编号：课程ID课程编号课程名称备注%response.setContentType(text/html;charset=UTF-8);request.setCharacterEncoding(UTF-8);String sqlStr=SELECT * FROM Course WHERE C_Id;String C_Name=request.getParameter(C_Name);String C_No=request.getParameter(C_No);if(!(C_Name = null)if(!C_Name.equals() sqlStr += and C_Name like %+C_Name+%; if(!(C_No = null) if (!C_No.equals() sqlStr += and C_No like %+C_No+%;EmpLogic empLogic=new EmpLogic();/out.println(sqlStr);EmpEntity empEntities= empLogic.select(sqlStr);/out.println(sqlStr);for (int i=0;i JavaBean代码：EmpEntity.JAVApackage hhvc.cic.Model;public class EmpEntity private String C_Id,C_No,C_Name,C_Other;public String getC_Id() return C_Id;public void setC_Id(String C_Id) this.C_Id = C_Id;public String getC_No() return C_No;public void setC_No(String C_No) this.C_No = C_No;public String getC_Name() return C_Name;public void setC_Name(String C_Name) this.C_Name = C_Name;public String getC_Other() return C_Other;public void setC_Other(String C_Other) this.C_Other = C_Other;EmpLogic.JAVApackage hhvc.cic.Model;import java.util.List;import java.util.Map;import hhvc.cic.Common.TableSelect;public class EmpLogic /* * param args */public static void main(String args) /主要用语测试/ TODO Auto-generated method stub String sqlStr=SELECT * FROM Course; EmpLogic empLogic=new EmpLogic(); empLogic.select(sqlStr);/* * * param sqlString * return */public int exec(String sqlString) int index=0;return index;public EmpEntity select(String sqlStr)TableSelect tableSelect=new TableSelect();List l=tableSelect.selectRS(sqlStr);/创建实体数组EmpEntity empEntities=new EmpEntityl.size();System.out.println(l.size();/list转换成实体类EmpEntity empEntity=null;String C_Id,C_No,C_Name,C_Other;for(int i=0;il.size();i+)C_Id=String.valueOf(Map) l.get(i).get(C_Id);C_No=String.valueOf(Map) l.get(i).get(C_No);C_Name=String.valueOf(Map) l.get(i).get(C_Name);C_Other=String.valueOf(Map) l.get(i).get(C_Other);System.out.println(C_Name);empEntity =new EmpEntity();empEntity.setC_Id(C_Id);empEntity.setC_No(C_No);empEntity.setC_Name(C_Name);empEntity.setC_Other(C_Other);empEntitiesi=empEntity;/把每个实体加到实体数组中return empEntities;StuEntity.JAVApackage hhvc.cic.Model;public class StuEntity String C_Name,C_No,C_Other,C_Id;public String getC_Id() return C_Id;public void setC_Id(String cId) C_Id = cId;public String getC_Name() return C_Name;public void setC_Name(String C_Name) this.C_Name = C_Name;public String getC_No() return C_No;public void setC_No(String C_No) this.C_No = C_No;public String getC_Other() return C_Other;public void setC_Other(String C_Other) this.C_Other = C_Other;StuLogic.JAVApackage hhvc.cic.Model;import java.util.List;import java.util.Map;import hhvc.cic.Model.StuEntity;import hhvc.cic.Model.StuLogic;import hhvc.cic.Common.TableModify;import hhvc.cic.Common.TableSelect;public class StuLogic public static void main(String args) StuLogic stuLogic = new StuLogic();StuEntity arrStuEntities=stuLogic.select(select * from Course);for (int i = 0; i arrStuEntities.length; i+) System.out.print(arrStuEntitiesi.getC_Name()+t);System.out.println(arrStuEntitiesi.getC_Other();/* * 查询全部数据 * param sqlStr * return */public StuEntity select(String sqlStr)StuEntity arrStuEntity=null;List rsList = null;TableSelect tableSelect = new TableSelect();rsList=tableSelect.selectRS(sqlStr);/System.out.println(大小：+rsList.size();String C_Id,C_Name,C_No,C_Other;arrStuEntity = new StuEntityrsList.size();for (int i = 0; i rsList.size(); i+) C_Id=String.valueOf(Map) rsList.get(i).get(C_Id);C_Name=String.valueOf(Map) rsList.get(i).get(C_Name);C_No=String.valueOf(Map) rsList.get(i).get(C_No);C_Other=String.valueOf(Map) rsList.get(i).get(C_Other);/System.out.println(C_Id+C_Name+C_No+C_Other);StuEntity stuEntity = new StuEntity();stuEntity.setC_Id(C_Id);stuEntity.setC_Name(C_Name);stuEntity.setC_No(C_No);stuEntity.setC_Other(C_Other);arrStuEntityi=stuEntity;/System.out.println(arrStuEntityi.C_Name);return arrStuEntity;/* * 接收LIST 返回 HTML 表格 * return */public String htmlTable(String sqlStr)List rsList=new TableSelect().selectRS(sqlStr); String tableString=;tableString+=;for (int i = 0; i rsList.size(); i+) tableString+=;tableString+=;tableString+=String.valueOf(Map) rsList.get(i).get(C_Name);tableString+=;tableString+=;tableString+=;return tableString;/* * 学生信息添加 * param stuEntity * return int 添加的记录数 */public int insert(StuEntity stuEntity) int index=0;String strSql=null;TableModify tableModify = new TableModify();strSql=INSERT INTO Course (C_Id,C_Name,C_No,C_Other) values (+stuEntity.getC_Id()+,+stuEntity.getC_Name()+,+stuEntity.getC_No()+,+stuEntity.getC_Other()+);System.out.print(strSql);index=tableModify.exec(strSql);return index;/* * 删除记录 * param sqlStr * return int */public int del(String sqlStr) /事务处理int index=0;TableModify tableModify = new TableModify();index=tableModify.exec(sqlStr);return index;/* * 修改 * param sqlStr * return */public int update(String sqlStr) /事务处理int index=0;TableModify tableModify = new TableModify();index=tableModify.exec(sqlStr);return index;Servlet类代码如下：CtrollenScoreServlet.JAVApackage hhvc.cic.Servlet;import hhvc.cic.Model.ScoreEntity;import hhvc.cic.Model.ScoreLogin;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;public class CtrollenScoreServlet extends HttpServlet /* * Constructor of the object. */public CtrollenScoreServlet() super();/* * Destruction of the servlet. */public void destroy() super.destroy(); / Just puts destroy string in log/ Put your code here/* * The doGet method of the servlet. * * This method is called when a form has its tag value method equals to get. * * param request the request send by the client to the server * param response the response send by the server to the client * throws ServletException if an error occurred * throws IOException if an error occurred */public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException response.setContentType(text/html;charset=UTF-8);request.setCharacterEncoding(UTF-8);PrintWriter out = response.getWriter();String flag=request.getParameter(flag);/String flag=request.getParameterValues(flag); if (flag.equals(selectScoreInfo) String sqlStr=select Stu_Id,Stu_Name,C_Name,S_Score from Score,Student,Course where Score.Stu_No=Student.Stu_No and Score.C_No=Course.C_No;String key1=request.getParameter(Stu_Name).trim();String key2=request.getParameter(C_Name).trim();/自己扩展 多条件组合查询if (!key1.equals() sqlStr+= and Stu_Name like %+key1+%;else if (!key2.equals(C_Name) sqlStr+= and C_Name like %+key2+%;out.print(flag);ScoreLogin ScoreLogin = new ScoreLogin();out.println(ScoreLogin.htmlTable(sqlStr);/System.out.println(ScoreLogin.table();else if (flag.equals(insScoreInfo) /获取表单传入的数据封装到实体类String S_Id = request.getParameter(S_Id);String Stu_No = request.getParameter(Stu_No);String C_No = request.getParameter(C_No);String S_Score = request.getParameter(S_Score);ScoreEntity scoreEntity = new ScoreEntity();scoreEntity.setS_Id(S_Id);scoreEntity.setStu_No(Stu_No);scoreEntity.setC_No(C_No);scoreEntity.setS_Score(Float.valueOf(S_Score);int i=0;i=new ScoreLogin().insert(scoreEntity);if (i0) out.println();out.println();out.println(window.location.href=./Luruchengji.jsp;);out.println();else out.println();out.println();out.println(window.location.href=./Luruchengji.jsp;);out.println();/删除else if(flag.equals(deleteScoreInfo)int index=1;String S_Id=request.getParameter(S_Id);String sqlStr=delete from Score where S_Id=+S_Id;index= new ScoreLogin().del(sqlStr);if (index=0) out.println();out.println();out.println(window.location.href=./update.jsp;);out.println();elseout.println();out.println();out.println(window.location.href=./update.jsp;);out.println();else if(flag.equals(updateScoreInfo)int index=0;String S_Id=request.getParameter(S_Id);String Stu_Id=request.getParameter(Stu_Id);String Stu_Name=request.getParameter(Stu_Name);String S_Score=request.getParameter(S_Score);String C_Name=request.getParameter(C_Name);String sqlStr=update Score set S_Score=+S_Score+ where S_Id=+S_Id;index= new ScoreLogin().update(sqlStr);if (index=0) out.println();out.println();out.println(window.location.href=./update.jsp;);out.println();elseout.println();out.println();out.println(window.location.href=./update.jsp;);out.println(); elseout.print(no flag); out.flush();out.close();public