用java做的一个图书管理系统的源代码(共42页).docx
精选优质文档-倾情为你奉上用java做的一个图书管理系统的源代码import java.sql.*;import java.util.*;public class Tpublic static void main(String args) throws ExceptionConnection conn=null;Statement stmt=null;ResultSet rs=null;while(true)Scanner scanner=new Scanner(System.in);System.out.println("请输入用户名：");String username2=scanner.next();System.out.println("请输入密码：");String password2=scanner.next();if(!(username2.equals("")|password2.equals("")tryClass.forName("sun.jdbc.odbc.JdbcOdbcDriver");conn=DriverManager.getConnection("jdbc:odbc:book","","");String sql="select * from ww where username='"+username2+"'"stmt=conn.createStatement();rs=stmt.executeQuery(sql);if(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("请输入选择功能的序号:");int a=scanner.nextInt();switch(a)case 1:System.out.println("图书信息:");System.out.println("1.查询图书信息:");System.out.println("2.插入图书信息:");System.out.println("3.删除图书信息:");System.out.println("4.修改图书信息:");int a1=scanner.nextInt();switch(a1)case 1:System.out.println("欢迎进入图书信息查询系统:");System.out.println("1.无条件查询图书信息:");System.out.println("2.条件查询图书信息:");int d=scanner.nextInt();switch(d)case 1:int llll=0;/int mm=0;while(llll!=1)System.out.println("1.无条件查询图书信息:");String Sql0 = "SELECT * FROM systembook "rs= stmt.executeQuery(Sql0);while(rs.next()StringbookID =rs.getString(1);StringbookNo =rs.getString(2);String bookName =rs.getString(3);String bookWriter =rs.getString(4);String bookPub =rs.getString(5);System.out.println(bookID+","+bookNo+","+bookName+","+bookWriter+","+bookPub);System.out.println("是否继续插入？yes/no no返回主菜单");String 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("2.模糊条件查询图书信息:");System.out.println("3.多表连接查询图书信息:");System.out.println("4.嵌套查询图书信息:");System.out.println("5.谓词演算查询");int c12=scanner.nextInt();switch(c12)case 1:System.out.println("1.单条件查询:");System.out.println("1.按图书名编码号查询图书信息:");int ddd=0;while(ddd!=1)System.out.println("请输入图书编码号:");String A=scanner.next();Stringsql1="SELECT*FROMsystembookWHEREbookIDrs= stmt.executeQuery(sql1);int x=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("查无此书,请重新输入");回主菜单");LIKE'"+E+"%'"elseSystem.out.println("是否继续按姓名查询？yes/nono返String k=scanner.next();if(k.startsWith("yes")System.out.println();if(k.startsWith("no")ddd=1;System.out.println();break;case 2:System.out.println("2.模糊查询图书信息:");int dc=0;while(dc!=1)System.out.println("请用户输入图书名字中的模糊关键字");String E=scanner.next();String sq123= "SELECT * FROM systembook WHERE bookNamers= stmt.executeQuery(sq123);int z=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.out.println("是否继续输入图书名字中的模糊关键字？yes/no no返回主菜单");String k=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.多表连接查询查询图书信息:");int dq=0;while(dq!=1)System.out.println("查询逾期罚款或是赔偿表中的读者的相关信息");System.out.println("请输入逾期罚款或是赔偿的读者编码号");String F=scanner.next();String sq1234= "SELECT * FROM fine,borrowbook,systemreaderWHEREfine.bookID=borrowbook.bookIDANDborrowbook.reaID=systemreader.reaIDANDfine.bookID='"+F+"' "rs= stmt.executeQuery(sq1234);int n=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("查无此人,请重新输入");elseSystem.out.println("是否继续输入图书名字中的模糊关键字？yes/no no返回主菜单");String k=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.嵌套查询图书信息:");int dq1=0;while(dq1!=1)System.out.println("查询某读者所在年级女读者的相关信息");System.out.println("请输入某读者的读者编号");String G=scanner.next();Stringsq12345="SELECT*FROMsystemreaderWHEREreaGrade=(SELECT reaGrade FROM systemreader WHERE reaID='"+G+"') AND reasex='女'"rs= stmt.executeQuery(sq12345);int m=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);m+;if(m=0)System.out.println("查无此书,请重新输入");elseSystem.out.println("是否继续输入读者编号？yes/nonoString k=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.谓词演算查询：");int dq1123=0;while(dq1123!=1)System.out.println("查询借阅了某本书的读者的相关信息");System.out.println("请输入该书的名字");String H=scanner.next();Stringsq="SELECT*FROMsystemreaderWHEREreaID IN (SELECT reaID FROM borrowbook WHERE bookName='"+H+"')"rs= stmt.executeQuery(sq);int l=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);l+;if(l=0)System.out.println("查无此人,请重新输入");elseSystem.out.println("是否继续输入图书名字？yes/no no返回主菜单");String k=scanner.next();if(k.startsWith("yes")System.out.println();if(k.startsWith("no")d=1;System.out.println();break;/c12break;break;/*case 1:System.out.println("1.查询图书信息:");String Sql = "SELECT * FROM systembook"rs= stmt.executeQuery(Sql);while(rs.next()/String str =scanner.next();StringbookID =rs.getString(1);StringbookNo =rs.getString(2);String bookName =rs.getString(3);String bookWriter =rs.getString(4);String bookPub =rs.getString(5);System.out.println(bookID+","+bookNo+","+bookName+","+bookWriter+","+bookPub);break;*/case 2:int zz=0;while(zz!=1)System.out.println("2.插入图书信息:");System.out.println("请按顺序插入图书条码号,图书索书号,图书名字,图书作者,图书出版社");String str=scanner.next();String splitst=str.split(",");String a11=splitst0;String a12=splitst1;String a13=splitst2;String a14=splitst3;String a15=splitst4;StringinsertSql="INSERTsystembook(bookID,bookNo,bookName,bookWriter,bookPub)VALUES('"+a11+"','"+a12+"','"+a13+"','"+a14+"','"+a15+"')"int i=stmt.executeUpdate(insertSql); /返回记录影响的条数if(i!=0)System.out.println("插入成功!");System.out.println("是否继续插入？yes/no no返回主菜单");String k=scanner.next();if(k.startsWith("yes")System.out.println();if(k.startsWith("no")zz=1;System.out.println();break;case 3:int ll=0;/int mm=0;while(ll!=1)INTOSystem.out.println("3.删除图书信息:");System.out.println("请输入要删除的图书编号:");String Str=scanner.next();String Splitst=Str.split(",");String b3=Splitst0;String sql1="SELECT * FROM systembook where bookID='"+b3+"'"rs= stmt.executeQuery(sql1);int kkk=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);System.out.println(a22+","+b22+" ,"+c22+","+d22+","+e22+","+f22);kkk+;if(kkk=0)System.out.println("没有这本书，请重新输入");elseStringdeleSql="DELETEFROMsystembookWHEREbookID='"+b3+"'"int p=stmt.executeUpdate(deleSql); /返回记录影响的条数if(p!=0)System.out.println("删除成功!");System.out.println("是否继续删除？yes/no no返回主菜单");String l=scanner.next();if(l.startsWith("yes")System.out.println();if(l.startsWith("no")ll=1;System.out.println();break;case 4:int mm=0;while(mm!=1)System.out.println("4.修改图书信息:");System.out.println("请输入修改的图书ID");String S=scanner.next();String sql1="SELECT * FROM systembook where bookID='"+S+"'"rs= stmt.executeQuery(sql1);int lll=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+" ,"+c222+","+d222+","+e222+","+f222);lll+;if(lll=0)System.out.println("没有这本书，请重新输入");elseSystem.out.println("要将书名改为");String bbb=scanner.next();String updateSql1="UPDATE systembookSET bookName='"+bbb+"'WHERE bookID='"+S+"'"int hh=stmt.executeUpdate(updateSql1); /返回记录影响的条数if(hh!=0)System.out.println("修改成功!");System.out.println("是否继续修改yes/no no返回主菜单");String o=scanner.next();if(o.startsWith("yes")System.out.println();if(o.startsWith("no")mm=1;System.out.println();break;break;/*StringupdateSql="UPDATEsystembookSETbookCopy='"+c1+"'WHERE bookName='数据库管理'"int t=stmt.executeUpdate(updateSql); /返回记录影响的条数if(t!=0)System.out.println("修改成功!");break;break;*/case 2:System.out.println("读者信息:");System.out.println("1.查询读者信息:");System.out.println("2.插入读者信息:");System.out.println("3.删除读者信息:");System.out.println("4.修改读者信息:");int b1=scanner.nextInt();switch(b1)case 1:System.out.println("1.查询读者信息:");String ssql = "SELECT * FROM systemreader "rs= stmt.executeQuery(ssql);while(rs.next()/ String str =scanner.next();StringreaID=rs.getString(1);StringreaName =rs.getString(2);StringreaLBID =rs.getString(3);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+","+reaLBID+","+reaType+","+reaDep+","+reaGrade+","+reaPre+","+reaDate);break;case 2:int zz=0;while(zz!=1)System.out.println("2.插入读者信息:");System.out.println("请按顺序插入借书卡证号读者名字读者学号读者性别读者LBID读者类型读者学院读者年级读者专业办证日期");String str=scanner.next();String splitst=str.split(",");String b11=splitst0;String b12=splitst1;String b13=splitst2;String b14=splitst3;String b15=splitst4;String b16=splitst5;String b17=splitst6;String b18=splitst7;String b19=splitst8;String b20=splitst9;StringinsertSql="INSERTINTOsystemreader(reaID,reaName,reaNo,reaSex,reaLBID,reaType,reaDep,reaGrade,reaPre,reaDate)VALUES('"+b11+"','"+b12+"','"+b13+"','"+b14+"','"+b15+"','"+b16+"','"+b17+"','"+b18+"','"+b19+"','"+b20+"')"int n=stmt.executeUpdate(insertSql); /返回记录影响的条数if(n!=0)System.out.println("插入成功!");System.out.println("是否继续插入？yes/no no返回主菜单");String k=scanner.next();if(k.startsWith("yes")System.out.println();if(k.startsWith("no")zz=1;System.out.println();break;case 3:int ll=0;while(ll!=1)System.out.println("3.删除读者信息:");System.out.println("请输入要删除的读者证号:");String Str=scanner.next();String Splitst=Str.split(",");String r=Splitst0;String sql1="SELECT * FROM systemreader where reaID='"+r+"'"rs= stmt.executeQuery(sql1);int kkk=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);System.out.println(a22+","+b22+" ,"+c22+","+d22+","+e22+","+f22+","+g22+","+h22+","+i22);kkk+;if(kkk=0)System.out.println("没有这个读者，请重新输入");else/System.out.println("您是否真的要删除? yes/no");/String k=scanner.next();/if(k.startsWith("y")StringdeleSql="DELETEFROMsystemreaderWHEREreaID='"+r+"'"int p=stmt.executeUpdate(deleSql); /返回记录影响的条数if(p!=0)System.out.println("删除成功!");System.out.println("是否继续删除？yes/no no返回主菜单");String l=scanner.next();if(l.startsWith("yes")System.out.println();if(l.startsWith("no")ll=1;System.out.println();reaID='"+r+"'"/*StringdeleSql="DELETEFROMsystemreaderWHEREint m=stmt.executeUpdate(deleSql); /返回记录影响的条数if(m!=0)System.out.println("删除成功!");*/break;case 4:int mm=0;while(mm!=1)System.out.println("4.修改读者信息:");System.out.println("请输入修改以后的读者的ID ");String S=scanner.next();/ String Ssplitst=S.split(",");/String tt=Ssplitst0;String sql1="SELECT * FROM systemreader where reaID='"+S+"'"rs= stmt.executeQuery(sql1);int lll=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);Stringg222 =rs.getString(7);Stringh222 =rs.getString(8);Stringi222 =rs.getString(9);Stringj222 =rs.getString(10);System.out.println(a222+","+b222+","+c222+","+d222+","+e222+","+f222+","+g222+","+h222+","+i222+","+j222);lll+;if(lll=0)System.out.println("没有这个人，请重新输入");elseSystem.out.println("要将名字改为");String bb=scanner.next();StringupdateSql="UPDATEsystemreaderSETreaName='"+bb+"'WHERE reaID='"+S+"'"int hh=stmt.executeUpdate(updateSql); /返回记录影响的条数if(hh!=0)System.out.println("修改成功!");System.out.println("是否继续修改yes/no no返回主菜单");String o=scanner.next();if(o.startsWith("yes")System.out.println();if(o.startsWith("no")mm=1;System.out.println();break;/*StringupdateSql="UPDATEsystemreaderSETreaSex='"+tt+"'WHEREreaID=''"int l=stmt.executeUpdate(updateSql); /返回记录影响的条数if(l!=0)System.out.println("修改成功!");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.返回上一级");int c11=scanner.nextInt();switch(c11)case 1:System.out.println("1.查询管理员信息:");String Ssql = "SELECT * FROM manager "rs= stmt.executeQuery(Ssql);while(rs.next()/ String str =scanner.next();String mID =rs.getString(1);String mName=rs.getString(2);String mSex =rs.getString(3);System.out.println(mID+","+mName+","+mSex);break;case 2:int zz=0;while(zz!=1)System.out.printl
