📄 guashibook.java
字号:
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(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);}
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)+"本!");
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);}
}
}
}
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 Query3() throws SQLException
{ readerc1=0;
String dzxm,dzbh,txm,xb,sf,yxzj,zjhm,zcrq,zxrq,csrq,lxdh,lxdz,dzzt,kjsl,zcqx,jycs,czy,xjcs,sfcq;
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("操作员");xjcs=rs.getString("续借次数");
sfcq=rs.getString("是否超期");
readerc1++;
}
con.close();
}
///////在图书资料中标明此挂失图书代码///////////////////////////////////////////////////////////////////////////////
public void UpdateBS2() 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())
{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("摘要");
stmt.executeUpdate("update 图书资料 set 图书状态='"+bs+"'where 编号='"+code+"'");
}
}
///////从续借统计中删除此挂失图书代码///////////////////////////////////////////////////////////////////////////////
public void UpdateBS1() throws SQLException
{ String bs="已挂失";
String dzxm,dzbh,txm,xb,sf,yxzj,zjhm,zcrq,zxrq,csrq,lxdh,lxdz,dzzt,kjsl,zcqx,jycs,czy,xjcs,sfcq;
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("操作员");xjcs=rs.getString("续借次数");
sfcq=rs.getString("是否超期");
stmt.executeUpdate("delete from 续借统计 where 图书编号='"+code+"'");
}
}
///////从借书统计中删除此挂失图书代码///////////////////////////////////////////////////////////////////////////////
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("delete from 借书统计 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())
{
rowData2[i][0]=null;rowData2[i][1]=null;rowData2[i][2]=null;
rowData2[i][3]=null;rowData2[i][4]=null;rowData2[i][5]=null;
rowData2[i][6]=null;rowData2[i][7]=null;rowData2[i][8]=null;
rowData2[i][9]=null;rowData2[i][10]=null;rowData2[i][11]=null;
rowData2[i][12]=null;rowData2[i][13]=null;rowData2[i][14]=null;
rowData2[i][15]=null;rowData2[i][16]=null;
i++;
validate();
}
rowData2[i][0]=null;rowData2[i][1]=null;rowData2[i][2]=null;
rowData2[i][3]=null;rowData2[i][4]=null;rowData2[i][5]=null;
rowData2[i][6]=null;rowData2[i][7]=null;rowData2[i][8]=null;
rowData2[i][9]=null;rowData2[i][10]=null;rowData2[i][11]=null;
rowData2[i][12]=null;rowData2[i][13]=null;rowData2[i][14]=null;
rowData2[i][15]=null;rowData2[i][16]=null;
jta2.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,xjcs,sfcq;
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("操作员");xjcs=rs.getString("续借次数");
sfcq=rs.getString("是否超期");
rowData2[i][0]=dzxm;
rowData2[i][1]=dzbh;
rowData2[i][2]=txm;
rowData2[i][3]=xb;
rowData2[i][4]=sf;
rowData2[i][5]=yxzj;
rowData2[i][6]=zjhm;
rowData2[i][7]=zcrq;
rowData2[i][8]=zxrq;
rowData2[i][9]=csrq;
rowData2[i][10]=lxdh;
rowData2[i][11]=lxdz;
rowData2[i][12]=dzzt;
rowData2[i][13]=zcqx;
rowData2[i][14]=czy;
rowData2[i][15]=xjcs;
rowData2[i][16]=sfcq;
i++;
}
jta2.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 GuaShiBook();
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -