开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Java编程 > JavaScript > 查看源码
JF_view_query_jbqk.java
资源名称：Appjxc.rar　[点击查看]
上传用户：whbcdz
上传日期：2008-08-04
资源大小：7683k
文件大小：10k
源码类别：

JavaScript

开发平台：

Java

JF_view_query_jbqk.java：源码内容
  1. package appjxc.view;
  3. import javax.swing.*;
  4. import java.awt.BorderLayout;
  5. import java.awt.FlowLayout;
  6. import java.awt.SystemColor;
  7. import javax.swing.border.Border;
  8. import javax.swing.border.TitledBorder;
  9. import java.awt.Font;
  10. import javax.swing.border.BevelBorder;
  11. import java.awt.Color;
  12. import javax.swing.BorderFactory;
  13. import java.awt.Dimension;
  14. import appjxc.model.obj_medicine;
  15. import appjxc.model.Obj_client;
  16. import appjxc.model.Obj_gys;
  17. import javax.swing.table.DefaultTableModel;
  18. import java.awt.event.ItemEvent;
  19. import java.awt.event.ItemListener;
  20. import java.awt.event.ActionEvent;
  21. import java.awt.event.ActionListener;
  22. import java.awt.event.KeyEvent;
  23. import java.awt.event.KeyAdapter;
  25. public class JF_view_query_jbqk extends JInternalFrame {
  26.     BorderLayout borderLayout1 = new BorderLayout();
  27.     JPanel jPanel1 = new JPanel();
  28.     JScrollPane jScrollPane1 = new JScrollPane();
  29.     JTable jTable1 = new JTable();
  30.     FlowLayout flowLayout1 = new FlowLayout();
  31.     JLabel jLabel1 = new JLabel();
  32.     JComboBox jCobj = new JComboBox();
  33.     Border border1 = BorderFactory.createLineBorder(SystemColor.controlText, 2);
  34.     Border border2 = new TitledBorder(border1, "查询参数设置");
  37.     JLabel jLabel2 = new JLabel();
  38.     JComboBox jCid = new JComboBox();
  39.     JComboBox jCysf = new JComboBox();
  40.     JLabel jLabel3 = new JLabel();
  41.     JTextField jTvalue = new JTextField();
  42.     JButton jByes = new JButton();
  43.     JButton jBquit = new JButton();
  44.     Object[] object = {new obj_medicine(),new Obj_client(),new Obj_gys()};
  45.     String[] name = {"ypbh","pym"};
  46.     int _objIndex = 0,_idIndex = 0,_ysfIndex = 0;
  48.     public JF_view_query_jbqk() {
  49.         try {
  50.             jbInit();
  51.         } catch (Exception ex) {
  52.             ex.printStackTrace();
  53.         }
  54.     }
  56.     public static void main(String[] args) {
  57.         JF_view_query_jbqk jf_view_query_jbqk = new JF_view_query_jbqk();
  58.     }
  60.     private void jbInit() throws Exception {
  61.       //  object[1] = {new obj_medicine(),new Obj_client(),new Obj_gys()};
  62.         jCobj.addItem("药品基本信息");
  63.         jCobj.addItem("客户基本信息");
  64.         jCobj.addItem("供应商基本信息");
  65.         jCysf.addItem("like");
  66.         jCysf.addItem(">");
  67.         jCysf.addItem("<");
  68.         jCid.addItem("信息编号");
  69.         jCid.addItem("拼音码");
  70.         border2 = new TitledBorder(border1, "设置查询参数",
  71.                                      TitledBorder.DEFAULT_JUSTIFICATION,
  72.                                      TitledBorder.DEFAULT_POSITION,
  73.                                      new java.awt.Font("新宋体", 0, 12),
  74.                                      Color.red);
  76.         this.getContentPane().setLayout(borderLayout1);
  77.         jCobj.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  78.         jCobj.addItemListener(new JF_view_query_jbqk_jCobj_itemAdapter(this));
  79.         jLabel3.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  80.         jLabel3.setText("数值:");
  81.         jTvalue.setMinimumSize(new Dimension(106, 21));
  82.         jTvalue.setPreferredSize(new Dimension(136, 24));
  83.         jTvalue.setText("");
  84.         jByes.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  85.         jByes.setText("查询");
  86.         jByes.addActionListener(new JF_view_query_jbqk_jByes_actionAdapter(this));
  87.         jBquit.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  88.         jBquit.setText("关闭");
  89.         jLabel1.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  90.         jLabel2.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  91.         jCid.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  92.         jCid.addItemListener(new JF_view_query_jbqk_jCid_itemAdapter(this));
  93.         jCysf.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  94.         flowLayout1.setHgap(8);
  95.         flowLayout1.setVgap(8);
  96.         borderLayout1.setVgap(3);
  97.         this.setClosable(true);
  98.         this.setMaximizable(true);
  99.         jCysf.addItemListener(new JF_view_query_jbqk_jCysf_itemAdapter(this));
  100.         jCobj.setPreferredSize(new Dimension(133, 25));
  101.         jCid.setPreferredSize(new Dimension(95, 25));
  102.         jCysf.setPreferredSize(new Dimension(85, 25));
  103.         jTvalue.addKeyListener(new JF_view_query_jbqk_jTvalue_keyAdapter(this));
  104.         jBquit.addActionListener(new JF_view_query_jbqk_jBquit_actionAdapter(this));
  105.         this.getContentPane().add(jPanel1, java.awt.BorderLayout.NORTH);
  106.         jPanel1.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  107.         jPanel1.setBorder(border2);
  108.         jLabel2.setText("运算符:");
  109.         jPanel1.add(jCobj);
  110.         jPanel1.add(jLabel1);
  111.         jPanel1.add(jCid);
  112.         jPanel1.add(jLabel2);
  113.         jPanel1.add(jCysf);
  114.         jPanel1.add(jLabel3);
  115.         jPanel1.add(jTvalue);
  116.         jPanel1.add(jByes);
  117.         jPanel1.add(jBquit);
  118.         jLabel1.setText("查询字段:");
  119.         jPanel1.setLayout(flowLayout1);
  120.         this.getContentPane().add(jScrollPane1, java.awt.BorderLayout.CENTER);
  121.         jScrollPane1.getViewport().add(jTable1);
  122.         this.setSize(850,550);
  123.         this.setVisible(true);
  124.     }
  126.     public void jCobj_itemStateChanged(ItemEvent e) {
  127.         _objIndex = jCobj.getSelectedIndex();
  128.         if (_objIndex == 0) {
  129.             name[0] = "ypbh";
  130.             name[1] = "pym";
  131.         }
  132.         if (_objIndex == 1) {
  133.             name[0] = "khbh";
  134.             name[1] = "pym";
  135.         }
  136.         if (_objIndex == 2) {
  137.             name[0] = "gysbh";
  138.             name[1] = "pym";
  139.         }
  140.         System.out.println(_objIndex);
  141.     }
  143.     public void jByes_actionPerformed(ActionEvent e) {
  144.         if (jTvalue.getText().trim().length() <= 0){
  145.             JOptionPane.showMessageDialog(null,"请输入查询数值!!","提示",JOptionPane.ERROR_MESSAGE);
  146.             jTvalue.requestFocus();
  147.             return;
  148.         }
  149.         DefaultTableModel defaultmodel = null;
  150.         int choose;
  151.         choose = jCobj.getSelectedIndex();
  152.         String queryStr = null,whereStr = null;
  153.         appjxc.constrol.BuildTable buildTable = new appjxc.constrol.BuildTable();
  155.         if (_ysfIndex == 0){
  156.             whereStr = name[_idIndex] + " " +
  157.                        String.valueOf(jCysf.getItemAt(_ysfIndex)) +
  158.                        " '%" + jTvalue.getText().trim() + "%'";
  159.         }else{
  160.             whereStr = name[_idIndex] + " " +
  161.                        String.valueOf(jCysf.getItemAt(_ysfIndex)) +
  162.                        " '" + jTvalue.getText().trim() + "'";
  163.         }
  165.         switch (choose){
  166.                case 0:
  167.                    queryStr = " From  obj_medicine where " + whereStr;
  168.                    defaultmodel = buildTable.getmedicineTableModel(queryStr);
  169.                    break;
  170.                case 1:
  171.                    queryStr = " From  Obj_client where " + whereStr;
  172.                    defaultmodel = buildTable.getClientTableModel(queryStr);
  173.                    break;
  174.               case 2:
  175.                   queryStr = " From  Obj_gys where " + whereStr;
  176.                   defaultmodel = buildTable.getGysTableModel(queryStr);
  177.                   break;
  178.         }
  179.         jTable1.setModel(defaultmodel);
  180.         if (jTable1.getRowCount() <= 0 ){
  181.             JOptionPane.showMessageDialog(null,"没有找到满足条件的数据!!!","系统提示",JOptionPane.ERROR_MESSAGE);
  182.         }
  184.     }
  186.     public void jCid_itemStateChanged(ItemEvent e) {
  187.         System.out.println(_idIndex);
  188.         _idIndex = jCid.getSelectedIndex();
  189.     }
  191.     public void jCysf_itemStateChanged(ItemEvent e) {
  192.         _ysfIndex = jCysf.getSelectedIndex();
  193.     }
  195.     public void jTvalue_keyPressed(KeyEvent e) {
  196.         if (e.getKeyCode() == KeyEvent.VK_ENTER){
  197.             ActionEvent yesevent = new ActionEvent(jByes,0,null);
  198.             this.jByes_actionPerformed(yesevent);
  199.         }
  200.     }
  202.     public void jBquit_actionPerformed(ActionEvent actionEvent) {
  203.         javax.swing.DefaultDesktopManager manger = new DefaultDesktopManager();
  204.         int result = JOptionPane.showOptionDialog(null,"是否真的退出基本信息查询?","系统提示",
  205.                                    JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE,
  206.                                    null,new String[]  {"是","否"},"否");
  207.         if (result == JOptionPane.YES_OPTION) {
  208.             try{
  209.                 //UIManager.setLookAndFeel("javax.swing.plaf.metal.MetalLookAndFeel");
  210.                 SwingUtilities.updateComponentTreeUI(this);
  211.             }catch(Exception ex){
  212.                 ex.printStackTrace();
  213.             }
  216.            manger.closeFrame(this);
  217.         }
  219.     }
  222. }
  225. class JF_view_query_jbqk_jBquit_actionAdapter implements ActionListener {
  226.     private JF_view_query_jbqk adaptee;
  227.     JF_view_query_jbqk_jBquit_actionAdapter(JF_view_query_jbqk adaptee) {
  228.         this.adaptee = adaptee;
  229.     }
  231.     public void actionPerformed(ActionEvent actionEvent) {
  232.         adaptee.jBquit_actionPerformed(actionEvent);
  233.     }
  234. }
  237. class JF_view_query_jbqk_jTvalue_keyAdapter extends KeyAdapter {
  238.     private JF_view_query_jbqk adaptee;
  239.     JF_view_query_jbqk_jTvalue_keyAdapter(JF_view_query_jbqk adaptee) {
  240.         this.adaptee = adaptee;
  241.     }
  243.     public void keyPressed(KeyEvent e) {
  244.         adaptee.jTvalue_keyPressed(e);
  245.     }
  246. }
  249. class JF_view_query_jbqk_jCysf_itemAdapter implements ItemListener {
  250.     private JF_view_query_jbqk adaptee;
  251.     JF_view_query_jbqk_jCysf_itemAdapter(JF_view_query_jbqk adaptee) {
  252.         this.adaptee = adaptee;
  253.     }
  255.     public void itemStateChanged(ItemEvent e) {
  256.         adaptee.jCysf_itemStateChanged(e);
  257.     }
  258. }
  261. class JF_view_query_jbqk_jCid_itemAdapter implements ItemListener {
  262.     private JF_view_query_jbqk adaptee;
  263.     JF_view_query_jbqk_jCid_itemAdapter(JF_view_query_jbqk adaptee) {
  264.         this.adaptee = adaptee;
  265.     }
  267.     public void itemStateChanged(ItemEvent e) {
  268.         adaptee.jCid_itemStateChanged(e);
  269.     }
  270. }
  273. class JF_view_query_jbqk_jByes_actionAdapter implements ActionListener {
  274.     private JF_view_query_jbqk adaptee;
  275.     JF_view_query_jbqk_jByes_actionAdapter(JF_view_query_jbqk adaptee) {
  276.         this.adaptee = adaptee;
  277.     }
  279.     public void actionPerformed(ActionEvent e) {
  280.         adaptee.jByes_actionPerformed(e);
  281.     }
  282. }
  285. class JF_view_query_jbqk_jCobj_itemAdapter implements ItemListener {
  286.     private JF_view_query_jbqk adaptee;
  287.     JF_view_query_jbqk_jCobj_itemAdapter(JF_view_query_jbqk adaptee) {
  288.         this.adaptee = adaptee;
  289.     }
  291.     public void itemStateChanged(ItemEvent e) {
  292.         adaptee.jCobj_itemStateChanged(e);
  293.     }
  294. }