zhussai7
asked on
java - ms access
Need urgent help on small project. Â I am having difficulty in getting my data to appear in the microsoft database. Â The connection work finebut the data is not stored. Â The code is given below please do not be concerned with other aspects of the code I will work on them myself but am only concerned with getting data to appear in the database. Â APOLOGIES FOR THE MESS BUT WILL SORT OUT ONCE DATABASE PROBLEM HASBEEN RECTIFIED. Thankyou.
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.io.*;
import java.text.*;
import java.util.*;
import java.sql.*;
import java.io.PrintStream;
import java.io.FileOutputStream;
import java.io.IOException;
public class riskAnalyser extends JPanel
{
      // Variables declaration - do not modify
  private Connection connection;
       private Statement stmt;
      private String url="jdbc:odbc:fuzzy";
      private String username="zhussain";
      private String password="brutus";
     Â
//Class.forName("sun.jdbc. odbc.JdbcO dbcDriver" );
//String URL = "jdbc:odbc:Driver={Microso ft Access Driver (*.mdb)};DBQ=C:/fuzzy_loan _risk_anal yser.MDB";
//DBConn = DriverManager.getConnectio n(URL,""," ");
  private javax.swing.JButton jButton2;
  private javax.swing.JButton jButton3;
  private javax.swing.JButton jButton4;
  private javax.swing.JCheckBox jCheckBox1;
  private javax.swing.JCheckBox jCheckBox2;
  private javax.swing.JCheckBox jCheckBox3;
  private javax.swing.JCheckBox jCheckBox4;
  private javax.swing.JComboBox jComboBox1;
  private javax.swing.JComboBox Age;
  private javax.swing.JComboBox JobHeld;
  private javax.swing.JComboBox Period;
  private javax.swing.JComboBox CreditRating;
  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 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.JTextField jTextField1;
  private javax.swing.JTextField jTextField10;
  private javax.swing.JTextField Salary;
  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 Loan;
  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;
 Â
  private String forename, surname, address1, address2, city, postcode, homeTel, mobTel, e_mail, occupation, salary, empName, empAdd1, empCity, empPostcode, empTelephone, amount;
  // End of variables declaration
 Â
  /** Creates new form JPanel */
  public riskAnalyser()
 Â
Â
 {
    java.awt.GridBagConstraint s gridBagConstraints;
try
           {
                  Class.forName("sun.jdbc.od bc.JdbcOdb cDriver");
           }
           catch (Exception e)
           {
                  System.out.println("Failed to load JDBC/ODBC driver.");
                  return;
           }
           // get a connection
           try
           {
                  connection = DriverManager.getConnectio n(url, username, password);
                  System.out.println("Succes sful Connection To: " +url);
           }
          Â
           catch (Exception e)
           {
                  System.err.println("proble ms connecting to "+url);
           }
   Â
    jLabel2 = new javax.swing.JLabel();
    jLabel1 = new javax.swing.JLabel();
    jComboBox1 = new javax.swing.JComboBox();
    jLabel3 = new javax.swing.JLabel();
    jTextField1 = new javax.swing.JTextField();
    jLabel4 = new javax.swing.JLabel();
    jTextField2 = new javax.swing.JTextField();
    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();
    jLabel9 = new javax.swing.JLabel();
    jTextField7 = new javax.swing.JTextField();
    jTextField8 = new javax.swing.JTextField();
    jLabel10 = new javax.swing.JLabel();
    jTextField9 = new javax.swing.JTextField();
    jLabel11 = new javax.swing.JLabel();
    Age = new javax.swing.JComboBox();
    jLabel12 = new javax.swing.JLabel();
    jLabel13 = new javax.swing.JLabel();
    jLabel14 = new javax.swing.JLabel();
    jLabel15 = new javax.swing.JLabel();
    jTextField10 = new javax.swing.JTextField();
    jLabel16 = new javax.swing.JLabel();
    JobHeld = new javax.swing.JComboBox();
    jLabel17 = new javax.swing.JLabel();
    Salary = 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();
    jLabel21 = new javax.swing.JLabel();
    jTextField14 = new javax.swing.JTextField();
    jLabel22 = new javax.swing.JLabel();
    jTextField15 = new javax.swing.JTextField();
    jLabel23 = new javax.swing.JLabel();
    jTextField16 = new javax.swing.JTextField();
    jLabel24 = new javax.swing.JLabel();
    jLabel25 = new javax.swing.JLabel();
    Loan = new javax.swing.JTextField();
    jLabel26 = new javax.swing.JLabel();
    jLabel27 = new javax.swing.JLabel();
    Period = new javax.swing.JComboBox();
    jLabel28 = new javax.swing.JLabel();
    jCheckBox1 = new javax.swing.JCheckBox();
    jCheckBox2 = new javax.swing.JCheckBox();
    jLabel29 = new javax.swing.JLabel();
    jCheckBox3 = new javax.swing.JCheckBox();
    jCheckBox4 = new javax.swing.JCheckBox();
    jLabel30 = new javax.swing.JLabel();
    jLabel31 = new javax.swing.JLabel();
    CreditRating = new javax.swing.JComboBox();
    jButton2 = new javax.swing.JButton();
    jLabel32 = new javax.swing.JLabel();
    jLabel33 = new javax.swing.JLabel();
    jButton3 = new javax.swing.JButton();
    jButton4 = new javax.swing.JButton();
    setLayout(new java.awt.GridBagLayout());
   Â
    setBackground(new java.awt.Color(194, 215, 240));
    setBorder(new javax.swing.border.EmptyBo rder(new java.awt.Insets(1, 1, 1, 1)));
    jLabel2.setText("Title");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 2;
    gridBagConstraints.insets = new java.awt.Insets(9, 0, 9, 343);
    add(jLabel2, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 0;
    gridBagConstraints.gridy = 0;
    add(jLabel1, gridBagConstraints);
    jComboBox1.setBackground(n ew java.awt.Color(255, 255, 255));
    jComboBox1.setModel(new javax.swing.DefaultComboBo xModel(new String[] { "Mr", "Mrs", "Miss", "Ms" }));
    jComboBox1.addActionListen er(new java.awt.event.ActionListe ner() {
      public void actionPerformed(java.awt.e vent.Actio nEvent evt) {
        jComboBox1ActionPerformed( evt);
      }
    });
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 2;
    gridBagConstraints.insets = new java.awt.Insets(9, 125, 0, 187);
    add(jComboBox1, gridBagConstraints);
    jLabel3.setText("*Surname" );
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 3;
    gridBagConstraints.insets = new java.awt.Insets(15, 0, 0, 310);
    add(jLabel3, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 3;
    gridBagConstraints.gridhei ght = 2;
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(15, 125, 36, 112);
    add(jTextField1, gridBagConstraints);
    jLabel4.setText("Address 1");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 4;
    gridBagConstraints.insets = new java.awt.Insets(24, 2, 0, 307);
    add(jLabel4, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 4;
    gridBagConstraints.gridhei ght = 2;
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(24, 125, 36, 112);
    add(jTextField2, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 4;
    gridBagConstraints.gridwid th = 3;
    gridBagConstraints.gridhei ght = 2;
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(24, 73, 36, 52);
    add(jTextField3, gridBagConstraints);
    jLabel5.setText("Town/City ");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 5;
    gridBagConstraints.insets = new java.awt.Insets(24, 2, 0, 310);
    add(jLabel5, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 5;
    gridBagConstraints.gridhei ght = 2;
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(24, 125, 36, 112);
    add(jTextField4, gridBagConstraints);
    jLabel6.setText("*Postcode ");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 5;
    gridBagConstraints.gridwid th = 2;
    gridBagConstraints.insets = new java.awt.Insets(24, 325, 0, 106);
    add(jLabel6, gridBagConstraints);
    jTextField5.addActionListe ner(new java.awt.event.ActionListe ner() {
      public void actionPerformed(java.awt.e vent.Actio nEvent evt) {
        jTextField5ActionPerformed (evt);
      }
    });
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 5;
    gridBagConstraints.gridwid th = 3;
    gridBagConstraints.gridhei ght = 2;
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(24, 73, 36, 52);
    add(jTextField5, gridBagConstraints);
    jLabel7.setText("*Forename ");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 3;
    gridBagConstraints.gridwid th = 2;
    gridBagConstraints.insets = new java.awt.Insets(15, 325, 0, 103);
    add(jLabel7, gridBagConstraints);
    jTextField6.addActionListe ner(new java.awt.event.ActionListe ner() {
      public void actionPerformed(java.awt.e vent.Actio nEvent evt) {
        jTextField6ActionPerformed (evt);
      }
    });
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 3;
    gridBagConstraints.gridwid th = 3;
    gridBagConstraints.gridhei ght = 2;
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(15, 73, 36, 52);
    add(jTextField6, gridBagConstraints);
    jLabel8.setText("Telephone ");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 6;
    gridBagConstraints.insets = new java.awt.Insets(24, 2, 0, 306);
    add(jLabel8, gridBagConstraints);
    jLabel9.setText("Mobile");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 6;
    gridBagConstraints.insets = new java.awt.Insets(24, 327, 0, 3);
    add(jLabel9, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 6;
    gridBagConstraints.gridhei ght = 2;
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(24, 125, 36, 112);
    add(jTextField7, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 6;
    gridBagConstraints.gridwid th = 3;
    gridBagConstraints.gridhei ght = 2;
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(24, 73, 36, 52);
    add(jTextField8, gridBagConstraints);
    jLabel10.setText("  E-Mail");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 7;
    gridBagConstraints.insets = new java.awt.Insets(24, 0, 0, 327);
    add(jLabel10, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 7;
    gridBagConstraints.gridhei ght = 2;
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(24, 125, 41, 112);
    add(jTextField9, gridBagConstraints);
    jLabel11.setText("*Age");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 7;
    gridBagConstraints.insets = new java.awt.Insets(24, 325, 0, 15);
    add(jLabel11, gridBagConstraints);
    Age.setBackground(new java.awt.Color(255, 255, 255));
    Age.setModel(new javax.swing.DefaultComboBo xModel(new String[] { "Select Age", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31", "32", "33", "34", "35", "36", "37", "38", "39", "40", "41", "42", "43", "44", "45", "46", "47", "48", "49", "50", "51", "52", "53", "54", "55", "56", "57", "58", "59", "60", "61", "62", "63", "64", "65", "66", "67", "68", "69", "70" }));
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 7;
    gridBagConstraints.gridwid th = 2;
    gridBagConstraints.gridhei ght = 2;
    gridBagConstraints.ipadx = 21;
    gridBagConstraints.insets = new java.awt.Insets(24, 73, 36, 10);
    add(Age, gridBagConstraints);
    jLabel12.setText("Address 2");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 4;
    gridBagConstraints.gridwid th = 2;
    gridBagConstraints.insets = new java.awt.Insets(24, 327, 0, 105);
    add(jLabel12, gridBagConstraints);
    jLabel13.setFont(new java.awt.Font("Courier New", 1, 18));
    jLabel13.setForeground(new java.awt.Color(255, 51, 51));
    jLabel13.setText("Personal Details");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 1;
    gridBagConstraints.ipadx = 4;
    gridBagConstraints.insets = new java.awt.Insets(60, 5, 0, 182);
    add(jLabel13, gridBagConstraints);
    jLabel14.setFont(new java.awt.Font("Courier New", 1, 18));
    jLabel14.setForeground(new java.awt.Color(255, 51, 51));
    jLabel14.setText("Employme nt ");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 8;
    gridBagConstraints.ipadx = 79;
    gridBagConstraints.insets = new java.awt.Insets(24, 5, 0, 162);
    add(jLabel14, gridBagConstraints);
    jLabel15.setText("Occupati on");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 9;
    gridBagConstraints.insets = new java.awt.Insets(9, 2, 4, 300);
    add(jLabel15, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 9;
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(9, 125, 0, 112);
    add(jTextField10, gridBagConstraints);
    jLabel16.setText("*Job Held");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 9;
    gridBagConstraints.gridwid th = 2;
    gridBagConstraints.insets = new java.awt.Insets(9, 325, 4, 111);
    add(jLabel16, gridBagConstraints);
    JobHeld.setBackground(new java.awt.Color(255, 255, 255));
    JobHeld.setModel(new javax.swing.DefaultComboBo xModel(new String[] { "Years", "1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31", "32", "33", "34", "35", "36", "37", "38", "39", "40" }));
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 15;
    gridBagConstraints.gridwid th = 2;
    gridBagConstraints.gridhei ght = 2;
    gridBagConstraints.insets = new java.awt.Insets(9, 73, 39, 59);
    add(JobHeld, gridBagConstraints);
    jLabel17.setText("*Salary" );
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 10;
    gridBagConstraints.insets = new java.awt.Insets(20, 0, 0, 326);
    add(jLabel17, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 10;
    gridBagConstraints.gridhei ght = 2;
    gridBagConstraints.ipadx = 116;
    gridBagConstraints.insets = new java.awt.Insets(20, 137, 40, 110);
    add(Salary, gridBagConstraints);
    jLabel19.setText("Employer s Name");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 11;
    gridBagConstraints.ipady = 4;
    gridBagConstraints.insets = new java.awt.Insets(24, 2, 0, 269);
    add(jLabel19, gridBagConstraints);
    jLabel20.setText("Address" );
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 12;
    gridBagConstraints.insets = new java.awt.Insets(20, 2, 0, 317);
    add(jLabel20, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 12;
    gridBagConstraints.gridhei ght = 2;
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(20, 125, 36, 112);
    add(jTextField12, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 11;
    gridBagConstraints.gridwid th = 4;
    gridBagConstraints.ipadx = 436;
    gridBagConstraints.insets = new java.awt.Insets(24, 125, 0, 57);
    add(jTextField13, gridBagConstraints);
    jLabel21.setText("Town/Cit y");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 12;
    gridBagConstraints.gridwid th = 2;
    gridBagConstraints.insets = new java.awt.Insets(20, 327, 0, 108);
    add(jLabel21, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 12;
    gridBagConstraints.gridwid th = 3;
    gridBagConstraints.gridhei ght = 2;
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(20, 73, 36, 52);
    add(jTextField14, gridBagConstraints);
    jLabel22.setText("Postcode ");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 13;
    gridBagConstraints.insets = new java.awt.Insets(24, 2, 0, 311);
    add(jLabel22, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 13;
    gridBagConstraints.gridhei ght = 2;
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(24, 125, 41, 112);
    add(jTextField15, gridBagConstraints);
    jLabel23.setText("Telephon e");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 13;
    gridBagConstraints.gridwid th = 2;
    gridBagConstraints.insets = new java.awt.Insets(24, 327, 0, 104);
    add(jLabel23, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 13;
    gridBagConstraints.gridwid th = 3;
    gridBagConstraints.gridhei ght = 2;
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(24, 73, 41, 52);
    add(jTextField16, gridBagConstraints);
    jLabel24.setFont(new java.awt.Font("Courier New", 1, 18));
    jLabel24.setForeground(new java.awt.Color(255, 51, 51));
    jLabel24.setText("Loan Details");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 14;
    gridBagConstraints.insets = new java.awt.Insets(24, 5, 0, 230);
    add(jLabel24, gridBagConstraints);
    jLabel25.setText("*Amount Required");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 15;
    gridBagConstraints.insets = new java.awt.Insets(9, 0, 0, 264);
    add(jLabel25, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 15;
    gridBagConstraints.gridhei ght = 2;
    gridBagConstraints.ipadx = 116;
    gridBagConstraints.insets = new java.awt.Insets(9, 137, 44, 110);
    add(Loan, gridBagConstraints);
Â
    jLabel27.setText("*Period" );
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 15;
    gridBagConstraints.insets = new java.awt.Insets(9, 325, 0, 0);
    add(jLabel27, gridBagConstraints);
    Period.setBackground(new java.awt.Color(255, 255, 255));
    Period.setModel(new javax.swing.DefaultComboBo xModel(new String[] { "Years", "1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15" }));
    Period.addActionListener(n ew java.awt.event.ActionListe ner() {
      public void actionPerformed(java.awt.e vent.Actio nEvent evt) {
        PeriodActionPerformed(evt) ;
      }
    });
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 9;
    gridBagConstraints.gridwid th = 2;
    gridBagConstraints.insets = new java.awt.Insets(4, 73, 0, 59);
    add(Period, gridBagConstraints);
    jLabel28.setText("Have you had a loan declined in the past?");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 16;
    gridBagConstraints.insets = new java.awt.Insets(24, 5, 8, 130);
    add(jLabel28, gridBagConstraints);
    jCheckBox1.setBackground(n ew java.awt.Color(255, 255, 255));
    jCheckBox1.setText("Yes");
    jCheckBox1.addActionListen er(new java.awt.event.ActionListe ner() {
      public void actionPerformed(java.awt.e vent.Actio nEvent evt) {
        jCheckBox1ActionPerformed( evt);
      }
    });
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 16;
    gridBagConstraints.ipadx = 4;
    gridBagConstraints.insets = new java.awt.Insets(24, 73, 0, 0);
    add(jCheckBox1, gridBagConstraints);
    jCheckBox2.setBackground(n ew java.awt.Color(255, 255, 255));
    jCheckBox2.setText("No");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 3;
    gridBagConstraints.gridy = 16;
    gridBagConstraints.insets = new java.awt.Insets(24, 30, 0, 0);
    add(jCheckBox2, gridBagConstraints);
    jLabel29.setText("Have you been clear of CCJs and Arrears in the last 12 months?");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 17;
    gridBagConstraints.insets = new java.awt.Insets(6, 5, 8, 2);
    add(jLabel29, gridBagConstraints);
    jCheckBox3.setBackground(n ew java.awt.Color(255, 255, 255));
    jCheckBox3.setText("Yes");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 17;
    gridBagConstraints.ipadx = 4;
    gridBagConstraints.insets = new java.awt.Insets(6, 73, 0, 0);
    add(jCheckBox3, gridBagConstraints);
    jCheckBox4.setBackground(n ew java.awt.Color(255, 255, 255));
    jCheckBox4.setText("No");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 3;
    gridBagConstraints.gridy = 17;
    gridBagConstraints.insets = new java.awt.Insets(6, 30, 0, 0);
    add(jCheckBox4, gridBagConstraints);
    jLabel30.setFont(new java.awt.Font("Courier New", 1, 18));
    jLabel30.setForeground(new java.awt.Color(255, 51, 51));
    jLabel30.setText("Staff");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 18;
    gridBagConstraints.ipadx = 35;
    gridBagConstraints.insets = new java.awt.Insets(16, 2, 0, 275);
    add(jLabel30, gridBagConstraints);
    jLabel31.setText("*Credit Rating");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 19;
    gridBagConstraints.insets = new java.awt.Insets(9, 0, 25, 289);
    add(jLabel31, gridBagConstraints);
    CreditRating.setBackground (new java.awt.Color(255, 255, 255));
    CreditRating.setModel(new javax.swing.DefaultComboBo xModel(new String[] { "Select", "1", "2", "3", "4", "5", "6", "7", "8", "9", "10" }));
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 19;
    gridBagConstraints.ipady = -5;
    gridBagConstraints.insets = new java.awt.Insets(9, 137, 21, 166);
    add(CreditRating, gridBagConstraints);
    jButton2.setBackground(new java.awt.Color(241, 249, 201));
    jButton2.setText("Submit") ;
    jButton2.addActionListener (new java.awt.event.ActionListe ner() {
      public void actionPerformed(java.awt.e vent.Actio nEvent evt) {
        jButton2ActionPerformed(ev t);
      }
    });
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 3;
    gridBagConstraints.gridy = 19;
    gridBagConstraints.gridwid th = 2;
    gridBagConstraints.ipadx = 26;
    gridBagConstraints.insets = new java.awt.Insets(24, 8, 0, 24);
    add(jButton2, gridBagConstraints);
          Â
   Â
    jLabel32.setFont(new java.awt.Font("Arial Black", 1, 24));
    jLabel32.setIcon(new javax.swing.ImageIcon("Z:\ \fyp\\Unti tled-6 copy.jpg"));
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 1;
    gridBagConstraints.gridwid th = 3;
    gridBagConstraints.ipady = -130;
    gridBagConstraints.insets = new java.awt.Insets(0, 95, 1, 65);
    add(jLabel32, gridBagConstraints);
    jLabel33.setFont(new java.awt.Font("Arial", 1, 12));
    jLabel33.setForeground(new java.awt.Color(255, 51, 51));
    jLabel33.setText("* Denotes compulsory feilds");
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 19;
    gridBagConstraints.gridhei ght = 2;
    gridBagConstraints.insets = new java.awt.Insets(39, 5, 19, 203);
    add(jLabel33, gridBagConstraints);
    jButton3.setBackground(new java.awt.Color(241, 249, 201));
    jButton3.setText("Save");
    jButton3.addActionListener (new java.awt.event.ActionListe ner() {
      public void actionPerformed(java.awt.e vent.Actio nEvent evt) {
        jButton3ActionPerformed(ev t);
      }
    });
   Â
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 19;
    gridBagConstraints.ipadx = 36;
    gridBagConstraints.insets = new java.awt.Insets(24, 21, 0, 2);
    add(jButton3, gridBagConstraints);
    jButton4.setBackground(new java.awt.Color(241, 249, 201));
    jButton4.setText("Quit");
    jButton4.addActionListener (new java.awt.event.ActionListe ner() {
      public void actionPerformed(java.awt.e vent.Actio nEvent evt) {
        jButton4ActionPerformed(ev t);
      }
    });
    gridBagConstraints = new java.awt.GridBagConstraint s();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 19;
    gridBagConstraints.gridwid th = 2;
    gridBagConstraints.ipadx = 43;
    gridBagConstraints.insets = new java.awt.Insets(24, 278, 0, 112);
    add(jButton4, gridBagConstraints);
  }
  private void jButton4ActionPerformed(ja va.awt.eve nt.ActionE vent evt) {
                Â
                 System.exit( 0 );
                    // Add your handling code here:
  }
  private void jTextField6ActionPerformed (java.awt. event.Acti onEvent evt) {
    // Add your handling code here:
  }
  private void PeriodActionPerformed(java .awt.event .ActionEve nt evt) {
    // Add your handling code here:
  }
  private void jButton2ActionPerformed(ja va.awt.eve nt.ActionE vent evt) {
       Â
                      JOptionPane.showMessageDia log (null,"Thankyou, Your Details Have Been Successfully Saved.","",JOptionPane.INF ORMATION_M ESSAGE);
                      PrintWriter outputStream = null;
                 try
                      {
                      // Gets the booking number from the textfield to use as the file name
                      String a = jTextField6.getText();
                      outputStream = new PrintWriter(new FileOutputStream(" " + a +".csv"));
                      outputStream.println("Age, Loan, Period,  Salary, JobHeld, CreditRating");
                      outputStream.println(" " + Age.getSelectedItem() + "," +" " +
                      Loan.getText() + ","+  " " +
                      Period.getSelectedItem() + "," + " "+
                      Salary.getText() + "," + " "+
                      JobHeld.getSelectedItem() + "," + " " +
                      CreditRating.getSelectedIt em());
                Â
                     Â
                      outputStream.close();
                      System.out.println("... written to output file");
                      }
                      catch(IOException ioException)
                      {
                      System.out.println("Error" );
                      }
                 }
    // Add your handling code here:
 Â
      private void jButton3ActionPerformed(ja va.awt.eve nt.ActionE vent evt) {
          Â
           String title = (String)jComboBox1.getSele ctedItem() ;
           surname = jTextField1.getText();
           forename = jTextField6.getText();
           address1 = jTextField2.getText();
           address2 =      jTextField3.getText();
           city =      jTextField4.getText();
           postcode = jTextField5.getText();
           homeTel = jTextField7.getText();
           mobTel = jTextField8.getText();
           e_mail = jTextField9.getText();
           String age = (String)Age.getSelectedIte m();
           occupation = jTextField3.getText();
           salary = Salary.getText();
           String jobHeld = (String)JobHeld.getSelecte dItem();
           empName = jTextField12.getText();
           empAdd1      = jTextField13.getText();
           empCity = jTextField14.getText();
           empPostcode = jTextField15.getText();
           empTelephone      = jTextField16.getText();
           amount = Loan.getText();
           String period= (String)Period.getSelected Item();
           String creditRating = (String)CreditRating.getSe lectedItem ();
          Â
           String addDataSql;
    addDataSql = "INSERT INTO Customer (Title, Forename, Surname, Address1, Address2, City, Postcode, HomeTel, MobTel, E-Mail, Age, Occupation, Salary, JobHeld, EmpName, EmpAdd1, EmpCity, EmpPostcode, EmpTelephone, Amount, Period, CreditRating, Decision ) VALUES ('"+title+"','"+forename+" ', '"+surname+"', '"+address1+"', '"+address2+"', '"+city+"',"+postcode+"', '"+homeTel+"', '"+mobTel+"', '"+e_mail+"', '"+age+"', '"+occupation+"', '"+salary+"', '"+jobHeld+"', '"+empName+"', '"+empAdd1+"', '"+empCity+"', '"+empPostcode+"', '"+empTelephone+"', '"+amount+"', '"+period+"', '"+creditRating+"', ' " +"  "+  "')";
            addData(addDataSql);
      Â
                                                        Â
                      removeAll();
                      add(new riskAnalyser());
                      validate();
      }
  Â
     Â
 Â
  private void jTextField5ActionPerformed (java.awt. event.Acti onEvent evt) {
    // Add your handling code here:
  }
  private void jComboBox1ActionPerformed( java.awt.e vent.Actio nEvent evt) {
    // Add your handling code here:
  }
  private void jCheckBox1ActionPerformed( java.awt.e vent.Actio nEvent evt) {
    // Add your handling code here:
  }
 Â
 Â
 Â
  public void addData(String sql)
      {
     Â
           try
           {
                      stmt = connection.createStatement ();
                Â
                      System.out.println(sql);
                      Â
                       stmt.executeUpdate(sql);
                      System.out.println("Data Input Successful");
                      JOptionPane.showMessageDia log(null, "Customer Created Successfully");
                                       Â
                Â
           }
           catch(SQLException undex)
           {
                 System.out.println("Custom er Database Not Updated");
                 JOptionPane.showMessageDia log(null, "Customer NOT Created. \nThis may be because either an invalid entry was entered in one of the input text fields or you did not input data in all the text fields. Please try agian.");
           }
       }
      Â
public static void main(String[] args)
      {
      JFrame frame = new JFrame("Risk Analysis System");
      frame.addWindowListener(ne w WindowAdapter()
           {
        public void windowClosing(WindowEvent e)
                 {
                 System.exit(0);
                 }
           });
      frame.getContentPane().add (new riskAnalyser(), BorderLayout.CENTER);
      frame.setSize(800, 850);
      frame.setVisible(true);
      }
}
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.io.*;
import java.text.*;
import java.util.*;
import java.sql.*;
import java.io.PrintStream;
import java.io.FileOutputStream;
import java.io.IOException;
public class riskAnalyser extends JPanel
{
      // Variables declaration - do not modify
  private Connection connection;
       private Statement stmt;
      private String url="jdbc:odbc:fuzzy";
      private String username="zhussain";
      private String password="brutus";
     Â
//Class.forName("sun.jdbc.
//String URL = "jdbc:odbc:Driver={Microso
//DBConn = DriverManager.getConnectio
  private javax.swing.JButton jButton2;
  private javax.swing.JButton jButton3;
  private javax.swing.JButton jButton4;
  private javax.swing.JCheckBox jCheckBox1;
  private javax.swing.JCheckBox jCheckBox2;
  private javax.swing.JCheckBox jCheckBox3;
  private javax.swing.JCheckBox jCheckBox4;
  private javax.swing.JComboBox jComboBox1;
  private javax.swing.JComboBox Age;
  private javax.swing.JComboBox JobHeld;
  private javax.swing.JComboBox Period;
  private javax.swing.JComboBox CreditRating;
  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 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.JTextField jTextField1;
  private javax.swing.JTextField jTextField10;
  private javax.swing.JTextField Salary;
  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 Loan;
  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;
 Â
  private String forename, surname, address1, address2, city, postcode, homeTel, mobTel, e_mail, occupation, salary, empName, empAdd1, empCity, empPostcode, empTelephone, amount;
  // End of variables declaration
 Â
  /** Creates new form JPanel */
  public riskAnalyser()
 Â
Â
 {
    java.awt.GridBagConstraint
try
           {
                  Class.forName("sun.jdbc.od
           }
           catch (Exception e)
           {
                  System.out.println("Failed
                  return;
           }
           // get a connection
           try
           {
                  connection = DriverManager.getConnectio
                  System.out.println("Succes
           }
          Â
           catch (Exception e)
           {
                  System.err.println("proble
           }
   Â
    jLabel2 = new javax.swing.JLabel();
    jLabel1 = new javax.swing.JLabel();
    jComboBox1 = new javax.swing.JComboBox();
    jLabel3 = new javax.swing.JLabel();
    jTextField1 = new javax.swing.JTextField();
    jLabel4 = new javax.swing.JLabel();
    jTextField2 = new javax.swing.JTextField();
    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();
    jLabel9 = new javax.swing.JLabel();
    jTextField7 = new javax.swing.JTextField();
    jTextField8 = new javax.swing.JTextField();
    jLabel10 = new javax.swing.JLabel();
    jTextField9 = new javax.swing.JTextField();
    jLabel11 = new javax.swing.JLabel();
    Age = new javax.swing.JComboBox();
    jLabel12 = new javax.swing.JLabel();
    jLabel13 = new javax.swing.JLabel();
    jLabel14 = new javax.swing.JLabel();
    jLabel15 = new javax.swing.JLabel();
    jTextField10 = new javax.swing.JTextField();
    jLabel16 = new javax.swing.JLabel();
    JobHeld = new javax.swing.JComboBox();
    jLabel17 = new javax.swing.JLabel();
    Salary = 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();
    jLabel21 = new javax.swing.JLabel();
    jTextField14 = new javax.swing.JTextField();
    jLabel22 = new javax.swing.JLabel();
    jTextField15 = new javax.swing.JTextField();
    jLabel23 = new javax.swing.JLabel();
    jTextField16 = new javax.swing.JTextField();
    jLabel24 = new javax.swing.JLabel();
    jLabel25 = new javax.swing.JLabel();
    Loan = new javax.swing.JTextField();
    jLabel26 = new javax.swing.JLabel();
    jLabel27 = new javax.swing.JLabel();
    Period = new javax.swing.JComboBox();
    jLabel28 = new javax.swing.JLabel();
    jCheckBox1 = new javax.swing.JCheckBox();
    jCheckBox2 = new javax.swing.JCheckBox();
    jLabel29 = new javax.swing.JLabel();
    jCheckBox3 = new javax.swing.JCheckBox();
    jCheckBox4 = new javax.swing.JCheckBox();
    jLabel30 = new javax.swing.JLabel();
    jLabel31 = new javax.swing.JLabel();
    CreditRating = new javax.swing.JComboBox();
    jButton2 = new javax.swing.JButton();
    jLabel32 = new javax.swing.JLabel();
    jLabel33 = new javax.swing.JLabel();
    jButton3 = new javax.swing.JButton();
    jButton4 = new javax.swing.JButton();
    setLayout(new java.awt.GridBagLayout());
   Â
    setBackground(new java.awt.Color(194, 215, 240));
    setBorder(new javax.swing.border.EmptyBo
    jLabel2.setText("Title");
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 2;
    gridBagConstraints.insets = new java.awt.Insets(9, 0, 9, 343);
    add(jLabel2, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 0;
    gridBagConstraints.gridy = 0;
    add(jLabel1, gridBagConstraints);
    jComboBox1.setBackground(n
    jComboBox1.setModel(new javax.swing.DefaultComboBo
    jComboBox1.addActionListen
      public void actionPerformed(java.awt.e
        jComboBox1ActionPerformed(
      }
    });
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 2;
    gridBagConstraints.insets = new java.awt.Insets(9, 125, 0, 187);
    add(jComboBox1, gridBagConstraints);
    jLabel3.setText("*Surname"
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 3;
    gridBagConstraints.insets = new java.awt.Insets(15, 0, 0, 310);
    add(jLabel3, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 3;
    gridBagConstraints.gridhei
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(15, 125, 36, 112);
    add(jTextField1, gridBagConstraints);
    jLabel4.setText("Address 1");
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 4;
    gridBagConstraints.insets = new java.awt.Insets(24, 2, 0, 307);
    add(jLabel4, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 4;
    gridBagConstraints.gridhei
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(24, 125, 36, 112);
    add(jTextField2, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 4;
    gridBagConstraints.gridwid
    gridBagConstraints.gridhei
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(24, 73, 36, 52);
    add(jTextField3, gridBagConstraints);
    jLabel5.setText("Town/City
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 5;
    gridBagConstraints.insets = new java.awt.Insets(24, 2, 0, 310);
    add(jLabel5, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 5;
    gridBagConstraints.gridhei
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(24, 125, 36, 112);
    add(jTextField4, gridBagConstraints);
    jLabel6.setText("*Postcode
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 5;
    gridBagConstraints.gridwid
    gridBagConstraints.insets = new java.awt.Insets(24, 325, 0, 106);
    add(jLabel6, gridBagConstraints);
    jTextField5.addActionListe
      public void actionPerformed(java.awt.e
        jTextField5ActionPerformed
      }
    });
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 5;
    gridBagConstraints.gridwid
    gridBagConstraints.gridhei
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(24, 73, 36, 52);
    add(jTextField5, gridBagConstraints);
    jLabel7.setText("*Forename
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 3;
    gridBagConstraints.gridwid
    gridBagConstraints.insets = new java.awt.Insets(15, 325, 0, 103);
    add(jLabel7, gridBagConstraints);
    jTextField6.addActionListe
      public void actionPerformed(java.awt.e
        jTextField6ActionPerformed
      }
    });
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 3;
    gridBagConstraints.gridwid
    gridBagConstraints.gridhei
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(15, 73, 36, 52);
    add(jTextField6, gridBagConstraints);
    jLabel8.setText("Telephone
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 6;
    gridBagConstraints.insets = new java.awt.Insets(24, 2, 0, 306);
    add(jLabel8, gridBagConstraints);
    jLabel9.setText("Mobile");
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 6;
    gridBagConstraints.insets = new java.awt.Insets(24, 327, 0, 3);
    add(jLabel9, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 6;
    gridBagConstraints.gridhei
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(24, 125, 36, 112);
    add(jTextField7, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 6;
    gridBagConstraints.gridwid
    gridBagConstraints.gridhei
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(24, 73, 36, 52);
    add(jTextField8, gridBagConstraints);
    jLabel10.setText("  E-Mail");
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 7;
    gridBagConstraints.insets = new java.awt.Insets(24, 0, 0, 327);
    add(jLabel10, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 7;
    gridBagConstraints.gridhei
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(24, 125, 41, 112);
    add(jTextField9, gridBagConstraints);
    jLabel11.setText("*Age");
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 7;
    gridBagConstraints.insets = new java.awt.Insets(24, 325, 0, 15);
    add(jLabel11, gridBagConstraints);
    Age.setBackground(new java.awt.Color(255, 255, 255));
    Age.setModel(new javax.swing.DefaultComboBo
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 7;
    gridBagConstraints.gridwid
    gridBagConstraints.gridhei
    gridBagConstraints.ipadx = 21;
    gridBagConstraints.insets = new java.awt.Insets(24, 73, 36, 10);
    add(Age, gridBagConstraints);
    jLabel12.setText("Address 2");
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 4;
    gridBagConstraints.gridwid
    gridBagConstraints.insets = new java.awt.Insets(24, 327, 0, 105);
    add(jLabel12, gridBagConstraints);
    jLabel13.setFont(new java.awt.Font("Courier New", 1, 18));
    jLabel13.setForeground(new
    jLabel13.setText("Personal
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 1;
    gridBagConstraints.ipadx = 4;
    gridBagConstraints.insets = new java.awt.Insets(60, 5, 0, 182);
    add(jLabel13, gridBagConstraints);
    jLabel14.setFont(new java.awt.Font("Courier New", 1, 18));
    jLabel14.setForeground(new
    jLabel14.setText("Employme
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 8;
    gridBagConstraints.ipadx = 79;
    gridBagConstraints.insets = new java.awt.Insets(24, 5, 0, 162);
    add(jLabel14, gridBagConstraints);
    jLabel15.setText("Occupati
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 9;
    gridBagConstraints.insets = new java.awt.Insets(9, 2, 4, 300);
    add(jLabel15, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 9;
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(9, 125, 0, 112);
    add(jTextField10, gridBagConstraints);
    jLabel16.setText("*Job Held");
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 9;
    gridBagConstraints.gridwid
    gridBagConstraints.insets = new java.awt.Insets(9, 325, 4, 111);
    add(jLabel16, gridBagConstraints);
    JobHeld.setBackground(new java.awt.Color(255, 255, 255));
    JobHeld.setModel(new javax.swing.DefaultComboBo
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 15;
    gridBagConstraints.gridwid
    gridBagConstraints.gridhei
    gridBagConstraints.insets = new java.awt.Insets(9, 73, 39, 59);
    add(JobHeld, gridBagConstraints);
    jLabel17.setText("*Salary"
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 10;
    gridBagConstraints.insets = new java.awt.Insets(20, 0, 0, 326);
    add(jLabel17, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 10;
    gridBagConstraints.gridhei
    gridBagConstraints.ipadx = 116;
    gridBagConstraints.insets = new java.awt.Insets(20, 137, 40, 110);
    add(Salary, gridBagConstraints);
    jLabel19.setText("Employer
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 11;
    gridBagConstraints.ipady = 4;
    gridBagConstraints.insets = new java.awt.Insets(24, 2, 0, 269);
    add(jLabel19, gridBagConstraints);
    jLabel20.setText("Address"
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 12;
    gridBagConstraints.insets = new java.awt.Insets(20, 2, 0, 317);
    add(jLabel20, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 12;
    gridBagConstraints.gridhei
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(20, 125, 36, 112);
    add(jTextField12, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 11;
    gridBagConstraints.gridwid
    gridBagConstraints.ipadx = 436;
    gridBagConstraints.insets = new java.awt.Insets(24, 125, 0, 57);
    add(jTextField13, gridBagConstraints);
    jLabel21.setText("Town/Cit
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 12;
    gridBagConstraints.gridwid
    gridBagConstraints.insets = new java.awt.Insets(20, 327, 0, 108);
    add(jLabel21, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 12;
    gridBagConstraints.gridwid
    gridBagConstraints.gridhei
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(20, 73, 36, 52);
    add(jTextField14, gridBagConstraints);
    jLabel22.setText("Postcode
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 13;
    gridBagConstraints.insets = new java.awt.Insets(24, 2, 0, 311);
    add(jLabel22, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 13;
    gridBagConstraints.gridhei
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(24, 125, 41, 112);
    add(jTextField15, gridBagConstraints);
    jLabel23.setText("Telephon
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 13;
    gridBagConstraints.gridwid
    gridBagConstraints.insets = new java.awt.Insets(24, 327, 0, 104);
    add(jLabel23, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 13;
    gridBagConstraints.gridwid
    gridBagConstraints.gridhei
    gridBagConstraints.ipadx = 126;
    gridBagConstraints.insets = new java.awt.Insets(24, 73, 41, 52);
    add(jTextField16, gridBagConstraints);
    jLabel24.setFont(new java.awt.Font("Courier New", 1, 18));
    jLabel24.setForeground(new
    jLabel24.setText("Loan Details");
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 14;
    gridBagConstraints.insets = new java.awt.Insets(24, 5, 0, 230);
    add(jLabel24, gridBagConstraints);
    jLabel25.setText("*Amount Required");
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 15;
    gridBagConstraints.insets = new java.awt.Insets(9, 0, 0, 264);
    add(jLabel25, gridBagConstraints);
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 15;
    gridBagConstraints.gridhei
    gridBagConstraints.ipadx = 116;
    gridBagConstraints.insets = new java.awt.Insets(9, 137, 44, 110);
    add(Loan, gridBagConstraints);
Â
    jLabel27.setText("*Period"
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 15;
    gridBagConstraints.insets = new java.awt.Insets(9, 325, 0, 0);
    add(jLabel27, gridBagConstraints);
    Period.setBackground(new java.awt.Color(255, 255, 255));
    Period.setModel(new javax.swing.DefaultComboBo
    Period.addActionListener(n
      public void actionPerformed(java.awt.e
        PeriodActionPerformed(evt)
      }
    });
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 9;
    gridBagConstraints.gridwid
    gridBagConstraints.insets = new java.awt.Insets(4, 73, 0, 59);
    add(Period, gridBagConstraints);
    jLabel28.setText("Have you had a loan declined in the past?");
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 16;
    gridBagConstraints.insets = new java.awt.Insets(24, 5, 8, 130);
    add(jLabel28, gridBagConstraints);
    jCheckBox1.setBackground(n
    jCheckBox1.setText("Yes");
    jCheckBox1.addActionListen
      public void actionPerformed(java.awt.e
        jCheckBox1ActionPerformed(
      }
    });
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 16;
    gridBagConstraints.ipadx = 4;
    gridBagConstraints.insets = new java.awt.Insets(24, 73, 0, 0);
    add(jCheckBox1, gridBagConstraints);
    jCheckBox2.setBackground(n
    jCheckBox2.setText("No");
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 3;
    gridBagConstraints.gridy = 16;
    gridBagConstraints.insets = new java.awt.Insets(24, 30, 0, 0);
    add(jCheckBox2, gridBagConstraints);
    jLabel29.setText("Have you been clear of CCJs and Arrears in the last 12 months?");
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 17;
    gridBagConstraints.insets = new java.awt.Insets(6, 5, 8, 2);
    add(jLabel29, gridBagConstraints);
    jCheckBox3.setBackground(n
    jCheckBox3.setText("Yes");
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 17;
    gridBagConstraints.ipadx = 4;
    gridBagConstraints.insets = new java.awt.Insets(6, 73, 0, 0);
    add(jCheckBox3, gridBagConstraints);
    jCheckBox4.setBackground(n
    jCheckBox4.setText("No");
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 3;
    gridBagConstraints.gridy = 17;
    gridBagConstraints.insets = new java.awt.Insets(6, 30, 0, 0);
    add(jCheckBox4, gridBagConstraints);
    jLabel30.setFont(new java.awt.Font("Courier New", 1, 18));
    jLabel30.setForeground(new
    jLabel30.setText("Staff");
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 18;
    gridBagConstraints.ipadx = 35;
    gridBagConstraints.insets = new java.awt.Insets(16, 2, 0, 275);
    add(jLabel30, gridBagConstraints);
    jLabel31.setText("*Credit Rating");
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 19;
    gridBagConstraints.insets = new java.awt.Insets(9, 0, 25, 289);
    add(jLabel31, gridBagConstraints);
    CreditRating.setBackground
    CreditRating.setModel(new javax.swing.DefaultComboBo
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 19;
    gridBagConstraints.ipady = -5;
    gridBagConstraints.insets = new java.awt.Insets(9, 137, 21, 166);
    add(CreditRating, gridBagConstraints);
    jButton2.setBackground(new
    jButton2.setText("Submit")
    jButton2.addActionListener
      public void actionPerformed(java.awt.e
        jButton2ActionPerformed(ev
      }
    });
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 3;
    gridBagConstraints.gridy = 19;
    gridBagConstraints.gridwid
    gridBagConstraints.ipadx = 26;
    gridBagConstraints.insets = new java.awt.Insets(24, 8, 0, 24);
    add(jButton2, gridBagConstraints);
          Â
   Â
    jLabel32.setFont(new java.awt.Font("Arial Black", 1, 24));
    jLabel32.setIcon(new javax.swing.ImageIcon("Z:\
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 1;
    gridBagConstraints.gridwid
    gridBagConstraints.ipady = -130;
    gridBagConstraints.insets = new java.awt.Insets(0, 95, 1, 65);
    add(jLabel32, gridBagConstraints);
    jLabel33.setFont(new java.awt.Font("Arial", 1, 12));
    jLabel33.setForeground(new
    jLabel33.setText("* Denotes compulsory feilds");
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 19;
    gridBagConstraints.gridhei
    gridBagConstraints.insets = new java.awt.Insets(39, 5, 19, 203);
    add(jLabel33, gridBagConstraints);
    jButton3.setBackground(new
    jButton3.setText("Save");
    jButton3.addActionListener
      public void actionPerformed(java.awt.e
        jButton3ActionPerformed(ev
      }
    });
   Â
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 19;
    gridBagConstraints.ipadx = 36;
    gridBagConstraints.insets = new java.awt.Insets(24, 21, 0, 2);
    add(jButton3, gridBagConstraints);
    jButton4.setBackground(new
    jButton4.setText("Quit");
    jButton4.addActionListener
      public void actionPerformed(java.awt.e
        jButton4ActionPerformed(ev
      }
    });
    gridBagConstraints = new java.awt.GridBagConstraint
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 19;
    gridBagConstraints.gridwid
    gridBagConstraints.ipadx = 43;
    gridBagConstraints.insets = new java.awt.Insets(24, 278, 0, 112);
    add(jButton4, gridBagConstraints);
  }
  private void jButton4ActionPerformed(ja
                Â
                 System.exit( 0 );
                    // Add your handling code here:
  }
  private void jTextField6ActionPerformed
    // Add your handling code here:
  }
  private void PeriodActionPerformed(java
    // Add your handling code here:
  }
  private void jButton2ActionPerformed(ja
       Â
                      JOptionPane.showMessageDia
                      PrintWriter outputStream = null;
                 try
                      {
                      // Gets the booking number from the textfield to use as the file name
                      String a = jTextField6.getText();
                      outputStream = new PrintWriter(new FileOutputStream(" " + a +".csv"));
                      outputStream.println("Age,
                      outputStream.println(" " + Age.getSelectedItem() + "," +" " +
                      Loan.getText() + ","+  " " +
                      Period.getSelectedItem() + "," + " "+
                      Salary.getText() + "," + " "+
                      JobHeld.getSelectedItem() + "," + " " +
                      CreditRating.getSelectedIt
                Â
                     Â
                      outputStream.close();
                      System.out.println("... written to output file");
                      }
                      catch(IOException ioException)
                      {
                      System.out.println("Error"
                      }
                 }
    // Add your handling code here:
 Â
      private void jButton3ActionPerformed(ja
          Â
           String title = (String)jComboBox1.getSele
           surname = jTextField1.getText();
           forename = jTextField6.getText();
           address1 = jTextField2.getText();
           address2 =      jTextField3.getText();
           city =      jTextField4.getText();
           postcode = jTextField5.getText();
           homeTel = jTextField7.getText();
           mobTel = jTextField8.getText();
           e_mail = jTextField9.getText();
           String age = (String)Age.getSelectedIte
           occupation = jTextField3.getText();
           salary = Salary.getText();
           String jobHeld = (String)JobHeld.getSelecte
           empName = jTextField12.getText();
           empAdd1      = jTextField13.getText();
           empCity = jTextField14.getText();
           empPostcode = jTextField15.getText();
           empTelephone      = jTextField16.getText();
           amount = Loan.getText();
           String period= (String)Period.getSelected
           String creditRating = (String)CreditRating.getSe
          Â
           String addDataSql;
    addDataSql = "INSERT INTO Customer (Title, Forename, Surname, Address1, Address2, City, Postcode, HomeTel, MobTel, E-Mail, Age, Occupation, Salary, JobHeld, EmpName, EmpAdd1, EmpCity, EmpPostcode, EmpTelephone, Amount, Period, CreditRating, Decision ) VALUES ('"+title+"','"+forename+"
            addData(addDataSql);
      Â
                                                        Â
                      removeAll();
                      add(new riskAnalyser());
                      validate();
      }
  Â
     Â
 Â
  private void jTextField5ActionPerformed
    // Add your handling code here:
  }
  private void jComboBox1ActionPerformed(
    // Add your handling code here:
  }
  private void jCheckBox1ActionPerformed(
    // Add your handling code here:
  }
 Â
 Â
 Â
  public void addData(String sql)
      {
     Â
           try
           {
                      stmt = connection.createStatement
                Â
                      System.out.println(sql);
                      Â
                       stmt.executeUpdate(sql);
                      System.out.println("Data Input Successful");
                      JOptionPane.showMessageDia
                                       Â
                Â
           }
           catch(SQLException undex)
           {
                 System.out.println("Custom
                 JOptionPane.showMessageDia
           }
       }
      Â
public static void main(String[] args)
      {
      JFrame frame = new JFrame("Risk Analysis System");
      frame.addWindowListener(ne
           {
        public void windowClosing(WindowEvent e)
                 {
                 System.exit(0);
                 }
           });
      frame.getContentPane().add
      frame.setSize(800, 850);
      frame.setVisible(true);
      }
}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Also - every driver does not allow you to insert using executeUpdate (). Try using execute () or using PreparedStatement.