Tab Problem!! PLZ HELP

[menwa ms]

hi,,,
i have this application that has a tab (box tab,voice tab , etc..), buttons , Jtable..
i also have an add button , whenever i click on the add button to add a user(this users info will be added to the JTable) but also a new tab(box) will be added , i don't want a new tab to be added to happen ,,
i don't know how to solve this error..
this is my code :

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.table.*;
import java.sql.*;
import java.io.*;
import javax.swing.JPanel;
import java.applet.*;
import sun.audio.*;
import java.net.*;
import java.text.*;
class UtilityMethods extends JFrame implements ActionListener
{
 // private boolean tabsVisible=false;
  private File fileName;
  private RandomAccessFile output;
  AudioStream voice;
  UtilityMethods utilities;
  Connection conn;
  Statement stat;
  String dsnName, userStatus;
  String appTable = "CUSTOMER";
  Container c = getContentPane();
   JTabbedPane tabs;
  JTable dataTable, addataTable;//,vdataTable;
  static String[][] tableData, adtableData;//,vtableData;
  JScrollPane scrollpane, adscrollpane,vscrollpane;
  JTextField id, name, address, phone, sex, dob, photo,audio;//,template;
  JTextArea comments;
  JButton search, update, clear, add, delete, close,audio1;//,faceBrowse,voiceBrowse;
  JPanel customerPanel, adminPanel,voicePanel;
  JPanel backPanel, inputPanel, middlePanel, buttonPanel1, buttonPanel2, photoHolder;
  JTextField adname, adusername, adpassword;
  JPanel adbackPanel, adinputPanel, admiddlePanel, adbuttonPanel1, adbuttonPanel2, radioPanel;
  JButton adsearch, adupdate, adclear, adadd, addelete, adclose;
  JRadioButton userStat, adminStat, cleared;
  ButtonGroup statusGroup;
  /*JTextField vid,vname,vaddress,vphone,vsex,vdob,vtemplate,vvoice;
  JButton vsearch,vupdate,vclear,vadd,vdelete,vclose,vplay,vstop;
  JPanel vbackPanel, vinputPanel, vmiddlePanel, vbuttonPanel1, vbuttonPanel2;*/
  //===================================================================================================
  public UtilityMethods()
  {
    makeGUI();
  }

