用java做的一个图书管理系统的源代码

1/53用java做的一个图书管理系统的源代码importjava.sql.*;importjava.util.*;publicclassT{publicstaticvoidmain(String[]args)throwsException{Connectionconn=null;Statementstmt=null;ResultSetrs=null;while(true){Scannerscanner=newScanner(System.in);System.out.println(请输入用户名：);Stringusername2=scanner.next();System.out.println(请输入密码：);Stringpassword2=scanner.next();if(!(username2.equals()||password2.equals())){try{Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);conn=DriverManager.getConnection(jdbc:odbc:book,,);Stringsql=select*from='+username2+';stmt=conn.createStatement();rs=stmt.executeQuery(sql);2/53if(rs.next()){if(rs.getString(password).equals(password2)){System.out.println(*********欢迎来山东科技大学图书馆管理系统********);while(true){System.out.println(1.图书信息);System.out.println(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){case1:System.out.println(图书信息:);System.out.println(1.查询图书信息:);System.out.println(2.插入图书信息:);System.out.println(3.删除图书信息:);System.out.println(4.修改图书信息:);inta1=scanner.nextInt();switch(a1){3/53case1:System.out.println(欢迎进入图书信息查询系统:);System.out.println(1.无条件查询图书信息:);System.out.println(2.条件查询图书信息:);intd=scanner.nextInt();switch(d){case1:intllll=0;//intmm=0;while(llll!=1){System.out.println(1.无条件查询图书信息:);StringSql0=SELECT*FROMsystembook;rs=stmt.executeQuery(Sql0);while(rs.next()){StringbookID=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);}4/53System.out.println(是否继续插入？yes/nono返回主菜单);Stringk=scanner.next();if(k.startsWith(yes)){System.out.println();};if(k.startsWith(no))='+A+';{llll=1;System.out.println();};}break;//break;case2:System.out.println(2.条件查询图书信息:);System.out.println(1.单条件查询图书信息:);System.out.println(2.模糊条件查询图书信息:);System.out.println(3.多表连接查询图书信息:);System.out.println(4.嵌套查询图书信息:);System.out.println(5.谓词演算查询);intc12=scanner.nextInt();5/53switch(c12){case1:System.out.println(1.单条件查询:);System.out.println(1.按图书名编码号查询图书信息:);intddd=0;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);System.out.println(a2+,+b2+,+c2+,+d2+,+e2);x++;}if(x==0){System.out.println(查无此书,请重新输入);回主菜单);6/53LIKE'+E+%';}else{System.out.println(是否继续按姓名查询？yes/nono返Stringk=scanner.next();if(k.startsWith(yes)){System.out.println();};if(k.startsWith(no)){ddd=1;System.out.println();};};}break;case2:System.out.println(2.模糊查询图书信息:);intdc=0;while(dc!=1){System.out.println(请用户输入图书名字中的模糊关键字);StringE=scanner.next();7/53Stringsq123=SELECT*FROMsystembookWHEREbookNamers=stmt.executeQuery(sq123);intz=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(查无此书,请重新输入);}else{System.out.println(是否继续输入图书名字中的模糊关键字？yes/nono返回主菜单);Stringk=scanner.next();if(k.startsWith(yes)){System.out.println();8/53};if(k.startsWith(no)){dc=1;System.out.println();//break;};}}break;case3:System.out.println(3.多表连接查询查询图书信息:);intdq=0;while(dq!=1){System.out.println(查询逾期罚款或是赔偿表中的读者的相关信息);System.out.println(请输入逾期罚款或是赔偿的读者编码号);StringF=scanner.next();Stringsq1234=SELECT*FROMfine,borrowbook,systemreaderWHEREfine.bookID=borrowbook.bookIDANDborrowbook.reaID=systemreader.reaIDANDfine.bookID='+F+';rs=stmt.executeQuery(sq1234);intn=0;9/53while(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(查无此人,请重新输入);}else{System.out.println(是否继续输入图书名字中的模糊关键字？yes/nono返回主菜单);Stringk=scanner.next();if(k.startsWith(yes)){System.out.println();};if(k.startsWith(no))10/53{ddd=1;System.out.println();};}}break;case4:System.out.println(4.嵌套查询图书信息:);intdq1=0;while(dq1!=1){System.out.println(查询某读者所在年级女读者的相关信息);System.out.println(请输入某读者的读者编号);StringG=scanner.next();Stringsq12345=SELECT*FROMsystemreaderWHEREreaGrade=(SELECTreaGradeFROMsystemreaderWHEREreaID='+G+')ANDreasex='女';rs=stmt.executeQuery(sq12345);intm=0;while(rs.next())返回主菜单);{Stringa2=rs.getString(1);Stringb2=rs.getString(2);11/53Stringc2=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(查无此书,请重新输入);}else{System.out.println(是否继续输入读者编号？yes/nonoStringk=scanner.next();if(k.startsWith(yes)){System.out.println();};if(k.startsWith(no)){d=1;System.out.println();};}12/53}break;case5:System.out.println(5.谓词演算查询：);intdq1123=0;while(dq1123!=1){System.out.println(查询借阅了某本书的读者的相关信息);System.out.println(请