《家譜管理系統(tǒng)》課程設(shè)計(jì)報(bào)告學(xué)院：信息科學(xué)與工程學(xué)院班級：計(jì)算機(jī)科學(xué)與技術(shù)08-4班制作人：邢尚文山東科技大學(xué)2011年9月1日需求分析：本系統(tǒng)主要完成對家譜的相關(guān)操作和家譜人員信息的管理，包括打開家譜、新加家譜、保存家譜和家譜人員的姓名查找、某代信息查找、信息刪除等。系統(tǒng)的核心是利用對話框的連接和文本處理來存儲(chǔ)和修改家譜管理系統(tǒng)的信息聯(lián)系，其中的每一個(gè)動(dòng)作都可能影響到其他的功能。本系統(tǒng)實(shí)現(xiàn)以下功能：.輸入文件以存放最初家譜中各成員的信息。成員的信息中均應(yīng)包含以下內(nèi)容：姓名、輩分、父輩姓名、電話。.實(shí)現(xiàn)數(shù)據(jù)的存盤和讀盤。.以圖形方式顯示家譜。,顯示第n代所有人的信息。.按照姓名查詢，輸出成員信息.刪除某成員。本系統(tǒng)的作用不是為了代替家譜，而是為了更好的建立家庭之間成員的聯(lián)系，提供一個(gè)查詢的平臺(tái)，里面的族譜及文化介紹可以有效的介紹家族歷史，讓成員了解家族歷史，向外界展示。E-R圖家譜管理系統(tǒng)ER程序界面與代碼:■偵Forml家譜文化中國冢族可壓紹用戶名:■偵Forml家譜文化中國冢族可壓紹用戶名:usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;namespaceWindowsFormsApplication12{publicpartialclassForm1:Form{publicForm1(){InitializeComponent();privatevoidbutton4_Click(objectsender,EventArgse){if(textBox1.Text==""&&textBox2.Text==""){MessageBox.Show("信息不全請重新填寫")；}if(textBoxl.Text=="admin"&&textBox2.Text=="admin"){Form2form=newForm2();form.Show();}else{textBox1.Text="";textBox2.Text="";MessageBox.Show("請重新輸入用戶名密碼？")；}}privatevoidbutton1_Click(objectsender,EventArgse){Form6form=newForm6();form.Show();}privatevoidbutton3_Click(objectsender,EventArgse){Form7form=newForm7();form.Show();}privatevoidbutton2_Click(objectsender,EventArgse){MessageBox.Show(”本軟件的設(shè)"計(jì)？是°?為a了兩讓"?用??戶ji能夠?更好?地t?管??】理Q??a家…譜iA以。？及匡方Q?便A?家…譜iA的t?修T改？，6?使°1用@?注Aie冊F過y的t?賬?號？的t?登t?陸?后"?就「a可?以。？使°1用??本A?軟....'件t！e?");

usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;namespaceWindowsFormsApplication12{publicpartialclassForm2:Form{publicForm2(){InitializeComponent();privatevoid祖A?先*,,功|德I?ToolStripMenuItem_Click(objectsender,EventArgse){Form3form=newForm3();form.Show();}privatevoidzToolStripMenuItem_Click(objectsender,EventArgse){Form4form=newForm4();form.Show();}privatevoid祭*Q祖A?文？化i￥ToolStripMenuItem_Click(objectsender,EventArgse){Form5form=newForm5();form.Show();}privatevoid家*°譜iA管"'理O"aToolStripMenuItem_Click(objectsender,EventArgse){Form8form=newForm8();form.Show();}privatevoiddsdfsdToolStripMenuItem_Click(objectsender,EventArgse){Form9form=newForm9();form.Show();}privatevoid通'[§訊？錄？添-一③加*?ToolStripMenuItem_Click(objectsender,EventArgse){Form10form=newForm10();form.Show();}privatevoid制?作AjA人*?ToolStripMenuItem1_Click(objectsender,EventArgse){MessageBox.Show("制？作AjA人.?？計(jì)？算？機(jī)"208-3班注。：6。李Q?薊？濤-?,6?李Q?赟2S,6?張?拓a?，6?蘇?曉t慧?")；privatevoid通aj§訊?錄?ToolStripMenuItem_Click(objectsender,EventArgse){MessageBox.Show("要。a做A?出？修T改？需―.要。a提「"供？管'^1理Q"員jA權(quán)"i§限T!e?");Formllform=newForm11();form.Show();}privatevoid制?作AjA人*?ToolStripMenuItem_Click(objectsender,EventArgse){Form13form=newForm13();form.Show();}}}u_,Form?您座楓曲簡上舫勞我耳目跟h中角<域1您座楓曲簡上舫勞我耳目跟h中角<域1段食苗胡冉由扣干變療布期霞中<*i志艾卡梃亦曼冠世賓寸箏殖博&

f或M彩主t命區(qū)導(dǎo)特<惟L、/li判諱!ctiidfe.tG涉打南附、i｛袖靴并枷rtn，出白.吝H冬眼立后-CFSPKB?鞋次｝-以宣酬，昏酬醐@1方K忌祁對：”豹土辨我癥，學(xué)王辛耳制1，l苗11您1^南琮，后蔑育fWF卑族冒注“Cfc半"任?.繇苛成享我4“平"任-4、朋重踽“竿*-“羊+期圖嘛頑調(diào)暮，陽蟲，tt.胡，為蚪席，蝌，*5布，嘛，制］，1，羅，翔隅七譴［期五玄頒蝦嶗國1；'等"昭ha吊J弱齡牌氐?ati手故丁土的5-出自更曲*蛙，壬擊般地翔R鰥，弓k、標(biāo)決玲化.?：?E-RH；后?格妤.叫1季氏+昂顧邸氏、usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;namespaceWindowsFormsApplication12{publicpartialclassForm3:Form{publicForm3(){InitializeComponent();亍丁.況，汗.*：.謎至士-一，專注滸元玨：：_同三?元.*F7字龍-M，斗，巽于上迫.序共浮巳-檢f瞬人*犬汶”=鉉*?:蕓F：巾*執(zhí)*討”土*?.?:巾碎心K耳平王時(shí)圈做M頊謔㈱聃?I暨的臨玨ilfl新」《^聽勤跑拋道襦才蓉理拙％什志科一書又剖演?P、〃命千文曜毒!通齡用“FF※空:抵那.包帶暇懷酒吉KH字?'g*m后岫，噌誦顧梢肅:;*誠常也蚣11:曲『第打脫散?虧矣:壬:;II■:：??,￡,”:SS.去「?3次悝?鏤，傘廊威退、孫酰據(jù)，贍觥施。甥胡，晰佩■溯?=三?.:?凡T薩他焊對嘰乏M金飪:tjgW7?七境，時(shí)淫星i岫解禹■判貞憫射映辟敝兒，機(jī)丑I卷料刷牖盼，怕拷小手蘭二.二W眨EMi：?仔礦二如在肝色Ml，治T方門壬#JKF?二由令將...黃*二?:蕓TT'.忸工三?5-以±.-致，4共，土羊：.■，：?.：”?監(jiān)耶符，?:;社蛇'物氣初軒乙"?僵潔f二立?.二??=.干罟-.雄—*,?「?m-■-幗破&:瓣躋兒子：李云■■舞,瑚L沖汕ffiS國眼府，國§-制大:遍壬.仕蕓，是：六、*亢:圭?芋打三LM沛;：=?二"站「=:mwi：■耗§、匕*擊亍.二”戶章'『-；tI川:言寧〒粗瞄:好剽^怫活滿擋相捌圈爭國糅寄起犧房，野軻，帽糙袒捅，剝1成5狩蛔卸S官，順爵^瞄學(xué)翊IW郎），獺聘福usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;namespaceWindowsFormsApplication12{publicpartialclassForm4:Form{publicForm4(){吁Form5:□回.W中國淵成嗥融幾千年有其深刻爆響，-方面是鼾人們對于跳就觥的劇、粉迎破怛的通，而與鼬爵箱懿切聯(lián)系的是祖先崇玲祖醍幡群體噸苛野伽］-厥為年間氐蹄首秘，在古榆涓機(jī)祖先所代表的經(jīng)也萼意瞅成，將隨其靈諼而永存，應(yīng)為-腆自然的槌，程取中雌做員。攔-發(fā)球桐雕的熟向，中國兩千年來的傳說瘢朝剽百家獨(dú)尊喘術(shù)開始，基本上是蠕冢為■S蛀部孔子鯽？％葬迎禮，散妁/:儒禳調(diào)其他理隹的含彩主匏括；言屈我；祭祖的靛，是要局七子麗寸于死去健善月舞，倍追晶主更是為了表遍捆先的獨(dú)和懷容垂護(hù)宗明勰㈱舸枕間眥使后代子驟密團(tuán)混互脅安家刖，在古代封建制度下法I他與齊孫治國是《郵劇嗷而全國上下鞘瓠q眥家岳社會(huì)及國家自加煽會(huì)安定項(xiàng)牛usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;namespaceWindowsFormsApplication12{publicpartialclassForm5:Form{publicForm5(){InitializeComponent();q：'FormG常話，呈-中礎(chǔ)即吐第史。無布嗔石爆響*:黃，，壬證的舐位，，:［包羅丁滿親生更-辟i-帽辨-工憂，房壩、家前等化史Ft的全過褂商務(wù)每一個(gè)眺法鑿埼科圮惜霜寶q：'FormG家諾與絲更、方志一配，砥稱為中年民旌三*仿史女獻(xiàn)占五千軸勺烏它如昵，下為益陶:t一弱*文化，F(xiàn)!樣中午奶?毒質(zhì)中華，營吊樣自貌帝溟未，早聲給E古國流人物，京治適功，：:解出多少向武建1土克巖而士，，】二甚娑的考食字，在世左敢法：尚、汨提鼬多*5建卻迭我譜文忱切史不其的涌泉，usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;namespaceWindowsFormsApplication12{publicpartialclassForm6:Form{publicForm6(){QL'Ferm?]7由華立化的統(tǒng)一性，在中國歷史上的任何時(shí)刻，即使是在多次的政治紛亂、社合動(dòng)蕩中。都豐曾被分裂和瓦解過；而在悠穴歷史長$可中，埴首中外京化交流的頻繁，中偉文化又眼版了討多外來的優(yōu)秀立化*它的牌蝗體現(xiàn)在哲學(xué)、京教、京學(xué)、藝本里，它的觸力體現(xiàn)在中醫(yī)、?飲食、民俗、建筑巾-數(shù)千年未，它不儀"著炎黃子強(qiáng)，而旦時(shí)世羿其他地區(qū)的歷史與交化聲生了重要的熟響，usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;namespaceWindowsFormsApplication12{publicpartialclassForm7:Form{publicForm7(){nJForm9這里是查找目錄：輸入查找的姓名：fi1.查找I編號p_rL!inieP_gpriprelfa_ri!iriptelp_rLiiiTi*李1無1232李二—2李—一12337^￡李—一1234李三一3李二一235李三二3李二一23123李三三31237李四一4李二一1238李四二4李二一12319李四三4李二一1231234|—nrVusingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.OleDb;namespaceWindowsFormsApplication12{publicpartialclassForm9:Form{publicForm9(){InitializeComponent();}privatevoidForm9_Load(objectsender,EventArgse){//TODO:這a行D代a"2碼?將？數(shù)。y據(jù)丫加"?載？到I?表A'a^adblDataSetll.表A"a2"jA中D。咱您"2可「以。？根??’據(jù)Y需....要°3移°?動(dòng)i￥或…刪|?除y它"Liethis.表A"a2TableAdapter.Fill(this.db1DataSet11.表人"'2);privatevoidbutton1_Click(objectsender,EventArgse){stringacc="”;strings=textBox1.Text;OleDbConnectionconn=newOleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;DataSource=F:/xitong/Projects/WindowsFormsApplication12/WindowsFormsApplication12/db1.mdb");acc=string.Format("selectp_name,p_general,fa_name,tele_numFROM表A"a2wherep_name='{0}'",textBox1.Text);conn.Open();DataSetdataset=newDataSet();OleDbDataAdapteradapter=newOleDbDataAdapter(acc,conn);adapter.Fill(dataset);dataGridView1.DataSource=dataset.Tables[0];}}}這里是人員添加界面:聯(lián)系電話:代數(shù):這里是人員添加界面:聯(lián)系電話:代數(shù):usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.OleDb;namespaceWindowsFormsApplication12{publicpartialclassForm10:Form{publicForm10(){InitializeComponent();privatevoidbutton1_Click(objectsender,EventArgse){OleDbConnectionconn=newOleDbConnection(礦Provider=Microsoft.Jet.OLEDB.4.0;DataSource=F:/xitong/Projects/WindowsFormsApplication12/WindowsFormsApplication12/db1.mdb");StringcmdString="insertinto表A"a2(p_name,p_general,fa_name,tele_num)values('”;cmdString+=textBox1.Text+"','”;cmdString+=textBox2.Text+"','”;cmdString+=textBox3.Text+"','”;cmdString+=textBox4.Text+"')”;conn.Open();OleDbCommandcmd=newOleDbCommand(cmdString,conn);//OleDbCommandcmd=newOleDbCommand();//cmd.CommandText=cmdString;//cmd.Connection=conn;//Console.WriteLine("SQL:"+cmdString);cmd.ExecuteNonQuery();conn.Close();}privatevoidtextBox1_TextChanged(objectsender,EventArgse){}privatevoidForm10_Load(objectsender,EventArgse){//TODO:這a行D代a"2碼?將？數(shù)。y據(jù)丫加"?載？到I?表A、a“iadb1DataSet10.表A、a2”iA中D。i6您"2可「以。？根??’據(jù)Y需...?要°3移。？動(dòng)i￥或"。刪|?除y它"Liethis.表A"a2TableAdapter.Fill(this.db1DataSet10.表A"a2);管理員用戶名：I管理員密碼:登陸usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;namespaceWindowsFormsApplication12{publicpartialclassForm11:Form{publicForm11(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){if(textBox1.Text=="123"&&textBox2.Text=="123"){Form12form=newForm12();form.Show();if(textBoxl.Text==""&&textBox2.Text==""){MessageBox.Show("信？息ie不？全"?,請？重？新？填-?寫ja");}if(textBoxl.Text=="123"&&textBox2.Text=="123"){Form2form=newForm2();form.Show();}else{textBox1.Text="";textBox2.Text="";MessageBox.Show("請？重？新？輸°?入工用@?戶jl名？和"a密r碼？")；}}}}請輸入零要?jiǎng)h除的名寶；刪除編號p_n!jiTipp_gerLpralfa_n!UTih!tele_num?李1無1232李二一2李—一12332李—一1234李三一3李二一235李三二3李二一231236李二二3123-rti!1_m司卜usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.OleDb;namespaceWindowsFormsApplication12{publicpartialclassForm12:Form{publicForm12(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){/*OleDbConnectionmyconn=DB.CreateConnection();myconn.Open();stringnewID=Request.QueryString["ID"].ToString();stringsql="deletefromnewswhereID="+newID;OleDbCommandcmd=newOleDbCommand(sql,myconn);cmd.ExecuteNonQuery();myconn.Close();Response.Redirect("defnews.aspx");*/}privatevoidForm12_Load(objectsender,EventArgse){//TODO:這a行D代a"2碼?將？數(shù)。y據(jù)丫加"?載？到I?表A、a“iadb1DataSet12.表A"a2"jA中D。咱您"2可「以。？根??’據(jù)Y需...?要°3移。？動(dòng)i￥或…刪|?除y它"Liethis.表A"a2TableAdapter.Fill(this.db1DataSet12.表入"2);}}}輸入查找的輩分；I蝙號p_n；iiii&p_gerLeral±a_rL；ijrietele_nmn,李一—1無123L2李二—2李一—1233Tf；2李一一1234李三一3李二—235李三二3李二—231236學(xué)三三3^1^212341IM1>usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.OleDb;namespaceWindowsFormsApplication12{publicpartialclassForm1