Java圖書(shū)館管理系統(tǒng)(附全代碼)-課程設(shè)計(jì)報(bào)告

1、數(shù)據(jù)庫(kù)系統(tǒng)概論課程報(bào)告課題名稱(chēng)： 小型圖書(shū)管理系統(tǒng)課題負(fù)責(zé)人名（學(xué)號(hào)）： best同組成員名單（角色）： 指導(dǎo)教師： 評(píng)閱成績(jī)： 評(píng)閱意見(jiàn)： 提交報(bào)告時(shí)間：2015年12月15日小型圖書(shū)管理系統(tǒng) 計(jì)算機(jī)科學(xué)與技術(shù) 專(zhuān)業(yè)學(xué)生 指導(dǎo)老師 摘要 隨著計(jì)算機(jī)技術(shù)的飛速發(fā)展，利用計(jì)算機(jī)來(lái)獲得和處理信息是當(dāng)今信息管理的一大特點(diǎn)。伴隨計(jì)算機(jī)硬件的快速發(fā)展，有關(guān)信息管理的軟件數(shù)據(jù)庫(kù)系統(tǒng)軟件也在迅猛發(fā)展著。圖書(shū)館是高等院校的重要組成部門(mén)，是教師和學(xué)生獲取知識(shí)的重要場(chǎng)所。由于圖書(shū)館主要從事大量的圖書(shū)資料的儲(chǔ)存和流通。所以一直以來(lái)，計(jì)算機(jī)在圖書(shū)館的圖書(shū)管理中得到了廣泛的應(yīng)用。本系統(tǒng)實(shí)現(xiàn)圖書(shū)信息管理的系統(tǒng)化，規(guī)范化和

2、自動(dòng)化，以最大程度提高操作人員的辦公效率。關(guān)鍵詞：JAVA、JDBC、SQL Server、數(shù)據(jù)庫(kù)、圖書(shū)館管理一、實(shí)驗(yàn)題目：小型圖書(shū)管理系統(tǒng)二、實(shí)驗(yàn)的目的和要求:完成一個(gè)小型圖書(shū)管理系統(tǒng)，功能要求如下：能夠通過(guò)書(shū)籍基本信息（包括：書(shū)號(hào)、書(shū)名、出版社、出版日期、作者、內(nèi)容摘要）單個(gè)或以AND方式組合多個(gè)條件查詢(xún)書(shū)籍信息；對(duì)于每一種書(shū)籍，除可查看其基本信息之外還可查看其總數(shù)以及目前在館數(shù)量可增添新的書(shū)籍可刪除已有書(shū)籍（如有讀者借了該書(shū)籍尚未歸還，則不允許刪除）可修改書(shū)籍的基本信息能夠通過(guò)讀者基本信息（包括：證號(hào)、姓名、性別、系名、年級(jí)）單個(gè)或以AND方式組合多個(gè)條件查詢(xún)讀者信息對(duì)于每位讀者除可查看

3、其基本信息之外，還可查看其已借的書(shū)籍列表、數(shù)量、借還日期可增添新的讀者可刪除已有讀者（如該讀者有尚未歸還的借書(shū)，則不允許刪除）可修改讀者的基本信息可完成借還書(shū)籍的手續(xù)還書(shū)時(shí)如超期，應(yīng)該顯示超期天數(shù)借書(shū)時(shí)如果有超期的書(shū)沒(méi)有還，則不允許借書(shū)可查詢(xún)有哪些讀者有超期的書(shū)沒(méi)有還，列出這些讀者的基本信息三、實(shí)驗(yàn)的環(huán)境：1、硬件環(huán)境：CPU: Intel(R) Core i5-3230 2.60GHz RAM: 8GB2、軟件環(huán)境：操作系統(tǒng)：Windows 7 Ultimate SP1 編譯軟件：Eclipse Luna Microsoft SQL Server 2014四、系統(tǒng)ER圖五、表結(jié)構(gòu)定義（使用表

