实验报告管理系统报告




软件项目设计报告

实验报告理系统



班级

组成员

学院名称
信电工程学院
专业名称
计算机科学技术
指导教师

起止日期
201412162015115


2015年
1月
15日







目 录
1 绪 1
11开发背景 1
12 次设计完成工作 1
13 务分工 1
14 务 1
2 系统分析 2
21需求分析 2
22行性分析 2
23 例图 2
3 系统设计实现 4
31系统目标 4
32系统功结构 4
33功流程工作流程 4
34系统流程图 5
35构建开发环境 5
37文件夹组织结构 6
38 学生模块实现 6
39 老师模块实现 19
结 35

1 绪
11开发背景
实验教学学生技培养重环节学生实验报告质量定程度反映实验教学质量实验报告理水反映实验教学理水目前部分学校提交实验报告停留纸介质方式严重制约着实验教学开展首先课程实验结果纸质实验报告中表现完全表现次纸质实验报告批改分析实验授课老师重负担提高学生实验报告表象力提高教师批改实验报告效率时发现纠正实验报告中存问题许课程实验授课教师面难题
12 次设计完成工作
老师登录该系统传载实验报告查学生做实验报告学生分老师查实验验课程实验课程列表查实验提交情况等
学生登录该系统传载实验报告查实验课程实验课程列表

13 务分工
组织结构：完成学生信息理系统项目开发班级组成项目团队员分工：明确项目团队中务分工现制定员分工表21示
表21 员分工
成员
角色
负责模块容
A
江灵瞳
学生传载学生查实验课程查实验列表
B
印海
老师传载老师填写分数数库设计
C
钱晨晨
老师查实验课程查实验列表查实验交情况登录
14 务
三分工完成模块容首先江灵瞳构造整系统框架然印海设计数库起先设计前台界面实现模块功





2 系统分析
21需求分析
1）实验课程设置设置课程编号课程名时间次数老师编号老师名实验班级
2）实验列表设置设置实验编号实验名班级学生学号学生名老师名实验路径提交状态分数
3）树型类设置设置编号名字路径学生名老师名树状态
22行性分析
221引言
编写目：
背景：
徐州工程学院培养应型普通高等学院完善理学校实验报告太没方保存决定开发实验报告理系统
222行性研究前提
求
实验报告系统必须提供学生信息教师信息基础设置提供强条件搜索功实验课程查询实验列表出现等理功分权限户该系统进行操作外该系统必须保证数安全性完整性准确性
目标：
实验报告理系统目标实现学生纸质实验报告太没方长期保存样系统课程学生实验报告进行理方便存放
条件假定限制：
时间限制必须两周时间里完成项目期间系统分析员需整理分析结果分配组员务天需员踪记录整理文档程序开发员须5天时间里进行系统设计程序编码系统测试程序调试期间包括双休日假期
223结
根面分析技术会存什问题项目延期性分配时间里利完成务加团队凝聚力齐心协力相信两周会获满意结果
23 例图

图21 例图
3 系统设计实现
31系统目标
根需求分析描述组建成员沟通现制定系统实现目标
a界面设计简洁友美观方
b操作简单快捷方便
c数存储安全
d信息分类清晰准确
e强查询功保证数查询灵活性
f理员提供真实数信息
g户输入数系统进行严格数检查排认错误
32系统功结构


图31 系统功结构
33功流程工作流程
学生模块：
a查实验课程
系统操作员开学生模块界面输入相关信息（学号密码）进入模块点击学年钮需信息
b查实验列表
系统操作员开学生模块界面输入相关信息进入模块点击课程信息
c载实验报告模板
该学生进入界面时找做实验报告课程点击载钮
d传实验报告
学生做完实验报告进入系统点击传钮
教师模块：
a查实验课程
系统操作员开学生模块界面输入相关信息（工号密码）进入模块点击学年钮需信息
b查实验列表
系统操作员开老师模块界面输入相关信息进入模块点击课程信息
c查提交情况
教师进入教师界面点击教课程点击查钮
d传实验报告模板
该老师进入界面时找做实验报告课程实验名称点击传钮
e载学生实验
该老师进入界面时找实验列表详情点击载钮
f分
该老师进入界面时载学生实验报告完实验列表详情中点击分钮

34系统流程图


图32 系统流程图
35构建开发环境
a操作系统：windows 7XP
b．java开发包：JDK16
c．数库：MY SQL
d分辨率佳效果1024*768素
37文件夹组织结构


