Package com.commander4j.util

Examples of com.commander4j.util.JExcel

235
236
237
238
239
240
241
242
    {
      moduleType = "EXEC";
      rs = module.getModuleDataByType(moduleType);
    }

    JExcel export = new JExcel();
    export.saveAs("modules_" + moduleType + ".xls", rs, Common.mainForm);
  }
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
73
74
      jButtonExcel = new JButton4j(Common.icon_XLS);
      jButtonExcel.addActionListener(new ActionListener() {
        public void actionPerformed(final ActionEvent e) {
          JDBControl control = new JDBControl(Common.selectedHostID, Common.sessionID);

          JExcel export = new JExcel();
          buildSQL();
          export.saveAs("control.xls", control.getControlDataResultSet(listStatement), Common.mainForm);
        }
      });
      jButtonExcel.setText(lang.get("btn_Excel"));
      jButtonExcel.setMnemonic(lang.getMnemonicChar());
      jButtonExcel.setBounds(331, 275, 106, 30);
View Full Code Here
263
264
265
266
267
268
269
270
271
272
273
  }
 
  private boolean generateExcel(ResultSet temp)
  {
    boolean result = true;
    JExcel export = new JExcel();
    setExportFilename(getExportPath() + getReportID() + "_" + JUtility.getISOTimeStampStringFormat(JUtility.getSQLDateTime()).replace("T", "_").replace("-", "_").replace(":", "_") + ".xls");
    setExportFilename(promptUserforSave());
    export.exportToExcel(getExportFilename(), temp);
    return result;
  }
View Full Code Here
244
245
246
247
248
249
250
251
252
253
254
255
256
        jButtonExcel = new JButton4j(Common.icon_XLS);
        jButtonExcel.addActionListener(new ActionListener() {
          public void actionPerformed(final ActionEvent e) {
            JDBArchive arch = new JDBArchive(Common.selectedHostID, Common.sessionID);

            JExcel export = new JExcel();
            buildSQL();
            export.saveAs("archive.xls", arch.getArchiveDataResultSet(listStatement), Common.mainForm);
          }
        });
        jButtonExcel.setText(lang.get("btn_Excel"));
        jButtonExcel.setMnemonic(lang.getMnemonicChar());
        jButtonExcel.setBounds(470, 275, 115, 30);
View Full Code Here
934
935
936
937
938
939
940
941
942
    }
  }

  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
243
244
245
246
247
248
249
250
    {
      moduleType = "EXEC";
      rs = module.getModuleDataByType(moduleType);
    }

    JExcel export = new JExcel();
    export.saveAs("modules_" + moduleType + ".xls", rs, Common.mainForm);
  }
View Full Code Here
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
    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
62
63
64
65
66
67
68
69
70
71
72
73
74
      jButtonExcel = new JButton4j(Common.icon_XLS);
      jButtonExcel.addActionListener(new ActionListener() {
        public void actionPerformed(final ActionEvent e) {
          JDBPrinters printers = new JDBPrinters(Common.selectedHostID, Common.sessionID);

          JExcel export = new JExcel();
          buildSQL();
          export.saveAs("printers.xls", printers.getPrintersResultSet(listStatement), Common.mainForm);
        }
      });
      jButtonExcel.setText(lang.get("btn_Excel"));
      jButtonExcel.setMnemonic(lang.getMnemonicChar());
      jButtonExcel.setBounds(331, 275, 106, 30);
View Full Code Here
201
202
203
204
205
206
207
208
    }
  }

  private void excel() {
    JDBUser user = new JDBUser(Common.selectedHostID, Common.sessionID);
    JExcel export = new JExcel();
    export.saveAs("users.xls", user.getUserDataResultSet(), Common.mainForm);
  }
View Full Code Here
300
301
302
303
304
305
306
307
308
309
310
311
312
  }

  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
TOP

Related Classes of com.commander4j.util.JExcel

  • com.commander4j.app.JInternalFrameCustomerAdmin
  • com.commander4j.app.JInternalFrameLabelHistory
  • com.commander4j.app.JInternalFrameLocationAdmin
  • com.commander4j.app.JInternalFrameMaterialAdmin
  • com.commander4j.app.JInternalFrameMaterialBatchAdmin
  • com.commander4j.app.JInternalFrameMaterialLocationAdmin
  • com.commander4j.app.JInternalFrameMHNAdmin
  • com.commander4j.app.JInternalFrameMHNProperties
  • com.commander4j.app.JInternalFramePalletAdmin
  • com.commander4j.app.JInternalFramePalletHistoryAdmin
    • 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.