Java tutorial
import java.io.File; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.Set; import java.util.TreeMap; import java.util.logging.Level; import java.util.logging.Logger; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; import org.apache.poi.xssf.usermodel.XSSFCell; import org.apache.poi.xssf.usermodel.XSSFRow; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; /* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ /** * * @author Digital */ public class spareexcel extends javax.swing.JFrame { String constring = "jdbc:mysql://localhost:3306/bharatmotors"; String username = "root"; String password = ""; DefaultTableModel dm = new DefaultTableModel(); public spareexcel() { initComponents(); } private DefaultTableModel getdata() { dm.addColumn("DATE"); dm.addColumn("PART_NO"); dm.addColumn("ITEM_NAME"); dm.addColumn("MODEL"); dm.addColumn("QUANTITY"); dm.addColumn("IN_PRICE"); dm.addColumn("MRP"); String sql = "SELECT * FROM SPAREPARTS"; try { Connection con = DriverManager.getConnection(constring, username, password); Statement s = con.prepareStatement(sql); ResultSet rs = s.executeQuery(sql); while (rs.next()) { String dt = rs.getString("Date"); String name = rs.getString("Part_No"); String addr = rs.getString("Item_Name"); String veh = rs.getString("Model"); String no = rs.getString("Quantity"); String eng = rs.getString("In_Price"); String eng1 = rs.getString("MRP"); String[] rowdata = { dt, name, addr, veh, no, eng, eng1 }; dm.addRow(rowdata); } return dm; } catch (Exception ex) { ex.printStackTrace(); } return null; } private String getCellValue(int x, int y) { return dm.getValueAt(x, y).toString(); } private void writeToExcel() throws FileNotFoundException, IOException { XSSFWorkbook wb = new XSSFWorkbook(); XSSFSheet ws = wb.createSheet(); TreeMap<String, Object[]> data = new TreeMap<>(); data.put("-1", new Object[] { dm.getColumnName(0), dm.getColumnName(1), dm.getColumnName(2), dm.getColumnName(3), dm.getColumnName(4), dm.getColumnName(5), dm.getColumnName(6) }); for (int i = 0; i < dm.getRowCount(); i++) { data.put(Integer.toString(i), new Object[] { getCellValue(i, 0), getCellValue(i, 1), getCellValue(i, 2), getCellValue(i, 3), getCellValue(i, 4), getCellValue(i, 5), getCellValue(i, 6) }); } Set<String> ids = data.keySet(); XSSFRow row; int rowID = 0; for (String key : ids) { row = ws.createRow(rowID++); Object[] values = data.get(key); int cellID = 0; for (Object o : values) { XSSFCell cell = row.createCell(cellID++); cell.setCellValue(o.toString()); } } FileOutputStream fos = new FileOutputStream(new File("D:/motors/sparexcel.xlsx")); wb.write(fos); fos.close(); } @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents private void initComponents() { jScrollPane3 = new javax.swing.JScrollPane(); jScrollPane2 = new javax.swing.JScrollPane(); table = new javax.swing.JTable(); jButton1 = new javax.swing.JButton(); jButton2 = new javax.swing.JButton(); jButton3 = new javax.swing.JButton(); jMenuBar5 = new javax.swing.JMenuBar(); jMenu5 = new javax.swing.JMenu(); jMenu12 = new javax.swing.JMenu(); jMenuItem26 = new javax.swing.JMenuItem(); jMenuItem27 = new javax.swing.JMenuItem(); jMenu13 = new javax.swing.JMenu(); jMenuItem28 = new javax.swing.JMenuItem(); jMenuItem4 = new javax.swing.JMenuItem(); jMenuItem5 = new javax.swing.JMenuItem(); jMenu6 = new javax.swing.JMenu(); jMenu14 = new javax.swing.JMenu(); jMenuItem29 = new javax.swing.JMenuItem(); jMenuItem30 = new javax.swing.JMenuItem(); jMenu15 = new javax.swing.JMenu(); jMenuItem6 = new javax.swing.JMenuItem(); jMenuItem31 = new javax.swing.JMenuItem(); jMenuItem32 = new javax.swing.JMenuItem(); jMenu7 = new javax.swing.JMenu(); jMenuItem9 = new javax.swing.JMenuItem(); jMenuItem13 = new javax.swing.JMenuItem(); jMenuItem33 = new javax.swing.JMenuItem(); jMenuItem15 = new javax.swing.JMenuItem(); jMenu8 = new javax.swing.JMenu(); jMenuItem10 = new javax.swing.JMenuItem(); jMenu16 = new javax.swing.JMenu(); jMenuItem11 = new javax.swing.JMenuItem(); jMenuItem12 = new javax.swing.JMenuItem(); jMenuItem16 = new javax.swing.JMenuItem(); jMenuItem17 = new javax.swing.JMenuItem(); jMenuItem18 = new javax.swing.JMenuItem(); jMenuItem19 = new javax.swing.JMenuItem(); jMenu17 = new javax.swing.JMenu(); jMenu18 = new javax.swing.JMenu(); jMenuItem7 = new javax.swing.JMenuItem(); jMenuItem8 = new javax.swing.JMenuItem(); jMenu9 = new javax.swing.JMenu(); jMenu19 = new javax.swing.JMenu(); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); setTitle("bharathmotors/spareparts/excel"); getContentPane().setLayout(null); table.setModel(new javax.swing.table.DefaultTableModel(new Object[][] { }, new String[] { })); jScrollPane2.setViewportView(table); jScrollPane3.setViewportView(jScrollPane2); getContentPane().add(jScrollPane3); jScrollPane3.setBounds(110, 50, 710, 400); jButton1.setFont(new java.awt.Font("Times New Roman", 0, 12)); // NOI18N jButton1.setText("RETRIEVE"); jButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1ActionPerformed(evt); } }); getContentPane().add(jButton1); jButton1.setBounds(850, 80, 110, 50); jButton2.setFont(new java.awt.Font("Times New Roman", 0, 12)); // NOI18N jButton2.setText("EXPORT"); jButton2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton2ActionPerformed(evt); } }); getContentPane().add(jButton2); jButton2.setBounds(850, 210, 110, 50); jButton3.setFont(new java.awt.Font("Times New Roman", 0, 12)); // NOI18N jButton3.setText("BACK"); jButton3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton3ActionPerformed(evt); } }); getContentPane().add(jButton3); jButton3.setBounds(850, 330, 110, 50); jMenu5.setText("StockEntry"); jMenu5.setMargin(new java.awt.Insets(0, 5, 0, 0)); jMenu5.setMaximumSize(new java.awt.Dimension(75, 32767)); jMenu12.setText("Motors"); jMenuItem26.setText("Bike"); jMenuItem26.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem26ActionPerformed(evt); } }); jMenu12.add(jMenuItem26); jMenuItem27.setText("Scooty"); jMenuItem27.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem27ActionPerformed(evt); } }); jMenu12.add(jMenuItem27); jMenu5.add(jMenu12); jMenu13.setText("Spare"); jMenuItem28.setText("Lubricants"); jMenuItem28.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem28ActionPerformed(evt); } }); jMenu13.add(jMenuItem28); jMenuItem4.setText("SpareParts"); jMenuItem4.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem4ActionPerformed(evt); } }); jMenu13.add(jMenuItem4); jMenuItem5.setText("Accessories"); jMenuItem5.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem5ActionPerformed(evt); } }); jMenu13.add(jMenuItem5); jMenu5.add(jMenu13); jMenuBar5.add(jMenu5); jMenu6.setText("Purchase"); jMenu6.setMargin(new java.awt.Insets(0, 5, 0, 0)); jMenu6.setMaximumSize(new java.awt.Dimension(75, 32767)); jMenu6.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenu6ActionPerformed(evt); } }); jMenu14.setText("Bill"); jMenuItem29.setText("Spare"); jMenuItem29.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem29ActionPerformed(evt); } }); jMenu14.add(jMenuItem29); jMenuItem30.setText("Motors"); jMenuItem30.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem30ActionPerformed(evt); } }); jMenu14.add(jMenuItem30); jMenu6.add(jMenu14); jMenuBar5.add(jMenu6); jMenu15.setText("Sale"); jMenu15.setMargin(new java.awt.Insets(0, 5, 0, 0)); jMenu15.setMaximumSize(new java.awt.Dimension(65, 32767)); jMenuItem6.setText("Sale"); jMenuItem6.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem6ActionPerformed(evt); } }); jMenu15.add(jMenuItem6); jMenuItem31.setText("Service"); jMenuItem31.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem31ActionPerformed(evt); } }); jMenu15.add(jMenuItem31); jMenuItem32.setText("Certificate"); jMenuItem32.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem32ActionPerformed(evt); } }); jMenu15.add(jMenuItem32); jMenuBar5.add(jMenu15); jMenu7.setText("StockAvailable"); jMenu7.setMargin(new java.awt.Insets(0, 5, 0, 0)); jMenu7.setMaximumSize(new java.awt.Dimension(115, 32767)); jMenu7.addMenuListener(new javax.swing.event.MenuListener() { public void menuCanceled(javax.swing.event.MenuEvent evt) { } public void menuDeselected(javax.swing.event.MenuEvent evt) { } public void menuSelected(javax.swing.event.MenuEvent evt) { jMenu7MenuSelected(evt); } }); jMenu7.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenu7ActionPerformed(evt); } }); jMenuItem9.setText("Motors"); jMenuItem9.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem9ActionPerformed(evt); } }); jMenu7.add(jMenuItem9); jMenuItem13.setText("Lubricants"); jMenuItem13.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem13ActionPerformed(evt); } }); jMenu7.add(jMenuItem13); jMenuItem33.setText("SpareParts"); jMenuItem33.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem33ActionPerformed(evt); } }); jMenu7.add(jMenuItem33); jMenuItem15.setText("Accessories"); jMenuItem15.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem15ActionPerformed(evt); } }); jMenu7.add(jMenuItem15); jMenuBar5.add(jMenu7); jMenu8.setText("Report"); jMenu8.setMargin(new java.awt.Insets(0, 5, 0, 0)); jMenu8.setMaximumSize(new java.awt.Dimension(60, 32767)); jMenu8.addMenuListener(new javax.swing.event.MenuListener() { public void menuCanceled(javax.swing.event.MenuEvent evt) { } public void menuDeselected(javax.swing.event.MenuEvent evt) { } public void menuSelected(javax.swing.event.MenuEvent evt) { jMenu8MenuSelected(evt); } }); jMenu8.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenu8ActionPerformed(evt); } }); jMenuItem10.setText("Sale"); jMenuItem10.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem10ActionPerformed(evt); } }); jMenu8.add(jMenuItem10); jMenu16.setText("Bill"); jMenuItem11.setText("BillNo"); jMenuItem11.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem11ActionPerformed(evt); } }); jMenu16.add(jMenuItem11); jMenuItem12.setText("BillDate"); jMenuItem12.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem12ActionPerformed(evt); } }); jMenu16.add(jMenuItem12); jMenu8.add(jMenu16); jMenuItem16.setText("Lubricants"); jMenuItem16.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem16ActionPerformed(evt); } }); jMenu8.add(jMenuItem16); jMenuItem17.setText("SpareParts"); jMenuItem17.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem17ActionPerformed(evt); } }); jMenu8.add(jMenuItem17); jMenuItem18.setText("Accessories"); jMenuItem18.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem18ActionPerformed(evt); } }); jMenu8.add(jMenuItem18); jMenuItem19.setText("Motors"); jMenuItem19.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem19ActionPerformed(evt); } }); jMenu8.add(jMenuItem19); jMenuBar5.add(jMenu8); jMenu17.setText("Payroll"); jMenu17.setMargin(new java.awt.Insets(0, 5, 0, 0)); jMenu17.setMaximumSize(new java.awt.Dimension(60, 32767)); jMenu17.addMenuListener(new javax.swing.event.MenuListener() { public void menuCanceled(javax.swing.event.MenuEvent evt) { } public void menuDeselected(javax.swing.event.MenuEvent evt) { } public void menuSelected(javax.swing.event.MenuEvent evt) { jMenu17MenuSelected(evt); } }); jMenuBar5.add(jMenu17); jMenu18.setLabel("Employee"); jMenu18.setMargin(new java.awt.Insets(0, 5, 0, 0)); jMenu18.setMaximumSize(new java.awt.Dimension(70, 32767)); jMenu18.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenu18ActionPerformed(evt); } }); jMenuItem7.setText("New"); jMenuItem7.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem7ActionPerformed(evt); } }); jMenu18.add(jMenuItem7); jMenuItem8.setText("Update/Delete"); jMenuItem8.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem8ActionPerformed(evt); } }); jMenu18.add(jMenuItem8); jMenuBar5.add(jMenu18); jMenu9.setText("AboutUs"); jMenu9.setMargin(new java.awt.Insets(0, 5, 0, 0)); jMenu9.setMaximumSize(new java.awt.Dimension(75, 32767)); jMenu9.addMenuListener(new javax.swing.event.MenuListener() { public void menuCanceled(javax.swing.event.MenuEvent evt) { } public void menuDeselected(javax.swing.event.MenuEvent evt) { } public void menuSelected(javax.swing.event.MenuEvent evt) { jMenu9MenuSelected(evt); } }); jMenu9.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenu9ActionPerformed(evt); } }); jMenuBar5.add(jMenu9); jMenu19.setText("Exit"); jMenu19.setMargin(new java.awt.Insets(0, 5, 0, 0)); jMenu19.setMaximumSize(new java.awt.Dimension(35, 32767)); jMenu19.addMenuListener(new javax.swing.event.MenuListener() { public void menuCanceled(javax.swing.event.MenuEvent evt) { } public void menuDeselected(javax.swing.event.MenuEvent evt) { } public void menuSelected(javax.swing.event.MenuEvent evt) { jMenu19MenuSelected(evt); } }); jMenu19.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenu19ActionPerformed(evt); } }); jMenuBar5.add(jMenu19); setJMenuBar(jMenuBar5); pack(); }// </editor-fold>//GEN-END:initComponents private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed // TODO add your handling code here: table.setModel(getdata()); }//GEN-LAST:event_jButton1ActionPerformed private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed // TODO add your handling code here: try { // TODO add your handling code here: writeToExcel(); JOptionPane.showMessageDialog(null, "Export"); } catch (IOException ex) { Logger.getLogger(saleexcel.class.getName()).log(Level.SEVERE, null, ex); } }//GEN-LAST:event_jButton2ActionPerformed private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed // TODO add your handling code here: Stock s = new Stock(); s.setVisible(true); setVisible(false); dispose(); }//GEN-LAST:event_jButton3ActionPerformed private void jMenuItem26ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem26ActionPerformed Bike b = new Bike(); b.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem26ActionPerformed private void jMenuItem27ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem27ActionPerformed Scooty s = new Scooty(); s.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem27ActionPerformed private void jMenuItem28ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem28ActionPerformed Lubricants l = new Lubricants(); l.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem28ActionPerformed private void jMenuItem4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem4ActionPerformed SpareParts p = new SpareParts(); p.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem4ActionPerformed private void jMenuItem5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem5ActionPerformed Accessories a = new Accessories(); a.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem5ActionPerformed private void jMenuItem29ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem29ActionPerformed // TODO add your handling code here: Billspare b = new Billspare(); b.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem29ActionPerformed private void jMenuItem30ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem30ActionPerformed // TODO add your handling code here: billmotors b = new billmotors(); b.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem30ActionPerformed private void jMenu6ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenu6ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_jMenu6ActionPerformed private void jMenuItem6ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem6ActionPerformed // TODO add your handling code here: Sale s = new Sale(); s.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem6ActionPerformed private void jMenuItem31ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem31ActionPerformed // TODO add your handling code here: Service s = new Service(); s.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem31ActionPerformed private void jMenuItem32ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem32ActionPerformed // TODO add your handling code here: salescert c = new salescert(); c.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem32ActionPerformed private void jMenuItem9ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem9ActionPerformed // TODO add your handling code here: stockAvilable s = new stockAvilable(); s.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem9ActionPerformed private void jMenuItem13ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem13ActionPerformed // TODO add your handling code here: stockLubricants s = new stockLubricants(); s.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem13ActionPerformed private void jMenuItem33ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem33ActionPerformed // TODO add your handling code here: stockspareparts s = new stockspareparts(); s.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem33ActionPerformed private void jMenuItem15ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem15ActionPerformed // TODO add your handling code here: stockaccessories s = new stockaccessories(); s.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem15ActionPerformed private void jMenu7MenuSelected(javax.swing.event.MenuEvent evt) {//GEN-FIRST:event_jMenu7MenuSelected // TODO add your handling code here: }//GEN-LAST:event_jMenu7MenuSelected private void jMenu7ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenu7ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_jMenu7ActionPerformed private void jMenuItem10ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem10ActionPerformed // TODO add your handling code here: Report1 r = new Report1(); r.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem10ActionPerformed private void jMenuItem11ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem11ActionPerformed // TODO add your handling code here: Report3 r = new Report3(); r.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem11ActionPerformed private void jMenuItem12ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem12ActionPerformed Report r = new Report(); r.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem12ActionPerformed private void jMenuItem16ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem16ActionPerformed // TODO add your handling code here: lubricantsreport l = new lubricantsreport(); l.setVisible(true); setVisible(false); dispose(); }//GEN-LAST:event_jMenuItem16ActionPerformed private void jMenuItem17ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem17ActionPerformed // TODO add your handling code here: sparepartsreport s = new sparepartsreport(); s.setVisible(true); setVisible(false); dispose(); }//GEN-LAST:event_jMenuItem17ActionPerformed private void jMenuItem18ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem18ActionPerformed // TODO add your handling code here: accessoriessreport a = new accessoriessreport(); a.setVisible(true); setVisible(false); dispose(); }//GEN-LAST:event_jMenuItem18ActionPerformed private void jMenuItem19ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem19ActionPerformed // TODO add your handling code here: motorsreport m = new motorsreport(); m.setVisible(true); setVisible(false); dispose(); }//GEN-LAST:event_jMenuItem19ActionPerformed private void jMenu8MenuSelected(javax.swing.event.MenuEvent evt) {//GEN-FIRST:event_jMenu8MenuSelected }//GEN-LAST:event_jMenu8MenuSelected private void jMenu8ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenu8ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_jMenu8ActionPerformed private void jMenu17MenuSelected(javax.swing.event.MenuEvent evt) {//GEN-FIRST:event_jMenu17MenuSelected // TODO add your handling code here: payroll p = new payroll(); p.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenu17MenuSelected private void jMenuItem7ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem7ActionPerformed // TODO add your handling code here: EmployeeEntry u = new EmployeeEntry(); u.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem7ActionPerformed private void jMenuItem8ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem8ActionPerformed // TODO add your handling code here: empupdate u = new empupdate(); u.setVisible(true); setVisible(false); dispose(); }//GEN-LAST:event_jMenuItem8ActionPerformed private void jMenu18ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenu18ActionPerformed // TODO add your handling code here: empupdate u = new empupdate(); u.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenu18ActionPerformed private void jMenu9MenuSelected(javax.swing.event.MenuEvent evt) {//GEN-FIRST:event_jMenu9MenuSelected // TODO add your handling code here: company1 c = new company1(); c.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenu9MenuSelected private void jMenu9ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenu9ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_jMenu9ActionPerformed private void jMenu19MenuSelected(javax.swing.event.MenuEvent evt) {//GEN-FIRST:event_jMenu19MenuSelected String message = " Are you sure you want to exit the application!!! "; int answer = JOptionPane.showConfirmDialog(null, message, "Confirmation!!!", JOptionPane.YES_NO_OPTION); if (answer == JOptionPane.YES_OPTION) { dispose(); } else if (answer == JOptionPane.NO_OPTION) { // User clicked NO. } }//GEN-LAST:event_jMenu19MenuSelected private void jMenu19ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenu19ActionPerformed }//GEN-LAST:event_jMenu19ActionPerformed /** * @param args the command line arguments */ public static void main(String args[]) { /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */ try { for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) { if ("Nimbus".equals(info.getName())) { javax.swing.UIManager.setLookAndFeel(info.getClassName()); break; } } } catch (ClassNotFoundException ex) { java.util.logging.Logger.getLogger(spareexcel.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(spareexcel.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(spareexcel.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(spareexcel.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold> /* Create and display the form */ java.awt.EventQueue.invokeLater(new Runnable() { public void run() { new spareexcel().setVisible(true); } }); } // Variables declaration - do not modify//GEN-BEGIN:variables private javax.swing.JButton jButton1; private javax.swing.JButton jButton2; private javax.swing.JButton jButton3; private javax.swing.JMenu jMenu12; private javax.swing.JMenu jMenu13; private javax.swing.JMenu jMenu14; private javax.swing.JMenu jMenu15; private javax.swing.JMenu jMenu16; private javax.swing.JMenu jMenu17; private javax.swing.JMenu jMenu18; private javax.swing.JMenu jMenu19; private javax.swing.JMenu jMenu5; private javax.swing.JMenu jMenu6; private javax.swing.JMenu jMenu7; private javax.swing.JMenu jMenu8; private javax.swing.JMenu jMenu9; private javax.swing.JMenuBar jMenuBar5; private javax.swing.JMenuItem jMenuItem10; private javax.swing.JMenuItem jMenuItem11; private javax.swing.JMenuItem jMenuItem12; private javax.swing.JMenuItem jMenuItem13; private javax.swing.JMenuItem jMenuItem15; private javax.swing.JMenuItem jMenuItem16; private javax.swing.JMenuItem jMenuItem17; private javax.swing.JMenuItem jMenuItem18; private javax.swing.JMenuItem jMenuItem19; private javax.swing.JMenuItem jMenuItem26; private javax.swing.JMenuItem jMenuItem27; private javax.swing.JMenuItem jMenuItem28; private javax.swing.JMenuItem jMenuItem29; private javax.swing.JMenuItem jMenuItem30; private javax.swing.JMenuItem jMenuItem31; private javax.swing.JMenuItem jMenuItem32; private javax.swing.JMenuItem jMenuItem33; private javax.swing.JMenuItem jMenuItem4; private javax.swing.JMenuItem jMenuItem5; private javax.swing.JMenuItem jMenuItem6; private javax.swing.JMenuItem jMenuItem7; private javax.swing.JMenuItem jMenuItem8; private javax.swing.JMenuItem jMenuItem9; private javax.swing.JScrollPane jScrollPane2; private javax.swing.JScrollPane jScrollPane3; private javax.swing.JTable table; // End of variables declaration//GEN-END:variables }