Package com.commander4j.util

Examples of com.commander4j.util.JExcel


    JButton4j btnExcel = new JButton4j(lang.get("btn_Excel"));
    btnExcel.addActionListener(new ActionListener()
    {
      public void actionPerformed(ActionEvent arg0)
      {
        JExcel export = new JExcel();
        PreparedStatement temp = buildSQL();

        ResultSet rs;

        try
        {
          rs = temp.executeQuery();
          export.saveAs("qm_results.xls", rs, Common.mainForm);
        } catch (Exception e)
        {
          rs = null;

        }
View Full Code Here


  }

  private void export() {
    JDBPalletHistory palletHistory = new JDBPalletHistory(Common.selectedHostID, Common.sessionID);

    JExcel export = new JExcel();
    export.setExcelRowLimit(jCheckBoxLimit, jSpinnerLimit);
    buildSQL();
    export.saveAs("pallet_history.xls", palletHistory.getPalletHistoryDataResultSet(listStatement), Common.mainForm);
  }
View Full Code Here

  }

  private void excel()
  {
    JDBQMDictionary dict = new JDBQMDictionary(Common.selectedHostID, Common.sessionID);
    JExcel export = new JExcel();
    PreparedStatement ps = dict.getDictionaryDataPreparedStatement();
    export.saveAs("qm_dictionary.xls", dict.getDictionaryDataResultSet(ps), Common.mainForm);
    try
    {
      ps.close();
    } catch (SQLException e)
    {
View Full Code Here

    populateList();
  }

  private void excel() {
    JDBMaterialBatch materialBatch = new JDBMaterialBatch(Common.selectedHostID, Common.sessionID);
    JExcel export = new JExcel();
    buildSQL();
    export.saveAs("material_batch.xls", materialBatch.getMaterialBatchDataResultSet(listStatement), Common.mainForm);
  }
View Full Code Here

    populateList();
  }

  private void excel() {
    JDBProcessOrder processOrder = new JDBProcessOrder(Common.selectedHostID, Common.sessionID);
    JExcel export = new JExcel();
    export.setExcelRowLimit(jCheckBoxLimit, jSpinnerLimit);
    buildSQL();
    export.saveAs("process_orders.xls", processOrder.getProcessOrderDataResultSet(listStatement), Common.mainForm);
  }
View Full Code Here

    }
  }

  private void export() {
    JDBLocation location = new JDBLocation(Common.selectedHostID, Common.sessionID);
    JExcel export = new JExcel();
    PreparedStatement temp = buildSQLr();
    export.saveAs("locations.xls", location.getLocationDataResultSet(temp), Common.mainForm);
  }
View Full Code Here

  }

  private void export()
  {
    JDBMHN mhn = new JDBMHN(Common.selectedHostID, Common.sessionID);
    JExcel export = new JExcel();
    PreparedStatement temp = buildSQLr();
    export.saveAs("mhn_" + masterHoldNoticeNumber + ".xls", mhn.getMHNDataResultSet(temp), Common.mainForm);
  }
View Full Code Here

    buildSQL();
    populateList();
  }

  private void excel() {
    JExcel export = new JExcel();

    ResultSet rs = null;
    try
    {
      rs = listStatement.executeQuery();

    }
    catch (SQLException e)
    {

    }
    export.saveAs("interface_log.xls", rs, Common.mainForm);
  }
View Full Code Here

    }
  }

  private void excel() {
    JDBCustomer customer = new JDBCustomer(Common.selectedHostID, Common.sessionID);
    JExcel export = new JExcel();
    export.saveAs("customers.xls", customer.getCustomerDataResultSet(), Common.mainForm);
  }
View Full Code Here

    populateList();
  }

  private void excel() {
    JDBInterface interfaceConfig = new JDBInterface(Common.selectedHostID, Common.sessionID);
    JExcel export = new JExcel();
    buildSQL();
    export.saveAs("interface.xls", interfaceConfig.getInterfaceDataResultSet(listStatement), Common.mainForm);
  }
View Full Code Here

TOP

Related Classes of com.commander4j.util.JExcel

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.