資源簡介
該系統采用SQL server 2008R2 與eclipse開發的圖書管理系統，實現了圖書管理系統的基本功能。
代碼片段和文件信息
package?bookManage;
import?java.awt.BorderLayout;
import?java.awt.Color;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.text.SimpleDateFormat;
import?java.util.Date;
import?javax.swing.JButton;
import?javax.swing.JComboBox;
import?javax.swing.JLabel;
import?javax.swing.JOptionPane;
import?javax.swing.JPanel;
import?javax.swing.JTextField;
public?class?AddBook?extends?JPanel{
String?url=“jdbc:sqlserver://localhost:1433;DatabaseName=Book_Manage“;
String?user=“admin“;
String?password=“123456“;?
JLabel?addlabel;
JLabel?booknum;
JLabel?bookname;
JLabel?choosebooksort;
JLabel?bookpublishname;
JLabel?writername;
JLabel?publishtime;
JLabel?bookvalue;
JLabel?incometime;
JLabel?incomenum;
JLabel?havenum;
JLabel?floor;
JLabel?isBorrow;
JLabel?tip1;
JLabel?tip2;
JButton?addbtn;
JButton?resetbtn;
JTextField?booknumtxt;
JTextField?booknametxt;
JComboBox?booksort;
JTextField?bookpublishnametxt;
JTextField?writernametxt;
JTextField?publishtimetxt;
JTextField?bookvaluetxt;
JTextField?incometimetxt;
JTextField?incomenumtxt;
JTextField?havenumtxt;
JTextField?floorTxt;
JComboBox?isBorrowTxt;
JPanel?p1;
JPanel?p2;
JPanel?p3;
public?AddBook（）?{
?p1=new?JPanel（）;
?p2=new?JPanel（）;
?p3=new?JPanel（）;
?addlabel=new?JLabel（“添加圖書“）;
?addlabel.setForeground（Color.white）;
?p1.add（addlabel）;
?p1.setBackground（Color.gray）;
?booksort=new?JComboBox（）;
?try?{
Connection??conn=DriverManager.getConnection（urluserpassword）;
????String?sqlStr=“select?*?from?BookCatagory“;
????Statement?st=conn.createStatement（）;
ResultSet?rs=st.executeQuery（sqlStr）;
while（rs.next（））?{
booksort.addItem（rs.getInt（“id“）+“?“+rs.getString（“name“））;
}
conn.close（）;
}?catch?（SQLException?e1）?{
//?TODO?自動生成的?catch?塊
e1.printStackTrace（）;
}
?//booksort.addItem（“IT“）;
?//booksort.addItem（“Math“）;
booknum=new?JLabel（“請輸入圖書ISBN：“）;
bookname=new?JLabel（“請輸入圖書名稱：“）;
choosebooksort=new?JLabel（“請選擇所屬類別：“）;
bookpublishname=new?JLabel（“請輸入出版社名稱：“）;
writername=new?JLabel（“請輸入作者：“）;
publishtime=new?JLabel（“請輸入出版日期：“）;
bookvalue=new?JLabel（“請輸入圖書定價：“）;
incometime=new?JLabel（“請輸入入庫時間：“）;
incomenum=new?JLabel（“請輸入入庫數量：“）;
havenum=new?JLabel（“請輸入在庫數量：“）;
floor=new?JLabel（“所在樓層“）;
isBorrow=new?JLabel（“是否可以外借“）;
tip1=new?JLabel（“如2012-03-20“）;
tip2=new?JLabel（“如2012-03-01“）;
booknumtxt=new?JTextField（）;
booknametxt=new?JTextField（）;
bookpublishnametxt=new?JTextField（）;
writernametxt=new?JTextField（）;
publishtimetxt=new?JTextField（）;
bookvaluetxt=new?JTextField（）;
incometimetxt=new?JTextField（）;
incomenumtxt=new?JTextField（）;
havenumtxt=new?JTextField（）;
floorTxt=new?JTextField（）;
isBorrowTxt=new?JComboBox（）;
isBorrowTxt.addIte ?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????390??2018-12-13?21:39??課程設計代碼（book_manage為數據庫文件）\BookManage\.classpath
?????文件????????386??2018-11-14?20:53??課程設計代碼（book_manage為數據庫文件）\BookManage\.project
?????文件????????598??2018-11-14?20:53??課程設計代碼（book_manage為數據庫文件）\BookManage\.settings\org.eclipse.jdt.core.prefs
?????文件???????8338??2018-12-22?18:12??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\AddBook.class
?????文件???????5014??2018-12-22?18:12??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\AddBookCatagory.class
?????文件???????5522??2018-12-25?20:45??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\AddBookLevel.class
?????文件???????5763??2018-12-22?18:12??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\AddBorrowCard.class
?????文件???????8956??2018-12-22?18:12??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\AddReaderInfo.class
?????文件???????4474??2018-12-22?18:12??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\AlterPassword.class
?????文件???????4153??2018-12-22?18:12??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\BookCellEditor.class
?????文件???????2684??2018-12-22?18:12??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\BooksList$1.class
?????文件???????3254??2018-12-22?18:12??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\BooksList.class
?????文件???????6796??2018-12-25?22:56??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\BorrowBook.class
?????文件???????4161??2018-12-22?18:12??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\BorrowCardCellEditor.class
?????文件???????6093??2018-12-22?18:12??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\BorrowCardManage.class
?????文件???????5934??2018-12-22?18:12??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\ChangeUserPassword.class
?????文件???????4842??2018-12-22?18:12??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\CheckTicket.class
?????文件???????3729??2018-12-22?18:12??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\DelBookCatagory$DelBookCataCellEditor.class
?????文件???????5551??2018-12-22?18:12??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\DelBookCatagory.class
?????文件???????3693??2018-12-24?21:58??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\DelBookLevel$DelBookLevelEditor.class
?????文件???????5672??2018-12-24?21:58??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\DelBookLevel.class
?????文件???????1204??2018-12-22?18:12??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\ExtendedTableModel.class
?????文件???????1690??2018-12-22?18:12??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\ExtensionFileFilter.class
?????文件???????1158??2018-12-22?18:12??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\FileIconView.class
?????文件????????803??2018-12-22?18:12??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\Login$1.class
?????文件????????804??2018-12-22?18:12??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\Login$2.class
?????文件????????803??2018-12-22?18:12??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\Login$3.class
?????文件????????664??2018-12-22?18:12??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\Login$4.class
?????文件???????4550??2018-12-22?18:12??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\Login$5.class
?????文件???????5721??2018-12-22?18:12??課程設計代碼（book_manage為數據庫文件）\BookManage\bin\bookManage\Login.class
............此處省略105個文件信息
評論
共有 條評論
川公網安備 51152502000135號