C#实验c-图书管理系统源代码

1.登陆界面

OleDbConnectioncn=newOleDbConnection(uProvider=Microsoft.Jet.OLEDB.4.0;Data

Source=C:\\test.mdb;n);

cn.Open();

cn.Close();

//读取数据到DataTable

OleDbConnectioncn=newOleDbConnection(uProvider=Microsoft.Jet.OLEDB.4.0;Data

Source=C:\\test.mdb;*1);

DataTableuserTbl=newDataTable();

OleDbDataAdapterda=newOleDbDataAdapter("SELECT*FROM[User]”，cn);

da.Fill(userTbl);

//插入-，条记录

OleDbConnectioncn=newOleDbConnection(HProvider=Microsoft.Jet.OLEDB.4.0;Data

Source=C:\\test.mdb;n);

OleDbCommandcmd=newOleDbCommand("INSERTINTO[User]([ID],[UserName],

[UserPassword])VALUES(1,'usejab','123')”，cn);

cn.Open();

cmd.ExecuteNonQueryO;

cn.Close();

//更新

OleDbConnectioncn=newOleDbConnection(uProvider=MicrosoftJet.OLEDB.4.0;Data

Source=C:\\test.mdb;**);

OleDbCommandcmd=newOleDbCommand(,,UPDATE[User]SET[UserPassword]=,newpwd'

WHERE[UserName]='user_ab'M,cn);

cn.Open();

cmd.ExecuteNonQueryO;

cn.Close();

主要代码：

