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

1、用java做的一个图书管理系统的源代码import java.sql.*;import java.util.*;public class T public static void main(String args) throws Exception Connection conn=null; Statement stmt=null; ResultSet rs=null; while(true) Scanner scanner=new Scanner(System.in); System.out.println("请输入用户名："); String username2=sca

2、nner.next(); System.out.println("请输入密码："); String password2=scanner.next(); if(!(username2.equals("")|password2.equals("") try Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); conn=DriverManager.getConnection("jdbc:odbc:book","","")

3、; 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(&

4、quot; 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(&

5、quot; 请输入选择功能的序号 :"); 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 a

6、1=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. 无条件查

7、询图书信息: "); String Sql0 = "SELECT * FROM systembook " rs= stmt.executeQuery(Sql0); while(rs.next() String bookID =rs.getString(1); String bookNo =rs.getString(2); String bookName =rs.getString(3); String bookWriter =rs.getString(4); String bookPub =rs.getString(5); System.out.println(b

8、ookID+","+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") llll=1; System.out.println(); ;

9、 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. 谓词

10、演算查询 "); 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(); String sql1= "SELECT * FROM systembook WHERE

11、bookID ='"+A+"' " rs= stmt.executeQuery(sql1); int x=0; while(rs.next() String a2 =rs.getString(1); String b2 =rs.getString(2); String c2 =rs.getString(3); String d2 =rs.getString(4); String e2 =rs.getString(5); System.out.println(a2+","+b2+" ,"+c2+",&

12、quot;+d2+","+e2); x+; if(x=0) System.out.println("查无此书,请重新输入"); else System.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;

13、 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 bookName LIKE'"+E+"%'" rs= stmt.executeQuery(sq123); int z=0; while(rs.n

14、ext() String a2 =rs.getString(1); String b2 =rs.getString(2); String c2 =rs.getString(3); String d2 =rs.getString(4); String e2 =rs.getString(5); System.out.println(a2+","+b2+" ,"+c2+","+d2+","+e2); z+; if(z=0) System.out.println("查无此书,请重新输入"); else

15、System.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

16、(dq!=1) System.out.println("查询逾期罚款或是赔偿表中的读者的相关信息"); System.out.println("请输入逾期罚款或是赔偿的读者编码号"); String F=scanner.next(); String sq1234= "SELECT * FROM fine,borrowbook,systemreader WHERE fine.bookID=borrowbook.bookID AND borrowbook.reaID=systemreader.reaID AND fine.bookID='&

17、quot;+F+"' " rs= stmt.executeQuery(sq1234); int n=0; while(rs.next() String a2 =rs.getString(1); String b2 =rs.getString(2); String c2 =rs.getString(3); String d2 =rs.getString(4); String e2 =rs.getString(5); System.out.println(a2+","+b2+" ,"+c2+","+d2+&qu

18、ot;,"+e2); n+; if(n=0) System.out.println("查无此人,请重新输入"); else System.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

19、4: System.out.println(" 4.嵌套查询图书信息: "); int dq1=0; while(dq1!=1) System.out.println("查询某读者所在年级女读者的相关信息"); System.out.println("请输入某读者的读者编号"); String G=scanner.next(); String sq12345= "SELECT * FROM systemreader WHERE reaGrade=(SELECT reaGrade FROM systemreader WHERE

20、 reaID='"+G+"') AND reasex='女'" rs= stmt.executeQuery(sq12345); int m=0; while(rs.next() String a2 =rs.getString(1); String b2 =rs.getString(2); String c2 =rs.getString(3); String d2 =rs.getString(4); String e2 =rs.getString(5); System.out.println(a2+","+b2+&

21、quot; ,"+c2+","+d2+","+e2); m+; if(m=0) System.out.println("查无此书,请重新输入"); else System.out.println("是否继续输入读者编号？yes/no no返回主菜单"); String k=scanner.next(); if(k.startsWith("yes") System.out.println(); ; if(k.startsWith("no") d=1; System.o

22、ut.println(); ; break; case 5: System.out.println(" 5. 谓词演算查询 ： "); int dq1123=0; while(dq1123!=1) System.out.println("查询借阅了某本书的读者的相关信息"); System.out.println("请输入该书的名字"); String H=scanner.next(); String sq123456= "SELECT * FROM systemreader WHERE reaID IN (SELECT r

23、eaID FROM borrowbook WHERE bookName='"+H+"')" rs= stmt.executeQuery(sq123456); int l=0; while(rs.next() String a2 =rs.getString(1); String b2 =rs.getString(2); String c2 =rs.getString(3); String d2 =rs.getString(4); String e2 =rs.getString(5); System.out.println(a2+",&quo

24、t;+b2+" ,"+c2+","+d2+","+e2); l+; if(l=0) System.out.println("查无此人,请重新输入"); else System.out.println("是否继续输入图书名字？yes/no no返回主菜单"); String k=scanner.next(); if(k.startsWith("yes") System.out.println(); ; if(k.startsWith("no") d=1; S

25、ystem.out.println(); ; break; /c12 break; break; /*case 1: System.out.println(" 1. 查询图书信息: "); String Sql = "SELECT * FROM systembook " rs= stmt.executeQuery(Sql); while(rs.next() /String str =scanner.next(); String bookID =rs.getString(1); String bookNo =rs.getString(2); String

26、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. 插入图书信息: ")

27、; 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; String insertSql="INSERT INTO systembook(bookID,bookN

28、o,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) System.out.println(&qu