frbookmanage.java~17~

用java编写的实现图书管理系统系统的功能

package mybook.book;

import java.awt.*;

import javax.swing.*;
import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.sql.ResultSet;
import mydbc.dbc.DBC;
import java.sql.SQLException;
import java.awt.event.ActionListener;
import java.awt.Rectangle;
import java.io.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class FrBookmanage extends JFrame {
    public FrBookmanage() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        setSize(new Dimension(651, 588));
        this.setTitle("图书管理");
        lblFind.setText("按");
        lblFind.setBounds(new Rectangle(18, 16, 18, 15));
        cbWay.setBounds(new Rectangle(38, 12, 77, 23));
        lblFindit.setText("查找");
        lblFindit.setBounds(new Rectangle(120, 15, 28, 15));
        btnFind.setBounds(new Rectangle(156, 13, 66, 53));
        btnFind.setText("查找");
        btnFind.addActionListener(new FrBookmanage_btnFind_actionAdapter(this));
        txtWay.setBounds(new Rectangle(38, 46, 77, 21));
        btnDelete.setBounds(new Rectangle(341, 13, 66, 53));
        btnDelete.setText("删除");
        btnFlush.setBounds(new Rectangle(433, 13, 66, 53));
        btnFlush.setText("刷新");
        btnExit.setBounds(new Rectangle(525, 13, 66, 53));
        btnExit.setText("关闭");
        btnExit.addActionListener(new FrBookmanage_btnExit_actionAdapter(this));
        btnEdit.setBounds(new Rectangle(248, 13, 66, 53));
        btnEdit.setText("修改");
        jScrollPane1.setBounds(new Rectangle(14, 84, 590, 454));
        this.getContentPane().add(lblFind);
        this.getContentPane().add(cbWay);
        this.getContentPane().add(lblFindit);
        this.getContentPane().add(txtWay);
        this.getContentPane().add(btnFind);
        this.getContentPane().add(btnEdit);
        this.getContentPane().add(btnDelete);
        this.getContentPane().add(btnFlush);
        this.getContentPane().add(btnExit);
        this.getContentPane().add(jScrollPane1);
        jScrollPane1.getViewport().add(jTable1);
        cbWay.addItem("编号");
        cbWay.addItem("书名");
        cbWay.addItem("类别");
        cbWay.addItem("作者");
        cbWay.addItem("价格");
        cbWay.addItem("出版社");
        this.Show();
    }

    JLabel lblFind = new JLabel();
    JComboBox cbWay = new JComboBox();
    JLabel lblFindit = new JLabel();
    JButton btnFind = new JButton();
    JTextField txtWay = new JTextField();
    JButton btnDelete = new JButton();
    JButton btnFlush = new JButton();
    JButton btnExit = new JButton();
    JButton btnEdit = new JButton();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTable jTable1 = new JTable();
    public void btnExit_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }
    public void Show() {
                DBC dbc = DBC.getInstance();
                int count = 0;
                ResultSet rs = dbc.executeQuery("SELECT * FROM Books WHERE Bid = 1");
                try {
                    while(rs.next()){
                        count++;
                    }
                    rs.close();
                    Object[][] cells = new Object[count][8];
                int i = 0;
                rs = dbc.executeQuery("SELECT * FROM Books WHERE Bid = 1");
                while (rs.next()) {

                    cells[i] = new Object[] {rs.getInt(1),
                               rs.getString(2), rs.getString(3),
                               rs.getString(4), rs.getString(5),
                               rs.getString(6), rs.getString(7),rs.getString(8)};
                    i++;
                }
                String[] colnames = {"编号", "书名", "简介", "类型", "出版社", "库存量", "单价","作者"};
                jTable1 = new JTable(cells, colnames);
                jScrollPane1.getViewport().add(jTable1);

                } catch (SQLException ex) {
                    javax.swing.JOptionPane.showMessageDialog(this,ex.getMessage().toString());
                }
        }
    public void btnFind_actionPerformed(ActionEvent e) {

    }


    class FrBookmanage_btnExit_actionAdapter implements ActionListener {
        private FrBookmanage adaptee;
        FrBookmanage_btnExit_actionAdapter(FrBookmanage adaptee) {
            this.adaptee = adaptee;
        }

        public void actionPerformed(ActionEvent e) {
            adaptee.btnExit_actionPerformed(e);
        }
    }
}


class FrBookmanage_btnFind_actionAdapter implements ActionListener {
    private FrBookmanage adaptee;
    FrBookmanage_btnFind_actionAdapter(FrBookmanage adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnFind_actionPerformed(e);
    }
}