📄 borrowbook.java
字号:
jtf8.setText(yxzj);jtf9.setText(zjhm);jtf10.setText(lxdh);jtf11.setText(lxdz);jtf12.setText(zcrq);
try{ setnull1();}
catch(SQLException ed){System.err.println(ed);}
try{ Query2();}
catch(SQLException ed){System.err.println(ed);}
try{ setnull();}
catch(SQLException ed){System.err.println(ed);}
try{ view();}
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)+"本!");
}
}
}
con.close();
}
//设置读者已借数量代码///////////////////////////////////////////////////////////////////////////////////////////
public void Query4() throws SQLException
{ bc1="";
int bcc=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("已借数量");
bcc=Integer.parseInt(jycs);
bcc++;
bc1=String.valueOf(bcc);
stmt.executeUpdate("update 读者资料 set 借阅次数='"+bc1+"',已借数量='"+readerc+"'where 读者编号='"+jtf5.getText().trim()+"'");
}
}
//查询借书统计代码////////////////////////////////////////////////////////////////////////////////////////
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 Query3() 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 借书统计 where 读者编号='"+jtf5.getText().trim()+"'");
if(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(czy.equals("是"))
{JOptionPane.showMessageDialog(null, "您所借图书有超期的，请您归还该图书后再借!", "友情提示",
JOptionPane.WARNING_MESSAGE);
}
else if(czy.equals("否"))
{btn2.setEnabled(true);
btn5.setEnabled(true);
btn6.setEnabled(true);
jtf13.setEnabled(true);
jtf14.setEnabled(true);
jtf17.setEnabled(true);
jtf16.setEnabled(true);
jtf18.setEnabled(true);
}
}
else
{btn2.setEnabled(true);
btn5.setEnabled(true);
btn6.setEnabled(true);
jtf13.setEnabled(true);
jtf14.setEnabled(true);
jtf17.setEnabled(true);
jtf16.setEnabled(true);
jtf18.setEnabled(true);
}
con.close();
}
//借书代码/////////////////////////////////////////////////////////////////////
public void Borrow() 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();
if(code.equals("")||name.equals("")||tiaoma.equals(""))
{JOptionPane.showMessageDialog(null, "您没有选择所要借的图书，请您先选择！", "友情提示",
JOptionPane.WARNING_MESSAGE);
}
else if(jtf16.getText().trim().equals("")||jtf17.getText().trim().equals("")||jtf18.getText().trim().equals(""))
{JOptionPane.showMessageDialog(null, "借阅时间、应还时间和操作员不能为空！", "友情提示",
JOptionPane.WARNING_MESSAGE);
}
else if(String.valueOf(readerc).equals(jtf7.getText().trim()))
{JOptionPane.showMessageDialog(null, "您的借阅数量已满，请您还书后再借!", "友情提示",
JOptionPane.WARNING_MESSAGE);
jtf1.setText("");jtf2.setText("");jtf3.setText("");jtf4.setText("");jtf5.setText("");jtf6.setText("");
jtf7.setText("");jtf8.setText("");jtf9.setText("");jtf10.setText("");jtf11.setText("");
jtf12.setText("");jtf16.setText("");jtf17.setText("");jtf18.setText("");btn6.setEnabled(false);
}
else if(!bookstatus.equals("在架"))
{JOptionPane.showMessageDialog(null, "此图书已被借出或已挂失,请您重新选择!", "友情提示",
JOptionPane.WARNING_MESSAGE);
}
else if(bookstatus.equals("在架"))
{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("操作员");jycs=rs.getString("续借");czy=rs.getString("是否超期");czy="无";bz="否";
int n=JOptionPane.showConfirmDialog(this,"您确定要借这本书吗?\n"+"图书编号为:"+code+",条形码为:"+tiaoma+",名称为:"+name,"确认对话框",JOptionPane.YES_NO_OPTION);
if(n==JOptionPane.YES_OPTION)
{stmt.executeUpdate("INSERT INTO 借书统计(读者姓名,读者编号,读者条形码,图书名称,图书编号,图书条形码,借阅数量,图书价格,出版社,存放位置,图书类型,借书日期,应还日期,操作员,续借,是否超期) values ('"+jtf2.getText().trim()+"','"+jtf5.getText().trim()+"','"+jtf6.getText().trim()+"','"+name+"','"+code+"','"+tiaoma+"','"+jtf15.getText().trim()+"','"+bookprice+"','"+bookpress+"','"+bookstock+"','"+bookfenlei+"','"+jtf16.getText().trim()+"','"+jtf17.getText().trim()+"','"+jtf18.getText().trim()+"','"+czy+"','"+bz+"')");
JOptionPane.showMessageDialog(null, "办理借书完毕，请您在"+jtf17.getText().trim()+"之前归还，否则超期自负！", "友情提示",
JOptionPane.WARNING_MESSAGE);
try{ UpdateBS();}
catch(SQLException ed){System.err.println(ed);}
try{ setnull();}
catch(SQLException ed){System.err.println(ed);}
try{ view();}
catch(SQLException ed){System.err.println(ed);}
try{ setnull1();}
catch(SQLException ed){System.err.println(ed);}
try{ Query1();}
catch(SQLException ed){System.err.println(ed);}
try{ Query2();}
catch(SQLException ed){System.err.println(ed);}
try{ Query4();}
catch(SQLException ed){System.err.println(ed);}
jtf13.setText("");
int m=JOptionPane.showConfirmDialog(this,"继续为该读者办理借书吗?","确认对话框",JOptionPane.YES_NO_OPTION);
if(m==JOptionPane.NO_OPTION)
{jtf1.setText("");jtf2.setText("");jtf3.setText("");jtf4.setText("");jtf5.setText("");jtf6.setText("");
jtf7.setText("");jtf8.setText("");jtf9.setText("");jtf10.setText("");jtf11.setText("");
jtf12.setText("");jtf13.setText("");jtf16.setText("");jtf17.setText("");jtf18.setText("");btn6.setEnabled(false);
jtf17.setEnabled(false);jtf16.setEnabled(false);jtf18.setEnabled(false);btn2.setEnabled(false);btn5.setEnabled(false);
jtf13.setEnabled(false);jtf14.setEnabled(false);lb3=new JLabel(" ",JLabel.CENTER);
try{ setnull();}
catch(SQLException ed){System.err.println(ed);}
try{ setnull1();}
catch(SQLException ed){System.err.println(ed);}
}
else if(m==JOptionPane.YES_OPTION)
{}
}
else if(n==JOptionPane.NO_OPTION)
{ jtf13.setText("");jtf16.setText("");jtf17.setText("");jtf18.setText("");
lb3=new JLabel(" ",JLabel.CENTER);
try{ setnull();}
catch(SQLException ed){System.err.println(ed);}
}
}
con.close();
}
}
///////更新图书状态代码///////////////////////////////////////////////////////////////////////////////
public void UpdateBS() throws SQLException
{ String bs="已借出";
bc="";
int bcc=0;
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())
{tsmc=rs.getString("图书名称");bh=rs.getString("编号");txm=rs.getString("条形码");
flf=rs.getString("分类法");zz=rs.getString("作者");lx=rs.getString("类型");
jg=String.valueOf(rs.getInt("价格"));cbs=rs.getString("出版社");ym=rs.getString("页码");
sjmc=rs.getString("书架名称");cbrq=rs.getString("出版日期");rkrq=rs.getString("入库日期");
kcl=String.valueOf(rs.getInt("库存量"));jycs=String.valueOf(rs.getInt("借阅次数"));tszt=rs.getString("图书状态");
czy=rs.getString("操作员");zy=rs.getString("摘要");
bcc=Integer.parseInt(jycs);
bcc++;
bc=String.valueOf(bcc);
stmt.executeUpdate("update 图书资料 set 图书状态='"+bs+"',借阅次数='"+bc+"'where 编号='"+code+"'");
}
con.close();
}
/////////////////////设置借书统计表格为空///////////////////////////////////////////////////////////////////
public void setnull() throws SQLException
{int i=0;
try{
String strurl =
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con= DriverManager.getConnection(strurl);
stmt = con.createStatement();
ResultSet rs=stmt.executeQuery("SELECT * From 借书统计 ");
while(rs.next())
{
rowData1[i][0]=null;rowData1[i][1]=null;rowData1[i][2]=null;
rowData1[i][3]=null;rowData1[i][4]=null;rowData1[i][5]=null;
rowData1[i][6]=null;rowData1[i][7]=null;rowData1[i][8]=null;
rowData1[i][9]=null;rowData1[i][10]=null;rowData1[i][11]=null;
rowData1[i][12]=null;rowData1[i][13]=null;rowData1[i][14]=null;rowData1[i][15]=null;
i++;
validate();
}
rowData1[i][0]=null;rowData1[i][1]=null;rowData1[i][2]=null;
rowData1[i][3]=null;rowData1[i][4]=null;rowData1[i][5]=null;
rowData1[i][6]=null;rowData1[i][7]=null;rowData1[i][8]=null;
rowData1[i][9]=null;rowData1[i][10]=null;rowData1[i][11]=null;
rowData1[i][12]=null;rowData1[i][13]=null;rowData1[i][14]=null;rowData1[i][15]=null;
jta1.repaint();
}
catch(Exception g)
{g.printStackTrace();}
}
/////////////////////表格显示数据库中数据代码///////////////////////////////////////////////////////////////////
public void view() throws SQLException
{int i=0;
try{ 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=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("操作员");jycs=rs.getString("续借");czy=rs.getString("是否超期");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -