數(shù)據(jù)庫系統(tǒng)設(shè)計(jì)實(shí)驗(yàn)報(bào)告

1、-. z.數(shù)據(jù)庫系統(tǒng)設(shè)計(jì)實(shí)驗(yàn)報(bào)告 課程：數(shù)據(jù)庫系統(tǒng)原理與應(yīng)用: *晨 專業(yè)：13級(jí)計(jì)本班 *：9 指導(dǎo)教師：王端理一 數(shù)據(jù)庫系統(tǒng)設(shè)計(jì)一、實(shí)驗(yàn)?zāi)康恼莆諗?shù)據(jù)庫設(shè)計(jì)的根本技術(shù)，熟悉數(shù)據(jù)庫設(shè)計(jì)的每個(gè)步驟中的任務(wù)和實(shí)施方法，并加深對(duì)數(shù)據(jù)庫系統(tǒng)概念和特點(diǎn)的理解。二、實(shí)驗(yàn)內(nèi)容設(shè)計(jì)一個(gè)簡單的客戶點(diǎn)餐數(shù)據(jù)庫應(yīng)用系統(tǒng)，完成設(shè)計(jì)報(bào)告。重點(diǎn)為數(shù)據(jù)庫系統(tǒng)構(gòu)造特性設(shè)計(jì)局部，包括需求分析、概念設(shè)計(jì)和邏輯設(shè)計(jì)。三、實(shí)驗(yàn)原理、方法利用數(shù)據(jù)庫設(shè)計(jì)的4個(gè)階段：需求分析(分析用戶要求)、概念設(shè)計(jì)(信息分析和定義)、邏輯設(shè)計(jì)(設(shè)計(jì)實(shí)現(xiàn))和物理設(shè)計(jì)(物理數(shù)據(jù)庫設(shè)計(jì))。概念模型設(shè)計(jì)時(shí)采用自底向上的方法，即自頂向下地進(jìn)展需求分析，然后再自底

2、向上地設(shè)計(jì)概念構(gòu)造，和自底向上的設(shè)計(jì)方法。四、實(shí)驗(yàn)步驟1、系統(tǒng)需求分析1.1操作環(huán)境與軟件 操作環(huán)境：Windows 7 數(shù)據(jù)庫軟件：SQL server 2008 系統(tǒng)編輯軟件：VS2010 1.2系統(tǒng)設(shè)計(jì)與功能分析 系統(tǒng)設(shè)計(jì)：本系統(tǒng)用于客戶與訂單在點(diǎn)餐上的聯(lián)系信息功能分析：用于輸入和查詢客戶的點(diǎn)餐情況和餐廳的菜單信息2、概念構(gòu)造設(shè)計(jì)E-R圖性別聯(lián)系*地址密碼價(jià)格備注用戶名客戶剩余量菜名登錄客戶評(píng)價(jià)配送狀態(tài)配送點(diǎn)餐菜單訂餐訂單號(hào)訂單信息客戶訂單點(diǎn)餐數(shù)量*菜名聯(lián)系送餐地址餐廳后臺(tái)管理訂單配送信息配送信息管理用戶更新菜單用戶名后臺(tái)管理員密碼備注3、邏輯構(gòu)造設(shè)計(jì) 3.1 管理員表FieldType

3、keyNULL用戶名nchar(10) PRINO密碼Nchar(6)NO備注Yes 3.2用戶表FieldTypekeyNULL用戶名nchar(10)PRINO密碼Nchar(6)NOnchar(10)NO性別nchar(1)NOnchar(11)NO地址nvarchar(50)NO備注nvarchar(50)Yes 3.3菜單表FieldTypekeyNULL菜名nchar(10)PRINO價(jià)格moneyNO剩余量intNO客戶評(píng)價(jià)nvarchar(50)Yes3.4 訂單表FieldTypekeyNULL訂單號(hào)intPRINO菜名nchar(10)NO點(diǎn)餐數(shù)量intNOnchar(10

4、)NO地址nvarchar(50)NO4、主要步驟登錄窗體： 驗(yàn)證用戶登錄 定義一個(gè)連接數(shù)據(jù)庫的類：class Class1 publicstatic DataRow login;publicstaticbool isman;publicstaticvoid checkuser(string 用戶名, string 密碼) SqlConnection = new SqlConnection(Properties.Settings.Default.*kSetting); SqlDataAdapter da = new SqlDataAdapter(SELECT * FROM guanli WHE

5、RE 用戶名=用戶名 AND 密碼=密碼,); da.Selectmand.Parameters.Add(用戶名, SqlDbType.NVarChar, 10).Value = 用戶名; da.Selectmand.Parameters.Add(密碼, SqlDbType.NVarChar, 6).Value = 密碼; DataSet ds = new DataSet(); da.Fill(ds);if (ds.Tables0.Rows.Count 0) login = ds.Tables0.Rows0; isman = true; else login = null; publicsta

