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

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

JavaScript

开发平台：

Java

JF_view_query_kcmx_rk.java：源码内容
  1. package appjxc.view;
  3. import java.awt.*;
  5. import javax.swing.*;
  6. import java.awt.BorderLayout;
  7. import java.awt.Font;
  8. import java.awt.Dimension;
  9. import javax.swing.border.Border;
  10. import java.util.Calendar;
  11. import java.util.Locale;
  12. import javax.swing.event.ChangeEvent;
  13. import javax.swing.event.ChangeListener;
  14. import javax.swing.table.TableColumnModel;
  15. import javax.swing.table.DefaultTableModel;
  16. import java.awt.event.ActionEvent;
  17. import java.awt.event.ActionListener;
  18. import java.awt.event.ItemEvent;
  19. import java.awt.event.ItemListener;
  20. import appjxc.model.Obj_BuyDetaile;
  22. public class JF_view_query_kcmx_rk extends JInternalFrame {
  23.     BorderLayout borderLayout1 = new BorderLayout();
  24.     JPanel jPanel1 = new JPanel();
  25.     GridLayout gridLayout1 = new GridLayout();
  26.     JPanel jPanel2 = new JPanel();
  27.     JPanel jPanel3 = new JPanel();
  28.     FlowLayout flowLayout1 = new FlowLayout();
  29.     JCheckBox jCheckBox1 = new JCheckBox();
  30.     JLabel jLabel1 = new JLabel();
  31.     JComboBox jCid = new JComboBox();
  32.     JComboBox jCysf = new JComboBox();
  33.     JTextField jTvalue = new JTextField();
  34.     JCheckBox jCheckBox2 = new JCheckBox();
  35.     JLabel jLabel2 = new JLabel();
  36.     JLabel jLabel3 = new JLabel();
  37.     JLabel jLabel4 = new JLabel();
  38.     JLabel jLabel6 = new JLabel();
  39.     FlowLayout flowLayout2 = new FlowLayout();
  40.     Border border1 = BorderFactory.createLineBorder(UIManager.getColor(
  41.             "ToolBar.dockingForeground"), 2);
  42.     Border border2 = BorderFactory.createLineBorder(Color.magenta, 1);
  43.     JButton jByes = new JButton();
  44.     JScrollPane jScrollPane1 = new JScrollPane();
  45.     JTable jTable1 = new JTable();
  46.     JFormattedTextField jFormattedTextField1 = new JFormattedTextField();
  47.     JFormattedTextField jFormattedTextField2 = new JFormattedTextField();
  49.     String[] name = {"rkdjh","rksl","rkje"};
  50.     int _idIndex ,_ysfIndex ;
  51.     public JF_view_query_kcmx_rk() {
  52.         _idIndex = 0 ;
  53.         _ysfIndex = 0 ;
  54.         try {
  55.             buildTable();
  56.             jbInit();
  57.         } catch (Exception exception) {
  58.             exception.printStackTrace();
  59.         }
  60.     }
  61.     public void setjSpinner(){
  62.     }
  64.     private void jbInit() throws Exception {
  65.         border2 = BorderFactory.createLineBorder(Color.magenta, 2);
  66.         jFormattedTextField1.setEnabled(false);
  67.         jFormattedTextField2.setEnabled(false);
  68.         border1 = BorderFactory.createLineBorder(Color.red, 1);
  69.         jCheckBox1.setSelected(true);
  70.         jCheckBox2.setSelected(false);
  71.         jCysf.addItem("like");
  72.         jCysf.addItem(">");
  73.         jCysf.addItem("<");
  74.         jCysf.addItem(">=");
  75.         jCysf.addItem("<=");
  77.         jCid.addItem("入库单据号");
  78.         jCid.addItem("入库数量");
  79.         jCid.addItem("入库金额");
  81.         getContentPane().setLayout(borderLayout1);
  82.         jCheckBox2.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  83.         jCheckBox2.setText("入库日期");
  84.         jCheckBox2.addChangeListener(new JF_view_query_kcmx_rk_jCheckBox2_changeAdapter(this));
  85.         jLabel2.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  86.         jLabel2.setText("起始日期:");
  87.         jLabel3.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  88.         jLabel3.setText("终止日期:");
  89.         jLabel4.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  90.         jLabel4.setText("运算符:");
  91.         jLabel6.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  92.         jLabel6.setText("数值:");
  93.         flowLayout1.setHgap(8);
  94.         jPanel3.setLayout(flowLayout2);
  95.         flowLayout2.setHgap(8);
  96.         jCheckBox1.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  97.         jLabel1.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  98.         jCid.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  99.         jCid.setPreferredSize(new Dimension(97, 23));
  100.         jCid.addItemListener(new JF_view_query_kcmx_rk_jCid_itemAdapter(this));
  101.         jPanel2.setBorder(border1);
  102.         jPanel3.setBorder(border2);
  103.         jTvalue.setPreferredSize(new Dimension(156, 24));
  104.         jCysf.setPreferredSize(new Dimension(53, 23));
  105.         jCysf.addItemListener(new JF_view_query_kcmx_rk_jCysf_itemAdapter(this));
  106.         jByes.setFont(new java.awt.Font("新宋体", Font.PLAIN, 12));
  107.         jByes.setText("查询");
  108.         jByes.addActionListener(new JF_view_query_kcmx_rk_jByes_actionAdapter(this));
  109.         jFormattedTextField1.setPreferredSize(new Dimension(139, 24));
  110.         jFormattedTextField2.setPreferredSize(new Dimension(139, 24));
  111.         this.setClosable(true);
  112.         this.getContentPane().add(jPanel1, java.awt.BorderLayout.NORTH);
  113.         jPanel2.setLayout(flowLayout1);
  114.         jCheckBox1.setText("查询条件");
  115.         jLabel1.setText("选择字段:");
  116.         jPanel1.add(jPanel2);
  117.         jPanel2.add(jCheckBox1);
  118.         jPanel2.add(jLabel1);
  119.         jPanel2.add(jCid);
  120.         jPanel2.add(jLabel4);
  121.         jPanel2.add(jCysf);
  122.         jPanel2.add(jLabel6);
  123.         jPanel2.add(jTvalue);
  125.         jPanel1.add(jPanel3);
  126.         jPanel3.add(jCheckBox2);
  127.         jPanel3.add(jLabel2);
  128.         jPanel3.add(jFormattedTextField1);
  129.         jPanel3.add(jLabel3);
  130.         jPanel3.add(jFormattedTextField2);
  131.         jPanel3.add(jByes);
  132.         this.getContentPane().add(jScrollPane1, java.awt.BorderLayout.CENTER);
  133.         jScrollPane1.getViewport().add(jTable1);
  134.         gridLayout1.setColumns(1);
  135.         gridLayout1.setRows(2);
  136.         jPanel1.setLayout(gridLayout1);
  138.         this.setSize(750,550);
  139.         this.setVisible(true);
  140.         UIManager.setLookAndFeel("javax.swing.plaf.metal.MetalLookAndFeel");
  141.         SwingUtilities.updateComponentTreeUI(this);
  142.     }
  143.     public void buildTable(){//"药品名称","药品批号","规格","产地","单位",,"零售价","有效期至"
  144.         String[] tname = {"入库单据号","药品编号","进货价格","进货数量","进货金额","进货日期"};
  145.         java.util.Vector vname = new java.util.Vector();
  146.         for (int i = 0 ; i < tname.length ; i++){
  147.             vname.addElement(tname[i]);
  148.         }
  149.         DefaultTableModel tableModel = null;
  150.         tableModel = new DefaultTableModel(vname,0);
  151.         jTable1.setModel(tableModel);
  152.         TableColumnModel tcm = jTable1.getColumnModel();
  154.     }
  158.     public void jCheckBox2_stateChanged(ChangeEvent e) {
  159.         if(jCheckBox2.isSelected()){
  160.             jFormattedTextField1.setEnabled(true);
  161.             jFormattedTextField2.setEnabled(true);
  162.             long nCurrentTime = System.currentTimeMillis();
  163.             java.util.Calendar calendar = java.util.Calendar.getInstance(new
  164.                     Locale("CN"));
  165.             calendar.setTimeInMillis(nCurrentTime);
  166.             int year = calendar.get(Calendar.YEAR);
  167.             int month = calendar.get(Calendar.MONTH) + 1;
  168.             int day = calendar.get(Calendar.DAY_OF_MONTH);
  169.             String mm, dd;
  170.             if (month < 10) {
  171.                 mm = "0" + String.valueOf(month);
  172.             } else {
  173.                 mm = String.valueOf(month);
  174.             }
  175.             if (day < 10) {
  176.                 dd = "0" + String.valueOf(day);
  177.             } else {
  178.                 dd = String.valueOf(day);
  179.             }
  181.           //  System.out.println(year + "-" + mm + "-" + dd);
  182.             java.sql.Date date = java.sql.Date.valueOf(year + "-" + mm + "-" +
  183.                     dd);
  184.             jFormattedTextField1.setText(String.valueOf(date));
  185.             jFormattedTextField2.setText(String.valueOf(date));
  187.         }else{
  188.             jFormattedTextField1.setEnabled(false);
  189.             jFormattedTextField2.setEnabled(false);
  190.             jFormattedTextField1.setText(String.valueOf(""));
  191.              jFormattedTextField2.setText(String.valueOf(""));
  192.         }
  194.     }
  196.     public void jByes_actionPerformed(ActionEvent e) {
  197.         if (jCheckBox1.isSelected()){
  198.            if (jTvalue.getText().trim().length() <= 0){
  199.                JOptionPane.showMessageDialog(null, "请输入查询数值!!", "提示",
  200.                                              JOptionPane.ERROR_MESSAGE);
  201.                jTvalue.requestFocus();
  202.                return;
  203.           }
  204.        }
  206.         String[] tname = {"入库单据号","药品编号","进货价格","进货数量","进货金额","进货日期"};
  207.         java.util.Vector vname = new java.util.Vector();
  208.         for (int i = 0 ; i < tname.length ; i++){
  209.             vname.addElement(tname[i]);
  210.         }
  211.         DefaultTableModel tableModel = null;
  212.         tableModel = new DefaultTableModel(vname,0);
  213.         jTable1.setModel(tableModel);
  216.         String whereStr = null,queryStr = null;
  217.         System.out.println(_ysfIndex);
  218.         if(jCheckBox1.isSelected() && !jCheckBox2.isSelected()){
  219.             if (_ysfIndex == 0){
  220.                whereStr = name[_idIndex] + " " + jCysf.getSelectedItem() + " '%" +
  221.                           jTvalue.getText().trim() + "%'";
  222.             }else{
  223.               whereStr = name[_idIndex] + " " + jCysf.getSelectedItem() + " '" +
  224.                      jTvalue.getText().trim() + "'";
  225.             }
  227.         }else if(jCheckBox1.isSelected()&& jCheckBox2.isSelected()){
  228.             java.sql.Date date1,date2 ;
  229.             try{
  230.                 date1 = java.sql.Date.valueOf(jFormattedTextField1.getText().trim());
  231.                 date2 = java.sql.Date.valueOf(jFormattedTextField2.getText().trim());
  232.                 System.out.println("date1 = " + date1 + "; date2 = " + date2);
  233.                 jFormattedTextField1.setText(String.valueOf(date1));
  234.                 jFormattedTextField2.setText(String.valueOf(date2));
  235.                 if (date1.after(date2)){
  236.                     JOptionPane.showMessageDialog(null,"输入的起始日期不能小于终止日期!!!","系统提示",JOptionPane.ERROR_MESSAGE);
  237.                     return;
  238.                 }
  239.             }catch(java.lang.NumberFormatException formate){
  240.                 JOptionPane.showMessageDialog(null,"输入的日期有误!!!n" + formate.getMessage(),"系统提示",JOptionPane.ERROR_MESSAGE);
  241.                 return;
  242.             }
  243.             if (_ysfIndex == 0){
  244.                whereStr = name[_idIndex] + " " + jCysf.getSelectedItem() + " '%" +
  245.                           jTvalue.getText().trim() + "%' and rkrq >= '" + date1 + "' and rkrq <= '" + date2 + "'";
  246.             }else{
  247.                 whereStr = name[_idIndex] + " " + jCysf.getSelectedItem() + " '" +
  248.                    jTvalue.getText().trim() + "' and rkrq >= '" + date1 + "' and rkrq <= '" + date2 + "'";
  249.             }
  251.         }else if(!jCheckBox1.isSelected() && jCheckBox2.isSelected()){
  252.             java.sql.Date date1,date2 ;
  253.             try{
  254.                 date1 = java.sql.Date.valueOf(jFormattedTextField1.getText().trim());
  255.                 date2 = java.sql.Date.valueOf(jFormattedTextField2.getText().trim());
  256.                 System.out.println("date1 = " + date1 + "; date2 = " + date2);
  257.                 jFormattedTextField1.setText(String.valueOf(date1));
  258.                 jFormattedTextField2.setText(String.valueOf(date2));
  259.                 if (date1.after(date2)){
  260.                     JOptionPane.showMessageDialog(null,"输入的起始日期不能小于终止日期!!!","系统提示",JOptionPane.ERROR_MESSAGE);
  261.                     return;
  262.                 }
  263.             }catch(java.lang.NumberFormatException formate){
  264.                 JOptionPane.showMessageDialog(null,"输入的日期有误!!!n" + formate.getMessage(),"系统提示",JOptionPane.ERROR_MESSAGE);
  265.                 return;
  266.             }
  267.             whereStr = " rkrq >= '" + date1 + "' and rkrq <= '" + date2 + "'";
  269.         }else if(!jCheckBox1.isSelected() && !jCheckBox2.isSelected()){
  270.             return;
  271.         }
  272.         queryStr = " from Obj_BuyDetaile where " + whereStr;
  273.         System.out.println(queryStr);
  274.         java.util.List list = appjxc.dao.AdapterDao.QueryObject(queryStr);
  275.         if (list.size() <= 0){
  276.             JOptionPane.showMessageDialog(null,"没有找到满足条件的数据!!","系统提示",JOptionPane.INFORMATION_MESSAGE);
  277.             return;
  278.         }
  279.         int rowcount = jTable1.getRowCount();
  282.         System.out.println("list.size() = " + list.size());
  283.         java.util.Iterator iterator = list.iterator();
  284.         //DefaultTableModel table = new DefaultTableModel();
  285.         while(iterator.hasNext()){
  286.             Obj_BuyDetaile buy = (Obj_BuyDetaile)iterator.next();
  287.             java.util.Vector vdata = new java.util.Vector();
  288.             vdata.addElement(buy.getRkdjh());
  289.             vdata.addElement(buy.getYpbh());
  290.             vdata.addElement(String.valueOf(buy.getRkdj()));
  291.             vdata.addElement(String.valueOf(buy.getRksl()));
  292.             vdata.addElement(String.valueOf(buy.getRkje()));
  293.             vdata.addElement(buy.getRkrq());
  295.             tableModel.addRow(vdata);
  296.         }
  297.         jTable1.setModel(tableModel);
  298.         jTable1.setRowHeight(20);
  299.     }
  301.     public void jCid_itemStateChanged(ItemEvent e) {
  302.         _idIndex = jCid.getSelectedIndex();
  303.     }
  305.     public void jCysf_itemStateChanged(ItemEvent e) {
  306.         _ysfIndex = jCysf.getSelectedIndex();
  307.     }
  308. }
  311. class JF_view_query_kcmx_rk_jByes_actionAdapter implements ActionListener {
  312.     private JF_view_query_kcmx_rk adaptee;
  313.     JF_view_query_kcmx_rk_jByes_actionAdapter(JF_view_query_kcmx_rk adaptee) {
  314.         this.adaptee = adaptee;
  315.     }
  317.     public void actionPerformed(ActionEvent e) {
  318.         adaptee.jByes_actionPerformed(e);
  319.     }
  320. }
  323. class JF_view_query_kcmx_rk_jCid_itemAdapter implements ItemListener {
  324.     private JF_view_query_kcmx_rk adaptee;
  325.     JF_view_query_kcmx_rk_jCid_itemAdapter(JF_view_query_kcmx_rk adaptee) {
  326.         this.adaptee = adaptee;
  327.     }
  329.     public void itemStateChanged(ItemEvent e) {
  330.         adaptee.jCid_itemStateChanged(e);
  331.     }
  332. }
  335. class JF_view_query_kcmx_rk_jCysf_itemAdapter implements ItemListener {
  336.     private JF_view_query_kcmx_rk adaptee;
  337.     JF_view_query_kcmx_rk_jCysf_itemAdapter(JF_view_query_kcmx_rk adaptee) {
  338.         this.adaptee = adaptee;
  339.     }
  341.     public void itemStateChanged(ItemEvent e) {
  342.         adaptee.jCysf_itemStateChanged(e);
  343.     }
  344. }
  347. class JF_view_query_kcmx_rk_jCheckBox2_changeAdapter implements ChangeListener {
  348.     private JF_view_query_kcmx_rk adaptee;
  349.     JF_view_query_kcmx_rk_jCheckBox2_changeAdapter(JF_view_query_kcmx_rk adaptee) {
  350.         this.adaptee = adaptee;
  351.     }
  353.     public void stateChanged(ChangeEvent e) {
  354.         adaptee.jCheckBox2_stateChanged(e);
  355.     }
  356. }