數(shù)據(jù)庫課程設(shè)計報告--設(shè)備管理系統(tǒng)

1、景德鎮(zhèn)陶瓷學(xué)院科技藝術(shù)學(xué)院工程系數(shù)據(jù)庫課程設(shè)計報告設(shè)備管理系統(tǒng)專 業(yè)： 計算機科學(xué)與技術(shù) 班 級： 10計科 學(xué) 號： 201030457135 姓 名： 劉世雨 指導(dǎo)教師： 何福保、胡開華 2012年12月10日一、 系統(tǒng)功能： 通過對某企業(yè)或單位設(shè)備管理相關(guān)流程進行分析，完成具有對設(shè)備進行基本信息管理和信息檢索等基本功能的設(shè)備管理系統(tǒng)的分析、設(shè)計與實現(xiàn)。 在這個設(shè)備管理系統(tǒng)中，基本做到了指導(dǎo)老師要求的“增、刪、改”。 對于實驗指導(dǎo)書要求的六大項，因為個人學(xué)業(yè)水平有限，所以暫時才完成了以下四項： 1、實現(xiàn)設(shè)備的錄入、刪除、修改等基本操作。 2、實現(xiàn)國家標準設(shè)備代碼的維護。 3、能夠?qū)υO(shè)備進行

2、方便的檢索。 4、能夠輸出設(shè)備分類明細表。用戶表：管理員表：設(shè)備管理表：設(shè)備信息表：瀏覽器中數(shù)據(jù)庫預(yù)覽截圖：2、 設(shè)備管理流程圖：驗證信息管理員管理員信息修改倉庫信息查詢折舊管理增刪改信息處理密碼信息處理結(jié)果處理結(jié)果設(shè)備管理信息設(shè)備管理設(shè)備操作信息商品銷售信息處理結(jié)果處理結(jié)果入庫信息打印信息商品銷售信息用戶身份驗證管理員信息驗證信息用戶相關(guān)設(shè)備操作身份驗證收銀信息管理員信息修改密碼信息處理結(jié)果管理員信息成功庫存信息用戶信息銷售信息三、功能界面設(shè)計1、系統(tǒng)登錄界面源代碼：if (DropDownList1.SelectedValue = "管理員") if (TextBox1

3、.Text = "" | TextBox2.Text = "") Label1.Text = "用戶名和密碼不能為空。" else string sql; string DBName = ConfigurationManager.AppSettings.Get("DBName").ToString(); /從配置文件中得到數(shù)據(jù)庫驅(qū)動 string DBDriver = ConfigurationManager.AppSettings.Get("DBDriver").ToString(); /得到

4、數(shù)據(jù)庫連接字符串 string DBConnectionString = DBDriver + HttpContext.Current.Server.MapPath(HttpContext.Current.Request.ApplicationPath + "/App_Data/") + DBName; /建立數(shù)據(jù)庫連接對象 OleDbConnection OleDbConn = new OleDbConnection(DBConnectionString); OleDbConn.Open(); /sql = "select * from 用戶表 where 用戶

5、名='kaihua' and 密碼='kaihua'"/建立sql查詢語句 sql = "select * from 管理員表 where 用戶名='" + TextBox1.Text.Trim() + "' and 密碼='" + TextBox2.Text.Trim() + "'"/建立sql查詢語句 OleDbCommand cmd = new OleDbCommand(sql, OleDbConn); /執(zhí)行SQL查詢語句 OleDbDataReader