6、ticvoid yonghu(string *inmin, string 密碼) SqlConnection = new SqlConnection(Properties.Settings.Default.*kSetting); SqlDataAdapter da = new SqlDataAdapter(SELECT * FROM yonghu WHERE *inmin=*inmin AND 密碼=密碼,); da.Selectmand.Parameters.Add(*inmin, SqlDbType.NVarChar, 10).Value = *inmin; da.Selectmand.P

7、arameters.Add(密碼, SqlDbType.NVarChar, 6).Value = 密碼; DataSet ds = new DataSet(); da.Fill(ds);if (ds.Tables0.Rows.Count 0) login = ds.Tables0.Rows0; isman = true; else login = null; 輸入用戶名和密碼，選擇管理員選項(xiàng)，點(diǎn)擊登錄：驗(yàn)證代碼如下：public Form1() Initializeponent(); privatevoid button1_Click(object sender, EventArgs e) i

8、f(checkBo*1.Checked)Class1.checkuser(te*tBo*1.Te*t,te*tBo*2.Te*t);elseClass1.yonghu(te*tBo*1.Te*t,te*tBo*2.Te*t);if (Class1.login = null)MessageBo*.Show(密碼錯(cuò)誤, 登錄, MessageBo*Buttons.OK, MessageBo*Icon.Information);else Close();P = te*tBo*1.Te*t; privatevoid button3_Click(object sender, EventArgs e) C

9、lose(); privatevoid button2_Click(object sender, EventArgs e) this.te*tBo*1.Te*t = ;this.te*tBo*2.Te*t = ; privatevoid Form1_Load(object sender, EventArgs e) privatevoid button4_Click(object sender, EventArgs e) zhuce f = newzhuce(); f.Show(); 驗(yàn)證出錯(cuò)截圖：設(shè)計(jì)主窗體：主窗體代碼：public partial class Form2 : Form Dat

10、aSet ds = new DataSet(); public Form2() Initializeponent(); private void Form2_Load(object sender, EventArgs e) / TODO: 這行代碼將數(shù)據(jù)加載到表ds*k.kuaican中。您可以根據(jù)需要移動(dòng)或刪除它。 this.kuaicanTableAdapter.Fill(this.ds*k.kuaican);/ TODO: 這行代碼將數(shù)據(jù)加載到表ds*k.*ican中。您可以根據(jù)需要移動(dòng)或刪除它。 this.*icanTableAdapter.Fill(this.ds*k.*ican);

11、/ TODO: 這行代碼將數(shù)據(jù)加載到表ds*k.wodedindan中。您可以根據(jù)需要移動(dòng)或刪除它。 this.wodedindanTableAdapter.Fill(this.ds*k.wodedindan);/ TODO: 這行代碼將數(shù)據(jù)加載到表ds*k.wodedindan中。您可以根據(jù)需要移動(dòng)或刪除它。 this.wodedindanTableAdapter.Fill(this.ds*k.wodedindan);/ TODO: 這行代碼將數(shù)據(jù)加載到表ds*k.zhongcan中。您可以根據(jù)需要移動(dòng)或刪除它。 this.zhongcanTableAdapter.Fill(this.ds*

12、k.zhongcan); panel1.Visible = false; panel2.Visible = false; panel3.Visible = false; panel4.Visible = false; panel5.Visible = true; private void label1_Click(object sender, EventArgs e) private void 首頁ToolStripMenuItem_Click(object sender, EventArgs e) panel1.Visible =false; panel2.Visible =false; p

