Help regarding JList Netbeans6.9 IDE

[ambassador]

good day guys,

please help:

i'm having trouble of displaying my data from ms access database to JList. if there's someone could help me, i would greatly appreciate it. i'm using netbeans 6.0 for developing an application. here is my code so far:

note: some of my code is auto generated by netbeans JDK.

/*TO GOD BE THE GLORY! I CAN DO ALL THINGS THROUGH CHRIST WHO STRENGHTENS ME!
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
 
/*
 * MainForm.java
 *
 * Created on Feb 4, 2011, 8:41:45 AM
 */
 
package UsernamePasswordPackage;
import java.awt.Color;
import java.sql.*;
import javax.swing.*;
/**
 *
 * @author jmoreno
 */
public class MainForm extends javax.swing.JFrame {
    /** Creates new form MainForm */
        DefaultListModel list = new DefaultListModel();
        public MainForm() {
        this.setTitle("Username & Password Manager");
 
        initComponents();
 
        jButton1.requestFocus();
        jButton1.setEnabled(true);
        jButton2.setEnabled(true);
        jButton3.setEnabled(false);
        jButton4.setEnabled(false);
        jButton5.setEnabled(true);
        jTextField1.setEnabled(false);
        jTextField2.setEnabled(false);
        jTextField3.setEnabled(false);
        jList1.clearSelection();
        jButton5.setBackground(Color.getHSBColor(0, 217, 114));
        //PopulatejList();
    }
 
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">
    private void initComponents() {
 
        jPanel1 = new javax.swing.JPanel();
        jScrollPane1 = new javax.swing.JScrollPane();
        jList1 = new javax.swing.JList();
        jLabel1 = new javax.swing.JLabel();
        jTextField1 = new javax.swing.JTextField();
        jTextField2 = new javax.swing.JTextField();
        jLabel2 = new javax.swing.JLabel();
        jLabel3 = new javax.swing.JLabel();
        jTextField3 = new javax.swing.JTextField();
        jButton1 = new javax.swing.JButton();
        jButton2 = new javax.swing.JButton();
        jButton3 = new javax.swing.JButton();
        jButton4 = new javax.swing.JButton();
        jButton5 = new javax.swing.JButton();
 
        setDefaultCloseOperation(javax.swing.WindowConstants.DO_NOTHING_ON_CLOSE);
        setResizable(false);
 
        jList1.setBorder(new javax.swing.border.LineBorder(new java.awt.Color(0, 0, 0), 1, true));
        jList1.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jList1MouseClicked(evt);
            }
        });
        jScrollPane1.setViewportView(jList1);
 
        jLabel1.setFont(new java.awt.Font("Tahoma", 1, 16));
        jLabel1.setText("Username :");
 
        jTextField1.setFont(new java.awt.Font("Tahoma", 0, 16));
        jTextField1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jTextField1ActionPerformed(evt);
            }
        });
        jTextField1.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                jTextField1KeyPressed(evt);
            }
        });
 
        jTextField2.setFont(new java.awt.Font("Tahoma", 0, 16));
        jTextField2.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                jTextField2KeyPressed(evt);
            }
        });
 
        jLabel2.setFont(new java.awt.Font("Tahoma", 1, 16));
        jLabel2.setText("Password :");
 
        jLabel3.setFont(new java.awt.Font("Tahoma", 1, 16));
        jLabel3.setText("Website :");
 
        jTextField3.setFont(new java.awt.Font("Tahoma", 0, 16));
        jTextField3.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                jTextField3KeyPressed(evt);
            }
        });
 
        jButton1.setText("Add");
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });
        jButton1.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                jButton1KeyPressed(evt);
            }
        });
 
        jButton2.setText("Edit");
        jButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton2ActionPerformed(evt);
            }
        });
        jButton2.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                jButton2KeyPressed(evt);
            }
        });
 
        jButton3.setText("Save");
        jButton3.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton3ActionPerformed(evt);
            }
        });
        jButton3.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                jButton3KeyPressed(evt);
            }
        });
 
        jButton4.setText("Cancel");
        jButton4.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton4ActionPerformed(evt);
            }
        });
        jButton4.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                jButton4KeyPressed(evt);
            }
        });
 
        jButton5.setText("Exit");
        jButton5.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton5ActionPerformed(evt);
            }
        });
        jButton5.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                jButton5KeyPressed(evt);
            }
        });
 
        javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
        jPanel1.setLayout(jPanel1Layout);
        jPanel1Layout.setHorizontalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 65, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 30, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 40, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jButton4, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jButton5, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
                        .addComponent(jScrollPane1, javax.swing.GroupLayout.Alignment.LEADING)
                        .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel1Layout.createSequentialGroup()
                            .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                .addComponent(jLabel2)
                                .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 134, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addComponent(jLabel3))
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                            .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 223, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))))
                .addContainerGap(20, Short.MAX_VALUE))
        );
 
        jPanel1Layout.linkSize(javax.swing.SwingConstants.HORIZONTAL, new java.awt.Component[] {jTextField1, jTextField2, jTextField3});
 
        jPanel1Layout.linkSize(javax.swing.SwingConstants.HORIZONTAL, new java.awt.Component[] {jLabel1, jLabel2, jLabel3});
 
        jPanel1Layout.linkSize(javax.swing.SwingConstants.HORIZONTAL, new java.awt.Component[] {jButton1, jButton2, jButton3, jButton4, jButton5});
 
        jPanel1Layout.setVerticalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 172, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addComponent(jLabel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 37, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel2))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 27, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jButton1)
                    .addComponent(jButton2)
                    .addComponent(jButton3)
                    .addComponent(jButton4)
                    .addComponent(jButton5))
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );
 
        jPanel1Layout.linkSize(javax.swing.SwingConstants.VERTICAL, new java.awt.Component[] {jTextField1, jTextField2, jTextField3});
 
        jPanel1Layout.linkSize(javax.swing.SwingConstants.VERTICAL, new java.awt.Component[] {jLabel1, jLabel2, jLabel3});
 
        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
        );
 
        java.awt.Dimension screenSize = java.awt.Toolkit.getDefaultToolkit().getScreenSize();
        setBounds((screenSize.width-405)/2, (screenSize.height-396)/2, 405, 396);
    }// </editor-fold>
 
    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        int choose = JOptionPane.showConfirmDialog(null,"Continue to add new record?","Add New Record",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
        if(choose == JOptionPane.OK_OPTION){
           jButton1.setEnabled(false);
           jButton2.setEnabled(false);
           jButton3.setEnabled(true);
           jButton4.setEnabled(true);
           jButton5.setEnabled(false);
           jTextField1.setEnabled(true);
           jTextField2.setEnabled(true);
           jTextField3.setEnabled(true);
           jTextField1.requestFocus();
        }else if(choose == JOptionPane.CANCEL_OPTION){
           jButton1.setEnabled(true);
           jButton2.setEnabled(true);
           jButton3.setEnabled(false);
           jButton4.setEnabled(false);
           jButton5.setEnabled(true);
           jTextField1.setEnabled(false);
           jTextField2.setEnabled(false);
           jTextField3.setEnabled(false);
           jButton1.requestFocus();
        }
    }                                        
 
    private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        JOptionPane.showMessageDialog(null,"You have been cancelled the adding of new record/s.");
        jButton1.setEnabled(true);
        jButton2.setEnabled(true);
        jButton3.setEnabled(false);
        jButton4.setEnabled(false);
        jButton5.setEnabled(true);
        jTextField1.setText("");
        jTextField2.setText("");
        jTextField3.setText("");
        jTextField1.setEnabled(false);
        jTextField2.setEnabled(false);
        jTextField3.setEnabled(false);
    }                                        
 
    private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        int choose = JOptionPane.showConfirmDialog(null,"Continue to exit?.","Exit",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
        if(choose == JOptionPane.YES_OPTION){
            this.dispose();
        }else if(choose == JOptionPane.NO_OPTION){
            jButton1.requestFocus();
            return;
        }
    }                                        
 
    private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        if(jTextField1.getText().isEmpty()){
           JOptionPane.showMessageDialog(null,"Please complete all necessary fields.","Required Fields",JOptionPane.OK_OPTION);
           if(jTextField1.getText().isEmpty()){
              jTextField1.requestFocus();
           }
           return;
        }
        else if(jTextField2.getText().isEmpty()){
           JOptionPane.showMessageDialog(null,"Please complete all necessary fields.","Required Fields",JOptionPane.OK_OPTION);
           if(jTextField2.getText().isEmpty()){
              jTextField2.requestFocus();
           }
           return;
        }
        else if(jTextField3.getText().isEmpty()){
           JOptionPane.showMessageDialog(null,"Please complete all necessary fields.","Required Fields",JOptionPane.OK_OPTION);
           if(jTextField3.getText().isEmpty()){
              jTextField3.requestFocus();
           }
           return;
        }
 
        int choose = JOptionPane.showConfirmDialog(null,"Continue to save new record?","Confirmation",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
        if(choose == JOptionPane.YES_OPTION){
 
           String text1 = jTextField1.getText();
           String text2 = jTextField2.getText();
           String text3 = jTextField3.getText();
 
           String dbuser = "";
           String dbpasswd = "";
           String DriverPrefix = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\myWork2\\PersonalInfo\\db1.mdb";
 
           String SQLString = "INSERT INTO Table1(Username,Password,Website)VALUES('"+text1+"','"+text2+"','"+text3+"')";
 
           try{
              Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
           }
           catch(Exception e){
              JOptionPane.showMessageDialog(null,""+e.getMessage(),"JDBC DRIVER Error",JOptionPane.WARNING_MESSAGE);
              return;
           }
           Statement stmt = null;
           Connection con = null;
 
           try{
              //con = DriverManager.getConnection("jdbc:odbc:db1.mdb");
              //con = DriverManager.getConnection(DriverPrefix+DataSource,dbuser,dbpasswd);
              con = DriverManager.getConnection(DriverPrefix,dbuser,dbpasswd);
              stmt = con.createStatement();
           }
           catch(Exception e){
              JOptionPane.showMessageDialog(null,""+e.getMessage(),"Connection Error",JOptionPane.WARNING_MESSAGE);
           }
 
           try{
              stmt.executeUpdate(SQLString);
              con.close();
              jTextField1.setEnabled(false);
              jTextField2.setEnabled(false);
              jTextField3.setEnabled(false);
              jButton1.setEnabled(true);
              jButton2.setEnabled(true);
              jButton3.setEnabled(false);
              jButton4.setEnabled(false);
              jButton5.setEnabled(true);
              jButton1.requestFocus();
           }
           catch(SQLException e){
              JOptionPane.showMessageDialog(null,"Check that all TextFields have been completed.\n"+e.getMessage(),"Communication Error",JOptionPane.WARNING_MESSAGE);
           }
        }
        else{
           jTextField1.setText("");
           jTextField1.setEnabled(false);
           jTextField2.setText("");
           jTextField2.setEnabled(false);
           jTextField3.setText("");
           jTextField3.setEnabled(false);
           jButton1.setEnabled(true);
           jButton2.setEnabled(true);
           jButton3.setEnabled(false);
           jButton4.setEnabled(false);
           jButton5.setEnabled(true);
           jButton1.requestFocus();
        }
    }                                        
 
    private void jTextField1ActionPerformed(java.awt.event.ActionEvent evt) {                                            
        // TODO add your handling code here:
    }                                           
 
    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        jButton1.setEnabled(false);
        jButton2.setEnabled(false);
        jButton3.setEnabled(true);
        jButton4.setEnabled(true);
        jButton5.setEnabled(false);
        jTextField1.setEnabled(true);
        jTextField2.setEnabled(true);
        jTextField3.setEnabled(true);
        jTextField1.requestFocus();
    }                                        
 
    private void jTextField1KeyPressed(java.awt.event.KeyEvent evt) {                                       
        // TODO add your handling code here:
        if(evt.getKeyCode()==10){
            jTextField2.requestFocus();
        }
    }                                      
 
    private void jTextField2KeyPressed(java.awt.event.KeyEvent evt) {                                       
        // TODO add your handling code here:
        if(evt.getKeyCode()==10){
            jTextField3.requestFocus();
        }
    }                                      
 
    private void jTextField3KeyPressed(java.awt.event.KeyEvent evt) {                                       
        // TODO add your handling code here:
        if(evt.getKeyCode()==10){
            jButton3.requestFocus();
        }
    }                                      
 
    private void jButton1KeyPressed(java.awt.event.KeyEvent evt) {                                    
        // TODO add your handling code here:
        if(evt.getKeyCode()==10){
            int choose = JOptionPane.showConfirmDialog(null,"Continue to add new record?","Add New Record",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
            if(choose == JOptionPane.OK_OPTION){
               jButton1.setEnabled(false);
               jButton2.setEnabled(false);
               jButton3.setEnabled(true);
               jButton4.setEnabled(true);
               jButton5.setEnabled(false);
               jTextField1.setEnabled(true);
               jTextField2.setEnabled(true);
               jTextField3.setEnabled(true);
               jTextField1.requestFocus();
            }else if(choose == JOptionPane.CANCEL_OPTION){
               jButton1.setEnabled(true);
               jButton2.setEnabled(true);
               jButton3.setEnabled(false);
               jButton4.setEnabled(false);
               jButton5.setEnabled(true);
               jTextField1.setEnabled(false);
               jTextField2.setEnabled(false);
               jTextField3.setEnabled(false);
               jButton1.requestFocus();
           }
        }
    }                                   
 
    private void jButton2KeyPressed(java.awt.event.KeyEvent evt) {                                    
        // TODO add your handling code here:
        if(evt.getKeyCode()==10){
            jButton1.setEnabled(false);
            jButton2.setEnabled(false);
            jButton3.setEnabled(true);
            jButton4.setEnabled(true);
            jButton5.setEnabled(false);
            jTextField1.setEnabled(true);
            jTextField2.setEnabled(true);
            jTextField3.setEnabled(true);
            jTextField1.requestFocus();
        }
    }                                   
 
    private void jButton3KeyPressed(java.awt.event.KeyEvent evt) {                                    
        // TODO add your handling code here:
        if(evt.getKeyCode()==10){
            if(jTextField1.getText().isEmpty()){
                JOptionPane.showMessageDialog(null,"Please complete all necessary fields.","Required Fields",JOptionPane.OK_OPTION);
                if(jTextField1.getText().isEmpty()){
                   jTextField1.requestFocus();
                }
                return;
             }
             else if(jTextField2.getText().isEmpty()){
                 JOptionPane.showMessageDialog(null,"Please complete all necessary fields.","Required Fields",JOptionPane.OK_OPTION);
                 if(jTextField2.getText().isEmpty()){
                     jTextField2.requestFocus();
                 }
                 return;
             }
             else if(jTextField3.getText().isEmpty()){
                 JOptionPane.showMessageDialog(null,"Please complete all necessary fields.","Required Fields",JOptionPane.OK_OPTION);
                 if(jTextField3.getText().isEmpty()){
                     jTextField3.requestFocus();
                 }
                 return;
             }
 
             int choose = JOptionPane.showConfirmDialog(null,"Continue to save new record?","Confirmation",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
             if(choose == JOptionPane.YES_OPTION){
 
             String text1 = jTextField1.getText();
             String text2 = jTextField2.getText();
             String text3 = jTextField3.getText();
 
             String dbuser = "";
             String dbpasswd = "";
             String DriverPrefix = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\myWork2\\PersonalInfo\\db1.mdb";
 
             String SQLString = "INSERT INTO Table1(Username,Password,Website)VALUES('"+text1+"','"+text2+"','"+text3+"')";
 
             try{
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             }
             catch(Exception e){
                JOptionPane.showMessageDialog(null,""+e.getMessage(),"JDBC DRIVER Error",JOptionPane.WARNING_MESSAGE);
                return;
             }
             Statement stmt = null;
             Connection con = null;
 
             try{
                //con = DriverManager.getConnection("jdbc:odbc:db1.mdb");
                //con = DriverManager.getConnection(DriverPrefix+DataSource,dbuser,dbpasswd);
                con = DriverManager.getConnection(DriverPrefix,dbuser,dbpasswd);
                stmt = con.createStatement();
             }
             catch(Exception e){
                JOptionPane.showMessageDialog(null,""+e.getMessage(),"Connection Error",JOptionPane.WARNING_MESSAGE);
             }
 
             try{
                stmt.executeUpdate(SQLString);
                con.close();
                jTextField1.setEnabled(false);
                jTextField2.setEnabled(false);
                jTextField3.setEnabled(false);
                jButton1.setEnabled(true);
                jButton2.setEnabled(true);
                jButton3.setEnabled(false);
                jButton4.setEnabled(false);
                jButton5.setEnabled(true);
                jButton1.requestFocus();
             }
             catch(SQLException e){
                JOptionPane.showMessageDialog(null,"Check that all TextFields have been completed.\n"+e.getMessage(),"Communication Error",JOptionPane.WARNING_MESSAGE);
             }
          }
          else{
             jTextField1.setText("");
             jTextField1.setEnabled(false);
             jTextField2.setText("");
             jTextField2.setEnabled(false);
             jTextField3.setText("");
             jTextField3.setEnabled(false);
             jButton1.setEnabled(true);
             jButton2.setEnabled(true);
             jButton3.setEnabled(false);
             jButton4.setEnabled(false);
             jButton5.setEnabled(true);
             jButton1.requestFocus();
          }
        }
    }                                   
 
    private void jButton4KeyPressed(java.awt.event.KeyEvent evt) {                                    
        // TODO add your handling code here:
        if(evt.getKeyCode()==10){
            JOptionPane.showMessageDialog(null,"You have been cancelled the adding of new record/s.");
            jButton1.setEnabled(true);
            jButton2.setEnabled(true);
            jButton3.setEnabled(false);
            jButton4.setEnabled(false);
            jButton5.setEnabled(true);
            jTextField1.setText("");
            jTextField2.setText("");
            jTextField3.setText("");
            jTextField1.setEnabled(false);
            jTextField2.setEnabled(false);
            jTextField3.setEnabled(false);
        }
    }                                   
 
    private void jButton5KeyPressed(java.awt.event.KeyEvent evt) {                                    
        // TODO add your handling code here:
        if(evt.getKeyCode()==10){
            int choose = JOptionPane.showConfirmDialog(null,"Continue to exit?.","Exit",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
            if(choose == JOptionPane.YES_OPTION){
                this.dispose();
            }else if(choose == JOptionPane.NO_OPTION){
                jButton1.requestFocus();
                return;
            }
        }
    }                                   
 
    private void jList1MouseClicked(java.awt.event.MouseEvent evt) {                                    
        // TODO add your handling code here:
    }                                   
 
    public void PopulatejList(){
           String dbuser = "";
           String dbpasswd = "";
           String DriverPrefix = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\myWork2\\PersonalInfo\\db1.mdb";
 
           String SQLString = ("select * from Table1");
 
           try{
              Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
           }
           catch(Exception e){
              JOptionPane.showMessageDialog(null,""+e.getMessage(),"JDBC DRIVER Error",JOptionPane.WARNING_MESSAGE);
              return;
           }
           Statement stmt = null;
           Connection con = null;
           ResultSet rset = null;
 
           try{
              con = DriverManager.getConnection(DriverPrefix,dbuser,dbpasswd);
              stmt = con.createStatement();
           }
           catch(Exception e){
              JOptionPane.showMessageDialog(null,""+e.getMessage(),"Connection Error",JOptionPane.WARNING_MESSAGE);
           }
 
           try{
              rset = stmt.executeQuery(SQLString);
              String Add;
              while(rset.next()){
                  Add = rset.getString("ID")+rset.getString("Username")+rset.getString("Password")+
                          rset.getString("Website");
                  list.addElement(Add);
              }
              con.close();
           }
           catch(SQLException e){
               JOptionPane.showMessageDialog(null,e.getMessage(),"Communication Error",JOptionPane.WARNING_MESSAGE);
           }
           jList1 = new JList(list);
    }
    /**
    * @param args the command line arguments
    */
    public static void main(String args[]) throws SQLException {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new MainForm().setVisible(true);
                MainForm MF = new MainForm();
                MF.PopulatejList();
            }
        });
    }
 
    // Variables declaration - do not modify
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JButton jButton3;
    private javax.swing.JButton jButton4;
    private javax.swing.JButton jButton5;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JList jList1;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTextField jTextField1;
    private javax.swing.JTextField jTextField2;
    private javax.swing.JTextField jTextField3;
    // End of variables declaration
 
}
 

thanks guys for helping me.

2 days have been passed and still i can't get pass with this. thanks again...