tank/SaleViewyzz.java

package com.view;

import java.awt.Color;
import java.awt.Container;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseEvent;
import java.awt.event.MouseListener;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;

import com.controller.SaleActionyzz;
import com.utils.BackgroundImagelyx;
import com.utils.FrameOptionlyx;
import com.utils.FrameOptionlyx;
import com.utils.MenuBarlyx;
import com.utils.SetTablelyx;

public class SaleViewyzz {
    JFrame main = new JFrame("Car Sale System");
    Container container = main.getContentPane();
    private JScrollPane scrollPane;
    private JButton buttonReset;
    private JButton buttonChange;
    private JButton buttonDel;
    private JButton buttonAdd;
    private JTable table;
    private SaleActionyzz saleAction;

    public SaleViewyzz() {
        // TODO Auto-generated constructor stub
        main.setLayout(null);
        new BackgroundImagelyx(main, container, "SaleBackground.jpg");
        new FrameOptionlyx(main);
        new MenuBarlyx(main);

        // 实例化标签和文本框
        JLabel saleDateJLabel = new JLabel("SaleDate");
        saleDateJLabel.setForeground(Color.green);
        saleDateJLabel.setBounds(75, 350, 100, 20);
        JTextField saleDateField = new JTextField();
        saleDateField.setBounds(175, 350, 100, 20);
        JLabel carTypeJLabel = new JLabel("CarType");
        carTypeJLabel.setForeground(Color.green);
        carTypeJLabel.setBounds(350, 350, 100, 20);
        JTextField carTypeField = new JTextField();
        carTypeField.setBounds(450, 350, 100, 20);
        JLabel colorJLabel = new JLabel("Color");
        colorJLabel.setForeground(Color.green);
        colorJLabel.setBounds(625, 350, 100, 20);
        JTextField colorField = new JTextField();
        colorField.setBounds(725, 350, 100, 20);
        JLabel numberJLabel = new JLabel("Number");
        numberJLabel.setForeground(Color.green);
        numberJLabel.setBounds(150, 400, 125, 20);
        JTextField numberField = new JTextField();
        numberField.setBounds(225, 400, 175, 20);
        JLabel handlerJLabel = new JLabel("Handler");
        handlerJLabel.setForeground(Color.green);
        handlerJLabel.setBounds(500, 400, 125, 20);
        JTextField handlerField = new JTextField();
        handlerField.setBounds(625, 400, 150, 20);

        // 修改输入文字颜色
        saleDateField.setForeground(new Color(12, 239, 34));
        carTypeField.setForeground(new Color(12, 239, 34));
        colorField.setForeground(new Color(12, 239, 34));
        numberField.setForeground(new Color(12, 239, 34));
        handlerField.setForeground(new Color(12, 239, 34));

        // 使文本框透明
        saleDateField.setOpaque(false);
        carTypeField.setOpaque(false);
        colorField.setOpaque(false);
        numberField.setOpaque(false);
        handlerField.setOpaque(false);

        container.add(saleDateJLabel);
        container.add(saleDateField);
        container.add(carTypeJLabel);
        container.add(carTypeField);
        container.add(colorJLabel);
        container.add(colorField);
        container.add(numberJLabel);
        container.add(numberField);
        container.add(handlerJLabel);
        container.add(handlerField);

        // 实例化按钮
        buttonAdd = new JButton("Add");
        buttonAdd.setBounds(100, 480, 100, 20);

        buttonDel = new JButton("Delect");
        buttonDel.setBounds(300, 480, 100, 20);

        buttonChange = new JButton("Change");
        buttonChange.setBounds(500, 480, 100, 20);

        buttonReset = new JButton("Query");
        buttonReset.setBounds(700, 480, 100, 20);

        container.add(buttonAdd);
        container.add(buttonDel);
        container.add(buttonChange);
        container.add(buttonReset);

        saleAction = new SaleActionyzz();
        // 初始化表格
        setTable();
        // 添加按钮监听
        // 添加按钮
        buttonAdd.addActionListener(new ActionListener() {

            @Override
            public void actionPerformed(ActionEvent e) {
                // TODO Auto-generated method stub
                try {
                    saleAction.addSaleInformation(saleDateField, carTypeField, colorField, numberField, handlerField);
                    main.setVisible(false);
                    new SaleViewyzz();
                } catch (Exception e2) {
                    // TODO: handle exception
                }
            }
        });
        // 删除按钮
        buttonDel.addActionListener(new ActionListener() {

            @Override
            public void actionPerformed(ActionEvent e) {
                // TODO Auto-generated method stub
//				System.out.printf(saleDateField.getText()+handlerField.getText());
                try {
                    saleAction.delSaleInformation(saleDateField.getText());
                    main.setVisible(false);
                    new SaleViewyzz();
                } catch (Exception e2) {
                    // TODO: handle exception
                }
            }
        });
        // 修改按钮
        buttonChange.addActionListener(new ActionListener() {

            @Override
            public void actionPerformed(ActionEvent e) {
                // TODO Auto-generated method stub
                try {
                    saleAction.changeSaleInformation(saleDateField, carTypeField, colorField, numberField,
                            handlerField);
                    main.setVisible(false);
                    new SaleViewyzz();
                } catch (Exception e2) {
                    // TODO: handle exception
                }
            }
        });
        // 查询按钮
        buttonReset.addActionListener(new ActionListener() {

            @Override
            public void actionPerformed(ActionEvent e) {
                // TODO Auto-generated method stub
                try {
                    setTable();
                    main.setVisible(false);
                    new SaleViewyzz();
                    JOptionPane.showMessageDialog(null, "数据更新成功", "tips", JOptionPane.PLAIN_MESSAGE);
                } catch (Exception e1) {
                    // TODO: handle exception
                    JOptionPane.showMessageDialog(null, "数据更新失败", "tips", JOptionPane.PLAIN_MESSAGE);
                }
            }
        });
    }

    private void setTable() {
        // TODO Auto-generated method stub
        String[] columnNames = { "销售日期", "轿车类型", "颜色", "数量", "经手人" };
        try {
            SaleActionyzz saleAction = new SaleActionyzz();
            Object[][] results = saleAction.query(columnNames);

            table = new JTable(results, columnNames);
            scrollPane = new JScrollPane(table);
            // 设置表格
            new SetTablelyx(scrollPane, table, columnNames, main);

            table.addMouseListener(new MouseListener() {

                @Override
                public void mouseReleased(MouseEvent e) {
                    // TODO Auto-generated method stub

                }

                @Override
                public void mousePressed(MouseEvent e) {
                    // TODO Auto-generated method stub

                }

                @Override
                public void mouseExited(MouseEvent e) {
                    // TODO Auto-generated method stub

                }

                @Override
                public void mouseEntered(MouseEvent e) {
                    // TODO Auto-generated method stub

                }

                @Override
                public void mouseClicked(MouseEvent e) {
                    // TODO Auto-generated method stub
//					String sale_date, car_type, color, number, handler;
//
//					int selRow = table.getSelectedRow();
//
//					sale_date = table.getValueAt(selRow, 0).toString();
//					car_type = table.getValueAt(selRow, 1).toString();
//					color = table.getValueAt(selRow, 2).toString();
//					number = table.getValueAt(selRow, 3).toString();
//					handler = table.getValueAt(selRow, 4).toString();
//
//					saleDateField.setText(sale_date);
//					carTypeField.setText(car_type);
//					colorField.setText(color);
//					numberField.setText(number);
//					handlerField.setText(handler);
                }
            });
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
}