frame3.java~12~

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

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();

        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() + "'";


               cons con=new cons();
      System.out.println(str);
              Vector ve = new Vector();
              if (jComboBox1.getItemAt(jComboBox1.getSelectedIndex()).equals("<默认>")) {
                  str = "select * from books";
                  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);
    }
}