上机实习报告总结结尾.docx

上机实习报告总结结尾代码如下;usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;namespaceWindowsApplicationl(publicpartialclassForm5:Form(publicForm5()(InitializeConiponent();)privatevoidbuttonlClick(objectsender,logofrom=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.Show();)代码如下：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Data.SqlClient;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;namespaceWindowsApplicationlpublicpartialclasslogo:Formpubliclogo()InitializeComponentO；)privatevoidFormlLoad(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,password.Text.ToStringO；SqlCommandm二conn.CreateCommand();m.CommandText="select*frommanagewhereUSername='+username+'andPaSSWord='+password+'；SqlDataReadersqlda=m.ExecuteReaderO；if(sqlda.Read()(ifs:/.xielw./gongzuobaogao/工作报告(SqIda"password".ToString().Trim()=password)/MessageBox.Show("恭喜您登陆成功！，登陆成功！，MessageBoxButtons.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.Zdangtuangongzuozongjie/党团工作总结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;namespaceWindowsApp1ication1(publicpartialclassForm2:Form(protectedSqlConnectionconn;protectedSqlCommandcmd;stringconnstring=DataSous:/./article/述职报告rce=panlunzhao;InitialCatalOg=BOOKSTORE.MDF;IntegratedSecurity=Truezz;publicForm2()(InitializeComponent();)privatevoidForm2Load(objectsender,EventArgse)(Ioadl();load();)protectedvoidIoadl()stringsql="select*fromcustomer”;conn=newSqlConnection(Connstring);conn.Open();SqlDataAdapterda=newSqlDataAdapter(sql,conn);DataSetds=newDataSet();da.Fi11(ds,"book");dataGridViewl.DataSource=ds.Tableszzbook'z;)protectedvoidload()(conn=newSqlConnection(Connstring);conn.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=newSqlDataAdapter(sqlselect,conn);DataSetds二newDataSet();ad.Fill(ds,"customer");returnds.TabIeS"customer")privatevoidbuttonlClick(objectsender,EventArgse)stringsql="select*fromcustomerwhereID='+id.Text.ToStringO+'；conn=newSqlConnection(Connstring);conn.Open();SqlCommandcmd=newSqlComniand(sql,conn);SqlDataReaderds=cmd.ExecuteReaderO；ds.Read();textBoxl.Text=dsz,11amezz.ToStringO；textBox2.Texts:/.xielw.xuexiaogongzuozongjie学校工作,总结=ds,zLevelszz.ToStringO；textBox3.Text=dsEzzBirthdayzz.ToStringO;textBox4.Text=ds"Degree"ToStringO;textBox5.Text=ds"Address".ToStringO;textBox6.Text=ds"Telephone".ToStringO;textBox7.Text=dszzEmai1z，.ToString();textBox8.Text=ds"Score".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=newSqlConnection(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，SqlDbType.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(EnIai1,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();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.NVarChar,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();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("Emai1，SqlDbType.NVarChar,50).Value=textBox7.Text.Trim();cmd.Parameters.Add(SCore，SqlDbType.Int).Value二Convert.ToDouble(textBox8.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.Question)二二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.ComponentModel;usingSystem.Data;usingSystem.Data.SqlClient;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;namespaceWindowsApp1ication1(publicpartialclassForm3:Form(protectedSqlConnectionconn;protectedSqlComs:/.xielw.shiJicailiao/事迹材料mandcmd;stringconnstring二矿DataSource=Panlunzhao;InitialCatalog=BOOKSTORE.MDF;IntegratedSecurity=Truezz;publicForm3()(InitialiZeComponent();)privatevoidtextBox7TextChanged(objectsender,EventArgse)()privatevoidlabel6Click(objectsender,EventArgse)privatevoidSelectClick(objectsender,EventArgse)stringbookname=shuming.Text.Trim();stringpress=chubanshe.Text.ToStringO；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(checkBox3.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=false;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.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=ds"pages".ToStringO;textBox8.Text=ds"barcode'.ToStringO;radioButtonl.Checked=(bool)dscd;textBoxlO.Text=ds"storage".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,©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.Text.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=textBox7.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.ExecuteNonQuery();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,conn);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.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=textBox8.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)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(connstring);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="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.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(Connstring);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(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.DataSource=ds.Tablesbook;)五.借书模块代码如下：usingSystem;usingSystem.Collections.Generic;usingSystem.CoinponentModel;usingSystem.Data;usingSystem.Data.SqlClient;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;namespaceWindowsApp1ication1(publicpartialclassForm4:Form(protectedSqlConnectionconn;protectedSqlCommandcmd;stringconnstring=DataSource=Panlunzhao;InitialCatalog=BOOKSTORE.MDs:/.xielw.banjigongzuojihua班级工作方案F;IntegratedSecurity=Truezz;publicForm4()InitialiZeComponent();)privatevoidForm4Load(objectsender,EventArgse)(try(conn=newSqlConnection(/zDataSource=panlunzhao;InitialCatalog=BOOKSTORE.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()boBoxl.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.