图37 文件夹组织结构
38 学生模块实现









package comxzitentity

public class Experclass {

private int Eid
private String courseID
private String courseName
private String courseTime
private String coursePeriod课程学时

private int experimentNum
private String teacherName
private String className


public Experclass() {
super()
}

public Experclass(int eid String courseID String courseName
String courseTime int experimentNum String teacherName
String className) {
super()
Eid eid
thiscourseID courseID
thiscourseName courseName
thiscourseTime courseTime
thisexperimentNum experimentNum
thisteacherName teacherName
thisclassName className
}
public Experclass(int eid String courseID String courseName
String courseTime String coursePeriod int experimentNum
String teacherName String className) {
super()
Eid eid
thiscourseID courseID
thiscourseName courseName
thiscourseTime courseTime
thiscoursePeriod coursePeriod
thisexperimentNum experimentNum
thisteacherName teacherName
thisclassName className
}

public String getCoursePeriod() {
return coursePeriod
}

public void setCoursePeriod(String coursePeriod) {
thiscoursePeriod coursePeriod
}
public String getCourseID() {
return courseID
}
public void setCourseID(String courseID) {
thiscourseID courseID
}
public String getCourseName() {
return courseName
}
public void setCourseName(String courseName) {
thiscourseName courseName
}
public String getCourseTime() {
return courseTime
}
public void setCourseTime(String courseTime) {
thiscourseTime courseTime
}
public int getExperimentNum() {
return experimentNum
}
public void setExperimentNum(int experimentNum) {
thisexperimentNum experimentNum
}
public String getTeacherName() {
return teacherName
}
public void setTeacherName(String teacherName) {
thisteacherName teacherName
}
public String getClassName() {
return className
}
public void setClassName(String className) {
thisclassName className
}

}
package comxzitdaoimpl

import javasqlConnection
import javasqlPreparedStatement
import javasqlResultSet
import javautilArrayList
import javautilHashMap
import javautilList
import javautilMap

import orgapachestruts2ServletActionContext

import comxzitdaoExperclassDao
import comxzitentityExperContent
import comxzitentityExperclass
import comxzitutilDBConnection
import comxzitutilDataGrid

