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

用java做的一个图书管理系统的源代码
import .*;
import .*;
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;
"请输入用户名：");
String username2=();
"请输入密码：");
String password2=();
if(!("")||(""))){
try{
("");
conn=("jdbc:odbc:book","","");
String sql="select * from ww where username='"+username2+"'";
stmt=();
rs=(sql);
if())
{
if("password").equals(password2))
{
"***欢迎来山东科技大学图书馆管理系统**");
while(true)
{
" 1.图书信息");
" 2.读者信息");
" 3.管理员信息");
" 4.借阅信息");
" 5.还书信息");
" 6.逾期罚款或损坏赔偿信息");
出");
" 请输入选择功能的序号:");
int a=();
switch(a){
case 1:
" 图书信息: ");
" 1. 查询图书信息: ");
" 2. 插入图书信息: ");
" 3. 删除图书信息: ");
" 4. 修改图书信息: ");
int a1=();
switch(a1)
{
case 1:
" 欢迎进入图书信息查询系统: ");
" 1. 无条件查询图书信息: ");
" 2. 条件查询图书信息: ");
int d=();
switch(d){
case 1:
int llll=0;
无条件查询图书信息: ");
String Sql0 = "SELECT * FROM systembook ";
rs= (Sql0);
while()){
String bookID =(1);
String bookNo =(2);
String bookName =(3);
String bookWriter =(4);
String bookPub =(5);
","+bookNo+","+bookName+","+ bookWriter+","+bookPub);
}
"是否继续插入yes/no no返回主菜单");
String k=();
if("yes"))
};
if("no"))
{
llll=1;
};
}
break;
条件查询图书信息: ");
" 1. 单条件查询图书信息: ");
" 2. 模糊条件查询图书信息: ");
" 3. 多表连接查询图书信息: ");
" 4. 嵌套查询图书信息: ");
" 5. 谓词演算查询");
int c12=();
switch(c12){
case 1:
" 1.单条件查询: ");
" 1.按图书名编码号查询图书信息: ");
int ddd=0;
while(ddd!=1){
"请输入图书编码号:");
String A=();
String sql1= "SELECT * FROM systembook WHERE bookID ='"+A+"' ";
rs= (sql1);
int x=0;
while())
{
String a2 =(1);
String b2 =(2);
String c2 =(3);
String d2 =(4);
String e2 =(5);
","+b2+" ,"+c2+","+d2+","+e2);
x++;
}
if(x==0)
{"查无此书,请重新输入");
else{
"是否继续按姓名查询yes/no no返回主菜单");
String k=();
if("yes"))
{
};
if("no"))
{
ddd=1;
};
};
}
break;
case 2:
" 2.模糊查询图书信息: ");
int dc=0;
while(dc!=1){
"请用户输入图书名字中的模糊关键字");
String E=();
String sq123= "SELECT * FROM systembook WHERE bookName LIKE'"+E+"%'";
rs= (sq123);
int z=0;
while())
{
String a2 =(1);
String b2 =(2);
String c2 =(3);
String d2 =(4);
String e2 =(5);
","+b2+" ,"+c2+","+d2+","+e2);
z++;
}
if(z==0)
{"查无此书,请重新输入");
}
else{
"是否继续输入图书名字中的模糊关键字yes/no no 返回主菜单");
String k=();
if("yes"))
{
};
if("no"))
{
dc=1;
表连接查询查询图书信息: ");
int dq=0;
while(dq!=1){
"查询逾期罚款或是赔偿表中的读者的相关信息");
"请输入逾期罚款或是赔偿的读者编码号");
String F=();
String sq1234= "SELECT * FROM fine,borrowbook,systemreader WHERE = AND = AND ='"+F+"' ";
rs= (sq1234);
int n=0;
while())
{
String a2 =(1);
String b2 =(2);
String c2 =(3);
String d2 =(4);
String e2 =(5);
","+b2+" ,"+c2+","+d2+","+e2);
n++;
}
if(n==0)
{"查无此人,请重新输入");
}
else
{
"是否继续输入图书名字中的模糊关键字yes/no no返回主菜单");
if("yes"))
{
};
if("no"))
{
ddd=1;
};
}
}
break;
case 4:
" 4.嵌套查询图书信息: ");
int dq1=0;
while(dq1!=1){
"查询某读者所在年级女读者的相关信息");
"请输入某读者的读者编号");
String G=();
String sq12345= "SELECT * FROM systemreader WHERE reaGrade=(SELECT reaGrade FROM systemreader WHERE reaID='"+G+"') AND reasex='女'";
rs= (sq12345);
int m=0;
while())
{
String a2 =(1);
String b2 =(2);
String c2 =(3);
String d2 =(4);
String e2 =(5);
","+b2+" ,"+c2+","+d2+","+e2);
m++;
}
if(m==0)
{"查无此书,请重新输入");
}
else
{
"是否继续输入读者编号yes/no no返回主菜单");
if("yes"))
{
};
if("no"))
{
d=1;
};
}
}
break;
case 5:
" 5. 谓词演算查询：");
int dq1123=0;
while(dq1123!=1)
{
"查询借阅了某本书的读者的相关信息");
"请输入该书的名字");
String H=();
String sq123456= "SELECT * FROM systemreader WHERE reaID IN (SELECT reaID FROM borrowbook WHERE bookName='"+H+"')";
rs= (sq123456);
int l=0;
while())
{
String a2 =(1);
String b2 =(2);
String c2 =(3);
String d2 =(4);
String e2 =(5);
","+b2+" ,"+c2+","+d2+","+e2);
l++;
}
if(l==0)
{
"查无此人,请重新输入");
}
else
{
"是否继续输入图书名字yes/no no返回主菜单");
String k=();
if("yes"))
{
} ;
if("no"))
{
d=1;
};
}
}
break;
}查询图书信息: ");
String Sql = "SELECT * FROM systembook ";
rs= (Sql);
while()){
插入图书信息: ");
"请按顺序插入图书条码号,图书索书号,图书名字,图书作者,图书出版社");
String str=();
String []splitst=(",");
String a11=splitst[0];
String a12=splitst[1];
String a13=splitst[2];
String a14=splitst[3];
String a15=splitst[4];
String insertSql="INSERT INTO systembook(bookID,bookNo,bookName,bookWriter,bookPub)
VALUES('"+a11+"','"+a12+"','"+a13+"','"+a14+"','"+a15+"')";
int i=(insertSql); 删除图书信息: ");
"请输入要删除的图书编号:");
String Str=();
String []Splitst=(",");
String b3=Splitst[0];
String sql1="SELECT * FROM systembook where bookID='"+b3+"'";
rs= (sql1);
int kkk=0;
while())
{
String a22 =(1);
String b22 =(2);
String c22 =(3);
String d22 =(4);
String e22 =(5);
String f22 =(6);
","+b22+" ,"+c22+","+d22+","+e22+","+f22);
kkk++;
}
if(kkk==0)
{
"没有这本书，请重新输入");
}
else
{
{String deleSql= "DELETE FROM systembook WHERE bookID='"+b3+"'";
int p=(deleSql); 修改图书信息: ");
"请输入修改的图书ID ");
String S=();
String sql1="SELECT * FROM systembook where bookID='"+S+"'";
rs= (sql1);
int lll=0;
while())
{
String a222 =(1);
String b222 =(2);
String c222 =(3);
String d222 =(4);
String e222 =(5);
String f222 =(6);
","+b222+" ,"+c222+","+d222+","+e222+","+f222);
lll++;
}
if(lll==0)
{
"没有这本书，请重新输入");
}
else
{
"要将书名改为");
String bbb=();
String updateSql1="UPDATE systembook SET bookName='"+bbb+"' WHERE bookID='"+S+"'";
int hh=(updateSql1); 查询读者信息: ");
" 2. 插入读者信息: ");
" 3. 删除读者信息: ");
" 4. 修改读者信息: " );
int b1=();
switch(b1){
case 1:
" 1. 查询读者信息: ");
String ssql = "SELECT * FROM systemreader ";
rs= (ssql);
while()){
插入读者信息: ");
"请按顺序插入借书卡证号读者名字读者学号读者性别读者LBID 读者类型读者学院读者年级读者专业办证日期");
String str=();
String []splitst=(",");
String b11=splitst[0];
String b12=splitst[1];
String b13=splitst[2];
String b14=splitst[3];
String b15=splitst[4];
String b16=splitst[5];
String b17=splitst[6];
String b18=splitst[7];
String b19=splitst[8];
String b20=splitst[9];
String insertSql="INSERT INTO systemreader(reaID,reaName,reaNo,reaSex,reaLBID,reaType,reaDep,reaGrade,reaPre,reaDate) VALUES('"+b11+"','"+b12+"','"+b13+"','"+b14+"','"+b15+"','"+b16+"','"+b17+"','"+b18+"','"+b19+"' ,'"+b20+"')";
int n=(insertSql); 删除读者信息: ");
"请输入要删除的读者证号:");
String Str=();
String []Splitst=(",");
String r=Splitst[0];
String sql1="SELECT * FROM systemreader where reaID='"+r+"'";
rs= (sql1);
int kkk=0;
while())
{
String a22 =(1);
String b22 =(2);
String c22 =(3);
String d22 =(4);
String e22 =(5);
String f22 =(6);
String g22 =(7);
String h22 =(8);
String i22 =(9);
","+b22+" ,"+c22+","+d22+","+e22+","+f22+","+g22+","+h22+","+i22);
kkk++;
}
if(kkk==0)
{
"没有这个读者，请重新输入");
}
else
{
修改读者信息: ");
"请输入修改以后的读者的ID ");
String S=();
查询管理员信息: ");
" 2. 插入管理员信息: ");
" 3. 删除管理员信息: ");
" 4. 修改管理员信息: ");
" 5. 返回上一级");
int c11=();
switch(c11){
case 1:
" 1. 查询管理员信息: ");
String Ssql = "SELECT * FROM manager ";
rs= (Ssql);
while()){
插入管理员信息: ");
"请按顺序插入管理员的编号，管理员的姓名,管理员的性别,所管书库，电话，地址");
String str=();
String []splitst=(",");
String a11=splitst[0];
String a12=splitst[1];
String a13=splitst[2];
String a14=splitst[3];
String a15=splitst[4];
String a16=splitst[5];
String insertSql="INSERT INTO manager(mID,mName,mSex,mAuth,mTeleph,mAddre)
VALUES('"+a11+"','"+a12+"','"+a13+"','"+a14+"','"+a15+"','"+a16+"')";
int i=(insertSql); 删除管理员信息: ");
"请输入要删除的管理员编号:");
String Str=();
String []Splitst=(",");
String b3=Splitst[0];
String sql1="SELECT * FROM manager where mID='"+b3+"'";
rs= (sql1);
int kkk=0;
while())
{
String a22 =(1);
String b22 =(2);
String c22 =(3);
String d22 =(4);
String e22 =(5);
String f22 =(6);
","+b22+" ,"+c22+","+d22+","+e22+","+f22);
kkk++;
}
if(kkk==0)
{
"没有这个管理员，请重新输入");
}
else
{
修改管理员信息: ");
"请输入要修改的管理员编号：");
String S=();
String []Ssplitst=(",");
String c1=Ssplitst[0];
String sql1="SELECT * FROM manager where mID='"+S+"'";
rs= (sql1);
int lll=0;
while())
{
String a222 =(1);
String b222 =(2);
String c222 =(3);
String d222 =(4);
String e222 =(5);
String f222 =(6);
","+b222+" ,"+c222+","+d222+","+e222+","+f222);
lll++;
}
if(lll==0)
{
"没有这个管理员，请重新输入");
}
else
{
查询图书借阅信息信息: ");
" 2. 插入图书借阅信息: ");
" 3. 删除图书借阅信息: ");
" 4. 修改图书借阅信息: ");
" 5. 返回上一级");
int d=();
switch(d){
case 1:
" 1. 查询图书借阅信息: ");
String Sql4 = "SELECT * FROM borrowbook ";
rs= (Sql4);
while()){
String bookID =(1);
String reaID =(2);
String outDate =(3);
String yhDate =(4);
","+reaID+","+outDate+","+yhDate);
}
break;
case 2:
int zz=0;
while(zz!=1){
" 2. 插入图书借阅信息: ");
"请按顺序插入图书的的编号,读者编号,图书借出日期,图书归还日期");
String str=();
String []splitst=(",");
String a11=splitst[0];
String a12=splitst[1];
String a13=splitst[2];
String a14=splitst[3];
删除图书借阅信息: ");
"请输入要删除的图书条码号:");
String Str=();
String []Splitst=(",");
String b3=Splitst[0];
String sql1="SELECT * FROM borrowbook where bookID='"+b3+"'";
rs= (sql1);
int kkk=0;
while())
{
String a22 =(1);
String b22 =(2);
String c22 =(3);
String d22 =(4);
修改借阅读书信息: ");
"请输入要修改的图书的ID ");
String S=();
String []Ssplitst=(",");
String c1=Ssplitst[0];
String sql1="SELECT * FROM borrowbook where bookID='"+S+"'";
rs= (sql1);
int lll=0;
while())
{
String a222 =(1);
String b222 =(2);
String c222 =(3);
String d222 =(4);
查询还书信息: ");
" 2. 插入还书信息: ");
" 3. 删除还书信息: ");
" 4. 修改还书信息: ");
" 5. 返回上一级");
int e=();
switch(e){
case 1:
" 1. 查询还书信息: ");
sql = "SELECT * FROM return ";
rs= (sql);
while()){
String reaID =(1);
String bookID =(2);
String bookName =(3);
String inDate =(4);
","+bookID+","+bookName+","+ inDate);
}
break;
case 2:
" 2. 插入还书信息: ");
"请按顺序插入读者卡号,图书编号,图书名称,还书日期");
String str=();
String []splitst=(",");
String e1=splitst[0];
String e2=splitst[1];
String e3=splitst[2];
String e4=splitst[3];
String insertSql="INSERT INTO returnbook(reaID,bookID,bookName,inDate) VALUES('"+e1+"','"+e2+"','"+e3+"','"+e4+"')";
int h=(insertSql); 删除还书书信息: ");
"请输入要删除的读者证号:");
String Str=();
String []Splitst=(",");
String f3=Splitst[0];
String deleSql= "DELETE FROM return WHERE reaID='"+f3+"'";
int w=(deleSql); 查询罚款信息: ");
" 2. 插入罚款信息: ");
" 3. 删除罚款信息: ");
" 4. 修改罚款信息: ");
int g=();
switch(g){
case 1:
" 1. 查询罚款信息: ");
String Sssql = "SELECT * FROM fine ";
rs= (Sssql);
while()){
插入罚款信息: ");
"请按顺序插入读者卡号,图书编号,借书日期，超出日期,应缴罚款");
String str=();
String []splitst=(",");
String g1=splitst[0];
String g2=splitst[1];
String g3=splitst[2];
String g4=splitst[3];
String g5=splitst[4];
删除罚款信息: ");
"请输入要删除的读者证号:");
String Str=();
String []Splitst=(",");
String r=Splitst[0];
String deleSql= "DELETE FROM fine WHERE reaID='"+r+"'";
int x=(deleSql); 查询借阅历史信息: ");
" 2. 插入借阅历史信息: ");
" 3. 删除借阅历史信息: ");
" 4. 修改借阅历史信息: ");
" 5. 返回上一级");
int h=();
switch(h){
" 1. 查询历史借阅信息: ");
String Sql7 = "SELECT * FROM borrowhistory ";
rs= (Sql7);
while()){
String bookID =(1);
String reaID =(2);
String bookName=(3);
String bookWriter=(4);
String outDate =(5);
String yhDate =(6);
","+reaID+","+bookName+","+bookWriter+","+outDate+","+yhDate);
}
break;
case 2:
" 2. 插入图书历史借阅信息: ");
"请按顺序插入图书的的编号,读者编号,,图书借出日期,图书归还日期");
String str=();
String []splitst=(",");
String a11=splitst[0];
String a12=splitst[1];
String a13=splitst[2];
String a14=splitst[3];
删除图书历史借阅信息: ");
"请输入要删除的图书条码号:");
String Str=();
String []Splitst=(",");
String d3=Splitst[0];
String deleSql= "DELETE bookID FROM borrowhistory WHERE bookID='"+d3+"'";
int k=(deleSql); 修改图书借阅历史信息: ");
"请输入要修改的图书的借出日期");
String S=();
String []Ssplitst=(",");
String c1=Ssplitst[0];
String updateSql="UPDATE borrow SET outDate='"+c1+"' WHERE bookName='数据库'";
int t=(updateSql); //返回记录影响的条数
if(t!=0){
"修改成功!");}
break;
}
}}
}
}
else{
"非法用户！");
}
}catch(SQLException e) {
();
}
//();
();
();
}
}
}
}。