C圖書館管理系統(tǒng)

1、 目錄1、緒論22、數(shù)據(jù)庫設(shè)計(jì)32.1 數(shù)據(jù)庫分析32.1創(chuàng)建數(shù)據(jù)庫43、界面設(shè)計(jì)43.1 登陸界面43.2 圖書管理系統(tǒng)界面83.3 圖書信息界面93.4 圖書歸還界面113.5 圖書借閱界面133.6 用戶信息界面153.7管理員界面163.8注冊界面183.9添加圖書界面194、系統(tǒng)測試214.1 登陸功能214.2 借閱圖書功能224.3 歸還圖書庫功能224.4 圖書信息功能234.5 管理員登陸功能234.6 添加圖書功能 244.7 用戶信息245 、連接數(shù)據(jù)庫245.1連接數(shù)據(jù)庫255.2操作數(shù)據(jù)庫中的數(shù)據(jù)256 、總結(jié)271、緒論2、數(shù)據(jù)庫設(shè)計(jì)2.1 數(shù)據(jù)庫分析本系統(tǒng)利用Vi

2、sual Studio 2010處理數(shù)據(jù)庫的功能，實(shí)現(xiàn)對圖書館信息的管理。主要功能為管理有關(guān)用戶、管理員、書籍和借閱的信息等。本系統(tǒng)的結(jié)構(gòu)分為用戶信息管理模塊、書籍信息管理模塊、借閱信息管理模塊、管理者管理信息模塊和查詢處理模塊。圖書館管理系統(tǒng)框圖如圖所示 進(jìn)入圖書館管理系統(tǒng)借閱圖書查詢圖書增加圖書查詢圖書圖書管理登錄 用戶 管理員失敗成功 2.2創(chuàng)建數(shù)據(jù)庫3、界面設(shè)計(jì)3.1登陸界面amespace 圖書管理系統(tǒng) public partial class Form1 : Form public Form1() InitializeComponent(); public static Form

3、fm = null; private static int ErrorTimes = 0; private void button3_Click(object sender, EventArgs e) this.Close(); private void textBox1_TextChanged(object sender, EventArgs e) private void button1_Click(object sender, EventArgs e) if (textBox1.Text = "" | textBox2.Text = "") Mes

4、sageBox.Show("提示：請輸入用戶名和密碼！", "警告"); SqlConnection conn = new SqlConnection("Server=PC_201402131602;Integrated Security=true;DataBase=圖書管理系統(tǒng)"); conn.Open(); SqlCommand cmd = new SqlCommand("select * from Table_1 where id='" + textBox1.Text.Trim() + "&

5、#39; and us='" + textBox2.Text.Trim() + "'", conn); SqlDataReader sdr = cmd.ExecuteReader(); sdr.Read(); if (sdr.HasRows) MessageBox.Show("登錄成功!", "提示"); Form2 fm = new Form2(); fm.Show(); this.Hide(); else ErrorTimes+; MessageBox.Show("用戶名或密碼不正確！您還有&q

6、uot; + (3 - ErrorTimes) + "次輸入密碼的機(jī)會，請重新輸入!如果超過3次，系統(tǒng)將自動關(guān)閉"); if (ErrorTimes >= 3) ErrorTimes = 0; conn.Close(); private void Form1_Load(object sender, EventArgs e) private void button4_Click(object sender, EventArgs e) if (textBox1.Text = "" | textBox2.Text = "") Mess

7、ageBox.Show("提示：請輸入用戶名和密碼！", "警告"); SqlConnection conn = new SqlConnection("Server=PC_201402131602;Integrated Security=true;DataBase=圖書管理系統(tǒng)"); conn.Open(); SqlCommand cmd = new SqlCommand("select * from Table_2 where uid='" + textBox1.Text.Trim() + "&

8、#39; and usr='" + textBox2.Text.Trim() + "'", conn); SqlDataReader sdr = cmd.ExecuteReader(); sdr.Read(); if (sdr.HasRows) MessageBox.Show("登錄成功!", "提示"); Form7 fm = new Form7(); fm.Show(); this.Hide(); else ErrorTimes+; MessageBox.Show("用戶名或密碼不正確！您還有&

9、quot; + (3 - ErrorTimes) + "次輸入密碼的機(jī)會，請重新輸入!如果超過3次，系統(tǒng)將自動關(guān)閉"); if (ErrorTimes >= 3) ErrorTimes = 0; conn.Close(); private void button2_Click(object sender, EventArgs e) Form8 f1=new Form8(); f1.Show(); private void button5_Click(object sender, EventArgs e) this.Hide(); Form10 f2 = new For

