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; els
3、e if (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 tr
4、ue; private void 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); tr
5、y SqlCommand command = 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。Wr
6、iteLine(ex.Message); 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 对象 SqlCom
7、mand command = new SqlCommand(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(”操作数据库
8、出错!”); Console.WriteLine(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 Syst
9、em。Windows.Forms;using System.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
10、(”输入账号与登陆账号不相同,请重新输入”,提示,MessageBoxButtons.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 = c
11、ommand。ExecuteNonQuery(); if (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 toolStripBu
12、tton4_Click(object sender, EventArgs 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,userhelp
13、er。readerid); private void button4_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.Te
14、xt) MessageBox。Show (”两次密码输入不同); else 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(”
15、修改失败”); else MessageBox.Show(”修改成功); catch 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)
16、readsearchbook searchbook = new readsearchbook(); 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 voi
17、d 图书查询ToolStripMenuItem1_Click(object sender, 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, Ev
18、entArgs e) groupBox1.Visible = false; groupBox2.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 s
19、ender, EventArgs e) Application。Exit(); 管理员界面;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 v
20、oid 退出ToolStripMenuItem_Click(object sender, 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(); addre
21、ader。Show(); this.Close(); private void 借书信息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(obje
22、ct sender, EventArgs e) addbook a = new addbook(); 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();
23、 private void 查询出版社信息ToolStripMenuItem_Click(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(
24、object sender, EventArgs e) adminborrow a = 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(); p
25、rivate void 删除ToolStripMenuItem_Click(object 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.Sq
26、lClient;namespace book public partial class 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(); Sq
27、lDataReader datareader = command。ExecuteReader(); 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); /Dbhe
28、lper。connection。Open(); SqlDataReader datareader1 = 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 book
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1