public void getListDetails(String id)
    {
        float total = 0;
        float totalInterest = 0;
        float payment1 = 0;
        float payment2 = 0;
        try
        {
            String tempQuery = "select TO_DATE(amordate, 'YYYY-MM-DD') as monthly_schedule,mon_amort as monthly_payment,mon_interest as interest, mon_premium as premium from loan_dtl where loanid="+id+" order by amordate";
        
            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
                {                    
                    commonUtils.updateTableModelData((DefaultTableModel) listDetails.getModel(), rs, 4);
                }
                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("monthly_payment");
                    totalInterest += ps.getFloat("interest");
                    
                    payment1 = total;
                    payment2 = totalInterest;
                }
            }
            catch(Exception e)
            {
                
            }
            
            finally
            {
                this.disconnect();
            }
        }
        
        catch(Exception e)
        {
            
        }
        
        payment1 = (float) (Math.round(payment1 * 100.00) / 100.00);
        payment2 = (float) (Math.round(payment2 * 100.00) / 100.00);
        
        textPayment.setText(String.valueOf(payment1));
        textPayment1.setText(String.valueOf(payment2));
    }