dmoney.java~10~

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

package jxm;

import java.awt.*;
import javax.swing.table.DefaultTableModel;
import java.sql.*;
import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.Vector;
import java.beans.PropertyChangeEvent;
import java.beans.PropertyChangeListener;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Dmoney extends JDialog {
    JPanel panel1 = new JPanel();
    JComboBox jComboBox1 = new JComboBox();
    JLabel jLabel1 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JTextField jTextField2 = new JTextField();
    JTextField jTextField3 = new JTextField();
    JLabel jLabel3 = new JLabel();
    JButton jButton1 = new JButton();
    JScrollPane jScrollPane1 = new JScrollPane();
    DefaultTableModel df = new DefaultTableModel();
    JTable jTable1 = new JTable(df);
    JLabel jLabel2 = new JLabel();
    public Dmoney(Frame owner, String title, boolean modal) {
        super(owner, title, modal);
        try {
            setDefaultCloseOperation(DISPOSE_ON_CLOSE);
            jbInit();
            pack();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public Dmoney() {
        this(new Frame(), "Dmoney", false);
    }

    private void jbInit() throws Exception {
        panel1.setLayout(null);
        jComboBox1.setBounds(new Rectangle(3, 4, 133, 23));
        jComboBox1.addActionListener(new Dmoney_jComboBox1_actionAdapter(this));

        jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jLabel1.setText("总收入");
        jLabel1.setBounds(new Rectangle(334, 36, 37, 25));
        jTextField1.setText("");

        jTextField1.setBounds(new Rectangle(374, 35, 82, 26));
        jTextField2.setText("");
        jTextField2.setBounds(new Rectangle(3, 38, 134, 23));
        jTextField3.setText("");
        jTextField3.setEditable(false);
        jTextField3.setBounds(new Rectangle(175, 37, 134, 25));
        jLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jLabel3.setBounds(new Rectangle(138, 38, 35, 22));
        jButton1.setBounds(new Rectangle(168, 5, 65, 23));
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jButton1.setText("查询");
        jButton1.addActionListener(new Dmoney_jButton1_actionAdapter(this));
        jScrollPane1.setBounds(new Rectangle(5, 72, 514, 252));
        jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jLabel2.setForeground(new Color(223, 0, 0));
        jLabel2.setBounds(new Rectangle(379, 327, 128, 32));
        getContentPane().add(panel1);
        panel1.add(jComboBox1);
        panel1.add(jTextField2);
        panel1.add(jLabel3);
        panel1.add(jButton1);
        panel1.add(jTextField3);
        panel1.add(jScrollPane1);
        panel1.add(jLabel2);
        panel1.add(jLabel1);
        panel1.add(jTextField1);

        jScrollPane1.getViewport().add(jTable1);
        jComboBox1.addItem("<默认>");
        jComboBox1.addItem("图书名");
        jComboBox1.addItem("时间");
        df.addColumn("图书名");
        df.addColumn("图书编号");
        df.addColumn("读者");
        df.addColumn("租金");
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        df.setRowCount(0);
        String str = "";
        String str1 = "";
        if (jComboBox1.getItemAt(jComboBox1.getSelectedIndex()).equals("时间")) {
            str = "select j.bookid,b.bname,d.dnum,j.zumoney from jhbook as j inner join books as b on(j.bookid=b.bnum)inner join duze as d on(j.userid = d.dnum) where j.starttime between '" +
                  jTextField2.getText().trim() + "'and '" +
                  jTextField3.getText().trim() + "' and j.zumoney is not null";
            str1 = "select sum(zumoney) from jhbook where starttime between '" +
                   jTextField2.getText().trim() + "'and'" +
                   jTextField3.getText().trim() + "'";
            //  jLabel3.setText("至");
        } else if (jComboBox1.getItemAt(jComboBox1.getSelectedIndex()).equals(
                "图书名")) {
            str = "select j.bookid,b.bname,d.dnum,j.zumoney from jhbook as j inner join books as b on(j.bookid=b.bnum) inner join duze as d on(j.userid=d.dnum)where b.bname='" +
                  jTextField2.getText().trim() + "' and j.zumoney is not null";
            str1 = "select sum(j.zumoney) from jhbook as j inner join books as b on(j.bookid=b.bnum) where b.bname='" +
                   jTextField2.getText().trim() + "'";
        } else {
            str = "select j.bookid,b.bname,d.dnum,j.zumoney from jhbook as j inner join books as b on(j.bookid=b.bnum) inner join duze as d on(j.userid=d.dnum)";
            str1 = "select sum(j.zumoney) from jhbook as j inner join books as b on(j.bookid=b.bnum)";
        }
        cons con = new cons();
        Vector ve = new Vector();
        ResultSet rs = null;
        rs = con.getrs(str1);
        ve = con.getmoney(str);
        try {
            if (rs.next()) {
                jTextField1.setText(rs.getString(1));
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        jLabel2.setText("共" + ve.size() + "条记录");
        for (int i = 0; i < ve.size(); i++) {
            jbmoney j = new jbmoney();
            j = (jbmoney) ve.get(i);
            df.addRow(getv(j));
        }
    }

    public Vector getv(jbmoney j) {
        Vector ve = new Vector();
        ve.add(j.getBookid());
        ve.add(j.getBname());
        ve.add(j.getDname());
        ve.add(j.getZumoney());
        return ve;
    }

    public void jComboBox1_actionPerformed(ActionEvent e) {
        if (jComboBox1.getItemAt(jComboBox1.getSelectedIndex()).equals("时间")) {
            jTextField2.setText("2007-7-9");
            jTextField3.setText("2008-1-1");
            jLabel3.setText("至");
            jTextField3.setEditable(true);
        } else {
            jTextField2.setText("");
            jTextField3.setText("");
            jLabel3.setText("");
            jTextField3.setEditable(false);

        }
    }


}


class Dmoney_jComboBox1_actionAdapter implements ActionListener {
    private Dmoney adaptee;
    Dmoney_jComboBox1_actionAdapter(Dmoney adaptee) {
        this.adaptee = adaptee;
    }

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


class Dmoney_jButton1_actionAdapter implements ActionListener {
    private Dmoney adaptee;
    Dmoney_jButton1_actionAdapter(Dmoney adaptee) {
        this.adaptee = adaptee;
    }

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