《上机实习报告总结结尾.docx》由会员分享，可在线阅读，更多相关《上机实习报告总结结尾.docx（25页珍藏版）》请在课桌文档上搜索。
1、上机实习报告总结结尾代码如下;usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;namespaceWindowsApplicationl(publicpartialclassForm5:Form(publicForm5()(InitializeConiponent();)privatevoidbuttonlClick(objectsender,l
2、ogofrom=newlogo()；from.Show();EventArgse)EventArgs e)privatevoidbutton2Click(objectsender,Form2from=newForm2();from.Show();privatevoidbutton3Click(objectsender,EventArgse)s:/.xielw.shijuan试卷(Form3from=newForm3();from.Show();)EventArgs e) privatevoidbutton4Click(objectsender,Form4from二newForm4();from
3、.Show();)代码如下：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Data.SqlClient;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;namespaceWindowsApplicationlpublicpartialclasslogo:Formpubliclogo()InitializeComponentO；)privatevoidFormlLoa
4、d(objectsender,EventArgse)()privatevoidbuttonlClick(objectsender,EventArgse)stringconnstring=DataSource=Panlunzhao;InitialCatalog=BOOKSTORE.MDF;IntegratedSecurity=Truezz;SqlConnectionconn=newSqlConnection(Connstring);conn.Open();stringusername=this,username.Text.ToStringO;stringpassword=this,passwor
5、d.Text.ToStringO；SqlCommandm二conn.CreateCommand();m.CommandText=select*frommanagewhereUSername=+username+andPaSSWord=+password+；SqlDataReadersqlda=m.ExecuteReaderO；if(sqlda.Read()(ifs:/.xielw./gongzuobaogao/工作报告(SqIdapassword.ToString().Trim()=password)/MessageBox.Show(恭喜您登陆成功！，登陆成功！，MessageBoxButto
6、ns.OK,MessageBoxIcon.Information);/Form2f=newForm2();/f.Show();Form3from=newForm3();from.Show();)elseMessageBox.Show(密码错误，请重新输入!，错误，MessageBoxButtons.OK,MessageBoxIcon.Information);)elseMeSSageBox.Show(此用户不存在，请您！，MessageBoxButtons.OK,MessageBoxIcon.Information);)conn.CloseO;s:/.xielw.Zdangtuangongzu
7、ozongjie/党团工作总结sqlda.CloseO；)privatevoidbutton2Click(objectsender,EventArgse)username.Text二；password.Text=；)三.会员管理模块代码如下：usingSystem;usingSystem.Collections.Generic;usingSystem.CoinponentModel;usingSystem.Data;usingSystem.Data.SqlClient;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;
8、namespaceWindowsApp1ication1(publicpartialclassForm2:Form(protectedSqlConnectionconn;protectedSqlCommandcmd;stringconnstring=DataSous:/./article/述职报告rce=panlunzhao;InitialCatalOg=BOOKSTORE.MDF;IntegratedSecurity=Truezz;publicForm2()(InitializeComponent();)privatevoidForm2Load(objectsender,EventArgse
9、)(Ioadl();load();)protectedvoidIoadl()stringsql=select*fromcustomer”;conn=newSqlConnection(Connstring);conn.Open();SqlDataAdapterda=newSqlDataAdapter(sql,conn);DataSetds=newDataSet();da.Fi11(ds,book);dataGridViewl.DataSource=ds.Tableszzbookz;)protectedvoidload()(conn=newSqlConnection(Connstring);con
10、n.Open();stringsqlselect=,SELECTIDFROMcustomer；cmd=newSqlCommand(sqlselect,conn);SqlDataReaderdr=cmd.ExecuteReaderO;id.Items.Clear();while(dr.Read()id.Items.Add(dr0);dr.Close();)privateDataTableBindData(stringsql)(stringsqlselect=sql;conn=newSqlConnection(Connstring);SqlDataAdapterad=newSqlDataAdapt
11、er(sqlselect,conn);DataSetds二newDataSet();ad.Fill(ds,customer);returnds.TabIeScustomer;)privatevoidbuttonlClick(objectsender,EventArgse)stringsql=select*fromcustomerwhereID=+id.Text.ToStringO+；conn=newSqlConnection(Connstring);conn.Open();SqlCommandcmd=newSqlComniand(sql,conn);SqlDataReaderds=cmd.Ex
12、ecuteReaderO；ds.Read();textBoxl.Text=dsz,11amezz.ToStringO；textBox2.Texts:/.xielw.xuexiaogongzuozongjie学校工作,总结=ds,zLevelszz.ToStringO；textBox3.Text=dsEzzBirthdayzz.ToStringO;textBox4.Text=dsDegreeToStringO;textBox5.Text=dsAddress.ToStringO;textBox6.Text=dsTelephone.ToStringO;textBox7.Text=dszzEmai1z
13、，.ToString();textBox8.Text=dsScore.ToStringO;radioButtonl.Checked二(bool)dszzGender,z;)privatevoidUpdateClick(objectsender,EventArgse)stringsql二,zcustomersetname=ame,LeVelS=LeVels,Birthday=Birthday,Degree=Wegree,AddreSS=AddreSs,Telephone=Te1ephone,EmaiI=EnIai1,Score=ScorewhereID=ID；conn=newSqlConnect
14、ion(Connstring);conn.Open();cmd=newSqlCommand(sql,conn);cmd.Parameters.Add(ID，SqlDbType.Int).Value=id.Text.ToStringO；cmd.Parameters.Add(name，SqlDbType.NVarChar,20).Value=textBoxl.Text.Trim();cmd.Parameters.Add(LeVelS,SqlDbType.SmallInt).Value二textBox2.Text.Trim();cmd.Parameters.Adel(Birthday，SqlDbTy
15、pe.SmallDateTime).Value=textBox3.Text.Trim();cmd.Parameters.Add(Degree，SqlDbType.NVarChar,20).Value=textBox4.Text.Trim();cmd.Parameters.Add(AddreSs,SqlDbType.NVarChar,256).Value=textBox5.Text.Trim();cmd.Parameters.Add(TelePhone，SqlDbType.NVarChar,50).Value=textBox6.Text.Trim();cmd.Parameters.Add(EnI
16、ai1,SqlDbType.NVarChar,50).Value=textBox7.Text.Trim();cmd.Parameters.Add(,s:/.xielw./yundonghuiyanjianggao运动会演讲稿Gender,SqlDbType.Bit).Value二(bool)radioButtonl.Checked;cmd.Parameters.Add(SCore，SqlDbType.Int).Value=textBox8.Text.Trim();cmd.ExecuteNonQuery();SqlDataReaderds=cmd.ExecuteReaderO;ds.Read()
17、;Ioadl();)privatevoidClick(objectsender,EventArgse)stringsql二intocustomer(Name,Levels,Gender,Birthday,Degree,Address,Telephone,Email,Score)values(Name,Levels,Gender,Birthday,Degree,Address,TeIephone,Email,Score),z;cmd=newSqlCommand(sql,conn);try(conn.Open();cmd.Parameters.Add(NaIne，SqlDbType.NVarCha
18、r,20).Value=textBoxl.Text.Trim();cmd.Parameters.Ade1(LeVelS，SqlDbType.Smallint).Value=Convert.ToDouble(textBox2.Text.Trim();cmd.Parameters.Add(Birthday，SqlDbType.SmallDateTime).Value二Convert.ToDateTime(textBox3.Text.Trim();cmd.Parameters.Add(Degree，SqlDbType.NVarChar,20).Value=textBox4.Text.Trim();c
19、md.Parameters.Add(AddreSs，SqlDbType.NVarChar,256).Value=textBox5.Text.Trim();cmd.Parameters.Add(TelePhone,SqlDbType.NVarChar,50).Value=textBox6.Text.Trim();cmd.Parameters.Add(Emai1，SqlDbType.NVarChar,50).Value=textBox7.Text.Trim();cmd.Parameters.Add(SCore，SqlDbType.Int).Value二Convert.ToDouble(textBo
20、x8.Text.Trim();if(radioButtonl.Checked)(cmd.Parameters.Ade1(Gender，SqlDbType.Bit).Value=true；)else(cmd.Parameters.Add(Gender，SqlDbType.Bit).Valus:/.xielw./yuegongzuozongjie月工作总结e=false”;)intcount=cmd.ExecuteNonQueryO；if(count=1)if(MessageBox.ShoW(确认添加读者吗？，提示“，MessageBoxButtons.YesNo,MessageBoxIcon.Q
21、uestion)二二DialogResult.No)return;MessageBox.ShOW(添加成功!”,提示!)；else(MessageBox.ShOW(添加失败，提示，MessageBoxButtons.RetryCancel,MessageBoxIcon.Information);)catch(Exceptionex)(MessageBox.Show(ex.Message);)finally(conn.CloseO;)四.增加、删除、修改图书模块代码如下：usingSystem;usingSystem.Collections.Generic;usingSystem.Compone
22、ntModel;usingSystem.Data;usingSystem.Data.SqlClient;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;namespaceWindowsApp1ication1(publicpartialclassForm3:Form(protectedSqlConnectionconn;protectedSqlComs:/.xielw.shiJicailiao/事迹材料mandcmd;stringconnstring二矿DataSource=Panlunzhao;InitialCat
23、alog=BOOKSTORE.MDF;IntegratedSecurity=Truezz;publicForm3()(InitialiZeComponent();)privatevoidtextBox7TextChanged(objectsender,EventArgse)()privatevoidlabel6Click(objectsender,EventArgse)privatevoidSelectClick(objectsender,EventArgse)stringbookname=shuming.Text.Trim();stringpress=chubanshe.Text.ToStr
24、ingO；stringAuthor=duzhe.Text.Trim();StringBuildersbl=newStringBuilderO；sbl.Append(,select*frombookwhere)；if(checkBoxl.Checked)sbl.Append(string.Format(NameLIKE%0%”,bookname);if(checkBoxl.Checked&checkBox2.Checked)sbl.Append(z,AND)；if(checkBox2.Checked)(sbl.Append(string.Format(,Press=0，press);if(che
25、ckBox3.Checked&checkBox2.Checked)sbl.Append(/,ND)；if(checkBox3.Checked)(sbl.Append(string.Format(,zAuthorLIKE%0%”,Author);)dataGridViewl.DataSource=Bins:/,xielw.Zbanzhurengongzuojihua班主任工作方案dData(sbl.ToStringO);privatevoidresetClick(objectsender,EventArgse)checkBoxl.Checked=true;checkBox2.Checked=fa
26、lse;checkBox3.Checked=false;shuming.Text二；chubanshe.Text二duzhe.Text=；)privatevoidbuttonlClick(objectsender,EventArgse)stringsql=select*frombookwhereISBN=,+boBoxl.Text.ToStringO+；conn=newSqlConnection(Connstring);conn.Open();SqlCominandcmd=newSqlCommand(sql,conn);SqlDataReaderds=cmd.ExecuteReaderO;ds
27、.Read();textBoxl.Text=dsz,ISBNz,.ToStringO;textBox2.Text=dsz,namez,.ToStringO;textBox3.Text=dsz,authorzz.ToStringO；textBox4.Text=ds,pressz,.ToStringO;textBox5.Text二ds,publishdatezz.ToString(s:/.xielw./Shiyongqigongzuozongjie试用期工作总结);textBox6.Text=dsz,pricez,.ToStringO;textBox7.Text=dspages.ToStringO
28、;textBox8.Text=dsbarcode.ToStringO;radioButtonl.Checked=(bool)dscd;textBoxlO.Text=dsstorage.ToStringO;privatevoidbutton2Click(objectsender,EventArgse)stringsql二intobook(ISBN,name,author,press,publishdate,price,pages,barcode,cd,storage)values(ISBN,name,author,press,publishdate,price,Pages,barcode,cd,
29、storage)；conn=newSqlConnection(Connstring);conn.Open();cmd=newSqlCommand(sql,conn);cmd.Parameters.Add(isbn，SqlDbType.NChar,10).Value=textBoxl.Text.ToStringO;cmd.Parameters.Add(name,SqlDbType.NVarChar,256).Value=textBox2.Text.Trim();cmd.Parameters.Add(author,SqlDbType.NVarChar,100).Value=textBox3.Tex
30、t.Trim();cmd.Parameters.Add(press,SqlDbType.NVarChar,50).Value=textBox4.Text.Trim();cmd.Parameters.Add(PUbliShdate,SqlDbType.NVarChar,50).Value=textBox5.Text.Trim();cmd.Parameters.Add(PriCe，SqlDbType.NVarChar,50).Value=textBox6.Text.Trim();cmd.Parameters.Add(pages,SqlDbType.NVarChar,50).Value=textBo
31、x7.Text.Trim();cmd.Parameters.Add(barcode，SqlDbTypes:/.xielw.Zdangxiaoxuexixindetihui/党校学习心得体味.NVarChar,50).Value=textBox8.Text.Trim();cmd.Parameters.Add(cd”,SqlDbType.NVarChar,50).Value二(bool)radioButtonl.Checked;cmd.Parameters.Add(StOrage”,SqlDbType.NVarChar,50).Value=textBoxlO.Text.Trim();cmd.Exe
32、cuteNonQuery();Ioadl();load();)privatevoidsavedick(objectsender,EventArgse)(stringsql=booksetname=name,author=author,press=press,pub1ishdate=pubIishdate,PriCe=PriCe,pages=pages,barcode=barcode,Cd=cd,Storage=StoragewhereISBN=ISBN；conn=newSqlConnection(Connstring);conn.Open();cmd=newSqlCommand(sql,con
33、n);cmd.Parameters.Add(/zisbn，z,SqlDbType.NChar,10).Value二boBoxl.Text.ToStringO;cmd.Parameters.Add(iIanIe，SqlDbType.NVarChar,256).Value=textBox2.Text.Trim();cmd.Parameters.Add(author，SqlDbType.NVarChar,100).Value=textBox3.Text.Trim();cmd.Parameters.Add(press,SqlDbType.NVarChar,50).Value二textBox4.Text
34、.Trim();cmd.Parameters.Add(PUbliShdate,SqlDbType.NVarChar,50).Value=textBox5.Text.Trim();cmd.Parameters.Add(PriCe,SqlDbType.NVarChar,50).Value=textBox6.Text.Trim();cmd.Parameters.Add(PageS，SqlDbType.NVarChar,50).Value=textBox7.Text.Trim();cmd.Parameters.Add(barcode，SqlDbType.NVarChar,50).Value=textB
35、ox8.Text.Trim();cmd.Parameters.Add(cd,SqlDbType.NVarChar,50).Value二(bool)radioButtonl.Checked;cmd.Parameters.Add(StOrage”,SqlDbType.NVarChar,50).Value=textBoxl0.Text.Trim();cmd.ExecuteNonQuery();SqlDataReaderds=cmd.ExecuteReaderO;ds.Read();Ioadl();)privatevoidquxiaosaveClick(objectsender,EventArgse)
36、textBoxl.Text=；textBox2.Text=；textBox3.Text二；textBox4.Text二textBox5.Text=z，&s:/.xielw./shenbaocailiao/申报材料quot;textBox6.Text=；textBox7.Text=”；textBox8.Text=；radioButtonl.Checked=false;IextBoxlO.Text二；)privatevoidClick(objectsender,EventArgse)stringsql=frombookwhereisbn=isbn；conn=newSqlConnection(con
37、nstring);cmd=newSqlCommand(sql,conn);conn.Open();cmd.Parameters.Add(isbn,SqlDbType.NChar,10).Value二boBoxl.Text.ToStringO;cmd.ExecuteNonQuery();Ioadl();load();)privatevoidForm3Load(objectsender,EventArgse)load();Ioadl();)protectedvoidload()conn=newSqlConnection(Connstring);conn.Open();stringsqlselect
38、=SELECTDISTINCTPRESSFROMBOOKORDERBYPRESS”;cmd二newSqlCommand(sqlselect,conn);SqlDataReaderdr=cmd.ExecuteReaderO；chubanshe.Items.ClearO；while(dr.Read()chubanshe.Items.Add(dr0);dr.Close()；cmd.CommandText二,SELECTDISTINCTBarcodeFROMBookORDERBYBarcodez,;SqlDataReaderds=cmd.ExecuteReaderO;tushutiaoma.Items
39、.Clear();while(ds.Read()tushutiaoma.Items.Add(dsO);ds.CloseO；cmd.CommandText=SELECTDISTINCTISBNFROMBookORDERBYISBN”;SqlDataReaderst=cmd.ExecuteReaderO；boBoxl.Items.ClearO；while(st.Read()boBoxl.Items.Add(st0);st.Close();)protectedvoidIoadl()stringsql二,zselect*frombook”;conn=newSqlConnection(Connstrin
40、g);conn.Open();SqlDataAdapterda=s:/.xielw.Zqingkuangbaogao/情况报告newSqlDataAdapter(sql,conn);DataSetds=newDataSet();da.Fill(ds,book)；dataGridViewl.DataSource=ds.Tableszzbookzz;)privateDataTableBindData(stringsql)(stringsqlselect=sql;conn=newSqlConnection(Connstring);SqlDataAdapterad=newSqlDataAdapter(
41、sqlselect,conn);DataSetds=newDataSet();ad.Fill(ds,Book);returnds.TablesBook;)privatevoidallClick(objectsender,EventArgse)(stringsql=select*frombook”;conn=newSqlConnection(Connstring);conn.Open();SqlDataAdapterda=newSqlDataAdapter(sql,conn);DataSetds二newDataSet();da.Fill(ds,book);dataGridViewl.DataSo
42、urce=ds.Tablesbook;)五.借书模块代码如下：usingSystem;usingSystem.Collections.Generic;usingSystem.CoinponentModel;usingSystem.Data;usingSystem.Data.SqlClient;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;namespaceWindowsApp1ication1(publicpartialclassForm4:Form(protectedSqlConnectionconn;prote
43、ctedSqlCommandcmd;stringconnstring=DataSource=Panlunzhao;InitialCatalog=BOOKSTORE.MDs:/.xielw.banjigongzuojihua班级工作方案F;IntegratedSecurity=Truezz;publicForm4()InitialiZeComponent();)privatevoidForm4Load(objectsender,EventArgse)(try(conn=newSqlConnection(/zDataSource=panlunzhao;InitialCatalog=BOOKSTOR
44、E.MDF;IntegratedSecurity=Truez);conn.Open();this.InitDataO;)catch(Exceptionexp)(MeSSageBoX.Show(无法建立数据连接：+exp.Message);this.Close();)protectedvoidInitDataO(cmd=newSqlCommand(,selectdistinctIDfromBookorderByID/z,conn);SqlDataReaderreaderl=cmd.ExecuteReaderO;boBoxl.Items.Clear();while(reader1.Read()bo
45、Boxl.Items.Add(readerl0);readerl.Close();cmd=newSqlCommand(,zselectidfromreaderorderbyIDzz,conn);SqlDataReaderreader2=cmd.ExecuteReaderO；id.Items.ClearO；while(reader2.Read()id.Items.Add(reader20);reader2.Close();)privatevoidSelectClick(objectsender,EventArgse)s:/.xielw.Zchengxinyanjianggao/诚信演讲稿stringsql=select*frombookwhereID=+boBoxl.Text.ToStringO+；conn=newSqlConnection(Connstring);conn.Open();SqlCommandcmd=newSqlCommand(sql,conn);SqlDataReaderds=cmd.ExecuteReaderO；ds.