4、格說(shuō)明）六、系統(tǒng)功能模塊能夠通過(guò)書(shū)籍基本信息單個(gè)或組合多個(gè)條件查詢(xún)書(shū)籍信息；對(duì)于每一種書(shū)籍，除可查看其基本信息之外還可查看其總數(shù)以及目前在館數(shù)量可增添新的書(shū)籍可刪除已有書(shū)籍（如有讀者借了該書(shū)籍尚未歸還，則不允許刪除）可修改書(shū)籍的基本信息能夠通過(guò)讀者基本信息單個(gè)或組合多個(gè)條件查詢(xún)讀者信息對(duì)于每位讀者除可查看其基本信息之外，還可查看其已借的書(shū)籍列表、數(shù)量、借還日期可增添新的讀者可刪除已有讀者（如該讀者有尚未歸還的借書(shū)，則不允許刪除）可修改讀者的基本信息可完成借還書(shū)籍的手續(xù)還書(shū)時(shí)如超期，應(yīng)該顯示超期天數(shù)借書(shū)時(shí)如果有超期的書(shū)沒(méi)有還，則不允許借書(shū)可查詢(xún)有哪些讀者有超期的書(shū)沒(méi)有還，列出這些讀者的基本信息七

5、、程序框架流程圖九、程序運(yùn)行結(jié)果八、核心代碼AddBook.javaimport java.awt.BorderLayout;import java.awt.Container;import java.awt.GridLayout;import java.awt.event.*;import java.util.ArrayList;import javax.swing.*;public class AddBook extends JFrame implements ActionListener SQLOperation op = new SQLOperation();Container c =

6、 getContentPane();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:);JLabe

7、l storage = new 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 pressTi

