frame3.java~14~

图书管理 问题描述：图书管理基本业务活动包括对一本书的采编入库、清除库存、借阅和归还等等。将上述业务活动借助于计算机系统完成。

package jxm;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JComboBox;
import java.awt.*;
import javax.swing.JTextField;
import javax.swing.JButton;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.Vector;

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

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jTextField1.setText("");
        jTextField1.setBounds(new Rectangle(11, 53, 142, 32));
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jButton1.addActionListener(new Frame3_jButton1_actionAdapter(this));
        jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jButton2.addActionListener(new Frame3_jButton2_actionAdapter(this));
        jButton3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jButton3.addActionListener(new Frame3_jButton3_actionAdapter(this));
        jTable1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jComboBox1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        this.getContentPane().add(jTextField1);
        jScrollPane1.setBounds(new Rectangle(11, 108, 824, 440));
        jButton3.setBounds(new Rectangle(275, 52, 59, 37));
        jButton3.setText("退出");
        jButton2.setBounds(new Rectangle(166, 53, 96, 36));
        jButton2.setText("借书");
        jButton1.setBounds(new Rectangle(166, 8, 95, 37));
        jButton1.setText("借书查询");
        this.getContentPane().add(jComboBox1);
        this.getContentPane().add(jScrollPane1);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jButton3);
        jScrollPane1.getViewport().add(jTable1);
        jComboBox1.setBounds(new Rectangle(11, 11, 143, 31));
        jComboBox1.addItem("<默认>");
        jComboBox1.addItem("编号");
        jComboBox1.addItem("书名");
        jComboBox1.addItem("类型");
        jComboBox1.addItem("作者");
        jComboBox1.addItem("出版社");
        jComboBox1.addItem("存放位置");
        df.addColumn("编号");
        df.addColumn("书名");
        df.addColumn("作者");
        df.addColumn("出版社");
        df.addColumn("类型");
        df.addColumn("存放位置");
        df.addColumn("状态");
        dispaly();
    }

    JTextField jTextField1 = new JTextField();
    JComboBox jComboBox1 = new JComboBox();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JScrollPane jScrollPane1 = new JScrollPane();
    DefaultTableModel df = new DefaultTableModel();
    JTable jTable1 = new JTable(df);
    public void jButton3_actionPerformed(ActionEvent e) { //  退出
        this.dispose();
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        int num = jTable1.getSelectedRow();
        System.out.println(num);
        if (num >= 0) {
            jbook jb = new jbook(String.valueOf(jTable1.getValueAt(num, 0)),
                                 String.valueOf(jTable1.getValueAt(num, 1)));
            jb.setSize(500, 400);
            jb.show();
        }
    }

    public void dispaly() {
        String str = "select * from books where bzt='1'";
        cons con = new cons();
        Vector ve = con.getbookve(str);
        jbbooks j;
        for (int i = 0; i < ve.size(); i++) {
            j = new jbbooks();
            j = (jbbooks) ve.get(i);
            df.addRow(getvebao(j));
        }
    }

    public String getst(String s) {
        if (s.equals("")) {
        } else {
            if (s.equals("编号")) {
                return "bnum";
            } else if (s.equals("书名")) {
                return "bname";
            } else if (s.equals("作者")) {
                return "bze";
            } else if (s.equals("出版社")) {
                return "bcbs";
            } else if (s.equals("类型")) {
                return "btype";
            } else if (s.equals("存放位置")) {
                return "baddress";
            }
        }
        return "";
    }

    public Vector getvebao(jbbooks j) {
        Vector ve = new Vector();
        ve.add(j.getBnum());
        ve.add(j.getBname());
        ve.add(j.getBze());
        ve.add(j.getBcbs());
        ve.add(j.getBtype());
        ve.add(j.getBaddress());
        ve.add(j.getBzt());
        return ve;
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        df.setRowCount(0);

        String str = "select * from books where " +
                     getst((String) jComboBox1.getItemAt(jComboBox1.
                getSelectedIndex())) + "='" + jTextField1.getText() +
                     "' and bzt='1'";

        cons con = new cons();
        System.out.println(str);
        Vector ve = new Vector();
        if (jComboBox1.getItemAt(jComboBox1.getSelectedIndex()).equals("<默认>")) {
            str = "select * from books where bzt='1'";
            jTextField1.setText("");
        }
        ve = con.getbookve(str);
        if (ve != null) {

            jbbooks j;
            for (int i = 0; i < ve.size(); i++) {
                j = new jbbooks();
                j = (jbbooks) ve.get(i);
                df.addRow(getvebao(j));

            }
        }

    }

}


class Frame3_jButton1_actionAdapter implements ActionListener {
    private Frame3 adaptee;
    Frame3_jButton1_actionAdapter(Frame3 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame3_jButton2_actionAdapter implements ActionListener {
    private Frame3 adaptee;
    Frame3_jButton2_actionAdapter(Frame3 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame3_jButton3_actionAdapter implements ActionListener {
    private Frame3 adaptee;
    Frame3_jButton3_actionAdapter(Frame3 adaptee) {
        this.adaptee = adaptee;
    }

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