public class ExperclassDaoimpl extends BaseDao implements ExperclassDao {

private String CourseTime

public ExperclassDaoimpl() throws Exception {
TODO Autogenerated constructor stub
}

private Connection connnew DBConnection()getConn()
private PreparedStatement stratnull

public DataGrid> experclass(String coursetime)
throws Exception {

DataGrid> dg
new DataGrid>()
分页信息
String _page ServletActionContextgetRequest()getParameter(page)
int page IntegerparseInt(_pagenull1_page)
String _rows ServletActionContextgetRequest()getParameter(rows)
int rows IntegerparseInt(_rowsnull20_rows)

String sqlselect * from experclasstable where CourseTime＇+coursetime+＇ and TeacherID＇+
ServletActionContextgetRequest()getSession()getAttribute(TeaId)+＇

String sql select CourseIDCourseNameCourseTimeCoursePeriodExperimentNumTeacherNameClassName from experclasstable where CourseTime＇+courseTime+＇ and ClassName＇+
ServletActionContextgetRequest()getSession()getAttribute(userclassname)+＇
Systemoutprintln(sql+sql)
List> datamap superlistMapList(sql pagerows)
dgsetRows(datamap)
String countSQL select count(*) from experclasstable where CourseTime＇+coursetime+＇ and TeacherID＇+
ServletActionContextgetRequest()getSession()getAttribute(TeaId)+＇
dgsetTotal(supercount(countSQL))
return dg


}

public DataGrid> stuexperclass(String courseTime) throws Exception {
TODO Autogenerated method stub

DataGrid> dg
new DataGrid>()
分页信息
String _page ServletActionContextgetRequest()getParameter(page)
int page IntegerparseInt(_pagenull1_page)
String _rows ServletActionContextgetRequest()getParameter(rows)
int rows IntegerparseInt(_rowsnull20_rows)
String sql select CourseIDCourseNameExperimentNumTeacherName from experclasstable where CourseTime＇2014年2015年＇ and ClassName＇12计卓＇
String sql select CourseIDCourseNameCourseTimeCoursePeriodExperimentNumTeacherNameClassName from experclasstable where CourseTime＇+courseTime+＇ and ClassName＇+
ServletActionContextgetRequest()getSession()getAttribute(userclassname)+＇

List> datamap superlistMapList(sql pagerows)
dgsetRows(datamap)
String countSQL select count(*) from experclasstable where CourseTime＇+courseTime+＇ and ClassName＇+
ServletActionContextgetRequest()getSession()getAttribute(userclassname)+＇
dgsetTotal(supercount(countSQL))
return dg

}

public DataGrid> stuexperContentlist(String courseId) throws Exception {
TODO Autogenerated method stub

DataGrid> dg
new DataGrid>()
分页信息
String _page ServletActionContextgetRequest()getParameter(page)
int page IntegerparseInt(_pagenull1_page)
String _rows ServletActionContextgetRequest()getParameter(rows)
int rows IntegerparseInt(_rowsnull20_rows)
String sql select CourseIDCourseNameExperimentNumTeacherName from experclasstable where CourseTime＇2014年2015年＇ and ClassName＇12计卓＇
String sql select t1ExperimentIDt1ExperimentNameExperimentPeriodt1TeacherNamet2Statust2upfileDatet1ExperimentContent from expercontenttable as t1 join expertablesubmit as t2 on t1ExperimentIDt2ExperimentID where t1CourseID＇
+courseId+＇ and StudentID+ServletActionContextgetRequest()getSession()getAttribute(userId)
List> datamap superlistMapList(sql pagerows)
dgsetRows(datamap)
String countSQL select count(*) from expercontenttable as t1 join expertablesubmit as t2 on t1ExperimentIDt2ExperimentID where t1CourseID＇+courseId+＇ and StudentID+ServletActionContextgetRequest()getSession()getAttribute(userId)
dgsetTotal(supercount(countSQL))
return dg
}

public ExperContent queryExperContent(String experimentID) throws Exception {
TODO Autogenerated method stub

String sql select t1* from expercontenttable as t1 join expertablesubmit as t2 on t1CourseIDt2CourseID where t1ExperimentID＇+experimentID+＇ and StudentID＇+ServletActionContextgetRequest()getSession()getAttribute(userId)+＇
Systemoutprintln(sql)
stratconnprepareStatement(sql)
ResultSet rsstratexecuteQuery()
ExperContent contentnull
if(rsnext()){
contentnew ExperContent()
contentsetExperimentID(rsgetString(ExperimentID))
contentsetExperimentName(rsgetString(ExperimentName))
contentsetExperimentContent(rsgetString(ExperimentContent))
contentsetExperimentPeriod(rsgetInt(ExperimentPeriod))
contentsetTeacherName(rsgetString(TeacherName))
contentsetTempletfile(rsgetString(Templetfile))
contentsetTempletfile(upload+rsgetString(Templetfile)replace(＼＼ ))

}

return content

}

public DataGrid> getexperlist(String courseId) throws Exception {
TODO Autogenerated method stub
DataGrid> dg
new DataGrid>()
分页信息
String _page ServletActionContextgetRequest()getParameter(page)
int page IntegerparseInt(_pagenull1_page)
String _rows ServletActionContextgetRequest()getParameter(rows)
int rows IntegerparseInt(_rowsnull20_rows)
String sql select CourseIDCourseNameExperimentNumTeacherName from experclasstable where CourseTime＇2014年2015年＇ and ClassName＇12计卓＇
String sql select * from expercontenttable where CourseID＇
+courseId+＇
List> datamap superlistMapList(sql pagerows)
dgsetRows(datamap)
String countSQL select count(*) from expercontenttable where CourseID＇
+courseId+＇
dgsetTotal(supercount(countSQL))
return dg
}



public String getCourseTime() {
return CourseTime
}

public void setCourseTime(String courseTime) {
CourseTime courseTime
}





}

package comxzitentity

