家谱管理系统实验报告

《家谱管理系统》课程设计报告学院：信息科学与工程学院班级：计算机科学与技术08-4班制作人：邢尚文山东科技大学2011年9月1日需求分析：本系统主要完成对家谱的相关操作和家谱人员信息的管理，包括打开家谱、新加家谱、保存家谱和家谱人员的姓名查找、某代信息查找、信息删除等。系统的核心是利用对话框的连接和文本处理来存储和修改家谱管理系统的信息联系，其中的每一个动作都可能影响到其他的功能。本系统实现以下功能：.输入文件以存放最初家谱中各成员的信息。成员的信息中均应包含以下内容：姓名、辈分、父辈姓名、电话。.实现数据的存盘和读盘。.以图形方式显示家谱。,显示第n代所有人的信息。.按照姓名查询，输出成员信息.删除某成员。本系统的作用不是为了代替家谱，而是为了更好的建立家庭之间成员的联系，提供一个查询的平台，里面的族谱及文化介绍可以有效的介绍家族历史，让成员了解家族历史，向外界展示。E-R图家谱管理系统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(”本软件的设"计？是°?为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人.•？计？算？机"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权"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命区导特<惟L、/li判讳!ctiidfe.tG涉打南附、i｛袖靴并枷rtn，出白.吝H冬眼立后-CFSPKB?鞋次｝-以宣酬，昏酬醐@1方K忌祁对：”豹土辨我症，学王辛耳制1，l苗11您1^南琮，后蔑育fWF卑族冒注“Cfc半"任・.繇苛成享我4“平"任-4、朋重踽“竿*-“羊+期图嘛顽调暮，阳虫，tt.胡，为蚪席，蝌，*5布，嘛，制］，1，罗，翔隅七谴［期五玄颁虾崂国1；'等"昭ha吊J弱龄牌氐・ati手故丁土的5-出自更曲*蛙，壬击般地翔R鳏，弓k、标决玲化.•：•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：巾*执*讨”土*•.•:巾碎心K耳平王时圈做M顼谑㈱聃?I暨的临珏ilfl新」《^听勤跑抛道襦才蓉理拙％什志科一书又剖演©P、〃命千文曜毒!通龄用“FF※空:抵那.包带暇怀酒吉KH字?'g*m后岫，噌诵顾梢肃:;*诚常也蚣11:曲『第打脱散•亏矣:壬:;II■:：••,£,”:SS.去「•3次悝•镂，伞廊威退、孙酰据，赡觥施。甥胡，晰佩■溯?=三•.:•凡T萨他焊对叽乏M金饪:tjgW7?七境，时淫星i岫解禹■判贞悯射映辟敝儿，机丑I卷料刷牖盼，怕拷小手兰二.二W眨EMi：•仔矿二如在肝色Ml，治T方门壬#JKF•二由令将...黄*二•:芸TT'.忸工三•5-以±.-致，4共，土羊：.■，：•.：”•监耶符，•:;社蛇'物气初轩乙"•僵洁f二立•.二•〜=.干罟-.雄—*,〜「•m-■-帼破&:瓣跻儿子：李云■■舞,瑚L冲汕ffiS国眼府，国§-制大:遍壬.仕芸，是：六、*亢:圭•芋打三LM沛;：=•二"站「=:mwi：■耗§、匕*击亍.二”户章'『-；tI川:言宁〒粗瞄:好剽^怫活满挡相捌圈争国糅寄起牺房，野轲，帽糙袒捅，剥1成5狩蛔卸S官，顺爵^瞄学翊IW郎），獭聘福usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;namespaceWindowsFormsApplication12{publicpartialclassForm4:Form{publicForm4(){吁Form5:□回.W中国渊成嗥融几千年有其深刻爆响，-方面是鼾人们对于跳就觥的剧、粉迎破怛的通，而与鼬爵箱懿切联系的是祖先崇玲祖醍幡群体吨苛野伽］-厥为年间氐蹄首秘，在古榆涓机祖先所代表的经也萼意瞅成，将随其灵谖而永存，应为-腆自然的槌，程取中雌做员。拦-发球桐雕的熟向，中国两千年来的传说瘢朝剽百家独尊喘术开始，基本上是蠕冢为■S蛀部孔子鲫？％葬迎礼，散妁/:儒禳调其他理隹的含彩主匏括；言屈我；祭祖的靛，是要局七子丽寸于死去健善月舞，倍追晶主更是为了表遍捆先的独和怀容垂护宗明勰㈱舸枕间眦使后代子骤密团混互胁安家刖，在古代封建制度下法I他与齐孙治国是《邮剧嗷而全国上下鞘瓠q眦家岳社会及国家自加煽会安定项牛usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;namespaceWindowsFormsApplication12{publicpartialclassForm5:Form{publicForm5(){InitializeComponent();q：'FormG常话，呈-中础即吐第史。无布嗔石爆响*:黄，，壬证的舐位，，:［包罗丁满亲生更-辟i-帽辨-工忧，房坝、家前等化史Ft的全过褂商务每一个眺法凿埼科圮惜霜宝q：'FormG家诺与丝更、方志一配，砥称为中年民旌三*仿史女献占五千轴勺乌它如昵，下为益陶:t一弱*文化，F!样中午奶•毒质中华，营吊样自貌帝溟未，早声给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由华立化的统一性，在中国历史上的任何时刻，即使是在多次的政治纷乱、社合动荡中。都丰曾被分裂和瓦解过；而在悠穴历史长$可中，埴首中外京化交流的频繁，中伟文化又眼版了讨多外来的优秀立化*它的牌蝗体现在哲学、京教、京学、艺本里，它的触力体现在中医、•饮食、民俗、建筑巾-数千年未，它不仪"着炎黄子强，而旦时世羿其他地区的历史与交化声生了重要的熟响，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码?将？数。y据丫加"®载？到I?表A'a^adblDataSetll.表A"a2"jA中D。咱您"2可「以。？根••’据Y需....要°3移°?动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];}}}这里是人员添加界面:联系电话:代数:这里是人员添加界面:联系电话:代数: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码?将？数。y据丫加"®载？到I?表A、a“iadb1DataSet10.表A、a2”iA中D。i6您"2可「以。？根••’据Y需...•要°3移。？动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码？")；}}}}请输入零要删除的名宝；删除编号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码?将？数。y据丫加"®载？到I?表A、a“iadb1DataSet12.表A"a2"jA中D。咱您"2可「以。？根••’据Y需...•要°3移。？动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学三三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