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??

?屬性????????????大小?????日期????時(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\BookDatabase.mdf

?????文件?????573440??2010-06-21?02:37??數(shù)據(jù)庫(kù)課程設(shè)計(jì)——圖書館管理系統(tǒng)\程序源代碼\BookSystem\Backup\BookSystem\BookDatabase_log.ldf

?????文件???????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è)文件信息