10、m10(); f2.Show(); 3.2圖書管理系統(tǒng)界面namespace 圖書管理系統(tǒng) public partial class Form2 : Form public Form2() InitializeComponent(); private void button5_Click(object sender, EventArgs e) this.Close(); private void button3_Click(object sender, EventArgs e) Form3 f2 = new Form3(); f2.Show(); this.Close(); MessageBo

11、x.Show("您已成功進(jìn)入-圖書信息！"); private void button2_Click(object sender, EventArgs e) Form4 f4 = new Form4(); f4.Show(); this.Close(); MessageBox.Show("您已成功進(jìn)入-還書系統(tǒng)！"); private void button1_Click(object sender, EventArgs e) Form5 f5 = new Form5(); f5.Show(); this.Close(); MessageBox.Show

12、("您已成功進(jìn)入-借書系統(tǒng)！"); 3.3圖書信息namespace 圖書管理系統(tǒng) public partial class Form3 : Form public Form3() InitializeComponent(); private void Form3_Load(object sender, EventArgs e) / TODO: 這行代碼將數(shù)據(jù)加載到表“圖書管理系統(tǒng)DataSet.Table_3”中。您可以根據(jù)需要移動或刪除它。 this.table_3TableAdapter.Fill(this.圖書管理系統(tǒng)DataSet.Table_3); privat

13、e void textBox1_TextChanged(object sender, EventArgs e) private void button1_Click(object sender, EventArgs e) this.Close(); 3.4歸還圖書namespace 圖書管理系統(tǒng) public partial class Form4 : Form public Form4() InitializeComponent(); private void button1_Click(object sender, EventArgs e) if (textBox1.Text = &quo

14、t;") MessageBox.Show("提示：請輸入所借書籍編號！", "警告"); SqlConnection conn = new SqlConnection("Server=PC_201402131602;Integrated Security=true;DataBase=圖書管理系統(tǒng)"); conn.Open(); SqlCommand cmd = new SqlCommand("select * from Table_4 where sid='" + textBox1.Text.Tr

15、im() + "' ", conn); SqlDataReader sdr = cmd.ExecuteReader(); sdr.Read(); if (sdr.HasRows) MessageBox.Show("該書已還", "提示"); else sdr.Close(); string myinsert = "insert into Table_4 (sid) values ('" + textBox1.Text + "') " SqlCommand mycom =

16、new SqlCommand(myinsert, conn); mycom.ExecuteNonQuery(); conn.Close(); conn.Dispose(); MessageBox.Show("您已還書成功！"); private void Form4_Load(object sender, EventArgs e) / TODO: 這行代碼將數(shù)據(jù)加載到表“圖書管理系統(tǒng)DataSet.Table_4”中。您可以根據(jù)需要移動或刪除它。 this.table_4TableAdapter.Fill(this.圖書管理系統(tǒng)DataSet.Table_4); / TOD

17、O: 這行代碼將數(shù)據(jù)加載到表“圖書管理系統(tǒng)DataSet.Table_3”中。您可以根據(jù)需要移動或刪除它。 this.table_3TableAdapter.Fill(this.圖書管理系統(tǒng)DataSet.Table_3); private void button2_Click(object sender, EventArgs e) this.Close(); Form2 f2 = new Form2(); f2.Show(); 3.5已借圖書namespace 圖書管理系統(tǒng) public partial class Form5 : Form public Form5() Initialize

