public void getListDetails(String id)
    {
        float total = 0;
        float totalInterest = 0;
        try
        {
            String tempQuery = "select membername,contribution,cash_amount,reg_amount,calamity_amount,educ_amount,emer_amount,goods_amount,mem_total from bill_dtl where billid='"+id+"'";
        
            Statement stmt = null;       
            this.connect();
            conn = this.getConnection();
                
            try
            {
                stmt = conn.createStatement();
            }
                
            catch (SQLException e)
            {
                e.printStackTrace();
            }
		
            ResultSet rs;
            ResultSet ps;
            try
            {
                rs = stmt.executeQuery(tempQuery);
                
                try
                {                    
                    tableUtils.updateTableModelData((DefaultTableModel) listDetails.getModel(), rs, 9);
                }
                catch (Exception ex)
                {
                    Logger.getLogger(ViewMember.class.getName()).log(Level.SEVERE, null, ex);
                }
            }
            catch(Exception e)
            {
            
            }
            
            try
            {
                ps = stmt.executeQuery(tempQuery);
                
                while(ps.next())
                {
                    total += ps.getFloat("mem_total");
                    textPayment.setText(String.valueOf(total));
                }
            }
            catch(Exception e)
            {
                
            }
            
            finally
            {
                this.disconnect();
            }
        }
        
        catch(Exception e)
        {
            
        }
    }