Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- * To change this template, choose Tools | Templates
- * and open the template in the editor.
- */
- /*
- * MyApplet.java
- *
- * Created on May 28, 2010, 10:23:32 PM
- */
- package org.me.hello;
- import java.awt.Color;
- import java.sql.*;
- import java.lang.*;
- public class MyApplet extends javax.swing.JApplet {
- // static final String JDBC_DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
- static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
- static final String DATABASE_URL = "jdbc:mysql://localhost:3306/beettest";
- public boolean newOrEdit = false;
- /** Initializes the applet MyApplet */
- public void init() {
- try {
- java.awt.EventQueue.invokeAndWait(new Runnable() {
- public void run() {
- initComponents();
- }
- });
- } catch (Exception ex) {
- ex.printStackTrace();
- }
- }
- /** This method is called from within the init() method 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">
- private void initComponents() {
- buttonGroup1 = new javax.swing.ButtonGroup();
- buttonGroup2 = new javax.swing.ButtonGroup();
- jDialog1 = new javax.swing.JDialog();
- jLabel1 = new javax.swing.JLabel();
- jTextField1 = new javax.swing.JTextField();
- jLabel2 = new javax.swing.JLabel();
- jRadioButton1 = new javax.swing.JRadioButton();
- jRadioButton2 = new javax.swing.JRadioButton();
- jLabel3 = new javax.swing.JLabel();
- jTextField2 = new javax.swing.JTextField();
- jLabel4 = new javax.swing.JLabel();
- jTextField3 = new javax.swing.JTextField();
- jLabel5 = new javax.swing.JLabel();
- jTextField4 = new javax.swing.JTextField();
- jLabel6 = new javax.swing.JLabel();
- jTextField5 = new javax.swing.JTextField();
- jLabel7 = new javax.swing.JLabel();
- jTextField6 = new javax.swing.JTextField();
- jLabel8 = new javax.swing.JLabel();
- jTextField7 = new javax.swing.JTextField();
- jLabel9 = new javax.swing.JLabel();
- jTextField8 = new javax.swing.JTextField();
- jLabel10 = new javax.swing.JLabel();
- jCheckBox1 = new javax.swing.JCheckBox();
- jCheckBox2 = new javax.swing.JCheckBox();
- jCheckBox3 = new javax.swing.JCheckBox();
- jTabbedPane1 = new javax.swing.JTabbedPane();
- jScrollPane1 = new javax.swing.JScrollPane();
- jTable1 = new javax.swing.JTable();
- jScrollPane2 = new javax.swing.JScrollPane();
- jTable2 = new javax.swing.JTable();
- jLabel11 = new javax.swing.JLabel();
- jScrollPane3 = new javax.swing.JScrollPane();
- jTextArea1 = new javax.swing.JTextArea();
- jCheckBox4 = new javax.swing.JCheckBox();
- jCheckBox5 = new javax.swing.JCheckBox();
- jCheckBox6 = new javax.swing.JCheckBox();
- jLabel12 = new javax.swing.JLabel();
- jSeparator1 = new javax.swing.JSeparator();
- jSeparator2 = new javax.swing.JSeparator();
- jRadioButton3 = new javax.swing.JRadioButton();
- jRadioButton4 = new javax.swing.JRadioButton();
- jRadioButton5 = new javax.swing.JRadioButton();
- jRadioButton6 = new javax.swing.JRadioButton();
- jTextField9 = new javax.swing.JTextField();
- jSeparator3 = new javax.swing.JSeparator();
- jSeparator4 = new javax.swing.JSeparator();
- jSeparator5 = new javax.swing.JSeparator();
- jButton1 = new javax.swing.JButton();
- jButton2 = new javax.swing.JButton();
- jButton3 = new javax.swing.JButton();
- jButton4 = new javax.swing.JButton();
- jButton5 = new javax.swing.JButton();
- jTextField10 = new javax.swing.JTextField();
- jTextField11 = new javax.swing.JTextField();
- jTextField12 = new javax.swing.JTextField();
- jTextField13 = new javax.swing.JTextField();
- jTextField14 = new javax.swing.JTextField();
- jTextField15 = new javax.swing.JTextField();
- jButton7 = new javax.swing.JButton();
- jButton9 = new javax.swing.JButton();
- jTextField16 = new javax.swing.JTextField();
- jButton6 = new javax.swing.JButton();
- jLabel13 = new javax.swing.JLabel();
- buttonGroup1.add(jRadioButton1);
- buttonGroup1.add(jRadioButton2);
- buttonGroup2.add(jRadioButton3);
- buttonGroup2.add(jRadioButton4);
- buttonGroup2.add(jRadioButton5);
- buttonGroup2.add(jRadioButton6);
- javax.swing.GroupLayout jDialog1Layout = new javax.swing.GroupLayout(jDialog1.getContentPane());
- jDialog1.getContentPane().setLayout(jDialog1Layout);
- jDialog1Layout.setHorizontalGroup(
- jDialog1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGap(0, 400, Short.MAX_VALUE)
- );
- jDialog1Layout.setVerticalGroup(
- jDialog1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGap(0, 300, Short.MAX_VALUE)
- );
- setBackground(new java.awt.Color(102, 153, 255));
- setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
- setStub(null);
- jLabel1.setFont(new java.awt.Font("Tahoma", 1, 18));
- jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
- jLabel1.setText("Engineering Lot Evaluation Form");
- jTextField1.setEditable(false);
- jTextField1.setEnabled(false);
- jTextField1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jTextField1ActionPerformed(evt);
- }
- });
- jLabel2.setText("SBR NO. :");
- jRadioButton1.setText("In-House Evaluation");
- jRadioButton1.setContentAreaFilled(false);
- jRadioButton1.setEnabled(false);
- jRadioButton1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jRadioButton1ActionPerformed(evt);
- }
- });
- jRadioButton2.setText("Customer");
- jRadioButton2.setContentAreaFilled(false);
- jRadioButton2.setEnabled(false);
- jRadioButton2.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jRadioButton2ActionPerformed(evt);
- }
- });
- jLabel3.setText("Device Type :");
- jTextField2.setEditable(false);
- jTextField2.setEnabled(false);
- jTextField2.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jTextField2ActionPerformed(evt);
- }
- });
- jLabel4.setText("Evaluation Type :");
- jTextField3.setEditable(false);
- jTextField3.setEnabled(false);
- jTextField3.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jTextField3ActionPerformed(evt);
- }
- });
- jLabel5.setText("Evaluation Date Started :");
- jTextField4.setEditable(false);
- jTextField4.setEnabled(false);
- jTextField4.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jTextField4ActionPerformed(evt);
- }
- });
- jLabel6.setText("Purpose of Evaluation :");
- jTextField5.setEditable(false);
- jTextField5.setEnabled(false);
- jTextField5.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jTextField5ActionPerformed(evt);
- }
- });
- jLabel7.setText("Input Quantity:");
- jTextField6.setEditable(false);
- jTextField6.setEnabled(false);
- jTextField6.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jTextField6ActionPerformed(evt);
- }
- });
- jLabel8.setText("Requestor:");
- jTextField7.setEditable(false);
- jTextField7.setEnabled(false);
- jTextField7.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jTextField7ActionPerformed(evt);
- }
- });
- jLabel9.setText("Evaluator:");
- jTextField8.setEditable(false);
- jTextField8.setEnabled(false);
- jTextField8.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jTextField8ActionPerformed(evt);
- }
- });
- jLabel10.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabel10.setText("Special Instructions");
- jCheckBox1.setSelected(true);
- jCheckBox1.setText("Yield Report Analysis");
- jCheckBox1.setContentAreaFilled(false);
- jCheckBox1.setEnabled(false);
- jCheckBox1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jCheckBox1ActionPerformed(evt);
- }
- });
- jCheckBox2.setSelected(true);
- jCheckBox2.setText("Data Collection");
- jCheckBox2.setContentAreaFilled(false);
- jCheckBox2.setEnabled(false);
- jCheckBox2.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jCheckBox2ActionPerformed(evt);
- }
- });
- jCheckBox3.setText("Special Qualification Test");
- jCheckBox3.setContentAreaFilled(false);
- jCheckBox3.setEnabled(false);
- jCheckBox3.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jCheckBox3ActionPerformed(evt);
- }
- });
- jTabbedPane1.setBackground(new java.awt.Color(102, 153, 255));
- jTabbedPane1.setBorder(javax.swing.BorderFactory.createEtchedBorder(new java.awt.Color(153, 204, 255), new java.awt.Color(153, 153, 255)));
- jTabbedPane1.setEnabled(false);
- jTable1.setModel(new javax.swing.table.DefaultTableModel(
- new Object [][] {
- {null, null},
- {null, null},
- {null, null},
- {null, null},
- {null, null},
- {null, null},
- {null, null}
- },
- new String [] {
- "Material", "Remarks"
- }
- ) {
- Class[] types = new Class [] {
- java.lang.String.class, java.lang.String.class
- };
- public Class getColumnClass(int columnIndex) {
- return types [columnIndex];
- }
- });
- jTable1.setEnabled(false);
- jScrollPane1.setViewportView(jTable1);
- jTabbedPane1.addTab("Materials", jScrollPane1);
- jTable2.setModel(new javax.swing.table.DefaultTableModel(
- new Object [][] {
- {null, null, null},
- {null, null, null},
- {null, null, null},
- {null, null, null},
- {null, null, null},
- {null, null, null},
- {null, null, null}
- },
- new String [] {
- "Procedure No.", "Procedure", "Remarks"
- }
- ) {
- Class[] types = new Class [] {
- java.lang.String.class, java.lang.String.class, java.lang.String.class
- };
- public Class getColumnClass(int columnIndex) {
- return types [columnIndex];
- }
- });
- jTable2.setEnabled(false);
- jScrollPane2.setViewportView(jTable2);
- jTabbedPane1.addTab("Process", jScrollPane2);
- jLabel11.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabel11.setText("Other Requirement/s");
- jTextArea1.setColumns(20);
- jTextArea1.setEditable(false);
- jTextArea1.setRows(5);
- jTextArea1.setEnabled(false);
- jScrollPane3.setViewportView(jTextArea1);
- jCheckBox4.setText("Change in OQA Sampling");
- jCheckBox4.setContentAreaFilled(false);
- jCheckBox4.setEnabled(false);
- jCheckBox4.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jCheckBox4ActionPerformed(evt);
- }
- });
- jCheckBox5.setText("Special Test Plan");
- jCheckBox5.setContentAreaFilled(false);
- jCheckBox5.setEnabled(false);
- jCheckBox5.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jCheckBox5ActionPerformed(evt);
- }
- });
- jCheckBox6.setText("Change in Label Specification");
- jCheckBox6.setContentAreaFilled(false);
- jCheckBox6.setEnabled(false);
- jCheckBox6.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jCheckBox6ActionPerformed(evt);
- }
- });
- jLabel12.setFont(new java.awt.Font("Tahoma", 1, 12));
- jLabel12.setText("Disposition");
- jSeparator1.setBackground(new java.awt.Color(153, 204, 255));
- jSeparator1.setForeground(new java.awt.Color(153, 153, 255));
- jSeparator2.setBackground(new java.awt.Color(153, 204, 255));
- jSeparator2.setForeground(new java.awt.Color(153, 153, 255));
- jRadioButton3.setText("SHIP TO AVAGO");
- jRadioButton3.setContentAreaFilled(false);
- jRadioButton3.setEnabled(false);
- jRadioButton3.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jRadioButton3ActionPerformed(evt);
- }
- });
- jRadioButton4.setText("SCRAP");
- jRadioButton4.setContentAreaFilled(false);
- jRadioButton4.setEnabled(false);
- jRadioButton5.setText("SHIPPABLE");
- jRadioButton5.setContentAreaFilled(false);
- jRadioButton5.setEnabled(false);
- jRadioButton6.setText("OTHER");
- jRadioButton6.setContentAreaFilled(false);
- jRadioButton6.setEnabled(false);
- jRadioButton6.addChangeListener(new javax.swing.event.ChangeListener() {
- public void stateChanged(javax.swing.event.ChangeEvent evt) {
- jRadioButton6StateChanged(evt);
- }
- });
- jRadioButton6.addItemListener(new java.awt.event.ItemListener() {
- public void itemStateChanged(java.awt.event.ItemEvent evt) {
- jRadioButton6ItemStateChanged(evt);
- }
- });
- jRadioButton6.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jRadioButton6ActionPerformed(evt);
- }
- });
- jRadioButton6.addPropertyChangeListener(new java.beans.PropertyChangeListener() {
- public void propertyChange(java.beans.PropertyChangeEvent evt) {
- jRadioButton6PropertyChange(evt);
- }
- });
- jTextField9.setEditable(false);
- jTextField9.setEnabled(false);
- jSeparator3.setBackground(new java.awt.Color(153, 204, 255));
- jSeparator3.setForeground(new java.awt.Color(153, 153, 255));
- jSeparator4.setBackground(new java.awt.Color(153, 204, 255));
- jSeparator4.setForeground(new java.awt.Color(153, 153, 255));
- jSeparator5.setBackground(new java.awt.Color(153, 204, 255));
- jSeparator5.setForeground(new java.awt.Color(153, 153, 255));
- jButton1.setBackground(new java.awt.Color(102, 153, 255));
- jButton1.setText("New Entry");
- jButton1.addMouseListener(new java.awt.event.MouseAdapter() {
- public void mouseClicked(java.awt.event.MouseEvent evt) {
- jButton1MouseClicked(evt);
- }
- public void mousePressed(java.awt.event.MouseEvent evt) {
- jButton1MousePressed(evt);
- }
- });
- jButton1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton1ActionPerformed(evt);
- jButton1ActionPerformed1(evt);
- }
- });
- jButton2.setBackground(new java.awt.Color(102, 153, 255));
- jButton2.setText("Edit Entry");
- jButton2.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton2ActionPerformed(evt);
- }
- });
- jButton3.setBackground(new java.awt.Color(102, 153, 255));
- jButton3.setText("Save Entry");
- jButton3.setEnabled(false);
- jButton3.addMouseListener(new java.awt.event.MouseAdapter() {
- public void mouseClicked(java.awt.event.MouseEvent evt) {
- jButton3MouseClicked(evt);
- }
- });
- jButton3.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton3ActionPerformed(evt);
- }
- });
- jButton4.setBackground(new java.awt.Color(102, 153, 255));
- jButton4.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
- jButton4.setForeground(new java.awt.Color(255, 51, 51));
- jButton4.setText("Delete Entry");
- jButton4.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton4ActionPerformed(evt);
- }
- });
- jButton5.setBackground(new java.awt.Color(102, 153, 255));
- jButton5.setText("Print Entry");
- jButton5.setEnabled(false);
- jButton5.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton5ActionPerformed(evt);
- }
- });
- jTextField10.setEditable(false);
- jTextField10.setEnabled(false);
- jTextField10.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jTextField10ActionPerformed(evt);
- }
- });
- jTextField11.setEditable(false);
- jTextField11.setEnabled(false);
- jTextField12.setEditable(false);
- jTextField12.setEnabled(false);
- jTextField13.setEditable(false);
- jTextField13.setEnabled(false);
- jTextField14.setEditable(false);
- jTextField14.setEnabled(false);
- jTextField15.setEditable(false);
- jTextField15.setEnabled(false);
- jTextField15.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jTextField15ActionPerformed(evt);
- }
- });
- jButton7.setText("Add Row");
- jButton7.setEnabled(false);
- jButton7.addMouseListener(new java.awt.event.MouseAdapter() {
- public void mouseClicked(java.awt.event.MouseEvent evt) {
- jButton7MouseClicked(evt);
- }
- });
- jButton7.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton7ActionPerformed(evt);
- }
- });
- jButton9.setFont(new java.awt.Font("Tahoma", 1, 11));
- jButton9.setForeground(new java.awt.Color(255, 0, 51));
- jButton9.setText("Delete Row");
- jButton9.setEnabled(false);
- jTextField16.setBackground(new java.awt.Color(204, 255, 255));
- jTextField16.setForeground(new java.awt.Color(153, 153, 153));
- jTextField16.setText("Type SBR Number Here");
- jTextField16.setToolTipText("");
- jTextField16.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED));
- jTextField16.setEnabled(false);
- jTextField16.addMouseListener(new java.awt.event.MouseAdapter() {
- public void mouseClicked(java.awt.event.MouseEvent evt) {
- jTextField16MouseClicked(evt);
- }
- });
- jButton6.setBackground(new java.awt.Color(102, 153, 255));
- jButton6.setText("Search"// </editor-fold>
- private void jTextField1ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void jRadioButton1ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void jRadioButton2ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void jTextField2ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void jTextField3ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void jTextField4ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void jTextField5ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void jTextField6ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void jTextField7ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void jTextField8ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void jCheckBox1ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- if(jCheckBox1.isSelected())
- {
- jTextField10.setEnabled(true);
- jTextField10.setEditable(true);
- }
- else
- {
- jTextField10.setEnabled(false);
- jTextField10.setEditable(false);
- }
- }
- private void jCheckBox4ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- if(jCheckBox4.isSelected())
- {
- jTextField13.setEnabled(true);
- jTextField13.setEditable(true);
- }
- else
- {
- jTextField13.setEnabled(false);
- jTextField13.setEditable(false);
- }
- }
- private void jCheckBox5ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- if(jCheckBox5.isSelected())
- {
- jTextField14.setEnabled(true);
- jTextField14.setEditable(true);
- }
- else
- {
- jTextField14.setEnabled(false);
- jTextField14.setEditable(false);
- }
- }
- private void jRadioButton3ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- newOrEdit = true;
- jTextField9.setText("");
- // Enabling code
- jButton1.setEnabled(true);
- jButton2.setEnabled(true);
- jButton3.setEnabled(true);
- jButton4.setEnabled(true);
- jButton5.setEnabled(true);
- jButton7.setEnabled(true);
- jButton9.setEnabled(true);
- jButton6.setEnabled(false);
- jCheckBox1.setEnabled(true);
- jCheckBox2.setEnabled(true);
- jCheckBox3.setEnabled(true);
- jCheckBox4.setEnabled(true);
- jCheckBox5.setEnabled(true);
- jCheckBox6.setEnabled(true);
- jRadioButton1.setEnabled(true);
- jRadioButton2.setEnabled(true);
- jRadioButton3.setEnabled(true);
- jRadioButton4.setEnabled(true);
- jRadioButton5.setEnabled(true);
- jRadioButton6.setEnabled(true);
- jTabbedPane1.setEnabled(true);
- jTable1.setEnabled(true);
- jTable2.setEnabled(true);
- jTextArea1.setEnabled(true);
- jTextField1.setEnabled(true);
- jTextField2.setEnabled(true);
- jTextField3.setEnabled(true);
- jTextField4.setEnabled(true);
- jTextField5.setEnabled(true);
- jTextField6.setEnabled(true);
- jTextField7.setEnabled(true);
- jTextField8.setEnabled(true);
- jTextField9.setEnabled(false);
- jTextField10.setEnabled(true);
- jTextField11.setEnabled(true);
- jTextField12.setEnabled(false);
- jTextField13.setEnabled(false);
- jTextField14.setEnabled(false);
- jTextField15.setEnabled(false);
- jTextField16.setEnabled(false);
- jTextArea1.setEditable(true);
- jTextField1.setEditable(true);
- jTextField2.setEditable(true);
- jTextField3.setEditable(true);
- jTextField4.setEditable(true);
- jTextField5.setEditable(true);
- jTextField6.setEditable(true);
- jTextField7.setEditable(true);
- jTextField8.setEditable(true);
- jTextField9.setEditable(false);
- jTextField10.setEditable(true);
- jTextField11.setEditable(true);
- jTextField12.setEditable(false);
- jTextField13.setEditable(false);
- jTextField14.setEditable(false);
- jTextField15.setEditable(false);
- jTextField16.setEditable(false);
- //Defaults
- jRadioButton1.setSelected(false);
- jRadioButton2.setSelected(false);
- jRadioButton3.setSelected(false);
- jRadioButton4.setSelected(false);
- jRadioButton5.setSelected(false);
- jCheckBox1.setSelected(true);
- jCheckBox2.setSelected(true);
- jCheckBox3.setSelected(false);
- jCheckBox4.setSelected(false);
- jCheckBox5.setSelected(false);
- jCheckBox6.setSelected(false);
- jTextField1.setText("");
- jTextField2.setText("");
- jTextField3.setText("");
- jTextField4.setText("");
- jTextField5.setText("");
- jTextField6.setText("");
- jTextField7.setText("");
- jTextField8.setText("");
- jTextField10.setText("");
- jTextField11.setText("");
- jTextField12.setText("");
- jTextField13.setText("");
- jTextField14.setText("");
- jTextField15.setText("");
- jTextArea1.setText("");
- }
- private void jRadioButton6StateChanged(javax.swing.event.ChangeEvent evt) {
- // TODO add your handling code here:
- }
- private void jButton1MouseClicked(java.awt.event.MouseEvent evt) {
- // TODO add your handling code here:
- }
- private void jButton1MousePressed(java.awt.event.MouseEvent evt) {
- // TODO add your handling code here:
- }
- private void jButton1ActionPerformed1(java.awt.event.ActionEvent evt) {
- }
- private void jButton3MouseClicked(java.awt.event.MouseEvent evt) {
- // TODO add your handling code here:
- if((jButton3.isEnabled()) && (newOrEdit == true))
- {
- Connection connection = null;
- Statement statement1 = null;
- Statement statement2 = null;
- Statement statement3 = null;
- try
- {
- Class.forName(JDBC_DRIVER);
- connection = DriverManager.getConnection(DATABASE_URL, "root", "beethoven3777");
- statement1 = connection.createStatement();
- statement2 = connection.createStatement();
- statement3 = connection.createStatement();
- String text = "";
- String text2 = "";
- char testbool[] = {0, 0, 0, 0, 0, 0};
- if(jRadioButton3.isSelected())
- text = "SHIPTO AVAGO";
- else if(jRadioButton5.isSelected())
- text = "SHIPPABLE";
- else if(jRadioButton4.isSelected())
- text = "SCRAP";
- else if(jRadioButton6.isSelected())
- text = jTextField9.getText();
- if(jRadioButton1.isSelected())
- text2 = "In-House Evaluation";
- else if(jRadioButton2.isSelected())
- text2 = "Customer";
- for(int i = 0; i <= 5; i++)
- {
- switch(i)
- {
- case 0:
- if(jCheckBox1.isSelected())
- testbool[i] = 1;
- break;
- case 1:
- if(jCheckBox2.isSelected())
- testbool[i] = 1;
- break;
- case 2:
- if(jCheckBox3.isSelected())
- testbool[i] = 1;
- break;
- case 3:
- if(jCheckBox4.isSelected())
- testbool[i] = 1;
- break;
- case 4:
- if(jCheckBox5.isSelected())
- testbool[i] = 1;
- break;
- case 5:
- if(jCheckBox6.isSelected())
- testbool[i] = 1;
- break;
- }
- }
- statement1.executeQuery("INSERT INTO `testdb` (" +
- "`SBRNo`, " +
- "`disposition`, " +
- "`evalReq`, " +
- "`devType`, " +
- "`evalType`, " +
- "`evalDateStart`, " +
- "`evalPurpose`, " +
- "`inputQty`, " +
- "`requestor`, " +
- "`evaluator`, " +
- "`yieldRA`, " +
- "`yieldRAText`, " +
- "`dataCol`, " +
- "`dataColText`, " +
- "`specialQTest`, " +
- "`specialQTestText`, " +
- "`changeOQA`, " +
- "`changeOQAText`, " +
- "`specialTestPlan`, " +
- "`specialTestPlanText`, " +
- "`changeLabelReq`, " +
- "`changeLabelReqText`, " +
- "`otherReq`" +
- ") VALUES ('" +
- jTextField1.getText() + // SBRNo
- "', '" +
- text + // disposition
- "', '" +
- text2 + // evalReq
- "', '" +
- jTextField2.getText() + // devType
- "', '" +
- jTextField3.getText() + // evalType
- "', '" +
- jTextField4.getText() + // evalDateStart
- "', '" +
- jTextField5.getText() + // evalPurpose
- "', '" +
- jTextField6.getText() + // inputQty
- "', '" +
- jTextField7.getText() + // requestor
- "', '" +
- jTextField8.getText() + // evaluator
- "', '" +
- Character.toString(testbool[0]) + // yieldRA
- "', '" +
- jTextField10.getText() + // yieldRAText
- "', '" +
- Character.toString(testbool[1]) + // dataCol
- "', '" +
- jTextField11.getText() + // dataColText
- "', '" +
- Character.toString(testbool[2]) + // specialQTest
- "', '" +
- jTextField12.getText() + // specialQTestText
- "', '" +
- Character.toString(testbool[3]) + // changeOQA
- "', '" +
- jTextField13.getText() + // changeOQAText
- "', '" +
- Character.toString(testbool[4]) + // specialTestPlan
- "', '" +
- jTextField14.getText() + // specialtestPlantext
- "', '" +
- Character.toString(testbool[5]) + // changeLabelReq
- "', '" +
- jTextField15.getText() + // changeLabelReqText
- "', '" +
- jTextArea1.getText() + // otherReq
- "')");
- int testint = jTable1.getRowCount();
- for(int i = 0; i <= testint; i++)
- {
- statement2.executeQuery("INSERT INTO `testdb2_matls` (`SBRNo`, " +
- "`material`, " +
- "`remarks`" +
- ") VALUES ('" +
- jTextField1.getText() +
- "', '" +
- jTable1.getValueAt(i, 1) +
- "', '" +
- jTable1.getValueAt(i, 2) +
- "')");
- }
- testint = jTable2.getRowCount();
- for(int i = 0; i <= testint; i++)
- {
- statement3.executeQuery("INSERT INTO `testdb2_proc` (`SBRNo`, " +
- "`procNo`, " +
- "`proc`, " +
- "`remarks`" +
- ") VALUES ('" +
- jTextField1.getText() +
- "', '" +
- jTable2.getValueAt(i, 1) +
- "', '" +
- jTable2.getValueAt(i, 2) +
- "', '" +
- jTable2.getValueAt(i, 3) +
- "')");
- }
- text = jTextField1.getText();
- jTextField1.setText("");
- jTextField2.setText("");
- jTextField3.setText("");
- jTextField4.setText("");
- jTextField5.setText("");
- jTextField6.setText("");
- jTextField7.setText("");
- jTextField8.setText("");
- jTextField10.setText("");
- jTextField11.setText("");
- jTextField12.setText("");
- jTextField13.setText("");
- jTextField14.setText("");
- jTextField15.setText("");
- jTextArea1.setText("");
- jButton1.setEnabled(true);
- jButton2.setEnabled(true);
- jButton3.setEnabled(false);
- jButton4.setEnabled(true);
- jButton5.setEnabled(false);
- jButton6.setEnabled(false);
- jButton7.setEnabled(false);
- jButton9.setEnabled(false);
- jCheckBox1.setEnabled(false);
- jCheckBox2.setEnabled(false);
- jCheckBox3.setEnabled(false);
- jCheckBox4.setEnabled(false);
- jCheckBox5.setEnabled(false);
- jCheckBox6.setEnabled(false);
- jRadioButton1.setEnabled(false);
- jRadioButton2.setEnabled(false);
- jRadioButton3.setEnabled(false);
- jRadioButton4.setEnabled(false);
- jRadioButton5.setEnabled(false);
- jRadioButton6.setEnabled(false);
- jTabbedPane1.setEnabled(false);
- jTable1.setEnabled(false);
- jTable2.setEnabled(false);
- jTextArea1.setEnabled(false);
- jTextField1.setEnabled(false);
- jTextField2.setEnabled(false);
- jTextField3.setEnabled(false);
- jTextField4.setEnabled(false);
- jTextField5.setEnabled(false);
- jTextField6.setEnabled(false);
- jTextField7.setEnabled(false);
- jTextField8.setEnabled(false);
- jTextField9.setEnabled(false);
- jTextField10.setEnabled(false);
- jTextField11.setEnabled(false);
- jTextField12.setEnabled(false);
- jTextField13.setEnabled(false);
- jTextField14.setEnabled(false);
- jTextField15.setEnabled(false);
- jLabel13.setText(text + " entry has been saved.");
- }
- catch(SQLException sqlException)
- {
- sqlException.printStackTrace();
- System.exit(1);
- }
- catch(ClassNotFoundException classNotFound)
- {
- classNotFound.printStackTrace();
- System.exit(1);
- }
- finally
- {
- try
- {
- statement1.close();
- statement2.close();
- statement3.close();
- connection.close();
- }
- catch(Exception exception)
- {
- exception.printStackTrace();
- System.exit(1);
- }
- }
- }
- else if((jButton3.isEnabled()) && (newOrEdit == false))
- {
- Connection connection = null;
- Statement statement1 = null;
- Statement statement2 = null;
- Statement statement3 = null;
- try
- {
- Class.forName(JDBC_DRIVER);
- connection = DriverManager.getConnection(DATABASE_URL, "root", "beethoven3777");
- statement1 = connection.createStatement();
- statement2 = connection.createStatement();
- statement3 = connection.createStatement();
- String text = "";
- String text2 = "";
- char testbool[] = {0, 0, 0, 0, 0, 0};
- if(jRadioButton3.isSelected())
- text = "SHIPTO AVAGO";
- else if(jRadioButton5.isSelected())
- text = "SHIPPABLE";
- else if(jRadioButton4.isSelected())
- text = "SCRAP";
- else if(jRadioButton6.isSelected())
- text = jTextField9.getText();
- if(jRadioButton1.isSelected())
- text2 = "In-House Evaluation";
- else if(jRadioButton2.isSelected())
- text2 = "Customer";
- for(int i = 0; i <= 5; i++)
- {
- switch(i)
- {
- case 0:
- if(jCheckBox1.isSelected())
- testbool[i] = 1;
- break;
- case 1:
- if(jCheckBox2.isSelected())
- testbool[i] = 1;
- break;
- case 2:
- if(jCheckBox3.isSelected())
- testbool[i] = 1;
- break;
- case 3:
- if(jCheckBox4.isSelected())
- testbool[i] = 1;
- break;
- case 4:
- if(jCheckBox5.isSelected())
- testbool[i] = 1;
- break;
- case 5:
- if(jCheckBox6.isSelected())
- testbool[i] = 1;
- break;
- }
- }
- statement1.executeQuery("DELETE FROM `testdb_matls` WHERE `SBRNo` = '" + jTextField1.getText() + "'");
- statement1.executeQuery("INSERT INTO `testdb` (" +
- "`SBRNo`, " +
- "`disposition`, " +
- "`evalReq`, " +
- "`devType`, " +
- "`evalType`, " +
- "`evalDateStart`, " +
- "`evalPurpose`, " +
- "`inputQty`, " +
- "`requestor`, " +
- "`evaluator`, " +
- "`yieldRA`, " +
- "`yieldRAText`, " +
- "`dataCol`, " +
- "`dataColText`, " +
- "`specialQTest`, " +
- "`specialQTestText`, " +
- "`changeOQA`, " +
- "`changeOQAText`, " +
- "`specialTestPlan`, " +
- "`specialTestPlanText`, " +
- "`changeLabelReq`, " +
- "`changeLabelReqText`, " +
- "`otherReq`" +
- ") VALUES ('" +
- jTextField1.getText() + // SBRNo
- "', '" +
- text + // disposition
- "', '" +
- text2 + // evalReq
- "', '" +
- jTextField2.getText() + // devType
- "', '" +
- jTextField3.getText() + // evalType
- "', '" +
- jTextField4.getText() + // evalDateStart
- "', '" +
- jTextField5.getText() + // evalPurpose
- "', '" +
- jTextField6.getText() + // inputQty
- "', '" +
- jTextField7.getText() + // requestor
- "', '" +
- jTextField8.getText() + // evaluator
- "', '" +
- Character.toString(testbool[0]) + // yieldRA
- "', '" +
- jTextField10.getText() + // yieldRAText
- "', '" +
- Character.toString(testbool[1]) + // dataCol
- "', '" +
- jTextField11.getText() + // dataColText
- "', '" +
- Character.toString(testbool[2]) + // specialQTest
- "', '" +
- jTextField12.getText() + // specialQTestText
- "', '" +
- Character.toString(testbool[3]) + // changeOQA
- "', '" +
- jTextField13.getText() + // changeOQAText
- "', '" +
- Character.toString(testbool[4]) + // specialTestPlan
- "', '" +
- jTextField14.getText() + // specialtestPlantext
- "', '" +
- Character.toString(testbool[5]) + // changeLabelReq
- "', '" +
- jTextField15.getText() + // changeLabelReqText
- "', '" +
- jTextArea1.getText() + // otherReq
- "')");
- statement2.executeQuery("DELETE FROM `testdb_matls` WHERE `SBRNo` = '" + jTextField1.getText() + "'");
- statement3.executeQuery("DELETE FROM `testdb_proc` WHERE `SBRNo` = '" + jTextField1.getText() + "'");
- int testint = jTable1.getRowCount();
- for(int i = 0; i <= testint; i++)
- {
- statement2.executeQuery("INSERT INTO `testdb2_matls` (`SBRNo`, " +
- "`material`, " +
- "`remarks`" +
- ") VALUES ('" +
- jTextField1.getText() +
- "', '" +
- jTable1.getValueAt(i, 1) +
- "', '" +
- jTable1.getValueAt(i, 2) +
- "')");
- }
- testint = jTable2.getRowCount();
- for(int i = 0; i <= testint; i++)
- {
- statement3.executeQuery("INSERT INTO `testdb2_proc` (`SBRNo`, " +
- "`procNo`, " +
- "`proc`, " +
- "`remarks`" +
- ") VALUES ('" +
- jTextField1.getText() +
- "', '" +
- jTable2.getValueAt(i, 1) +
- "', '" +
- jTable2.getValueAt(i, 2) +
- "', '" +
- jTable2.getValueAt(i, 3) +
- "')");
- }
- text = jTextField1.getText();
- jTextField1.setText("");
- jTextField2.setText("");
- jTextField3.setText("");
- jTextField4.setText("");
- jTextField5.setText("");
- jTextField6.setText("");
- jTextField7.setText("");
- jTextField8.setText("");
- jTextField10.setText("");
- jTextField11.setText("");
- jTextField12.setText("");
- jTextField13.setText("");
- jTextField14.setText("");
- jTextField15.setText("");
- jTextArea1.setText("");
- jButton1.setEnabled(true);
- jButton2.setEnabled(true);
- jButton3.setEnabled(false);
- jButton4.setEnabled(true);
- jButton5.setEnabled(false);
- jButton6.setEnabled(false);
- jButton7.setEnabled(false);
- jButton9.setEnabled(false);
- jCheckBox1.setEnabled(false);
- jCheckBox2.setEnabled(false);
- jCheckBox3.setEnabled(false);
- jCheckBox4.setEnabled(false);
- jCheckBox5.setEnabled(false);
- jCheckBox6.setEnabled(false);
- jRadioButton1.setEnabled(false);
- jRadioButton2.setEnabled(false);
- jRadioButton3.setEnabled(false);
- jRadioButton4.setEnabled(false);
- jRadioButton5.setEnabled(false);
- jRadioButton6.setEnabled(false);
- jTabbedPane1.setEnabled(false);
- jTable1.setEnabled(false);
- jTable2.setEnabled(false);
- jTextArea1.setEnabled(false);
- jTextField1.setEnabled(false);
- jTextField2.setEnabled(false);
- jTextField3.setEnabled(false);
- jTextField4.setEnabled(false);
- jTextField5.setEnabled(false);
- jTextField6.setEnabled(false);
- jTextField7.setEnabled(false);
- jTextField8.setEnabled(false);
- jTextField9.setEnabled(false);
- jTextField10.setEnabled(false);
- jTextField11.setEnabled(false);
- jTextField12.setEnabled(false);
- jTextField13.setEnabled(false);
- jTextField14.setEnabled(false);
- jTextField15.setEnabled(false);
- jLabel13.setText(text + " entry has been saved.");
- }
- catch(SQLException sqlException)
- {
- sqlException.printStackTrace();
- System.exit(1);
- }
- catch(ClassNotFoundException classNotFound)
- {
- classNotFound.printStackTrace();
- System.exit(1);
- }
- finally
- {
- try
- {
- statement1.close();
- statement2.close();
- statement3.close();
- connection.close();
- }
- catch(Exception exception)
- {
- exception.printStackTrace();
- System.exit(1);
- }
- }
- }
- }
- private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void jButton7MouseClicked(java.awt.event.MouseEvent evt) {
- // TODO add your handling code here:
- }
- private void jTextField16MouseClicked(java.awt.event.MouseEvent evt) {
- // TODO add your handling code here:
- if(jTextField16.isEnabled())
- {
- jTextField16.setText("");
- jTextField16.setForeground(Color.black);
- jTextField16.setCursor(null);
- }
- }
- private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- if(jButton4.isEnabled())
- {
- jTextField16.setEnabled(true);
- jButton6.setEnabled(true);
- jTextField16.setEditable(true);
- jButton6.setText("Delete");
- }
- }
- private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- if(jButton2.isEnabled())
- {
- newOrEdit = false;
- jTextField16.setEnabled(true);
- jButton6.setEnabled(true);
- jTextField16.setEditable(true);
- jButton6.setText("Search");
- }
- }
- private void jRadioButton6ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- if(jButton6.isEnabled())
- {
- String buttonSelect = jButton6.getText();
- if(buttonSelect == "Search")
- {
- Connection connection = null;
- Statement statement1 = null;
- Statement statement2 = null;
- Statement statement3 = null;
- jLabel13.setText("Searching...");
- try {
- Class.forName(JDBC_DRIVER);
- connection = DriverManager.getConnection(DATABASE_URL, "root", "beethoven3777");
- // Statement declarations
- statement1 = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
- statement2 = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
- statement3 = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
- // Resultsets
- ResultSet resultSet1 = statement1.executeQuery(
- "SELECT " +
- "`SBRNo`, " +
- "`disposition` , " +
- "`evalReq`, " +
- "`devType`, " +
- "`evalType`, " +
- "`evalDateStart`, " +
- "`evalPurpose`, " +
- "`inputQty`, " +
- "`requestor`, " +
- "`evaluator`, " +
- "`yieldRA`, " +
- "`yieldRAText`, " +
- "`dataCol`, " +
- "`dataColText`, " +
- "`specialQTest`, " +
- "`specialQTestText`, " +
- "`changeOQA`, " +
- "`changeOQAText`, " +
- "`specialTestPlan`, " +
- "`specialTestPlanText`, " +
- "`changeLabelReq`, " +
- "`changeLabelReqText`, " +
- "`otherReq`, " +
- "FROM `testdb` WHERE SBRNo = `" + jTextField16.getText() + "`");
- ResultSet resultSet2 = statement2.executeQuery(
- "SELECT " +
- "`SBRNo`, " +
- "`material`, `remarks` " +
- "FROM `testdb2_matls` WHERE SBRNo = `" + jTextField16.getText() + "`");
- ResultSet resultSet3 = statement3.executeQuery(
- "SELECT " +
- "`SBRNo`, " +
- "`procNo`" +
- "`process`, " +
- "`remarks` " +
- "FROM `testdb2_proc` WHERE SBRNo = `" + jTextField16.getText() + "`");
- // Gather data from resultsets
- ResultSetMetaData meta2 = resultSet2.getMetaData();
- ResultSetMetaData meta3 = resultSet3.getMetaData();
- int numberOfColumnsOf2 = meta2.getColumnCount();
- int numberOfColumnsOf3 = meta3.getColumnCount();
- // Materials and remarks
- int j = 0; // Row Counter
- while(resultSet2.next())
- {
- // SBRNo field should be skipped, thus i = 2
- for(int i = 2; i <= numberOfColumnsOf2; i++)
- {
- jTable1.setValueAt(resultSet2.getObject(i).toString(), j, i - 2);
- }
- j++;
- }
- // Procedures and remarks
- j = 0; // Reset row counter
- while(resultSet3.next())
- {
- // SBRNo should be skipped, thus i = 2
- for(int i = 2; i <= numberOfColumnsOf3; i++)
- {
- jTable2.setValueAt(resultSet3.getObject(i).toString(), j, i - 2);
- }
- j++;
- }
- // Get values for other fields, convert them to string
- for(int i = 1; i <= 23; i++)
- {
- String test = resultSet1.getObject(i).toString();
- boolean testbool = equals(resultSet1.getObject(i));
- switch(i)
- {
- case 1:
- jTextField1.setText(test); // SBR No
- break;
- case 2:
- if(test == "SEND TO AVAGO") //----------------------
- { //
- jRadioButton3.setEnabled(true); //
- } //
- else if(test == "SHIPPABLE") //
- { //
- jRadioButton5.setEnabled(true); //
- } //
- else if(test == "SCRAP") // disposition
- { //
- jRadioButton4.setEnabled(true); //
- } //
- else //
- { //
- jRadioButton6.setEnabled(true); //
- jTextField9.setText(test); //
- }
- break;
- case 3:
- if(test == "In-House Evaluation") //------------------
- { //
- jRadioButton1.setEnabled(true); //
- jRadioButton2.setEnabled(false); //
- } // evalReq
- else if(test == "Customer") // possible that they're checkboxes
- { //
- jRadioButton1.setEnabled(false); //
- jRadioButton2.setEnabled(true); //
- } //------------------
- break;
- case 4:
- jTextField2.setText(test); // device type
- break;
- case 5:
- jTextField3.setText(test); // evaluation type
- break;
- case 6:
- jTextField4.setText(test); // evaluation date started
- break;
- case 7:
- jTextField5.setText(test); // purpose of evaluation
- break;
- case 8:
- jTextField6.setText(test); // input qty
- break;
- case 9:
- jTextField7.setText(test); // requestor
- break;
- case 10:
- jTextField8.setText(test); // evaluator
- break;
- case 11:
- if(testbool == true) //--------------
- { //
- jCheckBox1.setEnabled(true); // yield report analysis
- } //--------------
- break;
- case 12:
- jTextField10.setText(test); // yieldRAText
- break;
- case 13:
- if(testbool == true) //--------------
- { //
- jCheckBox2.setEnabled(true); // data collection
- } //--------------
- break;
- case 14:
- jTextField11.setText(test); // dataColText
- break;
- case 15:
- if(testbool == true) //--------------
- { //
- jCheckBox3.setEnabled(true); // special qualification test
- } //--------------
- break;
- case 16:
- jTextField12.setText(test); // specialQTestText
- break;
- case 17:
- if(testbool == true) //--------------
- { //
- jCheckBox4.setEnabled(true); // change in oqa sampling
- } //--------------
- break;
- case 18:
- jTextField13.setText(test); // changeOQAText
- break;
- case 19:
- if(testbool == true) //--------------
- { //
- jCheckBox5.setEnabled(true); // special test plan
- } //--------------
- break;
- case 20:
- jTextField14.setText(test); // specialTestPlanText
- break;
- case 21:
- if(testbool == true) //--------------
- { //
- jCheckBox6.setEnabled(true); // change in label spec
- }
- break;
- case 22:
- jTextField15.setText(test); // changeLabelReqText
- break;
- case 23:
- jTextArea1.setText(test); // other requirements
- break;
- }
- }
- jLabel13.setText(jTextField1.getText() + " entry found.");
- }
- catch(SQLException sqlException)
- {
- jLabel13.setText("Error!");
- sqlException.printStackTrace();
- System.exit(1);
- }
- catch(ClassNotFoundException classNotFound)
- {
- jLabel13.setText("Error!");
- classNotFound.printStackTrace();
- System.exit(1);
- }
- finally
- {
- try
- {
- statement1.close();
- statement2.close();
- statement3.close();
- connection.close();
- }
- catch(Exception exception)
- {
- jLabel13.setText("Error!");
- exception.printStackTrace();
- System.exit(1);
- }
- }
- }
- else if(buttonSelect == "Delete")
- {
- Connection connection = null;
- Statement statement1 = null;
- Statement statement2 = null;
- Statement statement3 = null;
- jLabel13.setText("Searching...");
- try {
- Class.forName(JDBC_DRIVER);
- connection = DriverManager.getConnection(DATABASE_URL, "root", "beethoven3777");
- // Statement declarations
- statement1 = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
- statement2 = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
- statement3 = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
- statement1.executeQuery("DELETE from testdb WHERE SBRNo = " + jTextField16.getText());
- statement2.executeQuery("DELETE from testdb WHERE SBRNo = " + jTextField16.getText());
- statement3.executeQuery("DELETE from testdb WHERE SBRNo = " + jTextField16.getText());
- jLabel13.setText(jTextField1.getText() + " entry deleted.");
- jTextField16.setText("");
- jTextField16.setEnabled(false);
- jTextField16.setEditable(false);
- jButton6.setEnabled(false);
- }
- catch(SQLException sqlException)
- {
- jLabel13.setText("Error!");
- sqlException.printStackTrace();
- System.exit(1);
- }
- catch(ClassNotFoundException classNotFound)
- {
- jLabel13.setText("Error!");
- classNotFound.printStackTrace();
- System.exit(1);
- }
- finally
- {
- try
- {
- statement1.close();
- statement2.close();
- statement3.close();
- connection.close();
- }
- catch(Exception exception)
- {
- jLabel13.setText("Error!");
- exception.printStackTrace();
- System.exit(1);
- }
- }
- }
- }
- }
- private void jTextField15ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void jCheckBox2ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- if(jCheckBox2.isSelected())
- {
- jTextField11.setEnabled(true);
- jTextField11.setEditable(true);
- }
- else
- {
- jTextField11.setEnabled(false);
- jTextField11.setEditable(false);
- }
- }
- private void jCheckBox3ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- if(jCheckBox3.isSelected())
- {
- jTextField12.setEnabled(true);
- jTextField12.setEditable(true);
- }
- else
- {
- jTextField12.setEnabled(false);
- jTextField12.setEditable(false);
- }
- }
- private void jCheckBox6ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- if(jCheckBox6.isSelected())
- {
- jTextField15.setEnabled(true);
- jTextField15.setEditable(true);
- }
- else
- {
- jTextField15.setEnabled(false);
- jTextField15.setEditable(false);
- }
- }
- private void jRadioButton6PropertyChange(java.beans.PropertyChangeEvent evt) {
- // TODO add your handling code here:
- }
- private void jTextField10ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void jRadioButton6ItemStateChanged(java.awt.event.ItemEvent evt) {
- // TODO add your handling code here:
- if(jRadioButton6.isSelected())
- {
- jTextField9.setEnabled(true);
- jTextField9.setEditable(true);
- }
- else
- {
- jTextField9.setEnabled(false);
- jTextField9.setEditable(false);
- }
- }
- // Variables declaration - do not modify
- private javax.swing.ButtonGroup buttonGroup1;
- private javax.swing.ButtonGroup buttonGroup2;
- private javax.swing.JButton jButton1;
- private javax.swing.JButton jButton2;
- private javax.swing.JButton jButton3;
- private javax.swing.JButton jButton4;
- private javax.swing.JButton jButton5;
- private javax.swing.JButton jButton6;
- private javax.swing.JButton jButton7;
- private javax.swing.JButton jButton9;
- private javax.swing.JCheckBox jCheckBox1;
- private javax.swing.JCheckBox jCheckBox2;
- private javax.swing.JCheckBox jCheckBox3;
- private javax.swing.JCheckBox jCheckBox4;
- private javax.swing.JCheckBox jCheckBox5;
- private javax.swing.JCheckBox jCheckBox6;
- private javax.swing.JDialog jDialog1;
- 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 jLabel2;
- private javax.swing.JLabel jLabel3;
- private javax.swing.JLabel jLabel4;
- private javax.swing.JLabel jLabel5;
- private javax.swing.JLabel jLabel6;
- private javax.swing.JLabel jLabel7;
- private javax.swing.JLabel jLabel8;
- private javax.swing.JLabel jLabel9;
- private javax.swing.JRadioButton jRadioButton1;
- private javax.swing.JRadioButton jRadioButton2;
- private javax.swing.JRadioButton jRadioButton3;
- private javax.swing.JRadioButton jRadioButton4;
- private javax.swing.JRadioButton jRadioButton5;
- private javax.swing.JRadioButton jRadioButton6;
- private javax.swing.JScrollPane jScrollPane1;
- private javax.swing.JScrollPane jScrollPane2;
- private javax.swing.JScrollPane jScrollPane3;
- private javax.swing.JSeparator jSeparator1;
- private javax.swing.JSeparator jSeparator2;
- private javax.swing.JSeparator jSeparator3;
- private javax.swing.JSeparator jSeparator4;
- private javax.swing.JSeparator jSeparator5;
- private javax.swing.JTabbedPane jTabbedPane1;
- private javax.swing.JTable jTable1;
- private javax.swing.JTable jTable2;
- private javax.swing.JTextArea jTextArea1;
- 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 jTextField2;
- private javax.swing.JTextField jTextField3;
- private javax.swing.JTextField jTextField4;
- 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
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement