-
大小: 6.19MB文件類型: .rar金幣: 2下載: 0 次發(fā)布日期: 2023-08-12
- 語(yǔ)言: 其他
- 標(biāo)簽: sql??數(shù)據(jù)庫(kù)??圖書館??系統(tǒng)??
資源簡(jiǎn)介
附帶源碼,ppt,設(shè)計(jì)報(bào)告

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;
namespace?BookSystem
{
????public?partial?class?BookClass?:?Form
????{
????????public?BookClass()
????????{
????????????InitializeComponent();
????????}
????????private?void?btn_back_Click(object?sender?EventArgs?e)
????????{
????????????this.Close();
????????????ManagerForm?main?=?new?ManagerForm();
????????????main.Show();
????????}
????????private?void?BookClass_Load(object?sender?EventArgs?e)
????????{
????????????string?sq2?=?“SELECT?bt_type?FROM?[BookType]?“;
????????????SqlCommand?command1?=?new?SqlCommand(sq2?DBHelper.connection);
????????????try
????????????{
????????????????string?booktype;
????????????????DBHelper.connection.Open();
????????????????SqlDataReader?dataReader?=?command1.ExecuteReader();
????????????????while?(dataReader.Read())
????????????????{
????????????????????booktype?=?(string)dataReader[“bt_type“];
????????????????????this.listBox1.Items.Add(booktype);
????????????????}
????????????????dataReader.Close();
????????????}
????????????catch
????????????{
????????????????MessageBox.Show(“讀取數(shù)據(jù)庫(kù)出錯(cuò)!“);
????????????}
????????????finally
????????????{
????????????????DBHelper.connection.Close();
????????????}
????????}
????????private?void?btn_refresh_Click(object?sender?EventArgs?e)
????????{
????????????listBox1.Items.Clear();
????????????string?sq2?=?“SELECT?bt_type?FROM?[BookType]?“;
????????????SqlCommand?command1?=?new?SqlCommand(sq2?DBHelper.connection);
????????????try
????????????{
????????????????string?booktype;
????????????????DBHelper.connection.Open();
????????????????SqlDataReader?dataReader?=?command1.ExecuteReader();
????????????????while?(dataReader.Read())
????????????????{
????????????????????booktype?=?(string)dataReader[“bt_type“];
????????????????????this.listBox1.Items.Add(booktype);
????????????????}
????????????????dataReader.Close();
????????????}
????????????catch
????????????{
????????????????MessageBox.Show(“讀取數(shù)據(jù)庫(kù)出錯(cuò)!“);
????????????}
????????????finally
????????????{
????????????????DBHelper.connection.Close();
????????????}
????????}
????????private?void?btn_add_Click(object?sender?EventArgs?e)
????????{
????????????if?(txt_class.Text?==?““?||?txt_class.Text?==?“請(qǐng)輸入圖書類別“)
????????????????MessageBox.Show(“圖書類別不允許為空!“?“操作提示“?MessageBoxButtons.OK?MessageBoxIcon.Information);
????????????else
????????????{
????????????????try
????????????????{
????????????????????string?sql?=?string.Format(“insert?into?BookType(bt_type)?values(‘{0}‘)?“?txt_class.Text.Trim());
????????????????????SqlCommand?command?=?new?SqlCommand(sql?DBHelper.connection);
????????????????????DBHelper.connection.Open();
????????????????????int?result?=?command.ExecuteNonQuery();
????????????????????if?(result?1)
?
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件?????????19??2010-06-20?23:36??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\注意.txt
?????文件????2223104??2010-06-25?22:46??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\演示文稿\圖書館管理系統(tǒng).ppt
?????文件????4190027??2010-06-21?02:28??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序錄像\數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)錄像.exe
?????文件????????458??2010-06-03?14:16??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\app.config
?????文件???????8532??2010-06-21?02:00??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\BookClass.cs
?????文件???????6208??2010-06-21?02:00??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\BookClass.Designer.cs
?????文件???????5814??2010-06-21?02:00??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\BookClass.resx
?????文件????2293760??2010-06-21?02:37??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\BookDataba
?????文件?????573440??2010-06-21?02:37??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\BookDataba
?????文件???????9332??2010-06-20?01:32??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\BookSystem.csproj
?????文件????????485??2010-06-03?00:54??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\BookSystem.csproj.user
?????文件??????31951??2010-06-21?01:25??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\Borrowandreturn.cs
?????文件??????36095??2010-06-20?01:31??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\Borrowandreturn.Designer.cs
?????文件???????6402??2010-06-20?01:31??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\Borrowandreturn.resx
?????文件???????2937??2010-06-06?16:39??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\ChangePwd.cs
?????文件???????6326??2010-06-06?16:39??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\ChangePwd.Designer.cs
?????文件???????5814??2010-06-06?16:39??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\ChangePwd.resx
?????文件????????682??2010-06-17?22:54??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\DBHelper.cs
?????文件???????5365??2010-06-19?21:13??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\Loginform.cs
?????文件???????8637??2010-06-19?13:52??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\Loginform.Designer.cs
?????文件???????6016??2010-06-19?13:52??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\Loginform.resx
?????文件??????11478??2010-06-16?23:58??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\Manager.cs
?????文件??????21367??2010-06-16?20:55??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\Manager.Designer.cs
?????文件???????5814??2010-06-16?20:55??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\Manager.resx
?????文件???????3371??2010-06-20?16:09??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\ManagerForm.cs
?????文件??????19381??2010-06-20?16:09??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\ManagerForm.Designer.cs
?????文件??????11172??2010-06-20?16:09??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\ManagerForm.resx
?????文件????????495??2010-06-08?16:30??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\Program.cs
?????文件???????1376??2010-06-02?23:53??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\Properties\AssemblyInfo.cs
?????文件???????2870??2010-06-02?23:53??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\Properties\Resources.Designer.cs
............此處省略236個(gè)文件信息
評(píng)論
共有 條評(píng)論