簡易圖書管理系統(tǒng)

1、本程序以java為設(shè)計語言，能夠?qū)崿F(xiàn)一個簡單的圖書管理系統(tǒng)，可以實現(xiàn)簡單的增加圖書，查詢圖書，刪除圖書的功能，其中用到數(shù)據(jù)庫的連接，窗體的布局管理。本程序有以下幾個功能函數(shù)組成所有模塊都在名為bookmanager的包中1：主函數(shù)mainframe.java2：增加模塊 adddialog.java3:查詢模塊 searchdialog.java4:查詢結(jié)果模塊 searchresult.java5:書本類book.java6：數(shù)據(jù)庫連接類 dbcon.java1. 主界面2. 添加模塊3. 查詢模塊4. 輸出模塊5.6.源程序如下package bookmanager;import java

2、x.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 implements ActionListen

3、erprivate JToolBar tb;String btntitle="增加","查詢","刪除","退出"String tabeltitle="圖書編號","書名","定價","出版社"JButton btn=new JButton4;JTable table; DefaultTableModel model;public mainframe()super("圖書管理系統(tǒng)");/初始化各個按鈕tb=new J

4、ToolBar("工具欄");for(int i=0;i<btntitle.length;i+)btni=new JButton(btntitlei);btni.addActionListener(this);tb.add(btni);/創(chuàng)建表模型model=new DefaultTableModel(tabeltitle,10);table=new JTable(model);/設(shè)定單元格的高度table.setRowHeight(25);add(tb,BorderLayout.NORTH );add(new JScrollPane(table),BorderLay

5、out.CENTER );setSize(900,600);setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE );setLocation(100,30);init();public 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,2

6、5);sd.dialog.setVisible(true);init();if(o=btn2)int result=JOptionPane.showConfirmDialog(null,"確實要刪除該條圖書信息嗎？","確認",JOptionPane.YES_NO_OPTION ,JOptionPane.QUESTION_MESSAGE );if(result=0)Connection con=dbcon.getconnectin();Object ob=model.getValueAt(table.getSelectedRow(),0);dbcon.d

7、elete(con,ob);init();else return ;if(o=btn3)System.exit(0);public void init()Connection con=dbcon.getconnectin();LinkedList list=null;try PreparedStatement stmt=con.prepareStatement("select * from book");ResultSet rs=stmt.executeQuery(); list=new LinkedList();while(rs.next()String id=rs.ge

8、tString(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),publish);list.add(b);model.setRowCount(0);for(int i=0;i<list.size();i+)book b=(book)list.get(i);Object str=b.getid(),b.getname(),b.getprice(),b.getpublis

9、h();model.addRow(str); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();public static void main(String args)new mainframe().show();*2.Adddialog.java添加模塊package bookmanager;import java.awt.*;import java.awt.event.*;import java.util.LinkedList;import javax.swing.*;public cla

10、ss adddialog implements ActionListener JLabel label=new JLabel4;JTextField txt=new JTextField4;String ltitle="圖書編號","圖書名稱","單 價","出 版 社"String btitle="上一個","下一個","確 定","取 消"JButton btn=new JButton4;JDialog dialog;JPanel

