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