bookadmin.java~87~

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

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.sql.*;
import java.util.Vector;
import javax.swing.JOptionPane;

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

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jComboBox1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jComboBox1.setBounds(new Rectangle(14, 15, 161, 29));
        jButton1.setBounds(new Rectangle(198, 11, 119, 38));
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jButton1.setText("查询");
        jButton1.addActionListener(new bookadmin_jButton1_actionAdapter(this));
        jButton2.addActionListener(new bookadmin_jButton2_actionAdapter(this));
        jButton3.addActionListener(new bookadmin_jButton3_actionAdapter(this));
        jButton5.addActionListener(new bookadmin_jButton5_actionAdapter(this));
        jButton4.addActionListener(new bookadmin_jButton4_actionAdapter(this));
        this.getContentPane().add(jTextField1);
        jScrollPane1.setBounds(new Rectangle(14, 108, 807, 449));
        jButton5.setBounds(new Rectangle(469, 62, 91, 37));
        jButton5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jButton5.setText("退出");
        jButton4.setBounds(new Rectangle(334, 62, 121, 36));
        jButton4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jButton4.setText("清理删除");
        jButton3.setBounds(new Rectangle(333, 11, 122, 36));
        jButton3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jButton3.setText("更改信息");
        jButton2.setBounds(new Rectangle(197, 62, 120, 37));
        jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jButton2.setText("进书");
        this.getContentPane().add(jComboBox1);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jButton3);
        this.getContentPane().add(jButton4);
        this.getContentPane().add(jButton5);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jScrollPane1);
        jScrollPane1.getViewport().add(jTable1);
        jTextField1.setText("jTextField1");
        jTextField1.setBounds(new Rectangle(14, 68, 162, 27));
        df.addColumn("编号");
        df.addColumn("书名");
        df.addColumn("作者");
        df.addColumn("出版社");
        df.addColumn("页数");
        df.addColumn("书价");
        df.addColumn("类型");
        df.addColumn("存放位置");
        df.addColumn("状态");
        jComboBox1.addItem("书名");
        jComboBox1.addItem("类型");
        jComboBox1.addItem("编号");
        jComboBox1.addItem("作者");
        jComboBox1.addItem("出版社");
        jComboBox1.addItem("存放位置");
        jComboBox1.addItem("状态");

        display();

    }

    JComboBox jComboBox1 = new JComboBox();
    JTextField jTextField1 = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JButton jButton4 = new JButton();
    JButton jButton5 = new JButton();
    JScrollPane jScrollPane1 = new JScrollPane();
    DefaultTableModel df = new DefaultTableModel();
    JTable jTable1 = new JTable(df);
    cons con = new cons();
    public void jButton2_actionPerformed(ActionEvent e) {
        F4upbook f3b = new F4upbook();
        f3b.setSize(500, 400);
        f3b.setLocation(250, 90);
        f3b.show();
    }


    public void jButton3_actionPerformed(ActionEvent e) { //updata
        //  cons con = new cons();
        int i = jTable1.getSelectedRow();
        if (i != -1) {
            String st = String.valueOf(jTable1.getValueAt(i, 0));
            String str = "select * from books where bnum='" + st + "'";

            Vector ve = con.getbookve(str);
            jbbooks j = new jbbooks();

            try {
                if (ve.size() > 0) {
                    j = (jbbooks) ve.get(0);
                    ve = getvebao(j);
                    F4upbook f4b = new F4upbook(ve);
                    f4b.setSize(500, 400);
                    f4b.setLocation(250, 90);

                    f4b.show();
                }
            } catch (Exception ex) {
                System.out.println(ex);
            }

        }
    }

    public void jButton5_actionPerformed(ActionEvent e) { //退出
        this.dispose();
    }

    public void display() {
        String str = "select * from books";
        //  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 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.getBpage());
        ve.add(j.getBprice());
        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();
        Vector ve = new Vector();
        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));

            }
        }
    }

    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 "bzt";
            } else if (s.equals("存放位置")) {
                return "baddress";
            }
        }
        return "";
    }

    public void jButton4_actionPerformed(ActionEvent e) {
        int j;
        j = JOptionPane.showConfirmDialog(this, "你正在试图删除数据\n数据将永久删除", "是否确认",
                                          JOptionPane.INFORMATION_MESSAGE);
        if (j == 0) {
            int num[] = jTable1.getSelectedRows();

            if (num.length > 0) {
                String st;
                String str;
                String s;
                String ss;
                int ii = 0;
                String str2;
                int nums = num.length;
                for (int i = 0; i < num.length; i++) {
                    str2 =
                            "update bookzt set zmount=zmount-1,ymount=ymount-1 where bname='" +
                            String.valueOf(jTable1.getValueAt(num[i], 1)) + "'";
                    st = String.valueOf(jTable1.getValueAt(num[i], 0));
                    str = "delete books where bnum='" + st + "'";
                    s = "delete jhbook where bookid='" + st + "'";
                    ss = "select * from jhbook";
                    if (con.getbl(ss)) {
                        if (con.getblcc(s)) {
                            ii = 1;
                        } else {
                            break;
                        }
                    }
                    if (con.getblcc(str) && con.getblcc(str2)) {
                        String s1 = "select zmount from bookzt where bname='" +
                                    String.valueOf(jTable1.getValueAt(num[i], 1)) +
                                    "'";
                        String s2 = "delete bookzt where bname='" +
                                    String.valueOf(jTable1.getValueAt(num[i], 1)) +
                                    "'";
                        System.out.println(s1 + "\n" + s2);
                        ResultSet rs = null;
                        rs = con.getrs(s1);
                        try {
                            if (rs.next()) {
                                int ee = rs.getInt(1);
                                System.out.println();
                                if (ee == 0) {
                                    if (con.getblcc(s2)) {
                                        ii = 1;
                                    }
                                }
                            }
                        } catch (SQLException ex) {
                            System.out.println(ex);
                        }
                        ii = 1;
                    }

                } //end for()
                for (int i = nums; i > 0; i--) {
                    df.removeRow(num[i - 1]);
                }
                if (ii == 1) {
                    JOptionPane.showMessageDialog(this, "资料已更新", "删除成功",
                                                  JOptionPane.
                                                  INFORMATION_MESSAGE);
                } else {
                    JOptionPane.showMessageDialog(this, "删除失败", "错误",
                                                  JOptionPane.ERROR_MESSAGE);
                } //end  if (ii == 1)
            } //end if(num.length > 0)
        } //end if1
    }
}


class bookadmin_jButton4_actionAdapter implements ActionListener {
    private bookadmin adaptee;
    bookadmin_jButton4_actionAdapter(bookadmin adaptee) {
        this.adaptee = adaptee;
    }

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


class bookadmin_jButton1_actionAdapter implements ActionListener {
    private bookadmin adaptee;
    bookadmin_jButton1_actionAdapter(bookadmin adaptee) {
        this.adaptee = adaptee;
    }

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


class bookadmin_jButton5_actionAdapter implements ActionListener {
    private bookadmin adaptee;
    bookadmin_jButton5_actionAdapter(bookadmin adaptee) {
        this.adaptee = adaptee;
    }

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


class bookadmin_jButton3_actionAdapter implements ActionListener {
    private bookadmin adaptee;
    bookadmin_jButton3_actionAdapter(bookadmin adaptee) {
        this.adaptee = adaptee;
    }

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


class bookadmin_jButton2_actionAdapter implements ActionListener {
    private bookadmin adaptee;
    bookadmin_jButton2_actionAdapter(bookadmin adaptee) {
        this.adaptee = adaptee;
    }

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