11、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.createLineBorder(Color.red );/p.setBorder(Border

12、Factory.createBevelBorder(0, Color.red , Color.green );p.setBorder(BorderFactory.createBevelBorder(0, Color.red , Color.green , Color.blue , Color.yellow );for(int i=0;i<ltitle.length ;i+)labeli=new JLabel(ltitlei);labeli.setFont(new Font("宋體",Font.PLAIN ,18);txti=new JTextField();btni=

13、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,200,25);la

14、bel1.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

15、,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(b);/if(e.getSource()=btn0)/book b1=(book)list.get(size);/size-;/txt0.setText(b1.getid();/txt1.setText(b1.get

16、name();/txt2.setText(Float.toString(b1.getprice();/txt3.setText(b1.getpublish();/if(e.getSource()=btn1)/book b2=(book)list.get(size);/size+;/txt0.setText(b2.getid();/txt1.setText(b2.getname();/txt2.setText(Float.toString(b2.getprice();/txt3.setText(b2.getpublish();/if(e.getSource()=btn2)String id=tx

17、t0.getText();String name=txt1.getText();float price=getprice(txt2.getText();String publish=txt3.getText();Object str=id,name,price,publish;dbcon.insert(dbcon.getconnectin(), str);private float getprice(String str) float price=0; try price=Float.valueOf(str); catch(Exception ex) JOptionPane.showMessa

18、geDialog(null,"價格必須是數(shù)字，請重新輸入!","錯誤",JOptionPane.WARNING_MESSAGE ); return price;/設(shè)定上一個，下一個按鈕的可用性/private void init()/if(list.size()=0)/btn0.setEnabled(false);/btn1.setEnabled(false);/else/btn0.setEnabled(true);/btn1.setEnabled(true);/3.searchdialog.java 查找模塊package bookmanager;im

19、port javax.swing.*;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 searchdialog implements ActionListener ,ItemListenerJRadioButton radio=new JRadioB

20、utton3;ButtonGroup group;String rtitle="圖書編號","圖書名稱","出 版 社"String btitle=" 確定(Yes)","取消(Esc)"JTextField txtfield=new JTextField3;JButton btn=new JButton2;JDialog dialog;searchresult st;public searchdialog(JFrame f,int x,int y)/初始化單選按鈕group=new Butto

21、nGroup();st=new searchresult();for(int i=0;i<radio.length;i+)radioi=new JRadioButton(rtitlei);radioi.addActionListener(this);radioi.setFont(new Font("宋體",Font.PLAIN ,15);radioi.addItemListener(this);group.add(radioi);txtfieldi=new JTextField();txtfieldi.setEditable(false);for(int i=0;i&

22、lt;2;i+)btni=new JButton(btitlei);btni.addActionListener(this);btni.setFont(new Font("宋體",Font.PLAIN ,15);dialog =new JDialog(f,"查詢",true); /初始化radio0.setSelected(true);txtfield0.setEditable(true );dialog.setLocation(x,y);dialog.setLayout(null);/設(shè)定各個組件的邊界radio0.setBounds(10,10,90

23、,25);txtfield0.setBounds(110,10,250,25);radio1.setBounds(10,45,90,25);txtfield1.setBounds(110,45,250,25);radio2.setBounds(10,80,90,25);txtfield2.setBounds(110,80,250,25);for(int i=0;i<radio.length ;i+)dialog.add(radioi);dialog.add(txtfieldi);btn0.setBounds(20,135,120,25);btn1.setBounds(200,135,12

24、0,25);dialog.add(btn0);dialog.add(btn1);dialog.setSize(400,250);dialog.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE );public void actionPerformed(ActionEvent e)if(e.getSource()=btn0) st.init();Connection con=dbcon.getconnectin();PreparedStatement stmt=null;ResultSet rs=null;LinkedList list=new L

25、inkedList();try if(radio0.isSelected()stmt=con.prepareStatement("select * from book where bid like '%"+txtfield0.getText().trim()+"%'");if(radio1.isSelected()stmt=con.prepareStatement("select * from book where bname like '%"+txtfield1.getText().trim()+"

26、%'");if(radio2.isSelected()stmt=con.prepareStatement("select * from book where bpublish like '%"+txtfield2.getText().trim()+"%'"); rs=stmt.executeQuery(); while(rs.next() String id=rs.getString(1); String name=rs.getString(2); String price=rs.getString(3); String

27、 publish=rs.getString(4); book b=new book(id,name,Float.valueOf(price),publish); list.add(b); for(int i=0;i<list.size();i+) book b=(book)list.get(i); Object ob=b.getid(),b.getname(),b.getprice(),b.getpublish(); st.model.addRow(ob); JOptionPane.showMessageDialog(null,"總共找到"+list.size()+&

28、quot;條記錄!","信息",JOptionPane.INFORMATION_MESSAGE ); st.show(); catch (SQLException e1) / TODO Auto-generated catch blocke1.printStackTrace();public void itemStateChanged(ItemEvent e)for(int i=0;i<radio.length;i+)if(radioi.isSelected()txtfieldi.setEditable(true);else txtfieldi.setEdi

29、table(false);查找結(jié)果package bookmanager;import javax.swing.*;import javax.swing.table.DefaultTableModel;import java.awt.*;import java.awt.event.*;public class searchresult extends JFrame implements ActionListenerJTable table;DefaultTableModel model;String rtitle="圖書編號","圖書名稱","

30、單價","出 版 社"JDialog dialog;public searchresult()super("查詢結(jié)果");model=new DefaultTableModel(rtitle,0);table=new JTable(model);add(new JScrollPane(table),BorderLayout.CENTER );table.setRowHeight(25);table.setFont(new Font("楷體",Font.PLAIN ,18);setSize(600,400);public vo

31、id init()model.setRowCount(0);public void actionPerformed(ActionEvent e)/以后擴展用，暫不實現(xiàn)任何功能*數(shù)據(jù)庫連接類package bookmanager;import java.io.*;import .URL;import java.sql.*;import javax.swing.JOptionPane;public class dbcon public final static Connection getconnectin()Connection con=null;tryClass.forName("c

32、om.microsoft.sqlserver.jdbc.SQLServerDriver");String url="jdbc:sqlserver:/localhost:1433;integratedSecurity=true;"con=DriverManager.getConnection(url);con.setCatalog("book");catch(ClassNotFoundException ex)ex.printStackTrace();catch(SQLException ex)ex.printStackTrace();retur

33、n con;/添加數(shù)據(jù)public final static void insert(Connection con,Object obj)PreparedStatement stmt=null;try stmt=con.prepareStatement("insert into book values(?,?,?,?)");stmt.setString(1,obj0.toString();stmt.setString(2,obj1.toString();stmt.setFloat(3,Float.valueOf(obj2.toString();stmt.setString(4,obj3.toString();stmt.execute();JOptionPane.showMessageDialog(null,"添加成功!","操作提示",JOptionPane.NO_OPTION ); catch (SQLException e) JOptionPane.showMessageDialog(null,"添