图书管理系统

有一个表是代码创建，另外的两个用手工创建：创建表代码如下use课程设计create table bookBorr(users char(10),bookName char(20) primary key,borrowtime datetime,)insertinto bookBorr(users,bookName,borrowtime) values('101','马概','2013-05-12 07:43:32');insertinto bookBorr(users,bookName,borrowtime) values('102','马概','2013-05-14 07:59:32');insertinto bookBorr(users,bookName,borrowtime) values('105','李阳英语','2013-05-15 07:56:32'); insertinto bookBorr(users,bookName,borrowtime) values('105','概率论','2013-04-25 09:23:34'); insertinto bookBorr(users,bookName,borrowtime) values('105','线性代数','2013-5-16 16:53:32'); insertinto bookBorr(users,bookName,borrowtime) values('101','线性代数','2013-05-17 07:23:32'); insertinto bookBorr(users,bookName,borrowtime) values('104','马概','2013-05-18 07:23:32');insertinto bookBorr(users,bookName,borrowtime) values('102','数据库','2013-05-18 10:32:56'); insertinto bookBorr(users,bookName,borrowtime) values('103','红楼梦','2013-05-19 07:45:26'); insertinto bookBorr(users,bookName,borrowtime) values('104','财经法规','2013-05-19 11:23:45'); insertinto bookBorr(users,bookName,borrowtime) values('104','会计基础','2013-05-19 14:33:32'); insertinto bookBorr(users,bookName,borrowtime)values('101','李阳英语','2013-05-19 16:56:24');insertinto bookBorr(users,bookName,borrowtime)values('101','数据库','2013-05-19 19:26:24');insertinto bookBorr(users,bookName,borrowtime)values('101','财经法规','2013-05-19 20:36:24');insertinto bookBorr(users,bookName,borrowtime)values('101','概率论','2013-05-20 07:56:24');insertinto bookBorr(users,bookName,borrowtime)values('101','美术鉴赏','2013-05-20 12:16:24');insertinto bookBorr(users,bookName,borrowtime)values('101','C 程序设计','2013-05-21 10:30:34');点击执行，执行SQL语句，然后bookBorr表建成。

触发器创建代码：触发器（1）create trigger bookBorr_teston bookBorrfor insertasbegindeclare @a char(10),@b datetime,@c smallint,@d datetime,@e char(20)select @a=(select users from inserted)select @e=(select bookName from inserted)select @c=(select count(*)from bookBorr where users like @a and borrowtime is not null) select @b=(select min(borrowtime)from bookBorr where users like @a)select @d=datediff(day,@b,getdate())if(@c>8)beginraiserror('超过最大借阅量',16,1)rollback transactionendelse if(@d>30)beginraiserror('有图书超过最大借阅时间',16,1)rollback transactionendelseupdate bookifoSET bookifo.bookNum=bookifo.bookNum-1 where bookName=@eEnd触发器（2）create trigger bookBorr_HSon bookBorrfor deleteasbegindeclare @a char(20)select @a=(select bookName from deleted) update bookifoSET bookifo.bookNum=bookifo.bookNum+1 where bookName=@aEnd窗体创建以及代码：管理员登录界面用户登陆界面代码如下：private void btnYes_Click_1(object sender, EventArgs e){string connString = "Data Source=supervisor;Initial Catalog=课程设计;Integrated Security=True;Pooling=False";//使用SQL Sever身份验证SqlConnection connection = new SqlConnection(connString);connection.Open();switch (cbo.SelectedItem.ToString()){case"用户":{string a = String.Format("Select count(*) from lcifo where users='{0}' and pwd='{1}'", txtname.Text, txtpwd.Text);SqlCommand command = new SqlCommand(a, connection);int jieguo = (int)command.ExecuteScalar(): connection.Close();if (jieguo == 1){MessageBox.Show("欢迎进入图书管理系统！", "登录成功！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);Form2 Form2 = new Form2();//创建Form2窗体的对象Form2.Show();//把窗体弹出来this.Hide();}else{MessageBox.Show("你输入有误！", "登录失败！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);}}break;case"管理员":{if (txtname.Text == "admin" && txtpwd.Text == "123456"){MessageBox.Show("欢迎进入图书管理系统！", "登录成功！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);Form13 f = new Form13();//创建Form13窗体的对象f.Show();//把窗体弹出来this.Hide();}else{MessageBox.Show("你输入有误！", "登录失败！", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);}}break;}}private void btnCancel_Click_1(object sender, EventArgs e){txtname.Text = "";txtpwd.Text = "";txtname.Focus();}}主窗体分为用户登陆主窗体和管理员登陆主窗体，窗体如下图所示：管理员登陆后，点击新图书录入，弹出窗体名为bookMsgFrmprivate void tsmNewBook_Click(object sender, EventArgs e){bookMsgFrm bookMsgFrm = new bookMsgFrm(); //创建子窗体对象bookMsgFrm.MdiParent = this; //指定当前窗体为MDI父窗体bookMsgFrm.Show(); //打开子窗体tsMg.Text = bookMsgFrm.Text; //在状态栏显示操作内容}用户登陆后，点击弹出窗体在父窗体操作，和管理员登陆后新图书录入操作一样。