publicpartialclassLoginForm:Form{

publicstaticstringuacc;

publiestaticstringupsw;

publicstaticstringuname;

publicstaticstringusex;

publicstaticstringupart;

publicstaticstringuright;

publicLoginForm()

(

InitializeComponent0;

privatevoidloginbtn_Click(objectsender,EventArgse)

(

if(this.useracctxt.Text.Trim()==""&&this,pswtxt.Text==

(

MessageBox.Show(“请输入您的用户名和密码！"，"提示！”)；

return;

)

try

(

stringsql;

sql="select*fromtb_userwhereuacc='"+this,useracctxt.Text+andupsw=,

+this,pswtxt.Text+

OleDbDataReaderdr=DBIIelp.OleReader(sql);

dr.Read();

if(dr.HasRows)

{

uacc=this,useracctxt.Text;

upsw=this,pswtxt.Text;

uname=dr［，/uname/，］.ToStringO;

usex=dr［，zusex，/］.ToStringO;

upart=drE^upart*].ToStringO;

uright=dr[^uright^].ToStringO;

MainFormaf=newMainForm(this);

this.Hide();

this,useracctxt.Clear();

this.pswtxt.Clear();

af.Show();

)

else

(

此55网68。上$110八〃账号或密码错误！"，”提示！〃)；

this,useracctxt.Clear();

this,pswtxt.Clear();

this,useracctxt.Focus0;

)

)

catch(Exception)

(

\怙$S&8。F5。仁5110火("数据库无法连接！〃，〃警告！〃)；

}

)

privatevoidcancelbtn_Click(objectsender,Event.Argse)

(

Application.Exit();

)

privatevoidLoginForm_Closing(objectsender,FormC1osingEvcntArgse)

(

.Application.Exit();

}

}

2.主界面(图较小，自己可以拉大点)

♦图书管理系统

主要代码就不写了，很简单。

3.权限设置

主要代码：

publicpartialclassRightSet:Form

(

publicRightSet0

InitializeComponent();

privatevoidRightSetLoad(objectsender,EventArgse)

this,rightbox.Selectedlndex=0;

//this.treeright.ExpandAl1();

FillO；

)

privatevoidokbtn_Click(objectsender,EventArgse)

(

if(this,txtnum.Text二二string.Empty)

(

\1*5@名。8。-511剧(〃请输入最大借阅图书数量！〃，”提示！〃)；

return;

)

if(this,txtday.Text==string.Empty)

(

MessageBox.Show("请输入最大借阅图书时间！。〃提示！〃)；

return;

}

if(this,txtcost.Text==string.Empty)

(

MessageBox.Show(”请输入借书押金金额！"，"提示！")；

return;

)

if(this,txtfine.Text==string.Empty)

(

MessageBox.Show("请输入超期罚款金额！”，〃提示！“)；

return;

)

if(this,txttim.Text==string.Empty)

(

MessageBox.Show(〃请输入图书遗失罚款倍数！〃，”提示！〃);

return;

)

ArrayListarr=newArrayList();

foreach(TreeXodenodesinthis,treeright.Nodes)

(

if(nodes.Checked)

{

arr.Add("l");

)

else

arr.Add("O");

}

foreach(TreeNodenodeinnodes.Nodes)

{

if(node.Checked)

(

arr.Add(T);

}

else

(

arr.Add("0");

)

)

)

stringf]a=newstring[l1];

for(inti=0;i<arr.Count;i++)

(

if(arr[i].ToString0.TrimO=T)

(

a[i]="yes";

)

else

(

a[i]="no";

)

}

stringsql=string.Empty;

sql+="select*fromtbrightwhereuright二+this.rightbox.Text+

DatciTablodt=DBHe1p.ExeOleCommand(sql);

boolb=false;

while(dt.Rows.Count!=0)

(

b=true;

break;

}

stringsqll;

if(b)

sqll=?Xupdatetb_rightset

sqll+=“maxbook二'"+this,txtnum.Text+

sqll+二“maxdale二+this,txtday.Text+

sqll+二//rcost.二>+this,txtcost.Text+

sql1+二rfine=+this,txtfine.Text+

ft.•，〃

sqll+=rtim=+this,txttim.Text+

sqll+="rbm='〃+a[0]+“，〃；

sqll+=rum=+a[l]+"I”;

sqll+二rrm=+a[2]+

sqll+二rbornF+a[3]

〃•，，，,

sqll+二ns=+a[4]

sqll+=/zrbis-/z+a[5]

sqll+=〃ruis='"+a[6]

sqll+=“rboris='"+a[7]

sqll+=〃rb]p二,〃+a⑻+”:；

sqll+二"rbl='"+a[9]

sqll+二"rlp='"+a[10]+”；

sql1+=z/whereuright->/z+this,rightbox.Text+"

}

else

(

sqll=/zinsertinto

tb_right(uright,maxbook,maxdate,rcost,rfine,rtim,rbm,rum,rrm,rborm,ris,rbis,ruis,rboris,rblp

,rbl,rlp)z，;

sql1+="values(**+this,rightbox.Text+"+this,txtnum.Text+"+

this,txtday.Text+"+this,txtcost.Text+"+this,txtfine.Text+"+

this,txttim.Text+a[0]+〃'，'〃+a[l]+〃'，'〃+a[2]+〃'，'〃+a[3]+〃，/"+a[4]+

a[5]+〃'，'"+a[6]+〃'，'"+a[7]+〃'，'"+a[8]+〃'，’"+a[9]+〃'，'"+a[10]+

)

DataTab1edt1=DBHelp.ExeOleCommand(sqll);

FillO;

)

privatevoidFi11()

(

stringsql;

sql="selectridasID号，urightas用户身份，maxbookas最大借书数量，maxdateas最

大借阅时间，rcostas押金，rfineas超期罚率，rtimas遗失赔率，rbmas图书管理,rumas用户管

理,rnnas权限管理,rbormas借阅管理,risas信息杳询，rbisas图书信息查询,ruisas用户信息查

询，rborisas借阅历史查询,rblpas图书挂失处理,rblas图书挂失,ripas挂失处理fromtb_right";

iIedt=DBHoIp.ExeOleCommand(sql);

this.dataGridViewl.DataSource=dt;

privatevoidcell_click(objectsender,DataGridViewCe11EvenlArgse)

(

this,rightbox.Text=this.dataGridViewl[1,

this.dataGridViewl.CurrentCell.Rowindex].Value.ToStringO.TrimO;

this,txtnum.Text=this.dataGridViewl[2,

this.dataGridViewl.CurrentCell.Rowindex].Value.ToString().Trim();

this,txtday.Text=this.dataGridViewl[3,

this.dataGridViewl.CurrentCell.Rowindex].Value.ToStringO.Trim();

this,txtcost.Text=this.dataGridViewl[4,

this.dataGridViewl.CurrentCell.Rowindex].Value.ToStringO.TrimO;

this,txtfine.Text=this.dataGridViewl[5,

this.dataGridViewl.CurrentCell.Rowindex].Value.ToStringO.TrimO；

this,txttim.Text=this.dataGridViewl[6,

this.dataGridViewl.CurrentCell.Rowindex].Value.ToString().TrimO；

ArrayListlist=newArrayListO;

stringsql="select*fromtbrightwhereuright=,+this,rightbox.Text+

DataTabledt=DBHelp.ExeOleCommand(sql);

if(dt.Rows.Count!=0)

(

for(inti=0;i<11;i++)

{

list.Add(dt.Rows[0][7+i].ToString());

)

ArrayListarr=newArrayList();

foreach(TrecNodenodesinthis,treeright.Nodes)

(

arr.Add(nodes);

foreach(TreeXodenodeinnodes.Nodes)

(

arr.Add(node);

)

)

for(inti=0;i<1ist.Count;i++)

if(1ist[i].ToStringO="yes")

((TreeNode)arr[i]).Checked=true;

)

else

(

((TreeNode)arr[i]).Checked=false;

)

)

)

}

