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.text.MessageFormat; 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.JTable; import javax.swing.table.DefaultTableModel; import net.proteanit.sql.DbUtils; 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 Viewsale extends javax.swing.JFrame { String constring = "jdbc:mysql://localhost:3306/bharatmotors"; String username = "root"; String password = ""; DefaultTableModel dm = new DefaultTableModel(); public Viewsale() { initComponents(); } private DefaultTableModel getdata() { dm.addColumn("DATE"); dm.addColumn("CUST_NAME"); dm.addColumn("CUST_ADDR"); dm.addColumn("PHN_NO"); dm.addColumn("ALT_NO"); dm.addColumn("ITEM_NAME"); dm.addColumn("MANUF_YEAR"); dm.addColumn("ENGINE_NO"); dm.addColumn("CHASE_NO"); dm.addColumn("COLOR"); dm.addColumn("HYPO/FINANCE"); dm.addColumn("OFFERS"); dm.addColumn("DISCOUNT"); dm.addColumn("ADVANCE"); dm.addColumn("INSURANCE"); dm.addColumn("TOTAL"); String sql = "SELECT * FROM SALE"; 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(1); String name = rs.getString(2); String addr = rs.getString(3); String veh = rs.getString(4); String no = rs.getString(5); String eng = rs.getString(6); String eng1 = rs.getString(7); String dt1 = rs.getString(8); String name1 = rs.getString(9); String addr1 = rs.getString(10); String veh1 = rs.getString(11); String no1 = rs.getString(12); String eng2 = rs.getString(13); String eng3 = rs.getString(14); String eng4 = rs.getString(15); String eng5 = rs.getString(16); String[] rowdata = { dt, name, addr, veh, no, eng, eng1, dt1, name1, addr1, veh1, no1, eng2, eng3, eng4, eng5 }; 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), dm.getColumnName(7), dm.getColumnName(8), dm.getColumnName(9), dm.getColumnName(10), dm.getColumnName(11), dm.getColumnName(12), dm.getColumnName(13), dm.getColumnName(14), dm.getColumnName(15) }); 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), getCellValue(i, 7), getCellValue(i, 8), getCellValue(i, 9), getCellValue(i, 10), getCellValue(i, 11), getCellValue(i, 12), getCellValue(i, 13), getCellValue(i, 14), getCellValue(i, 15) }); } 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/saleview.xlsx")); wb.write(fos); fos.close(); } /** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always * regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents private void initComponents() { jScrollPane1 = new javax.swing.JScrollPane(); jScrollPane2 = new javax.swing.JScrollPane(); table = new javax.swing.JTable(); jLabel1 = new javax.swing.JLabel(); jLabel2 = new javax.swing.JLabel(); jButton2 = new javax.swing.JButton(); jButton3 = new javax.swing.JButton(); jButton1 = new javax.swing.JButton(); jMenuBar1 = new javax.swing.JMenuBar(); jMenu1 = new javax.swing.JMenu(); jMenu8 = new javax.swing.JMenu(); jMenuItem1 = new javax.swing.JMenuItem(); jMenuItem2 = new javax.swing.JMenuItem(); jMenu9 = new javax.swing.JMenu(); jMenuItem3 = new javax.swing.JMenuItem(); jMenuItem4 = new javax.swing.JMenuItem(); jMenuItem5 = new javax.swing.JMenuItem(); jMenu2 = new javax.swing.JMenu(); jMenu13 = new javax.swing.JMenu(); jMenuItem20 = new javax.swing.JMenuItem(); jMenuItem21 = new javax.swing.JMenuItem(); jMenu14 = new javax.swing.JMenu(); jMenuItem6 = new javax.swing.JMenuItem(); jMenuItem22 = new javax.swing.JMenuItem(); jMenuItem23 = new javax.swing.JMenuItem(); jMenu3 = new javax.swing.JMenu(); jMenuItem9 = new javax.swing.JMenuItem(); jMenuItem13 = new javax.swing.JMenuItem(); jMenuItem14 = new javax.swing.JMenuItem(); jMenuItem15 = new javax.swing.JMenuItem(); jMenu4 = new javax.swing.JMenu(); jMenuItem10 = new javax.swing.JMenuItem(); jMenu12 = 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(); jMenu10 = new javax.swing.JMenu(); jMenu11 = new javax.swing.JMenu(); jMenuItem7 = new javax.swing.JMenuItem(); jMenuItem8 = new javax.swing.JMenuItem(); jMenu5 = new javax.swing.JMenu(); jMenu7 = new javax.swing.JMenu(); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); table.setModel(new javax.swing.table.DefaultTableModel(new Object[][] { }, new String[] { })); jScrollPane2.setViewportView(table); jScrollPane1.setViewportView(jScrollPane2); jLabel1.setFont(new java.awt.Font("Times New Roman", 1, 30)); // NOI18N jLabel1.setForeground(new java.awt.Color(0, 0, 153)); jLabel1.setText("BHARATHMOTORS"); jLabel2.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N jLabel2.setText("Sale Details"); jButton2.setText("jButton2"); jButton3.setFont(new java.awt.Font("Times New Roman", 0, 12)); // NOI18N jButton3.setText("EXPORT"); jButton3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton3ActionPerformed(evt); } }); 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); } }); jMenu1.setText("StockEntry"); jMenu1.setMargin(new java.awt.Insets(0, 5, 0, 0)); jMenu1.setMaximumSize(new java.awt.Dimension(75, 32767)); jMenu8.setText("Motors"); jMenuItem1.setText("Bike"); jMenuItem1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem1ActionPerformed(evt); } }); jMenu8.add(jMenuItem1); jMenuItem2.setText("Scooty"); jMenuItem2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem2ActionPerformed(evt); } }); jMenu8.add(jMenuItem2); jMenu1.add(jMenu8); jMenu9.setText("Spare"); jMenuItem3.setText("Lubricants"); jMenuItem3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem3ActionPerformed(evt); } }); jMenu9.add(jMenuItem3); jMenuItem4.setText("SpareParts"); jMenuItem4.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem4ActionPerformed(evt); } }); jMenu9.add(jMenuItem4); jMenuItem5.setText("Accessories"); jMenuItem5.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem5ActionPerformed(evt); } }); jMenu9.add(jMenuItem5); jMenu1.add(jMenu9); jMenuBar1.add(jMenu1); jMenu2.setText("Purchase"); jMenu2.setMargin(new java.awt.Insets(0, 5, 0, 0)); jMenu2.setMaximumSize(new java.awt.Dimension(75, 32767)); jMenu2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenu2ActionPerformed(evt); } }); jMenu13.setText("Bill"); jMenuItem20.setText("Spare"); jMenuItem20.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem20ActionPerformed(evt); } }); jMenu13.add(jMenuItem20); jMenuItem21.setText("Motors"); jMenuItem21.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem21ActionPerformed(evt); } }); jMenu13.add(jMenuItem21); jMenu2.add(jMenu13); jMenuBar1.add(jMenu2); jMenu14.setText("Sale"); jMenu14.setMargin(new java.awt.Insets(0, 5, 0, 0)); jMenu14.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); } }); jMenu14.add(jMenuItem6); jMenuItem22.setText("Service"); jMenuItem22.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem22ActionPerformed(evt); } }); jMenu14.add(jMenuItem22); jMenuItem23.setText("Certificate"); jMenuItem23.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem23ActionPerformed(evt); } }); jMenu14.add(jMenuItem23); jMenuBar1.add(jMenu14); jMenu3.setText("StockAvailable"); jMenu3.setMargin(new java.awt.Insets(0, 5, 0, 0)); jMenu3.setMaximumSize(new java.awt.Dimension(115, 32767)); jMenu3.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) { jMenu3MenuSelected(evt); } }); jMenu3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenu3ActionPerformed(evt); } }); jMenuItem9.setText("Motors"); jMenuItem9.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem9ActionPerformed(evt); } }); jMenu3.add(jMenuItem9); jMenuItem13.setText("Lubricants"); jMenuItem13.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem13ActionPerformed(evt); } }); jMenu3.add(jMenuItem13); jMenuItem14.setText("SpareParts"); jMenuItem14.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem14ActionPerformed(evt); } }); jMenu3.add(jMenuItem14); jMenuItem15.setText("Accessories"); jMenuItem15.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem15ActionPerformed(evt); } }); jMenu3.add(jMenuItem15); jMenuBar1.add(jMenu3); jMenu4.setText("Report"); jMenu4.setMargin(new java.awt.Insets(0, 5, 0, 0)); jMenu4.setMaximumSize(new java.awt.Dimension(60, 32767)); jMenu4.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) { jMenu4MenuSelected(evt); } }); jMenu4.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenu4ActionPerformed(evt); } }); jMenuItem10.setText("Sale"); jMenuItem10.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem10ActionPerformed(evt); } }); jMenu4.add(jMenuItem10); jMenu12.setText("Bill"); jMenuItem11.setText("BillNo"); jMenuItem11.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem11ActionPerformed(evt); } }); jMenu12.add(jMenuItem11); jMenuItem12.setText("BillDate"); jMenuItem12.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem12ActionPerformed(evt); } }); jMenu12.add(jMenuItem12); jMenu4.add(jMenu12); jMenuItem16.setText("Lubricants"); jMenuItem16.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem16ActionPerformed(evt); } }); jMenu4.add(jMenuItem16); jMenuItem17.setText("SpareParts"); jMenuItem17.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem17ActionPerformed(evt); } }); jMenu4.add(jMenuItem17); jMenuItem18.setText("Accessories"); jMenuItem18.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem18ActionPerformed(evt); } }); jMenu4.add(jMenuItem18); jMenuItem19.setText("Motors"); jMenuItem19.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem19ActionPerformed(evt); } }); jMenu4.add(jMenuItem19); jMenuBar1.add(jMenu4); jMenu10.setText("Payroll"); jMenu10.setMargin(new java.awt.Insets(0, 5, 0, 0)); jMenu10.setMaximumSize(new java.awt.Dimension(60, 32767)); jMenu10.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) { jMenu10MenuSelected(evt); } }); jMenuBar1.add(jMenu10); jMenu11.setLabel("Employee"); jMenu11.setMargin(new java.awt.Insets(0, 5, 0, 0)); jMenu11.setMaximumSize(new java.awt.Dimension(70, 32767)); jMenu11.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenu11ActionPerformed(evt); } }); jMenuItem7.setText("New"); jMenuItem7.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem7ActionPerformed(evt); } }); jMenu11.add(jMenuItem7); jMenuItem8.setText("Update/Delete"); jMenuItem8.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem8ActionPerformed(evt); } }); jMenu11.add(jMenuItem8); jMenuBar1.add(jMenu11); jMenu5.setText("AboutUs"); jMenu5.setMargin(new java.awt.Insets(0, 5, 0, 0)); jMenu5.setMaximumSize(new java.awt.Dimension(75, 32767)); jMenu5.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) { jMenu5MenuSelected(evt); } }); jMenu5.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenu5ActionPerformed(evt); } }); jMenuBar1.add(jMenu5); jMenu7.setText("Exit"); jMenu7.setMargin(new java.awt.Insets(0, 5, 0, 0)); jMenu7.setMaximumSize(new java.awt.Dimension(35, 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); } }); jMenuBar1.add(jMenu7); setJMenuBar(jMenuBar1); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup().addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup().addGap(423, 423, 423).addComponent(jLabel1)) .addGroup(layout.createSequentialGroup().addGap(68, 68, 68) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 182, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 1263, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(layout.createSequentialGroup().addGap(11, 11, 11) .addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 89, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(30, 30, 30) .addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 98, javax.swing.GroupLayout.PREFERRED_SIZE))))) .addContainerGap(423, Short.MAX_VALUE))); layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup().addContainerGap() .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(118, 118, 118) .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 27, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 394, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(28, 28, 28) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 38, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 38, javax.swing.GroupLayout.PREFERRED_SIZE)) .addContainerGap(89, Short.MAX_VALUE))); pack(); }// </editor-fold>//GEN-END:initComponents private void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem1ActionPerformed Bike b = new Bike(); b.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem1ActionPerformed private void jMenuItem2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem2ActionPerformed Scooty s = new Scooty(); s.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem2ActionPerformed private void jMenuItem3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem3ActionPerformed Lubricants l = new Lubricants(); l.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem3ActionPerformed 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 jMenuItem20ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem20ActionPerformed // TODO add your handling code here: Billspare b = new Billspare(); b.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem20ActionPerformed private void jMenuItem21ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem21ActionPerformed // TODO add your handling code here: billmotors b = new billmotors(); b.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem21ActionPerformed private void jMenu2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenu2ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_jMenu2ActionPerformed 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 jMenuItem22ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem22ActionPerformed // TODO add your handling code here: Service s = new Service(); s.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem22ActionPerformed private void jMenuItem23ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem23ActionPerformed // TODO add your handling code here: salescert c = new salescert(); c.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem23ActionPerformed 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 jMenuItem14ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem14ActionPerformed // TODO add your handling code here: stockspareparts s = new stockspareparts(); s.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem14ActionPerformed 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 jMenu3MenuSelected(javax.swing.event.MenuEvent evt) {//GEN-FIRST:event_jMenu3MenuSelected // TODO add your handling code here: }//GEN-LAST:event_jMenu3MenuSelected private void jMenu3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenu3ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_jMenu3ActionPerformed 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 jMenu4MenuSelected(javax.swing.event.MenuEvent evt) {//GEN-FIRST:event_jMenu4MenuSelected }//GEN-LAST:event_jMenu4MenuSelected private void jMenu4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenu4ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_jMenu4ActionPerformed private void jMenu10MenuSelected(javax.swing.event.MenuEvent evt) {//GEN-FIRST:event_jMenu10MenuSelected // TODO add your handling code here: payroll p = new payroll(); p.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenu10MenuSelected 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 jMenu11ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenu11ActionPerformed // TODO add your handling code here: empupdate u = new empupdate(); u.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenu11ActionPerformed private void jMenu5MenuSelected(javax.swing.event.MenuEvent evt) {//GEN-FIRST:event_jMenu5MenuSelected // TODO add your handling code here: company1 c = new company1(); c.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenu5MenuSelected private void jMenu5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenu5ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_jMenu5ActionPerformed private void jMenu7MenuSelected(javax.swing.event.MenuEvent evt) {//GEN-FIRST:event_jMenu7MenuSelected 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_jMenu7MenuSelected private void jMenu7ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenu7ActionPerformed }//GEN-LAST:event_jMenu7ActionPerformed private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed // TODO add your handling code here:export 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_jButton3ActionPerformed 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 /** * @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(Viewsale.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(Viewsale.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(Viewsale.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(Viewsale.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 Viewsale().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.JLabel jLabel1; private javax.swing.JLabel jLabel2; private javax.swing.JMenu jMenu1; private javax.swing.JMenu jMenu10; private javax.swing.JMenu jMenu11; private javax.swing.JMenu jMenu12; private javax.swing.JMenu jMenu13; private javax.swing.JMenu jMenu14; private javax.swing.JMenu jMenu2; private javax.swing.JMenu jMenu3; private javax.swing.JMenu jMenu4; private javax.swing.JMenu jMenu5; private javax.swing.JMenu jMenu7; private javax.swing.JMenu jMenu8; private javax.swing.JMenu jMenu9; private javax.swing.JMenuBar jMenuBar1; private javax.swing.JMenuItem jMenuItem1; private javax.swing.JMenuItem jMenuItem10; private javax.swing.JMenuItem jMenuItem11; private javax.swing.JMenuItem jMenuItem12; private javax.swing.JMenuItem jMenuItem13; private javax.swing.JMenuItem jMenuItem14; 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 jMenuItem2; private javax.swing.JMenuItem jMenuItem20; private javax.swing.JMenuItem jMenuItem21; private javax.swing.JMenuItem jMenuItem22; private javax.swing.JMenuItem jMenuItem23; private javax.swing.JMenuItem jMenuItem3; 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 jScrollPane1; private javax.swing.JScrollPane jScrollPane2; private javax.swing.JTable table; // End of variables declaration//GEN-END:variables }