jf_zcgl_query_zcwx.java

数据库管理系统

package appgdzc.view;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JScrollPane;
import javax.swing.JPanel;
import javax.swing.BorderFactory;
import javax.swing.UIManager;
import javax.swing.border.Border;
import javax.swing.border.TitledBorder;
import java.awt.Color;
import javax.swing.JTable;
import java.awt.FlowLayout;
import javax.swing.table.DefaultTableModel;
import javax.swing.JLabel;
import javax.swing.JComboBox;
import javax.swing.JTextField;
import javax.swing.JButton;
import javax.swing.JToggleButton;
import java.awt.Dimension;
import java.awt.Font;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JOptionPane;
import javax.swing.DefaultDesktopManager;
import java.awt.event.KeyEvent;
import java.awt.event.KeyAdapter;
import appgdzc.tools.QueryTableEJB;

public class JF_ZCGL_Query_zcwx extends javax.swing.JInternalFrame{//JFrame {
    String name[] = {"zcbh","sxrq","wxrq","wxfy"};
    String tname = "zcbh";

    BorderLayout borderLayout1 = new BorderLayout();
    JScrollPane jScrollPane1 = new JScrollPane();
    JPanel jPanel1 = new JPanel();

    Border border1 = BorderFactory.createLineBorder(UIManager.getColor(
            "ToolBar.dockingForeground"), 2);
    Border border2 = new TitledBorder(border1, "查询参数");
    JTable jTable1 = new JTable();
    FlowLayout flowLayout1 = new FlowLayout();
    public static DefaultTableModel tableModel = null;
    JLabel jLabel1 = new JLabel();
    JComboBox jCombozd = new JComboBox();
    JLabel jLabel2 = new JLabel();
    JComboBox jComboysf = new JComboBox();
    JLabel jLabel3 = new JLabel();
    JTextField jTvalue = new JTextField();
    JButton jByes = new JButton();
    JButton jBexit = new JButton();
    JPanel jPanel2 = new JPanel();
    BorderLayout borderLayout2 = new BorderLayout();
    JLabel jLtext = new JLabel();



    public JF_ZCGL_Query_zcwx() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
//        java.awt.Font font = new Font()
        border2 = new TitledBorder(BorderFactory.createLineBorder(Color.red, 1),
                                   "查询参数");

        getContentPane().setLayout(borderLayout1);
        jCombozd.addItem("设备编号");
        jCombozd.addItem("送修日期");
        jCombozd.addItem("维修日期");
        jCombozd.addItem("维修费用");