6、 mydata = cmd.ExecuteReader(); if (mydata.Read() /判斷查詢結(jié)果是否為空 /this.Label1.Text = "登入成功！" /Session"username" = this.username.Text; Response.Redirect("zhuye.aspx"); else this.Label1.Text = "用戶不存在，請檢測用戶名和密碼是否正確！" else if (DropDownList1.SelectedValue = "用戶&qu

7、ot;) if (TextBox1.Text = "" | TextBox2.Text = "") Label1.Text = "賬號和密碼不能為空。" else string sql; string DBName = ConfigurationManager.AppSettings.Get("DBName").ToString(); /從配置文件中得到數(shù)據(jù)庫驅(qū)動 string DBDriver = ConfigurationManager.AppSettings.Get("DBDriver")

8、.ToString(); /得到數(shù)據(jù)庫連接字符串 string DBConnectionString = DBDriver + HttpContext.Current.Server.MapPath(HttpContext.Current.Request.ApplicationPath + "/App_Data/") + DBName; /建立數(shù)據(jù)庫連接對象 OleDbConnection OleDbConn = new OleDbConnection(DBConnectionString); OleDbConn.Open(); /sql = "select * f

9、rom 用戶表 where 用戶名='kaihua' and 密碼='kaihua'"/建立sql查詢語句 sql = "select * from 用戶表 where 用戶名='" + TextBox1.Text.Trim() + "' and 密碼='" + TextBox2.Text.Trim() + "'"/建立sql查詢語句 OleDbCommand cmd = new OleDbCommand(sql, OleDbConn); /執(zhí)行SQL查詢語句

10、OleDbDataReader mydata = cmd.ExecuteReader(); if (mydata.Read() /判斷查詢結(jié)果是否為空 /this.Label1.Text = "登入成功！" /Session"username" = this.username.Text; Response.Redirect("zhuye.aspx"); else this.Label1.Text = "用戶不存在，請檢測用戶名和密碼是否正確！"2、增刪改信息：增加源代碼： if (this.TextBox10.Te

11、xt = "" | this.TextBox11.Text = "" | this.TextBox12.Text = "" | this.TextBox13.Text = "" |this.TextBox14.Text = "" | this.TextBox15.Text = "") Response.Write("<script language=javascript>alert('帶*號的信息為必填。')</script>

12、"); 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.Applicatio

13、nPath + "/App_Data/") + DBName; OleDbConnection con = new OleDbConnection(DBConnectionString); OleDbCommand cmd = con.CreateCommand(); cmd.CommandText = "insert into 設(shè)備信息表(設(shè)備編號,設(shè)備名,廠商,倉庫號,數(shù)量,備注) values('" + this.TextBox10.Text + "','" + this.TextBox11.Text +

14、 "','" + this.TextBox12.Text + "','" + this.TextBox13.Text + "','" + this.TextBox14.Text + "','" + this.TextBox15.Text + "')" cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); GridViewBind(); pr

15、otected void Button3_Click(object sender, EventArgs e) TextBox10.Text = "" TextBox11.Text = "" TextBox12.Text = "" TextBox13.Text = "" TextBox14.Text = "" TextBox15.Text = ""刪除源代碼： string cid = GridView1.DataKeyse.RowIndex.Values0.ToString(

16、); string SqlStr = "delete from 設(shè)備信息表 where 設(shè)備編號='" + cid + " '" string DBName = ConfigurationManager.AppSettings.Get("DBName").ToString(); /從配置文件中得到數(shù)據(jù)庫驅(qū)動 string DBDriver = ConfigurationManager.AppSettings.Get("DBDriver").ToString(); /得到數(shù)據(jù)庫連接字符串 string

17、 DBConnectionString = DBDriver + HttpContext.Current.Server.MapPath(HttpContext.Current.Request.ApplicationPath + "/App_Data/") + DBName; /建立數(shù)據(jù)庫連接對象 OleDbConnection conn = new OleDbConnection(DBConnectionString); conn.Open(); /OleDbConnection conn = new OleDbConnection(System.Configuration

18、.ConfigurationManager.ConnectionStrings1.ConnectionString); /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.Clos

19、e(); GridView1.EditIndex = -1; GridViewBind();修改源代碼： /string Cid = (TextBox)GridView1.Rowse.RowIndex.Cells0.Controls0).Text.ToString(); string Cid = GridView1.DataKeyse.RowIndex.Values0.ToString(); /string Cname = GridView1.DataKeyse.RowIndex.Values0.ToString(); string Cname = (TextBox)GridView1.Row

20、se.RowIndex.Cells1.Controls0).Text.ToString(); string Cadress = (TextBox)GridView1.Rowse.RowIndex.Cells2.Controls0).Text.ToString(); string Positions = (TextBox)GridView1.Rowse.RowIndex.Cells3.Controls0).Text.ToString(); string Cphone = (TextBox)GridView1.Rowse.RowIndex.Cells4.Controls0).Text.ToStri

21、ng(); string Cgrade = (TextBox)GridView1.Rowse.RowIndex.Cells5.Controls0).Text.ToString(); /string Cname = (TextBox)GridView1.Rowse.RowIndex.FindControl("Cname").Text; /string Cadress = (TextBox)GridView1.Rowse.RowIndex.FindControl("Cadress").Text; /string Position = (TextBox)Gri

22、dView1.Rowse.RowIndex.FindControl("Position").Text; /string Cphone = (TextBox)GridView1.Rowse.RowIndex.FindControl("Cphone").Text; /string Cgrade = (TextBox)GridView1.Rowse.RowIndex.FindControl("Cgrade").Text; string DBName = ConfigurationManager.AppSettings.Get("D

23、BName").ToString(); /從配置文件中得到數(shù)據(jù)庫驅(qū)動 string DBDriver = ConfigurationManager.AppSettings.Get("DBDriver").ToString(); /得到數(shù)據(jù)庫連接字符串 string DBConnectionString = DBDriver + HttpContext.Current.Server.MapPath(HttpContext.Current.Request.ApplicationPath + "/App_Data/") + DBName; /建立數(shù)據(jù)

24、庫連接對象 OleDbConnection conn = new OleDbConnection(DBConnectionString); conn.Open(); string SqlStr = "update 設(shè)備信息表 set 設(shè)備名='" + Cname + "',廠商='" + Cadress + "',倉庫號='" + Positions + "',數(shù)量='" + Cphone + "',備注='" + Cgra

25、de + "' where 設(shè)備編號='" + Cid + "'" /string SqlStr = "update company set Cname='111',Positions='1111'where Cid='as'"源代碼：mpmenu1=new mMenu('用戶相關(guān)','','self','','','','');mpmenu1.addI

26、tem(new mMenuItem(' 用戶注冊','yonghuzhuce.aspx','it',false,'用戶登錄',null,'','','','');mpmenu1.addItem(new mMenuItem(' 密碼修改','mimaxiugai.aspx','it',false,'用戶登錄',null,'','','','')

27、;mpmenu2=new mMenu('設(shè)備操作','','self','','','','');mpmenu2.addItem(new mMenuItem(' 增加設(shè)備','shebeicaozao.aspx','it',false,'增加設(shè)備',null,'','','','');mpmenu2.addItem(new mMenuItem(' 刪

28、除設(shè)備','shebeicaozao.aspx','it',false,'刪除設(shè)備',null,'','','','');mpmenu2.addItem(new mMenuItem(' 修改設(shè)備','shebeicaozao.aspx','it',false,'修改設(shè)備',null,'','','','');mpmenu2.addItem(new m

29、MenuItem(' 查找設(shè)備','shebeicaozao.aspx','it',false,'查找設(shè)備',null,'','','','');mpmenu3=new mMenu('設(shè)備管理','','self','','','','');mpmenu3.addItem(new mMenuItem(' 折舊管理','jsjjczs.

30、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,'','','',''