【文章內(nèi)容簡(jiǎn)介】 )。(”“)。return。} sqlStr1=”select * from borrow where user_cardnumber=“+ ”39?！?str1+”39?！?。result=(sqlStr1)。int i=0。while(()){i=i+1。} if(i==4){ ()。(frame,”you can39。t borrow more than four books!“)。(”“)。return。} } }if(obj==jtfd3){ (formatted1)。str1=().trim()。if((”“)){ ()。(frame,”Text was null!“)。return。} sqlStr1=”select state from book where bannercode=“+”39?！?str1+”39。“。result=(sqlStr1)。if(!()){(true)。(frame,”invalid bannercode!“)。(”“)。return。} else {state=(”state“)。if((”離架“)){(true)。(frame,”this book has been lent!“)。(”“)。return。} } } }catch(SQLException sqle){(sqle)。} } public void focusLost(FocusEvent e){ try{str1=().trim()。sqlStr1=”selectsum_accountfrompunishment user_cardnumber=“+”39。“+str1+”39?！?。result=(sqlStr1)。if(()){BigDecimal money=(”sum_account“,2)。(”罰款:“+money)。}else{(”罰款:“)。}}catch(SQLException sqle){(sqle)。}}where} public void actionPerformed(ActionEvent e){String sqlStr1,sqlStr2,str1,str2,str3,str4。int result。str1=().trim()。str2=().trim()。str3=().trim()。str4=().trim()。 today1,today2。Object obj=(JButton)()。try{if(obj==btn1){if((”“)|(”“)|(”“)|(”“)){(frame,”The Text can39。t be null!“)。return。} sqlStr1=”updatebooksetstate=39。離架39。where bannercode=“+”39。“+str2+”39?！?。today1=(str3)。today2=(str4)。(1,str1)。(2,str2)。(3,today1)。(4,today2)。result=()。if(result0){(frame,”borrow successfully!“)。} result=(sqlStr1)。if(result0){(frame,”update successfully!“)。} (”“)。(”“)。(”“)。(”“)。} if(obj==btn3){sqlStr1=”delete from punishment where user_cardnumber=“+ ”39。“+str1+”39?！?。result=(sqlStr1)。if(result0){(frame,”pay successfully!“)。(”罰款:“)。} } if(obj==btn2){()。()。()。} }} catch(SQLException sqle){(sqle)。} } public static void main(String[]args){new Borrow()。} import .*。import .*。import .*。import .*。import .*。import .*。public class BorrowQuery implements ActionListener { private JFrame frame。private JButton btn1,btn2。private JTextField jtfd1,jtfd2。private JTable tableTest。private String[]columnNames={”借閱證號(hào)“,”圖書條碼“,”借書日期“,”應(yīng)還日期“}。private Object[][] rowData=new Object[4][4]。private Statement stmt。private Connection con。public BorrowQuery(){(new (true)。frame=new JFrame(”借閱查詢“)。Container content=()。(new BorderLayout())。JLabel lb1=new JLabel(”借閱證號(hào):“)。JLabel lb2=new JLabel(”姓名:“)。btn1=new JButton(”查詢“)。btn2=new JButton(”退出“)。(this)。(this)。jtfd1=new JTextField()。jtfd2=new JTextField()。JPanel pl=new JPanel()。(new GridLayout(2,3,10,10))。(lb1)。(jtfd1)。(btn1)。(lb2)。(jtfd2)。(btn2)。tableTest=new JTable(rowData,columnNames)。(30)。Dimension(500,60))。JScrollPane scrollPane=new JScrollPane(tableTest)。}(pl,)。(scrollPane,)。()。(true)。try {} catch(ClassNotFoundException e){ } catch(SQLException e){(e)。} (”“)。con=(”jdbc:odbc:library“)。stmt=()。public void actionPerformed(ActionEvent e){String sqlStr,cardnumber,user_name,str1,str2,bannercode。ResultSet result。 day1,day2。Object obj=(JButton)()。str1=().trim()。str2=().trim()。try {if(obj==btn1){if((”“)|(”“)){(frame,”Text can39。t be null!“)。return。}sqlStr=”select ,user_name,bannercode,borrowdate,receivedate“+ ”fromborrow,userwhere = and“+” =“+”39?！?str1+”39?！?。result=(sqlStr)。for(int j=0。jcardnumber=(”user_cardnumber“)。user_name=(”user_name“)。if((user_name)){day1=(”borrowdate“)。day2=(”receivedate“)。bannercode=(”bannercode“)。}rowData[i][0]=cardnumber。rowData[i][1]=bannercode。rowData[i][2]=day1。rowData[i][3]=day2。i++。} }(”“)。(”“)。} if(obj==btn2){()。()。()。} } catch(SQLException sqle){(sqle)。} } public static void main(String[]args){new BorrowQuery()。} import .*。import .*。import .*。import .*。import .*。public class CallUpReturn {private Vector columnField=new Vector()。private Vector column=new Vector()。private Vector rowData=new Vector()。private Connection con。private Statement stmt。private ResultSet result,result2,result3。private String sqlStr,cardnumber,bannercode,user_name,user_office, bookname,publisher。private day1,day2,today。private String[]columnNames={”借閱證“,”姓名“,”單位“,”圖書條碼“,”書名“,”作者“, ”借出時(shí)間“,”到期時(shí)間“}。public CallUpReturn(){JFrame frame=new JFrame(”催還通告“)。Container content=()。try {(”“)。con=(”jdbc:odbc:library“)。stmt=(, )。sqlStr=”select ,borrowdate,receivedate,“+ ”user_name,user_office,bookname,publishingpanyfrom borrow,book,user“+ ” where=and =“+result=(sqlStr)?！薄?。today=new ()。int i=0。while(()){()。day1=(”borrowdate“)。day2=(”receivedate“)。if((today)){cardnumber=(”user_cardnumber“)。bannercode=(”bannercode“)。user_name=(”user_name“)。user_office=(”user_office“)。bookname=(”bookname“)。publisher=(”publishingpany“)。}(cardnumber)。(user_name)。(user_office)。(bannercode)。(bookname)。(publisher)。(day1)。(day2)。(())。}(i)。}()。()。catch(ClassNotFoundException e){(e)。} catch(SQLException e){(())。(())。(())。(())。} }for(int i=0。iJTable tableTest=new JTable(rowData,column)。(30)。JScrollPane scrollPane=new JScrollPane(tableTest)。(new Dimension(500,80))。(scrollPane,)。()。(true)。} public static void main(String[]args){ } new CallUpReturn()。 import .*。import .*。import .*。import .*。import .*。import .*。import .*。public class CardManagement implements ActionListener { private JTextField jtfd1,jtfd2,jtfd3,jtfd4。private JButton btn1,btn2,btn3,btn4。private Statement stmt。private PreparedStatement pstmt。private Connection con。private JFrame frame。public CardManagement(){(true)。frame=new JFrame(”借閱證管理“)。Container content=()。JLabel lb1=new JLabel(”借閱證號(hào):“)。JLabel lb2=new JLabel(”按借閱證號(hào):“)。JLabel lb3=new JLabel(”按有效期:“)。JLabel lb4=new JLabel(”借閱證號(hào):“)。jtfd1=new JTextField()。jtfd2=new JTextField