        jComboysf.addItem(">");
        jComboysf.addItem("=");
        jComboysf.addItem("<");
        jLabel1.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        jLabel1.setText("查询字段");
        jLabel2.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        jLabel2.setText("运算符");
        jLabel3.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        jLabel3.setText("数值");
        jByes.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        jByes.setText("确定");
        jByes.addActionListener(new JF_ZCGL_Query_zcwx_jByes_actionAdapter(this));
        jBexit.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        jBexit.setText("退出");
        jBexit.addActionListener(new JF_ZCGL_Query_zcwx_jBexit_actionAdapter(this));
        jTvalue.setPreferredSize(new Dimension(126, 28));
        jTvalue.addKeyListener(new JF_ZCGL_Query_zcwx_jTvalue_keyAdapter(this));
        jCombozd.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        jCombozd.setPreferredSize(new Dimension(85, 23));
        jCombozd.addItemListener(new JF_ZCGL_Query_zcwx_jCombozd_itemAdapter(this));
        jComboysf.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
        jComboysf.setPreferredSize(new Dimension(38, 23));
        flowLayout1.setAlignment(FlowLayout.RIGHT);
        flowLayout1.setHgap(10);
        jPanel2.setLayout(borderLayout2);
        jLtext.setFont(new java.awt.Font("新宋体", Font.PLAIN, 14));
        jLtext.setForeground(Color.red);
        jLtext.setText("共有数据:");
        this.setClosable(true);
        this.setMaximizable(true);
        this.setTitle("资产设备维修情况查询");
        this.getContentPane().add(jScrollPane1, java.awt.BorderLayout.CENTER);
        jPanel1.add(jLabel1);
        jPanel1.add(jCombozd);
        jPanel1.add(jLabel2);
        jPanel1.add(jComboysf);
        jPanel1.add(jLabel3);
        jPanel1.add(jTvalue);
        jPanel1.add(jByes);
        jPanel1.add(jBexit);
        jPanel1.setBorder(border2);
        jPanel1.setLayout(flowLayout1);
        jScrollPane1.getViewport().add(jTable1);
        this.getContentPane().add(jPanel2, java.awt.BorderLayout.SOUTH);
        this.getContentPane().add(jPanel1, java.awt.BorderLayout.NORTH);
        jPanel2.add(jLtext, java.awt.BorderLayout.CENTER);
        this.setSize(750,550);
        this.setVisible(true);

    }

    public void jCombozd_itemStateChanged(ItemEvent itemEvent) {
        int index = jCombozd.getSelectedIndex();
        tname = name[index];
        jTvalue.setText("");
    }
    public void jByes_actionPerformed(ActionEvent actionEvent) {
        String sqlStr = null;
        if (tname.equals("wxfy") || tname=="wxfy"){
            sqlStr = "select * from t_zcwx where "
                 + tname + " " + jComboysf.getSelectedItem() + jTvalue.getText().trim();
        }
        if(tname.equals("zcbh") || tname == "zcbh"){
            sqlStr = "select * from t_zcwx where "
                 + tname + " " + jComboysf.getSelectedItem() + "'" + jTvalue.getText().trim() + "'";
        }
        if((tname.equals("sxrq") || tname=="sxrq") || (tname.equals("wxrq"))||tname == "wxrq"){
            java.sql.Date dt = null;
            dt = java.sql.Date.valueOf(jTvalue.getText().trim());
            //System.out.println(dt);
            sqlStr = "select * from t_zcwx where "
                 + tname + " " + jComboysf.getSelectedItem() + " '" + dt + "'";
        }

        QueryTableEJB queryTable = new QueryTableEJB("t_zcwx");
        DefaultTableModel tableModel = null;
        tableModel = queryTable.getTableModel(sqlStr);
        jTable1.setModel(tableModel);
        jTable1.setRowHeight(22);
        if (jTable1.getRowCount() <= 0 ){
            JOptionPane.showMessageDialog(null,"没有满足该条件的数据!!!","系统提示",JOptionPane.INFORMATION_MESSAGE);

        }
        jLtext.setText("共有数据:" + jTable1.getRowCount() + " 条");//,当前是第 " + jTable1.getSelectedRow() + " 条");



    }

    public void jBexit_actionPerformed(ActionEvent actionEvent) {
        javax.swing.DefaultDesktopManager manger = new DefaultDesktopManager();
        int result = JOptionPane.showOptionDialog(null,"是否真的退出资产设备维修查询?","系统提示",
                                   JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE,
                                   null,new String[]  {"是","否"},"否");
        if (result == JOptionPane.YES_OPTION) {
            manger.closeFrame(this);
        }

    }

    public void jTvalue_keyPressed(KeyEvent keyEvent) {
        if(keyEvent.getKeyCode() == KeyEvent.VK_ENTER){
            ActionEvent actionevent = new ActionEvent(jByes,0,"");
            this.jByes_actionPerformed(actionevent);
        }

    }
}


class JF_ZCGL_Query_zcwx_jTvalue_keyAdapter extends KeyAdapter {
    private JF_ZCGL_Query_zcwx adaptee;
    JF_ZCGL_Query_zcwx_jTvalue_keyAdapter(JF_ZCGL_Query_zcwx adaptee) {
        this.adaptee = adaptee;
    }

    public void keyPressed(KeyEvent keyEvent) {
        adaptee.jTvalue_keyPressed(keyEvent);
    }
}


class JF_ZCGL_Query_zcwx_jBexit_actionAdapter implements ActionListener {
    private JF_ZCGL_Query_zcwx adaptee;
    JF_ZCGL_Query_zcwx_jBexit_actionAdapter(JF_ZCGL_Query_zcwx adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent actionEvent) {
        adaptee.jBexit_actionPerformed(actionEvent);
    }
}


class JF_ZCGL_Query_zcwx_jCombozd_itemAdapter implements ItemListener {
    private JF_ZCGL_Query_zcwx adaptee;
    JF_ZCGL_Query_zcwx_jCombozd_itemAdapter(JF_ZCGL_Query_zcwx adaptee) {
        this.adaptee = adaptee;
    }

    public void itemStateChanged(ItemEvent itemEvent) {
        adaptee.jCombozd_itemStateChanged(itemEvent);
    }
}


class JF_ZCGL_Query_zcwx_jByes_actionAdapter implements ActionListener {
    private JF_ZCGL_Query_zcwx adaptee;
    JF_ZCGL_Query_zcwx_jByes_actionAdapter(JF_ZCGL_Query_zcwx adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent actionEvent) {
        adaptee.jByes_actionPerformed(actionEvent);
    }
}