📄 guashibook.java
字号:
float fd=days1*fakuan1;
jtf19.setText(String.valueOf(fd));
btn5.setEnabled(true);jtf17.setEnabled(false);
jtf18.setEnabled(true);jtf19.setEnabled(true);
jtf16.setEnabled(true);jtf20.setEnabled(true);
jtf21.setEnabled(true);
}
else
{jrb5.setSelected(true); btn5.setEnabled(true);jtf17.setEnabled(true);
jtf18.setEnabled(true);jtf19.setEnabled(true);
jtf16.setEnabled(true);jtf20.setEnabled(true);
jtf21.setEnabled(true);
}
}
}
con.close();
}
//////////////////////查询该读者未续借图书是否超期和设置超期信息////////////////////////////////////////////////////////
public void Update1() 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=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("是否超期");
if(dzbh.equals(tempString)||txm.equals(tempString)||sf.equals(tempString)||yxzj.equals(tempString))
{code=sf;tiaoma=yxzj;name=xb;jtf16.setText(lxdz);
bookprice=zcrq;bookpress=zxrq;bookstock=csrq;bookfenlei=lxdh;bookdate=dzzt;bookstatus=jycs;
lb3.setText("您要挂失的图书编号为:"+code+",条形码为:"+tiaoma+",名称为:"+name);
lb3.setToolTipText("您要挂失的图书编号为:"+code+",条形码为:"+tiaoma+",名称为:"+name);
nowTime=new Date();
matter=new SimpleDateFormat("yyyy-MM-dd");
calendar=Calendar.getInstance();
calendar.setTime(new Date());
int year=calendar.get(Calendar.YEAR),
month=calendar.get(Calendar.MONTH)+1,
day=calendar.get(Calendar.DAY_OF_MONTH);
String year1=String.valueOf(calendar.get(Calendar.YEAR)),
month1=String.valueOf(calendar.get(Calendar.MONTH)+1),
day1=String.valueOf(calendar.get(Calendar.DAY_OF_MONTH));
String substr=bookdate.substring(0,4),
substr1=bookdate.substring(5,7),
substr2=bookdate.substring(8,10);
calendar.set(Integer.parseInt(substr),Integer.parseInt(substr1)-1,Integer.parseInt(substr2));
long time1=calendar.getTimeInMillis();
calendar.set(year,month-1,day);
long time2=calendar.getTimeInMillis();
long days=(time2-time1)/(1000*60*60*24);
if(days>Integer.parseInt(rzcqx))
{jrb4.setSelected(true);
try{ Chaoqi();}
catch(SQLException ed){System.err.println(ed);}
try{ Fajin();}
catch(SQLException ed){System.err.println(ed);}
JOptionPane.showMessageDialog(null, "该读者所借此书已超期，请交付罚金并及时归还该书!", "友情提示",
JOptionPane.WARNING_MESSAGE);
lb3.setText("该超期图书编号为:"+code+",条形码为:"+tiaoma+",名称为:"+name);
jtf16.setText(matter.format(nowTime));
jtf17.setText(String.valueOf(days));
jtf18.setText(fakuan);
float fakuan1=Float.valueOf(fakuan).floatValue();
float days1=Float.valueOf(days).floatValue();
float fd=days1*fakuan1;
jtf19.setText(String.valueOf(fd));
btn5.setEnabled(true);jtf17.setEnabled(true);
jtf18.setEnabled(true);jtf19.setEnabled(true);
jtf16.setEnabled(true);jtf20.setEnabled(true);
jtf21.setEnabled(true);
}
else
{jrb5.setSelected(true); btn5.setEnabled(true);jtf17.setEnabled(true);
jtf18.setEnabled(true);jtf19.setEnabled(true);
jtf16.setEnabled(true);jtf20.setEnabled(true);
jtf21.setEnabled(true);
}
}
}
con.close();
}
//查询每日罚款金额代码///////////////////////////////////////////////////////////////////////////////////////////
public void Fajin() throws SQLException
{ String bianhao="1";
String mrfj,autoview,bh;
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 编号='"+bianhao+"'");
while(rs.next())
{ mrfj=rs.getString("每日罚金");autoview=rs.getString("是否自动显示");bh=rs.getString("编号");
fakuan=mrfj;
}
}
//交付罚金按钮实现代码///////////////////////////////////////////////////////////////////////////////////////////
public void Jiaofu() throws SQLException
{ String frbh,frtxm,frname,fbbh,fbtxm,fbname,fcount,fdate,flate,fdays,fday,ftotal,fmoney,fzcy;
String chao="";
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();
if(jrb4.isSelected())
{chao="是";}
else if(jrb5.isSelected())
{chao="否";}
if(jtf21.getText().trim().equals(""))
{JOptionPane.showMessageDialog(null, "操作人员不能为空，请填写完整后再交付罚款金额!", "友情提示",
JOptionPane.WARNING_MESSAGE);
}
else
{ ResultSet rs = stmt.executeQuery("select * from 挂失图书");
while(rs.next())
{ fbbh=rs.getString("图书编号");fbtxm=rs.getString("图书条形码");fbname=rs.getString("图书名称");
frbh=rs.getString("读者编号");frtxm=rs.getString("读者条形码");frname=rs.getString("读者姓名");
fcount=rs.getString("丢失数量");fdate=rs.getString("丢失时间");flate=rs.getString("是否超期");
fdays=rs.getString("超期天数");fday=rs.getString("每日罚金");ftotal=rs.getString("罚款总计");
fmoney=rs.getString("赔偿金额");fzcy=rs.getString("操作员");
if(fbbh.equals(code))
{JOptionPane.showMessageDialog(null, "该图书已交过超期罚款及赔偿金额，请下次注意保护图书!", "友情提示",
JOptionPane.WARNING_MESSAGE);
btn5.setEnabled(false);btn6.setEnabled(true);
}
else
{stmt.executeUpdate("INSERT INTO 挂失图书(图书编号,图书条形码,图书名称,读者编号,读者条形码,读者姓名,丢失数量,丢失时间,是否超期,超期天数,每日罚金,罚款总计,赔偿金额,操作员) values ('"+code+"','"+tiaoma+"','"+name+"','"+jtf5.getText().trim()+"','"+jtf6.getText().trim()+"','"+jtf2.getText().trim()+"','"+jtf15.getText().trim()+"','"+jtf16.getText().trim()+"','"+chao+"','"+jtf17.getText().trim()+"','"+jtf18.getText().trim()+"','"+jtf19.getText().trim()+"','"+jtf20.getText().trim()+"','"+jtf21.getText().trim()+"')");
JOptionPane.showMessageDialog(null, "超期罚款及图书赔偿金额已交付，您可以挂失此书!", "友情提示",
JOptionPane.WARNING_MESSAGE);
btn6.setEnabled(true);btn5.setEnabled(false);
try{ zheng();}
catch(SQLException ed){System.err.println(ed);}
}
}
con.close();
}
}
//设置读者的已借数量///////////////////////////////////////////////////////////////////////////////////////////
public void Borrowed() throws SQLException
{ String chaoqi="借书超期";
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 读者资料");
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("备注");
borrowed=rs.getString("已借数量");i=Integer.parseInt(borrowed)-1;
stmt.executeUpdate("update 读者资料 set 已借数量='"+i+"'where 读者编号='"+jtf5.getText().trim()+"'");
}
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 zheng() 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("借书超期"))
{JOptionPane.showMessageDialog(null,"该读者所借图书已超期，请归还该超期图书后再挂失此图书!","友情提示",
JOptionPane.WARNING_MESSAGE);
try{ Query2();}
catch(SQLException ed){System.err.println(ed);}
try{ Query();}
catch(SQLException ed){System.err.println(ed);}
}
else if(dzzt.equals(guashi))
{JOptionPane.showMessageDialog(null, "该读者已挂失，请办理新证后再挂失此图书!", "友情提示",
JOptionPane.WARNING_MESSAGE);
try{ Query2();}
catch(SQLException ed){System.err.println(ed);}
try{ Query();}
catch(SQLException ed){System.err.println(ed);}
}
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);}
try{ Query3();}
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{ view1();}
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);}
try{ Query3();}
catch(SQLException ed){System.err.println(ed);}
lb3.setText("该读者总共可借"+kjsl+"本,最长期限为"+zcqx+"天,现已借"+String.valueOf(readerc+readerc1)+"本!");
lb3.setToolTipText("该读者总共可借"+kjsl+"本,最长期限为"+zcqx+"天,现已借"+String.valueOf(readerc+readerc1)+"本!");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -