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

1、精選優(yōu)質(zhì)文檔-傾情為你奉上用java做的一個(gè)圖書(shū)管理系統(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("請(qǐng)輸入用戶(hù)名："); String

2、username2=scanner.next(); System.out.println("請(qǐng)輸入密碼："); 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("*歡迎來(lái)山東科技大學(xué)圖書(shū)館管理系統(tǒng)*"); while(true) System.

4、out.println(" 1.圖書(shū)信息 "); System.out.println(" 2.讀者信息 "); System.out.println(" 3.管理員信息 "); System.out.println(" 4.借閱信息 "); System.out.println(" 5.還書(shū)信息 "); System.out.println(" 6.逾期罰款或損壞賠償信息"); /System.out.println(" 7.退出 "); System.

5、out.println(" 請(qǐng)輸入選擇功能的序號(hào) :"); int a=scanner.nextInt(); switch(a) case 1: System.out.println(" 圖書(shū)信息: "); System.out.println(" 1. 查詢(xún)圖書(shū)信息: "); System.out.println(" 2. 插入圖書(shū)信息: "); System.out.println(" 3. 刪除圖書(shū)信息: "); System.out.println(" 4. 修改圖書(shū)信息: &

6、quot;); int a1=scanner.nextInt(); switch(a1) case 1: System.out.println(" 歡迎進(jìn)入圖書(shū)信息查詢(xún)系統(tǒng): "); System.out.println(" 1. 無(wú)條件查詢(xún)圖書(shū)信息: "); System.out.println(" 2. 條件查詢(xún)圖書(shū)信息: "); int d=scanner.nextInt(); switch(d) case 1: int llll=0; /int mm=0; while(llll!=1) System.out.println(&

7、quot; 1. 無(wú)條件查詢(xún)圖書(shū)信息: "); 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. 條件查詢(xún)圖書(shū)信息: "); System.out.println(" 1. 單條件查詢(xún)圖書(shū)信息: "); System.out.println(" 2. 模糊條件查詢(xún)圖書(shū)信息: "); System.out.println(" 3. 多表連接查詢(xún)圖書(shū)信息: "); System.out.println(" 4. 嵌套查詢(xún)圖書(shū)信息: "); System.out.println

10、(" 5. 謂詞演算查詢(xún) "); int c12=scanner.nextInt(); switch(c12) case 1: System.out.println(" 1.單條件查詢(xún): "); System.out.println(" 1.按圖書(shū)名編碼號(hào)查詢(xún)圖書(shū)信息: "); int ddd=0; while(ddd!=1) System.out.println("請(qǐng)輸入圖書(shū)編碼號(hào):"); 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("查無(wú)此書(shū),請(qǐng)重新輸入"); else System.out.println("是否繼續(xù)按姓名查詢(xún)？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.模糊查詢(xún)圖書(shū)信息: "); int dc=0; while(dc!=1) System.out.println("請(qǐng)用戶(hù)輸入圖書(shū)名字中的模糊關(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("查無(wú)此書(shū),請(qǐng)重新輸入&

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

16、t dq=0; while(dq!=1) System.out.println("查詢(xún)逾期罰款或是賠償表中的讀者的相關(guān)信息"); System.out.println("請(qǐng)輸入逾期罰款或是賠償?shù)淖x者編碼號(hào)"); 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("查無(wú)此人,請(qǐng)重新輸入"); else System.out.println("是否繼續(xù)輸入圖書(shū)名字中的模糊關(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.嵌套查詢(xún)圖書(shū)信息: "); int dq1=0; while(dq1!=1) System.out.println("查詢(xún)某讀者所在年級(jí)女讀者的相關(guān)信息"); System.out.println("請(qǐng)輸入某讀者的讀者編號(hào)"); 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("查無(wú)此書(shū),請(qǐng)重新輸入"); else System.out.println("是否繼續(xù)輸入讀者編號(hào)？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. 謂詞演算查詢(xún) ： "); int dq1123=0; while(dq1123!=1) System.out.println("查詢(xún)借閱了某本書(shū)的讀者的相關(guān)信息"); System.out.println("請(qǐng)輸入該書(shū)的名字"); 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("查無(wú)此人,請(qǐng)重新輸入"); else System.out.println("是否繼續(xù)輸入圖書(shū)名字？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. 查詢(xún)圖書(shū)信息: "); 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. 插入圖書(shū)信息: "

27、); System.out.println("請(qǐng)按順序插入圖書(shū)條碼號(hào),圖書(shū)索書(shū)號(hào),圖書(shū)名字,圖書(shū)作者,圖書(shū)出版社"); 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(