public class Exper {
private String ExperimentID
private String ExperimentName
private String ClassName
private String StudentID
private String StudentName
private String TeacherID
private String TeacherName
private String FileName
private String FileRoad
private String Status
private String UpfileDate
private String Testscore




public Exper() {
super()
}

public Exper(String experimentID String experimentName
String studentName String teacherName String fileRoad
String status) {
super()
ExperimentID experimentID
ExperimentName experimentName
StudentName studentName
TeacherName teacherName
FileRoad fileRoad
Status status
}

public Exper(String experimentID String experimentName String className
String studentID String studentName String teacherID
String teacherName String fileName String fileRoad
String status String upfileDate String testscore) {
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
}

public String getClassName() {
return ClassName
}

public void setClassName(String className) {
ClassName className
}

public String getStudentID() {
return StudentID
}

public void setStudentID(String studentID) {
StudentID studentID
}

public String getTeacherID() {
return TeacherID
}

public void setTeacherID(String teacherID) {
TeacherID teacherID
}

public String getFileName() {
return FileName
}

public void setFileName(String fileName) {
FileName fileName
}

public String getUpfileDate() {
return UpfileDate
}

public void setUpfileDate(String upfileDate) {
UpfileDate upfileDate
}

public String getTestscore() {
return Testscore
}

public void setTestscore(String testscore) {
Testscore testscore
}

public String getExperimentID() {
return ExperimentID
}

public void setExperimentID(String experimentID) {
ExperimentID experimentID
}

public String getExperimentName() {
return ExperimentName
}

public void setExperimentName(String experimentName) {
ExperimentName experimentName
}

public String getStudentName() {
return StudentName
}

public void setStudentName(String studentName) {
StudentName studentName
}

public String getTeacherName() {
return TeacherName
}

public void setTeacherName(String teacherName) {
TeacherName teacherName
}

public String getFileRoad() {
return FileRoad
}

public void setFileRoad(String fileRoad) {
FileRoad fileRoad
}

public String getStatus() {
return Status
}

public void setStatus(String status) {
Status status
}




}

package comxzitdaoimpl

import javasqlConnection
import javasqlPreparedStatement
import javautilList
import javautilMap

import orgapachestruts2ServletActionContext

import comxzitdaoExperDao
import comxzitentityExper
import comxzitutilDBConnection
import comxzitutilDataGrid

public class ExperDaoListImpl extends BaseDao implements ExperDao {

private Connection conn new DBConnection()getConn()
private PreparedStatement stratnull


public ExperDaoListImpl() throws Exception {
super()
TODO Autogenerated constructor stub
}

public Exper exper() throws Exception {
TODO Autogenerated method stub
return null
}

public void saveandUpdate(int sid int eid) throws Exception {
TODO Autogenerated method stub

}

public List list(int page int rows) throws Exception {
String sqlselect * from expertablesubmit
return superlist(sql Experclass page rows)
}
public long count() throws Exception {
return 0
}

public DataGrid> getexpsublist(String experidString courid)
throws Exception {
TODO Autogenerated method stub

DataGrid> dg
new DataGrid>()
分页信息
String _page ServletActionContextgetRequest()getParameter(page)
int page IntegerparseInt(_pagenull1_page)
String _rows ServletActionContextgetRequest()getParameter(rows)
int rows IntegerparseInt(_rowsnull20_rows)

String sqlselect * from expertablesubmit where ExperimentID＇+experid+＇ and CourseID＇+
courid+＇

String sql select CourseIDCourseNameCourseTimeCoursePeriodExperimentNumTeacherNameClassName from experclasstable where CourseTime＇+courseTime+＇ and ClassName＇+
ServletActionContextgetRequest()getSession()getAttribute(userclassname)+＇
Systemoutprintln(sql+sql)
List> datamap superlistMapList(sql pagerows)
dgsetRows(datamap)
String countSQL select count(*) from expertablesubmit where ExperimentID＇+experid+＇ and CourseID＇+
courid+＇
dgsetTotal(supercount(countSQL))
return dg
}

public boolean addfron(String experid String courid String stuid
float Testscores) throws Exception {
TODO Autogenerated method stub
String sql update expertablesubmit set Testscore+Testscores+ where ExperimentID＇+experid+＇ and StudentID＇+stuid+＇ and CourseID ＇+courid+＇
stratconnprepareStatement(sql)
int n stratexecuteUpdate()
if(n>0){
return true
}
return false
}

}

package comxzitentity

public class Upfile {

private String fileName 文件名称
private String fileStuClass课程班级
private String fileCourDate学年
private String fileCourName课程名称
private String fileExperName实验名称

public String getFileName() {
return fileName
}
public void setFileName(String fileName) {
thisfileName fileName
}
public String getFileStuClass() {
return fileStuClass
}
public void setFileStuClass(String fileStuClass) {
thisfileStuClass fileStuClass
}
public String getFileCourDate() {
return fileCourDate
}
public void setFileCourDate(String fileCourDate) {
thisfileCourDate fileCourDate
}
public String getFileCourName() {
return fileCourName
}
public void setFileCourName(String fileCourName) {
thisfileCourName fileCourName
}
public String getFileExperName() {
return fileExperName
}
public void setFileExperName(String fileExperName) {
thisfileExperName fileExperName
}

}
package comxzitdaoimpl

