📄 rborrowbook.java
字号:
}
con.close();
}
//设置续借统计中该书为超期///////////////////////////////////////////////////////////////////////////////////////////
public void Chaoqi3() throws SQLException
{ String chaoqi="是";
String dzxm,dzbh,txm,xb,sf,yxzj,zjhm,zcrq,zxrq,csrq,lxdh,lxdz,dzzt,kjsl,zcqx,jycs,czy,bz,borrowed;
String strurl=
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch (ClassNotFoundException eg) {}
con= DriverManager.getConnection(strurl);
stmt= con.createStatement();
ResultSet rs = stmt.executeQuery("select * from 续借统计");
while(rs.next())
{ dzxm=rs.getString("读者姓名");dzbh=rs.getString("读者编号");txm=rs.getString("读者条形码");
xb=rs.getString("图书名称");sf=rs.getString("图书编号");yxzj=rs.getString("图书条形码");zjhm=rs.getString("续借数量");
zcrq=String.valueOf(rs.getInt("图书价格"));zxrq=rs.getString("出版社");csrq=rs.getString("存放位置");
lxdh=rs.getString("图书类型");lxdz=rs.getString("上次借阅时间");dzzt=rs.getString("本次续借时间");
zcqx=rs.getString("下次归还时间");czy=rs.getString("操作员");bz=rs.getString("续借次数");
borrowed=rs.getString("是否超期");
stmt.executeUpdate("update 续借统计 set 是否超期='"+chaoqi+"'where 图书编号='"+code+"'");
}
con.close();
}
//设置续借统计中续借次数和是否超期///////////////////////////////////////////////////////////////////////////////////////////
public void Xujie() throws SQLException
{ bc="";
int bcc=0;
String chao="否";
String dzxm,dzbh,txm,xb,sf,yxzj,zjhm,zcrq,zxrq,csrq,lxdh,lxdz,dzzt,kjsl,zcqx,jycs,czy,bz,borrowed;
String strurl=
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch (ClassNotFoundException eg) {}
con= DriverManager.getConnection(strurl);
stmt= con.createStatement();
ResultSet rs = stmt.executeQuery("select * from 续借统计");
while(rs.next())
{ dzxm=rs.getString("读者姓名");dzbh=rs.getString("读者编号");txm=rs.getString("读者条形码");
xb=rs.getString("图书名称");sf=rs.getString("图书编号");yxzj=rs.getString("图书条形码");zjhm=rs.getString("续借数量");
zcrq=String.valueOf(rs.getInt("图书价格"));zxrq=rs.getString("出版社");csrq=rs.getString("存放位置");
lxdh=rs.getString("图书类型");lxdz=rs.getString("上次借阅时间");dzzt=rs.getString("本次续借时间");
zcqx=rs.getString("下次归还时间");czy=rs.getString("操作员");bz=rs.getString("续借次数");
borrowed=rs.getString("是否超期");
bcc=Integer.parseInt(bz);
bcc++;
bc=String.valueOf(bcc);
stmt.executeUpdate("update 续借统计 set 续借次数='"+bc+"',是否超期='"+chao+"'where 图书编号='"+code+"'");
}
con.close();
}
//设置读者状态为超期///////////////////////////////////////////////////////////////////////////////////////////
public void Chaoqi() throws SQLException
{ String chaoqi="借书超期";
String dzxm,dzbh,txm,xb,sf,yxzj,zjhm,zcrq,zxrq,csrq,lxdh,lxdz,dzzt,kjsl,zcqx,jycs,czy,bz;
String strurl=
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch (ClassNotFoundException eg) {}
con= DriverManager.getConnection(strurl);
stmt= con.createStatement();
ResultSet rs = stmt.executeQuery("select * from 读者资料");
while(rs.next())
{ dzxm=rs.getString("读者姓名");dzbh=rs.getString("读者编号");txm=rs.getString("条形码");
xb=rs.getString("性别");sf=rs.getString("身份");yxzj=rs.getString("有效证件");zjhm=rs.getString("证件号码");
zcrq=rs.getString("注册日期");zxrq=rs.getString("截止日期");csrq=rs.getString("出生日期");
lxdh=rs.getString("联系电话");lxdz=rs.getString("联系地址");dzzt=rs.getString("读者状态");
kjsl=String.valueOf(rs.getInt("可借数量"));zcqx=String.valueOf(rs.getInt("最长期限"));jycs=String.valueOf(rs.getInt("借阅次数"));czy=rs.getString("操作员");bz=rs.getString("备注");
stmt.executeUpdate("update 读者资料 set 读者状态='"+chaoqi+"'where 读者编号='"+jtf5.getText().trim()+"'");
}
con.close();
}
//查询读者状态是否超期///////////////////////////////////////////////////////////////////////////////////////////
public void Chaoqi1() throws SQLException
{ String chaoqi="借书超期",guashi="已挂失";
String dzxm,dzbh,txm,xb,sf,yxzj,zjhm,zcrq,zxrq,csrq,lxdh,lxdz,dzzt,kjsl,zcqx,jycs,czy,bz,yjsl;
String strurl=
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch (ClassNotFoundException eg) {}
con= DriverManager.getConnection(strurl);
stmt= con.createStatement();
ResultSet rs = stmt.executeQuery("select * from 读者资料 where 读者编号='"+jtf1.getText().trim()+"'");
while(rs.next())
{ dzxm=rs.getString("读者姓名");dzbh=rs.getString("读者编号");txm=rs.getString("条形码");
xb=rs.getString("性别");sf=rs.getString("身份");yxzj=rs.getString("有效证件");zjhm=rs.getString("证件号码");
zcrq=rs.getString("注册日期");zxrq=rs.getString("截止日期");csrq=rs.getString("出生日期");
lxdh=rs.getString("联系电话");lxdz=rs.getString("联系地址");dzzt=rs.getString("读者状态");
kjsl=String.valueOf(rs.getInt("可借数量"));zcqx=String.valueOf(rs.getInt("最长期限"));jycs=String.valueOf(rs.getInt("借阅次数"));czy=rs.getString("操作员");bz=rs.getString("备注");
yjsl=String.valueOf(rs.getInt("已借数量"));
if(dzzt.equals("借书超期"))
{lb3.setText("该读者所借图书已超期，请归还超期图书后再借!");
}
else if(dzzt.equals(guashi))
{lb3.setText("该读者已挂失，请办理新证后再借!");
}
else
{try{ Query2();}
catch(SQLException ed){System.err.println(ed);}
try{ Query();}
catch(SQLException ed){System.err.println(ed);}
}
}
con.close();
}
//查询读者资料代码///////////////////////////////////////////////////////////////////////////////////////////
public void Query() throws SQLException
{
String dzxm,dzbh,txm,xb,sf,yxzj,zjhm,zcrq,zxrq,csrq,lxdh,lxdz,dzzt,kjsl,zcqx,jycs,czy,bz;
String strurl=
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch (ClassNotFoundException eg) {}
con= DriverManager.getConnection(strurl);
stmt= con.createStatement();
ResultSet rs = stmt.executeQuery("select * from 读者资料");
while(rs.next())
{ dzxm=rs.getString("读者姓名");dzbh=rs.getString("读者编号");txm=rs.getString("条形码");
xb=rs.getString("性别");sf=rs.getString("身份");yxzj=rs.getString("有效证件");zjhm=rs.getString("证件号码");
zcrq=rs.getString("注册日期");zxrq=rs.getString("截止日期");csrq=rs.getString("出生日期");
lxdh=rs.getString("联系电话");lxdz=rs.getString("联系地址");dzzt=rs.getString("读者状态");
kjsl=String.valueOf(rs.getInt("可借数量"));zcqx=String.valueOf(rs.getInt("最长期限"));jycs=String.valueOf(rs.getInt("借阅次数"));czy=rs.getString("操作员");bz=rs.getString("备注");
if(jrb1.isSelected())//按读者编号
{
if(dzbh.equals(jtf1.getText()))
{ jtf2.setText(dzxm);jtf3.setText(xb);jtf4.setText(sf);jtf5.setText(dzbh);jtf6.setText(txm);jtf7.setText(kjsl);
jtf8.setText(yxzj);jtf9.setText(zjhm);jtf10.setText(lxdh);jtf11.setText(lxdz);jtf12.setText(zcrq);
try{ Query2();}
catch(SQLException ed){System.err.println(ed);}
lb3.setText("该读者总共可借"+kjsl+"本,最长期限为"+zcqx+"天,现已借"+String.valueOf(readerc)+"本!");
lb3.setToolTipText("该读者总共可借"+kjsl+"本,最长期限为"+zcqx+"天,现已借"+String.valueOf(readerc)+"本!");
rzcqx=zcqx;
try{ setnull1();}
catch(SQLException ed){System.err.println(ed);}
try{ view();}
catch(SQLException ed){System.err.println(ed);}
try{ setnull();}
catch(SQLException ed){System.err.println(ed);}
try{ Query1();}
catch(SQLException ed){System.err.println(ed);}
}
}
if(jrb2.isSelected())//按条形码
{
if(txm.equals(jtf1.getText()))
{ jtf2.setText(dzxm);jtf3.setText(xb);jtf4.setText(sf);jtf5.setText(dzbh);jtf6.setText(txm);jtf7.setText(kjsl);
jtf8.setText(yxzj);jtf9.setText(zjhm);jtf10.setText(lxdh);jtf11.setText(lxdz);jtf12.setText(zcrq);
rzcqx=zcqx;
try{ Query2();}
catch(SQLException ed){System.err.println(ed);}
lb3.setText("该读者总共可借"+kjsl+"本,最长期限为"+zcqx+"天,现已借"+String.valueOf(readerc)+"本!");
lb3.setToolTipText("该读者总共可借"+kjsl+"本,最长期限为"+zcqx+"天,现已借"+String.valueOf(readerc)+"本!");
try{ setnull1();}
catch(SQLException ed){System.err.println(ed);}
try{ view();}
catch(SQLException ed){System.err.println(ed);}
try{ setnull();}
catch(SQLException ed){System.err.println(ed);}
try{ Query1();}
catch(SQLException ed){System.err.println(ed);}
}
}
if(jrb3.isSelected())//按读者姓名
{
if(dzxm.equals(jtf1.getText()))
{ jtf2.setText(dzxm);jtf3.setText(xb);jtf4.setText(sf);jtf5.setText(dzbh);jtf6.setText(txm);jtf7.setText(kjsl);
jtf8.setText(yxzj);jtf9.setText(zjhm);jtf10.setText(lxdh);jtf11.setText(lxdz);jtf12.setText(zcrq);
rzcqx=zcqx;
try{ Query2();}
catch(SQLException ed){System.err.println(ed);}
lb3.setText("该读者总共可借"+kjsl+"本,最长期限为"+zcqx+"天,现已借"+String.valueOf(readerc)+"本!");
lb3.setToolTipText("该读者总共可借"+kjsl+"本,最长期限为"+zcqx+"天,现已借"+String.valueOf(readerc)+"本!");
try{ setnull1();}
catch(SQLException ed){System.err.println(ed);}
try{ view();}
catch(SQLException ed){System.err.println(ed);}
try{ setnull();}
catch(SQLException ed){System.err.println(ed);}
try{ Query1();}
catch(SQLException ed){System.err.println(ed);}
}
}
}
con.close();
}
//查询借书统计代码////////////////////////////////////////////////////////////////////////////////////////
public void Query2() throws SQLException
{ readerc=0;
String dzxm,dzbh,txm,xb,sf,yxzj,zjhm,zcrq,zxrq,csrq,lxdh,lxdz,dzzt,kjsl,zcqx,jycs,czy,bz;
String strurl=
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch (ClassNotFoundException eg) {}
con= DriverManager.getConnection(strurl);
stmt= con.createStatement();
ResultSet rs = stmt.executeQuery("select * from 借书统计 where 读者编号='"+jtf5.getText().trim()+"'");
while(rs.next())
{ dzxm=rs.getString("读者姓名");dzbh=rs.getString("读者编号");txm=rs.getString("读者条形码");
xb=rs.getString("图书名称");sf=rs.getString("图书编号");yxzj=rs.getString("图书条形码");zjhm=String.valueOf(rs.getInt("借阅数量"));
zcrq=String.valueOf(rs.getInt("图书价格"));zxrq=rs.getString("出版社");csrq=rs.getString("存放位置");
lxdh=rs.getString("图书类型");lxdz=rs.getString("借书日期");dzzt=rs.getString("应还日期");
zcqx=rs.getString("操作员");jycs=rs.getString("续借");czy=rs.getString("是否超期");
readerc++;
}
con.close();
}
//查询续借统计代码///////////////////////////////////////////////////////////////////////////////////////////
public void Query1() throws SQLException
{int i=0;
String dzxm,dzbh,txm,xb,sf,yxzj,zjhm,zcrq,zxrq,csrq,lxdh,lxdz,dzzt,kjsl,zcqx,jycs,czy,bz,borrowed;
String strurl=
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch (ClassNotFoundException eg) {}
con= DriverManager.getConnection(strurl);
stmt= con.createStatement();
ResultSet rs = stmt.executeQuery("select * from 续借统计 where 读者编号='"+jtf5.getText().trim()+"'");
while(rs.next())
{ dzxm=rs.getString("读者姓名");dzbh=rs.getString("读者编号");txm=rs.getString("读者条形码");
xb=rs.getString("图书名称");sf=rs.getString("图书编号");yxzj=rs.getString("图书条形码");zjhm=rs.getString("续借数量");
zcrq=String.valueOf(rs.getInt("图书价格"));zxrq=rs.getString("出版社");csrq=rs.getString("存放位置");
lxdh=rs.getString("图书类型");lxdz=rs.getString("上次借阅时间");dzzt=rs.getString("本次续借时间");
zcqx=rs.getString("下次归还时间");czy=rs.getString("操作员");bz=rs.getString("续借次数");
borrowed=rs.getString("是否超期");
rowData1[i][0]=dzxm;rowData1[i][1]=dzbh;rowData1[i][2]=txm;rowData1[i][3]=xb;
rowData1[i][4]=sf;rowData1[i][5]=yxzj;rowData1[i][6]=zjhm;rowData1[i][7]=zcrq;
rowData1[i][8]=zxrq;rowData1[i][9]=csrq;rowData1[i][10]=lxdh;rowData1[i][11]=lxdz;
rowData1[i][12]=dzzt;rowData1[i][13]=zcqx;rowData1[i][14]=czy;rowData1[i][15]=bz;
rowData1[i][16]=borrowed;i++;
}
con.close();
}
////////////////////////////////////////////查询上次续借时间代码//////////////////////////////////////////////
public void Query3() throws SQLException
{
try{ String dzxm,dzbh,txm,xb,sf,yxzj,zjhm,zcrq,zxrq,csrq,lxdh,lxdz,dzzt,kjsl,zcqx,jycs,czy,bz,borrowed;
String strurl=
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch (ClassNotFoundException eg) {}
con= DriverManager.getConnection(strurl);
stmt= con.createStatement();
ResultSet rs = stmt.executeQuery("select * from 续借统计 where 图书编号='"+code+"'");
while(rs.next())
{ dzxm=rs.getString("读者姓名");dzbh=rs.getString("读者编号");txm=rs.getString("读者条形码");
xb=rs.getString("图书名称");sf=rs.getString("图书编号");yxzj=rs.getString("图书条形码");zjhm=rs.getString("续借数量");
zcrq=String.valueOf(rs.getInt("图书价格"));zxrq=rs.getString("出版社");csrq=rs.getString("存放位置");
lxdh=rs.getString("图书类型");lxdz=rs.getString("上次借阅时间");dzzt=rs.getString("本次续借时间");
zcqx=rs.getString("下次归还时间");czy=rs.getString("操作员");bz=rs.getString("续借次数");
borrowed=rs.getString("是否超期");
jtf16.setText(dzzt);
lb17.setText("上次续借时间:");
}
}
catch(Exception es)
{es.printStackTrace();}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -