package stockinterface;import java.awt.*;import java.awt.event.*;import javax.swing.event.*;import javax.swing.*;import data.*;import maininterface.*;import user.*;import method.*;import java.util.Date;import print.*;public class CashLedgerViewFrame extends JFrame implements ActionListener {  JPanel contentPane;  //創建標簽控件  JLabel jLabel1 = new JLabel();  JLabel jLabel2 = new JLabel();  JLabel jLabel3 = new JLabel();  JLabel jLabel4 = new JLabel();  //創建編輯框控件  JTextField jTextField1 = new JTextField();  JTextField jTextField2 = new JTextField();  JTextField jTextField3 = new JTextField();  //創建按鈕控件  JButton jButton1 = new JButton();  //創建滾動框控件  JScrollPane jScrollPane1 = new JScrollPane();  //創建表格控件  JTable jTable1 = new JTable();  //創建表格模式類  StockManagementTableModel smTableModel = new StockManagementTableModel();  //創建標題數組  String[] colNames = {"序號", "關聯票據標識", "借貸標識", "記帳用戶", "發生金額", "發生日期"};  //創建下拉列表框控件  JComboBox jComboBox1 = new JComboBox();  //創建字體類  Font dialog13 = new java.awt.Font("Dialog", 0, 13);  //聲明數據類  StockManagementData stockManagementData = null;  //聲明用戶類  User user = null;  //聲明主窗口類  StockManagementMainFrame stockManagementMainFrame = null;  //創建現金賬套數組  String[][] cashLedgers = new String[0][6];  //創建方法類  DataMethod dataMethod = new DataMethod();  //創建帳套日期字符串  String ledgerDate = "";  public CashLedgerViewFrame(StockManagementMainFrame stockManagementMainFrame) {    this.stockManagementMainFrame = stockManagementMainFrame;    //取得主窗口的數據類    stockManagementData = stockManagementMainFrame.getStockManagementData();    //取得主窗口的用戶類    user = stockManagementMainFrame.getUser();    //取得主窗口的賬套日期    ledgerDate = stockManagementMainFrame.getLedgerDate();    //取得進貨模塊的用戶權限    int stockFunction = user.getStockFunction();    //檢查用戶權限    if ( (stockFunction & 16) != 16) {      JOptionPane.showMessageDialog(null, user.getUserName() + "用戶不具有該權限.");      System.exit(0);    }    //檢查賬套日期    if(ledgerDate.length() == 0){      JOptionPane.showMessageDialog(null, user.getUserName() + "請選擇賬套.");      return;    }    try {      jbInit();    }    catch(Exception e) {      e.printStackTrace();    }  }  private void jbInit() throws Exception  {    contentPane = (JPanel) this.getContentPane();    contentPane.setLayout(null);    this.setSize(new Dimension(657, 349));    this.setTitle("現金日記賬查看窗口");    //設置標簽的屬性    jLabel1.setText("查詢條件");    jLabel1.setBounds(new Rectangle(25, 33, 62, 16));    jLabel2.setText("查詢值");    jLabel2.setBounds(new Rectangle(259, 33, 50, 16));    jLabel3.setText("開始日期");    jLabel3.setBounds(new Rectangle(25, 75, 67, 16));    jLabel4.setText("結束日期");    jLabel4.setBounds(new Rectangle(198, 75, 66, 16));    //設置編輯框的屬性    jTextField1.setBounds(new Rectangle(317, 33, 133, 22));    jTextField2.setBounds(new Rectangle(92, 75, 101, 22));    jTextField3.setBounds(new Rectangle(264, 75, 101, 22));    //設置按鈕的屬性    jButton1.setText("查詢");    jButton1.setActionCommand("search");    jButton1.setBounds(new Rectangle(371, 75, 79, 22));    //設置滾動框的屬性    jScrollPane1.setBounds(new Rectangle(25, 118, 597, 171));    //設置下拉列表框的屬性    jComboBox1.setBounds(new Rectangle(86, 33, 156, 22));    jComboBox1.addItem("根據關聯票據標識查詢");    jComboBox1.addItem("根據記帳用戶查詢");    jComboBox1.addItem("根據發生日期查詢");    //為面板加入各個控件    contentPane.add(jScrollPane1, null);    contentPane.add(jButton1, null);    contentPane.add(jLabel1, null);    contentPane.add(jLabel3, null);    contentPane.add(jComboBox1, null);    contentPane.add(jTextField2, null);    contentPane.add(jLabel4, null);    contentPane.add(jLabel2, null);    contentPane.add(jTextField1, null);    contentPane.add(jTextField3, null);    jScrollPane1.getViewport().add(jTable1, null);    //設置窗口類的字體和為按鈕加入動作接收器    setupFontAndListener();  }  //設置窗口類的字體和為按鈕加入動作接收器的方法  public void setupFontAndListener(){    Component[] components = contentPane.getComponents();    //創建臨時按鈕控件    JButton tmpBtn = new JButton();    for(int i = 0; i < components.length; i++){      components[i].setFont(dialog13);      if(components[i].getClass().getName().equals("javax.swing.JButton")){        tmpBtn = (JButton)components[i];        tmpBtn.addActionListener(this);      }    }  }  //退出方法  public void exit(){    //隱藏窗口    this.setVisible(false);    //清空數組的內容    cashLedgers = new String[0][6];    this.showTableData(cashLedgers);    //取得面板上的所有控件    Component[] components = contentPane.getComponents();    //創建臨時編輯框控件    JTextField tmpTextField = new JTextField();    for(int i = 0; i < components.length; i++){      if(components[i].getClass().getName().equals("javax.swing.JTextField")){        tmpTextField = (JTextField)components[i];        //清空編輯框的內容        tmpTextField.setText("");      }    }  }  //設置用戶的方法  public void setUser(User user) {    this.user = user;  }  //設置賬套的方法  public void setLedgerDate(String ledgerDate) {    this.ledgerDate = ledgerDate;  }  protected void processWindowEvent(WindowEvent e) {    if (e.getID() == WindowEvent.WINDOW_CLOSING) {      exit();    }  }  //顯示表格內容的方法  public void showTableData(Object[][] detail){    //設置表格的標題    smTableModel.setColumnNames(colNames);    //設置表格的數據    smTableModel.setData(detail);    jTable1 = new JTable(smTableModel);    //設置表格的字體    jTable1.setFont(dialog13);    //將數據表格加入數據滾動框    jScrollPane1.getViewport().add(jTable1, null);    //設置列的寬度    jTable1.getColumnModel().getColumn(0).setPreferredWidth(8);    jTable1.getColumnModel().getColumn(1).setPreferredWidth(50);    jTable1.getColumnModel().getColumn(2).setPreferredWidth(8);    jTable1.getColumnModel().getColumn(3).setPreferredWidth(20);    jTable1.getColumnModel().getColumn(4).setPreferredWidth(10);    jTable1.getColumnModel().getColumn(5).setPreferredWidth(60);  }  //查詢方法  public void search(){    //取得查詢選項    int selectedIndex = jComboBox1.getSelectedIndex();    //取得編輯框的變量    String searchValue = jTextField1.getText().trim();    String startDateStr = jTextField2.getText().trim();    String endDateStr = jTextField3.getText().trim();    if (selectedIndex == 0 | selectedIndex == 1) {      if (searchValue.length() == 0) {        JOptionPane.showMessageDialog(null, "請輸入查詢值");        return;      }      switch (selectedIndex) {        case 0:          //根據關聯票據標識取得記錄          cashLedgers = stockManagementData.getCashLedgerByStringField(              ledgerDate, "linkId", searchValue);          break;        case 1:          //根據記帳用戶取得記錄          cashLedgers = stockManagementData.getCashLedgerByStringField(              ledgerDate, "filler", searchValue);          break;      }    }else{      java.sql.Timestamp startDate = dataMethod.transferDate(startDateStr);      java.sql.Timestamp endDate = dataMethod.transferEndDate(endDateStr);      if(startDate == null | endDate == null){        JOptionPane.showMessageDialog(null, "日期輸入錯誤，正確的日期格式是"                                      + "yyyy-mm-dd（年-月-日），如2004-1-1");        return;      }      //根據日期取得記錄      cashLedgers = stockManagementData.getCashLedgerByFillDate(ledgerDate,          startDate, endDate);    }    //顯示表格的內容    this.showTableData(cashLedgers);  }  //單擊事件  public void actionPerformed(ActionEvent e) {    //取得按鈕的動作字符串    String actionCommand = e.getActionCommand().trim();    if (actionCommand.equals("search")) {      //查詢      search();    }else if(actionCommand.equals("exit")){      exit();    }  }}