c班級通訊錄標(biāo)準(zhǔn)管理系統(tǒng)實(shí)訓(xùn)報(bào)告

c班級通訊錄標(biāo)準(zhǔn)管理系統(tǒng)實(shí)訓(xùn)報(bào)告《C#應(yīng)用程序設(shè)計(jì)》實(shí)訓(xùn)報(bào)告系部：信息工程系班級：12軟件班姓名：陶滬指導(dǎo)教師：劉春友實(shí)訓(xùn)時(shí)間：2013年春季學(xué)期班級通訊錄管理系統(tǒng)實(shí)訓(xùn)報(bào)告一、實(shí)訓(xùn)主題班級通訊錄系統(tǒng)的開發(fā)和運(yùn)用二、實(shí)訓(xùn)時(shí)間：2013年6月1日～2013年6月27日三、實(shí)訓(xùn)目的教會(huì)學(xué)生利用Visulstatus2005開發(fā)平臺開發(fā)出班級通訊錄系統(tǒng),Framework組件實(shí)際與數(shù)據(jù)庫的連接,建立班級通訊錄的顯示，查詢，添加，修改，刪除四個(gè)功能塊窗體,，刪，改，查四項(xiàng)基本功能.四、實(shí)訓(xùn)內(nèi)容與要求：“班級通訊錄管理系統(tǒng)”是以班級學(xué)生的個(gè)人信息為主的管理系統(tǒng)，合理的數(shù)據(jù)庫結(jié)構(gòu)設(shè)計(jì)可以提高數(shù)據(jù)存儲的效率，保證數(shù)據(jù)的完整性和一致性。運(yùn)用結(jié)構(gòu)化開發(fā)方法，分析并開發(fā)一個(gè)小型、簡單的“班級通訊錄管理系統(tǒng)”。功能：設(shè)計(jì)一個(gè)班級通訊錄管理系統(tǒng)，班級通訊錄數(shù)據(jù)信息構(gòu)成內(nèi)容可自行設(shè)計(jì)（如班級、學(xué)號、姓名、性別、年齡、電話、郵政編碼、等）。要求實(shí)現(xiàn)顯示、查找、添加、刪除、修改某個(gè)記錄等功能。五、實(shí)訓(xùn)中的重要知識和方法：提供諸如SQLServer和XML這樣的數(shù)據(jù)源以及通過OLEDB和ODBC公開的數(shù)據(jù)源的一致訪問。，F(xiàn)ramework數(shù)據(jù)提供程序。這些結(jié)果或者被直接處理，DataSet對象中以便用特別的方式向用戶開放,并與來自多個(gè)源的數(shù)據(jù)組合:或者在層之間傳遞。Framework數(shù)據(jù)提供程序，用于管理應(yīng)用程序本地的數(shù)據(jù)或源自XML的數(shù)據(jù)。：.NETFramework數(shù)據(jù)提供程序和DataSet。.NETFramework數(shù)據(jù)提供程序用于連接到數(shù)據(jù)庫，執(zhí)行命令和檢索結(jié)果。DataSet可以用于多種不同的數(shù)據(jù)源，用于XML數(shù)據(jù)，或用于管理應(yīng)用程序本地的數(shù)據(jù)。DataSet包含一個(gè)或多個(gè)DataTable對象的集合，這些對象由數(shù)據(jù)行和數(shù)據(jù)列以及有關(guān)DataTable對象中數(shù)據(jù)的主鍵，外鍵，約束和關(guān)系信息組成。六、實(shí)訓(xùn)步驟總體結(jié)構(gòu)圖班級通訊錄管理系統(tǒng)班級通訊錄管理系統(tǒng)查找聯(lián)系人添加聯(lián)系人刪除聯(lián)系人修改聯(lián)系人流程圖：登錄登錄判斷用戶名的有效性和合法性班級通訊錄管理系統(tǒng)主界面查詢聯(lián)系人信息刪除聯(lián)系人信息添加聯(lián)系人信息修改聯(lián)系人信息否是數(shù)據(jù)庫設(shè)計(jì)字段名類型長度是否為空是否為主鍵說明userId文本10否是用戶名userPwd文本10否否用戶密碼字段名類型長度是否為空是否為主鍵說明stuNo文本8否是學(xué)號stuName文本10否否姓名classId文本10是否班級Sex文本2否否性別birthday日期/時(shí)間10是否出生日期tel文本15是否電話address文本100是否家庭住址文本6是否郵政編碼email文本30是否電子remark文本

