软件工程实验报告

1、湖北第二师范学院实验报告书课程名: 软件工程 题 目： 软件工程实验报告班 级： 计算机应用技术2班学 号： 姓 名： 张波 数据流图总数据图： 细化后数据流图： 数据字典名字：教师开课信息别名：描述：教师开的教学课程和网络课程定义：信息=教师信息+开课班级信息名字：学生选课信息别名：描述：学生选了某一门课程才能登陆到该课程班级定义：信息=学生信息+教师信息+开课班级信息 名字：成绩别名：分数描述：学生作业批改的结果供学生和学校参考定义：成绩=0数字100 E-R图作业提交系统注册登录密码找回学生用户登录教师用户登录管理员用户登录查看成绩打包下载作业发布修改作业添加班级添加用户数据库管理上传作

2、业下载作业查看作业发布修改成绩删除作业添加专业通用模板修改密码查看个人资料注销系统系统功能体系图数据库设计数据库图编码和测试系统运行资源管理图登录界面及编码屏幕切换编码： if (self != top) top.location = self.location; function switchSysBar() if (switchPoint.innerHTML = <) switchPoint.innerHTML = > document.getElementById(frmTitle).style.display = none; else switchPoint.innerHT

3、ML = < document.getElementById(frmTitle).style.display = block; function changeMainFrameSrc(url) /alert(url); document.getElementById(mainFrame).src = url; < 屏幕切换 if (window.screen.width 1024) switchSysBar() 管理员添加用户界面及编码protected void b_register_Click(object sender, EventArgs e) string user =

