圖書館綜合管理系統(tǒng)程序設(shè)計(jì)代碼

程序設(shè)計(jì)代碼登錄模塊if(username.Text.Trim()==""||password.Text.Trim()=="") MessageBox.Show("請(qǐng)輸入用戶名和密碼","提醒"); else {if(radioManage.Checked==true){stringstrcon="DataSource=SIMON-VAIO;InitialCatalog=lkl2;IntegratedSecurity=True;";//連接數(shù)據(jù)庫(kù)字符串，用于指定數(shù)據(jù)庫(kù)地址，名稱，賬號(hào)，密碼，連接方法SqlConnectionsqlCon=newSqlConnection(strcon);//實(shí)例化并定義一個(gè)數(shù)據(jù)庫(kù)連接sqlCon.Open();//打開(kāi)數(shù)據(jù)庫(kù)連接stringsql="select*fromloginwhereusernum=@usernumanduserpassword=@suerpassword";//定義要查詢sql語(yǔ)句SqlCommandcmd=newSqlCommand(sql,sqlCon);//實(shí)例化并定義sql語(yǔ)句和數(shù)據(jù)庫(kù)路徑cmd.Parameters.Add("@usernum",SqlDbType.NChar,20);//定義cmd查詢命令字段屬性，@loginnamesqldbtypenchar（20）cmd.Parameters.Add("@suerpassword",SqlDbType.NChar,20);//同上cmd.Parameters["@usernum"].Value=username.Text;//將username中text保留到變量@loginnamecmd.Parameters["@suerpassword"].Value=password.Text;//同上SqlDataReaderdr=cmd.ExecuteReader();if(dr.Read()){this.Visible=false;Form2Formmain=newForm2();//應(yīng)該是實(shí)例化一個(gè)主窗體this.Hide();//應(yīng)該是切換到主窗口或關(guān)閉自己Formmain.Show();//應(yīng)該是打開(kāi)一個(gè)主窗體dr.Close();//關(guān)閉dr數(shù)據(jù)庫(kù)連接}else//if(dr.Read())讀取失敗則實(shí)施以下代碼MessageBox.Show("密碼錯(cuò)誤,請(qǐng)重新輸入!");//顯示提醒信息}elseif(radioPerson.Checked==true){stringstrcon="DataSource=SIMON-VAIO;InitialCatalog=lkl2;IntegratedSecurity=True;";//連接數(shù)據(jù)庫(kù)字符串，用于指定數(shù)據(jù)庫(kù)地址，名稱，賬號(hào)，密碼，連接方法SqlConnectionsqlCon=newSqlConnection(strcon);//實(shí)例化并定義一個(gè)數(shù)據(jù)庫(kù)連接sqlCon.Open();//打開(kāi)數(shù)據(jù)庫(kù)連接stringsql1="select*fromreaderwhereusernum=@usernumanduserpassword=@suerpassword";//定義要查詢sql語(yǔ)句SqlCommandcmd1=newSqlCommand(sql1,sqlCon);//實(shí)例化并定義sql語(yǔ)句和數(shù)據(jù)庫(kù)路徑cmd1.Parameters.Add("@usernum",SqlDbType.NChar,20);//定義cmd查詢命令字段屬性，@loginnamesqldbtypenchar（20）cmd1.Parameters.Add("@suerpassword",SqlDbType.NChar,20);//同上cmd1.Parameters["@usernum"].Value=username.Text;//將username中text保留到變量@loginnamecmd1.Parameters["@suerpassword"].Value=password.Text;//同上cmd1.CommandText=sql1;SqlDataReaderdr=cmd1.ExecuteReader(); if(dr.Read()){this.Visible=false;Form9Formmain=newForm9();//應(yīng)該是實(shí)例化一個(gè)主窗體this.Hide();//應(yīng)該是切換到主窗口或關(guān)閉自己dr.Close();//關(guān)閉dr數(shù)據(jù)庫(kù)連接 Formmain.Show();//應(yīng)該是打開(kāi)一個(gè)主窗體} else MessageBox.Show("用戶名或密碼錯(cuò)a誤","警告");}elseMessageBox.Show("沒(méi)有選擇角色","提醒");}}添加圖書代碼SqlConnectionsqlcon=newSqlConnection("DataSource=SIMON-VAIO;InitialCatalog=lkl2;IntegratedSecurity=True;");stringstr="insertintodbo.bookvalues(@bnum,@bname,@bauthor,@bpublic,@bclasses,@benshu)";sqlcon.Open();SqlCommandcmd=newSqlCommand(str,sqlcon);cmd.Parameters.Add("@bnum",SqlDbType.NChar,20);cmd.Parameters.Add("@bname",SqlDbType.NChar,20);cmd.Parameters.Add("@bauthor",SqlDbType.NChar,20);cmd.Parameters.Add("@bpublic",SqlDbType.NChar,20);cmd.Parameters.Add("@bclasses",SqlDbType.NChar,20);cmd.Parameters.Add("@benshu",SqlDbType.TinyInt);cmd.Parameters["@bnum"].Value=bnum.Text;cmd.Parameters["@bname"].Value=bname.Text;cmd.Parameters["@bauthor"].Value=bauthor.Text;cmd.Parameters["@bpublic"].Value=bpublic.Text;cmd.Parameters["@bclasses"].Value=bclasses.Text;cmd.Parameters["@benshu"].Value=benshu.Text;cmd.ExecuteNonQuery();sqlcon.Close();this.bnum.Clear();this.bname.Clear();this.bauthor.Clear();this.bpublic.Clear();this.benshu.Clear();this.bclasses.Clear();MessageBox.Show("添加成功!");刪除圖書代碼SqlConnectionsqlcon=newSqlConnection("DataSource=SIMON-VAIO;InitialCatalog=lkl2;IntegratedSecurity=True");sqlcon.Open();stringstr="deletefrombookwherebnum=@bnum";SqlCommandcmd=newSqlCommand(str,sqlcon);cmd.Parameters.Add("@bnum",SqlDbType.NChar,20);cmd.Parameters["@bnum"].Value=this.tnum.Text;cmd.ExecuteNonQuery();sqlcon.Close();this.tnum.Clear();this.tno.Clear();this.tname.Clear();this.tpublisher.Clear();this.tauthor.Clear();this.tclasses.Clear();this.tbenshu.Clear();MessageBox.Show("刪除成功!")查詢圖書代碼SqlConnectioncon=newSqlConnection();//建立數(shù)據(jù)庫(kù)連接con.ConnectionString="DataSource=SIMON-VAIO;InitialCatalog=lkl2;IntegratedSecurity=True;";con.Open();//打開(kāi)連接SqlCommandcmd=newSqlCommand("select*frombookwherebname=@bname",con);cmd.Parameters.Add("@bname",SqlDbType.NChar,20);cmd.Parameters["@bname"].Value=bookname.Text;SqlDataAdapterda=newSqlDataAdapter(cmd);DataTabledt=newDataTable("圖書統(tǒng)計(jì)表");da.TableMappings.Add("BorrowRecord","借閱統(tǒng)計(jì)表");da.TableMappings[0].ColumnMappings.Add("bnum","圖書號(hào)");da.TableMappings[0].ColumnMappings.Add("bname","圖書名");da.TableMappings[0].ColumnMappings.Add("bauthor","作者");da.TableMappings[0].ColumnMappings.Add("bpublic","出版社");da.TableMappings[0].ColumnMappings.Add("bclasses","類別");da.TableMappings[0].ColumnMappings.Add("benshu","本數(shù)");da.Fill(dt);dataGridView1.DataSource=dt;con.Close();圖書更新代碼SqlConnectioncon1=newSqlConnection("DataSource=SIMON-VAIO;InitialCatalog=lkl2;IntegratedSecurity=True;");con1.Open();SqlCommandcmd1=newSqlCommand("updatebooksetbname=@bname,bauthor=@bauthor,bpublic=@bpublic,bclasses=@bclasses,benshu=@benshuwherebnum=@bnum;",con1);cmd1.Parameters.Add("@bnum",SqlDbType.NChar,20);cmd1.Parameters.Add("@bname",SqlDbType.NChar,20);cmd1.Parameters.Add("@bauthor",SqlDbType.NChar,20);cmd1.Parameters.Add("@bpublic",SqlDbType.NChar,20);cmd1.Parameters.Add("@bclasses",SqlDbType.NChar,20);cmd1.Parameters.Add("@benshu",SqlDbType.NChar,20);cmd1.Parameters["@bnum"].Value=cnum.Text;cmd1.Parameters["@bname"].Value=cname.Text;cmd1.Parameters["@bauthor"].Value=cauthor.Text;cmd1.Parameters["@bpublic"].Value=cpublic.Text;cmd1.Parameters["@bclasses"].Value=cclasses.Text;cmd1.Parameters["@benshu"].Value=cbenshu.Text;cmd1.ExecuteNonQuery();con1.Close();um.Clear();ame.Clear();this.cauthor.Clear();this.cpublic.Clear();this.cclasses.Clear();this.cbenshu.Clear();MessageBox.Show("更新成功!");添加用戶代碼SqlConnectionsqlcon=newSqlConnection("DataSource=SIMON-VAIO;InitialCatalog=lkl2;IntegratedSecurity=True;");stringstr="insertintodbo.readervalues(@usernum,@username,@userpassword,@usertype)";sqlcon.Open();SqlCommandcmd=newSqlCommand(str,sqlcon);cmd.Parameters.Add("@usernum",SqlDbType.NChar,20);cmd.Parameters.Add("@username",SqlDbType.NChar,20);cmd.Parameters.Add("@userpassword",SqlDbType.NChar,20);cmd.Parameters.Add("@usertype",SqlDbType.NChar,20);cmd.Parameters["@usernum"].Value=usernum.Text;cmd.Parameters["@username"].Value=username.Text;cmd.Parameters["@userpassword"].Value=userpassword.Text;cmd.Parameters["@usertype"].Value=usertype.Text;cmd.ExecuteNonQuery();sqlcon.Close();this.usernum.Clear();this.username.Clear();this.userpassword.Clear();this.usertype.Clear();MessageBox.Show("用戶添加成功!"刪除用戶代碼SqlConnectionsqlcon=newSqlConnection("DataSource=SIMON-VAIO;InitialCatalog=lkl2;IntegratedSecurity=True");sqlcon.Open();stringstr="deletefromreaderwhereusernum=@usernum";SqlCommandcmd=newSqlCommand(str,sqlcon);cmd.Parameters.Add("@usernum",SqlDbType.NChar,20);cmd.Parameters["@usernum"].Value=this.num.Text;cmd.ExecuteNonQuery();sqlcon.Close();MessageBox.Show("刪除成功!");修改密碼代碼SqlConnectioncon1=newSqlConnection("DataSource=SIMON-VAIO;InitialCatalog=lkl2;IntegratedSecurity=True;");con1.Open();SqlCommandcmd1=newSqlCommand("updatereadersetuserpassword=@userpasswordwhereusernum=@usernum;",con1);cmd1.Parameters.Add("@usernum",SqlDbType.NChar,20);cmd1.Parameters.Add("@userpassword",SqlDbType.NChar,20);cmd1.Parameters["@usernum"].Value=cusernum.Text;cmd1.Parameters["@userpassword"].Value=cuserpassword.Text;cmd1.ExecuteNonQuery();con1.Close();this.cusernum.Clear();this.cuserpassword.Clear();MessageBox.Show("修改成功請(qǐng)從新登陸!");完善讀者信息代碼SqlConnectionsqlcon=newSqlConnection("DataSource=SIMON-VAIO;InitialCatalog=lkl2;IntegratedSecurity=True;");stringstr="insertintodbo.readerifovalues(@usernum,@username,@usersex,@usergrade,@telephone)";sqlcon.Open();SqlCommandcmd=newSqlCommand(str,sqlcon);cmd.Parameters.Add("@usernum",SqlDbType.NChar,20);cmd.Parameters.Add("@username",SqlDbType.NChar,20);cmd.Parameters.Add("@usersex",SqlDbType.NChar,20);cmd.Parameters.Add("@usergrade",SqlDbType.NChar,20);cmd.Parameters.Add("@telephone",SqlDbType.NChar,20);cmd.Parameters["@usernum"].Value=usernum.Text;cmd.Parameters["@username"].Value=username.Text;cmd.Parameters["@usersex"].Value=usersex.Text;cmd.Parameters["@usergrade"].Value=usergrade.Text;cmd.Parameters["@telephone"].Value=telephone.Text;cmd.ExecuteNonQuery();sqlcon.Close();this.usernum.Clear();this.username.Clear();this.userpassword.Clear();this.usertype.Clear();this.usersex.Clear();this.usergrade.Clear();this.telephone.Clear();MessageBox.Show("添加信息成功!");檢索用戶信息代碼if(num.Text==""){MessageBox.Show("請(qǐng)輸入學(xué)生學(xué)號(hào)！");}else{stringstrcon="DataSource=SIMON-VAIO;InitialCatalog=lkl2;IntegratedSecurity=True";SqlConnectionsqlCon=newSqlConnection(strcon);sqlCon.Open();stringsql="select*fromreaderifowhereusernum=@usernum";SqlCommandcmd=newSqlCommand(sql,sqlCon);cmd.Parameters.Add("@usernum",SqlDbType.NChar,20);cmd.Parameters["@usernum"].Value=num.Text;//創(chuàng)建SqlDataReader，必需調(diào)用SqlCommand對(duì)象ExecuteReader方法，而不要直接使用結(jié)構(gòu)函數(shù)。SqlDataReaderdr=cmd.ExecuteReader();if(dr.Read()){this.usernum.Text=dr["usernum"].ToString().Trim();this.username.Text=dr["username"].ToString().Trim();this.usersex.Text=dr["usersex"].ToString().Trim();this.usergrade.Text=dr["usergrade"].ToString().Trim();this.telephone.Text=dr["telephone"].ToString().Trim();MessageBox.Show("歡迎光臨本圖書館來(lái)借書！");}sqlCon.Close();借閱圖書代碼SqlConnectionsqlcon=newSqlConnection("DataSource=SIMON-VAIO;InitialCatalog=lkl2;IntegratedSecurity=True;");stringstr="insertintodbo.borrowifovalues(@bnum,@bname,@bauthor,@bpublic,@bclasses,@benshu,@btime,@usernum,@username,@usersex,@usergrade,@telephone)";sqlcon.Open();SqlCommandcmd=newSqlCommand(str,sqlcon);cmd.Parameters.Add("@bnum",SqlDbType.NChar,20);cmd.Parameters.Add("@bname",SqlDbType.NChar,20);cmd.Parameters.Add("@bauthor",SqlDbType.NChar,20);cmd.Parameters.Add("@bpublic",SqlDbType.NChar,20);cmd.Parameters.Add("@bclasses",SqlDbType.NChar,20);cmd.Parameters.Add("@benshu",SqlDbType.TinyInt);cmd.Parameters.Add("@btime",SqlDbType.Date);cmd.Parameters.Add("@usernum",SqlDbType.NChar,20);cmd.Parameters.Add("@username",SqlDbType.NChar,20);cmd.Parameters.Add("@usersex",SqlDbType.NChar,20);cmd.Parameters.Add("@usergrade",SqlDbType.NChar,20);cmd.Parameters.Add("@telephone",SqlDbType.NChar,20);cmd.Parameters["@bnum"].Value=tno.Text;cmd.Parameters["@bname"].Value=tname.Text;cmd.Parameters["@bauthor"].Value=tauthor.Text;cmd.Parameters["@bpublic"].Value=tpublisher.Text;cmd.Parameters["@bclasses"].Value=tclasses.Text;cmd.Parameters["@benshu"].Value="1";cmd.Parameters["@btime"].Value=System.DateTime.Now;cmd.Parameters["@usernum"].Value=usernum.Text;cmd.Parameters["@username"].Value=username.Text;cmd.Parameters["@usersex"].Value=usersex.Text;cmd.Parameters["@usergrade"].Value=usergrade.Text;cmd.Parameters.Add(newSqlParameter("@borrowtime",DateTime.Now));cmd.Parameters["@telephone"].Value=telephone.Text;cmd.ExecuteNonQuery();sqlcon.Close();SqlConnectioncon1=newSqlConnection("DataSource=SIMON-VAIO;InitialCatalog=lkl2;IntegratedSecurity=True;");con1.Open();SqlCommandcmd1=newSqlCommand("updatebooksetbenshu=benshu-1wherebnum=@bnum",con1);cmd1.Parameters.Add("@bnum",SqlDbType.NChar,20);cmd1.Parameters["@bnum"].Value=tnum.Text;cmd1.ExecuteNonQuery();con1.Close();this.tnum.Clear();this.tno.Clear();this.tname.Clear();this.tauthor.Clear();this.tpublisher.Clear();this.tclasses.Clear();this.num.Clear();this.usernum.Clear();this.username.Clear();this.usersex.Clear();this.usergrade.Clear();this.tbenshu.Clear();this.telephone.Clear();MessageBox.Show("借閱成功!");歸還圖書代碼SqlConnectionsqlcon=newSqlConnection("DataSource=SIMON-VAIO;InitialCatalog=lkl2;IntegratedSecurity=True;");stringstr="insertintodbo.returnifovalues(@bnum,@bname,@bauthor,@bpublic,@bclasses,@benshu,@rtime,@usernum,@username,@usersex,@usergrade,@telephone)";sqlcon.Open();SqlCommandcmd=newSqlCommand(str,sqlcon);cmd.Parameters.Add("@bnum",SqlDbType.NChar,20);cmd.Parameters.Add("@bname",SqlDbType.NChar,20);cmd.Parameters.Add("@bauthor",SqlDbType.NChar,20);cmd.Parameters.Add("@bpublic",SqlDbType.NChar,20);cmd.Parameters.Add("@bclasses",SqlDbType.NChar,20);cmd.Parameters.Add("@benshu",SqlDbType.TinyInt);cmd.Parameters.Add("@rtime",SqlDbType.Date);cmd.Parameters.Add("@usernum",SqlDbType.NChar,20);cmd.Parameters.Add("@username",SqlDbType.NChar,20);cmd.Parameters.Add("@usersex",SqlDbType.NChar,20);cmd.Parameters.Add("@usergrade",SqlDbType.NChar,20);cmd.Parameters.Add("@telephone",SqlDbType.NChar,20);cmd.Parameters["@bnum"].Value=sno.Text;cmd.Parameters["@bname"].Value=sname.Text;cmd.Parameters["@bauthor"].Value=sauthor.Text;cmd.Parameters["@bpublic"].Value=spublisher.Text;cmd.Parameters["@bclasses"].Value=sclasses.Text;cmd.Parameters["@benshu"].Value=sbenshu.Text;cmd.Parameters["@rtime"].Value=System.DateTime.Now;cmd.Parameters["@usernum"].Value=usernum.Text;cmd.Parameters["@username"].Value=username.Text;cmd.Parameters["@usersex"].Value=usersex.Text;cmd.Parameters["@usergrade"].Value=usergrade.Text;cmd.Parameters.Add(newSqlParameter("@returntime",DateTime.Now));cmd.Parameters["@telephone"].Value=telephone.Text;cmd.ExecuteNonQuery();sqlcon.Close();SqlConnectioncon1=newSqlConnection("DataSource=SIMON-VAIO;InitialCatalog=lkl2;IntegratedSecurity=True;");con1.Open();SqlCommandcmd1=newSqlCommand("updatebooksetbenshu=benshu+1wherebnum=@bnum",con1);cmd1.Parameters.Add("@bnum",SqlDbType.NChar,20);cmd1.Parameters["@bnum"].Value=tnum.Text;cmd1.ExecuteNonQuery();con1.Close();this.tnum.Clear();this.sno.Clear();this.sname.Clear();this.sauthor.Clear();this.spublisher.Clear();this.sclasses.Clear();this.sbenshu.Clear();this.num.Clear();this.usernum.Clear();this.username.Clear();this.usersex.Clear();this.usergrade.Clear();this.telephone.Clear();MessageBox.Show("還書成功!");查詢借閱歸還圖書信息代碼