jf_view_query_kcmx_hk.java

医药进销存管理系统 对医药公司的进销存进行管理

package appjxc.view;

import java.awt.*;

import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Font;
import java.awt.Dimension;
import javax.swing.border.Border;
import java.util.Calendar;
import java.util.Locale;
import javax.swing.event.ChangeEvent;
import javax.swing.event.ChangeListener;
import javax.swing.table.TableColumnModel;
import javax.swing.table.DefaultTableModel;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import appjxc.model.Obj_BuyDetaile;
import appjxc.model.Obj_SellDetaile;
import appjxc.model.Obj_SellMain;

public class JF_view_query_kcmx_hk extends JInternalFrame {
    BorderLayout borderLayout1 = new BorderLayout();
    JPanel jPanel1 = new JPanel();
    GridLayout gridLayout1 = new GridLayout();
    JPanel jPanel2 = new JPanel();
    JPanel jPanel3 = new JPanel();
    FlowLayout flowLayout1 = new FlowLayout();
    JCheckBox jCheckBox1 = new JCheckBox();
    JLabel jLabel1 = new JLabel();
    JComboBox jCid = new JComboBox();
    JComboBox jCysf = new JComboBox();
    JTextField jTvalue = new JTextField();
    JCheckBox jCheckBox2 = new JCheckBox();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel6 = new JLabel();
    FlowLayout flowLayout2 = new FlowLayout();
    Border border1 = BorderFactory.createLineBorder(UIManager.getColor(
            "ToolBar.dockingForeground"), 2);
    Border border2 = BorderFactory.createLineBorder(Color.magenta, 1);
    JButton jByes = new JButton();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTable jTable1 = new JTable();
    JFormattedTextField jFormattedTextField1 = new JFormattedTextField();
    JFormattedTextField jFormattedTextField2 = new JFormattedTextField();
    DefaultTableModel tableModel = null;
    String[] name = {"khbh","hkje"};
    int _idIndex ,_ysfIndex ;
    public JF_view_query_kcmx_hk() {
        _idIndex = 0 ;
        _ysfIndex = 0 ;
        try {
            buildTable();
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    public void setjSpinner(){
    }

    private void jbInit() throws Exception {
        jFormattedTextField1.setEnabled(false);
        jFormattedTextField2.setEnabled(false);
        border1 = BorderFactory.createLineBorder(Color.red, 1);
        jCheckBox1.setSelected(true);
        jCheckBox2.setSelected(false);
        jCysf.addItem("like");
        jCysf.addItem(">");
        jCysf.addItem("<");
        jCysf.addItem(">=");
        jCysf.addItem("<=");

        jCid.addItem("客户编号");
        jCid.addItem("回款金额");
        //jCid.addItem("销售数量");


        getContentPane().setLayout(borderLayout1);
        jCheckBox2.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        jCheckBox2.setToolTipText("");
        jCheckBox2.setText("回款日期");
        jCheckBox2.addChangeListener(new JF_view_query_kcmx_hk_jCheckBox2_changeAdapter(this));
        jLabel2.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        jLabel2.setText("起始日期:");
        jLabel3.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        jLabel3.setText("终止日期:");
        jLabel4.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        jLabel4.setText("运算符:");
        jLabel6.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        jLabel6.setText("数值:");
        flowLayout1.setHgap(8);
        jPanel3.setLayout(flowLayout2);
        flowLayout2.setHgap(8);
        jCheckBox1.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        jLabel1.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        jCid.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        jCid.setPreferredSize(new Dimension(97, 23));
        jCid.addItemListener(new JF_view_query_kcmx_hk_jCid_itemAdapter(this));
        jPanel2.setBorder(border1);
        jPanel3.setBorder(border2);
        jTvalue.setPreferredSize(new Dimension(156, 24));
        jCysf.setPreferredSize(new Dimension(53, 23));
        jCysf.addItemListener(new JF_view_query_kcmx_hk_jCysf_itemAdapter(this));
        jByes.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        jByes.setText("查询");
        jByes.addActionListener(new JF_view_query_kcmx_hk_jByes_actionAdapter(this));
        jFormattedTextField1.setPreferredSize(new Dimension(139, 24));
        jFormattedTextField2.setPreferredSize(new Dimension(139, 24));
        this.setClosable(true);
        this.getContentPane().add(jPanel1, java.awt.BorderLayout.NORTH);
        jPanel2.setLayout(flowLayout1);
        jCheckBox1.setText("查询条件");
        jLabel1.setText("选择字段:");
        jPanel1.add(jPanel2);
        jPanel2.add(jCheckBox1);
        jPanel2.add(jLabel1);
        jPanel2.add(jCid);
        jPanel2.add(jLabel4);
        jPanel2.add(jCysf);
        jPanel2.add(jLabel6);
        jPanel2.add(jTvalue);

        jPanel1.add(jPanel3);
        jPanel3.add(jCheckBox2);
        jPanel3.add(jLabel2);
        jPanel3.add(jFormattedTextField1);
        jPanel3.add(jLabel3);
        jPanel3.add(jFormattedTextField2);
        jPanel3.add(jByes);
        this.getContentPane().add(jScrollPane1, java.awt.BorderLayout.CENTER);
        jScrollPane1.getViewport().add(jTable1);
        gridLayout1.setColumns(1);
        gridLayout1.setRows(2);
        jPanel1.setLayout(gridLayout1);

        this.setSize(750,550);
        this.setVisible(true);
        UIManager.setLookAndFeel("javax.swing.plaf.metal.MetalLookAndFeel");
        SwingUtilities.updateComponentTreeUI(this);
    }
    public void buildTable(){//"药品名称","药品批号","规格","产地","单位",,"零售价","有效期至"
        String[] tname = {"销售单据号","客户编号","销售金额","销售数量","实收金额","回款金额","回款日期"};
        java.util.Vector vname = new java.util.Vector();
        for (int i = 0 ; i < tname.length ; i++){
            vname.addElement(tname[i]);
        }
        tableModel = new DefaultTableModel(vname,0);
        jTable1.setModel(tableModel);
        TableColumnModel tcm = jTable1.getColumnModel();

    }

    public static void main(String[] args) {
        JF_view_query_kcmx_hk jf_query_view = new JF_view_query_kcmx_hk();
    }

    public void jCheckBox2_stateChanged(ChangeEvent e) {
        if(jCheckBox2.isSelected()){
            jFormattedTextField1.setEnabled(true);
            jFormattedTextField2.setEnabled(true);
            long nCurrentTime = System.currentTimeMillis();
            java.util.Calendar calendar = java.util.Calendar.getInstance(new
                    Locale("CN"));
            calendar.setTimeInMillis(nCurrentTime);
            int year = calendar.get(Calendar.YEAR);
            int month = calendar.get(Calendar.MONTH) + 1;
            int day = calendar.get(Calendar.DAY_OF_MONTH);
            String mm, dd;
            if (month < 10) {
                mm = "0" + String.valueOf(month);
            } else {
                mm = String.valueOf(month);
            }
            if (day < 10) {
                dd = "0" + String.valueOf(day);
            } else {
                dd = String.valueOf(day);
            }

          //  System.out.println(year + "-" + mm + "-" + dd);
            java.sql.Date date = java.sql.Date.valueOf(year + "-" + mm + "-" +