📄 rborrowbook.java
字号:
}
//续借代码/////////////////////////////////////////////////////////////////////
public void Borrow() throws SQLException
{
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();
if(code.equals("")||name.equals("")||tiaoma.equals("")||jtf16.getText().trim().equals(""))
{JOptionPane.showMessageDialog(null, "您没有选择所要续借的图书，请您先选择！", "友情提示",
JOptionPane.WARNING_MESSAGE);
}
else if(jtf15.getText().trim().equals("")||jtf17.getText().trim().equals("")||jtf18.getText().trim().equals("")||jtf19.getText().trim().equals(""))
{JOptionPane.showMessageDialog(null, "续借数量、本次续借时间、下次应还时间和操作员不能为空！", "友情提示",
JOptionPane.WARNING_MESSAGE);
}
else
{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("是否超期");
if(bookstatus.equals("已续借"))
{
int n=JOptionPane.showConfirmDialog(this,"此书已被该读者续借，是否继续?\n"+"图书编号为:"+code+",条形码为:"+tiaoma+",名称为:"+name,"确认对话框",JOptionPane.YES_NO_OPTION);
if(n==JOptionPane.YES_OPTION)
{
try{ Query3();}
catch(SQLException ed){System.err.println(ed);}
stmt.executeUpdate("update 续借统计 set 上次借阅时间='"+jtf16.getText().trim()+"',本次续借时间='"+jtf17.getText().trim()+"',下次归还时间='"+jtf18.getText().trim()+"',操作员='"+jtf19.getText().trim()+"'where 图书编号='"+code+"'");
JOptionPane.showMessageDialog(null, "办理续借完毕，请您在"+jtf18.getText().trim()+"之前归还，否则超期自负！", "友情提示",
JOptionPane.WARNING_MESSAGE);
lb17.setText("上次借阅时间:");
try{ setnull();}
catch(SQLException ed){System.err.println(ed);}
try{ view1();}
catch(SQLException ed){System.err.println(ed);}
try{ UpdateBS();}
catch(SQLException ed){System.err.println(ed);}
try{ Xujie();}
catch(SQLException ed){System.err.println(ed);}
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("");jtf16.setText("");jtf17.setText("");jtf18.setText("");jtf19.setText("");btn6.setEnabled(false);
jtf17.setEnabled(false);jtf18.setEnabled(false);jtf19.setEnabled(false);
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)
{jtf16.setText("");jtf17.setText("");jtf18.setText("");jtf19.setText("");}
}
else
{int k=JOptionPane.showConfirmDialog(this,"确定为该读者续借此书吗?\n"+"图书编号为:"+code+",条形码为:"+tiaoma+",名称为:"+name,"确认对话框",JOptionPane.YES_NO_OPTION);
if(k==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()+"','"+jtf19.getText().trim()+"')");
JOptionPane.showMessageDialog(null, "办理续借完毕，请您在"+jtf18.getText().trim()+"之前归还，否则超期自负！", "友情提示",
JOptionPane.WARNING_MESSAGE);
try{ UpdateBS();}
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);}
try{ Xujie();}
catch(SQLException ed){System.err.println(ed);}
int l=JOptionPane.showConfirmDialog(this,"继续为该读者办理续借图书吗?","确认对话框",JOptionPane.YES_NO_OPTION);
if(l==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("");jtf16.setText("");jtf17.setText("");jtf18.setText("");jtf19.setText("");btn6.setEnabled(false);
jtf17.setEnabled(false);jtf18.setEnabled(false);jtf19.setEnabled(false);
try{ setnull();}
catch(SQLException ed){System.err.println(ed);}
try{ setnull1();}
catch(SQLException ed){System.err.println(ed);}
}
else if(l==JOptionPane.YES_OPTION)
{}
}
else if(k==JOptionPane.NO_OPTION)
{}
}
}
con.close();
}
}
///////更新图书状态代码///////////////////////////////////////////////////////////////////////////////
public void UpdateBS() throws SQLException
{ String bs="已续借";
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=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("是否超期");
stmt.executeUpdate("update 借书统计 set 续借='"+bs+"'where 图书编号='"+code+"'");
}
}
/////////////////////设置借阅统计表格为空///////////////////////////////////////////////////////////////////
public void setnull1() 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())
{
rowData[i][0]=null;rowData[i][1]=null;rowData[i][2]=null;
rowData[i][3]=null;rowData[i][4]=null;rowData[i][5]=null;
rowData[i][6]=null;rowData[i][7]=null;rowData[i][8]=null;
rowData[i][9]=null;rowData[i][10]=null;rowData[i][11]=null;
rowData[i][12]=null;rowData[i][13]=null;rowData[i][14]=null;rowData[i][15]=null;
i++;
validate();
}
rowData[i][0]=null;rowData[i][1]=null;rowData[i][2]=null;
rowData[i][3]=null;rowData[i][4]=null;rowData[i][5]=null;
rowData[i][6]=null;rowData[i][7]=null;rowData[i][8]=null;
rowData[i][9]=null;rowData[i][10]=null;rowData[i][11]=null;
rowData[i][12]=null;rowData[i][13]=null;rowData[i][14]=null;rowData[i][15]=null;
jta.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("是否超期");
rowData[i][0]=dzxm;rowData[i][1]=dzbh;rowData[i][2]=txm;rowData[i][3]=xb;rowData[i][4]=sf;
rowData[i][5]=yxzj;rowData[i][6]=zjhm;rowData[i][7]=zcrq;rowData[i][8]=zxrq;rowData[i][9]=csrq;
rowData[i][10]=lxdh;rowData[i][11]=lxdz;rowData[i][12]=dzzt;rowData[i][13]=zcqx;
rowData[i][14]=jycs;rowData[i][15]=czy;
i++;
}
jta.repaint();
con.close();
}
catch(Exception es)
{es.printStackTrace();}
}
/////////////////////设置续借表格为空///////////////////////////////////////////////////////////////////
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;rowData1[i][16]=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;rowData1[i][16]=null;
jta1.repaint();
}
catch(Exception g)
{g.printStackTrace();}
}
/////////////////////表格显示数据库续借统计中数据代码///////////////////////////////////////////////////////////////////
public void view1() 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,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++;
}
jta1.repaint();
con.close();
}
catch(Exception es)
{es.printStackTrace();}
}
/////////////////////////////////////////////////////////////////////////////////////////////////
public static void main(String[]args)
{ try {
UIManager.setLookAndFeel("com.sun.java.swing.plaf.windows.WindowsLookAndFeel");
}
catch(Exception e) {
e.printStackTrace();
}
new RBorrowBook();
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -