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

        try
        {
            try
            {

                int select = listCompany.getSelectedIndex();
                listCompany.setSelectedIndex(select);
                String compid = compID.get(select);
                String tempQuery = "select billid,processdt,startdt,enddt,billdt,billamt from bill_hdr where compid='"+compid+"'";
               // System.out.println(tempQuery);
                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
                    {
                        tableUtils.updateTableModelData((DefaultTableModel) listHeader.getModel(), rs, 6);
                    } 
                    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) listHeader.getModel();
                model.removeRow(model.getRowCount()-1);
            }
        }
        catch(Exception o)
        {
            
        }
        
        // TODO add your handling code here:
    }//GEN-LAST:event_listCompanyMouseClicked