8、meField = new JTextField();JTextField abstractField = new JTextField();JTextField storageField = new JTextField();JButton cancel = new JButton(Cancel);JButton confirm = new JButton(Confirm!);public AddBook() c.add(p1, BorderLayout.NORTH);p1.setLayout(new GridLayout(9, 2, 20, 10);p1.add(bookNumber);p

9、1.add(numberField);p1.add(bookName);p1.add(nameField);p1.add(bookAuthor);p1.add(authorField);p1.add(press);p1.add(pressField);p1.add(pressTime);p1.add(pressTimeField);p1.add(bookAbstract);p1.add(abstractField);p1.add(storage);p1.add(storageField);p1.add(remain);p1.add(remain1);p1.add(cancel);p1.add(

10、confirm);cancel.addActionListener(this);confirm.addActionListener(this);public void actionPerformed(ActionEvent e) / TODO Auto-generated method stubif (e.getSource() = cancel) this.dispose();if (e.getSource() = confirm) this.dispose();BookInfo book = new BookInfo(numberField.getText(),nameField.getT

11、ext(), authorField.getText(),pressField.getText(), pressTimeField.getText(),abstractField.getText(), Integer.parseInt(storageField.getText(),Integer.parseInt(storageField.getText();ArrayList strArray = new ArrayList();strArray = op.addBookJudgement();int n = 0;int replicate = 0;while (n Integer.pars

12、eInt(strArray.get(0) n+;if (numberField.getText().equals(strArray.get(n) replicate+;if (replicate = 0) op.saveBook(book);JOptionPane.showMessageDialog(null, Add a book successfully！,Information, JOptionPane.INFORMATION_MESSAGE); else JOptionPane.showMessageDialog(null,This book(number) has already e

13、xisted!, Warning,JOptionPane.INFORMATION_MESSAGE);AddReader.javaimport java.awt.BorderLayout;import java.awt.Container;import java.awt.GridLayout;import java.awt.event.*;import java.util.ArrayList;import javax.swing.*;public class AddReader extends JFrame implements ActionListener SQLOperation op =

14、new SQLOperation();Container c = getContentPane();JPanel p1 = new JPanel();JLabel readerNumber = new JLabel(Reader Number:);JLabel readerName = new JLabel(Reader Name:);JLabel sex = new JLabel(Sex:);JLabel dpt = new JLabel(Department:);JLabel grade = new JLabel(Grade:);JTextField numberField = new J

15、TextField();JTextField nameField = new JTextField();JTextField sexField = new JTextField();JTextField dptField = new JTextField();JTextField gradeField = new JTextField();JButton cancel = new JButton(Cancel);JButton confirm = new JButton(Confirm!);public AddReader() c.add(p1, BorderLayout.NORTH);p1.

16、setLayout(new GridLayout(6, 2, 20, 10);p1.add(readerNumber);p1.add(numberField);p1.add(readerName);p1.add(nameField);p1.add(sex);p1.add(sexField);p1.add(dpt);p1.add(dptField);p1.add(grade);p1.add(gradeField);p1.add(cancel);p1.add(confirm);cancel.addActionListener(this);confirm.addActionListener(this

17、);public void actionPerformed(ActionEvent e) / TODO Auto-generated method stubif (e.getSource() = cancel) this.dispose();if (e.getSource() = confirm) this.dispose();ReaderInfo reader = new ReaderInfo(numberField.getText(),nameField.getText(), sexField.getText(),dptField.getText(), Integer.parseInt(g

18、radeField.getText();ArrayList strArray = new ArrayList();strArray = op.addReaderJudgement();int n = 0;int replicate = 0;while (n Integer.parseInt(strArray.get(0) n+;if (numberField.getText().equals(strArray.get(n) replicate+;if (replicate = 0) if (!sexField.getText().equals(boy)& !sexField.getText()

19、.equals(girl) JOptionPane.showMessageDialog(null,In the Sex field, you can only input boy or girl！,Warning, JOptionPane.INFORMATION_MESSAGE); else op.saveReader(reader);JOptionPane.showMessageDialog(null,Add a reader successfully！, Information,JOptionPane.INFORMATION_MESSAGE); else JOptionPane.showM

20、essageDialog(null,This reader(number) has already existed!, Warning,JOptionPane.INFORMATION_MESSAGE);BookDetails.javaimport java.awt.BorderLayout;import java.awt.Container;import java.awt.Dimension;import java.awt.GridLayout;import java.awt.event.*;import java.util.ArrayList;import javax.swing.*;imp

21、ort javax.swing.table.DefaultTableModel;public class BookDetails extends JFrame implements ActionListener SQLOperation op = new SQLOperation();Container c = getContentPane();JPanel p1 = new JPanel();JPanel p2 = new JPanel();JPanel p3 = new JPanel();JLabel bookNumber = new JLabel(Book Number:);JLabel

22、 bookName = new JLabel(Book Name:);JLabel author = new JLabel(Author:);JLabel press = new JLabel(Press:);JLabel pressTime = new JLabel(Press time:);JLabel bookAbstract = new JLabel(Abstract:);JLabel storage = new JLabel(Storage:);JLabel remain = new JLabel(Remain:);JLabel numberField = new JLabel();

23、JLabel nameField = new JLabel();JLabel authorField = new JLabel();JLabel pressField = new JLabel();JLabel pressTimeField = new JLabel();JLabel abstractField = new JLabel();JLabel storageField = new JLabel();JLabel remainField = new JLabel();JButton cancel = new JButton(Cancel);JLabel details = new J

24、Label(Borrow and reaturn details);Object s = Reader number, Borrow time, Deadline, Over time ;Object ob1 = new Object74;JTable table = new JTable(ob1, s);JScrollPane scrollPane = new JScrollPane(table);public BookDetails(String number) BookInfo book = new BookInfo(number);ob1 = op.borrowListForBook(

25、number);for (int i = 0; i 5; i+) DefaultTableModel books = new DefaultTableModel(ob1, s);for (int n = 0; n 7; n+) for (int m = 0; m 4; m+) ob1nm = this.ob1nm;table.setModel(books);table.invalidate();ArrayList strArray = new ArrayList();strArray = op.outputBook(book);numberField.setText(number);nameF

26、ield.setText(strArray.get(1);authorField.setText(strArray.get(2);pressField.setText(strArray.get(3);pressTimeField.setText(strArray.get(4);abstractField.setText(strArray.get(5);storageField.setText(strArray.get(6);remainField.setText(strArray.get(7);c.add(p1, BorderLayout.NORTH);c.add(p2, BorderLayo

27、ut.CENTER);c.add(p3, BorderLayout.SOUTH);p1.setLayout(new GridLayout(9, 2, 20, 10);p1.add(bookNumber);p1.add(numberField);p1.add(bookName);p1.add(nameField);p1.add(author);p1.add(authorField);p1.add(press);p1.add(pressField);p1.add(pressTime);p1.add(pressTimeField);p1.add(bookAbstract);p1.add(abstra

28、ctField);p1.add(storage);p1.add(storageField);p1.add(remain);p1.add(remainField);p1.add(details);scrollPane.setBounds(0, 0, 800, 300);p2.add(scrollPane);p3.add(cancel);table.setPreferredScrollableViewportSize(new Dimension(400, 100);cancel.addActionListener(this);public void actionPerformed(ActionEv

29、ent e) / TODO Auto-generated method stubif (e.getSource() = cancel) this.dispose();BookInfo.javapublic class BookInfo private String number, name, author, press, pressTime, bookAbstract;private int total, remain;/ default constructorpublic BookInfo() public BookInfo(String number) this.number = numb

30、er;public BookInfo(String number, String name) this.number = number; = name;public BookInfo(String number, String name, String author, String press,String pressTime, String bookAbstract, int total, int remain) this.number = number; = name;this.author = author;this.press = press;thi

31、s.pressTime = pressTime;this.bookAbstract = bookAbstract;this.total = total;this.remain = remain;public void setRemain(int i) this.remain=i;public String getNumber() return number;public String getName() return name;public String getAuthor() return author;public String getPress() return press;public

32、 String getPressTime() return pressTime;public String getBookAbstract() return bookAbstract;public int getTotal() return total;public int getRemain() return remain;BookRetrieval.javaimport java.awt.BorderLayout;import java.awt.Container;import java.awt.Dimension;import java.awt.Font;import java.awt.

33、GridLayout;import java.awt.event.*;import java.util.ArrayList;import javax.swing.*;import javax.swing.table.DefaultTableModel;class BookRetrieval extends JFrame implements ActionListener SQLOperation op = new SQLOperation();Container c = getContentPane();JPanel p1 = new JPanel();JPanel p4 = new JPan

34、el();JPanel p5 = new JPanel();JLabel bookNumber = new JLabel(Book Number:);JLabel bookName = new JLabel(Book Name:);JTextField number = new JTextField();JTextField name = new JTextField();JButton back = new JButton(Back (Fresh);JButton addBook = new JButton(Add a book);JButton deleteBook = new JButt

35、on(Delete a book);JButton editBook = new JButton(Edit a book);JButton search = new JButton(Search for details!);JButton borrowBook = new JButton(Borrow a book);JButton returnBook = new JButton(Return a book);Font font1 = new Font(00, Font.BOLD, 20);Object s = Number, Name, Author, Press, Press Time,

36、Abstract, Storage, Remain ;Object ob = new Object408;JTable table = new JTable(ob, s);JScrollPane scrollPane = new JScrollPane(table);public BookRetrieval() BookInfo book = new BookInfo();ob = op.allBook(book);for (int i = 0; i 5; i+) DefaultTableModel books = new DefaultTableModel(ob, s);for (int n

37、 = 0; n 20; n+) for (int m = 0; m 8; m+) obnm = this.obnm;table.setModel(books);table.invalidate();c.add(p4, BorderLayout.NORTH);c.add(p1, BorderLayout.CENTER);c.add(p5, BorderLayout.SOUTH);search.setFont(font1);p4.setLayout(new GridLayout(2, 4, 20, 10);p4.add(back);p4.add(addBook);p4.add(editBook);

38、p4.add(deleteBook);p4.add(borrowBook);p4.add(returnBook);p1.setLayout(null);scrollPane.setBounds(0, 0, 800, 300);p1.add(scrollPane);p5.setLayout(new GridLayout(5, 1, 0, 0);p5.add(bookNumber);p5.add(number);p5.add(bookName);p5.add(name);p5.add(search);table.setPreferredScrollableViewportSize(new Dime

39、nsion(400, 300);addBook.addActionListener(this);search.addActionListener(this);back.addActionListener(this);deleteBook.addActionListener(this);editBook.addActionListener(this);borrowBook.addActionListener(this);returnBook.addActionListener(this);public void actionPerformed(ActionEvent e) if (e.getSo

40、urce() = search) ArrayList strArray = new ArrayList();strArray = op.addBookJudgement();String s1 = number.getText();String s2 = name.getText();int n = 0;int replicate = 0;while (n Integer.parseInt(strArray.get(0) n+;if (s1.equals(strArray.get(n) replicate+;ArrayList strArray1 = new ArrayList();strAr

41、ray1 = op.addBookJudgement1();int n1 = 0;int replicate1 = 0;while (n1 Integer.parseInt(strArray1.get(0) n1+;if (s2.equals(strArray1.get(n1) replicate1+;if (replicate = 0 & replicate1 = 0) JOptionPane.showMessageDialog(null,Please input a correct book number or name!,Warning, JOptionPane.INFORMATION_

42、MESSAGE); else if (replicate != 0 | replicate1 != 0) if (replicate = 0 & replicate1 != 0) BookInfo book = new BookInfo(s1, s2);String s = op.searchBookByName(book);BookDetails f = new BookDetails(s);/ f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);f.setTitle(Book Details);f.setLocation(300, 200);f

43、.setSize(480, 470);f.setVisible(true); else if (replicate != 0) BookDetails f = new BookDetails(s1);/ f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);f.setTitle(Book Details);f.setLocation(300, 200);f.setSize(480, 470);f.setVisible(true);if (e.getSource() = back) this.dispose();MyFrame f = new MyFr

44、ame();/ f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);f.setTitle(Library Management System);f.setLocation(300, 200);f.setSize(580, 300);f.setVisible(true);if (e.getSource() = addBook) AddBook f = new AddBook();/ f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);f.setTitle(Add a book);f.setLocation

45、(300, 200);f.setSize(300, 400);f.setVisible(true);if (e.getSource() = deleteBook) DeleteBook f = new DeleteBook();/ f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);f.setTitle(Delete a book);f.setLocation(300, 200);f.setSize(300, 200);f.setVisible(true);if (e.getSource() = borrowBook) BorrowBook f =

46、 new BorrowBook();/ f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);f.setTitle(Borrow a book);f.setLocation(300, 200);f.setSize(300, 200);f.setVisible(true);if (e.getSource() = returnBook) ReturnBook f = new ReturnBook();/ f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);f.setTitle(Return a book);f

47、.setLocation(300, 200);f.setSize(300, 200);f.setVisible(true);if (e.getSource() = editBook) SelectEdit f = new SelectEdit();/ f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);f.setTitle(Edit a book);f.setLocation(300, 200);f.setSize(300, 200);f.setVisible(true);BorrowBook.javaimport java.awt.BorderL

48、ayout;import java.awt.Container;import java.awt.GridLayout;import java.awt.event.*;import java.util.ArrayList;import javax.swing.*;public class BorrowBook extends JFrame implements ActionListener SQLOperation op = new SQLOperation();Container c = getContentPane();JPanel p1 = new JPanel();JLabel book

49、Number = new JLabel(Book Number:);JTextField numberField = new JTextField();JLabel readerNumber = new JLabel(Reader Number:);JTextField readerNumberField = new JTextField();JButton cancel = new JButton(Cancel);JButton borrow = new JButton(Borrow!);public BorrowBook() c.add(p1, BorderLayout.NORTH);p1

50、.setLayout(new GridLayout(3, 2, 20, 10);p1.add(bookNumber);p1.add(numberField);p1.add(readerNumber);p1.add(readerNumberField);p1.add(cancel);p1.add(borrow);cancel.addActionListener(this);borrow.addActionListener(this);public void actionPerformed(ActionEvent e) / TODO Auto-generated method stubif (e.

51、getSource() = cancel) this.dispose();if (e.getSource() = borrow) String bookNumber = numberField.getText();ArrayList strArray = new ArrayList();strArray = op.addBookJudgement();int n = 0;int replicate = 0;while (n Integer.parseInt(strArray.get(0) n+;if (bookNumber.equals(strArray.get(n) replicate+;S

52、tring readerNumber = readerNumberField.getText();ArrayList strArray1 = new ArrayList();strArray1 = op.addReaderJudgement();int n1 = 0;int replicate1 = 0;while (n1 Integer.parseInt(strArray1.get(0) n1+;if (readerNumber.equals(strArray1.get(n1) replicate1+;if (replicate = 0 | replicate1 = 0) JOptionPa

53、ne.showMessageDialog(null,Please input a correct book number and a reader number!,Warning, JOptionPane.INFORMATION_MESSAGE); else BookInfo book = new BookInfo(bookNumber);ArrayList s = new ArrayList();s = op.outputBook(book);if (Integer.parseInt(s.get(7) 0) int s1 = op.reBorrowCheck(numberField.getT

54、ext(),readerNumberField.getText();if (s1 = 1) JOptionPane.showMessageDialog(null,You have borrowed this book, can not reborrow it!,Unsuccessful,JOptionPane.INFORMATION_MESSAGE); else long currentTime = System.currentTimeMillis();if (op.deadLineCheck(readerNumberField.getText(),currentTime) != 0) JOp

55、tionPane.showMessageDialog(null,You have exceeded the deadline, please return these books first!,Unsuccessful,JOptionPane.INFORMATION_MESSAGE); else BookInfo book1 = new BookInfo(s.get(0), s.get(1),s.get(2), s.get(3), s.get(4), s.get(5),Integer.parseInt(s.get(6),Integer.parseInt(s.get(7) - 1);op.inp

56、utBook(book1);String borrowTime = Long.toString(System.currentTimeMillis();String deadline = Long.toString(System.currentTimeMillis() + 2592000000l);System.out.println(borrowTime);System.out.println(deadline);op.insertBorrow(numberField.getText(),readerNumberField.getText(), borrowTime,deadline);JOp

57、tionPane.showMessageDialog(null,Borrowed this book successfully, you have 30 days to enjoy this book!,Successful,JOptionPane.INFORMATION_MESSAGE); else JOptionPane.showMessageDialog(null,This book has been borrowed!, Unsuccessful,JOptionPane.INFORMATION_MESSAGE);this.dispose();BorrowList.Javaimport

58、java.awt.BorderLayout;import java.awt.Container;import java.awt.Dimension;import java.awt.Font;import java.awt.GridLayout;import java.awt.event.*;import java.util.ArrayList;import javax.swing.*;import javax.swing.table.DefaultTableModel;public class BorrowList extends JFrame implements ActionListene

59、r SQLOperation op = new SQLOperation();Container c = getContentPane();JPanel p1 = new JPanel();JPanel p2 = new JPanel();JButton back=new JButton(Back);Object s = Book number, Reader number, Borrow time, Deadline,OverTime;Object ob = new Object1005;JTable table = new JTable(ob, s);JScrollPane scrollP

60、ane = new JScrollPane(table);public BorrowList() / TODO Auto-generated constructor stubObject ob1 = op.borrowList();for (int i = 0; i 5; i+) DefaultTableModel list = new DefaultTableModel(ob, s);for (int n = 0; n 100; n+) for (int m = 0; m 5; m+) obnm = ob1nm;table.setModel(list);table.invalidate();