用java做的一个图书管理系统的源代码.docx
《用java做的一个图书管理系统的源代码.docx》由会员分享,可在线阅读,更多相关《用java做的一个图书管理系统的源代码.docx(47页珍藏版)》请在冰豆网上搜索。
![用java做的一个图书管理系统的源代码.docx](https://file1.bdocx.com/fileroot1/2023-2/24/6abc2253-82bb-4a9b-9fe4-e9fa49f6d463/6abc2253-82bb-4a9b-9fe4-e9fa49f6d4631.gif)
用java做的一个图书管理系统的源代码
用java做的一个图书管理系统的源代码
importjava.sql.*;
importjava.util.*;
publicclassT{
publicstaticvoidmain(String[]args)throwsException{
Connectionconn=null;
Statementstmt=null;
ResultSetrs=null;
while(true)
{Scannerscanner=newScanner(System.in);
System.out.println(”请输入用户名:
”);
Stringusername2=scanner.next();
System.out.println(”请输入密码:
");
Stringpassword2=scanner.next();
if(!
(username2.equals("")||password2.equals(""))){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:
odbc:
book","","");
Stringsql="select*fromwwwhereusername="'+username2+""';
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
if(rs.next())
{
if(rs.getString("password").equals(password2))
{
System.out.println("*********欢迎来山东科技大学图书馆管理系统
********“、.
while(true)
inta1=scanner.nextInt();switch(a1)
{
欢迎进入图书信息查询系统:
")无条件查询图书信息:
");条件查询图书信息:
");
case1:
System.out.println("
System.out.println("1.
System.out.println("2.
intd=scanner.nextInt();
switch(d){
case1:
intllll=0;
//intmm=0;
while(llll!
=1){
System.out.println(”1.
无条件查询图书信息:
"
StringSql0="SELECT*FROMsystembook";rs=stmt.executeQuery(SqlO);
while(rs.next()){
StringbookID=rs.getString
(1);
StringbookNo=rs.getString
(2);
StringbookName=rs.getString(3);
StringbookWriter=rs.getString(4);
StringbookPub=rs.getString(5);
System.out.println(booklD+","+bookNo+","+bookName+","+bookWriter+","+bookPub);
}
是否继续插入?
yes/nono返回主菜单");
System.out.println("
Stringk=scanner.next();if(k.startsWith("yes")){
System.out.println();
};
if(k.startsWith("no"))
{
1111=1;
System.out.println();};
}
break;
//break;
case2:
单条件查询:
");
按图书名编码号查询图书信息:
");
System.out.println(”2.
System.out.println(”1.
System.out.println(”2.
System.out.println(”3.
System.out.println(”4.
System.out.println("5.intc12=scanner.nextInt();switch(c12){
case1:
System.out.println(”1.
System.out.println(”1.intddd=O;
while(ddd!
=1){
System.out.println("
条件查询图书信息:
");单条件查询图书信息:
");模糊条件查询图书信息:
");多表连接查询图书信息:
");嵌套查询图书信息:
");谓词演算查询");
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++;
}
查无此书,请重新输入");
是否继续按姓名查询?
yes/no
if(x==0)
{System.out.println("
}else{
System.out.println("
no返回主菜单");
Stringk=scanner.next();
if(k.startsWith("yes"))
{
System.out.println();
};
if(k.startsWith("no"))
{
ddd=1;
System.out.println();
};
};
}
break;
case2:
System.out.println(”2.intdc=0;
while(dc!
=1){
模糊查询图书信息:
");
System.out.println("
请用户输入图书名字中的模糊关键字
");
StringE=scanner.next();
Stringsq123="SELECT*FROMfeystembookWHEREookName
LIKE”'+E+"%”:
rs=stmt.executeQuery(sq123);intz=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("
}
else{
System.out.println("模糊关键字?
yes/nono返回主菜单");
Stringk=scanner.next();if(k.startsWith("yes")){
System.out.println();
};
if(k.startsWith("no"))
{
dc=1;
System.out.println();
//break;
};
}
}break;
case3:
System.out.println(”3.
");
intdq=0;
while(dq!
=1){
System.out.println("
相关信息”);
查无此书,请重新输入");
是否继续输入图书名字中的
多表连接查询查询图书信息
查询逾期罚款或是赔偿表中的读者的
System.out.println(”
请输入逾期罚款或是赔偿的读者编码
号”);
StringF=scanner.next();
Stringsq1234="SELECT*FROM
fine,borrowbook,systemreaderWHEREfine.booklD=borrowbook.booklDAND
borrowbook.realD=systemreader.realDANDfine.bookID='"+F+"'";
rs=stmt.executeQuery(sq1234);
intn=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("
}
else
{
System.out.println();
};
if(k.startsWith("no"))
{
ddd=1;
System.out.println();
};
}
}
break;
case4:
System.out.println(”intdq仁0;
while(dq1!
=1){
System.out.println(”
System.out.println(”
4.
嵌套查询图书信息:
”);
查询某读者所在年级女读者的相关信息
请输入某读者的读者编号");
StringG=scanner.next();
Stringsq12345="SELECT*FROMsystemreader
reaGrade=(SELECTreaGradeFROMsystemreaderWHERErealD="'+G+"')ANDreasex='
");
WHERE
女
rs=stmt.executeQuery(sq12345);intm=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("
}
else
{
System.out.println("
no返回主菜单");
Stringk=scanner.next();if(k.startsWith("yes")){
System.out.println();
};
if(k.startsWith("no"))
{
d=1;
System.out.println();
查无此书,请重新输入");
是否继续输入读者编号?
yes/no
};
}
}
break;
谓词演算查询:
");
case5:
System.out.println("5.
intdq1123=0;
while(dq1123!
=1)
查询借阅了某本书的读者的相关
{
System.out.println("
信息”);
System.out.println(”请输入该书的名字”);
StringH=scanner.next();
Stringsq123456="SELECT*FROMsystemreaderWHERE
reaIDIN(SELECTreaIDFROMborrowbookWHEREbookName=”'+H+"')";
rs=stmt.executeQuery(sq123456);
intl=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("
}
else
{
System.out.println("
yes/nono返回主菜单”);
Stringk=scanner.next();if(k.startsWith("yes")){
System.out.println();
};
if(k.startsWith(”no"))
{
d=1;
System.out.println();
};
}
}
break;
}//c12
break;
}
break;
/*case1:
System.out.println(”1.查询图书信息:
");
StringSql="SELECT*FROMsystembook";
rs=stmt.executeQuery(Sql);
while(rs.next()){
//Stringstr=scanner.next();
StringbookID=rs.getString
(1);
StringbookNo=rs.getString
(2);
StringbookName=rs.getString(3);
StringbookWriter=rs.getString(4);
StringbookPub=rs.getString(5);
System.out.println(booklD+","+bookNo+","+bookName+","+
bookWriter+","+bookPub);
}
break;*/
case2:
intzz=O;
while(zz!
=1){
Stringa12=splitst[1];Stringa13=splitst[2];
Stringa14=splitst[3];
Stringa15=splitst[4];
StringinsertSql="INSERTINTO
systembook(booklD,bookNo,bookName,bookWriter,bookPub)
VALUES(”'+a11+"',”'+a12+"',”'+a13+"',”'+a14+"',”'+a15+"')";
inti=stmt.executeUpdate(insertSql);//返回记录影响的条数
if(i!
=0){
System.out.println(”插入成功!
");}
System.out.println(”是否继续插入?
yes/nono返回主菜单”);
Stringk=scanner.next();
if(k.startsWith("yes"))
{
System.out.println();
};
if(k.startsWith("no"))
{
zz=1;
System.out.println();
};
}
break;
case3:
int11=0;
〃intmm=0;while(ll!
=1){
System.out.println(”3.删除图书信息:
”);
System.out.println(”请输入要删除的图书编号:
”);
StringStr=scanner.next();
String[]Splitst=Str.split(",");
Stringb3=Splitst[0];
Stringsql仁"SELECT*FROMsystembookwherebooklD=”'+b3+"”';rs=stmt.executeQuery(sqll);
intkkk=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("没有这本书,请重新输入");
}
else
{
主菜单”);
Stringl=scanner.next();if(l.startsWith("yes"))
{
System.out.println();
};
if(l.startsWith("no"))
{
ll=1;
System.out.println();
};
};
}
}
break;
case4:
修改图书信息:
");请输入修改的图书ID");
intmm=0;while(mm!
=1){
System.out.println(”4.
System.out.println("
StringS=scanner.next();
Stringsql仁"SELECT*FROMsystembookwherebooklD=”'+S+"”';rs=stmt.executeQuery(sqll);
intlll=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);
III++;
}
if(lll==0)
{
System.out.println("没有这本书,请重新输入");
}
else
{
System.out.println(”要将书名改为”);
Stringbbb=scanner.next();
StringupdateSql仁"UPDATEsystembookSET
bookName='"+bbb+"'WHEREbookID='"+S+"”';
inthh=stmt.executeUpdate(updateSql1);//返回记录影响的条数
if(hh!
=O)
{
System.out.println(”修改成功!
");
}
System.out.println(”是否继续修改yes/nono返回主菜单");
Stringo=scanner.next();
if(o.startsWith("yes"))
{
System.out.println();
};
if(o.startsWith("no"))
{
mm=1;
System.out.println();
};
}
}
break;
}break;
/*StringupdateSql="UPDATEsystembookSETbookCopy="'+c1+"'
WHEREbookName=^据库管理”:
返回记录影响的条数
intt=stmt.executeUpdate(updateSql);//
if(t!
=O){
System.out.println("
修改成功!
");}
break;
}break;*/
case2:
System.out.println("
读者信息:
");
System.out.println(”1.
查询读者信息:
");
System.out.println(”2.
插入读者信息:
");
System.out.println(”3.
删除读者信息:
");
System.out.println(”4.
修改读者信息:
”);
intb1=scanner.nextInt();
switch(b1){
case1:
System.out.println(”1.
查询读者信息:
”
Stringssql="SELECT*FROMsystemreader";rs=stmt.executeQuery(ssql);
while(rs.next()){
//Stringstr=scanner.next();
StringrealD=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);
Syst