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 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 Viewservice extends javax.swing.JFrame { String constring = "jdbc:mysql://localhost:3306/bharatmotors"; String username = "root"; String password = ""; DefaultTableModel dm = new DefaultTableModel(); public Viewservice() { initComponents(); } private DefaultTableModel getdata() { dm.addColumn("NO"); dm.addColumn("DATE"); dm.addColumn("JOBCARDNO"); dm.addColumn("NAME"); dm.addColumn("PHNNO"); dm.addColumn("REGISTERNO"); dm.addColumn("MODEL"); dm.addColumn("COLOR"); dm.addColumn("MODE"); dm.addColumn("BILL"); dm.addColumn("MECHANIC"); dm.addColumn("LABOUR"); dm.addColumn("SPARE"); dm.addColumn("OIL"); dm.addColumn("WASHING"); dm.addColumn("CONSUMABLE"); dm.addColumn("OTHER"); dm.addColumn("DUE"); dm.addColumn("FEEDBACK"); String sql = "SELECT * FROM SERVICE "; 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 eng6 = rs.getString(17); String eng7 = rs.getString(18); String eng8 = rs.getString(19); String[] rowdata = { dt, name, addr, veh, no, eng, eng1, dt1, name1, addr1, veh1, no1, eng2, eng3, eng4, eng5, eng6, eng7, eng8 }; 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), dm.getColumnName(16), dm.getColumnName(17), dm.getColumnName(18) }); 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), getCellValue(i, 16), getCellValue(i, 17), getCellValue(i, 18) }); } 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/serviceview.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() { jLabel1 = new javax.swing.JLabel(); jScrollPane1 = new javax.swing.JScrollPane(); jScrollPane2 = new javax.swing.JScrollPane(); table = new javax.swing.JTable(); jLabel2 = new javax.swing.JLabel(); jButton1 = new javax.swing.JButton(); jButton2 = 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(); jMenu21 = 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(); jMenuItem21 = new javax.swing.JMenuItem(); jMenuItem22 = new javax.swing.JMenuItem(); jMenu22 = new javax.swing.JMenu(); jMenuItem6 = new javax.swing.JMenuItem(); jMenuItem23 = new javax.swing.JMenuItem(); jMenuItem24 = 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(); jMenu23 = 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(); jMenu24 = new javax.swing.JMenu(); jMenu25 = new javax.swing.JMenu(); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); jLabel1.setFont(new java.awt.Font("Times New Roman", 1, 30)); // NOI18N jLabel1.setForeground(new java.awt.Color(0, 0, 153)); jLabel1.setText("BHARATHMOTORS"); table.setModel(new javax.swing.table.DefaultTableModel(new Object[][] { }, new String[] { })); jScrollPane2.setViewportView(table); jScrollPane1.setViewportView(jScrollPane2); jLabel2.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N jLabel2.setText("Service Details"); jButton1.setFont(new java.awt.Font("Times New Roman", 0, 12)); // NOI18N jButton1.setText("EXPORT"); jButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1ActionPerformed(evt); } }); jButton2.setFont(new java.awt.Font("Times New Roman", 0, 12)); // NOI18N jButton2.setText("RETRIEVE"); jButton2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton2ActionPerformed(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); jMenu21.setText("Spare"); jMenuItem3.setText("Lubricants"); jMenuItem3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem3ActionPerformed(evt); } }); jMenu21.add(jMenuItem3); jMenuItem4.setText("SpareParts"); jMenuItem4.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem4ActionPerformed(evt); } }); jMenu21.add(jMenuItem4); jMenuItem5.setText("Accessories"); jMenuItem5.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem5ActionPerformed(evt); } }); jMenu21.add(jMenuItem5); jMenu1.add(jMenu21); 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"); jMenuItem21.setText("Spare"); jMenuItem21.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem21ActionPerformed(evt); } }); jMenu13.add(jMenuItem21); jMenuItem22.setText("Motors"); jMenuItem22.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem22ActionPerformed(evt); } }); jMenu13.add(jMenuItem22); jMenu2.add(jMenu13); jMenuBar1.add(jMenu2); jMenu22.setText("Sale"); jMenu22.setMargin(new java.awt.Insets(0, 5, 0, 0)); jMenu22.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); } }); jMenu22.add(jMenuItem6); jMenuItem23.setText("Service"); jMenuItem23.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem23ActionPerformed(evt); } }); jMenu22.add(jMenuItem23); jMenuItem24.setText("Certificate"); jMenuItem24.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem24ActionPerformed(evt); } }); jMenu22.add(jMenuItem24); jMenuBar1.add(jMenu22); 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); jMenu23.setText("Report"); jMenu23.setMargin(new java.awt.Insets(0, 5, 0, 0)); jMenu23.setMaximumSize(new java.awt.Dimension(60, 32767)); jMenu23.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) { jMenu23MenuSelected(evt); } }); jMenu23.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenu23ActionPerformed(evt); } }); jMenuItem10.setText("Sale"); jMenuItem10.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem10ActionPerformed(evt); } }); jMenu23.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); jMenu23.add(jMenu12); jMenuItem16.setText("Lubricants"); jMenuItem16.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem16ActionPerformed(evt); } }); jMenu23.add(jMenuItem16); jMenuItem17.setText("SpareParts"); jMenuItem17.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem17ActionPerformed(evt); } }); jMenu23.add(jMenuItem17); jMenuItem18.setText("Accessories"); jMenuItem18.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem18ActionPerformed(evt); } }); jMenu23.add(jMenuItem18); jMenuItem19.setText("Motors"); jMenuItem19.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenuItem19ActionPerformed(evt); } }); jMenu23.add(jMenuItem19); jMenuBar1.add(jMenu23); 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); jMenu24.setText("AboutUs"); jMenu24.setMargin(new java.awt.Insets(0, 5, 0, 0)); jMenu24.setMaximumSize(new java.awt.Dimension(75, 32767)); jMenu24.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) { jMenu24MenuSelected(evt); } }); jMenu24.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenu24ActionPerformed(evt); } }); jMenuBar1.add(jMenu24); jMenu25.setText("Exit"); jMenu25.setMargin(new java.awt.Insets(0, 5, 0, 0)); jMenu25.setMaximumSize(new java.awt.Dimension(35, 32767)); jMenu25.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) { jMenu25MenuSelected(evt); } }); jMenu25.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jMenu25ActionPerformed(evt); } }); jMenuBar1.add(jMenu25); 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() .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 170, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 1297, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(layout.createSequentialGroup() .addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 89, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(39, 39, 39).addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 93, javax.swing.GroupLayout.PREFERRED_SIZE))) .addContainerGap(56, Short.MAX_VALUE)) .addGroup(layout.createSequentialGroup().addGap(388, 388, 388).addComponent(jLabel1) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))); layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup().addContainerGap() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 38, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(layout.createSequentialGroup() .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(76, 76, 76) .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18) .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 331, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(27, 27, 27).addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 45, javax.swing.GroupLayout.PREFERRED_SIZE))) .addContainerGap(372, 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 jMenuItem21ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem21ActionPerformed // TODO add your handling code here: Billspare b = new Billspare(); b.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem21ActionPerformed private void jMenuItem22ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem22ActionPerformed // TODO add your handling code here: billmotors b = new billmotors(); b.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem22ActionPerformed 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 jMenuItem23ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem23ActionPerformed // TODO add your handling code here: Service s = new Service(); s.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem23ActionPerformed private void jMenuItem24ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem24ActionPerformed // TODO add your handling code here: salescert c = new salescert(); c.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenuItem24ActionPerformed 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 jMenu23MenuSelected(javax.swing.event.MenuEvent evt) {//GEN-FIRST:event_jMenu23MenuSelected }//GEN-LAST:event_jMenu23MenuSelected private void jMenu23ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenu23ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_jMenu23ActionPerformed 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 jMenu24MenuSelected(javax.swing.event.MenuEvent evt) {//GEN-FIRST:event_jMenu24MenuSelected // TODO add your handling code here: company1 c = new company1(); c.setVisible(true); setVisible(false); }//GEN-LAST:event_jMenu24MenuSelected private void jMenu24ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenu24ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_jMenu24ActionPerformed private void jMenu25MenuSelected(javax.swing.event.MenuEvent evt) {//GEN-FIRST:event_jMenu25MenuSelected 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_jMenu25MenuSelected private void jMenu25ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenu25ActionPerformed }//GEN-LAST:event_jMenu25ActionPerformed private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed // 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_jButton1ActionPerformed private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed // TODO add your handling code here: table.setModel(getdata()); }//GEN-LAST:event_jButton2ActionPerformed /** * @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(Viewservice.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(Viewservice.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(Viewservice.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(Viewservice.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 Viewservice().setVisible(true); } }); } // Variables declaration - do not modify//GEN-BEGIN:variables private javax.swing.JButton jButton1; private javax.swing.JButton jButton2; 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 jMenu2; private javax.swing.JMenu jMenu21; private javax.swing.JMenu jMenu22; private javax.swing.JMenu jMenu23; private javax.swing.JMenu jMenu24; private javax.swing.JMenu jMenu25; private javax.swing.JMenu jMenu3; private javax.swing.JMenu jMenu8; 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 jMenuItem21; private javax.swing.JMenuItem jMenuItem22; private javax.swing.JMenuItem jMenuItem23; private javax.swing.JMenuItem jMenuItem24; 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 }