18、Component(); private void button1_Click(object sender, EventArgs e) this.Close(); Form2 f2 = new Form2(); f2.Show(); private void Form5_Load(object sender, EventArgs e) / TODO: 這行代碼將數(shù)據(jù)加載到表“圖書管理系統(tǒng)DataSet.Table_4”中。您可以根據(jù)需要移動或刪除它。 this.table_4TableAdapter.Fill(this.圖書管理系統(tǒng)DataSet.Table_4); / TODO: 這行代碼將

19、數(shù)據(jù)加載到表“圖書管理系統(tǒng)DataSet.Table_3”中。您可以根據(jù)需要移動或刪除它。 this.table_3TableAdapter.Fill(this.圖書管理系統(tǒng)DataSet.Table_3); private void button2_Click(object sender, EventArgs e) if (textBox1.Text = "") MessageBox.Show("提示：請輸入所借書籍編號！", "警告"); SqlConnection conn = new SqlConnection("S

20、erver=PC_201402131602;Integrated Security=true;DataBase=圖書管理系統(tǒng)"); conn.Open(); SqlCommand cmd = new SqlCommand("select * from Table_4 where sid='" + textBox1.Text.Trim() + "' ", conn); SqlDataReader sdr = cmd.ExecuteReader(); sdr.Read(); if (sdr.HasRows) MessageBox.S

21、how("該書已借", "提示"); else sdr.Close(); string myinsert = "insert into Table_4 (sid) values ('" + textBox1.Text + "') " SqlCommand mycom = new SqlCommand(myinsert, conn); mycom.ExecuteNonQuery(); conn.Close(); conn.Dispose(); MessageBox.Show("您已借書成功！

22、"); private void textBox2_TextChanged(object sender, EventArgs e) 3.6用戶信息namespace 圖書管理系統(tǒng) public partial class Form6 : Form public Form6() InitializeComponent(); private void Form6_Load(object sender, EventArgs e) / TODO: 這行代碼將數(shù)據(jù)加載到表“圖書管理系統(tǒng)DataSet.Table_1”中。您可以根據(jù)需要移動或刪除它。 this.table_1TableAdapt

23、er.Fill(this.圖書管理系統(tǒng)DataSet.Table_1); private void button1_Click(object sender, EventArgs e) this.Close(); 3.7 管理員主界面namespace 圖書管理系統(tǒng) public partial class Form7 : Form public Form7() InitializeComponent(); private void button2_Click(object sender, EventArgs e) Form6 f1 = new Form6(); f1.Show(); Messa

24、geBox.Show("您已成功進(jìn)入-用戶信息！"); private void button3_Click(object sender, EventArgs e) Form3 f2 = new Form3(); f2.Show(); MessageBox.Show("您已成功進(jìn)入-圖書信息！"); private void button1_Click(object sender, EventArgs e) Form9 f2 = new Form9(); f2.Show(); MessageBox.Show("您已成功進(jìn)入-添加圖書系統(tǒng)！&qu

25、ot;); private void button4_Click(object sender, EventArgs e) this.Close(); 3.8注冊界面namespace 圖書管理系統(tǒng) public partial class Form8 : Form public Form8() InitializeComponent(); private void button1_Click(object sender, EventArgs e) if (textBox1.Text = "" | textBox2.Text = "") MessageBo

26、x.Show("提示：請輸入用戶名和密碼！", "警告"); SqlConnection conn = new SqlConnection("Server=PC_201402131602;Integrated Security=true;DataBase=圖書管理系統(tǒng)"); conn.Open(); SqlCommand cmd = new SqlCommand("select * from table_1 where id='" + textBox1.Text.Trim() + "' a

27、nd us='" + textBox2.Text.Trim() + "'", conn); SqlDataReader sdr = cmd.ExecuteReader(); sdr.Read(); if (sdr.HasRows) MessageBox.Show("該用戶已注冊，請使用其他用戶名", "提示"); else sdr.Close(); string myinsert = "insert into table_1(id,us) values ('" + textBox1

28、.Text + "','" + textBox2.Text + "')" SqlCommand mycom = new SqlCommand(myinsert, conn); mycom.ExecuteNonQuery(); conn.Close(); conn.Dispose(); MessageBox.Show("您已注冊成功！"); private void button2_Click(object sender, EventArgs e) this.Close(); private void Form8

29、_Load(object sender, EventArgs e) 3.9 添加圖書namespace 圖書管理系統(tǒng) public partial class Form9 : Form public Form9() InitializeComponent(); private void button2_Click(object sender, EventArgs e) private void button1_Click(object sender, EventArgs e) SqlConnection conn = new SqlConnection("server=PC_2014

30、02131602;database=圖書管理系統(tǒng);integrated Security=true"); string sql = "insert into Table_3 (sid,sdata,sname) values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "')" conn.Open(); SqlCommand comm = new SqlCommand

31、(sql, conn); if (conn.State = ConnectionState.Closed) conn.Open(); if (Convert.ToInt32(comm.ExecuteNonQuery() > 0) label4.Text = "成功！" MessageBox.Show("您已成功添加數(shù)據(jù)！"); else label4.Text = "失敗！" 4、 系統(tǒng)測試登陸借閱圖書歸還圖書圖書信息管理員登陸添加圖書用戶信息5、連接數(shù)據(jù)庫為數(shù)據(jù)庫BookManage和本系統(tǒng)之間建立一個數(shù)據(jù)連接。(1)在服務(wù)器

32、資源管理器中右擊“數(shù)據(jù)連接”節(jié)點(diǎn)(VS 2008中操作)。在彈出的快捷菜單中執(zhí)行“添加連接”命令，打開Data Link Properties對話框。切換到Provider選項(xiàng)卡，選中列表框中的Microsoft OLE DB Provider for SQL Server項(xiàng)。單擊“下一步”切換到Connection選項(xiàng)卡。(2)在其中的第一個下拉列表框中選擇數(shù)據(jù)庫所在服務(wù)器名稱。輸入登錄服務(wù)器信息后選擇數(shù)據(jù)庫BookManage，然后單擊測試按鈕。如果測試成功，單擊“確定”按鈕。5.1 連接數(shù)據(jù)庫(1)定義數(shù)據(jù)庫連接字符串，代碼如下：Private static string Connect

33、String = "Data Source= (local)sqlexpress;DataBase=BookManage.mdf"(2)創(chuàng)建Connection對象，代碼如下：SqlConnection con = new SqlConnection(ConnectString);(3)打開連接，代碼如下：con.Open();(4)關(guān)閉連接，代碼如下：con.Close();5.2操作數(shù)據(jù)庫中的數(shù)據(jù)using System;using System.Collections.Generic;using System.Linq;using System.Text;using

34、System.Data;using System.Data.SqlClient;namespace BookManage class DataAccess private static string ConnectString = "Data Source =SQLEXPRESS;AttachDbFilename=F:BookManagedataBookManage.mdf;Integrated Security=False"/數(shù)據(jù)庫連接字符串 / <summary> / 根據(jù)表名獲取數(shù)據(jù)集的表 / </summary> / <param na

35、me="table"></param> / <returns></returns>public static DataTable GetDataSetByTableName(string table) using (SqlConnection con = new SqlConnection(ConnectString)/創(chuàng)建數(shù)據(jù)庫連接對象 string sql = "select * from " + table + ""/查詢sql語句try SqlDataAdapter adapter =

36、 new SqlDataAdapter(sql, con);/創(chuàng)建適配器對象 DataSet ds = new DataSet();/創(chuàng)建數(shù)據(jù)集對象 adapter.Fill(ds, "table");/填充數(shù)據(jù)集 return ds.Tables0;/返回?cái)?shù)據(jù)表 catch (SqlException ex) throw new Exception(ex.Message); ; public static DataSet GetDataSetBySql(string sql) using (SqlConnection con = new SqlConnection(ConnectString)/創(chuàng)建數(shù)據(jù)庫連接對象 SqlDataAdapter adapter = new SqlDataAdapter(sql,con);/創(chuàng)建適配器對象 DataSet ds = new DataSet