fuser.java~23~

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

package jxm;

import java.awt.*;

import javax.swing.*;
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 Fuser extends JFrame {
    public Fuser() {
        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(9, 10, 134, 27));
        jTextField1.setText("");
        jTextField1.setBounds(new Rectangle(8, 48, 134, 24));
        jButton1.setBounds(new Rectangle(157, 11, 84, 27));
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jButton1.setText("查询");
        jButton1.addActionListener(new Fuser_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(254, 45, 85, 25));
        jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jButton2.setText("添加读者");
        jButton2.addActionListener(new Fuser_jButton2_actionAdapter(this));
        jButton3.setBounds(new Rectangle(254, 11, 84, 26));
        jButton3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jButton3.setText("更改资料");
        jButton3.addActionListener(new Fuser_jButton3_actionAdapter(this));
        jButton4.setBounds(new Rectangle(157, 46, 83, 24));
        jButton4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jButton4.setText("删除");
        jButton4.addActionListener(new Fuser_jButton4_actionAdapter(this));
        jButton5.setBounds(new Rectangle(355, 45, 67, 25));
        jButton5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jButton5.setText("退出");
        jButton5.addActionListener(new Fuser_jButton5_actionAdapter(this));
        this.getContentPane().add(jScrollPane1);
        this.getContentPane().add(jComboBox1);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jButton4);
        this.getContentPane().add(jButton3);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jButton5);
        jScrollPane1.getViewport().add(jTable1);
        jScrollPane1.setBounds(new Rectangle(4, 88, 514, 305));
        jComboBox1.addItem("<默认>");
        jComboBox1.addItem("读者编号");
        jComboBox1.addItem("读者姓名");
        jComboBox1.addItem("性别");
        jComboBox1.addItem("联系电话");
        jComboBox1.addItem("地址");
        df.addColumn("读者编号");
        df.addColumn("读者姓名");
        df.addColumn("性别");
        df.addColumn("联系电话");
        df.addColumn("地址");
        dispaly();

    }

    JScrollPane jScrollPane1 = new JScrollPane();
    DefaultTableModel df = new DefaultTableModel();
    JTable jTable1 = new JTable(df);
    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();
    cons con = new cons();
    public void jButton3_actionPerformed(ActionEvent e) {
        //  Vector ve = new Vector();

        int i = jTable1.getSelectedRow();
        if (i != -1) {
            String st = String.valueOf(jTable1.getValueAt(i, 0));
            String str = "select * from duze where dnum='" + st + "'";

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

            try {
                if (ve.size() > 0) {
                    j = (jbuser) ve.get(0);
                    ve = getvebao(j);
                    Dadduser fadd = new Dadduser(ve);
                    fadd.setSize(431, 309);
                    fadd.setLocation(250, 90);
                    fadd.show();
                }
            } catch (Exception ex) {
                System.out.println(ex);
            }

        }

    }

    public Vector getvebao(jbuser j) {
        Vector ve = new Vector();
        ve.add(j.getDnum());
        ve.add(j.getDname());
        ve.add(j.getDsex());
        ve.add(j.getDdh());
        ve.add(j.getDaddress());
        return ve;
    }


    public void jButton2_actionPerformed(ActionEvent e) {
        Dadduser fadd = new Dadduser();
        fadd.setSize(431, 309);
        fadd.setLocation(250, 90);
        fadd.show();
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        df.setRowCount(0);
        String str = "select * from duze where " + getstr() + "='" +
                     jTextField1.getText() + "'";
        if (jComboBox1.getItemAt(jComboBox1.getSelectedIndex()).equals("<默认>")) {
            str = "select * from duze";
            jTextField1.setText("");
        }
        Vector ve = new Vector();
        ve = con.getuserve(str);
        for (int i = 0; i < ve.size(); i++) {
            jbuser j = new jbuser();
            j = (jbuser) ve.get(i);
            df.addRow(getv(j));
        }
    }

    public Vector getv(jbuser j) {
        Vector ve = new Vector();
        ve.add(j.getDnum());
        ve.add(j.getDname());
        ve.add(j.getDsex());
        ve.add(j.getDdh());
        ve.add(j.getDaddress());

        return ve;
    }

    public void dispaly() {

        Vector ve = con.getuserve("select * from duze");
        jbuser j;
        for (int i = 0; i < ve.size(); i++) {
            j = (jbuser) ve.get(i);
            df.addRow(getv(j));
        }

    }

    public String getstr() {

        if (jComboBox1.getSelectedItem().equals("读者编号")) {
            return "dnum";
        } else if (jComboBox1.getSelectedItem().equals("读者姓名")) {
            return "dname";
        } else if (jComboBox1.getSelectedItem().equals("性别")) {
            return "dsex";
        } else if (jComboBox1.getSelectedItem().equals("联系电话")) {
            return "ddh";
        } else if (jComboBox1.getSelectedItem().equals("地址")) {
            return "daddress";
        } else {
            return "";
        }
    }

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

            for (int i = 0; i < num.length; i++) {
                str = String.valueOf(jTable1.getValueAt(num[i], 0));
                String str1 = "delete jhbook where userid='" + str + "'";
                String str2 = "delete duze where dnum='" + str + "'";
                if (con.getblcc(str1) && con.getblcc(str2)) {
                    ii = 1;

                } else if (con.getblcc(str2)) {
                    ii = 1;

                } else {
                    ii = 0;
                }

            }
            for (int i = num.length; i > 0; i--) {
                df.removeRow(num[i - 1]);
            }

            if (ii == 1) {
                JOptionPane.showMessageDialog(this, "资料已删除", "删除成功",
                                              JOptionPane.
                                              INFORMATION_MESSAGE);

            } else {
                JOptionPane.showMessageDialog(this, "删除失败", "错误",
                                              JOptionPane.ERROR_MESSAGE);
            }
        }
    }

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


class Fuser_jButton5_actionAdapter implements ActionListener {
    private Fuser adaptee;
    Fuser_jButton5_actionAdapter(Fuser adaptee) {
        this.adaptee = adaptee;
    }

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


class Fuser_jButton4_actionAdapter implements ActionListener {
    private Fuser adaptee;
    Fuser_jButton4_actionAdapter(Fuser adaptee) {
        this.adaptee = adaptee;
    }

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


class Fuser_jButton1_actionAdapter implements ActionListener {
    private Fuser adaptee;
    Fuser_jButton1_actionAdapter(Fuser adaptee) {
        this.adaptee = adaptee;
    }

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


class Fuser_jButton2_actionAdapter implements ActionListener {
    private Fuser adaptee;
    Fuser_jButton2_actionAdapter(Fuser adaptee) {
        this.adaptee = adaptee;
    }

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


class Fuser_jButton3_actionAdapter implements ActionListener {
    private Fuser adaptee;
    Fuser_jButton3_actionAdapter(Fuser adaptee) {
        this.adaptee = adaptee;
    }

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