Java tutorial
/* Optical Workshop Monitoring System is a desktop application to fulfill the workflow control requirement at IRDE (DRDO) Dehradun. Copyright (C) 2014 Mayank Chaudhari (devil15) This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program. If not, see <http://www.gnu.org/licenses/>. For any query mail me at m.charly3015@gmail.com */ package opticalworkshopmonitoringsystem; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.text.SimpleDateFormat; import java.util.Date; import javax.swing.JOptionPane; import org.joda.time.DateTime; import org.joda.time.Days; /** * * @author devil15 */ public class GrindingUpdate extends javax.swing.JFrame { static String project, component; static String slicing_machine; static String cg_tool; static String trepening_tool; static String ssdate, sedate, stime; static String tsdate, tedate, ttime; static String cgsdate, cgedate, cgtime; static String gsdate, gedate, gtime; static String is1date, iedate, itime; static String grinding_tool; static int s = 0, t = 0, cg = 0, g = 0, i = 0, total = 0, total_time = 0; /** * Creates new form GrindingUpdate */ public GrindingUpdate() { initComponents(); fill_trepening(); fill_grinding(); } /** * 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(); jPanel1 = new javax.swing.JPanel(); jLabel1 = new javax.swing.JLabel(); jLabel2 = new javax.swing.JLabel(); jLabel3 = new javax.swing.JLabel(); jTextField1 = new javax.swing.JTextField(); jTextField2 = new javax.swing.JTextField(); jButton1 = new javax.swing.JButton(); jLabel4 = new javax.swing.JLabel(); jComboBox1 = new javax.swing.JComboBox(); jLabel5 = new javax.swing.JLabel(); jLabel6 = new javax.swing.JLabel(); jTextField3 = new javax.swing.JTextField(); jLabel7 = new javax.swing.JLabel(); jTextField4 = new javax.swing.JTextField(); jLabel8 = new javax.swing.JLabel(); jTextField5 = new javax.swing.JTextField(); jLabel9 = new javax.swing.JLabel(); jTextField6 = new javax.swing.JTextField(); jPanel3 = new javax.swing.JPanel(); jLabel15 = new javax.swing.JLabel(); jLabel16 = new javax.swing.JLabel(); jComboBox4 = new javax.swing.JComboBox(); jTextField10 = new javax.swing.JTextField(); jLabel17 = new javax.swing.JLabel(); jTextField11 = new javax.swing.JTextField(); jLabel18 = new javax.swing.JLabel(); jLabel19 = new javax.swing.JLabel(); jLabel20 = new javax.swing.JLabel(); jTextField12 = new javax.swing.JTextField(); jTextField13 = new javax.swing.JTextField(); jComboBox5 = new javax.swing.JComboBox(); jLabel51 = new javax.swing.JLabel(); jLabel52 = new javax.swing.JLabel(); jPanel4 = new javax.swing.JPanel(); jLabel21 = new javax.swing.JLabel(); jComboBox6 = new javax.swing.JComboBox(); jLabel22 = new javax.swing.JLabel(); jTextField14 = new javax.swing.JTextField(); jLabel23 = new javax.swing.JLabel(); jLabel24 = new javax.swing.JLabel(); jLabel25 = new javax.swing.JLabel(); jTextField15 = new javax.swing.JTextField(); jTextField16 = new javax.swing.JTextField(); jComboBox7 = new javax.swing.JComboBox(); jLabel40 = new javax.swing.JLabel(); jLabel49 = new javax.swing.JLabel(); jLabel50 = new javax.swing.JLabel(); jPanel5 = new javax.swing.JPanel(); jLabel26 = new javax.swing.JLabel(); jLabel27 = new javax.swing.JLabel(); jLabel28 = new javax.swing.JLabel(); jLabel29 = new javax.swing.JLabel(); jLabel30 = new javax.swing.JLabel(); jLabel31 = new javax.swing.JLabel(); jTextField17 = new javax.swing.JTextField(); jTextField18 = new javax.swing.JTextField(); jTextField19 = new javax.swing.JTextField(); jTextField20 = new javax.swing.JTextField(); jTextField21 = new javax.swing.JTextField(); jTextField22 = new javax.swing.JTextField(); jTextField23 = new javax.swing.JTextField(); jTextField24 = new javax.swing.JTextField(); jLabel32 = new javax.swing.JLabel(); jLabel33 = new javax.swing.JLabel(); jLabel34 = new javax.swing.JLabel(); jLabel35 = new javax.swing.JLabel(); jLabel36 = new javax.swing.JLabel(); jLabel37 = new javax.swing.JLabel(); jTextField25 = new javax.swing.JTextField(); jTextField26 = new javax.swing.JTextField(); jTextField27 = new javax.swing.JTextField(); jTextField28 = new javax.swing.JTextField(); jTextField29 = new javax.swing.JTextField(); jTextField30 = new javax.swing.JTextField(); jTextField31 = new javax.swing.JTextField(); jTextField32 = new javax.swing.JTextField(); jTextField33 = new javax.swing.JTextField(); jTextField34 = new javax.swing.JTextField(); jLabel38 = new javax.swing.JLabel(); jLabel39 = new javax.swing.JLabel(); jTextField35 = new javax.swing.JTextField(); jTextField36 = new javax.swing.JTextField(); jLabel57 = new javax.swing.JLabel(); jLabel58 = new javax.swing.JLabel(); jButton2 = new javax.swing.JButton(); jPanel6 = new javax.swing.JPanel(); jLabel10 = new javax.swing.JLabel(); jLabel12 = new javax.swing.JLabel(); jLabel13 = new javax.swing.JLabel(); jLabel14 = new javax.swing.JLabel(); jComboBox2 = new javax.swing.JComboBox(); jTextField7 = new javax.swing.JTextField(); jTextField8 = new javax.swing.JTextField(); jComboBox3 = new javax.swing.JComboBox(); jLabel11 = new javax.swing.JLabel(); jTextField9 = new javax.swing.JTextField(); jLabel47 = new javax.swing.JLabel(); jLabel48 = new javax.swing.JLabel(); jPanel2 = new javax.swing.JPanel(); jLabel41 = new javax.swing.JLabel(); jLabel42 = new javax.swing.JLabel(); jLabel43 = new javax.swing.JLabel(); jLabel44 = new javax.swing.JLabel(); jLabel45 = new javax.swing.JLabel(); jLabel46 = new javax.swing.JLabel(); jTextField37 = new javax.swing.JTextField(); jTextField38 = new javax.swing.JTextField(); jTextField39 = new javax.swing.JTextField(); jTextField40 = new javax.swing.JTextField(); jComboBox8 = new javax.swing.JComboBox(); jComboBox9 = new javax.swing.JComboBox(); jLabel53 = new javax.swing.JLabel(); jTextField41 = new javax.swing.JTextField(); jLabel54 = new javax.swing.JLabel(); jLabel55 = new javax.swing.JLabel(); jLabel56 = new javax.swing.JLabel(); setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE); setTitle("Update Grinding Record"); jScrollPane1.setVerticalScrollBarPolicy(javax.swing.ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS); jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.CENTER); jLabel1.setText("Update Project details"); jLabel2.setText("Project Name"); jLabel3.setText("Component"); jButton1.setText("Autofill"); jButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1ActionPerformed(evt); } }); jLabel4.setText("Material used"); jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Use own", "Provided by user" })); jLabel5.setText("Testplate"); jLabel6.setText("Radius"); jLabel7.setText("Diameter"); jLabel8.setText("Vex(r)"); jLabel9.setText("Cave(r)"); jPanel3.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Curve Generation", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, null, new java.awt.Color(0, 51, 204))); jLabel15.setText("Machine used"); jLabel16.setText("Tool used"); jComboBox4.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Outer Dia 82 Inner Dia 74", "Outer Dia 208 Inner Dia 200", "Outer Dia 102 Inner Dia 94", "Other" })); jComboBox4.setEnabled(false); jComboBox4.addItemListener(new java.awt.event.ItemListener() { public void itemStateChanged(java.awt.event.ItemEvent evt) { jComboBox4ItemStateChanged(evt); } }); jTextField10.setEnabled(false); jLabel17.setText("Other"); jTextField11.setEnabled(false); jTextField11.addFocusListener(new java.awt.event.FocusAdapter() { public void focusLost(java.awt.event.FocusEvent evt) { jTextField11FocusLost(evt); } }); jLabel18.setText("Start date(dd/mm/yyyy)"); jLabel19.setText("End date(dd/mm/yyyy)"); jLabel20.setText("Status"); jTextField12.setEnabled(false); jTextField13.setEnabled(false); jTextField13.addFocusListener(new java.awt.event.FocusAdapter() { public void focusLost(java.awt.event.FocusEvent evt) { jTextField13FocusLost(evt); } }); jComboBox5.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Pending", "Completed" })); jComboBox5.setEnabled(false); jComboBox5.addItemListener(new java.awt.event.ItemListener() { public void itemStateChanged(java.awt.event.ItemEvent evt) { jComboBox5ItemStateChanged(evt); } }); jLabel51.setText("Time taken"); javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3); jPanel3.setLayout(jPanel3Layout); jPanel3Layout .setHorizontalGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel3Layout.createSequentialGroup() .addGroup(jPanel3Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false) .addComponent(jLabel20, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jLabel18, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 145, Short.MAX_VALUE) .addComponent(jLabel15, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jLabel16, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jLabel19, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addGap(18, 18, 18) .addGroup(jPanel3Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jComboBox4, 0, 204, Short.MAX_VALUE) .addComponent(jTextField10).addComponent(jTextField12) .addComponent(jComboBox5, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jTextField13)) .addGap(18, 18, 18) .addGroup(jPanel3Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel3Layout.createSequentialGroup().addComponent(jLabel17) .addGap(18, 18, 18).addComponent(jTextField11, javax.swing.GroupLayout.PREFERRED_SIZE, 190, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(jPanel3Layout.createSequentialGroup().addComponent(jLabel51) .addGap(18, 18, 18).addComponent(jLabel52, javax.swing.GroupLayout.PREFERRED_SIZE, 81, javax.swing.GroupLayout.PREFERRED_SIZE))) .addGap(0, 0, Short.MAX_VALUE))); jPanel3Layout.setVerticalGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel3Layout.createSequentialGroup().addContainerGap().addGroup(jPanel3Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE).addComponent(jLabel15) .addComponent(jTextField10, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(18, 18, 18) .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel16) .addComponent(jComboBox4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel17).addComponent(jTextField11, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(18, 18, 18) .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel18).addComponent(jTextField12, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(18, 18, 18) .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel19) .addComponent(jTextField13, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel51).addComponent(jLabel52, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 18, Short.MAX_VALUE) .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel20).addComponent(jComboBox5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addContainerGap())); jPanel4.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Trepening Operation", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, null, new java.awt.Color(0, 51, 204))); jLabel21.setText("Tool"); jComboBox6.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "0" })); jComboBox6.setEnabled(false); jComboBox6.addItemListener(new java.awt.event.ItemListener() { public void itemStateChanged(java.awt.event.ItemEvent evt) { jComboBox6ItemStateChanged(evt); } }); jLabel22.setText("Other"); jTextField14.setEnabled(false); jTextField14.addFocusListener(new java.awt.event.FocusAdapter() { public void focusLost(java.awt.event.FocusEvent evt) { jTextField14FocusLost(evt); } }); jLabel23.setText("Start date(dd/mm/yyyy)"); jLabel24.setText("End date(dd/mm/yyyy)"); jLabel25.setText("Status"); jTextField15.setEnabled(false); jTextField16.setEnabled(false); jTextField16.addFocusListener(new java.awt.event.FocusAdapter() { public void focusLost(java.awt.event.FocusEvent evt) { jTextField16FocusLost(evt); } }); jComboBox7.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Pending", "Completed" })); jComboBox7.setEnabled(false); jComboBox7.addItemListener(new java.awt.event.ItemListener() { public void itemStateChanged(java.awt.event.ItemEvent evt) { jComboBox7ItemStateChanged(evt); } }); jLabel49.setText("Time taken"); javax.swing.GroupLayout jPanel4Layout = new javax.swing.GroupLayout(jPanel4); jPanel4.setLayout(jPanel4Layout); jPanel4Layout .setHorizontalGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel4Layout.createSequentialGroup() .addGroup(jPanel4Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false) .addComponent(jLabel25, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jLabel24, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jLabel23, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 145, Short.MAX_VALUE) .addComponent(jLabel21, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addGap(18, 18, 18) .addGroup(jPanel4Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jComboBox6, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jTextField15).addComponent(jTextField16) .addComponent(jComboBox7, 0, 145, Short.MAX_VALUE)) .addGap(18, 18, 18) .addGroup(jPanel4Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addGroup(jPanel4Layout.createSequentialGroup().addComponent(jLabel22) .addGap(18, 18, 18).addComponent(jTextField14, javax.swing.GroupLayout.PREFERRED_SIZE, 101, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(jPanel4Layout.createSequentialGroup().addComponent(jLabel49) .addGap(18, 18, 18).addComponent(jLabel50, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))) .addGap(44, 44, 44).addComponent(jLabel40, javax.swing.GroupLayout.PREFERRED_SIZE, 124, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(0, 0, Short.MAX_VALUE))); jPanel4Layout.setVerticalGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel4Layout.createSequentialGroup().addContainerGap().addGroup(jPanel4Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel40, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel21) .addComponent(jComboBox6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel22).addComponent(jTextField14, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))) .addGap(18, 18, 18) .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel23).addComponent(jTextField15, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(18, 18, 18) .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel24) .addComponent(jTextField16, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel49) .addComponent(jLabel50, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(18, 18, 18) .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel25).addComponent(jComboBox7, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(19, 19, 19))); jPanel5.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Inspection details", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, null, new java.awt.Color(0, 51, 204))); jLabel26.setHorizontalAlignment(javax.swing.SwingConstants.CENTER); jLabel26.setText("Specified"); jLabel27.setHorizontalAlignment(javax.swing.SwingConstants.CENTER); jLabel27.setText("Measured"); jLabel28.setText("Radius of Courvature"); jLabel29.setText("Central thickness"); jLabel30.setText("Surface details"); jLabel31.setText("Angle"); jTextField17.setEnabled(false); jTextField18.setEnabled(false); jTextField19.setEnabled(false); jTextField20.setEnabled(false); jTextField21.setEnabled(false); jTextField22.setEnabled(false); jTextField23.setEnabled(false); jTextField24.setEnabled(false); jLabel32.setText("A1"); jLabel33.setText("A2"); jLabel34.setText("A3"); jLabel35.setText("A4"); jLabel36.setText("A5"); jLabel37.setText("A6"); jTextField25.setEnabled(false); jTextField26.setEnabled(false); jTextField27.setEnabled(false); jTextField28.setEnabled(false); jTextField29.setEnabled(false); jTextField30.setEnabled(false); jTextField31.setEnabled(false); jTextField32.setEnabled(false); jTextField33.setEnabled(false); jTextField34.setEnabled(false); jLabel38.setText("Start date(dd/mm/yyyy)"); jLabel39.setText("End date(dd/mm/yyyy)"); jTextField35.setEnabled(false); jTextField36.setEnabled(false); jTextField36.addFocusListener(new java.awt.event.FocusAdapter() { public void focusLost(java.awt.event.FocusEvent evt) { jTextField36FocusLost(evt); } }); jLabel57.setText("Time taken "); javax.swing.GroupLayout jPanel5Layout = new javax.swing.GroupLayout(jPanel5); jPanel5.setLayout(jPanel5Layout); jPanel5Layout.setHorizontalGroup(jPanel5Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel5Layout.createSequentialGroup().addGroup(jPanel5Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel5Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addGroup(jPanel5Layout.createSequentialGroup().addGroup(jPanel5Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jLabel28, javax.swing.GroupLayout.DEFAULT_SIZE, 145, Short.MAX_VALUE) .addComponent(jLabel29, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jLabel30, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addGap(58, 58, 58)) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel5Layout.createSequentialGroup().addGroup(jPanel5Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jLabel37) .addGroup(jPanel5Layout .createParallelGroup( javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jLabel36) .addGroup(jPanel5Layout .createParallelGroup( javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jLabel35) .addGroup(jPanel5Layout.createParallelGroup( javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jLabel34) .addGroup(jPanel5Layout.createParallelGroup( javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jLabel33) .addGroup(jPanel5Layout .createSequentialGroup() .addComponent(jLabel31, javax.swing.GroupLayout.PREFERRED_SIZE, 100, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent( jLabel32))))))) .addGap(18, 18, 18))) .addGroup(jPanel5Layout.createSequentialGroup() .addGroup(jPanel5Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false) .addComponent(jLabel39, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jLabel38, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 145, Short.MAX_VALUE)) .addGap(58, 58, 58))) .addGroup( jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addGroup(jPanel5Layout .createSequentialGroup().addGroup(jPanel5Layout .createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jLabel26, javax.swing.GroupLayout.DEFAULT_SIZE, 70, Short.MAX_VALUE) .addComponent(jTextField17).addComponent( jTextField19) .addComponent(jTextField21).addComponent(jTextField23) .addComponent(jTextField25).addComponent(jTextField26) .addComponent(jTextField27).addComponent(jTextField28) .addComponent(jTextField29)) .addGap(50, 50, 50) .addGroup(jPanel5Layout .createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jLabel27, javax.swing.GroupLayout.DEFAULT_SIZE, 70, Short.MAX_VALUE) .addComponent(jTextField18).addComponent(jTextField20) .addComponent(jTextField22).addComponent(jTextField24) .addComponent(jTextField30).addComponent(jTextField31) .addComponent(jTextField32).addComponent(jTextField33) .addComponent(jTextField34))) .addComponent(jTextField35).addComponent(jTextField36)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jLabel57).addGap(18, 18, 18) .addComponent(jLabel58, javax.swing.GroupLayout.PREFERRED_SIZE, 81, javax.swing.GroupLayout.PREFERRED_SIZE) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))); jPanel5Layout.setVerticalGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel5Layout.createSequentialGroup().addContainerGap() .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel26).addComponent(jLabel27)) .addGap(18, 18, 18) .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel28) .addComponent(jTextField17, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jTextField18, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(18, 18, 18) .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel29) .addComponent(jTextField19, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jTextField20, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(18, 18, 18) .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel30) .addComponent(jTextField21, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jTextField22, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(18, 18, 18) .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel31) .addComponent(jTextField23, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jTextField24, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel32)) .addGap(18, 18, 18) .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel33) .addComponent(jTextField25, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jTextField30, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(18, 18, 18) .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel34) .addComponent(jTextField26, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jTextField31, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel35) .addComponent(jTextField27, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jTextField32, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(18, 18, 18) .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel36) .addComponent(jTextField28, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jTextField33, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel37) .addComponent(jTextField29, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jTextField34, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 33, Short.MAX_VALUE) .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel38).addComponent(jTextField35, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(18, 18, 18) .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jLabel39) .addGroup(jPanel5Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jTextField36, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel57).addComponent(jLabel58, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE))) .addGap(25, 25, 25))); jButton2.setText("Update record"); jButton2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton2ActionPerformed(evt); } }); jPanel6.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Slicing Operation", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, null, new java.awt.Color(0, 51, 204))); jLabel10.setText("Machine used"); jLabel12.setText("Start date(dd/mm/yyyy)"); jLabel13.setText("End date(dd/mm/yyyy)"); jLabel14.setText("Status"); jComboBox2 .setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Slicing machine", "TS4", "Other" })); jComboBox2.addItemListener(new java.awt.event.ItemListener() { public void itemStateChanged(java.awt.event.ItemEvent evt) { jComboBox2ItemStateChanged(evt); } }); jTextField8.addFocusListener(new java.awt.event.FocusAdapter() { public void focusLost(java.awt.event.FocusEvent evt) { jTextField8FocusLost(evt); } }); jComboBox3.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Pending", "Completed" })); jComboBox3.addItemListener(new java.awt.event.ItemListener() { public void itemStateChanged(java.awt.event.ItemEvent evt) { jComboBox3ItemStateChanged(evt); } }); jLabel11.setText("Other"); jTextField9.setEnabled(false); jTextField9.addFocusListener(new java.awt.event.FocusAdapter() { public void focusLost(java.awt.event.FocusEvent evt) { jTextField9FocusLost(evt); } }); jLabel47.setText("Time taken"); javax.swing.GroupLayout jPanel6Layout = new javax.swing.GroupLayout(jPanel6); jPanel6.setLayout(jPanel6Layout); jPanel6Layout .setHorizontalGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel6Layout.createSequentialGroup().addGroup(jPanel6Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jLabel10, javax.swing.GroupLayout.DEFAULT_SIZE, 145, Short.MAX_VALUE) .addComponent(jLabel12, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jLabel13, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jLabel14, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addGap(18, 18, 18) .addGroup(jPanel6Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jComboBox2, 0, 145, Short.MAX_VALUE).addComponent(jTextField7) .addComponent(jTextField8).addComponent(jComboBox3, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addGap(18, 18, 18) .addGroup(jPanel6Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addGroup(jPanel6Layout.createSequentialGroup().addComponent(jLabel11) .addGap(41, 41, 41).addComponent(jTextField9, javax.swing.GroupLayout.PREFERRED_SIZE, 145, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(jPanel6Layout.createSequentialGroup().addComponent(jLabel47) .addGap(18, 18, 18).addComponent(jLabel48, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))) .addGap(0, 0, Short.MAX_VALUE))); jPanel6Layout.setVerticalGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel6Layout.createSequentialGroup().addContainerGap().addGroup(jPanel6Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE).addComponent(jLabel10) .addComponent(jComboBox2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel11).addComponent(jTextField9, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(18, 18, 18) .addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jTextField7, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel12)) .addGap(18, 18, 18) .addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel13) .addComponent(jTextField8, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel47) .addComponent(jLabel48, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(18, 18, 18) .addGroup(jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jComboBox3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel14)) .addContainerGap())); jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Grinding and Smoothing ", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, null, new java.awt.Color(0, 51, 204))); jPanel2.setPreferredSize(new java.awt.Dimension(633, 217)); jLabel41.setText("Machine"); jLabel42.setText("Tool"); jLabel43.setText("Processing method"); jLabel44.setText("Status"); jLabel45.setText("Start date(dd/mm/yyyy)"); jLabel46.setText("Completion date(dd/mm/yyyy)"); jTextField37.setEnabled(false); jTextField38.setEnabled(false); jTextField39.setEnabled(false); jTextField40.setEnabled(false); jTextField40.addFocusListener(new java.awt.event.FocusAdapter() { public void focusLost(java.awt.event.FocusEvent evt) { jTextField40FocusLost(evt); } }); jComboBox8.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "0" })); jComboBox8.setEnabled(false); jComboBox8.addItemListener(new java.awt.event.ItemListener() { public void itemStateChanged(java.awt.event.ItemEvent evt) { jComboBox8ItemStateChanged(evt); } }); jComboBox9.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Pending", "Completed" })); jComboBox9.setEnabled(false); jComboBox9.addItemListener(new java.awt.event.ItemListener() { public void itemStateChanged(java.awt.event.ItemEvent evt) { jComboBox9ItemStateChanged(evt); } }); jLabel53.setText("Other"); jTextField41.setEnabled(false); jTextField41.addFocusListener(new java.awt.event.FocusAdapter() { public void focusLost(java.awt.event.FocusEvent evt) { jTextField41FocusLost(evt); } }); jLabel55.setText("Time taken"); javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2); jPanel2.setLayout(jPanel2Layout); jPanel2Layout .setHorizontalGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel2Layout.createSequentialGroup() .addGroup(jPanel2Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jLabel41, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jLabel42, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jLabel43, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jLabel44, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jLabel45, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jLabel46, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addGap(18, 18, 18) .addGroup(jPanel2Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jTextField37).addComponent(jTextField38) .addComponent(jTextField39).addComponent(jTextField40) .addComponent(jComboBox8, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jComboBox9, 0, 204, Short.MAX_VALUE)) .addGap(18, 18, 18) .addGroup(jPanel2Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addGroup(jPanel2Layout.createSequentialGroup().addComponent(jLabel53) .addGap(18, 18, 18).addComponent(jTextField41, javax.swing.GroupLayout.PREFERRED_SIZE, 125, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(jPanel2Layout.createSequentialGroup().addComponent(jLabel55) .addGap(18, 18, 18).addComponent(jLabel56, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jLabel54, javax.swing.GroupLayout.PREFERRED_SIZE, 134, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(0, 864, Short.MAX_VALUE))); jPanel2Layout.setVerticalGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel2Layout.createSequentialGroup().addContainerGap().addGroup(jPanel2Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE).addComponent(jLabel41) .addComponent(jTextField37, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(18, 18, 18) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel42) .addComponent(jComboBox8, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel53) .addComponent(jTextField41, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel54, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(18, 18, 18) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel43).addComponent(jTextField38, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(18, 18, 18) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel44).addComponent(jComboBox9, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(18, 18, 18) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel45).addComponent(jTextField39, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(18, 18, 18) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel46) .addComponent(jTextField40, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel55).addComponent(jLabel56, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE)) .addContainerGap())); javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1); jPanel1.setLayout(jPanel1Layout); jPanel1Layout.setHorizontalGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jPanel6, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jPanel4, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jPanel3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jPanel5, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, 1577, Short.MAX_VALUE) .addGroup(jPanel1Layout.createSequentialGroup().addGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup( jPanel1Layout.createSequentialGroup().addGap(293, 293, 293).addComponent(jButton1)) .addGroup(jPanel1Layout.createSequentialGroup().addContainerGap() .addGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false) .addComponent(jLabel5, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jLabel4, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent( jLabel2, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 145, Short.MAX_VALUE)) .addGap(18, 18, 18) .addGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup() .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 150, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18) .addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 140, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18).addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, 150, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(jPanel1Layout.createSequentialGroup().addGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addGroup(jPanel1Layout.createSequentialGroup() .addComponent(jLabel6).addGap(18, 18, 18) .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, 40, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jLabel7)) .addComponent(jComboBox1, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addGap(18, 18, 18) .addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, 40, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jLabel8).addGap(18, 18, 18) .addComponent(jTextField5, javax.swing.GroupLayout.PREFERRED_SIZE, 40, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18).addComponent(jLabel9) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jTextField6, javax.swing.GroupLayout.PREFERRED_SIZE, 40, javax.swing.GroupLayout.PREFERRED_SIZE)))) .addGroup(jPanel1Layout.createSequentialGroup().addGap(175, 175, 175).addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 131, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(jPanel1Layout.createSequentialGroup().addGap(252, 252, 252).addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 112, javax.swing.GroupLayout.PREFERRED_SIZE))) .addContainerGap(928, Short.MAX_VALUE))); jPanel1Layout.setVerticalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup().addContainerGap().addComponent(jLabel1) .addGap(18, 18, 18) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel2).addComponent(jLabel3) .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(18, 18, 18).addComponent(jButton1).addGap(18, 18, 18).addGroup( jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel4) .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(18, 18, 18) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel5).addComponent(jLabel6) .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel7) .addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel8) .addComponent(jTextField5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel9).addComponent(jTextField6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(18, 18, 18) .addComponent(jPanel6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jPanel4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18) .addComponent(jPanel3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, 291, Short.MAX_VALUE) .addGap(18, 18, 18) .addComponent(jPanel5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED).addComponent(jButton2) .addGap(29, 29, 29))); jScrollPane1.setViewportView(jPanel1); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 733, Short.MAX_VALUE)); layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 1699, Short.MAX_VALUE)); pack(); }// </editor-fold>//GEN-END:initComponents private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed project = jTextField1.getText(); component = jTextField2.getText(); String sql = "select * from grinding where project_name='" + project + "' and component='" + component + "'"; try { Class.forName("com.mysql.jdbc.Driver"); String uName = "root"; String uPass = ""; Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/drdo", uName, uPass); System.out.println(con.isClosed()); Statement smt = con.createStatement(); ResultSet rs = smt.executeQuery(sql); rs.next(); //slicing Panel autofill jComboBox1.setSelectedItem(rs.getString(5)); jTextField3.setText(rs.getString(6)); jTextField4.setText(rs.getString(7)); jTextField5.setText(rs.getString(8)); jTextField6.setText(rs.getString(9)); slicing_machine = rs.getString(10); if ("Slicing machine".equals(rs.getString(10)) || "TS4".equals(rs.getString(10))) { jComboBox2.setSelectedItem(slicing_machine); jTextField9.setEnabled(false); } else { jComboBox2.setSelectedItem("Other"); jTextField9.setEnabled(true); jTextField9.setText(slicing_machine); } jTextField7.setText(rs.getString(12)); ssdate = rs.getString(12); jTextField8.setText(rs.getString(13)); sedate = rs.getString(13); jLabel48.setText(rs.getString(14)); stime = rs.getString(14); jComboBox3.setSelectedItem(rs.getString(11)); // trepening panel autofill code trepening_tool = rs.getString(21); if (trepening_tool != null || !"".equals(trepening_tool) || !"0".equals(trepening_tool)) { jLabel40.setText(trepening_tool); jComboBox6.setEnabled(false); jTextField14.setEnabled(false); } else { jComboBox6.setEnabled(true); // jTextField14.setEnabled(true); } jTextField15.setText(rs.getString(23)); tsdate = rs.getString(23); jTextField16.setText(rs.getString(24)); tedate = rs.getString(24); jLabel50.setText(rs.getString(25)); ttime = rs.getString(25); jComboBox7.setSelectedItem(rs.getString(22)); //curve generation panel update jTextField10.setText(rs.getString(15)); cg_tool = rs.getString(16); if ("Outer Dia 102 Inner Dia 94".equals(rs.getString(16)) || "Outer Dia 82 Inner Dia 74".equals(rs.getString(16)) || "Outer Dia 208 Inner Dia 200".equals(rs.getString(16))) { jComboBox4.setSelectedItem(cg_tool); } else { jComboBox4.setSelectedItem("Other"); jTextField11.setEnabled(true); jTextField11.setText(cg_tool); } jTextField12.setText(rs.getString(18)); cgsdate = rs.getString(18); jTextField13.setText(rs.getString(19)); cgedate = rs.getString(19); jLabel52.setText(rs.getString(20)); cgtime = rs.getString(20); jComboBox5.setSelectedItem(rs.getString(17)); //Grinding and smoothing panel auto fill jTextField37.setText(rs.getString(48)); grinding_tool = rs.getString(49); if (grinding_tool != null || !"".equals(grinding_tool) || !"0".equals(grinding_tool)) { jLabel54.setText(grinding_tool); jComboBox6.setEnabled(false); jTextField41.setEnabled(false); } else { jComboBox8.setEnabled(true); //jTextField41.setEnabled(true); } jTextField38.setText(rs.getString(50)); jComboBox9.setSelectedItem(rs.getString(51)); jTextField39.setText(rs.getString(52)); gsdate = rs.getString(52); jTextField40.setText(rs.getString(53)); gedate = rs.getString(53); jLabel56.setText(rs.getString(54)); gtime = rs.getString(54); // Inspection detail panel update jTextField17.setText(rs.getString(26)); jTextField18.setText(rs.getString(27)); jTextField19.setText(rs.getString(28)); jTextField20.setText(rs.getString(29)); jTextField21.setText(rs.getString(30)); jTextField22.setText(rs.getString(31)); jTextField23.setText(rs.getString(32)); jTextField24.setText(rs.getString(33)); jTextField25.setText(rs.getString(34)); jTextField30.setText(rs.getString(35)); jTextField26.setText(rs.getString(36)); jTextField31.setText(rs.getString(37)); jTextField27.setText(rs.getString(38)); jTextField32.setText(rs.getString(39)); jTextField28.setText(rs.getString(40)); jTextField33.setText(rs.getString(41)); jTextField29.setText(rs.getString(42)); jTextField34.setText(rs.getString(43)); jTextField35.setText(rs.getString(44)); is1date = rs.getString(44); jTextField36.setText(rs.getString(45)); iedate = rs.getString(45); jLabel58.setText(rs.getString(46)); itime = rs.getString(46); total_time = rs.getInt(47); JOptionPane.showMessageDialog(this.getParent(), "Record fetched successfully,you may perform required operation now"); con.close(); } catch (Exception ex) { JOptionPane.showMessageDialog(this.getParent(), "Error fetching record,please enter a valid record"); ex.printStackTrace(); } }//GEN-LAST:event_jButton1ActionPerformed private void jComboBox3ItemStateChanged(java.awt.event.ItemEvent evt) {//GEN-FIRST:event_jComboBox3ItemStateChanged if ("Completed".equals(jComboBox3.getSelectedItem().toString())) { jTextField15.setEnabled(true); jTextField16.setEnabled(true); jComboBox6.setEnabled(true); jComboBox7.setEnabled(true); } else { jTextField16.setEnabled(false); jTextField15.setEnabled(false); jComboBox6.setEnabled(false); jComboBox7.setEnabled(false); } }//GEN-LAST:event_jComboBox3ItemStateChanged private void jComboBox5ItemStateChanged(java.awt.event.ItemEvent evt) {//GEN-FIRST:event_jComboBox5ItemStateChanged if ("Completed".equals(jComboBox5.getSelectedItem().toString())) { jTextField37.setEnabled(true); jTextField38.setEnabled(true); jTextField39.setEnabled(true); jTextField40.setEnabled(true); jComboBox8.setEnabled(true); jComboBox9.setEnabled(true); } else { jTextField37.setEnabled(false); jTextField38.setEnabled(false); jTextField39.setEnabled(false); jTextField40.setEnabled(false); jComboBox8.setEnabled(false); jComboBox9.setEnabled(false); } }//GEN-LAST:event_jComboBox5ItemStateChanged private void jComboBox7ItemStateChanged(java.awt.event.ItemEvent evt) {//GEN-FIRST:event_jComboBox7ItemStateChanged if ("Completed".equals(jComboBox7.getSelectedItem().toString())) { jTextField10.setEnabled(true); jTextField12.setEnabled(true); jTextField13.setEnabled(true); jComboBox5.setEnabled(true); jComboBox4.setEnabled(true); } else { jTextField10.setEnabled(false); jTextField12.setEnabled(false); jTextField13.setEnabled(false); jComboBox4.setEnabled(false); jComboBox5.setEnabled(false); } }//GEN-LAST:event_jComboBox7ItemStateChanged private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed total = s + t + cg + g + i + total_time; String update = "update grinding set material=? ,testplate_radius= ? ,testplate_diameter=? ,testplate_vax_radius=? ,testplate_cave_radius=? ,slicing_machine_used=? ,slicing_status=? ,Slicing_start_date=? ,Slicing_end_date=?, Slicing_time_taken=?, trepeing_tool=?" + ",trepening_status=?, T_s_date=? , T_e_date=?, T_t_taken=?, curve_generation_machine=?, curve_generation_tool=? ,curve_generation_status=?, C_g_s_date=?, C_g_e_date=?, C_g_t_taken=?" + ",gs_machine=?,gs_tool=?, gs_processing=?, gs_status=?, gs_start=? , gs_end=?, gs_time=?, I_roc_s=?, I_roc_m=?, I_central_thickness_s=? " + ",I_central_thickness_m=?, I_Surface_Details_s=?, I_Surface_Details_m=? ,IA1S=?, IA1M=? ,IA2S=?, IA2M=?, IA3S=?, IA3M=?" + ",IA4S=?, IA4M=?, IA5S=?, IA5M=?, IA6S=?, IA6M=?, I_start_date=?, I_end_date=?, I_t_taken= ?, total_grinding_time=? where project_name='" + project + "' and component='" + component + "'"; try { Class.forName("com.mysql.jdbc.Driver"); String uName = "root"; String uPass = ""; Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/drdo", uName, uPass); PreparedStatement ps = con.prepareStatement(update); ps.setString(1, jComboBox1.getSelectedItem().toString()); ps.setString(2, jTextField3.getText()); ps.setString(3, jTextField4.getText()); ps.setString(4, jTextField5.getText()); ps.setString(5, jTextField6.getText()); ps.setString(6, slicing_machine); ps.setString(7, jComboBox3.getSelectedItem().toString()); ps.setString(8, ssdate); ps.setString(9, sedate); ps.setString(10, stime); ps.setString(11, trepening_tool); ps.setString(12, jComboBox7.getSelectedItem().toString()); ps.setString(13, tsdate); ps.setString(14, tedate); ps.setString(15, ttime); ps.setString(16, jTextField10.getText()); ps.setString(17, cg_tool); ps.setString(18, jComboBox5.getSelectedItem().toString()); ps.setString(19, cgsdate); ps.setString(20, cgedate); ps.setString(21, cgtime); ps.setString(22, jTextField37.getText()); ps.setString(23, grinding_tool); ps.setString(24, jTextField38.getText()); ps.setString(25, jComboBox9.getSelectedItem().toString()); ps.setString(26, gsdate); ps.setString(27, gedate); ps.setString(28, gtime); ps.setString(29, jTextField17.getText()); ps.setString(30, jTextField18.getText()); ps.setString(31, jTextField19.getText()); ps.setString(32, jTextField20.getText()); ps.setString(33, jTextField21.getText()); ps.setString(34, jTextField22.getText()); ps.setString(35, jTextField23.getText()); ps.setString(36, jTextField24.getText()); ps.setString(37, jTextField25.getText()); ps.setString(38, jTextField30.getText()); ps.setString(39, jTextField26.getText()); ps.setString(40, jTextField31.getText()); ps.setString(41, jTextField27.getText()); ps.setString(42, jTextField32.getText()); ps.setString(43, jTextField28.getText()); ps.setString(44, jTextField33.getText()); ps.setString(45, jTextField29.getText()); ps.setString(46, jTextField34.getText()); ps.setString(47, is1date); ps.setString(48, iedate); ps.setString(49, itime); ps.setInt(50, total); ps.executeUpdate(); System.out.println(con.isClosed()); JOptionPane.showMessageDialog(this.getParent(), "Record updated successfully,you may exit now"); con.close(); } catch (SQLException ex) { JOptionPane.showMessageDialog(this.getParent(), "Error updqting record,please enter 0 in the blank spaces"); ex.printStackTrace(); } catch (Throwable e) { e.printStackTrace(); } }//GEN-LAST:event_jButton2ActionPerformed private void jComboBox9ItemStateChanged(java.awt.event.ItemEvent evt) {//GEN-FIRST:event_jComboBox9ItemStateChanged if ("Completed".equals(jComboBox9.getSelectedItem().toString())) { jTextField17.setEnabled(true); jTextField18.setEnabled(true); jTextField19.setEnabled(true); jTextField20.setEnabled(true); jTextField21.setEnabled(true); jTextField22.setEnabled(true); jTextField23.setEnabled(true); jTextField24.setEnabled(true); jTextField25.setEnabled(true); jTextField26.setEnabled(true); jTextField27.setEnabled(true); jTextField28.setEnabled(true); jTextField29.setEnabled(true); jTextField30.setEnabled(true); jTextField31.setEnabled(true); jTextField32.setEnabled(true); jTextField33.setEnabled(true); jTextField34.setEnabled(true); jTextField35.setEnabled(true); jTextField36.setEnabled(true); } else { jTextField17.setEnabled(false); jTextField18.setEnabled(false); jTextField18.setEnabled(false); jTextField20.setEnabled(false); jTextField21.setEnabled(false); jTextField22.setEnabled(false); jTextField23.setEnabled(false); jTextField24.setEnabled(false); jTextField25.setEnabled(false); jTextField26.setEnabled(false); jTextField27.setEnabled(false); jTextField28.setEnabled(false); jTextField29.setEnabled(false); jTextField30.setEnabled(false); jTextField31.setEnabled(false); jTextField32.setEnabled(false); jTextField33.setEnabled(false); jTextField34.setEnabled(false); jTextField35.setEnabled(false); jTextField36.setEnabled(false); } }//GEN-LAST:event_jComboBox9ItemStateChanged private void jComboBox2ItemStateChanged(java.awt.event.ItemEvent evt) {//GEN-FIRST:event_jComboBox2ItemStateChanged if ("Other".equals(jComboBox2.getSelectedItem().toString())) { jTextField9.setEnabled(true); } else { slicing_machine = jComboBox2.getSelectedItem().toString(); } }//GEN-LAST:event_jComboBox2ItemStateChanged private void jTextField9FocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_jTextField9FocusLost slicing_machine = jTextField9.getText(); }//GEN-LAST:event_jTextField9FocusLost private void jComboBox6ItemStateChanged(java.awt.event.ItemEvent evt) {//GEN-FIRST:event_jComboBox6ItemStateChanged if (jComboBox6.getSelectedItem().toString() == "other") { jTextField14.setEnabled(true); } else { trepening_tool = jComboBox6.getSelectedItem().toString(); } }//GEN-LAST:event_jComboBox6ItemStateChanged private void jTextField14FocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_jTextField14FocusLost trepening_tool = jTextField4.getText(); }//GEN-LAST:event_jTextField14FocusLost private void jComboBox4ItemStateChanged(java.awt.event.ItemEvent evt) {//GEN-FIRST:event_jComboBox4ItemStateChanged if (jComboBox4.getSelectedItem().toString() == "Other") { jTextField11.setEnabled(true); } else { cg_tool = jComboBox4.getSelectedItem().toString(); } }//GEN-LAST:event_jComboBox4ItemStateChanged private void jTextField11FocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_jTextField11FocusLost cg_tool = jTextField11.getText(); }//GEN-LAST:event_jTextField11FocusLost private void jComboBox8ItemStateChanged(java.awt.event.ItemEvent evt) {//GEN-FIRST:event_jComboBox8ItemStateChanged if (jComboBox8.getSelectedItem().toString() == "Other") { jTextField41.setEnabled(true); } else { grinding_tool = jComboBox8.getSelectedItem().toString(); } }//GEN-LAST:event_jComboBox8ItemStateChanged private void jTextField41FocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_jTextField41FocusLost // TODO add your handling code here: grinding_tool = jTextField41.getText(); }//GEN-LAST:event_jTextField41FocusLost private void jTextField8FocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_jTextField8FocusLost Date d1 = null; Date d2 = null; ssdate = jTextField7.getText(); sedate = jTextField8.getText(); //d1=; SimpleDateFormat format = new SimpleDateFormat("dd/MM/yyyy"); try { d1 = format.parse(ssdate); d2 = format.parse(sedate); DateTime dt1 = new DateTime(d1); DateTime dt2 = new DateTime(d2); jLabel48.setText(Days.daysBetween(dt1, dt2).getDays() + " days"); s = Days.daysBetween(dt1, dt2).getDays(); stime = s + " days"; } catch (Exception e) { JOptionPane.showMessageDialog(null, "Please enter a valid date"); } }//GEN-LAST:event_jTextField8FocusLost private void jTextField16FocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_jTextField16FocusLost Date d1 = null; Date d2 = null; tsdate = jTextField15.getText(); tedate = jTextField16.getText(); SimpleDateFormat format = new SimpleDateFormat("dd/MM/yyyy"); try { d1 = format.parse(tsdate); d2 = format.parse(tedate); DateTime dt1 = new DateTime(d1); DateTime dt2 = new DateTime(d2); jLabel50.setText(Days.daysBetween(dt1, dt2).getDays() + " days"); t = Days.daysBetween(dt1, dt2).getDays(); ttime = t + " days"; } catch (Exception e) { JOptionPane.showMessageDialog(null, "Please enter a valid date"); } }//GEN-LAST:event_jTextField16FocusLost private void jTextField13FocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_jTextField13FocusLost Date d1 = null; Date d2 = null; cgsdate = jTextField12.getText(); cgedate = jTextField13.getText(); SimpleDateFormat format = new SimpleDateFormat("dd/MM/yyyy"); try { d1 = format.parse(cgsdate); d2 = format.parse(cgedate); DateTime dt1 = new DateTime(d1); DateTime dt2 = new DateTime(d2); jLabel52.setText(Days.daysBetween(dt1, dt2).getDays() + " days"); cg = Days.daysBetween(dt1, dt2).getDays(); cgtime = cg + " days"; } catch (Exception e) { JOptionPane.showMessageDialog(null, "Please enter a valid date"); } }//GEN-LAST:event_jTextField13FocusLost private void jTextField40FocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_jTextField40FocusLost Date d1 = null; Date d2 = null; gsdate = jTextField39.getText(); gedate = jTextField40.getText(); SimpleDateFormat format = new SimpleDateFormat("dd/MM/yyyy"); try { d1 = format.parse(gsdate); d2 = format.parse(gedate); DateTime dt1 = new DateTime(d1); DateTime dt2 = new DateTime(d2); jLabel56.setText(Days.daysBetween(dt1, dt2).getDays() + " days"); g = Days.daysBetween(dt1, dt2).getDays(); gtime = t + " days"; } catch (Exception e) { JOptionPane.showMessageDialog(null, "Please enter a valid date"); } }//GEN-LAST:event_jTextField40FocusLost private void jTextField36FocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_jTextField36FocusLost Date d1 = null; Date d2 = null; is1date = jTextField35.getText(); sedate = jTextField36.getText(); SimpleDateFormat format = new SimpleDateFormat("dd/MM/yyyy"); try { d1 = format.parse(is1date); d2 = format.parse(iedate); DateTime dt1 = new DateTime(d1); DateTime dt2 = new DateTime(d2); jLabel58.setText(Days.daysBetween(dt1, dt2).getDays() + " days"); i = Days.daysBetween(dt1, dt2).getDays(); itime = t + " days"; } catch (Exception e) { JOptionPane.showMessageDialog(null, "Please enter a valid date"); } }//GEN-LAST:event_jTextField36FocusLost private void fill_trepening() { try { Class.forName("com.mysql.jdbc.Driver"); String uName = "root"; String uPass = ""; Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/drdo", uName, uPass); System.out.println(con.isClosed()); Statement smt = con.createStatement(); String sql = "select * from trepening_tool"; ResultSet rs = smt.executeQuery(sql); while (rs.next()) { String tool = rs.getString("Tool"); jComboBox6.addItem(tool); } smt.close(); con.close(); } catch (Exception ex) { JOptionPane.showMessageDialog(this.getParent(), "Error adding record,please enter 0 in the blank spaces"); ex.printStackTrace(); } } private void fill_grinding() { try { Class.forName("com.mysql.jdbc.Driver"); String uName = "root"; String uPass = ""; Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/drdo", uName, uPass); System.out.println(con.isClosed()); Statement smt = con.createStatement(); String sql = "select * from curve_generation_tool"; ResultSet rs = smt.executeQuery(sql); while (rs.next()) { String tool = rs.getString("tool"); jComboBox8.addItem(tool); } smt.close(); con.close(); } catch (Exception ex) { JOptionPane.showMessageDialog(this.getParent(), "Error adding record,please enter 0 in the blank spaces"); ex.printStackTrace(); } } /** * @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(GrindingUpdate.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(GrindingUpdate.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(GrindingUpdate.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(GrindingUpdate.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 GrindingUpdate().setVisible(true); } }); } // Variables declaration - do not modify//GEN-BEGIN:variables private javax.swing.JButton jButton1; private javax.swing.JButton jButton2; private javax.swing.JComboBox jComboBox1; private javax.swing.JComboBox jComboBox2; private javax.swing.JComboBox jComboBox3; private javax.swing.JComboBox jComboBox4; private javax.swing.JComboBox jComboBox5; private javax.swing.JComboBox jComboBox6; private javax.swing.JComboBox jComboBox7; private javax.swing.JComboBox jComboBox8; private javax.swing.JComboBox jComboBox9; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel10; private javax.swing.JLabel jLabel11; private javax.swing.JLabel jLabel12; private javax.swing.JLabel jLabel13; private javax.swing.JLabel jLabel14; private javax.swing.JLabel jLabel15; private javax.swing.JLabel jLabel16; private javax.swing.JLabel jLabel17; private javax.swing.JLabel jLabel18; private javax.swing.JLabel jLabel19; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel20; private javax.swing.JLabel jLabel21; private javax.swing.JLabel jLabel22; private javax.swing.JLabel jLabel23; private javax.swing.JLabel jLabel24; private javax.swing.JLabel jLabel25; private javax.swing.JLabel jLabel26; private javax.swing.JLabel jLabel27; private javax.swing.JLabel jLabel28; private javax.swing.JLabel jLabel29; private javax.swing.JLabel jLabel3; private javax.swing.JLabel jLabel30; private javax.swing.JLabel jLabel31; private javax.swing.JLabel jLabel32; private javax.swing.JLabel jLabel33; private javax.swing.JLabel jLabel34; private javax.swing.JLabel jLabel35; private javax.swing.JLabel jLabel36; private javax.swing.JLabel jLabel37; private javax.swing.JLabel jLabel38; private javax.swing.JLabel jLabel39; private javax.swing.JLabel jLabel4; private javax.swing.JLabel jLabel40; private javax.swing.JLabel jLabel41; private javax.swing.JLabel jLabel42; private javax.swing.JLabel jLabel43; private javax.swing.JLabel jLabel44; private javax.swing.JLabel jLabel45; private javax.swing.JLabel jLabel46; private javax.swing.JLabel jLabel47; private javax.swing.JLabel jLabel48; private javax.swing.JLabel jLabel49; private javax.swing.JLabel jLabel5; private javax.swing.JLabel jLabel50; private javax.swing.JLabel jLabel51; private javax.swing.JLabel jLabel52; private javax.swing.JLabel jLabel53; private javax.swing.JLabel jLabel54; private javax.swing.JLabel jLabel55; private javax.swing.JLabel jLabel56; private javax.swing.JLabel jLabel57; private javax.swing.JLabel jLabel58; private javax.swing.JLabel jLabel6; private javax.swing.JLabel jLabel7; private javax.swing.JLabel jLabel8; private javax.swing.JLabel jLabel9; private javax.swing.JPanel jPanel1; private javax.swing.JPanel jPanel2; private javax.swing.JPanel jPanel3; private javax.swing.JPanel jPanel4; private javax.swing.JPanel jPanel5; private javax.swing.JPanel jPanel6; private javax.swing.JScrollPane jScrollPane1; private javax.swing.JTextField jTextField1; private javax.swing.JTextField jTextField10; private javax.swing.JTextField jTextField11; private javax.swing.JTextField jTextField12; private javax.swing.JTextField jTextField13; private javax.swing.JTextField jTextField14; private javax.swing.JTextField jTextField15; private javax.swing.JTextField jTextField16; private javax.swing.JTextField jTextField17; private javax.swing.JTextField jTextField18; private javax.swing.JTextField jTextField19; private javax.swing.JTextField jTextField2; private javax.swing.JTextField jTextField20; private javax.swing.JTextField jTextField21; private javax.swing.JTextField jTextField22; private javax.swing.JTextField jTextField23; private javax.swing.JTextField jTextField24; private javax.swing.JTextField jTextField25; private javax.swing.JTextField jTextField26; private javax.swing.JTextField jTextField27; private javax.swing.JTextField jTextField28; private javax.swing.JTextField jTextField29; private javax.swing.JTextField jTextField3; private javax.swing.JTextField jTextField30; private javax.swing.JTextField jTextField31; private javax.swing.JTextField jTextField32; private javax.swing.JTextField jTextField33; private javax.swing.JTextField jTextField34; private javax.swing.JTextField jTextField35; private javax.swing.JTextField jTextField36; private javax.swing.JTextField jTextField37; private javax.swing.JTextField jTextField38; private javax.swing.JTextField jTextField39; private javax.swing.JTextField jTextField4; private javax.swing.JTextField jTextField40; private javax.swing.JTextField jTextField41; private javax.swing.JTextField jTextField5; private javax.swing.JTextField jTextField6; private javax.swing.JTextField jTextField7; private javax.swing.JTextField jTextField8; private javax.swing.JTextField jTextField9; // End of variables declaration//GEN-END:variables }