private void listMemberMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_listMemberMouseClicked

        try
        {
            try
            {
                int select = listMember.getSelectedIndex();
                listMember.setSelectedIndex(select);
                String tempFirst = arrayFirstName.get(select);
                String tempLast = arrayLastName.get(select);
                String tempMid = arrayMidName.get(select);
               // System.out.println("MemberID:  "+lastname + " : " + select);
                String tempQuery = "select loanid,status,loantype,grantdt,loanamt,montopay,interestrt,balance from loan_hdr where memberid = (select memberid from member where firstname = '"+ tempFirst +"' and lastname = '"+tempLast+"' and midinit = '"+tempMid+"')";
        
                Statement stmt = null;       
                this.connect();
                conn = this.getConnection();
                
                try
                {
                    stmt = conn.createStatement();
                }
                
                catch(SQLException e)
                {
                    e.printStackTrace();
                }
        
                ResultSet rs;
	
                try
                {
                    rs = stmt.executeQuery(tempQuery);
                    try
                    {
                        commonUtils.updateTableModelData((DefaultTableModel) listLoan.getModel(), rs, 8);
                    } 
                    catch (Exception ex)
                    {
                        Logger.getLogger(ViewMember.class.getName()).log(Level.SEVERE, null, ex);
                    }
                }
        
                catch (SQLException e)
                {
                    e.printStackTrace();
                }
                finally
                {
                    this.disconnect();
                }
            }
        
            catch(Exception e)
            {
                DefaultTableModel model = (DefaultTableModel) listLoan.getModel();
                model.removeRow(model.getRowCount()-1);
            }
        }
        catch(Exception o)
        {
            
        }
        // TODO add your handling code here:
    }//GEN-LAST:event_listMemberMouseClicked