1、图书管理系统源码C#版登录界面:using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace book public partial class login : Form public string password; /用来存储密码 public login() In
2、itializeComponent(); private void button2_Click(object sender, EventArgs e) Application.Exit(); private bool yanzhengshuru() password = textBox3.Text; if (Typename.Text.Trim() = ) MessageBox.Show(请选择登录类型, 登录提示, MessageBoxButtons.OK, MessageBoxIcon.Information); Typename.Focus(); return false; else i
3、f (loginid.Text.Trim() = ) MessageBox.Show(请输入用户名, 登录提示, MessageBoxButtons.OK, MessageBoxIcon.Information); loginid.Focus(); return false; else if (password = ) MessageBox.Show(请输入密码, 登录提示, MessageBoxButtons.OK, MessageBoxIcon.Information); textBox3.Focus(); return false; else return true; private v
4、oid button1_Click(object sender, EventArgs e) userhelper.adminid= loginid.Text; /用户账号 password = textBox3.Text;/用户密码 if (yanzhengshuru() if (Typename.Text.Trim() = 管理员) string sql = string.Format(Select count(*) from admin where adminId=0 and adminpass=1, loginid.Text, password); try SqlCommand comm
5、and = new SqlCommand(sql, Dbhelper.connection); Dbhelper.connection.Open(); int count = (int)command.ExecuteScalar(); if (count 1) MessageBox.Show(用户或密码不存在!); /result = false; else admin admin = new admin(); admin.Show(); catch (Exception ex) MessageBox.Show(操作数据库出错!); Console.WriteLine(ex.Message);
6、 finally Dbhelper.connection.Close(); if (Typename.Text.Trim() = 借阅者) userhelper.readerid =Convert .ToString (loginid.Text); string sql = string.Format(Select count(*) from reader where readerId=0 and readerpass=1, userhelper.readerid,textBox3.Text); try / 创建 Command 对象 SqlCommand command = new SqlC
7、ommand(sql, Dbhelper.connection); / 打开数据库连接 Dbhelper.connection.Open(); / 验证是否为合法用户 int count = (int)command.ExecuteScalar(); if (count 1) MessageBox.Show(用户或密码不存在!); /result = false; else reader reader = new reader(); reader.Show(); catch (Exception ex) MessageBox.Show(操作数据库出错!); Console.WriteLine(
8、ex.Message); /result = false; finally / 关闭数据库连接 Dbhelper.connection.Close(); private void login_Load(object sender, EventArgs e) 读者界面;using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using Sy
9、stem.Data.Sql;using System.Data.SqlClient;namespace book public partial class reader : Form public reader() InitializeComponent(); private void button3_Click(object sender, EventArgs e) string id =Convert.ToString (textBox1.Text); if (id!=userhelper.readerid) MessageBox.Show(输入账号与登陆账号不相同,请重新输入,提示,Me
10、ssageBoxButtons.OK,MessageBoxIcon.Warning); textBox1.Text = ; textBox1.Focus(); else try string sql = string.Format(update reader set islost=0where readerid=1, 是,id); Dbhelper.connection.Open(); SqlCommand command = new SqlCommand(sql,Dbhelper.connection); int result = command.ExecuteNonQuery(); if
11、(result 1) MessageBox.Show(修改失败); else MessageBox.Show(挂失成功); catch MessageBox.Show(error); finally Dbhelper.connection.Close(); private void toolStripButton3_Click(object sender, EventArgs e) groupBox1.Visible = false; groupBox2.Visible = true; private void toolStripButton4_Click(object sender, Eve
12、ntArgs e) groupBox1.Visible = true; groupBox2.Visible = false; private void button5_Click(object sender, EventArgs e) textBox2.Text = ; textBox4.Text = ; textBox5.Text = ; private void Form1_Load(object sender, EventArgs e) toolStrip1.Text = string.Format(学生:0,userhelper.readerid); private void butt
13、on4_Click(object sender, EventArgs e) string id =Convert.ToString (textBox2.Text); if (id!=userhelper.readerid) MessageBox.Show(输入账号与登陆账号不相同,请重新输入,提示,MessageBoxButtons.OK,MessageBoxIcon.Warning); textBox1.Text = ; textBox1.Focus(); else if (textBox4.Text!=textBox5.Text) MessageBox.Show (两次密码输入不同); e
14、lse try string sql = string.Format(update reader set readerpass=0 where readerid=1, textBox4.Text,id); Dbhelper.connection.Open(); SqlCommand command = new SqlCommand(sql,Dbhelper.connection); int result = command.ExecuteNonQuery(); if (result 1) MessageBox.Show(修改失败); else MessageBox.Show(修改成功); ca
15、tch MessageBox.Show(error); finally Dbhelper.connection.Close(); private void toolStripButton6_Click(object sender, EventArgs e) addreader addreader = new addreader(); addreader = new addreader(); private void toolStripButton1_Click(object sender, EventArgs e) readsearchbook searchbook = new readsea
16、rchbook(); searchbook.Show(); private void toolStripButton2_Click(object sender, EventArgs e) borrow a = new borrow(); a.Show(); private void toolStripButton5_Click(object sender, EventArgs e) readerseacherinfo a = new readerseacherinfo(); a.Show(); private void 图书查询ToolStripMenuItem1_Click(object s
17、ender, EventArgs e) readsearchbook a = new readsearchbook(); a.Show(); this.Close(); private void 结束查询ToolStripMenuItem_Click(object sender, EventArgs e) borrow a = new borrow(); a.Show(); this.Close(); private void 修改密码ToolStripMenuItem_Click(object sender, EventArgs e) groupBox1.Visible = false; g
18、roupBox2.Visible = true; private void 挂失ToolStripMenuItem_Click(object sender, EventArgs e) groupBox1.Visible = true; groupBox2.Visible = false; private void 退出ToolStripMenuItem_Click(object sender, EventArgs e) this.Close(); private void button2_Click(object sender, EventArgs e) Application.Exit();
19、 管理员界面;using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;namespace book public partial class admin : Form public admin() InitializeComponent(); private void 退出ToolStripMenuItem_Click(object se
20、nder, EventArgs e) this.Close(); private void admin_Load(object sender, EventArgs e) toolStrip1.Text=string.Format (管理员:登录,userhelper.adminid); private void toolStripButton4_Click(object sender, EventArgs e)/录入学生信息 addreader addreader = new addreader(); addreader.Show(); this.Close(); private void 借
21、书信息ToolStripMenuItem_Click(object sender, EventArgs e) adminborrow a = new adminborrow(); a.Show(); private void 还书信息ToolStripMenuItem_Click(object sender, EventArgs e) adminborrow a = new adminborrow(); a.Show(); private void 添加图书ToolStripMenuItem_Click(object sender, EventArgs e) addbook a = new a
22、ddbook(); a.Show(); private void 删除图书ToolStripMenuItem_Click(object sender, EventArgs e) adminearchbook a = new adminearchbook(); a.Show(); private void 查询图书ToolStripMenuItem_Click(object sender, EventArgs e) adminearchbook a = new adminearchbook(); a.Show(); private void 查询出版社信息ToolStripMenuItem_Cl
23、ick(object sender, EventArgs e) publisher a = new publisher(); a.Show(); this.Close(); private void 修改出版社信息ToolStripMenuItem_Click(object sender, EventArgs e) publisher a = new publisher(); a.Show(); this.Close(); private void 查询学生借阅信息ToolStripMenuItem_Click(object sender, EventArgs e) adminborrow a
24、 = new adminborrow(); a.Show(); private void toolStripButton6_Click_1(object sender, EventArgs e)/借书信息 booksborrow a = new booksborrow(); a.Show(); private void 添加ToolStripMenuItem_Click(object sender, EventArgs e) readerinfo a = new readerinfo(); a.Show(); private void 删除ToolStripMenuItem_Click(obj
25、ect sender, EventArgs e) deletereader a = new deletereader(); a.Show(); 添加图书信息界面:using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace book public partial cla
26、ss addbook : Form public addbook() InitializeComponent(); private void addbook_Load(object sender, EventArgs e) try string sql1 = select booktypename from booktype; SqlCommand command = new SqlCommand(sql1, Dbhelper.connection); Dbhelper.connection.Open(); SqlDataReader datareader = command.ExecuteR
27、eader(); string typename = ; while (datareader.Read() typename = (string)datareader0; comboBox2.Items.Add(typename); datareader.Close(); string sql2 = select publishername from publisher; SqlCommand command1 = new SqlCommand(sql2, Dbhelper.connection); /Dbhelper.connection.Open(); SqlDataReader data
28、reader1 = command1.ExecuteReader(); string publishername = ; while (datareader1.Read() publishername = (string)datareader10; /MessageBox.Show(publishername); comboBox1.Items.Add(publishername); datareader1.Close(); catch MessageBox.Show(error); finally Dbhelper.connection.Close(); private void button2_Click(object sender, EventArgs e) textBox1.Text = null; textBox2.Text = null; textBox4.Text = null; comboBox2.Text = null; comboBox1.Text = null; private string typdid(string a) string id = ; string sqltypeid = string.Format(select booktypeid f
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1