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

声明：本系统是基于 C/S 的图书管理

系统，主要使用的是 Oracle 数据库，

下面附所有实现代码

package library;

import java.awt.BorderLayout;

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;

JPanel panel1,panel2;

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);

address=new JLabel("藏书地址",JLabel.CENTER);

book_id_TextField=new JTextField(15);

book_name_TextField=new JTextField(15);

author_TextField=new JTextField(15);

press_TextField=new JTextField(15);

addresst=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);

panel1.add(press_label);

panel1.add(author_TextField);

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=new JPanel();

clear=new JButton("清空");

panel2.add(add);

panel2.add(exit);

c.add(panel1,BorderLayout.CENTER);

c.add(panel2,BorderLayout.SOUTH);

setVisible(true);

this.dispose();

else if(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("");

{

JOptionPane.showMessageDialog(null, "书号不能为空");

}

else if(book_name_TextField.getText().trim().equals(""))

{

JOptionPane.showMessageDialog(null, "书名不能为空");

}

else if(author_TextField.getText().trim().equals(""))

{

JOptionPane.showMessageDialog(null, "作者不能为空");

else if(press_TextField.getText().trim().equals(""))

else if(press_date_TextField.getText().trim().equals(""))

}

else if(price_TextField.getText().trim().equals(""))

{

JOptionPane.showMessageDialog(null, "价格不能为空");

}

JOptionPane.showMessageDialog(null, "库存不能为空");

{

JOptionPane.showMessageDialog(null, "借阅数不能为空");

}

else {

try{

String strSQL="insert into

book(book_id,book_name,press,author,press_date,price,book_count,borrowed_count,s

tore_address) values('"

+book_id_TextField.getText().trim()

+"','"

+book_name_TextField.getText().trim()

+"','"

+"','"

+price_TextField.getText().trim()

+"','"

+book_num_TextField.getText().trim()

+"','"

+borrowed_count.getText().trim()

+"','"

+addresst.getSelectedItem()+"')";

{

}

}

db.closeConnection();

}

}

}

package library;

import javax.swing.*;

import java.awt.*;

import java.sql.SQLException;

Container c;

JComboBox bb=new JComboBox();

JButton yes,exit;

JPanel panel1=new JPanel();

public book_delete()

{

super("删除图书信息");

c.setLayout(new BorderLayout());