实验报告管理系统报告样本

资料内容仅供您学习参考，如有不当或者侵权，请联系改正或者删除。软件项目设计报告实验报告管理系统所在班级12计卓小组成员江灵瞳印海平钱晨晨学院名称信电工程学院专业名称计算机科学与技术指导教师胡局新起止日期.12.16-.1.151月15日目录1绪论 11.1开发背景 11.2本次设计完成的工作 11.3任务分工 11.4任务 12系统分析 22.1需求分析 22.2可行性分析 22.3用例图 23系统设计与实现 43.1系统目标 43.2系统功能结构 43.3功能流程及工作流程 43.4系统流程图 53.5构建开发环境 53.7文件夹组织结构 63.8学生模块的实现 63.9老师模块的实现 19结论 351绪论1.1开发背景实验教学是学生技能培养的重要环节之一,学生实验报告的质量在一定程度上反映了实验教学的质量,实验报告管理水平也反映了实验教学管理水平。当前,大部分学校所提交的实验报告大多还停留在以纸为介质的方式上,这将严重制约着实验教学的开展。首先,很多课程的实验结果在纸质实验报告中不能表现或不能完全表现,其次纸质实验报告的批改和分析也是实验授课老师的一个很重负担,如何提高学生实验报告的表象能力,提高教师批改实验报告的效率并及时发现和纠正实验报告中存在的问题是许多课程实验授课教师所面正确一个难题。1.2本次设计完成的工作老师登录该系统能够上传、下载实验报告、查看学生做的实验报告并给学生打分、老师能够查看实验验课程、实验课程列表、查看实验提交情况等。学生登录该系统能够上传、下载实验报告、查看实验课程和实验课程列表。1.3任务分工组织结构:为了完成学生信息管理系统的项目开发,班级组成了一个项目团队,人员分工:为了明确项目团队中每个人的任务分工,现制定人员分工,如下表2.1所示:表2.1人员分工成员角色负责的模块内容A江灵瞳学生的上传,下载,学生查看实验课程,查看实验列表B印海平老师的上传,下载,和老师填写分数,数据库设计C钱晨晨老师查看实验课程,查看实验列表,查看实验上交情况,登录1.4任务我们三个人各自分工完成自己的模块内容,首先,江灵瞳构造整个系统的框架,然后印海平设计数据库,在我们一起先设计前台界面,之后我们就各自实现各自模块的功能。

2系统分析2.1需求分析1)实验课程设置,设置课程编号、课程名、时间、次数、老师编号、老师名、实验班级;2)实验列表设置,设置实验编号、实验名、班级、学生学号、学生名、老师名、实验路径、提交状态、分数;3)树型类别设置,设置编号、名字、路径、学生名、老师名、树的状态。2.2可行性分析2.2.1引言编写目的:背景:徐州工程学院是一所培养应用型人才的普通高等学院。为了完善管理学校实验报告太多没有地方保存了,经决定开发实验报告管理系统。2.2.2可行性研究的前提要求:实验报告系统必须提供学生信息和教师信息的基础设置;提供强大的条件搜索功能个实验课程查询、实验列表出现等管理功能;能够分不同权限、不同用户对该系统进行操作。另外,该系统还必须保证数据的安全性、完整性和准确性。目标:实验报告管理系统的目标是实现学生的纸质的实验报告太多没有地方长期保存,这样用一个系统能够将一个课程所有学生的实验报告进行管理方便存放。条件、假定和限制:时间的限制,我们必须在两周的时间里完成项目,在这期间系统分析员需要整理好分析结果,分配各组员的任务,每天需要人员跟踪记录整理文档。程序开发人员须在5天的时间里进行系统设计、程序编码、系统测试、程序调试。期间,还包括一个双休日假期。2.2.3结论根据上面的分析,在技术上不会存在什么问题,因此项目延期的可能性很小。只要在分配的时间里都能顺利地完成任务,再加上团队的凝聚力齐心协力,相信在这两周内会获得一个满意的结果。2.3用例图图2.1用例图

3系统设计与实现3.1系统目标根据需求分析的描述以及与组建成员的沟通,现制定系统实现目标如下:a.界面设计简洁、友好、美观大方。b.操作简单、快捷方便。c.数据存储安全、可靠。d.信息分类清晰、准确。e.强大的查询功能,保证数据查询的灵活性。f.为管理员提供真实的数据信息。g.对用户输入的数据,系统进行严格的数据检查,尽可能排除认为的错误。3.2系统功能结构图3.1系统功能结构3.3功能流程及工作流程学生模块:a.查看实验课程系统操作人员打开学生模块主界面,输入相关的信息(学号、密码)进入模块,点击年按钮就能够看到所需要的信息。b.查看实验列表系统操作人员打开学生模块主界面,输入相关信息进入模块,点击课程就能够看到所要的信息。c.下载实验报告模板当该学生进入自己的界面时,找到要做实验报告的课程,点击下载按钮。d.上传实验报告当学生做完实验报告后,进入系统,点击上传按钮。教师模块:a.查看实验课程系统操作人员打开学生模块主界面,输入相关的信息(工号、密码)进入模块,点击年按钮就能够看到所需要的信息。b.查看实验列表系统操作人员打开老师模块主界面,输入相关信息进入模块,点击课程就能够看到所要的信息c.查看提交情况教师进入教师界面,点击自己教的课程,点击查看按钮。d.上传实验报告模板当该老师进入自己的界面时,找到要做实验报告的课程的实验名称,点击上传按钮。e.下载学生实验当该老师进入自己的界面时,找到实验列表详情,点击下载按钮。f.打分当该老师进入自己的界面时,下载学生的实验报告看完后,在实验列表详情中点击打分按钮。3.4系统流程图图3.2系统流程图3.5构建开发环境a.操作系统:windows7或XPb．java开发包:JDK1.6c．数据库:MYSQLd.分辨率:最佳效果为1024*768像素3.7文件夹组织结构图3.7文件夹组织结构3.8学生模块的实现packagecom.xzit.entity;publicclassExperclass{ privateintEid; privateStringcourseID; privateStringcourseName; privateStringcourseTime; privateStringcoursePeriod;//课程学时 privateintexperimentNum; privateStringteacherName; privateStringclassName; publicExperclass(){ super(); } publicExperclass(inteid,StringcourseID,StringcourseName, StringcourseTime,intexperimentNum,StringteacherName, StringclassName){ super(); Eid=eid; this.courseID=courseID; this.courseName=courseName; this.courseTime=courseTime; this.experimentNum=experimentNum; this.teacherName=teacherName; this.className=className; } publicExperclass(inteid,StringcourseID,StringcourseName, StringcourseTime,StringcoursePeriod,intexperimentNum, StringteacherName,StringclassName){ super(); Eid=eid; this.courseID=courseID; this.courseName=courseName; this.courseTime=courseTime; this.coursePeriod=coursePeriod; this.experimentNum=experimentNum; this.teacherName=teacherName; this.className=className; } publicStringgetCoursePeriod(){ returncoursePeriod; } publicvoidsetCoursePeriod(StringcoursePeriod){ this.coursePeriod=coursePeriod; } publicStringgetCourseID(){ returncourseID; } publicvoidsetCourseID(StringcourseID){ this.courseID=courseID; } publicStringgetCourseName(){ returncourseName; } publicvoidsetCourseName(StringcourseName){ this.courseName=courseName; } publicStringgetCourseTime(){ returncourseTime; } publicvoidsetCourseTime(StringcourseTime){ this.courseTime=courseTime; } publicintgetExperimentNum(){ returnexperimentNum; } publicvoidsetExperimentNum(intexperimentNum){ this.experimentNum=experimentNum; } publicStringgetTeacherName(){ returnteacherName; } publicvoidsetTeacherName(StringteacherName){ this.teacherName=teacherName; } publicStringgetClassName(){ returnclassName; } publicvoidsetClassName(StringclassName){ this.className=className; } }packagecom.xzit.dao.impl;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.util.ArrayList;importjava.util.HashMap;importjava.util.List;importjava.util.Map;importorg.apache.struts2.ServletActionContext;importcom.xzit.dao.ExperclassDao;importcom.xzit.entity.ExperContent;importcom.xzit.entity.Experclass;importcom.xzit.util.DBConnection;importcom.xzit.util.DataGrid;publicclassExperclassDaoimplextendsBaseDao<Experclass>implementsExperclassDao{ privateStringCourseTime; publicExperclassDaoimpl()throwsException{ //TODOAuto-generatedconstructorstub } privateConnectionconn=newDBConnection().getConn(); privatePreparedStatementstrat=null; publicDataGrid<Map<String,Object>>experclass(Stringcoursetime) throwsException{ DataGrid<Map<String,Object>>dg= newDataGrid<Map<String,Object>>(); //分页信息 String_page=ServletActionContext.getRequest().getParameter("page"); intpage=Integer.parseInt(_page==null?"1":_page); String_rows=ServletActionContext.getRequest().getParameter("rows"); introws=Integer.parseInt(_rows==null?"20":_rows); Stringsql="select*fromexperclasstablewhereCourseTime='"+coursetime+"'andTeacherID='"+ ServletActionContext.getRequest().getSession().getAttribute("TeaId")+"'"; //Stringsql="selectCourseID,CourseName,CourseTime,CoursePeriod,ExperimentNum,TeacherName,ClassNamefromexperclasstablewhereCourseTime='"+courseTime+"'andClassName='"+ //ServletActionContext.getRequest().getSession().getAttribute("userclassname")+"'"; System.out.println("==============sql==========="+sql); List<Map<String,Object>>datamap=super.listMapList(sql,page,rows); dg.setRows(datamap); StringcountSQL="selectcount(*)fromexperclasstablewhereCourseTime='"+coursetime+"'andTeacherID='"+ ServletActionContext.getRequest().getSession().getAttribute("TeaId")+"'"; dg.setTotal(super.count(countSQL)); returndg; } publicDataGrid<Map<String,Object>>stuexperclass(StringcourseTime)throwsException{ //TODOAuto-generatedmethodstub DataGrid<Map<String,Object>>dg= newDataGrid<Map<String,Object>>(); //分页信息 String_page=ServletActionContext.getRequest().getParameter("page"); intpage=Integer.parseInt(_page==null?"1":_page); String_rows=ServletActionContext.getRequest().getParameter("rows"); introws=Integer.parseInt(_rows==null?"20":_rows); //Stringsql="selectCourseID,CourseName,ExperimentNum,TeacherNamefromexperclasstablewhereCourseTime='-'andClassName='12计卓'"; Stringsql="selectCourseID,CourseName,CourseTime,CoursePeriod,ExperimentNum,TeacherName,ClassNamefromexperclasstablewhereCourseTime='"+courseTime+"'andClassName='"+ ServletActionContext.getRequest().getSession().getAttribute("userclassname")+"'"; List<Map<String,Object>>datamap=super.listMapList(sql,page,rows); dg.setRows(datamap); StringcountSQL="selectcount(*)fromexperclasstablewhereCourseTime='"+courseTime+"'andClassName='"+ ServletActionContext.getRequest().getSession().getAttribute("userclassname")+"'"; dg.setTotal(super.count(countSQL)); returndg; } publicDataGrid<Map<String,Object>>stuexperContentlist(StringcourseId)throwsException{ //TODOAuto-generatedmethodstub DataGrid<Map<String,Object>>dg= newDataGrid<Map<String,Object>>(); //分页信息 String_page=ServletActionContext.getRequest().getParameter("page"); intpage=Integer.parseInt(_page==null?"1":_page); String_rows=ServletActionContext.getRequest().getParameter("rows"); introws=Integer.parseInt(_rows==null?"20":_rows); //Stringsql="selectCourseID,CourseName,ExperimentNum,TeacherNamefromexperclasstablewhereCourseTime='-'andClassName='12计卓'"; Stringsql="selectt1.ExperimentID,t1.ExperimentName,ExperimentPeriod,t1.TeacherName,t2.Status,t2.upfileDate,t1.ExperimentContentfromexpercontenttableast1joinexpertablesubmitast2ont1.ExperimentID=t2.ExperimentIDwheret1.CourseID='" +courseId+"'andStudentID="+ServletActionContext.getRequest().getSession().getAttribute("userId"); List<Map<String,Object>>datamap=super.listMapList(sql,page,rows); dg.setRows(datamap); StringcountSQL="selectcount(*)fromexpercontenttableast1joinexpertablesubmitast2ont1.ExperimentID=t2.ExperimentIDwheret1.CourseID='"+courseId+"'andStudentID="+ServletActionContext.getRequest().getSession().getAttribute("userId"); dg.setTotal(super.count(countSQL)); returndg; } publicExperContentqueryExperContent(StringexperimentID)throwsException{ //TODOAuto-generatedmethodstub Stringsql="selectt1.*fromexpercontenttableast1joinexpertablesubmitast2ont1.CourseID=t2.CourseIDwheret1.ExperimentID='"+experimentID+"'andStudentID='"+ServletActionContext.getRequest().getSession().getAttribute("userId")+"'"; System.out.println(sql); strat=conn.prepareStatement(sql);ResultSetrs=strat.executeQuery();ExperContentcontent=null;if(rs.next()){ content=newExperContent(); content.setExperimentID(rs.getString("ExperimentID")); content.setExperimentName(rs.getString("ExperimentName")); content.setExperimentContent(rs.getString("ExperimentContent")); content.setExperimentPeriod(rs.getInt("ExperimentPeriod")); content.setTeacherName(rs.getString("TeacherName")); //content.setTempletfile(rs.getString("Templetfile")); content.setTempletfile("upload/"+rs.getString("Templetfile").replace("\\","/")); } returncontent; } publicDataGrid<Map<String,Object>>getexperlist(StringcourseId)throwsException{ //TODOAuto-generatedmethodstub DataGrid<Map<String,Object>>dg= newDataGrid<Map<String,Object>>(); //分页信息 String_page=ServletActionContext.getRequest().getParameter("page"); intpage=Integer.parseInt(_page==null?"1":_page); String_rows=ServletActionContext.getRequest().getParameter("rows"); introws=Integer.parseInt(_rows==null?"20":_rows); //Stringsql="selectCourseID,CourseName,ExperimentNum,TeacherNamefromexperclasstablewhereCourseTime='-'andClassName='12计卓'"; Stringsql="select*fromexpercontenttablewhereCourseID='" +courseId+"'"; List<Map<String,Object>>datamap=super.listMapList(sql,page,rows); dg.setRows(datamap); StringcountSQL="selectcount(*)fromexpercontenttablewhereCourseID='" +courseId+"'"; dg.setTotal(super.count(countSQL)); returndg; } publicStringgetCourseTime(){ returnCourseTime; } publicvoidsetCourseTime(StringcourseTime){ CourseTime=courseTime; } }packagecom.xzit.entity;publicclassExper{ privateStringExperimentID; privateStringExperimentName; privateStringClassName; privateStringStudentID; privateStringStudentName; privateStringTeacherID; privateStringTeacherName; privateStringFileName; privateStringFileRoad; privateStringStatus; privateStringUpfileDate; privateStringTestscore; publicExper(){ super(); } publicExper(StringexperimentID,StringexperimentName, StringstudentName,StringteacherName,StringfileRoad, Stringstatus){ super(); ExperimentID=experimentID; ExperimentName=experimentName; StudentName=studentName; TeacherName=teacherName; FileRoad=fileRoad; Status=status; } publicExper(StringexperimentID,StringexperimentName,StringclassName, StringstudentID,StringstudentName,StringteacherID, StringteacherName,StringfileName,StringfileRoad, Stringstatus,StringupfileDate,Stringtestscore){ super(); ExperimentID=experimentID; ExperimentName=experimentName; ClassName=className; StudentID=studentID; StudentName=studentName; TeacherID=teacherID; TeacherName=teacherName; FileName=fileName; FileRoad=fileRoad; Status=status; UpfileDate=upfileDate; Testscore=testscore; } publicStringgetClassName(){ returnClassName; } publicvoidsetClassName(StringclassName){ ClassName=className; } publicStringgetStudentID(){ returnStudentID; } publicvoidsetStudentID(StringstudentID){ StudentID=studentID; } publicStringgetTeacherID(){ returnTeacherID; } publicvoidsetTeacherID(StringteacherID){ TeacherID=teacherID; } publicStringgetFileName(){ returnFileName; } publicvoidsetFileName(StringfileName){ FileName=fileName; } publicStringgetUpfileDate(){ returnUpfileDate; } publicvoidsetUpfileDate(StringupfileDate){ UpfileDate=upfileDate; } publicStringgetTestscore(){ returnTestscore; } publicvoidsetTestscore(Stringtestscore){ Testscore=testscore; } publicStringgetExperimentID(){ returnExperimentID; } publicvoidsetExperimentID(StringexperimentID){ ExperimentID=experimentID; } publicStringgetExperimentName(){ returnExperimentName; } publicvoidsetExperimentName(StringexperimentName){ ExperimentName=experimentName; } publicStringgetStudentName(){ returnStudentName; } publicvoidsetStudentName(StringstudentName){ StudentName=studentName; } publicStringgetTeacherName(){ returnTeacherName; } publicvoidsetTeacherName(StringteacherName){ TeacherName=teacherName; } publicStringgetFileRoad(){ returnFileRoad; } publicvoidsetFileRoad(StringfileRoad){ FileRoad=fileRoad; } publicStringgetStatus(){ returnStatus; } publicvoidsetStatus(Stringstatus){ Status=status; } }packagecom.xzit.dao.impl;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.util.List;importjava.util.Map;importorg.apache.struts2.ServletActionContext;importcom.xzit.dao.ExperDao;importcom.xzit.entity.Exper;importcom.xzit.util.DBConnection;importcom.xzit.util.DataGrid;publicclassExperDaoListImpl<T>extendsBaseDao<Exper>implementsExperDao{ privateConnectionconn=newDBConnection().getConn(); privatePreparedStatementstrat=null; publicExperDaoListImpl()throwsException{ super(); //TODOAuto-generatedconstructorstub } publicExperexper()throwsException{ //TODOAuto-generatedmethodstub returnnull; } publicvoidsaveandUpdate(intsid,inteid)throwsException{ //TODOAuto-generatedmethodstub } publicList<Exper>list(intpage,introws)throwsException{ Stringsql="select*fromexpertablesubmit"; returnsuper.list(sql,Exper.class,page,rows); } publiclongcount()throwsException{ return0; } publicDataGrid<Map<String,Object>>getexpsublist(Stringexperid,Stringcourid) throwsException{ //TODOAuto-generatedmethodstub DataGrid<Map<String,Object>>dg= newDataGrid<Map<String,Object>>(); //分页信息 String_page=ServletActionContext.getRequest().getParameter("page"); intpage=Integer.parseInt(_page==null?"1":_page); String_rows=ServletActionContext.getRequest().getParameter("rows"); introws=Integer.parseInt(_rows==null?"20":_rows); Stringsql="select*fromexpertablesubmitwhereExperimentID='"+experid+"'andCourseID='"+ courid+"'"; //Stringsql="selectCourseID,CourseName,CourseTime,CoursePeriod,ExperimentNum,TeacherName,ClassNamefromexperclasstablewhereCourseTime='"+courseTime+"'andClassName='"+ //ServletActionContext.getRequest().getSession().getAttribute("userclassname")+"'"; System.out.println("==============sql==========="+sql); List<Map<String,Object>>datamap=super.listMapList(sql,page,rows); dg.setRows(datamap); StringcountSQL="selectcount(*)fromexpertablesubmitwhereExperimentID='"+experid+"'andCourseID='"+ courid+"'"; dg.setTotal(super.count(countSQL)); returndg; } publicbooleanaddfron(Stringexperid,Stringcourid,Stringstuid, floatTestscores)throwsException{ //TODOAuto-generatedmethodstub Stringsql="updateexpertablesubmitsetTestscore="+Testscores+"whereExperimentID='"+experid+"'andStudentID='"+stuid+"'andCourseID='"+courid+"'"; strat=conn.prepareStatement(sql); intn=strat.executeUpdate(); if(n>0){ returntrue; } returnfalse; }}packagecom.xzit.entity;publicclassUpfile{ privateStringfileName;//文件名称 privateStringfileStuClass;//课程班级 privateStringfileCourDate;//年 privateStringfileCourName;//课程名称 privateStringfileExperName;//实验名称 publicStringgetFileName(){ returnfileName; } publicvoidsetFileName(StringfileName){ this.fileName=fileName; } publicStringgetFileStuClass(){ returnfileStuClass; } publicvoidsetFileStuClass(StringfileStuClass){ this.fileStuClass=fileStuClass; } publicStringgetFileCourDate(){ returnfileCourDate; } publicvoidsetFileCourDate(StringfileCourDate){ this.fileCourDate=fileCourDate; } publicStringgetFileCourName(){ returnfileCourName; } publicvoidsetFileCourName(StringfileCourName){ this.fileCourName=fileCourName; } publicStringgetFileExperName(){ returnfileExperName; } publicvoidsetFileExperName(StringfileExperName){ this.fileExperName=fileExperName; } }packagecom.xzit.dao.impl;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.text.SimpleDateFormat;importjava.util.Date;importorg.apache.struts2.ServletActionContext;importcom.xzit.dao.IUpfileDao;importcom.xzit.entity.Upfile;importcom.xzit.util.DBConnection;publicclassUpfileDaoextendsBaseDao<Upfile>implementsIUpfileDao{ privateConnectionconn=newDBConnection().getConn(); privatePreparedStatementstrat=null; publicUpfileDao()throwsException{ super(); } publicUpfileQueryFileClass(Stringcourid)throwsException{ //TODOAuto-generatedmethodstub Stringsql="select*fromexperclasstablewhereCourseID='"+courid+"'"; strat=conn.prepareStatement(sql);ResultSetrs=strat.executeQuery();Upfilecontent=null;while(rs.next()){ content=newUpfile(); content.setFileCourDate(rs.getString("CourseTime")); content.setFileCourName(rs.getString("CourseName")); content.setFileStuClass(rs.getString("ClassName"));} returncontent; } publicStringSaveFileRoad(Stringexperid,Stringpath,Stringupfilename)throwsException{ //TODOAuto-generatedmethodstub SimpleDateFormatdf=newSimpleDateFormat("yyyy-MM-dd");//设置日期格式 Stringdatetime=df.format(newDate());//newDate()为获取当前系统时间 Stringsql="updateexpertablesubmitsetFileRoad='"+path+"',Status='是',UpfileDate='"+datetime +"',FileName='"+upfilename+"'whereExperimentID='"+experid+"'andStudentID='"+ServletActionContext.getRequest().getSession().getAttribute("userId")+"'"; strat=conn.prepareStatement(sql); intn=strat.executeUpdate(); if(n>0){ return"success"; } return"false"; } publicStringteaSaveFileRoad(Stringexperid,Stringpath,Stringcourid) throwsException{ //TODOAuto-generatedmethodstub Stringsql="updateexpercontenttablesetTempletfile='"+path+"'whereExperimentID='"+experid+"'andCourseID='"+courid+"'"; strat=conn.prepareStatement(sql); intn=strat.executeUpdate(); if(n>0){ return"success"; } return"false"; } }3.9老师模块的实现packagecom.xzit.entity;publicclassExperContent{ privateStringExperimentID; privateStringExperimentName; privateStringExperimentContent; privateintExperimentPeriod; privateStringTeacherName; privateStringTempletfile; publicStringgetExperimentID(){ returnExperimentID; } publicvoidsetExperimentID(StringexperimentID){ ExperimentID=experimentID; } publicStringgetExperimentName(){ returnExperimentName; } publicvoidsetExperimentName(StringexperimentName){ ExperimentName=experimentName; } publicStringgetExperimentContent(){ returnExperimentContent; } publicvoidsetExperimentContent(StringexperimentContent){ ExperimentContent=experimentContent; } publicintgetExperimentPeriod(){ returnExperimentPeriod; } publicvoidsetExperimentPeriod(intexperimentPeriod){ ExperimentPeriod=experimentPeriod; } publicStringgetTeacherName(){ returnTeacherName; } publicvoidsetTeacherName(StringteacherName){ TeacherName=teacherName; } publicStringgetTempletfile(){ returnTempletfile; } publicvoidsetTempletfile(Stringtempletfile){ Templetfile=templetfile; } publicExperContent(){ super(); } publicExperContent(StringexperimentID,StringexperimentName, StringexperimentContent,intexperimentPeriod,StringteacherName, Stringtempletfile){ super(); ExperimentID=experimentID; ExperimentName=experimentName; ExperimentContent=experimentContent; ExperimentPeriod=experimentPeriod; TeacherName=teacherName; Templetfile=templetfile; } }packagecom.xzit.entity;publicclassUpfile{ privateStringfileName;//文件名称 privateStringfileStuClass;//课程班级 privateStringfileCourDate;//年 privateStringfileCourName;//课程名称 privateStringfileExperName;//实验名称 publicStringgetFileName(){ returnfileName; } publicvoidsetFileName(StringfileName){ this.fileName=fileName; } publicStringgetFileStuClass(){ returnfileStuClass; } publicvoidsetFileStuClass(StringfileStuClass){ this.fileStuClass=fileStuClass; } publicStringgetFileCourDate(){ returnfileCourDate; } publicvoidsetFileCourDate(StringfileCourDate){ this.fileCourDate=fileCourDate; } publicStringgetFileCourName(){ returnfileCourName; } publicvoidsetFileCourName(StringfileCourName){ this.fileCourName=fileCourName; } publicStringgetFileExperName(){ returnfileExperName; } publicvoidsetFileExperName(StringfileExperName){ this.fileExperName=fileExperName; } }packagecom.xzit.dao.impl;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.text.SimpleDateFormat;importjava.util.Date;importorg.apache.struts2.ServletActionContext;importcom.xzit.dao.IUpfileDao;importcom.xzit.entity.Upfile;importcom.xzit.util.DBConnection;publicclassUpfileDaoextendsBaseDao<Upfile>implementsIUpfileDao{ privateConnectionconn=newDBConnection().getConn(); privatePreparedStatementstrat=null; publicUpfileDao()throwsException{ super(); } publicUpfileQueryFileClass(Stringcourid)throwsException{ //TODOAuto-generatedmethodstub Stringsql="select*fromexperclasstablewhereCourseID='"+courid+"'"; strat=conn.prepareStatement(sql);ResultSetrs=strat.executeQuery();Upfilecontent=null;while(rs.next()){ content=newUpfile(); content.setFileCourDate(rs.getString("CourseTime")); content.setFileCourName(rs.getString("CourseName")); content.setFileStuClass(rs.getString("ClassName"));} returncontent; } publicStringSaveFileRoad(Stringexperid,Stringpath,Stringupfilename)throwsException{ //TODOAuto-generatedmethodstub SimpleDateFormatdf=newSimpleDateFormat("yyyy-MM-dd");//设置日期格式 Stringdatetime=df.format(newDate());//newDate()为获取当前系统时间 Stringsql="updateexpertablesubmitsetFileRoad='"+path+"',Status='是',UpfileDate='"+datetime +"',FileName='"+upfilename+"'whereExperimentID='"+experid+"'andStudentID='"+ServletActionContext.getRequest().getSession().getAttribute("userId")+"'"; strat=conn.prepareStatement(sql); intn=strat.executeUpdate(); if(n>0){ return"success"; } return"false"; } publicStringteaSaveFileRoad(Stringexperid,Stringpath,Stringcourid) throwsException{ //TODOAuto-generatedmethodstub Stringsql="updateexpercontenttablesetTempletfile='"+path+"'whereExperimentID='"+experid+"'andCourseID='"+courid+"'"; strat=conn.prepareStatement(sql); intn=strat.executeUpdate(); if(n>0){ return"success"; } return"false"; } }packagecom.xzit.entity;publicclassExperclass{ privateintEid; privateStringcourseID; privateStringcourseName; privateStringcourseTime; privateStringcoursePeriod;//课程学时 privateintexperimentNum; privateStringteacherName; privateStringclassName; publicExperclass(){ super(); } publicExperclass(inteid,StringcourseID,StringcourseName, StringcourseTime,intexperimentNum,StringteacherName, StringclassName){ super(); Eid=eid; this.courseID=courseID; this.courseName=courseName; this.courseTime=courseTime; this.experimentNum=experimentNum; this.teacherName=teacherName; this.className=className; } publicExperclass(inteid,StringcourseID,StringcourseName, StringcourseTime,StringcoursePeriod,intexperimentNum, StringteacherName,StringclassName){ super(); Eid=eid; this.courseID=courseID; this.courseName=courseName; this.courseTime=courseTime; this.coursePeriod=coursePeriod; this.experimentNum=experimentNum; this.teacherName=teacherName; this.className=className; } publicStringgetCoursePeriod(){ returncoursePeriod; } publicvoidsetCoursePeriod(StringcoursePeriod){ this.coursePeriod=coursePeriod; } publicStringgetCourseID(){ returncourseID; } publicvoidsetCourseID(StringcourseID){ this.courseID=courseID; } publicStringgetCourseName(){ returncourseName; } publicvoidsetCourseName(StringcourseName){ this.courseName=courseName; } publicStringgetCourseTime(){ returncourseTime; } publicvoidsetCourseTime(StringcourseTime){ this.courseTime=courseTime; } publicintgetExperimentNum(){ returnexperimentNum; } publicvoidsetExperimentNum(intexperimentNum){ this.experimentNum=experimentNum; } publicStringgetTeacherName(){ returnteacherName; } publicvoidsetTeacherName(StringteacherName){ this.teacherName=teacherName; } publicStringgetClassName(){ returnclassName; } publicvoidsetClassName(StringclassName){ this.className=className; } }packagecom.xzit.dao.impl;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.util.ArrayList;importjava.util.HashMap;importjava.util.List;importjava.util.Map;importorg.apache.struts2.ServletActionContext;importcom.xzit.dao.ExperclassDao;importcom.xzit.entity.ExperContent;importcom.xzit.entity.Experclass;importcom.xzit.util.DBConnection;importcom.xzit.util.DataGrid;publicclassExperclassDaoimplextendsBaseDao<Experclass>implementsExperclassDao{ privateStringCourseTime; publicExperclassDaoimpl()throwsException{ //TODOAuto-generatedconstructorstub } privateConnectionconn=new