景德镇陶瓷学院科技艺术学院工程系数据库课程设计报告设备管理系统专业：计算机科学与技术班级：10计科学号：201030457135 姓名：刘世雨指导教师：何福保、胡开华2012年12月10日一、系统功能：通过对某企业或单位设备管理相关流程进行分析，完成具有对设备进行基本信息管理和信息检索等基本功能的设备管理系统的分析、设计与实现。

在这个设备管理系统中，基本做到了指导老师要求的“增、删、改”。

对于实验指导书要求的六大项，因为个人学业水平有限，所以暂时才完成了以下四项：1、实现设备的录入、删除、修改等基本操作。

2、实现国家标准设备代码的维护。

3、能够对设备进行方便的检索。

4、能够输出设备分类明细表。

用户表：管理员表：设备管理表：设备信息表：浏览器中数据库预览截图：二、设备管理流程图：三、功能界面设计1、系统登录界面源代码：if (DropDownList1.SelectedValue == "管理员"){if (TextBox1.Text == "" || TextBox2.Text == "")Label1.Text = "用户名和密码不能为空。

";else{string sql;string DBName = ConfigurationManager.AppSettings.Get("DBName").ToString();//从配置文件中得到数据库驱动string DBDriver = ConfigurationManager.AppSettings.Get("DBDriver").ToString();//得到数据库连接字符串string DBConnectionString = DBDriver + HttpContext.Current.Server.MapPath(HttpContext.Current.Request.ApplicationPath + "/App_Data/") + DBName;//建立数据库连接对象OleDbConnection OleDbConn = new OleDbConnection(DBConnectionString);OleDbConn.Open();//sql = "select * from 用户表where 用户名='kaihua' and 密码='kaihua'";//建立sql查询语句sql = "select * from 管理员表where 用户名='" + TextBox1.T ext.Trim() + "' and 密码='" + TextBox2.Text.Trim() + "'";//建立sql查询语句OleDbCommand cmd = new OleDbCommand(sql, OleDbConn); //执行SQL查询语句OleDbDataReader mydata = cmd.ExecuteReader();if (mydata.Read()) //判断查询结果是否为空{//bel1.Text = "登入成功！";//Session["username"] = ername.Text;Response.Redirect("zhuye.aspx");}else{bel1.Text = "用户不存在，请检测用户名和密码是否正确！";}}}else if (DropDownList1.SelectedValue == "用户"){if (TextBox1.Text == "" || TextBox2.Text == "")Label1.Text = "账号和密码不能为空。

";else{string sql;string DBName = ConfigurationManager.AppSettings.Get("DBName").ToString();//从配置文件中得到数据库驱动string DBDriver = ConfigurationManager.AppSettings.Get("DBDriver").ToString();//得到数据库连接字符串string DBConnectionString = DBDriver + HttpContext.Current.Server.MapPath(HttpContext.Current.Request.ApplicationPath + "/App_Data/") + DBName;//建立数据库连接对象OleDbConnection OleDbConn = new OleDbConnection(DBConnectionString);OleDbConn.Open();//sql = "select * from 用户表where 用户名='kaihua' and 密码='kaihua'";//建立sql查询语句sql = "select * from 用户表where 用户名='" + TextBox1.T ext.Trim() + "' and 密码='" + TextBox2.Text.Trim() + "'";//建立sql查询语句OleDbCommand cmd = new OleDbCommand(sql, OleDbConn); //执行SQL查询语句OleDbDataReader mydata = cmd.ExecuteReader();if (mydata.Read()) //判断查询结果是否为空{//bel1.Text = "登入成功！";//Session["username"] = ername.Text;Response.Redirect("zhuye.aspx");}else{bel1.Text = "用户不存在，请检测用户名和密码是否正确！";2、增删改信息：增加源代码：if(this.TextBox10.Text == ""|| this.TextBox11.T ext == ""|| this.TextBox12.Text == ""|| this.TextBox13.Text == "" ||this.TextBox14.T ext == "" || this.TextBox15.Text == ""){Response.Write("<script language=javascript>alert('带*号的信息为必填。

')</script>");}else{string DBName = ConfigurationManager.AppSettings.Get("DBName").ToString();string DBDriver = ConfigurationManager.AppSettings.Get("DBDriver").ToString();string DBConnectionString = DBDriver + HttpContext.Current.Server.MapPath(HttpContext.Current.Request.ApplicationPath + "/App_Data/") + DBName;OleDbConnection con = new OleDbConnection(DBConnectionString);OleDbCommand cmd = con.CreateCommand();mandText = "insert into 设备信息表(设备编号,设备名,厂商,仓库号,数量,备注) values('" + this.TextBox10.Text + "','" + this.TextBox11.T ext + "','" + this.TextBox12.Text + "','" + this.TextBox13.Text + "','" + this.TextBox14.T ext + "','" + this.TextBox15.T ext + "')";cmd.Connection = con;con.Open();cmd.ExecuteNonQuery();con.Close();GridViewBind();}}protected void Button3_Click(object sender, EventArgs e){TextBox10.Text = "";TextBox11.Text = "";TextBox12.Text = "";TextBox13.Text = "";TextBox14.Text = "";TextBox15.Text = "";删除源代码：string cid = GridView1.DataKeys[e.RowIndex].Values[0].ToString();string SqlStr = "delete from 设备信息表where 设备编号='" + cid + " '";string DBName = ConfigurationManager.AppSettings.Get("DBName").T oString();//从配置文件中得到数据库驱动string DBDriver = ConfigurationManager.AppSettings.Get("DBDriver").ToString();//得到数据库连接字符串string DBConnectionString = DBDriver + HttpContext.Current.Server.MapPath(HttpContext.Current.Request.ApplicationPath + "/App_Data/") + DBName;//建立数据库连接对象OleDbConnection conn = new OleDbConnection(DBConnectionString);conn.Open();//OleDbConnection conn = new OleDbConnection(System.Configuration.ConfigurationManager.ConnectionStrings[1].Connectio nString);//conn.Open();//OleDbConnection conn = new OleDbConnection(DBConnectionString);//conn.Open();OleDbCommand comm = new OleDbCommand(SqlStr, conn);comm.ExecuteNonQuery();comm.Dispose();if (conn.State.ToString() == "Open") conn.Close();GridView1.EditIndex = -1;GridViewBind();修改源代码：//string Cid = ((TextBox)GridView1.Rows[e.RowIndex].Cells[0].Controls[0]).Text.ToString();string Cid = GridView1.DataKeys[e.RowIndex].Values[0].ToString();//string Cname = GridView1.DataKeys[e.RowIndex].Values[0].ToString();string Cname = ((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text.ToString();string Cadress = ((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text.ToString();string Positions = ((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text.ToString();string Cphone = ((TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[0]).Text.ToString();string Cgrade = ((TextBox)GridView1.Rows[e.RowIndex].Cells[5].Controls[0]).Text.ToString();//string Cname = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("Cname")).Text;//string Cadress = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("Cadress")).Text;//string Position = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("Position")).Text;//string Cphone = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("Cphone")).Text;//string Cgrade = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("Cgrade")).T ext;string DBName = ConfigurationManager.AppSettings.Get("DBName").T oString();//从配置文件中得到数据库驱动string DBDriver = ConfigurationManager.AppSettings.Get("DBDriver").ToString();//得到数据库连接字符串string DBConnectionString = DBDriver + HttpContext.Current.Server.MapPath(HttpContext.Current.Request.ApplicationPath + "/App_Data/") + DBName;//建立数据库连接对象OleDbConnection conn = new OleDbConnection(DBConnectionString);conn.Open();string SqlStr = "update 设备信息表set 设备名='" + Cname + "',厂商='" + Cadress + "',仓库号='" + Positions + "',数量='" + Cphone + "',备注='" + Cgrade + "' where 设备编号='" + Cid + "'";//string SqlStr = "update company set Cname='111',Positions='1111'where Cid='as'";源代码：mpmenu1=new mMenu('用户相关','','self','','','','');mpmenu1.addItem(new mMenuItem(' 用户注册','yonghuzhuce.aspx','it',false,'用户登录',null,'','','',''));mpmenu1.addItem(new mMenuItem(' 密码修改','mimaxiugai.aspx','it',false,'用户登录',null,'','','','')); mpmenu2=new mMenu('设备操作','','self','','','','');mpmenu2.addItem(new mMenuItem(' 增加设备','shebeicaozao.aspx','it',false,'增加设备',null,'','','',''));mpmenu2.addItem(new mMenuItem(' 删除设备','shebeicaozao.aspx','it',false,'删除设备',null,'','','',''));mpmenu2.addItem(new mMenuItem(' 修改设备','shebeicaozao.aspx','it',false,'修改设备',null,'','','',''));mpmenu2.addItem(new mMenuItem(' 查找设备','shebeicaozao.aspx','it',false,'查找设备',null,'','','',''));mpmenu3=new mMenu('设备管理','','self','','','','');mpmenu3.addItem(new mMenuItem(' 折旧管理','jsjjczs.aspx','blank',false,'折旧管理',null,'','','','')); mpmenu3.addItem(new mMenuItem(' 维修管理','windowsjc.aspx','blank',false,'维修管理',null,'','','',''));mpmenu4=new mMenu('信息查询','','self','','','','');mpmenu4.addItem(new mMenuItem('仓库信息查询','cangkuxinxichaxun.aspx','it',false,'仓库信息查询',null,'','','',''));mpmenu4.addItem(new mMenuItem(' 设备信息查询','shebeixinxichaxun.aspx','it',false,'设备信息查询',null,'','','',''));mpmenu5=new mMenu('管理简介','','self','','','','');mpmenu5.addItem(new mMenuItem('设备管理简介','shenbeiguanlijianjie.aspx','it',false,'仓库信息查询',null,'','','',''));二、课程设计总结这次课程设计使我熟悉了系统设计的整体步骤。