13、anel3.Visible = false; panel4.Visible = false; panel5.Visible = true; private void 退出登錄ToolStripMenuItem_Click(object sender, EventArgs e) Form1 myf = new Form1(); myf.Show(); private void 中餐ToolStripMenuItem_Click(object sender, EventArgs e) panel1.Visible = true; panel2.Visible = false; panel3.Vis

14、ible = false; panel4.Visible = false; panel5.Visible = false; private void 我的訂單ToolStripMenuItem_Click(object sender, EventArgs e) panel1.Visible = false; panel2.Visible = false; panel3.Visible = false; panel4.Visible = true; panel5.Visible = false; private void 退出登錄ToolStripMenuItem1_Click(object s

15、ender, EventArgs e) Close(); private void toolStripButton1_Click(object sender, EventArgs e) Form3 a = new Form3(); a.Show(); private void 西餐ToolStripMenuItem_Click(object sender, EventArgs e) panel1.Visible = false; panel2.Visible = true; panel3.Visible = false; panel4.Visible = false; panel5.Visib

16、le = false; private void 酒水ToolStripMenuItem_Click(object sender, EventArgs e) panel1.Visible = false; panel2.Visible = false; panel3.Visible = true; panel4.Visible = false; panel5.Visible = false; private void toolStripButton2_Click(object sender, EventArgs e) Form4 a = new Form4(); a.Show(); priva

17、te void 個(gè)人信息ToolStripMenuItem_Click(object sender, EventArgs e) Form5 a = new Form5(); a.Show(); 3建立各子窗體：菜單項(xiàng)下的子窗體顯示，我選用的是PENER控件，方便在主窗體內(nèi)刷新數(shù)據(jù)。privatevoid Form5_Load(object sender, EventArgs e) SqlDataAdapter OleDat;DataTable dt;SqlConnection = newSqlConnection(Properties.Settings.Default.*kSetting);

18、.Open(); dt = newDataTable();string mysql = select * from yonghu where 用戶名 = + P + ; OleDat = newSqlDataAdapter(mysql,); OleDat.Fill(dt);this.te*tBo*1.Te*t = dt.Rows01.ToString();this.te*tBo*2.Te*t = dt.Rows02.ToString();this.te*tBo*3.Te*t = dt.Rows03.ToString();this.te*tBo*4.Te*t = dt.Rows04.ToStri

19、ng();this.te*tBo*5.Te*t = dt.Rows05.ToString();this.te*tBo*6.Te*t = dt.Rows06.ToString();this.te*tBo*7.Te*t = dt.Rows07.ToString();創(chuàng)立數(shù)據(jù)集管理員權(quán)限：更新點(diǎn)餐菜單，管理注冊(cè)用戶代碼：public Form3() Initializeponent(); privatevoid zhongcanBindingNavigatorSaveItem_Click(object sender, EventArgs e) this.Validate();this.zhongca

20、nBindingSource.EndEdit();this.tableAdapterManager.UpdateAll(this.ds*k); privatevoid Form3_Load(object sender, EventArgs e) / TODO: 這行代碼將數(shù)據(jù)加載到表ds*k.*ican中。您可以根據(jù)需要移動(dòng)或刪除它。this.*icanTableAdapter.Fill(this.ds*k.*ican);/ TODO: 這行代碼將數(shù)據(jù)加載到表ds*k.zhongcan中。您可以根據(jù)需要移動(dòng)或刪除它。this.zhongcanTableAdapter.Fill(this.ds*

21、k.zhongcan); 管理用戶代碼：publicpartialclassForm4 : Form public Form4() Initializeponent(); privatevoid yonghuBindingNavigatorSaveItem_Click(object sender, EventArgs e) this.Validate();this.yonghuBindingSource.EndEdit();this.tableAdapterManager.UpdateAll(this.ds*k); privatevoid Form4_Load(object sender, EventArgs e) / TODO: 這行代碼將數(shù)據(jù)加載到表ds*k.yonghu中。您可以根據(jù)需要移動(dòng)或刪除它。this.yonghuTableAdapter.Fill(this.ds*k.yonghu); 注冊(cè)新用戶：驗(yàn)證注冊(cè)信息代碼：privatevoid button1_Click(object sender, EventArgs e) string 用戶名 = te*