import javasqlConnection
import javasqlPreparedStatement
import javasqlResultSet
import javatextSimpleDateFormat
import javautilDate

import orgapachestruts2ServletActionContext

import comxzitdaoIUpfileDao
import comxzitentityUpfile
import comxzitutilDBConnection

public class UpfileDao extends BaseDao implements IUpfileDao{


private Connection connnew DBConnection()getConn()
private PreparedStatement stratnull

public UpfileDao() throws Exception {
super()

}

public Upfile QueryFileClass(String courid) throws Exception {
TODO Autogenerated method stub
String sql select * from experclasstable where CourseID＇+courid+＇
stratconnprepareStatement(sql)
ResultSet rsstratexecuteQuery()
Upfile contentnull
while(rsnext()){
contentnew Upfile()
contentsetFileCourDate(rsgetString(CourseTime))
contentsetFileCourName(rsgetString(CourseName))
contentsetFileStuClass(rsgetString(ClassName))
}

return content
}

public String SaveFileRoad(String experidString pathString upfilename) throws Exception {
TODO Autogenerated method stub
SimpleDateFormat df new SimpleDateFormat(yyyyMMdd)设置日期格式
String datetime dfformat(new Date()) new Date()获取前系统时间
String sql update expertablesubmit set FileRoad＇+path+＇Status＇＇UpfileDate＇+datetime
+＇FileName＇+upfilename+＇ where ExperimentID＇+experid+＇ and StudentID＇+ServletActionContextgetRequest()getSession()getAttribute(userId)+＇
stratconnprepareStatement(sql)
int n stratexecuteUpdate()
if(n>0){
return success
}
return false
}

public String teaSaveFileRoad(String experid String path String courid)
throws Exception {
TODO Autogenerated method stub
String sql update expercontenttable set Templetfile＇+path+＇ where ExperimentID＇+experid+＇ and CourseID＇+courid+＇
stratconnprepareStatement(sql)
int n stratexecuteUpdate()
if(n>0){
return success
}
return false
}



}
39 老师模块实现






package comxzitentity

public class ExperContent {

private String ExperimentID
private String ExperimentName
private String ExperimentContent
private int ExperimentPeriod
private String TeacherName
private String Templetfile
public String getExperimentID() {
return ExperimentID
}
public void setExperimentID(String experimentID) {
ExperimentID experimentID
}
public String getExperimentName() {
return ExperimentName
}
public void setExperimentName(String experimentName) {
ExperimentName experimentName
}
public String getExperimentContent() {
return ExperimentContent
}
public void setExperimentContent(String experimentContent) {
ExperimentContent experimentContent
}
public int getExperimentPeriod() {
return ExperimentPeriod
}
public void setExperimentPeriod(int experimentPeriod) {
ExperimentPeriod experimentPeriod
}
public String getTeacherName() {
return TeacherName
}
public void setTeacherName(String teacherName) {
TeacherName teacherName
}
public String getTempletfile() {
return Templetfile
}
public void setTempletfile(String templetfile) {
Templetfile templetfile
}

public ExperContent() {
super()
}
public ExperContent(String experimentID String experimentName
String experimentContent int experimentPeriod String teacherName
String templetfile) {
super()
ExperimentID experimentID
ExperimentName experimentName
ExperimentContent experimentContent
ExperimentPeriod experimentPeriod
TeacherName teacherName
Templetfile templetfile
}

}
package comxzitentity

public class Upfile {

private String fileName 文件名称
private String fileStuClass课程班级
private String fileCourDate学年
private String fileCourName课程名称
private String fileExperName实验名称

public String getFileName() {
return fileName
}
public void setFileName(String fileName) {
thisfileName fileName
}
public String getFileStuClass() {
return fileStuClass
}
public void setFileStuClass(String fileStuClass) {
thisfileStuClass fileStuClass
}
public String getFileCourDate() {
return fileCourDate
}
public void setFileCourDate(String fileCourDate) {
thisfileCourDate fileCourDate
}
public String getFileCourName() {
return fileCourName
}
public void setFileCourName(String fileCourName) {
thisfileCourName fileCourName
}
public String getFileExperName() {
return fileExperName
}
public void setFileExperName(String fileExperName) {
thisfileExperName fileExperName
}

}
package comxzitdaoimpl

import javasqlConnection
import javasqlPreparedStatement
import javasqlResultSet
import javatextSimpleDateFormat
import javautilDate

