?? 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 + -