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

1、精選優(yōu)質(zhì)文檔-傾情為你奉上用java做的一個圖書管理系統(tǒng)的源代碼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

2、username2=scanner.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("*歡迎來山東科技大學(xué)圖書館管理系統(tǒng)*"); while(true) System.

4、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.

5、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. 修改圖書信息: &

6、quot;); int a1=scanner.nextInt(); switch(a1) case 1: System.out.println(" 歡迎進入圖書信息查詢系統(tǒng): "); 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(&

7、quot; 1. 無條件查詢圖書信息: "); 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.

8、out.println(bookID+","+bookNo+","+bookName+","+ bookWriter+","+bookPub); System.out.println("是否繼續(xù)插入？yes/no no返回主菜單"); String k=scanner.next(); if(k.startsWith("yes") System.out.println(); ; if(k.startsWith("no") llll=1; System.out

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

10、(" 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(); String sql1= "SELECT * FROM syst

11、embook WHERE 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+" ,"

12、;+c2+","+d2+","+e2); x+; if(x=0) System.out.println("查無此書,請重新輸入"); else System.out.println("是否繼續(xù)按姓名查詢？yes/no no返回主菜單"); String k=scanner.next(); if(k.startsWith("yes") System.out.println(); ; if(k.startsWith("no") ddd=1; System.out.println(

13、); ; ; break; case 2: System.out.println(" 2.模糊查詢圖書信息: "); int dc=0; while(dc!=1) System.out.println("請用戶輸入圖書名字中的模糊關(guān)鍵字"); String E=scanner.next(); String sq123= "SELECT * FROM systembook WHERE bookName LIKE'"+E+"%'" rs= stmt.executeQuery(sq123); int z=

14、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+","+e2); z+; if(z=0) System.out.println("查無此書,請重新輸入&

15、quot;); else System.out.println("是否繼續(xù)輸入圖書名字中的模糊關(guān)鍵字？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.多表連接查詢查詢圖書信息: "); in

16、t dq=0; while(dq!=1) System.out.println("查詢逾期罰款或是賠償表中的讀者的相關(guān)信息"); System.out.println("請輸入逾期罰款或是賠償?shù)淖x者編碼號"); String F=scanner.next(); String sq1234= "SELECT * FROM fine,borrowbook,systemreader WHERE fine.bookID=borrowbook.bookID AND borrowbook.reaID=systemreader.reaID AND fine.

17、bookID='"+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+",

18、"+d2+","+e2); n+; if(n=0) System.out.println("查無此人,請重新輸入"); else System.out.println("是否繼續(xù)輸入圖書名字中的模糊關(guān)鍵字？yes/no no返回主菜單"); String k=scanner.next(); if(k.startsWith("yes") System.out.println(); ; if(k.startsWith("no") ddd=1; System.out.println(); ;

19、 break; case 4: System.out.println(" 4.嵌套查詢圖書信息: "); int dq1=0; while(dq1!=1) System.out.println("查詢某讀者所在年級女讀者的相關(guān)信息"); System.out.println("請輸入某讀者的讀者編號"); String G=scanner.next(); String sq12345= "SELECT * FROM systemreader WHERE reaGrade=(SELECT reaGrade FROM syste

20、mreader WHERE 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+"

21、;,"+b2+" ,"+c2+","+d2+","+e2); m+; if(m=0) System.out.println("查無此書,請重新輸入"); else System.out.println("是否繼續(xù)輸入讀者編號？yes/no no返回主菜單"); String k=scanner.next(); if(k.startsWith("yes") System.out.println(); ; if(k.startsWith("no")

22、d=1; System.out.println(); ; break; case 5: System.out.println(" 5. 謂詞演算查詢 ： "); int dq1123=0; while(dq1123!=1) System.out.println("查詢借閱了某本書的讀者的相關(guān)信息"); System.out.println("請輸入該書的名字"); String H=scanner.next(); String sq= "SELECT * FROM systemreader WHERE reaID IN (S

23、ELECT reaID FROM borrowbook WHERE bookName='"+H+"')" rs= stmt.executeQuery(sq); 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+",&qu

24、ot;+b2+" ,"+c2+","+d2+","+e2); l+; if(l=0) System.out.println("查無此人,請重新輸入"); else System.out.println("是否繼續(xù)輸入圖書名字？yes/no no返回主菜單"); String k=scanner.next(); if(k.startsWith("yes") System.out.println(); ; if(k.startsWith("no") d=1;

25、System.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,book

28、No,bookName,bookWriter,bookPub) VALUES('"+a11+"','"+a12+"','"+a13+"','"+a14+"','"+a15+"')" int i=stmt.executeUpdate(insertSql); /返回記錄影響的條數(shù) if(i!=0) System.out.println("插入成功!"); System.out.println("是否繼續(xù)插入？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(