import orgapachestruts2ServletActionContext

import comxzitdaoIUpfileDao
import comxzitentityUpfile
import comxzitutilDBConnection

public class UpfileDao extends BaseDao implements IUpfileDao{


private Connection connnew DBConnection()getConn()
private PreparedStatement stratnull

public UpfileDao() throws Exception {
super()

}

public Upfile QueryFileClass(String courid) throws Exception {
TODO Autogenerated method stub
String sql select * from experclasstable where CourseID＇+courid+＇
stratconnprepareStatement(sql)
ResultSet rsstratexecuteQuery()
Upfile contentnull
while(rsnext()){
contentnew Upfile()
contentsetFileCourDate(rsgetString(CourseTime))
contentsetFileCourName(rsgetString(CourseName))
contentsetFileStuClass(rsgetString(ClassName))
}

return content
}

public String SaveFileRoad(String experidString pathString upfilename) throws Exception {
TODO Autogenerated method stub
SimpleDateFormat df new SimpleDateFormat(yyyyMMdd)设置日期格式
String datetime dfformat(new Date()) new Date()获取前系统时间
String sql update expertablesubmit set FileRoad＇+path+＇Status＇＇UpfileDate＇+datetime
+＇FileName＇+upfilename+＇ where ExperimentID＇+experid+＇ and StudentID＇+ServletActionContextgetRequest()getSession()getAttribute(userId)+＇
stratconnprepareStatement(sql)
int n stratexecuteUpdate()
if(n>0){
return success
}
return false
}

public String teaSaveFileRoad(String experid String path String courid)
throws Exception {
TODO Autogenerated method stub
String sql update expercontenttable set Templetfile＇+path+＇ where ExperimentID＇+experid+＇ and CourseID＇+courid+＇
stratconnprepareStatement(sql)
int n stratexecuteUpdate()
if(n>0){
return success
}
return false
}



}
package comxzitentity

public class Experclass {

private int Eid
private String courseID
private String courseName
private String courseTime
private String coursePeriod课程学时

private int experimentNum
private String teacherName
private String className


public Experclass() {
super()
}

public Experclass(int eid String courseID String courseName
String courseTime int experimentNum String teacherName
String className) {
super()
Eid eid
thiscourseID courseID
thiscourseName courseName
thiscourseTime courseTime
thisexperimentNum experimentNum
thisteacherName teacherName
thisclassName className
}
public Experclass(int eid String courseID String courseName
String courseTime String coursePeriod int experimentNum
String teacherName String className) {
super()
Eid eid
thiscourseID courseID
thiscourseName courseName
thiscourseTime courseTime
thiscoursePeriod coursePeriod
thisexperimentNum experimentNum
thisteacherName teacherName
thisclassName className
}

public String getCoursePeriod() {
return coursePeriod
}

public void setCoursePeriod(String coursePeriod) {
thiscoursePeriod coursePeriod
}
public String getCourseID() {
return courseID
}
public void setCourseID(String courseID) {
thiscourseID courseID
}
public String getCourseName() {
return courseName
}
public void setCourseName(String courseName) {
thiscourseName courseName
}
public String getCourseTime() {
return courseTime
}
public void setCourseTime(String courseTime) {
thiscourseTime courseTime
}
public int getExperimentNum() {
return experimentNum
}
public void setExperimentNum(int experimentNum) {
thisexperimentNum experimentNum
}
public String getTeacherName() {
return teacherName
}
public void setTeacherName(String teacherName) {
thisteacherName teacherName
}
public String getClassName() {
return className
}
public void setClassName(String className) {
thisclassName className
}





}
package comxzitdaoimpl

import javasqlConnection
import javasqlPreparedStatement
import javasqlResultSet
import javautilArrayList
import javautilHashMap
import javautilList
import javautilMap

import orgapachestruts2ServletActionContext

import comxzitdaoExperclassDao
import comxzitentityExperContent
import comxzitentityExperclass
import comxzitutilDBConnection
import comxzitutilDataGrid

