1、基于java的图书管理系统源代码基于java的图书管理系统源代码声明:本系统是基于C/S的图书管理系统,主要使用的是Oracle数据库,下面附所有实现代码 package library; import java.awt.BorderLayout; import java.awt.Container; import java.awt.GridLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.ResultSet; import javax.swing.J
2、Button; import javax.swing.JComboBox; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JTextField; public class book_add extends JFrame implements ActionListener DataBaseManager db=new DataBaseManager(); ResultSet rs;
3、 JPanel panel1,panel2; JLabel book_id_label,book_name_label,author_label, press_label,press_date_label,price_label,book_num_label,borrowed_num_label,address; JTextField book_id_TextField,book_name_TextField,author_TextField, press_TextField,press_date_TextField,price_TextField,book_num_TextField, bo
4、rrowed_count; JComboBox addresst; Container c; JButton clear,add,exit; public book_add() super(添加图书信息); c=getContentPane(); c.setLayout(new BorderLayout(); book_id_label=new JLabel(编号,JLabel.CENTER); book_name_label=new JLabel(名称,JLabel.CENTER); 1 author_label=new JLabel(作者,JLabel.CENTER); press_lab
5、el=new JLabel(出版社,JLabel.CENTER); press_date_label=new JLabel(出版日期,JLabel.CENTER); price_label=new JLabel(价格,JLabel.CENTER); book_num_label=new JLabel(库存数,JLabel.CENTER); borrowed_num_label=new JLabel(已借阅数,JLabel.CENTER); address=new JLabel(藏书地址,JLabel.CENTER); book_id_TextField=new JTextField(15);
6、book_name_TextField=new JTextField(15); author_TextField=new JTextField(15); press_TextField=new JTextField(15); press_date_TextField=new JTextField(15); price_TextField=new JTextField(15); book_num_TextField=new JTextField(15); borrowed_count=new JTextField(15); borrowed_count.setText(0); addresst=
7、new JComboBox(); addresst.addItem(扬子津图书馆); addresst.addItem(荷花池图书馆); addresst.addItem(瘦西湖图书馆); addresst.addItem(淮海路图书馆); panel1=new JPanel(); panel1.setLayout(new GridLayout(9,2); panel1.add(book_id_label); panel1.add(book_id_TextField); panel1.add(book_name_label); panel1.add(book_name_TextField);
8、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(b
9、orrowed_num_label); panel1.add(borrowed_count); panel1.add(address); panel1.add(addresst); panel2=new JPanel(); panel2.setLayout(new GridLayout(1,3); clear=new JButton(清空); 2 clear.addActionListener(this); add=new JButton(添加); add.addActionListener(this); exit=new JButton(退出); exit.addActionListener
10、(this); panel2.add(clear); panel2.add(add); panel2.add(exit); c.add(panel1,BorderLayout.CENTER); c.add(panel2,BorderLayout.SOUTH); setVisible(true); public void actionPerformed(ActionEvent e) if(e.getSource()=exit) this.dispose(); else if(e.getSource()=clear) book_id_TextField.setText(); book_name_T
11、extField.setText(); author_TextField.setText(); press_TextField.setText(); press_date_TextField.setText(); price_TextField.setText(); book_num_TextField.setText(); else if(e.getSource()=add) if(book_id_TextField.getText().trim().equals() JOptionPane.showMessageDialog(null, 书号不能为空); else if(book_name
12、_TextField.getText().trim().equals() JOptionPane.showMessageDialog(null, 书名不能为空); else if(author_TextField.getText().trim().equals() JOptionPane.showMessageDialog(null, 作者不能为空); else if(press_TextField.getText().trim().equals() 3 JOptionPane.showMessageDialog(null, 出版社不能为空); else if(press_date_TextF
13、ield.getText().trim().equals() JOptionPane.showMessageDialog(null, 出版日期不能为空); else if(price_TextField.getText().trim().equals() JOptionPane.showMessageDialog(null, 价格不能为空); else if(book_num_TextField.getText().trim().equals() JOptionPane.showMessageDialog(null, 库存不能为空); else if(borrowed_count.getTex
14、t().trim().equals() JOptionPane.showMessageDialog(null, 借阅数不能为空); else try String strSQL=insert into book(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.
15、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) 4 this.dispose(); JOptionPane.sh
16、owMessageDialog(null,添加图书成功); else JOptionPane.showMessageDialog(null,添加图书失败); this.dispose(); db.closeConnection(); catch(Exception ex) System.out.println(ex.toString(); package library; import javax.swing.*; import java.awt.*; import java.awt.event.*; import java.sql.ResultSet; import java.sql.SQL
17、Exception; public class book_delete extends JFrame implements ActionListener DataBaseManager db=new DataBaseManager(); ResultSet rs; Container c; JLabel TipLabel=new JLabel(请选择要删除的书名,JLabel.CENTER); JComboBox bb=new JComboBox(); JButton yes,exit; JPanel panel1=new JPanel(); public book_delete() supe
18、r(删除图书信息); c=getContentPane(); c.setLayout(new BorderLayout(); 5 try String strSQL=select book_name from book where book_countborrowed_count; rs=db.getResult(strSQL); while(rs.next() bb.addItem(rs.getString(1); catch(SQLException sqle) System.out.println(sqle.toString(); catch(Exception ex) System.o
19、ut.println(ex.toString(); c.add(TipLabel,BorderLayout.NORTH); c.add(bb,BorderLayout.CENTER); yes=new JButton(确定); exit=new JButton(退出); yes.addActionListener(this); exit.addActionListener(this); panel1.add(yes); panel1.add(exit); c.add(panel1,BorderLayout.SOUTH); setVisible(true); public void action
20、Performed(ActionEvent e) if(e.getSource()=exit) this.dispose(); else if(e.getSource()=yes) try String strSQL=select borrowed_count from book where book_name= +bb.getSelectedItem()+; rs=db.getResult(strSQL); if(!rs.first() JOptionPane.showMessageDialog(null,书库里没有你要删除的书); else 6 String strSql=delete f
21、rom book where book_name= +bb.getSelectedItem() +and borrowed_count=0; rs.first(); int count=rs.getInt(1); if(!(count=0) JOptionPane.showMessageDialog(null,此书还有学生没有还,不可删除); else if(db.updateSql(strSql) JOptionPane.showMessageDialog(null,删除成功); db.closeConnection(); this.dispose(); else JOptionPane.s
22、howMessageDialog(null,删除失败); db.closeConnection(); this.dispose(); catch(SQLException sqle) System.out.println(sqle.toString(); catch(Exception ex) System.out.println(ex.toString(); package library; import java.awt.BorderLayout; import java.awt.Container; import java.awt.GridLayout; import java.awt.
23、event.ActionEvent; import java.awt.event.ActionListener; import java.sql.ResultSet; import javax.swing.JButton; import javax.swing.JFrame; 7 import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JTextField; public class book_modify extends JFrame im
24、plements ActionListener DataBaseManager db=new DataBaseManager(); ResultSet rs; JPanel panel1,panel2,panel3; JLabel TipLabel=new JLabel(输入书名点确定 ,将调出此书的相关信息); JLabel book_name_label,author_label, press_label,press_date_label,price_label; JTextField book_name_TextField,author_TextField, press_TextFiel
25、d,press_date_TextField,price_TextField; Container c; JButton clear,yes,update,exit; public book_modify() super(修改图书信息); c=getContentPane(); c.setLayout(new BorderLayout(); panel3=new JPanel(); panel3.add(TipLabel); c.add(panel3,BorderLayout.NORTH); book_name_label=new JLabel(名称,JLabel.CENTER); autho
26、r_label=new JLabel(作者,JLabel.CENTER); press_label=new JLabel(出版社,JLabel.CENTER); press_date_label=new JLabel(出版日期,JLabel.CENTER); price_label=new JLabel(价格,JLabel.CENTER); book_name_TextField=new JTextField(15); author_TextField=new JTextField(15); press_TextField=new JTextField(15); press_date_Text
27、Field=new JTextField(15); price_TextField=new JTextField(15); panel1=new JPanel(); panel1.setLayout(new GridLayout(6,2); panel1.add(book_name_label); panel1.add(book_name_TextField); panel1.add(author_label); panel1.add(author_TextField); panel1.add(press_label); panel1.add(press_TextField); panel1.
28、add(press_date_label); panel1.add(press_date_TextField); panel1.add(price_label); 8 panel1.add(price_TextField); panel2=new JPanel(); panel2.setLayout(new GridLayout(1,4); clear=new JButton(清空); yes=new JButton(确定); update=new JButton(更新); exit=new JButton(退出); panel2.add(clear); panel2.add(yes); pa
29、nel2.add(update); panel2.add(exit); clear.addActionListener(this); yes.addActionListener(this); update.addActionListener(this); exit.addActionListener(this); update.setEnabled(false); c.add(panel1,BorderLayout.CENTER); c.add(panel2,BorderLayout.SOUTH); setVisible(true); public void actionPerformed(ActionEvent e) if(e.getSource()=exit) this.dispose(); else if(e.getSource()=clear) book_name_TextField.setText(); author_TextField.setText(); press_TextField.setText(); press_date_TextField.setText(); price_TextField.se
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1