基于java的图书管理系统源代码

声明：本系统是基于C/S的图书管理系统，主要使用的是Oracle数据库，下面附所有实现代码packagelibrary;importjava.awt.BorderLayout;importjava.awt.Container;importjava.awt.GridLayout;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.sql.ResultSet;importjavax.swing.JButton;importjavax.swing.JComboBox;importjavax.swing.JFrame;importjavax.swing.JLabel;importjavax.swing.JOptionPane;importjavax.swing.JPanel;importjavax.swing.JTextField;publicclassbook_addextendsJFrameimplementsActionListener{DataBaseManagerdb=newDataBaseManager();ResultSetrs;JPanelpanel1,panel2;JLabelbook_id_label,book_name_label,author_label,press_label,press_date_label,price_label,book_num_label,borrowed_num_label,address;JTextFieldbook_id_TextField,book_name_TextField,author_TextField,press_TextField,press_date_TextField,price_TextField,book_num_TextField,borrowed_count;JComboBoxaddresst;Containerc;JButtonclear,add,exit;publicbook_add(){super(添加图书信息);c=getContentPane();c.setLayout(newBorderLayout());book_id_label=newJLabel(编号,JLabel.CENTER);book_name_label=newJLabel(名称,JLabel.CENTER);author_label=newJLabel(作者,JLabel.CENTER);press_label=newJLabel(出版社,JLabel.CENTER);press_date_label=newJLabel(出版日期,JLabel.CENTER);price_label=newJLabel(价格,JLabel.CENTER);book_num_label=newJLabel(库存数,JLabel.CENTER);borrowed_num_label=newJLabel(已借阅数,JLabel.CENTER);address=newJLabel(藏书地址,JLabel.CENTER);book_id_TextField=newJTextField(15);book_name_TextField=newJTextField(15);author_TextField=newJTextField(15);press_TextField=newJTextField(15);press_date_TextField=newJTextField(15);price_TextField=newJTextField(15);book_num_TextField=newJTextField(15);borrowed_count=newJTextField(15);borrowed_count.setText(0);addresst=newJComboBox();addresst.addItem(扬子津图书馆);addresst.addItem(荷花池图书馆);addresst.addItem(瘦西湖图书馆);addresst.addItem(淮海路图书馆);panel1=newJPanel();panel1.setLayout(newGridLayout(9,2));panel1.add(book_id_label);panel1.add(book_id_TextField);panel1.add(book_name_label);panel1.add(book_name_TextField);panel1.add(press_label);panel1.add(press_TextField);panel1.add(author_label);panel1.add(author_TextField);panel1.add(press_date_label);panel1.add(press_date_TextField);panel1.add(price_label);panel1.add(price_TextField);panel1.add(book_num_label);panel1.add(book_num_TextField);panel1.add(borrowed_num_label);panel1.add(borrowed_count);panel1.add(address);panel1.add(addresst);panel2=newJPanel();panel2.setLayout(newGridLayout(1,3));clear=newJButton(清空);clear.addActionListener(this);add=newJButton(添加);add.addActionListener(this);exit=newJButton(退出);exit.addActionListener(this);panel2.add(clear);panel2.add(add);panel2.add(exit);c.add(panel1,BorderLayout.CENTER);c.add(panel2,BorderLayout.SOUTH);setVisible(true);}publicvoidactionPerformed(ActionEvente){if(e.getSource()==exit){this.dispose();}elseif(e.getSource()==clear){book_id_TextField.setText();book_name_TextField.setText();author_TextField.setText();press_TextField.setText();press_date_TextField.setText();price_TextField.setText();book_num_TextField.setText();}elseif(e.getSource()==add){if(book_id_TextField.getText().trim().equals()){JOptionPane.showMessageDialog(null,书号不能为空);}elseif(book_name_TextField.getText().trim().equals()){JOptionPane.showMessageDialog(null,书名不能为空);}elseif(author_TextField.getText().trim().equals()){JOptionPane.showMessageDialog(null,作者不能为空);}elseif(press_TextField.getText().trim().equals()){JOptionPane.showMessageDialog(null,出版社不能为空);}elseif(press_date_TextField.getText().trim().equals()){JOptionPane.showMessageDialog(null,出版日期不能为空);}elseif(price_TextField.getText().trim().equals()){JOptionPane.showMessageDialog(null,价格不能为空);}elseif(book_num_TextField.getText().trim().equals()){JOptionPane.showMessageDialog(null,库存不能为空);}elseif(borrowed_count.getText().trim().equals()){JOptionPane.showMessageDialog(null,借阅数不能为空);}else{try{StringstrSQL=insertintobook(book_id,book_name,press,author,press_date,price,book_count,borrowed_count,store_address)values('+book_id_TextField.getText().trim()+','+book_name_TextField.getText().trim()+','+press_TextField.getText().trim()+','+author_TextField.getText().trim()+','+press_date_TextField.getText().trim()+','+price_TextField.getText().trim()+','+book_num_TextField.getText().trim()+','+borrowed_count.getText().trim()+','+addresst.getSelectedItem()+');if(db.updateSql(strSQL)){this.dispose();JOptionPane.showMessageDialog(null,添加图书成功);}else{JOptionPane.showMessageDialog(null,添加图书失败);this.dispose();}db.closeConnection();}catch(Exceptionex){System.out.println(ex.toString());}}}}}packagelibrary;importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.ResultSet;importjava.sql.SQLException;publicclassbook_deleteextendsJFrameimplementsActionListener{DataBaseManagerdb=newDataBaseManager();ResultSetrs;Containerc;JLabelTipLabel=newJLabel(请选择要删除的书名,JLabel.CENTER);JComboBoxbb=newJComboBox();JButtonyes,exit;JPanelpanel1=newJPanel();publicbook_delete(){super(删除图书信息);c=getContentPane();c.setLayout(newBorderLayout());try{StringstrSQL=selectbook_namefrombookwherebook_countborrowed_count;