public class ExperclassDaoimpl extends BaseDao implements ExperclassDao {

private String CourseTime

public ExperclassDaoimpl() throws Exception {
TODO Autogenerated constructor stub
}

private Connection connnew DBConnection()getConn()
private PreparedStatement stratnull

public DataGrid> experclass(String coursetime)
throws Exception {

DataGrid> dg
new DataGrid>()
分页信息
String _page ServletActionContextgetRequest()getParameter(page)
int page IntegerparseInt(_pagenull1_page)
String _rows ServletActionContextgetRequest()getParameter(rows)
int rows IntegerparseInt(_rowsnull20_rows)

String sqlselect * from experclasstable where CourseTime＇+coursetime+＇ and TeacherID＇+
ServletActionContextgetRequest()getSession()getAttribute(TeaId)+＇

String sql select CourseIDCourseNameCourseTimeCoursePeriodExperimentNumTeacherNameClassName from experclasstable where CourseTime＇+courseTime+＇ and ClassName＇+
ServletActionContextgetRequest()getSession()getAttribute(userclassname)+＇
Systemoutprintln(sql+sql)
List> datamap superlistMapList(sql pagerows)
dgsetRows(datamap)
String countSQL select count(*) from experclasstable where CourseTime＇+coursetime+＇ and TeacherID＇+
ServletActionContextgetRequest()getSession()getAttribute(TeaId)+＇
dgsetTotal(supercount(countSQL))
return dg


}

public DataGrid> stuexperclass(String courseTime) throws Exception {
TODO Autogenerated method stub

DataGrid> dg
new DataGrid>()
分页信息
String _page ServletActionContextgetRequest()getParameter(page)
int page IntegerparseInt(_pagenull1_page)
String _rows ServletActionContextgetRequest()getParameter(rows)
int rows IntegerparseInt(_rowsnull20_rows)
String sql select CourseIDCourseNameExperimentNumTeacherName from experclasstable where CourseTime＇2014年2015年＇ and ClassName＇12计卓＇
String sql select CourseIDCourseNameCourseTimeCoursePeriodExperimentNumTeacherNameClassName from experclasstable where CourseTime＇+courseTime+＇ and ClassName＇+
ServletActionContextgetRequest()getSession()getAttribute(userclassname)+＇

List> datamap superlistMapList(sql pagerows)
dgsetRows(datamap)
String countSQL select count(*) from experclasstable where CourseTime＇+courseTime+＇ and ClassName＇+
ServletActionContextgetRequest()getSession()getAttribute(userclassname)+＇
dgsetTotal(supercount(countSQL))
return dg

}

public DataGrid> stuexperContentlist(String courseId) throws Exception {
TODO Autogenerated method stub

DataGrid> dg
new DataGrid>()
分页信息
String _page ServletActionContextgetRequest()getParameter(page)
int page IntegerparseInt(_pagenull1_page)
String _rows ServletActionContextgetRequest()getParameter(rows)
int rows IntegerparseInt(_rowsnull20_rows)
String sql select CourseIDCourseNameExperimentNumTeacherName from experclasstable where CourseTime＇2014年2015年＇ and ClassName＇12计卓＇
String sql select t1ExperimentIDt1ExperimentNameExperimentPeriodt1TeacherNamet2Statust2upfileDatet1ExperimentContent from expercontenttable as t1 join expertablesubmit as t2 on t1ExperimentIDt2ExperimentID where t1CourseID＇
+courseId+＇ and StudentID+ServletActionContextgetRequest()getSession()getAttribute(userId)
List> datamap superlistMapList(sql pagerows)
dgsetRows(datamap)
String countSQL select count(*) from expercontenttable as t1 join expertablesubmit as t2 on t1ExperimentIDt2ExperimentID where t1CourseID＇+courseId+＇ and StudentID+ServletActionContextgetRequest()getSession()getAttribute(userId)
dgsetTotal(supercount(countSQL))
return dg
}

public ExperContent queryExperContent(String experimentID) throws Exception {
TODO Autogenerated method stub

String sql select t1* from expercontenttable as t1 join expertablesubmit as t2 on t1CourseIDt2CourseID where t1ExperimentID＇+experimentID+＇ and StudentID＇+ServletActionContextgetRequest()getSession()getAttribute(userId)+＇
Systemoutprintln(sql)
stratconnprepareStatement(sql)
ResultSet rsstratexecuteQuery()
ExperContent contentnull
if(rsnext()){
contentnew ExperContent()
contentsetExperimentID(rsgetString(ExperimentID))
contentsetExperimentName(rsgetString(ExperimentName))
contentsetExperimentContent(rsgetString(ExperimentContent))
contentsetExperimentPeriod(rsgetInt(ExperimentPeriod))
contentsetTeacherName(rsgetString(TeacherName))
contentsetTempletfile(rsgetString(Templetfile))
contentsetTempletfile(upload+rsgetString(Templetfile)replace(＼＼ ))

}

return content

}

public DataGrid> getexperlist(String courseId) throws Exception {
TODO Autogenerated method stub
DataGrid> dg
new DataGrid>()
分页信息
String _page ServletActionContextgetRequest()getParameter(page)
int page IntegerparseInt(_pagenull1_page)
String _rows ServletActionContextgetRequest()getParameter(rows)
int rows IntegerparseInt(_rowsnull20_rows)
String sql select CourseIDCourseNameExperimentNumTeacherName from experclasstable where CourseTime＇2014年2015年＇ and ClassName＇12计卓＇
String sql select * from expercontenttable where CourseID＇
+courseId+＇
List> datamap superlistMapList(sql pagerows)
dgsetRows(datamap)
String countSQL select count(*) from expercontenttable where CourseID＇
+courseId+＇
dgsetTotal(supercount(countSQL))
return dg
}



public String getCourseTime() {
return CourseTime
}

public void setCourseTime(String courseTime) {
CourseTime courseTime
}





}结
学html5cssjavascriptjava ee 中jspservlet滤器监听器JSTLELjQueryAjax 
面模块进行总结：学html时没太意里面全部标签没需理解容全部属识记学时相轻松html常标签非常清楚form中十种类型常textpasswordhiddensubmitbuttonradiocheckbox等标签divtablespanselect重标签 
Css学：然说标签中定义样式做起明智学CSS时较努力样式效果测试写相应案例3月忘半时候查文档写出然CSS说必非常精通觉掌握东西越工作越轻松考试结束会前面笔记案例 
Javascript：js 认重甚超servletjsp课期间讲容较少javascript中创建象说吧应该讲3中方法然般情况觉必学样助懂写框架javascript部分学中讲dom操作觉dom操作太繁琐写代码太效率起高面讲事件事件算简单触发事件进行相应响应javascript流程控制象基语法java类似课时没讲太 
Servlet：觉较简单java代码容易理解首先讲开发环境配置安装tomcat解tomcat目录web工程目录讲servlet访问方式postget区处理中文乱码servlet中重知识点项目会遇问题乱码getpost乱码通设置request者response编码方式实现Servlet间跳转方式重定转发重定转发区现理解透彻重定获取request中参数客户端两次请求转发服务器部跳转两种设置滤器情况通滤器跳转Servlet生命周期笔试必考题实简单需理解没必死记硬背session算重知识点数存储存中购物车户信息等session设置生存时间说session必须说说四种会话踪技术cookieURL重写表单域隐藏session 
JSP：JSP实际servlet样两者侧重点JSP置象作域致样JSP中动作常操作JavaBean动作页面跳转动作包含动作里重点提两种包含区JSP讲jstlEL表达式基础应写定义标签定java基础开始太理解标签解析程例子发现定义已难 
jQuery：jQuery说中级部分学方便特选择器避免浏览器差异学jQuery想javascript获取元素仅jQuery中封装Ajax操作非常简单需封装类getpost 够省麻烦jQuery监听事件简单需标签中添加应事件动态绑定事件dom操作更方便学完Ajaxjson发现没JSP做出动态页面出会存效率问题 
总结：然说面知识部分掌握否灵活运重点学中思考问题否种解决方法 参考文献
[1]周恒王殊宇JSP项目开发全程实录[M]北京：清华学出版社 2008．
[2]张桂珠刘丽陈爱国Java面象程序设计[M]北京：北京邮电学出版社 2007．
[3]孙卫琴 TomcatJava Web开发技术详解（第2版）[M] 北京：电子工业出版社 2009
[4]李兴华 名师讲坛：Java Web开发实战典基础篇 [M] 清华学出版社 2010
[5]Jim Waldo Java The Good Parts [M] O＇Reilly Media 2010
[6] Gary Cornell Core Java Cay SHorstmann[M]北京：北京邮电出版社2008
[7] Sharon Zakhour [et al]The Java tutorial [M]北京：民邮电出版社2008
[8]刘中兵Java研究室Java高手真Java Web核心框架[M]．北京：电子工业出版社 2009
[9] 车皓阳 杨眉UML面象建模设计[M]北京民邮电出版社2009
[10]殷兆麟等Web系统技术：Java Web应技术[M]北京：国防工业出版社2008
徐zhou工程学院

文档香网(httpswwwxiangdangnet)户传

《香当网》用户分享的内容，不代表《香当网》观点或立场，请自行判断内容的真实性和可靠性！
该内容是文档的文本内容，更好的格式请下载文档