  //Create the GUI:
  void makeGUI()
  {
    c.setLayout(new BorderLayout());
    tabs = new JTabbedPane();
    customerPanel = new JPanel(new BorderLayout());
    adminPanel = new JPanel(new BorderLayout());
    voicePanel= new JPanel(new BorderLayout());
    //1. Construct customers tab:
      //The data input section:
    inputPanel = new JPanel(new GridLayout(4, 4));
    id = new JTextField(20);
    name = new JTextField(20);
    address = new JTextField(20);
    phone = new JTextField(20);
    sex = new JTextField(20);
    dob = new JTextField(20);
    photo = new JTextField(20);
    audio   = new JTextField(20);
    //template   = new JTextField(20);
    inputPanel.add(new JLabel("CPR", JLabel.CENTER));
    inputPanel.add(id);
    inputPanel.add(new JLabel("Name", JLabel.CENTER));
    inputPanel.add(name);
    inputPanel.add(new JLabel("Address", JLabel.CENTER));
    inputPanel.add(address);
    inputPanel.add(new JLabel("Phone", JLabel.CENTER));
    inputPanel.add(phone);
    inputPanel.add(new JLabel("Sex", JLabel.CENTER));
    inputPanel.add(sex);
    inputPanel.add(new JLabel("Date Of Birth", JLabel.CENTER));
    inputPanel.add(dob);
    inputPanel.add(new JLabel("Customer Photo ", JLabel.CENTER));
    inputPanel.add(photo);
    inputPanel.add(new JLabel("Voice ", JLabel.CENTER));
    inputPanel.add(audio);
    //inputPanel.add(new JLabel("Template", JLabel.CENTER));
    //inputPanel.add(template);
    customerPanel.add(inputPanel, BorderLayout.NORTH);
      //The buttons section:
    backPanel = new JPanel();
    middlePanel = new JPanel(new BorderLayout());
    buttonPanel1 = new JPanel();
    buttonPanel2 = new JPanel();
    search   = new JButton("SEARCH");
    update   = new JButton("UPDATE");
    clear    = new JButton("CLEAR");
    add      = new JButton("ADD");
    delete   = new JButton("DELETE");
    close    = new JButton("EXIT");
    audio1    =new JButton("Voice");
    //faceBrowse    = new JButton("...");
    //voiceBrowse    =new JButton("...");
    search.setPreferredSize(new Dimension(102, 26));
    update.setPreferredSize(new Dimension(102, 26));
    clear.setPreferredSize(new Dimension(102, 26));
    add.setPreferredSize(new Dimension(102, 26));
    delete.setPreferredSize(new Dimension(102, 26));
    close.setPreferredSize(new Dimension(102, 26));
    audio1.setPreferredSize(new Dimension(102, 26));
    //faceBrowse.setPreferredSize(new Dimension(26, 26));
    //voiceBrowse.setPreferredSize(new Dimension(26, 26));
    search.addActionListener(this);
    update.addActionListener(this);
    clear.addActionListener(this);
    add.addActionListener(this);
    delete.addActionListener(this);
    close.addActionListener(this);
    audio1.addActionListener(this);
    //faceBrowse.addActionListener(this);
    //voiceBrowse.addActionListener(this);

    buttonPanel1.add(search);
    //buttonPanel1.add(faceBrowse);
    buttonPanel1.add(update);
    buttonPanel1.add(clear);
    buttonPanel2.add(add);
    buttonPanel2.add(delete);
    buttonPanel2.add(close);
    buttonPanel2.add(audio1);
    //buttonPanel1.add(voiceBrowse);
    middlePanel.add(buttonPanel1, BorderLayout.NORTH);
    middlePanel.add(buttonPanel2, BorderLayout.CENTER);
    photoHolder = new JPanel();
    Icon curPhoto = new ImageIcon("");
    Icon[] custPhotos = {curPhoto};
    JList photosList = new JList(custPhotos);
    photosList.setFixedCellHeight(100);
    photosList.setFixedCellWidth(80);
    photoHolder.add(photosList);
    makeComments();
    backPanel.add(middlePanel);
    backPanel.add(photoHolder);
    backPanel.add(comments);
    customerPanel.add(backPanel, BorderLayout.EAST);

    //2. Create the administration tab:
    adinputPanel = new JPanel(new GridLayout(2, 4));
    adname = new JTextField(20);
    adusername = new JTextField(20);
    adpassword = new JTextField(20);
    radioPanel = new JPanel();
    statusGroup = new ButtonGroup();
    userStat = new JRadioButton("User");
    adminStat = new JRadioButton("Admin");
    cleared = new JRadioButton("");
    statusGroup.add(userStat);
    statusGroup.add(adminStat);
    statusGroup.add(cleared);
    JLabel filler = new JLabel();
    filler.setPreferredSize(new Dimension(90, 0));
    radioPanel.add(userStat);
    radioPanel.add(adminStat);
    radioPanel.add(filler);
    adinputPanel.add(new JLabel("Name  ", JLabel.RIGHT));
    adinputPanel.add(adname);
    adinputPanel.add(new JLabel("Status:  ", JLabel.RIGHT));
    adinputPanel.add(radioPanel);
    adinputPanel.add(new JLabel("(Search by) UserName  ", JLabel.RIGHT));
    adinputPanel.add(adusername);
    adinputPanel.add(new JLabel("Password  ", JLabel.RIGHT));
    adinputPanel.add(adpassword);
    adminPanel.add(adinputPanel, BorderLayout.NORTH);
      //The admin buttons section:
    admiddlePanel = new JPanel(new BorderLayout());
    adbuttonPanel1 = new JPanel();
    adbuttonPanel2 = new JPanel();
    adsearch = new JButton("SEARCH");
    adupdate = new JButton("UPDATE");
    adclear = new JButton("CLEAR");
    adadd = new JButton("ADD");
    addelete = new JButton("DELETE");
    adclose = new JButton("EXIT");
    adsearch.setPreferredSize(new Dimension(102, 26));
    adupdate.setPreferredSize(new Dimension(102, 26));
    adclear.setPreferredSize(new Dimension(102, 26));
    adadd.setPreferredSize(new Dimension(102, 26));
    addelete.setPreferredSize(new Dimension(102, 26));
    adclose.setPreferredSize(new Dimension(102, 26));
    adsearch.addActionListener(this);
    adupdate.addActionListener(this);
    adclear.addActionListener(this);
    adadd.addActionListener(this);
    addelete.addActionListener(this);
    adclose.addActionListener(this);
    adbuttonPanel1.add(adsearch);
    adbuttonPanel1.add(adupdate);
    adbuttonPanel1.add(adclear);
    adbuttonPanel2.add(adadd);
    adbuttonPanel2.add(addelete);
    adbuttonPanel2.add(adclose);
    admiddlePanel.add(adbuttonPanel1, BorderLayout.NORTH);
    admiddlePanel.add(adbuttonPanel2, BorderLayout.CENTER);
    adminPanel.add(adinputPanel, BorderLayout.NORTH);
    adminPanel.add(admiddlePanel, BorderLayout.CENTER);
    tabs.add(customerPanel, "Customers");
    tabs.add(adminPanel, "Administration");
    //tabs.add(voicePanel,"Voice");

    if(userStatus.equals("user"))
    {
      delete.setEnabled(false);
//      vdelete.setEnabled(false);
      tabs.setEnabledAt(1, false);
    }
updateTable();
    pack();
    setVisible(true);
  } //makeGUI

