《简易图书管理系统.doc》由会员分享，可在线阅读，更多相关《简易图书管理系统.doc（14页珍藏版）》请在金锄头文库上搜索。
1、本程序以java为设计语言，能够实现一个简单的图书管理系统，可以实现简单的增加图书，查询图书，删除图书的功能，其中用到数据库的连接，窗体的布局管理。本程序有以下几个功能函数组成所有模块都在名为bookmanager的包中1：主函数mainframe.java2：增加模块 adddialog.java3:查询模块 searchdialog.java4:查询结果模块 searchresult.java5:书本类book.java6：数据库连接类 dbcon.java1. 主界面2. 添加模块3. 查询模块4. 输出模块5.6.源程序如下1.mainframe.javapackage bookman
2、ager;import javax.swing.*;import javax.swing.table.DefaultTableModel;import java.awt.*;import java.awt.event.*;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.LinkedList;public class mainframe extends JFrame impleme
3、nts ActionListenerprivate JToolBar tb;String btntitle=增加,查询,删除,退出;String tabeltitle=图书编号,书名,定价,出版社;JButton btn=new JButton4;JTable table; DefaultTableModel model;public mainframe()super(图书管理系统);/初始化各个按钮tb=new JToolBar(工具栏);for(int i=0;ibtntitle.length;i+)btni=new JButton(btntitlei);btni.addActionLis
4、tener(this);tb.add(btni);/创建表模型model=new DefaultTableModel(tabeltitle,10);table=new JTable(model);/设定单元格的高度table.setRowHeight(25);add(tb,BorderLayout.NORTH );add(new JScrollPane(table),BorderLayout.CENTER );setSize(900,600);setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE );setLocation(100,30);init();p
5、ublic void actionPerformed(ActionEvent e)mainframe m=new mainframe();Object o=e.getSource();if(o=btn0)adddialog ad=new adddialog(m,25,25);init();if(o=btn1)searchdialog sd=new searchdialog(m,25,25);sd.dialog.setVisible(true);init();if(o=btn2)int result=JOptionPane.showConfirmDialog(null,确实要删除该条图书信息吗？
6、,确认,JOptionPane.YES_NO_OPTION ,JOptionPane.QUESTION_MESSAGE );if(result=0)Connection con=dbcon.getconnectin();Object ob=model.getValueAt(table.getSelectedRow(),0);dbcon.delete(con,ob);init();else return ;if(o=btn3)System.exit(0);public void init()Connection con=dbcon.getconnectin();LinkedList list=n
7、ull;try PreparedStatement stmt=con.prepareStatement(select * from book);ResultSet rs=stmt.executeQuery(); list=new LinkedList();while(rs.next()String id=rs.getString(1);String name=rs.getString(2);String price=rs.getString(3);String publish=rs.getString(4);book b=new book(id,name,Float.valueOf(price
8、),publish);list.add(b);model.setRowCount(0);for(int i=0;ilist.size();i+)book b=(book)list.get(i);Object str=b.getid(),b.getname(),b.getprice(),b.getpublish();model.addRow(str); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();public static void main(String args)new mainfra
9、me().show();*2.Adddialog.java添加模块package bookmanager;import java.awt.*;import java.awt.event.*;import java.util.LinkedList;import javax.swing.*;public class adddialog implements ActionListener JLabel label=new JLabel4;JTextField txt=new JTextField4;String ltitle=图书编号,图书名称,单 价,出 版 社;String btitle=上一个
10、,下一个,确 定,取 消;JButton btn=new JButton4;JDialog dialog;JPanel p;LinkedList list;public adddialog(JFrame f,int x,int y)dialog=new JDialog(f,增加,true);dialog.setLocation(x,y);p=new JPanel(); list=new LinkedList();/p.setBorder(BorderFactory.createTitledBorder(请选择操作);/p.setBorder(BorderFactory.createLineBo
11、rder(Color.red );/p.setBorder(BorderFactory.createBevelBorder(0, Color.red , Color.green );p.setBorder(BorderFactory.createBevelBorder(0, Color.red , Color.green , Color.blue , Color.yellow );for(int i=0;iltitle.length ;i+)labeli=new JLabel(ltitlei);labeli.setFont(new Font(宋体,Font.PLAIN ,18);txti=ne
12、w JTextField();btni=new JButton(btitlei);btni.addActionListener(this);btni.setFont(new Font(幼圆,Font.PLAIN ,15);dialog.add(labeli);dialog.add(txti);dialog.add(btni);dialog.setLayout(null);p.setBounds(10,150,310,160); p.setBackground(Color.green );label0.setBounds(10,10,90,25);txt0.setBounds(110,10,20
13、0,25);label1.setBounds(10,45,90,25);txt1.setBounds(110,45,200,25);label2.setBounds(10,80,90,25);txt2.setBounds(110,80,200,25);label3.setBounds(10,115,90,25);txt3.setBounds(110,115,200,25);dialog.add(p);btn0.setBounds(60,180,80,25);btn1.setBounds(175,180,80,25);btn2.setBounds(60,250,80,25);btn3.setBounds(175,250,80,25);dialog.setSize(400,400);dialog.show();dialog.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE );public void actionPerformed(ActionEvent e)int size=list.size();/init();/list.add
