import?java.awt.*;
import?java.awt.event.*;
import?java.awt.Container;
import?java.sql.*;
import?javax.swing.*;

public?class?BookBorrow?extends?Jframe?implements?ActionListener{

????private?JButton?ok?cancle;
????private?JTextField?book_num?user_name;
????JPanel?pn?pn_center?pn_south?pn_east;

????public?BookBorrow（）{
????????initComponents（）;//借書窗口
????}

????private?void?initComponents（）{//借書窗口
????????Container?cp?=?getContentPane（）;//用getContentPane（）方法獲得Jframe的內容面板
????????pn_center?=?new?JPanel（new?GridLayout（8?2））;
????????pn_south?=?new?JPanel（）;
????????pn_east?=?new?JPanel（）;
????????book_num?=?new?JTextField（18）;
????????user_name?=?new?JTextField（18）;
????????ok?=?new?JButton（“確定“）;
????????cancle?=?new?JButton（“取消“）;

????????cp.add（pn_center?“Center“）;
????????cp.add（pn_south?“South“）;
????????cp.add（pn_east?“East“）;
????????pn_center.add（new?JLabel（““））;
????????pn_center.add（new?JLabel（““））;
????????pn_center.add（new?JLabel（““））;
????????pn_center.add（new?JLabel（““））;
????????pn_center.add（new?JLabel（“???????圖書號“））;
????????pn_center.add（book_num）;
????????pn_center.add（new?JLabel（““））;
????????pn_center.add（new?JLabel（““））;
????????pn_center.add（new?JLabel（““））;
????????pn_center.add（new?JLabel（““））;
????????pn_center.add（new?JLabel（“???????用戶名“））;
????????pn_center.add（user_name）;
????????pn_center.add（new?JLabel（““））;
????????pn_center.add（new?JLabel（““））;
????????pn_center.add（new?JLabel（““））;
????????pn_center.add（new?JLabel（““））;
????????pn_south.add（ok）;
????????pn_south.add（cancle）;

??????
????????setDefaultCloseOperation（Jframe.DISPOSE_ON_CLOSE）;
????????settitle（“借書“）;
????????setSize（230?250）;
????????Toolkit?tkt?=?Toolkit.getDefaultToolkit（）;//獲取默認工具包
????????Dimension?screen?=?tkt.getScreenSize（）;//獲取屏幕尺寸對象

????????int?x?=?screen.width;
????????int?y?=?screen.height;
????????int?xcenter?=?（x?-?300）?/?2;
????????int?ycenter?=?（y?-?200）?/?2;
????????setLocation（xcenter?ycenter）;
????????setResizable（false）;//窗口大小不可改變

????????ok.addActionListener（this）;
????????cancle.addActionListener（this）;
????}

???//輸入圖書號和用戶
????public?void?actionPerformed（ActionEvent?e）{
????????object?source?=?e.getSource（）;//獲取事件源，e是事件
????????if（source?==?ok）{
????????????if（book_num.getText（）.equals（““）?||?user_name.getText（）.equals（““））{
????????????????JOptionPane.showMessageDialog（null?“請輸入圖書號和用戶ID！“）;
????????????????return;
????????????}
????????????else{
????????????????bookBorrow（）;//??public?BookBorrow（）
????????????}
????????}
????????if（source?==?cancle）{?????????
????????????dispose（）;//?關閉這個窗口
????????}

????}

????private?void?bookBorrow（）{
????	//查用戶名
????????String?sql1?=?“select?*?from?reader?where?readerID=‘“?+?user_name.
????????????????getText（）?+?“‘;“;
????????//查圖書號
????????String?sql2?=?“select?*?from?book?where?bookNum=‘“?+?book_num.getText（）
????????????????+?“‘;“;
????????//修改是否借閱
????????String?sql3?=?“update?book?set?borrower=‘“?+?user_name.getText（）
????????????????+?“‘?where?bookNum=‘“?+?book_num.ge

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-12-24?16:02??新建文件夾\a\
?????文件?????????401??2018-09-29?09:26??新建文件夾\a\.classpath
?????文件?????????377??2018-09-28?22:19??新建文件夾\a\.project
?????目錄???????????0??2018-12-24?16:02??新建文件夾\a\.settings\
?????文件??????????57??2018-09-28?22:20??新建文件夾\a\.settings\org.eclipse.core.resources.prefs
?????文件?????????598??2018-09-28?22:19??新建文件夾\a\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2018-12-24?16:02??新建文件夾\a\bin\
?????文件????????5033??2018-10-08?20:44??新建文件夾\a\bin\BookBorrow.class
?????文件????????6064??2018-10-08?20:44??新建文件夾\a\bin\BookIn.class
?????文件?????????697??2018-10-08?20:44??新建文件夾\a\bin\BookReturn$1.class
?????文件?????????697??2018-10-08?20:44??新建文件夾\a\bin\BookReturn$2.class
?????文件????????6550??2018-10-08?20:44??新建文件夾\a\bin\BookReturn.class
?????文件????????3335??2018-10-08?20:44??新建文件夾\a\bin\chaBook.class
?????文件????????5440??2018-10-08?20:44??新建文件夾\a\bin\ChangePasswd.class
?????文件????????1916??2018-10-08?20:44??新建文件夾\a\bin\Database.class
?????文件????????2707??2018-10-08?20:44??新建文件夾\a\bin\DelBook.class
?????文件????????6840??2018-10-08?20:44??新建文件夾\a\bin\gaiBook.class
?????文件?????????591??2018-10-08?20:44??新建文件夾\a\bin\Login$1.class
?????文件????????5383??2018-10-08?20:44??新建文件夾\a\bin\Login.class
?????文件?????????887??2018-10-08?20:44??新建文件夾\a\bin\MainWin$1$1.class
?????文件?????????700??2018-10-08?20:44??新建文件夾\a\bin\MainWin$1$2.class
?????文件????????1744??2018-10-08?20:44??新建文件夾\a\bin\MainWin$1.class
?????文件????????8573??2018-10-08?20:44??新建文件夾\a\bin\MainWin.class
?????文件????????3377??2018-10-08?20:44??新建文件夾\a\bin\ShowBook.class
?????文件?????????608??2018-10-08?20:44??新建文件夾\a\bin\UserAdd$1.class
?????文件????????6465??2018-10-08?20:44??新建文件夾\a\bin\UserAdd.class
?????目錄???????????0??2018-12-24?16:02??新建文件夾\a\src\
?????文件????????4673??2018-10-06?20:23??新建文件夾\a\src\BookBorrow.java
?????文件????????5939??2018-10-06?20:21??新建文件夾\a\src\BookIn.java
?????文件????????6062??2018-10-06?20:21??新建文件夾\a\src\BookReturn.java
?????文件????????2522??2018-10-06?20:21??新建文件夾\a\src\chaBook.java
............此處省略10個文件信息