用java做的一個圖書管理系統(tǒng)的源代碼

1、用java做的一個圖書管理系統(tǒng)的源代碼importjava.sql.*;importjava.util.*;publicclassTpublicstaticvoidmain(Stringargs)throwsExceptionConnectionconn=null;Statementstmt=null;ResultSetrs=null;while(true)Scannerscanner=newScanner(System.in);System.out.println("請輸入用戶名：");Stringusername2=scanner.next();System.out.p

2、rintln("請輸入密碼：");Stringpassword2=scanner.next();if(!(username2.equals("")|password2.equals("")tryClass.forName("sun.jdbc.odbc.JdbcOdbcDriver");conn=DriverManager.getConnection("jdbc:odbc:book","","");Stringsql="select*fromwww

3、hereusername='"+username2+"'"stmt=conn.createStatement();rs=stmt.executeQuery(sql);48 / 53if（rs.next（）if（rs.getString（"password"）.equals（password2）System.out.println（"*歡迎來山東科技大學圖書館管理系統(tǒng)*"）;while（true）System.out.println（"1.圖書信息"）;System.out.println（

4、"2.讀者信息"）;System.out.println（"3.管理員信息"）;System.out.println（"4.借閱信息"）;System.out.println（"5.還書信息"）;System.out.println（"6.逾期罰款或損壞賠償信息"）;/System.out.println（"7.退出"）;System.out.println（"請輸入選擇功能的序號:"）;inta=scanner.nextInt（）;switch（a）ca

5、se1:System.out.println（"圖書信息:"）;System.out.println（"1.查詢圖書信息:"）;System.out.println（"2.插入圖書信息:"）;System.out.println（"3.刪除圖書信息:"）;System.out.println（"4.修改圖書信息:"）;inta1=scanner.nextInt（）;switch（a1）case1:System.out.println("歡迎進入圖書信息查詢系統(tǒng):");Syst

6、em.out.println("1.無條件查詢圖書信息:");System.out.println("2.條件查詢圖書信息:");intd=scanner.nextInt();switch(d)case 1:intllll=0;/intmm=0;while(llll!=1)System.out.println("1.無條件查詢圖書信息:");StringSql0="SELECT*FROMsystembook"rs=stmt.executeQuery(Sql0);while(rs.next()StringbookID

7、=rs.getString(1);StringbookNo=rs.getString(2);StringbookName=rs.getString(3);StringbookWriter=rs.getString(4);StringbookPub=rs.getString(5);System.out.println(bookID+","+bookNo+","+bookName+","+bookWriter+","+bookPub););StringSystem.out.println("是否繼續(xù)插入？ye

8、s/nono返回主菜單k=scanner.next();if(k.startsWith("yes")System.out.println();if(k.startsWith("no")='"+A+"'"llll=1;System.out.println();break;/break;case 2:System.out.println("2.條件查詢圖書信息:");System.out.println("1.單條件查詢圖書信息:");System.out.println(

9、"2.模糊條件查詢圖書信息:");System.out.println("3.多表連接查詢圖書信息:");System.out.println("4.嵌套查詢圖書信息:");System.out.println("5.謂詞演算查詢");intc12=scanner.nextInt();switch(c12)case 1:System.out.println("1.單條件查詢:");System.out.println("1.按圖書名編碼號查詢圖書信息:");intddd=0;

10、while(ddd!=1)System.out.println("請輸入圖書編碼號:");StringA=scanner.next();Stringsql1="SELECT*FROMsystembookWHEREbookIDrs=stmt.executeQuery(sql1);intx=0;while(rs.next()Stringa2=rs.getString(1);Stringb2=rs.getString(2);Stringc2=rs.getString(3);Stringd2=rs.getString(4);Stringe2=rs.getString(5)

11、;System.out.println(a2+","+b2+","+c2+","+d2+","+e2);x+;if(x=0)System.out.println("查無此書，請重新輸入")；回主菜單");LIKE'"+E+"%'"elseSystem.out.println("是否繼續(xù)按姓名查詢？yes/nono返Stringk=scanner.next();if(k.startsWith("yes")Syst

12、em.out.println();if(k.startsWith("no")ddd=1;System.out.println();break;case 2:System.out.println("2.模糊查詢圖書信息:");intdc=0;while(dc!=1)System.out.println(”請用戶輸入圖書名字中的模糊關(guān)鍵字");StringE=scanner.next();Stringsq123="SELECT*FROMsystembookWHEREbookNamers=stmt.executeQuery(sq123);i

13、ntz=0;while(rs.next()Stringa2=rs.getString(1);Stringb2=rs.getString(2);Stringc2=rs.getString(3);Stringd2=rs.getString(4);Stringe2=rs.getString(5);System.out.println(a2+","+b2+","+c2+","+d2+","+e2);z+;if(z=0)System.out.println("查無此書，請重新輸入")；elseSystem

14、.out.println("是否繼續(xù)輸入圖書名字中的模糊關(guān)鍵字？yes/nono返回主菜單");Stringk=scanner.next();if(k.startsWith("yes")System.out.println();if(k.startsWith("no")dc=1;System.out.println();/break;break;case 3:System.out.println("3.多表連接查詢查詢圖書信息:");intdq=0;while(dq!=1)System.out.println(&q

15、uot;查詢逾期罰款或是賠償表中的讀者的相關(guān)信息")；System.out.println("請輸入逾期罰款或是賠償?shù)淖x者編碼號");StringF=scanner.next();Stringsq1234="SELECT*FROMfine,borrowbook,systemreaderWHEREfine.bookID=borrowbook.bookIDANDborrowbook.reaID=systemreader.reaIDANDfine.bookID='"+F+"'"rs=stmt.executeQuer

16、y(sq1234);intn=0;while(rs.next()Stringa2=rs.getString(1);Stringb2=rs.getString(2);Stringc2=rs.getString(3);Stringd2=rs.getString(4);Stringe2=rs.getString(5);System.out.println(a2+","+b2+","+c2+","+d2+","+e2);n+;if(n=0)System.out.println("查無此人，請重新輸入")

17、；elseSystem.out.println("是否繼續(xù)輸入圖書名字中的模糊關(guān)鍵字？yes/nono返回主菜單");Stringk=scanner.next();if(k.startsWith("yes")System.out.println();if(k.startsWith("no")ddd=1;System.out.println();break;case 4:System.out.println("4.嵌套查詢圖書信息:");intdq1=0;while(dq1!=1)System.out.println

18、("查詢某讀者所在年級女讀者的相關(guān)信息");System.out.println("請輸入某讀者的讀者編號")；StringG=scanner.next();Stringsq12345="SELECT*FROMsystemreaderWHEREreaGrade=(SELECTreaGradeFROMsystemreaderWHEREreaID='"+G+"')ANDreaseX=""rs=stmt.executeQuery(sq12345);intm=0;while(rs.next()返回

19、主菜單");Stringa2=rs.getString(1);Stringb2=rs.getString(2);Stringc2=rs.getString(3);Stringd2=rs.getString(4);Stringe2=rs.getString(5);System.out.println(a2+","+b2+","+c2+","+d2+","+e2);m+;if(m=0)System.out.println("查無此書，請重新輸入")；elseSystem.out.print

20、ln("是否繼續(xù)輸入讀者編號？yes/nonoStringk=scanner.next();if(k.startsWith("yes")System.out.println();if(k.startsWith("no")d=1;System.out.println();break;case 5:System.out.println("5.謂詞演算查詢：");intdq1123=0;while(dq1123!=1)System.out.println("查詢借閱了某本書的讀者的相關(guān)信息")；System.o

21、ut.println("請輸入該書的名字");StringH=scanner.next();Stringsq123456="SELECT*FROMsystemreaderWHEREreaIDIN(SELECTreaIDFROMborrowbookWHEREbookName='"+H+"')"rs=stmt.executeQuery(sq123456);intl=0;while(rs.next()Stringa2=rs.getString(1);Stringb2=rs.getString(2);Stringc2=rs.g

22、etString(3);Stringd2=rs.getString(4);Stringe2=rs.getString(5);System.out.println(a2+","+b2+","+c2+","+d2+","+e2);l+;if(l=0)System.out.println("查無此人,請重新輸入");elseSystem.out.println("是否繼續(xù)輸入圖書名字？yes/nono返回主菜單");Stringk=scanner.next();if(k.start

23、sWith("yes")System.out.println();if(k.startsWith("no")d=1;System.out.println();break;/c12break;break;/*case1:System.out.println("1.查詢圖書信息:");StringSql="SELECT*FROMsystembook"rs=stmt.executeQuery(Sql);while(rs.next()/Stringstr=scanner.next();StringbookID=rs.get

24、String(1);StringbookNo=rs.getString(2);StringbookName=rs.getString(3);StringbookWriter=rs.getString(4);StringbookPub=rs.getString(5);System.out.println(bookID+","+bookNo+","+bookName+","+bookWriter+","+bookPub);break;*/case 2:intzz=0;while(zz!=1)System.out.pri

25、ntln("2.插入圖書信息:");System.out.println("請按順序插入圖書條碼號，圖書索書號，圖書名字，圖書作者,圖書出版社");Stringstr=scanner.next();Stringsplitst=str.split(",");Stringa11=splitst0;Stringa12=splitst1;Stringa13=splitst2;Stringa14=splitst3;Stringa15=splitst4;StringinsertSql="INSERTsystembook(bookID,b

26、ookNo,bookName,bookWriter,bookPub)VALUES('"+a11+"','"+a12+"','"+a13+"','"+a14+"','"+a15+"')"inti=stmt.executeUpdate(insertSql);/返回記錄影響的條數(shù)if(i!=0)System.out.println("插入成功!");System.out.println(&qu

27、ot;是否繼續(xù)插入？yes/nono返回主菜單");Stringk=scanner.next();if(k.startsWith("yes")System.out.println();if(k.startsWith("no")zz=1;System.out.println();break;case 3:intll=0;/intmm=0;while(ll!=1)INTOSystem.out.println("3.刪除圖書信息：”)；System.out.println("請輸入要刪除的圖書編號:");StringSt

28、r=scanner.next();StringSplitst=Str.split(",");Stringb3=Splitst0;Stringsql1="SELECT*FROMsystembookwherebookID='"+b3+"'"rs=stmt.executeQuery(sql1);intkkk=0;while(rs.next()Stringa22=rs.getString(1);Stringb22=rs.getString(2);Stringc22=rs.getString(3);Stringd22=rs.ge

29、tString(4);Stringe22=rs.getString(5);Stringf22=rs.getString(6);System.out.println(a22+","+b22+","+c22+","+d22+","+e22+","+f22);kkk+;if(kkk=0)System.out.println("沒有這本書，請重新輸入");elseStringdeleSql="DELETEFROMsystembookWHEREbookID='&quo

30、t;+b3+"'"intp=stmt.executeUpdate(deleSql);/返回記錄影響的條數(shù)if(p!=0)System.out.println("刪除成功!");System.out.println("是否繼續(xù)刪除？yes/nono返回主菜單");Stringl=scanner.next();if(l.startsWith("yes")System.out.println();if(l.startsWith("no")ll=1;System.out.println();br

31、eak;case 4:intmm=0;while(mm!=1)System.out.println("4.修改圖書信息:");System.out.println("請輸入修改的圖書ID");StringS=scanner.next();Stringsql1="SELECT*FROMsystembookwherebookID='"+S+"'"rs=stmt.executeQuery(sql1);intlll=0;while(rs.next()Stringa222=rs.getString(1);St

32、ringb222=rs.getString(2);Stringc222=rs.getString(3);Stringd222=rs.getString(4);Stringe222=rs.getString(5);Stringf222=rs.getString(6);System.out.println(a222+","+b222+","+c222+","+d222+","+e222+","+f222);lll+;if(lll=0)System.out.println("沒有這本書，請重

33、新輸入");elseSystem.out.println("要將書名改為");Stringbbb=scanner.next();StringupdateSql1="UPDATEsystembookSETbookName='"+bbb+"'WHEREbookID='"+S+"'"inthh=stmt.executeUpdate(updateSql1);/返回記錄影響的條數(shù)if(hh!=0)System.out.println("修改成功!");System

34、.out.println("是否繼續(xù)修改yes/nono返回主菜單");Stringo=scanner.next();if(o.startsWith("yes")System.out.println();if(o.startsWith("no")mm=1;System.out.println();break;break;/*StringupdateSql="UPDATEsystembookSETbookCopy='"+c1+"'WHEREbookName=數(shù)據(jù)庫管理'"i

35、ntt=stmt.executeUpdate(updateSql);/返回記錄影響的條數(shù)if(t!=0)System.out.println("修改成功!");break;break;*/case2:System.out.println("讀者信息:");System.out.println("1.查詢讀者信息:");System.out.println("2.插入讀者信息:");System.out.println("3.刪除讀者信息:");System.out.println("4

36、.修改讀者信息:");intb1=scanner.nextInt();switch(b1)case 1:System.out.println("1.查詢讀者信息:");Stringssql="SELECT*FROMsystemreader"rs=stmt.executeQuery(ssql);while(rs.next()/Stringstr=scanner.next();StringreaID=rs.getString(1);StringreaName=rs.getString(2);StringreaLBID=rs.getString(3)

37、;StringreaNo=rs.getString(4);StringreaSex=rs.getString(5);StringreaType=rs.getString(6);StringreaDep=rs.getString(7);StringreaGrade=rs.getString(8);StringreaPre=rs.getString(9);StringreaDate=rs.getString(10);System.out.println(reaID+","+reaName+","+reaNo+","+reaSex+&quo

38、t;,"+reaLBID+","+reaType+","+reaDep+","+reaGrade+","+reaPre+","+reaDate);break;case 2:intzz=0;while(zz!=1)System.out.println("2.插入讀者信息:");System.out.println("請按順序插入借書卡證號讀者名字讀者學號讀者性別讀者LBID讀者類型讀者學院讀者年級讀者專業(yè)辦證日期")；Stringstr=scann

39、er.next();Stringsplitst=str.split(",");Stringb11=splitst0;Stringb12=splitst1;Stringb13=splitst2;Stringb14=splitst3;Stringb15=splitst4;Stringb16=splitst5;Stringb17=splitst6;Stringb18=splitst7;Stringb19=splitst8;Stringb20=splitst9;StringinsertSql="INSERTINTOsystemreader(reaID,reaName,re

40、aNo,reaSex,reaLBID,reaType,reaDep,reaGrade,reaPre,reaDate)VALUES('"+b11+"','"+b12+"','"+b13+"','"+b14+"','"+b15+"','"+b16+"','"+b17+"','"+b18+"','"

41、+b19+"','"+b20+"')"intn=stmt.executeUpdate(insertSql);/返回記錄影響的條數(shù)if(n!=0)System.out.println("插入成功!");System.out.println("是否繼續(xù)插入？yes/nono返回主菜單");Stringk=scanner.next();if(k.startsWith("yes")System.out.println();if(k.startsWith("no"

42、;)zz=1;System.out.println();break;case 3:intll=0;while(ll!=1)System.out.println("3.刪除讀者信息:");System.out.println("請輸入要刪除的讀者證號:");StringStr=scanner.next();StringSplitst=Str.split(",");Stringr=Splitst0;Stringsql1="SELECT*FROMsystemreaderwherereaID='"+r+"

43、'"rs=stmt.executeQuery(sql1);intkkk=0;while(rs.next()Stringa22=rs.getString(1);Stringb22=rs.getString(2);Stringc22=rs.getString(3);Stringd22=rs.getString(4);Stringe22=rs.getString(5);Stringf22=rs.getString(6);Stringg22=rs.getString(7);Stringh22=rs.getString(8);Stringi22=rs.getString(9);Syst

44、em.out.println(a22+","+b22+","+c22+","+d22+","+e22+","+f22+","+g22+","+h22+","+i22);kkk+;if(kkk=0)System.out.println("沒有這個讀者，請重新輸入");else/System.out.println("您是否真的要刪除?yes/no");/Stringk=scanner.next();

45、/if(k.startsWith("y")StringdeleSql="DELETEFROMsystemreaderWHEREreaID='"+r+"'"intp=stmt.executeUpdate(deleSql);/返回記錄影響的條數(shù)if(p!=0)System.out.println("刪除成功!");System.out.println("是否繼續(xù)刪除？yes/nono返回主菜單");Stringl=scanner.next();if(l.startsWith(&quo

46、t;yes")System.out.println();if(l.startsWith("no")ll=1;System.out.println();reaID='"+r+"'"/*StringdeleSql="DELETEFROMsystemreaderWHEREintm=stmt.executeUpdate(deleSql);/返回記錄影響的條數(shù)if(m!=0)System.out.println("刪除成功!");*/break;case 4:intmm=0;while(mm!=1)

47、System.out.println("4.修改讀者信息:");System.out.println("請輸入修改以后的讀者的ID");StringS=scanner.next();/StringSsplitst=S.split(",");/Stringtt=Ssplitst0;Stringsql1="SELECT*FROMsystemreaderwherereaID='"+S+"'"rs=stmt.executeQuery(sql1);intlll=0;while(rs.nex

48、t()Stringa222=rs.getString(1);Stringb222=rs.getString(2);Stringc222=rs.getString(3);Stringd222=rs.getString(4);Stringe222=rs.getString(5);Stringf222=rs.getString(6);Stringg222=rs.getString(7);Stringh222=rs.getString(8);Stringi222=rs.getString(9);Stringj222=rs.getString(10);System.out.println(a222+&q

49、uot;,"+b222+","+c222+","+d222+","+e222+","+f222+","+g222+","+h222+","+i222+","+j222);lll+;if(lll=0)System.out.println("沒有這個人，請重新輸入");elseSystem.out.println("要將名字改為");Stringbb=scanner.next();Strin

50、gupdateSql="UPDATEsystemreaderSETreaName='"+bb+"'WHEREreaID='"+S+"'"inthh=stmt.executeUpdate(updateSql);/返回記錄影響的條數(shù)if(hh!=0)System.out.println("修改成功!");System.out.println("是否繼續(xù)修改yes/nono返回主菜單");Stringo=scanner.next();if(o.startsWith(&q

51、uot;yes")System.out.println();if(o.startsWith("no")mm=1;System.out.println();break;/*StringupdateSql="UPDATEsystemreaderSETreaSex='"+tt+"'WHEREreaID='20030101'"intl=stmt.executeUpdate(updateSql);/返回記錄影響的條數(shù)if(l!=0)System.out.println("修改成功!"

52、);break;*/break;case 3:System.out.println("管理員信息:");System.out.println("1.查詢管理員信息:");System.out.println("2.插入管理員信息:");System.out.println("3.刪除管理員信息:");System.out.println("4.修改管理員信息:");System.out.println("5.返回上一級");intc11=scanner.nextInt();s

53、witch(c11)case 1:System.out.println("1.查詢管理員信息:");StringSsql="SELECT*FROMmanager"rs=stmt.executeQuery(Ssql);while(rs.next()/Stringstr=scanner.next();StringmID=rs.getString(1);StringmName=rs.getString(2);StringmSex=rs.getString(3);System.out.println(mID+","+mName+",

54、"+mSex);break;case 2:intzz=0;while(zz!=1)System.out.println("2.插入管理員信息:");System.out.println("請按順序插入管理員的編號，管理員的姓名，管理員的性別,所管書庫，電話，地址");Stringstr=scanner.next();Stringsplitst=str.split(",");Stringa11=splitst0;Stringa12=splitst1;Stringa13=splitst2;Stringa14=splitst3;S

55、tringa15=splitst4;Stringa16=splitst5;StringinsertSql="INSERTmanager(mID,mName,mSex,mAuth,mTeleph,mAddre)VALUES('"+a11+"','"+a12+"','"+a13+"','"+a14+"','"+a15+"','"+a16+"')"inti=stmt.

56、executeUpdate(insertSql);/返回記錄影響的條數(shù)if(i!=0)System.out.println("插入成功!");System.out.println("是否繼續(xù)插入？yes/nono返回主菜單");Stringk=scanner.next();if(k.startsWith("yes")System.out.println();if(k.startsWith("no")zz=1;System.out.println();break;case3:INTOintll=0;while(ll!

57、=1)System.out.println("3.刪除管理員信息:");System.out.println("請輸入要刪除的管理員編號:");StringStr=scanner.next();StringSplitst=Str.split(",");Stringb3=Splitst0;Stringsql1="SELECT*FROMmanagerwheremID='"+b3+"'"rs=stmt.executeQuery(sql1);intkkk=0;while(rs.next(

58、)Stringa22=rs.getString(1);Stringb22=rs.getString(2);Stringc22=rs.getString(3);Stringd22=rs.getString(4);Stringe22=rs.getString(5);Stringf22=rs.getString(6);System.out.println(a22+","+b22+","+c22+","+d22+","+e22+","+f22);kkk+;if(kkk=0)System.out.prin

59、tln("沒有這個管理員，請重新輸入");else/System.out.println("您是否真的要刪除?yes/no");/Stringk=scanner.next();/if(k.startsWith("y")StringdeleSql="DELETEFROMmanagerWHEREmID='"+b3+"'"intp=stmt.executeUpdate(deleSql);/返回記錄影響的條數(shù)if(p!=0)System.out.println("刪除成功!&q

60、uot;);System.out.println("是否繼續(xù)刪除？yes/nono返回主菜單");Stringl=scanner.next();if(l.startsWith("yes")System.out.println();if(l.startsWith("no")ll=1;System.out.println();/*StringdeleSql="DELETEmIDFROMmanagerWHEREmID='"+b3+"'"intk=stmt.executeUpdate(d

61、eleSql);/返回記錄影響的條數(shù)if(k!=0)System.out.println("刪除成功!");*/break;case4:intmm=0;while(mm!=1)System.out.println("4.修改管理員信息:");System.out.println("請輸入要修改的管理員編號：")；StringS=scanner.next();StringSsplitst=S.split(",");Stringc1=Ssplitst0;Stringsql1="SELECT*FROMmanag

62、erwheremID='"+S+"'"rs=stmt.executeQuery(sql1);intlll=0;while(rs.next()Stringa222=rs.getString(1);Stringb222=rs.getString(2);Stringc222=rs.getString(3);Stringd222=rs.getString(4);Stringe222=rs.getString(5);Stringf222=rs.getString(6);System.out.println(a222+","+b222+&q

63、uot;,"+c222+","+d222+","+e222+","+f222);lll+;if(lll=0)mID='"+S+""，;System.out.println("沒有這個管理員，請重新輸入");else/System.out.println("要修改的信息");/Stringaa=scanner.next();System.out.println("要將它改為");Stringbb=scanner.next();St

64、ringupdateSql="UPDATEmanagerSETmName='"+bb+"'WHEREinthh=stmt.executeUpdate(updateSql);/返回記錄影響的條數(shù)if(hh!=0)System.out.println("修改成功!");System.out.println("是否繼續(xù)修改yes/nono返回主菜單");Stringo=scanner.next();if(o.startsWith("yes")System.out.println();if(o.s

65、tartsWith("no")mm=1;System.out.println();break;break;/*StringupdateSql="UPDATEmanagerSETmSex='"+c1+"'WHEREmID=1"intt=stmt.executeUpdate(updateSql);/返回記錄影響的條數(shù)if(t!=0)System.out.println("修改成功!");break;*/case 4:System.out.println("圖書借閱信息:");System.out.println("1.查詢圖書借閱信息信息:");System.out.println("2.插入圖書借閱信息:");System.out.println("3.刪除圖書借閱信息:");System.out.println(&qu