1、6)能够通过读者基本信息(包括:证号、姓名、性别、系名、年级)单个或以AND方式组合多个条件查询读者信息7)对于每位读者除可查看其基本信息之外,还可查看其已借的书籍列表、数量、借还日期8)可增添新的读者9)可删除已有读者(如该读者有尚未归还的借书,则不允许删除)10)可修改读者的基本信息11)可完成借还书籍的手续12)还书时如超期,应该显示超期天数13)借书时如果有超期的书没有还,则不允许借书14)可查询有哪些读者有超期的书没有还,列出这些读者的基本信息三、实验的环境:1、硬件环境:CPU: Intel(R) Core i5-3230 RAM: 8GB2、软件环境:操作系统:Windows 7
2、 Ultimate SP1 编译软件:Eclipse Luna Microsoft SQL Server 2014四、系统ER图五、表结构定义(使用表格说明)六、系统功能模块1)能够通过书籍基本信息单个或组合多个条件查询书籍信息;6)能够通过读者基本信息单个或组合多个条件查询读者信息七、程序框架流程图九、程序运行结果八、核心代码import .*;public class AddBook extends JFrame implements ActionListener SQLOperation op = new SQLOperation(); Container c = getContentP
3、ane(); JPanel p1 = new JPanel(); JLabel bookNumber = new JLabel(Book Number:); JLabel bookName = new JLabel(Book Name: JLabel bookAuthor = new JLabel(Book Author: JLabel press = new JLabel(Press: JLabel pressTime = new JLabel(Press time: JLabel bookAbstract = new JLabel(Abstract: JLabel storage = ne
4、w JLabel(Storage: JLabel remain = new JLabel(Remain JLabel remain1 = new JLabel(Update with Storage JTextField numberField = new JTextField(); JTextField nameField = new JTextField(); JTextField authorField = new JTextField(); JTextField pressField = new JTextField(); JTextField pressTimeField = new
5、 JTextField(); JTextField abstractField = new JTextField(); JTextField storageField = new JTextField(); JButton cancel = new JButton(Cancel JButton confirm = new JButton(Confirm! public AddBook() (p1, ; (new GridLayout(9, 2, 20, 10); (bookNumber); (numberField); (bookName); (nameField); (bookAuthor)
6、; (authorField); (press); (pressField); (pressTime); (pressTimeField); (bookAbstract); (abstractField); (storage); (storageField); (remain); (remain1); (cancel); (confirm); (this); public void actionPerformed(ActionEvent e) etText(), (); ArrayList strArray = new ArrayList(); strArray = (); int n = 0
7、; int replicate = 0; while (n (0) n+; if ().equals(n) replicate+; if (replicate = 0) (book); (null, Add a book successfully!, Information, ; else (null,This book(number) has already existed!, Warning ; public class AddReader extends JFrame implements ActionListener JLabel readerNumber = new JLabel(R
8、eader Number: JLabel readerName = new JLabel(Reader Name: JLabel sex = new JLabel(Sex: JLabel dpt = new JLabel(Department: JLabel grade = new JLabel(Grade: JTextField sexField = new JTextField(); JTextField dptField = new JTextField(); JTextField gradeField = new JTextField(); public AddReader() (ne
9、w GridLayout(6, 2, 20, 10); (readerNumber); (readerName); (sex); (sexField); (dpt); (dptField); (grade); (gradeField); quals(n) if (!().equals(boy) & !girl) JOptionPane .showMessageDialog( null, In the Sex field, you can only input boy or girl! else (reader); (null, Add a reader successfully! ;This
10、reader(number) has already existed!import class BookDetails extends JFrame implements ActionListener JPanel p2 = new JPanel(); JPanel p3 = new JPanel(); JLabel author = new JLabel(Author:Remain: JLabel numberField = new JLabel(); JLabel nameField = new JLabel(); JLabel authorField = new JLabel(); JL
11、abel pressField = new JLabel(); JLabel pressTimeField = new JLabel(); JLabel abstractField = new JLabel(); JLabel storageField = new JLabel(); JLabel remainField = new JLabel(); JLabel details = new JLabel(Borrow and reaturn details Object s = Reader numberBorrow timeDeadlineOver time ; Object ob1 =
12、 new Object74; JTable table = new JTable(ob1, s); JScrollPane scrollPane = new JScrollPane(table); public BookDetails(String number) BookInfo book = new BookInfo(number); ob1 = (number); for (int i = 0; i 5; i+) DefaultTableModel books = new DefaultTableModel(ob1, s); for (int n = 0; n 7; n+) for (i
13、nt m = 0; m 4; m+) ob1nm = nm; (books); (); ArrayList strArray = (book); (number); (1); (2); (3); (4); (5); (6); (7); (p2, ; (p3, ; (author); (remainField); (details); (0, 0, 800, 300); (scrollPane); (new Dimension(400, 100); ;import BookRetrieval extends JFrame implements ActionListener JPanel p4 =
14、 new JPanel(); JPanel p5 = new JPanel(); JTextField number = new JTextField(); JTextField name = new JTextField(); JButton back = new JButton(Back (Fresh) JButton addBook = new JButton(Add a book JButton deleteBook = new JButton(Delete a book JButton editBook = new JButton(Edit a book JButton search
15、 = new JButton(Search for details! JButton borrowBook = new JButton(Borrow a book JButton returnBook = new JButton(Return a book Font font1 = new Font(00, , 20);NumberNameAuthorPressPress Time AbstractStorage Object ob = new Object408; JTable table = new JTable(ob, s); public BookRetrieval() BookInf
16、o book = new BookInfo(); ob = (book); DefaultTableModel books = new DefaultTableModel(ob, s); 20; 8; obnm = nm; (p4, ; (p5, ; (font1); (new GridLayout(2, 4, 20, 10); (back); (addBook); (editBook); (deleteBook); (borrowBook); (returnBook); (null); (new GridLayout(5, 1, 0, 0); (name); (search); (new D
17、imension(400, 300); if () = search) String s1 = (); String s2 = (); if (n) strArray1 = new ArrayList strArray1 = (); int n1 = 0; int replicate1 = 0; while (n1 n1+; if (n1) replicate1+; if (replicate = 0 & replicate1 = 0) Please input a correct book number or name! else if (replicate != 0 | replicate1 != 0) if (replicate = 0 & replicate1 ! BookInfo book = new BookInfo(s1, s2); String s = (book); BookDetails f = new BookDetails(s); ;public class BorrowBook extends JFrame implements ActionListener JLabel readerNumber = new JLab
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1