buy_history.java~10~

来自「使用Java语言开发的数据库课程设计——医药管理信息系统。」· JAVA~10~ 代码 · 共 214 行

import java.awt.*;

import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.Font;
import javax.swing.BorderFactory;
import java.awt.Insets;
import java.awt.Color;
import javax.swing.table.DefaultTableModel;
import java.util.Vector;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.SQLException;
import java.awt.event.WindowEvent;
import java.awt.event.WindowAdapter;

public class Buy_history extends JFrame
{
    BorderLayout borderLayout1 = new BorderLayout();
    JPanel jPanel1 = new JPanel();
    JPanel jPanel2 = new JPanel();
    BorderLayout borderLayout2 = new BorderLayout();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTable jTable1 = new JTable();
    JLabel jLabel1 = new JLabel();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    String Driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
    String conURL =
            "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=CASY";
    String Username = "sa";
    String Password = "111111";
    String Order = null;
    Vector header = null;
    Vector data = null;
    DefaultTableModel tableModel1 = null;

    public Buy_history()
    {
        this.setTitle("历史采购明细");
        this.setSize(500, 300);
        this.setVisible(true);
        this.setResizable(false);
        this.addWindowListener(new WindowAdapter()
        {
            public void windowClosing(WindowEvent e)
            {
                new mainWin();
                dispose();
            }
        });
        new Set_center();

        new Load_DB_Driver();
        try
        {
            jbInit();
            this.validate();
        }
        catch (Exception exception)
        {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception
    {
        getContentPane().setLayout(borderLayout1);
        jButton1.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        jButton1.setMargin(new Insets(5, 18, 5, 18));
        jButton1.addActionListener(new Buy_history_jButton1_actionAdapter(this));
        jButton2.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        jButton2.setMargin(new Insets(5, 14, 5, 14));
        jButton2.setText("订购日期");
        jButton2.addActionListener(new Buy_history_jButton2_actionAdapter(this));
        jButton3.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        jButton3.setMargin(new Insets(5, 18, 5, 18));
        jButton3.setText("供应商");
        jButton3.addActionListener(new Buy_history_jButton3_actionAdapter(this));
        jPanel2.setBorder(BorderFactory.createLoweredBevelBorder());
        jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
        this.getContentPane().add(jPanel1, java.awt.BorderLayout.CENTER);
        jScrollPane1.getViewport().add(jTable1);
        jScrollPane1.setHorizontalScrollBarPolicy(JScrollPane.
                                                  HORIZONTAL_SCROLLBAR_ALWAYS);
        jLabel1.setFont(new java.awt.Font("宋体", Font.BOLD, 14));
        jLabel1.setBorder(null);
        jLabel1.setText("排序:");
        jButton1.setText("订单号");
        jPanel1.setLayout(borderLayout2);
        jPanel2.setBackground(new Color(236, 233, 173));
        jPanel2.setMinimumSize(new Dimension(10, 40));
        jPanel2.setPreferredSize(new Dimension(10, 45));
        this.getContentPane().add(jPanel2, java.awt.BorderLayout.SOUTH);
        jPanel2.add(jLabel1);
        jPanel2.add(jButton1);
        jPanel2.add(jButton2);
        jPanel2.add(jButton3);
        jPanel1.add(jScrollPane1, java.awt.BorderLayout.CENTER);
        init_table();
        String sql = "select * from Medicine_Buy";
        add_table_data(sql);
        jPanel1.validate();
        jPanel2.validate();
    }

    public void init_table()
    {
        header = new Vector();
        header.addElement("订单号");
        header.addElement("药品编号");
        header.addElement("药品名称");
        header.addElement("入库数量");
        header.addElement("供应商");
        header.addElement("订购日期");
        tableModel1 = new DefaultTableModel(header, 0);
        jTable1.setModel(tableModel1);
        for (int i = 0; i < 6; i++)
            jTable1.getColumnModel().getColumn(i).setPreferredWidth(100);
    }

    public void add_table_data(String Order) {
        try {
            Connection con = DriverManager.getConnection(conURL, Username,
                    Password);
            Statement s = con.createStatement();
            ResultSet rs = s.executeQuery(Order);
            while (rs.next()) {
                data = new Vector();
                data.addElement(rs.getString(1));
                data.addElement(rs.getString(2));
                data.addElement(rs.getString(3));
                data.addElement(rs.getString(4));
                data.addElement(rs.getString(5));
                data.addElement(rs.getString(6));
                tableModel1.addRow(data);
            }
            jTable1.setModel(tableModel1);
            rs.close();
            con.close();
        } catch (SQLException ex) {
            JOptionPane.showMessageDialog(null, "SQLException:" + ex.getMessage(),
                                          "警告!", JOptionPane.WARNING_MESSAGE);
        }
    }

    public static void main(String[] args) {
        new Buy_history();
    }

    public void jButton1_actionPerformed(ActionEvent e)
    {
        init_table();
        Order = "select * from Medicine_Buy order by 订单号";
        add_table_data(Order);
    }

    public void jButton2_actionPerformed(ActionEvent e)
    {
        init_table();
        Order = "select * from Medicine_Buy order by 订购日期";
        add_table_data(Order);
    }

    public void jButton3_actionPerformed(ActionEvent e)
    {
        init_table();
        Order = "select * from Medicine_Buy order by 供应商";
        add_table_data(Order);
    }
}


class Buy_history_jButton3_actionAdapter implements ActionListener {
    private Buy_history adaptee;
    Buy_history_jButton3_actionAdapter(Buy_history adaptee) {
        this.adaptee = adaptee;
    }

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


class Buy_history_jButton2_actionAdapter implements ActionListener {
    private Buy_history adaptee;
    Buy_history_jButton2_actionAdapter(Buy_history adaptee) {
        this.adaptee = adaptee;
    }

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


class Buy_history_jButton1_actionAdapter implements ActionListener {
    private Buy_history adaptee;
    Buy_history_jButton1_actionAdapter(Buy_history adaptee) {
        this.adaptee = adaptee;
    }

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