  //===================================================================================================
  //===================================================================================================
  //Update the customer table from the database:
  void updateTable(String userStatus)
  {
    this.userStatus = userStatus;
  }
  void updateTable()
  {boolean tabsVisible=false;
    ResultSet results = null;
    ResultSet results1 = null;
    try
    {
      //Get the number of rows in the table so we know how big to make the data array..
      int rowNumbers  = 0;
      int columnCount = 6;
      results = stat.executeQuery("SELECT COUNT(*) FROM CUSTOMER ");
      if(results.next())
      {
        rowNumbers = results.getInt(1);
      } //if
      if(rowNumbers == 0)
      rowNumbers = 1;
      tableData = new String[rowNumbers][columnCount];
      //Initialize the data array with "" so we avoid possibly having nulls in it later..
      for(int i =0;i<tableData.length;i++)
      {
        for(int j=0;j<tableData[0].length;j++)
        tableData[i][j] = "";
      }
      //Populate the data array with results of the query on the database..
      int currentRow = 0;
      results1 = stat.executeQuery("SELECT * FROM CUSTOMER ORDER BY ID");
      while (results1.next())
      {
        for(int i = 0; i < columnCount; i++)
        tableData[currentRow][i] = results1.getString(i + 1);
        currentRow++;
      } //while
      //-----------------------------------------------------------------------------------------------------
      //Create the table model:
      final String[] colName = { "CPR", "Name", "Address", "Phone", "Sex", "Date OF Birth" };
      TableModel pageModel = new AbstractTableModel()
      {
        public int getColumnCount()
        {
          return tableData[0].length;
        } //getColumnCount
        public int getRowCount()
        {
          return tableData.length;
        } //getRowCount
        public Object getValueAt(int row, int col)
        {
          return tableData[row][col];
        } //getValueAt
        public String getColumnName(int column)
        {
          return colName[column];
        } //getcolName
        public Class getColumnClass(int col)
        {
          return getValueAt(0, col).getClass();
        } //getColumnClass
        public boolean isCellEditable(int row, int col)
        {
          return false;
        } //isCellEditable
        public void setValueAt(String aValue, int row, int column)
        {
          tableData[row][column] = aValue;
        } //setValueAt
        //dataTable.setValue( new JScrollBar(JScrollBar.HORIZONTAL), 2,1 );
      }; //pageModel
      //-----------------------------------------------------------------------------------------------------
      //Create the JTable from the table model:
      JTable dataTable = new JTable(pageModel);

      //-----------------------------------------------------------------------------------------------------
      /*if (scrollpane != null)
      {
        scrollpane.setVisible(false);
        scrollpane = null;
      } //if*/
      //scrollpane = new JScrollPane(dataTable);
      //scrollpane.setVisible(true);
      if (inputPanel == null)
      makeGUI();
      JScrollPane scrollpane = new JScrollPane(dataTable, JScrollPane.VERTICAL_SCROLLBAR_ALWAYS, JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
      dataTable.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);

       // Create vertical box for second tab
        Box box = Box.createVerticalBox();
        // Create component for top
        box.add(inputPanel);
        // Place glue between components
        box.add(Box.createVerticalGlue());
        // Create component for middle
        box.add(middlePanel);
        // Place glue between components
        box.add(Box.createVerticalGlue());
        // Create component for middle
         box.add(backPanel);
   // Place glue between components
        box.add(Box.createVerticalGlue());
        // Create component for bottom
        box.add(scrollpane);
        // Add box to JTabbedPane
           tabs.add(box, "Box");
     // customerPanel.add(scrollpane, BorderLayout.SOUTH);
 if (!tabsVisible) {
 c.add(tabs);
 tabsVisible=true;
 }
//tabs.remove(box);
 //     c.add(tabs);
      id.grabFocus();
      pack();
      repaint();
      //adupdateTable();
    } //try
    catch (Exception e)
    {
      System.out.println("Caught updateTable exception: " + e);
    } //catch
  } //updatetable
  //===================================================================================================
  //===================================================================================================
  //Update the admin gui from the database:
  void adupdateTable()
  {
    ResultSet results = null;
    ResultSet results1 = null;
    try
    {
      //Get the number of rows in the table so we know how big to make the data array..
      int rowNumbers  = 0;
      int columnCount = 4;
      results = stat.executeQuery("SELECT COUNT(*) FROM PASSWORD1");
      if(results.next())
      {
        rowNumbers = results.getInt(1);
      } //if
      if(rowNumbers == 0)
      rowNumbers = 1;
      adtableData = new String[rowNumbers][columnCount];
      //Initialize the data array with "" so we avoid possibly having nulls in it later..
      for(int i =0;i< adtableData.length;i++)
      {
        for(int j=0;j< adtableData[0].length;j++)
        adtableData[i][j] = "";
      }
      //Populate the data array with results of the query on the database..
      int currentRow = 0;
      results1 = stat.executeQuery("SELECT * FROM PASSWORD1 ");
      while (results1.next())
      {
        for(int i = 0; i < columnCount; i++)
        adtableData[currentRow][i] = results1.getString(i + 1);
        currentRow++;
      } //while
      //-----------------------------------------------------------------------------------------------------
      //Create the table model:
      final String[] colName = { "Name", "Username", "Password", "Status"};
      TableModel adpageModel = new AbstractTableModel()
      {
        public int getColumnCount()
        {
          return adtableData[0].length;
        } //getColumnCount
        public int getRowCount()
        {
          return adtableData.length;
        } //getRowCount
        public Object getValueAt(int row, int col)
        {
          return adtableData[row][col];
        } //getValueAt
        public String getColumnName(int column)
        {
          return colName[column];
        } //getcolName
        public Class getColumnClass(int col)
        {
          return getValueAt(0, col).getClass();
        } //getColumnClass
        public boolean isCellEditable(int row, int col)
        {
          return false;
        } //isCellEditable
        public void setValueAt(String aValue, int row, int column)
        {
          adtableData[row][column] = aValue;
        } //setValueAt
      }; //adpageModel
      //-----------------------------------------------------------------------------------------------------
      //Create the JTable from the table model:
      addataTable = new JTable(adpageModel);
      //-----------------------------------------------------------------------------------------------------
      //if (adscrollpane != null)
      //{
      //  adscrollpane.setVisible(false);
      //  adscrollpane = null;
      //} //if
      //adscrollpane = new JScrollPane(addataTable);
      //adscrollpane.setVisible(true);
      if (adminPanel == null)
      makeGUI();
      JScrollPane adscrollpane = new JScrollPane(addataTable, JScrollPane.VERTICAL_SCROLLBAR_ALWAYS, JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
        addataTable.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
       //customerPanel.add(scrollpane, BorderLayout.SOUTH);
      adminPanel.add(adscrollpane, BorderLayout.SOUTH);
      //c.add(tabs);
      id.grabFocus();
      pack();
      repaint();
//      vupdateTable();
    } //try
    catch (Exception e)
    {
      System.out.println("Caught updateTable exception: " + e);
    } //catch
  } //updatetable

  //===================================================================================================
  //===================================================================================================

  //===========================================================================================================================
  //The button actions:
  public void actionPerformed(ActionEvent e)
  {
    FileInputStream fis = null;
    if (e.getSource() == add) //The ADD button.
    {
      //User has not populated all the input fields.
      if(name.getText().equals("")|| address.getText().equals("")|| phone.getText().equals("")|| sex.getText().equals("")|| dob.getText().equals("")|| photo.getText().equals(""))
      {
        JOptionPane.showMessageDialog(null, "Please fill in all the fields","Missing Fields",JOptionPane.INFORMATION_MESSAGE);
      }
      else
      {
        // save the new customer:
        try
        {
          //1. take the customer's data and photo:
          int    userId= Integer.parseInt(id.getText());
          String userName = name.getText();
          String userAddress = address.getText();
          String userPhone = phone.getText();
          String userSex = sex.getText();
          String userDateBirth = dob.getText();
          String photoName = photo.getText();
          String audioName=   audio.getText();
          File   file = new File(photoName);
          int    fileLength = (int)file.length();
          //2. Set the user's photo into the photoHolder:
          photoHolder.setVisible(false);
          photoHolder = null;
          comments.setVisible(false);
          comments = null;
          Icon[] custPhotos = {new ImageIcon(photoName)};
          JList photosList = new JList(custPhotos);
          photosList.setFixedCellHeight(100);
          photosList.setFixedCellWidth(80);
          photoHolder = new JPanel();
          photoHolder.add(photosList);
          makeComments();
          //3. Insert the data and photo into the database:
          if(fileLength > 0)
          {
            fis = new FileInputStream(file);
            String query = " INSERT INTO CUSTOMER VALUES('"+userId+"', '"+ userName+ "', '"+ userAddress+ "', " +" '"+ userPhone+ "', '"+ userSex+ "', '"+ userDateBirth+ "', ?,?,? ) ";
            PreparedStatement pstmt = conn.prepareStatement(query);
            pstmt.setBinaryStream(1, fis, fileLength);
    pstmt.setString(2,photoName);
    pstmt.setString(3,audioName);
            pstmt.executeUpdate();
            comments.setText(userName+", added.");
          }
          else
          {
            String query = " INSERT INTO CUSTOMER (id, name, address, phone, sex, dob) VALUES('"+userId+"', '"+userName+"', '"+userAddress+"', '"+userPhone+"', '"+userSex+"', '"+userDateBirth+"') ";
            stat.executeUpdate(query);
            comments.setText("Customer saved without a photo.");
          }
          backPanel.add(photoHolder);
          backPanel.add(comments);
          updateTable();
        } //try
        catch (Exception ee)
        {
           //The danger of putting creating the JOptionPane in here is that it will show the same message regardless of the error.
  JOptionPane.showMessageDialog(null, "Customers CPR already exits!!Please enter another CPR","Invalid",JOptionPane.INFORMATION_MESSAGE);
          System.out.println("Caught exception in add action: " + ee);
        } //catch
      } //if
    }//add button
    //-----------------------------------------------------------------------------------------------------
    else if(e.getSource() == delete) //The DELETE button.
    {
      if(searchDB())
      {
        int deleteConfirmed = JOptionPane.showConfirmDialog(this, "Are you sure you want to delete this customer?", "Confirm Delete",  JOptionPane.OK_CANCEL_OPTION, JOptionPane.WARNING_MESSAGE);
        if(deleteConfirmed == 0)
        {
          try
          {
            int userId = Integer.parseInt(id.getText());
            String sql = "DELETE FROM CUSTOMER WHERE ID = '"+userId+"' ";
            stat.executeUpdate(sql);
            clearFields();
            id.setText("");
            updateTable();
          }
          catch(Exception ex)
          {
            System.out.println("Caught deleting exception: "+ex);
          }
        }
      }
    }//delete button
    //-----------------------------------------------------------------------------------------------------
    else if (e.getSource() == search) //The SEARCH button.
    {
      searchDB();
    } //search button
    //-----------------------------------------------------------------------------------------------------
    else if(e.getSource() == update) //The UPDATE button.
    {
      //User has not populated all the CPR field.
      if(id.getText().equals(""))
      {
        JOptionPane.showMessageDialog( null, "Please enter a customer's CPR.","Customers CPR is missing.",JOptionPane.INFORMATION_MESSAGE);
      }
      else
      {
        int updateConfirmed = JOptionPane.showConfirmDialog(this, "Are you sure you want to update this customer?", "Confirm Update",  JOptionPane.OK_CANCEL_OPTION, JOptionPane.WARNING_MESSAGE);
        if(updateConfirmed == 0)
        {
        // save the updates:
        try
        {
          //1. take the customer's data and photo:
          int    userId= Integer.parseInt(id.getText());
          String userName = name.getText();
          String userAddress = address.getText();
          String userPhone = phone.getText();
          String userSex = sex.getText();
          String userDateBirth = dob.getText();
          String photoName = photo.getText();
          File   file = new File(photoName);
          int    fileLength = (int)file.length();
          //3. Update the data and photo in the database:
          if(fileLength > 0)
          {
            fis = new FileInputStream(file);
            String query = " UPDATE CUSTOMER SET NAME = '"+ userName+ "', ADDRESS = '"+ userAddress+ "', " +
              " PHONE = " +" '"+ userPhone+ "', SEX = '"+ userSex+ "', DOB = '"+userDateBirth+"', PICTURE = ? ,photoFileName=? " +
              " WHERE ID = '"+userId+"' ";
            PreparedStatement pstmt = conn.prepareStatement(query);
            pstmt.setBinaryStream(1, fis, fileLength);
            pstmt.setString(2,photoName);
            pstmt.executeUpdate();
          //2. Set the user's photo into the photoHolder:
          photoHolder.setVisible(false);
          photoHolder = null;
          comments.setVisible(false);
          comments = null;
          Icon[] custPhotos = {new ImageIcon(photoName)};
          JList photosList = new JList(custPhotos);
          photosList.setFixedCellHeight(100);
          photosList.setFixedCellWidth(80);
          photoHolder = new JPanel();
          photoHolder.add(photosList);
          makeComments();
          }
          else
          {
            String query = " UPDATE CUSTOMER SET NAME = '"+userName+"', ADDRESS = '"+userAddress+"', " +
              " PHONE = '"+userPhone+"', SEX = '"+userSex+"', DOB = '"+userDateBirth+"' " +
              " WHERE ID = '"+userId+"' ";
            stat.executeUpdate(query);
          }
          backPanel.add(photoHolder);
          backPanel.add(comments);
          updateTable();
        } //try
        catch (Exception ee)
        {
          System.out.println("Caught exception in update action: " + ee);
        } //catch
         comments.setText("Customer successfully updated");
      }
    }//if
   }
    //-----------------------------------------------------------------------------------------------------
    else if(e.getSource() == clear) //The CLEAR button.
    {
      id.setText("");
      clearFields();
    }//clear button
    //-----------------------------------------------------------------------------------------------------
    else if (e.getSource() == close) //The CLOSE button.
    {
      closeConnection();
      System.exit(0);
    }//close button
    //-----------------------------------------------------------------------------------------------------
     else if(e.getSource() == adsearch)
    {
      try
      {
        String adusernameInput = adusername.getText();
        ResultSet adresults = stat.executeQuery("SELECT * FROM PASSWORD1 WHERE USERNAME = '"+adusernameInput+"' ");
        if(adresults.next())
        {
          adname.setText(adresults.getString(1).trim());
          adpassword.setText(adresults.getString(3).trim());
          String curStatus = adresults.getString(4).trim();
          if(curStatus.equals("user"))
          userStat.setSelected(true);
          else if(curStatus.equals("admin"))
          adminStat.setSelected(true);
        }//if
      }//try
      catch(Exception ade)
      {
        System.out.println("Caught adsearch exception: "+ade);
      }//catch
    }//adsearch
//-----------------------------------------------------------------------------------------------------------
 else if(e.getSource()==adadd)
     {
      String enteredPassword= adpassword.getText();
    if(adname.getText().equals("")|| adusername.getText().equals("")|| enteredPassword.equals("") || (userStat.isSelected() == false && adminStat.isSelected() == false))
            {
              JOptionPane.showMessageDialog(null, "Please fill in all the fields","Missing Fields",JOptionPane.INFORMATION_MESSAGE);
             }//if
         else
             {
        // save
        try
        {
          String  aduserName= adname.getText();
          String  adName= adusername.getText();
                  String aduserPassword = adpassword.getText();
          String aduserStatus = "";
                    if(userStat.isSelected() == true)
                    aduserStatus = "user";
                    else if(adminStat.isSelected() == true)
                    aduserStatus = "admin";
         String addquery = " INSERT INTO password1 VALUES( '"+ aduserName+ "', '"+ adName+ "', '"+ aduserPassword+ "', '"+aduserStatus+"' )" ;
                 stat.executeUpdate(addquery);
 adupdateTable();
                 } //try
  catch (Exception ep)
   {
      //The danger of putting creating the JOptionPane in here is that it will show the same message regardless of the error.
   JOptionPane.showMessageDialog(null, "UserName already exits!!Please enter another Username","Invalid",JOptionPane.INFORMATION_MESSAGE);
           System.out.println("Caught exception in add action: " + ep);
                   } //catch
              }//else
  }//else if
//-----------------------------------------------------------------------------------------------------------------------
else if(e.getSource()==adupdate)
     {
       if(adusername.getText().equals(""))
       {
         JOptionPane.showMessageDialog( null, "Please enter a username.","Missing.",JOptionPane.INFORMATION_MESSAGE);
       }//if
       else
       {
         int updateConfirmed = JOptionPane.showConfirmDialog(this, "Are you sure you want to update this customer?", "Confirm Update",  JOptionPane.OK_CANCEL_OPTION, JOptionPane.WARNING_MESSAGE);
         if(updateConfirmed == 0)
         {
         // save the updates:
         try
                  {
    String  aduserName= adname.getText();
        String  adName= adusername.getText();
                    String aduserPassword= adpassword.getText();
//    String aduserPassword = adpassword.getText();
                String aduserStatus = "";
         if(userStat.isSelected() == true)
                       aduserStatus = "user";
         else if(adminStat.isSelected() == true)
                       aduserStatus = "admin";
//3. Update the data in the database:
    String query =  " UPDATE password1 SET NAME = '"+adName+"', Password= '"+aduserPassword+"', " +
                            "status = '"+aduserStatus+"' " + " WHERE username = '"+aduserName+"' ";
               stat.executeUpdate(query);
   adupdateTable();

 } //try

 catch (Exception epu)
 {
  System.out.println("Caught exception in add action: " + epu);
                  } //catch
   }//else
   }//if
}//else if
//--------------------------------------------------------------------------------------------------------------------------------------------------------------
 else if(e.getSource() == addelete) //The DELETE button.
    {
        int deleteConfirmed = JOptionPane.showConfirmDialog(this, "Are you sure you want to delete this customer?", "Confirm Delete",  JOptionPane.OK_CANCEL_OPTION, JOptionPane.WARNING_MESSAGE);
        if(deleteConfirmed == 0)
        {
          try
          {
            String aduserName = adusername.getText();
            String sql = "DELETE FROM password1 WHERE username = '"+aduserName+"' ";
            stat.executeUpdate(sql);
            adname.setText("");
adusername.setText("");
adpassword.setText("");
            cleared.setSelected(true);
            updateTable();
          }//try
          catch(Exception ex)
          {
            System.out.println("Caught deleting exception: "+ex);
          }//catch
        }//if
    }//delete button
//----------------------------------------------------------------------------------------------------------------------------------------------------------------------
 else if(e.getSource()==adclear)
 {
      adname.setText("");
      adusername.setText("");
      adpassword.setText("");
      cleared.setSelected(true);
    }
//-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
   else if(e.getSource() == adclose)
    {
      closeConnection();
      System.exit(0);
    }
//-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
  } //actionlistener
  //===================================================================================================
  //===================================================================================================
  //Clear all the input fields:
  void clearFields()
  {
    name.setText("");
    address.setText("");
    phone.setText("");
    sex.setText("");
    dob.setText("");
    photo.setText("");
    photoHolder.setVisible(false);
    photoHolder = null;
    comments.setVisible(false);
    comments = null;
    photoHolder = new JPanel();
    Icon curPhoto = new ImageIcon("");
    Icon[] custPhotos = {curPhoto};
    JList photosList = new JList(custPhotos);
    photosList.setFixedCellHeight(100);
    photosList.setFixedCellWidth(80);
    photoHolder.add(photosList);
    backPanel.add(photoHolder);
    makeComments();
    backPanel.add(comments);
  }

  //===================================================================================================
  //Perform a search on the database:
  boolean searchDB()
  {
    //Validate the input:
    String validInput = "0123456789";
    String input = id.getText();
    boolean invalidInput = false;
    for(int i =0;i<input.length();i++)
    {
      if(validInput.indexOf(input.charAt(i)) == -1)
      {
        JOptionPane.showMessageDialog( null, "Customers CPR must be a number","Invalid customer CPR.",JOptionPane.INFORMATION_MESSAGE);
        return false;
      }//if
    }//for
    if(id.getText().equals(""))
    {
      JOptionPane.showMessageDialog(null,"Please enter a customers CPR."," Customers CPR is missing",JOptionPane.INFORMATION_MESSAGE);
      return false;
    }//if
    else
    {
      //The id is valid, perform a search on it:
      clearFields();
      int idEntered = Integer.parseInt(id.getText());
      try
      {
        ResultSet results = stat.executeQuery("SELECT * FROM CUSTOMER WHERE ID='" + idEntered + "'");
        if (results.next())
        {
          //The customer is in the database, populate the data fields with their info. and show their photo..
          name.setText(results.getString(2).trim());
          address.setText(results.getString(3).trim());
          phone.setText(results.getString(4).trim());
          sex.setText(results.getString(5).trim());
          dob.setText(results.getString(6));
          photo.setText(results.getString(8));
          byte[] photoBytes = results.getBytes(7);
          if(photoBytes != null)
          {
            photoHolder.setVisible(false);
            comments.setVisible(false);
            photoHolder = null;
            comments = null;
            Icon curPhoto = new ImageIcon(results.getBytes(7));
            Icon[] custPhotos = {curPhoto};
            JList photosList = new JList(custPhotos);
            photosList.setFixedCellHeight(100);
            photosList.setFixedCellWidth(80);
            photoHolder = new JPanel();
            photoHolder.add(photosList);
            makeComments();
            backPanel.add(photoHolder);
            backPanel.add(comments);
            repaint();
          }//if
          comments.setText(name.getText());
          return true;
        }//if
        else
        {
          comments.setText("Customer CPR"+idEntered+", is not in database.");
          return false;
        }//else
      }//try
      catch (Exception eee)
      {
        System.out.println("Caught exception in searchDB: " + eee);
        return false;
      } //catch
    }//else
  }//search
  //---------------------------------------------------------------------------------------------------------------------------------------------------

  //-----------------------------------------------------------------------------------------------------

void makeComments()
{
    comments = new JTextArea(5, 15);
    comments.setLineWrap(true);
    comments.setWrapStyleWord(true);
    comments.setHighlighter(null);
    comments.setEditable(false);
    comments.setForeground(Color.red);
    comments.setFont(new Font("Dialog", Font.BOLD, 12));
    comments.setBackground(new Color(204, 204, 204));
}

  //===================================================================================================
  //Handle the connections to the database:
  void makeConnection(String dsnName)
  {
    try
    {
      this.dsnName = dsnName;
      System.out.println("Connecting to database..");
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      conn = DriverManager.getConnection("jdbc :-o	 dbc:" + dsnName);
      stat = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
    }
    catch (Exception e)
    {
      System.out.println("Caught exception in makeConnection: " + e);
    }
  } //makeConnection()
  //-----------------------------------------------------------------------------------------------------
  void closeConnection()
  {
    try
    {
      System.out.println("Closing database connections..");
      conn.close();
      conn = null;
      stat = null;
    }
    catch (Exception e)
    {
      System.out.println("Caught closeConnection exception: " + e);
    }
  } //closeConnection()
    public static void main(String args[]){
  UtilityMethods application=new UtilityMethods();
  application.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
       }//MAIN
} //Jframe