是否備注七、實(shí)訓(xùn)代碼數(shù)據(jù)庫鏈接代碼：usingSystem;using;using;using;using;using;namespace班級通訊錄管理系統(tǒng){classDataAccess{//定義連接字符串privatestringstrDSN;//定義數(shù)據(jù)庫連接對象OleDbConnectionoledbCon;//數(shù)據(jù)庫連接方法publicvoiddataCon(){strDSN="Provider=;DataSource="+()+"\\";oledbCon=newOleDbConnection(strDSN);}//獲取DataSetpublicDataSetgetDataset(stringsql){DataSetds=newDataSet();();try{OleDbCommandoledbCom=newOleDbCommand(sql,oledbCon);OleDbDataAdapteroledbDa=newOleDbDataAdapter(oledbCom);(ds);returnds;}catch(Exceptionex){thrownewException(());}finally{();}}//執(zhí)行SQL語句publicboolsqlExec(stringsql){try{();}catch{("數(shù)據(jù)庫未連接");}try{OleDbCommandoledbCom=newOleDbCommand(sql,oledbCon);();returntrue;}catch(Exceptionex){(,"提示");returnfalse;}finally{();}}}}登錄界面：usingSystem;using;using;using;using;using;using;using;namespace班級通訊錄管理系統(tǒng){publicpartialclassUsersLogin:Form{publicUsersLogin(){InitializeComponent();}privatevoidUsersLogin_Activated(objectsender,EventArgse){//將光標(biāo)放在用戶名文本框上();}privatevoidbutton1_Click(objectsender,EventArgse){stringusername,password;stringstrSql="";DataSetds;//判斷文本框是否為空if(textBox1.Text.Trim()!=""&&textBox2.Text.Trim()!=""){username=();password=();strSql="select*fromusersloginwhereuserId='"+username+"'anduserPwd='"+password+"'";//實(shí)例化類DataAccessdata=newDataAccess();//連接數(shù)據(jù)庫();//執(zhí)行查詢語句，獲取Datasetds=(strSql);//判斷是否登錄成功if([0].==1){MainfMain=newMain();();();}else{("用戶名或密碼錯(cuò)誤！","登錄失敗");}}}privatevoidbutton2_Click(objectsender,EventArgse){();}privatevoidlabel2_Click(objectsender,EventArgse){}}}主界面：usingSystem;using;using;using;using;using;using;namespace班級通訊錄管理系統(tǒng){publicpartialclassMain:Form{publicMain(){InitializeComponent();}privatevoidMain_FormClosing(objectsender,FormClosingEventArgse){();}privatevoid添加聯(lián)系人ToolStripMenuItem_Click(objectsender,EventArgse){AddLinkmanfrm2=newAddLinkman();();}privatevoid刪除聯(lián)系人ToolStripMenuItem_Click(objectsender,EventArgse){ManageLinkmanfrm4=newManageLinkman();();}privatevoid顯示全部聯(lián)系人ToolStripMenuItem_Click(objectsender,EventArgse){AllLinkmanfrm1=newAllLinkman();();}privatevoid修改聯(lián)系人ToolStripMenuItem_Click(objectsender,EventArgse){ManageLinkmanfrm3=newManageLinkman();();}privatevoid查詢聯(lián)系人ToolStripMenuItem_Click(objectsender,EventArgse){ManageLinkmanfrm4=newManageLinkman();();}privatevoid退出系統(tǒng)ToolStripMenuItem_Click(objectsender,EventArgse){();}}}查詢窗體代碼：usingSystem;using;using;using;using;using;using;namespace班級通訊錄管理系統(tǒng){publicpartialclassManageLinkman:Form{publicManageLinkman(){InitializeComponent();}publicstaticstringstuNo;publicstaticstringStuNo{get{returnstuNo;}set{stuNo=value;}}privatevoidbutton1_Click(objectsender,EventArgse){stringstrSql;stringconditon="";DataAccessdata=newDataAccess();DataSetds;if(!=""){conditon+="andstuNo='"++"'";}if(!=""){conditon+="andstuName='"++"'";}if(!=""){conditon+="andclassId='"++"'";}if(!=""){conditon+="andSex='"++"'";}strSql="selectstuNoas學(xué)號,stuNameas姓名,Sexas性別,birthdayas出生日期,classIdas班級,telas電話,addressas家庭地址,postalcodeas郵政編碼,emailas電子,remarkas備注fromusersinfowhere1=1"+conditon;();ds=(strSql);=[0];}privatevoidbutton2_Click(objectsender,EventArgse){stringstrSql;DataAccessdata=newDataAccess();strSql="deletefromusersinfowherestuNo='"+[0].()+"'";();if((strSql)){("刪除成功！");}else{("刪除失敗！");}}privatevoidbutton3_Click(objectsender,EventArgse){ManageLinkman.StuNo=[0].();EditLinkmans1=newEditLinkman();();}}}修改窗體代碼：usingSystem;using;using;using;using;using;using;namespace班級通訊錄管理系統(tǒng){publicpartialclassEditLinkman:Form{publicEditLinkman(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){stringstrSql="";if(textBox2.Text!=""&&textBox3.Text!=""&&textBox4.Text!=""&&textBox5.Text!=""&&textBox6.Text!=""&&textBox7.Text!=""&&textBox8.Text!=""&&textBox9.Text!=""&&comboBox1.Text!=""){strSql="updateuesrsinfosetstuName='"++"',Sex='"++"',birthday='"++"',classId='"++"',tel='"++"',Address='"++"',postalcode='"++"',email='"++"',remark='"++"',wherestuNo='"++"'";DataAccessdata=newDataAccess();();if((strSql)){("修改成功！");}else{("修改失??！");}}else{("輸入未完全！");}}privatevoidEditLinkman_Load(objectsender,EventArgse){=;}privatevoidbutton2_Click(objectsender,EventArgse){();}}}添加窗體代碼：usingSystem;using;using;using;using;using;using;namespace班級通訊錄管理系統(tǒng){publicpartialclassAddLinkman:Form{publicAddLinkman(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){stringstrSql;DataAccessdata=newDataAccess();strSql="insertintousersinfo(stuNo,stuName,classId,birthday,tel,postalcode,email,address,remark,Sex)values('"+textBox1.Text+"','"+textBox2.Text+"','"+textBox3.Text+"','"+textBox4.Text+"','"+textBox5.Text+"','"+textBox6.Text+"','"+textBox7.Text+"','"+textBox8.Text+"','"+textBox9.Text+"','"+comboBox1.Text+"')";();if((strSql)){("添加成功！");}else{("添加失?。?);}}privatevoidbutton2_Click(objectsender,EventArgse){();}}}顯示所有聯(lián)系人窗體代碼：usingSystem;using;using;using;using;using;using;namespace班級通訊錄管理系統(tǒng){publicpartialclassAllLinkman:Form{publicAllLinkman(){Initial