4、; string scmd=; if (r_admin.Checked = true) user = admin; scmd = string.Format(insert into admin(username,adminid,password,name) values (0,1,2,3);,t_username.Text.ToString(),t_id.Text.ToString(),t_id.Text.ToString(),t_name.Text.ToString(); else if (r_student.Checked = true) user = student; scmd = st

5、ring.Format(insert into student(username,stuid,password,stuname,sex,grade,class) values (0,1,2,3,4,5,6);,t_username.Text.ToString(), t_id.Text.ToString(), t_id.Text.ToString(), t_name.Text.ToString(),t_sex.Text.ToString(), t_grade.Text.ToString(), t_class.Text.ToString(); else user = teacher; scmd =

6、 string.Format(insert into teacher(username,teaid,password,teaname,sex,fuction) values (0,1,2,3,4,5);,t_username.Text.ToString(), t_id.Text.ToString(), t_id.Text.ToString(),t_name.Text.ToString(),t_sex.Text.ToString(), t_fuction.Text.ToString(); if (t_id.Text.ToString() = ) Page.ClientScript.Registe

7、rStartupScript(Page.GetType(), , string.Format(alert(请输入用户名！);); else if (t_name.Text.ToString() = ) Page.ClientScript.RegisterStartupScript(Page.GetType(), , string.Format(alert(请输入姓名！);); else string sconn = server=(local)SQLEXPRESS;database=homework;Trusted_Connection=True; SqlConnection conn = n

8、ew SqlConnection(sconn); conn.Open(); SqlCommand cmd = new SqlCommand(scmd, conn); cmd.ExecuteNonQuery(); conn.Close(); Page.ClientScript.RegisterStartupScript(Page.GetType(), , string.Format(alert(添加成功！);); Response.Redirect(admin.aspx); 教师发布修改作业界面及编码protected void Page_Load(object sender, EventArg

9、s e) if (Sessionusername = null) Response.Redirect(menus.htm); else teachername = Sessionusername.ToString(); SetBind(); private void SetBind() DataSet ds = new DataSet(); string sconn = server=(local)SQLEXPRESS;database=homework;Trusted_Connection=True; SqlConnection conn = new SqlConnection(sconn)

10、; SqlDataAdapter da = new SqlDataAdapter(string.Format(select ID,title,num,conten from work where teaname=0, teachername), conn); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); conn.Close(); protected void b_addhomework_Click(object sender, EventArgs e) string path = string.Format(/wo

11、rk/0,t_addhomework.Text.ToString();/目录在E盘 if (!Directory.Exists(path) string sconn = server=(local)SQLEXPRESS;database=homework;Trusted_Connection=True; SqlConnection conn = new SqlConnection(sconn); conn.Open(); string scmd=string.Format(insert work(title,teaname,num,conten) values(0,1,0,2),t_addho

12、mework.Text.ToString(),teachername,TextBox1.Text.ToString(); SqlCommand cmd = new SqlCommand(scmd,conn); cmd.ExecuteNonQuery(); conn.Close(); Directory.CreateDirectory(path); Page.ClientScript.RegisterStartupScript(Page.GetType(), , string.Format(alert(添加成功！);); else Page.ClientScript.RegisterStartu

13、pScript(Page.GetType(), , string.Format(alert(已经有该作业文档，请重新命名！);); protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) if (e.CommandName = Select) int iIndex = Convert.ToInt16(e.CommandArgument); string title = GridView1.DataKeysiIndex.Value.ToString(); Response.Redirect(st

14、ring.Format(showwork.aspx?title=0, title); protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) int iIndex = Convert.ToInt16(e.RowIndex); string ID = GridView1.DataKeysiIndex.Value.ToString(); string sconn = server=(local)SQLEXPRESS;database=homework;Trusted_Connection=True

15、; SqlConnection conn = new SqlConnection(sconn); string scmd = string.Format(delete from work where title=0,ID); conn.Open(); SqlCommand cmd = new SqlCommand(scmd, conn); cmd.ExecuteNonQuery(); conn.Close(); SetBind(); Page.ClientScript.RegisterStartupScript(Page.GetType(), , string.Format(alert(删除成

16、功！););教师批量下载作业界面及编码protectedvoidButton2_Click(objectsender,EventArgse)hello();stringstrtxtPath=strFileUploadPath;stringstrzipPath=strFileUploadPath+free.zip;System.Diagnostics.ProcessProcess1=newSystem.Diagnostics.Process();Process1.StartInfo.FileName=Winrar.exe;Process1.StartInfo.CreateNoWindow=tru

17、e;/压缩c:freezipfree.txt(即文件夹及其下文件freezipfree.txt)/到c:freezipfree.rar/strzipPath=C:freezipfree;/设置压缩方式为.zipProcess1.StartInfo.Arguments=a-afzip+strzipPath+strtxtPath;/3Process1.Start();if(Process1.HasExited)intiExitCode=Process1.ExitCode;if(iExitCode=0)Response.Write(iExitCode.ToString()+正常完成);elseRes

18、ponse.Write(iExitCode.ToString()+有错完成);学生上传作业界面及编码privatevoidhello()strFileUploadPath=string.Format(D:work0,title);stringID=Request.QueryStringID.ToString();SqlConnectionconn=newSqlConnection(server=(local)SQLEXPRESS;database=homework;Trusted_Connection=True);conn.Open();SqlCommandcmd=newSqlCommand(

19、string.Format(select*fromworkwhereID=0,ID),conn);SqlDataReaderread=cmd.ExecuteReader();read.Read();teacher=readteaname.ToString();title=readtitle.ToString();conn.Close();privatevoidInitFileList()hello();strFileUploadPath=string.Format(D:work0,title);/组合成物理路径file:/D:homeworkpic/stringstrFilePath=Serv

20、er.MapPath(strFileUploadPath);/读取文件夹下所有文件FileInfoarrFiles=newDirectoryInfo(strFileUploadPath).GetFiles();/把文件名逐一添加到列表框控件控件foreach(FileInfofiinarrFiles)lb_FileList.Items.Add(fi.Name);privatevoidInitUploadLimit()/从config中读取上传文件类型限制并根据逗号分割成字符串数组stringarrFileTypeLimit=ConfigurationManager.AppSettingsFil

21、eTypeLimit.ToString().Split(,);/从config中读取上传文件大小限制doubleiFileSizeLimit=Convert.ToInt32(ConfigurationManager.AppSettingsFileSizeLimit);/遍历字符串数组把所有项加入项目编号控件for(inti=0;iarrFileTypeLimit.Length;i+)bl_FileTypeLimit.Items.Add(arrFileTypeLimiti.ToString();/把文件大小限制赋值给标签lab_FileSizeLimit.Text=string.Format(0

22、:f2M,iFileSizeLimit/1024);hello();strFileUploadPath=string.Format(D:work0,title);intitemNo=(Int16)(lb_FileList.Items.Count-1);doListItemitem;item=lb_FileList.ItemsitemNo;if(lb_FileList.ItemsitemNo.Selected)stringstrFileName=lb_FileList.SelectedValue;/组合成物理路径stringstrFilePhysicalPath=strFileUploadPat

23、h+strFileName;Response.Clear();Response.ContentType=application/octet-stream;Response.AddHeader(Content-Disposition,attachment;FileName=+HttpUtility.UrlEncode(strFileName,System.Text.Encoding.UTF8);Response.WriteFile(strFilePhysicalPath);Response.End();数据库类编码hello();/判断用户是否选择了文件if(FileUpload.HasFile

24、)/调用自定义方法判断文件类型是否符合要求if(IsAllowableFileType()/调用自定义方法判断文件大小是否符合要求if(IsAllowableFileSize()if(FileUpload.HasFile)strFileUploadPath=string.Format(D:work0,title);stringfilename=FileUpload.FileName;stringfilenewname=SessionID.ToString();stringfileext=Path.GetExtension(filename);stringstrFileName=Server.M

25、apPath(filenewname+fileext);FileUpload.SaveAs(strFileUploadPath+filenewname+fileext);SqlConnectionconn=newSqlConnection(server=(local)SQLEXPRESS;database=homework;Trusted_Connection=True);conn.Open();SqlCommandcmd1=newSqlCommand(string.Format(select*fromstudentwhereusername=0,Sessionusername.ToStrin

26、g(),conn);SqlDataReaderread1=cmd1.ExecuteReader();read1.Read();stringstuid=read1stuid.ToString();stringstuname=read1stuname.ToString();read1.Close();SqlCommandcmd2=newSqlCommand(string.Format(select*fromteacherwhereteaname=0,teacher),conn);SqlDataReaderread2=cmd2.ExecuteReader();read2.Read();stringteaid=read2teaid.ToString();stringteaname=read2teaname.ToString();read2.Close();SqlCommandcmd3=newSqlCommand(string.Format(insertintohomework(title,stuname,teaname,stuid,teaid,mark)values(0,1,2,3,4,0),title,stuname,teaname,stuid,