4.权限修

主要代码：

publicpartialclassIserRight:I'orm

(

publicUserRightO

{

InitializeComponent();

}

privatevoidbtncancel_Click(objectsender,EventArgse)

(

this.CloseO;

)

pi'ivatevoidUserRight_Load(objectsender,EventArgse)

this.checkbox.Selectedlndex=0;

this,partbox.Selectedlndex=0;

)

privatevoidFill()

(

if(this,checkbox.Text=

(

MessageBox.Show("请选择要使用的查询字段！"，”提示！〃)；

return;

}

if(this,partbox.Text==

(

MassageBox.Show("请选择用户所在的部门！“，"提示！”)；

return;

)

stringsql=string.Empty;

sql+="selectuidasID号，uaccas帐号，unameas姓名，usexas性别，upartas部

fJ,utelphoneas移动电话，uphoneas固定电话，udateas注册II期，urightas权限fromtbuser";

if(this,checktxt.Text!="〃)

(

stringc=this,checkbox.Selectedlndex.ToStringO;

switch(c)

{

case"0":〃用户帐号

if(this,checktxt.Text1=string.Empty)

{

sql+="whereuacc1ike'+this,checktxt.Text+"%'";

)

break;

case"1":〃用户姓名

if(this,checktxt.Text!=string.Empty)

(

sql+=〃whereuname1ike'+this,checktxt.Text+"%'";

)

break;

default:

break;

)

if(this,partbox.Selectedlndex.ToStringO!=〃0")

sql+="andupart='"+this,partbox.Text+〃'”；

}

)

else

(

if(this,partbox.Selectedlndex.ToStringO!=〃0")

(

sql+="whereuparl='"+this,partbox.Text+

)

)

sql+="orderbyuaccasc”;

DataTabledt=DBHelp.Exe01eCommand(sql);

this.dataGridViewl.DataSource=dt;

}

privatevoidcheckbtnClick(objectsender,EventAi'gse)

(

FillO；

}

privatevoidcell_click(objectsender,DataGridViewCe11KventArgse)

{

this,txtuacc.Text=this.dataGridViewl[1,

this.dataGridViewl.CurrentCell.Rowindex].Value.ToString().TrimO;

this,txtname.Text=this.dataGridViewl[2,

this.dataGridViewl.CurrentCell.Rowindex].Value.ToString().Trim();

this.txtsex.Text=this.dataGridViewl[3,

this.dataGridViewl.CurrentCel1.Rowindex].Value.ToString().TrimO;

this,txtpart.Text=this.dataGridViewl[4,

this.dataGridViewl.CurrentCell.Rowindex].Value.ToString().TrimO；

this,txttel.Text=this.dataGridViewl[5,

this.dataGridViewl.CurrentCell.Rowindex].Value.ToString().TrimO；

this,txtphone.Text=this.dataGridViewl[6,

this.dataGridViewl.CurrentCel1.Rowindex].Value.ToString().TrimO;

this,txtdate.Text=this.dataGridViewl[7,

this.dataGridViewl.CurrentCell.Rowindex].Value.ToString0.TrimO;

this,txtright.Text=this.dataGridViewl[8,

this.dataGridViewl.CurrentCel1.Rowindex].Value.ToString().TrimO；

this.txtright.Enabled=true;

)

privatevoidbtnchange_Click(objectsender,EventArgse)

{

if(this,txtuacc.Text二二”〃)

(

MessageBox.Show("执行操作前，请先在下表选择要修改的用户！"提示！")；

return;

)

DialogResultres;

尚essageBox.Show("您确定要修改该用户吗?"，”提示！〃，McssagcBoxBuilons.YesNo);

if(res==DialogResuIt.Yes)

(

stringsql=string.Empty;

sql+="updatetb_userseturight='"+this.txtright.Text+“'";

sql+="whereuacc='"+this.txluacc.Texl+“'";

DataTabledt=DBHoIp.ExeOleCommand(sql);

MessageBox.Show("修改成功！"，"恭喜！”);

FillO;

)

}

)

5.添加图书信息

主要代码：

publicpartialclassNewBook:Form

I

publicNewBook()

(

InitializeComponent();

)

privatevoidretbtnClick(objectsender,EventArgse)

(

this.Hide();

}

privatevoidsavebtnClick(objectsender,HventArgse)

(

if(this,booknotxt.Text==〃")

(

MessageBox.Show("请输入图书的信息!”，"提示！”)；

return;

)

if(this,booknametxt.Text=="")

(

MessageBox.Show("请输入图书的信息！"，"提示！");

return;

)

if(this.classtxt.Text=

(

MessageBox.Show("请输入图书的信息！"，"提示！");

return;

)

if(this,isbntxt.Text二二

(

MessageBox.Show("请输入图书的信息！"，"提示！");

return;

)

if(this,bookcosttxt.Text==

(

MessageBox.Show("请输入图书的信息！"提示！");

return;

)

if(this,bookwritertxt.Text==

(

MessageBox.Show("请输入图书的信息！"，"提示！〃)；

return;

)

if(this,bookpubtxt.Text="")

(

MessageBox.Show("请输入图书的信息！"，"提示！")；

return;

)

if(this.numtxt.Text==

(

MessageBox.Show(〃请输入图书的信息！〃，〃提示！〃)；

return;

}

if(this,notetxt.Text二二”〃)

(

MessageBox.Show("请输入图书的信息！"，"提示！");

return;

)

//stringpat3=[\u4e00-\u9fa5]+$”;〃全为汉字

//stringpat4=@”([\u4e00-\u9fa5]+![A-Za-z]+)$”;〃汉字或字母

//stringpat5=[\u4e00-\u9fa5]{2,4}$”;〃两到四位汉字

stringpatl=广(\d[T*){9}[\dxX]$”;〃图书的ISBN号格式X-XXXX-XXXX-X或

X-XXX-XXXXX-X(X为数字，以图书实际ISBN号为准)

stringpat2=[0-9]*$”;〃正整数

stringpat3=(0[1-9][0-9]*)(.[0-9]{2})?$〃;〃双精度浮点数

boolml=Program,match(this,isbntxt.Text,patl);

boolm2=Progrcun.match(this,numtxt.Text,pat2);

boolm3=Progrctin.match(this,bookcosttxt.Text,pat3);

if(!ml)

(

MessageBox.Show("图书的ISBN号格式为X-XXXX-XXXX-X或X-XXX-XXXXX-X(X为数字，以

图书实际ISBN号为准)!〃，〃提示！〃)；

this,isbntxt.Text=

return;

)

if(!m2)

(

MessageBox.Show(〃图书购买数量应为大于0的整数！〃，〃提示！〃)；

this,numtxt.Text=

return;

)

if(!m3)

MessagcBox.Show("图书价格应为XX.XX元！“，〃提示！“)；

this,bookcosttxt.Text=

return;

)

intnum;

num=Convert.Tolnt32(this,numtxt.Text);

for(inti=1,k=Convert.Tolnt32(this,booknotxt.Text);i<=num;i++,k++)

(

stringsql;

sql="insertinto

tbbook(bno,bname,belass,bisbn,bcost,adder,adddate,bauthor,bpub,bstate,bnote)/z

+“values。"+k.ToString()+"+this,booknametxt.Text+"+

this,classtxt.Text+"+this,isbntxt,Text+"+this,bookcosttxt.Text+"+

LoginForm,uname+"+DateTime.Now.ToString()+"+this,bookwritertxt.Text+

this,bookpubtxt.Text+'在库'，'"+this,notetxt.Text+

DataTabledt=DBHelp.ExeOleCommand(sql);

)

MessageBox.Show("注册成功！"，"恭喜！”)；

this.Hide();

)

privatevoidrebtn_Click(objectsender,EventArgse)

(

this,isbntxt.Clear0;

Clears();

}

privatevoidClears()

{

this,booknametxt.Clear0;

//this,isbntxt.Clear();

this,bookcosttxt.ClearO;

this,bookwritertxt.ClearO；

this.bookpubtxt.Clear();

this.notetxt.Clear();

this,numtxt.Clear();

)

privatevoidNewBook_Load(objectsender,EventArgse)

/*

stringsql;

sql="selectbnofromtbbookorderbybnoasc”;

DataTabledt=DBHelp.ExeOleCommand(sql);

for(inti=0,k=10000001;i<1;i++,k++)

(

for(intj=0;j<dt.Rows.Count;j++)

(

if(dt.Rows[j][0].ToString().Trim().Equals(k.ToString()))

k++;

)

this,booknotxt.Items.Add(k.ToString());

)

this,booknotxt.SelectedIndex=0;

this,classtxt.Selectedlndex=0;

*/

stringsql;

sql="selecttop1bnofromtbbookorderbybnodesc”;

DataTabledt=DBHelp.ExeOleCommand(sql);

intk;

for(inti=0;i<1;i++)

(

if(dt.Rows[0][0].ToStringO=

(

k=10000001;

)

else

(

k=Convert.Tolnt32(dt.Rows[0][0].ToStringO);

k++;

)

this,booknotxt.Items.Add(k.ToStringO)；

}

this.booknotxt.Selectedlndex=0;

this,classtxt.Selectedlndex=0;

)

privatevoidfindbtn_Click(objectsender,EventArgse)

if(this,isbntxt.Text==

(

MessageBox.Show("请输入图书的ISBN号！"，"提示！");

return;

}

stringsql;

sql=zzselect*fromtbbookwherebisbn='"+this,isbntxt.Text+

OleDbDataReaderdr=DBHelp.OleReader(sql);

dr.Read();

if(dr.HasRows)

(

this,booknametxt.Text=dr[，，bname，，l.ToStringO.TrimO;

this,classtxt.Text=drbelass*].ToStringO.TrimO;

this,bookcosttxt.Text=dr[，，bcost，，l.ToStringO.TrimO;

this,bookwritertxt.Text=drt^bauthor^].ToStringO.TrimO；

this,bookpubtxt.Text=dr["bpub"].ToStringO.Trim();

this,notetxt.Text=drE^bnote*].ToStringO.TrimO；

MessageBox.Show("找到匹配图书信息，自动填充基本信息，请填充余下信息！”，〃提示!

”)；

this,numtxt.Enabled=true;

)

else

(

ClearsO;

MessageBox.Show("未找到匹配图书信息！"，"提示!");

this,booknotxt.Enabled=true;

this,booknametxt.Enabled=true;

this,classtxt.Enabled=true;

this,bookcosttxt.Enabled=true;

this,bookwritertxt.Enabled=true;

this,bookpubtxt.Enabled=true;

this,numtxt.Enabled=true;

this,notetxt.Enabled=true;

}

}

6.图书信息管理

主要代码：

publicpartialclassBookManage:Form

(

publicBookManage()

(

InitializeComponent();

stringbookisbn;

privatevoidBookManage_Load(objectsender,EventArgse)

(

this.checkbox.Selected!ndex=0;

this.classbox.Seiectedlndex=0;

}

privatevoidcheckbtn_Click(objectsender,EventArgse)

{

FillGridO;

)

privatevoidcell_click(objectsender,DataGridViewCe11EventAre)

(

FilllnfoO;

privatevoidnobtnClick(objectsender,EventArgse)

(

this.Close();

}

privatevoidokbtn_Click(objectsender,EventArgse)

(

if(this,nametxt.Text==string.Empty)

(

MessageBox.Show("执行操作前,请先选择图书！"，"提示！");

return;

)

〃修改同ISBN图书信息

stringsql2=string.Empty;

sql2+="updatetb_booksetbisbn='"+this.isbntxt.Text+,bname='"+

this,nametxt.Text+"',bclass=+this,classtxt.Text+"',bcosl="+this,costtxt.Text+

”,bauthor='〃+this,writertxt.Text+,bpub='"+this,pubtxt.Text+,adder='"+

this,addertxt.Text+,bnote='"+this,notetxt.Text+

sql2+="wherebisbn='"+this.bookisbn+

DataTabledt2=DBHelp.ExeO1©Command(sq12);

stringsql5=string.Empty;

sql5+="updatetbborrowsetbname='"+this,nametxt.Text+bisbn='"+

this,isbntxt.Text+〃'”；

sq15+="wherebisbn='"+this,bookisbn+

DataTabledt5=DBHelp.Exe01eCommand(sql5);

MessageBox.Show("该类图书信息修改成功！”,〃提示！“);

this,checktxt.Text=

FillGridO;

FilllnfoO;

}

privatevoidFi1IGrid()

(

if(this,checkbox.Text=string.Empty)

(

MessageBox.Show("请输入你要使用的检索条件！"，"提示！”)；

return;

)

if(this,classbox.Text==string.Empty)

(

MessageBox.Show("请输入你要挖找的图书类型！。"提示！")；

return;

)

stringsql=string.Empty;

sql+="selectbidasID号，bnoas图书编号，bnameas图书名称，bauthoras作者，

bclassas类别，bisbnasISBN号，bcostas价格，bpubas出版社，adderas记录员，adddateas入

库日期，bnoleas内容简介，bslateas状态fromtb_book";

if(this,checktxt.Text!="〃)

(

stringc=this,checkbox.Selectedlndex.ToStringO;

switch(c)

{

case"0〃:〃图书名称

if(this,checktxt.Text!=string.Empty)

(

sql+="wherebnamelike+this,checktxt.Text+

)

break;

case〃1〃:〃图书编号

if(this,checktxt.Text!=string.Empty)

{

sql+="wherebnolike'+this,checktxt.Text+"%";

)

break;

case”2〃:〃作者

if(this.checktxt.Text!=string.Empty)

{

sql+="wherebauthorlike+this,checktxt.Text+税”；

)

break;

case"3":〃isbn号

if(this.checktxt.Text!=string.Empty)

(

sql+="wherebisbnlike'+this,checktxt.Text+"%’";

)

break;

case"4”:〃出版社

if(this.checktxt.Text!=string.Empty)

sql+="wherebpublike+this,checktxt.Text

)

break;

default:

break;

)

if(this,classbox.Selectedlndex.ToStringO!=〃0〃)

(

sql十="andbelass='"+this.classbox.Text+

)

)

else

(

if(this,classbox.Selectedlndex.ToStringO!="0")

{

sql十="wherebelass='"+this,classbox.Text+

)

}

sql+="orderbybnoasc”;

DataTabledt=DBHelp.ExeOleCommand(sql);

this.dataGridViewl.DataSource=dt;

}

privatevoidFillinfo()

(

this.Iabel3.Text=this.dataGridViewl[1,

this.dataGridViewl.CurrentCel1.RowIndex].Value.ToStringO.Trim();

this,isbntxt.Text=this.dataGridViewl[5,

this.dataGridViewl.CurrentCel1.Rowindex].Value.ToStringO.TrimO;

this,nametxt.Text=thi