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

用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=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,); 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() 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(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) 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(); String sql1= SELECT * FROM systembook 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+ ,+c2+,+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; 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.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(查无此书,请重新输入); else 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(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=+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+,+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 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 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+ ,+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.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(); String sq123456= SELECT * FROM systemreader WHERE reaID IN (SELECT reaID 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+,+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; 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 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; String insertSql=INSERT INTO systembook(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!