基于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.JButton;

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;

JLabel book_id_label,book_name_label,author_label,

press_label,press_date_label,price_label,book_num_label,borrowed_num _label,a

ddress;

JTextField book_id_TextField,book_name_TextField,author_TextField, press_TextField,press_date_TextField,price_TextField,book_num_TextFi eld,

borrowed_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_label=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);

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=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(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=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(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_TextField.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_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_TextField.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.getText().trim().equals(""))

{

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

}

else {

try{

String strSQL="insert into

book(book_id,book_name,press,author,press_date,price,book_count,borr owed_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))

{

4

this.dispose();

JOptionPane.showMessageDialog(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.SQLException; 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()

{

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

c=getContentPane();

c.setLayout(new BorderLayout());

5

try{

String strSQL="select book_name from book where

book_count>borrowed_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.out.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 actionPerformed(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 from 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.showMessageDialog(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.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 implements 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_TextField,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); author_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_TextField=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.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);

panel2.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.setText("");

}

else if(e.getSource()==yes)

{

try{

String strSQL="select * from book where book_name='"

+book_name_TextField.getText().trim()+"'";

rs=db.getResult(strSQL);

while(rs.next()){

book_name_TextField.setText(rs.getString("book_name")); author_TextField.setText(rs.getString("author"));

9

press_TextField.setText(rs.getString("press"));

press_date_TextField.setText(rs.getString("press_date")); price_TextField.setText(rs.getString("price"));

}

update.setEnabled(true);

}catch(NullPointerException upe){

System.out.println(upe.toString());

}catch(Exception es){

System.out.println(es.toString());

}

}

else if(e.getSource()==update)

{

try{

String strSQL="update book set book_name='"

+book_name_TextField.getText().trim()+"',press='"

+press_TextField.getText().trim()+"',author='"

+author_TextField.getText().trim()+"',press_date='"

+press_date_TextField.getText().trim()+"',price='"

+price_TextField.getText().trim()+"' where

book_name='"+book_name_TextField.getText().trim()+"'";

if(db.updateSql(strSQL))

{

this.dispose();

JOptionPane.showMessageDialog(null,"更新图书成功");

}

else {

JOptionPane.showMessageDialog(null,"更新图书失败");

}

db.closeConnection();

}catch(Exception sqle){

System.out.println(sqle.toString());

}

}

}

}

package library;

import java.awt.BorderLayout;

import java.awt.Container;

import java.awt.GridLayout;

import java.awt.event.ActionEvent;

10

import java.awt.event.ActionListener; import java.sql.ResultSet; import java.sql.SQLException;

import java.text.DateFormat;

import java.text.SimpleDateFormat; import java.util.Calendar; import java.util.Date;

import javax.swing.JButton;

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 bookborrow extends JFrame implements ActionListener{ DataBaseManager db=new DataBaseManager();

ResultSet rs;

Container c;

JPanel panel1,panel2;

JLabel borrowname,bookname,borrowdate,returndate,is_return_label; JTextField borrowdateField,returndateField,is_return;

JButton clear,yes,cancel;

JComboBox borrownameBox=new JComboBox();

JComboBox booknameBox=new JComboBox();

public bookborrow()

{

super("书籍出借");

c=getContentPane();

c.setLayout(new BorderLayout());

Calendar cal = Calendar.getInstance();

int year,month,day;

// year=cal.get(Calendar.YEAR);

// month=cal.get(Calendar.MONTH)+3;//从0开始的

// day=cal.get(Calendar.DAY_OF_MONTH); // java.text.SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); // String cdate =

sdf.format(cal.getTime());

// String

da=Integer.toString(year)+"-0"+Integer.toString(month)+"-

"+Integer.toString(day);

borrowname=new JLabel("借阅者姓名",JLabel.CENTER);

bookname=new JLabel("书名",JLabel.CENTER);

borrowdate=new JLabel("借书日期",JLabel.CENTER);

11

// returndate=new JLabel("应还日期",JLabel.CENTER);

is_return_label=new JLabel("是否归还",JLabel.CENTER);

borrowdateField=new JTextField(15); //

borrowdateField.setText(cdate); // returndateField=new JTextField(15); // returndateField.setText(da);

is_return=new JTextField(15);

is_return.setText("否");

try{

String strSql="select student_name from reader ";

rs=db.getResult(strSql);

while(rs.next())

{

borrownameBox.addItem(rs.getString(1));

}