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