Making more than one reports to screen with list

[aborgeld]

I making one list i can use in different cases, which can take more than one output query and thats why i want
to make my own to string method.


The code:
And this is the most important code of this list, in the controller package:

  public void fillList2(Object[] objecten) {
    this.dbObjecten = objecten;

    ArrayList<String> fillList2 = new ArrayList<String>();
    for (int i=0; i < objecten.length; i++) {
      fillList2.add(uitl.toString2());
    }
    this.list.setListData(fillList2.toArray());
   
  }

One model class with
2 queries

  public static Uitleen[] getAllUitleningen() {
    return getUitleenRs(          "select      a.uitleen_id," +
                                                "a.uitleen_uitleendatum, "+
                                                "a.uitleen_vervaldatum, "+
                                                "a.uitleen_terugbrengdatum, "+
                                                "a.uitleen_bijzonderheden, "+
                                                "a.uitleen_boete, "+
                                                "a.lid_nummer, "+
                                                "b.lid_voorletters, "+
                                                "b.lid_achternaam, "+
                                                "a.speelgoed_code, "+
                                                "c.speelgoed_omschrijving "+
                                 "from          uitleen as a "+
                                                "join    lid as b "+
                                 "on            a.lid_nummer = b.lid_nummer "+
                                 "join          speelgoed as c "+
                                 "on            a.speelgoed_code = c.speelgoed_code ");
  }


  public static Uitleen [] getUitleenSpCode(String speelgCode) {
        return getUitleenRs(   "select          a.uitleen_id, "+
                                                "a.uitleen_uitleendatum, "+
                                                "a.uitleen_vervaldatum, "+
                                                "a.uitleen_terugbrengdatum, "+
                                                "a.uitleen_bijzonderheden, "+
                                                "a.uitleen_boete, "+
                                                "a.lid_nummer, "+
                                                "b.lid_voorletters, "+
                                                "b.lid_achternaam, "+
                                                "a.speelgoed_code, "+
                                                "c.speelgoed_omschrijving "+
                                 "from          uitleen as a "+
                                 "join          lid as b "+
                                 "on            a.lid_nummer = b.lid_nummer "+
                                 "join          speelgoed as c "+
                                 "on            a.speelgoed_code = c.speelgoed_code "+
                                 "where         a.speelgoed_code LIKE'%" + speelgCode + "%'");


   }

 private static Uitleen[] getUitleenRs(String query) {
         ResultSet r = Database.executeSelectQuery(query);


        int aantalUitleningen = Database.getAmountResultSet(r);
        Uitleen[] uitleningen = new Uitleen[aantalUitleningen];

        try {

            int teller  = 0;
            while (teller < aantalUitleningen) {

                Uitleen value = new Uitleen();
                value.speelgCode = r.getString("speelgoed_code");
                value.omschrijving = r.getString("speelgoed_omschrijving");
                value.uitleenDatum = r.getString("uitleen_uitleendatum");
                value.uitleenVervaldatum = r.getString("uitleen_vervaldatum");
                value.uitleenTerugbrengDatum = r.getString("uitleen_terugbrengdatum");
                value.uitleenBijzonderheden = r.getString("uitleen_bijzonderheden");
                value.uitleenBoete = r.getString("uitleen_boete");
                value.lidNummer = r.getString("lid_nummer");
                value.lidVoorletters = r.getString("lid_voorletters");
                value.lidAchternaam = r.getString("lid_achternaam");

                uitleningen[teller] = value;
                teller++;
                r.next();
            }
       }

     catch (SQLException e) {
      System.out.println("Uitleen: getUitleenSp: " + e.toString());
      System.out.println(e.getMessage() + "\n" + e.getSQLState() + "\n" + e.getErrorCode());
    }
    return uitleningen;
  }

My own toString method because i need one more toString method for the second query.

public  String  toString2() {


         String value  = "";
          value += JSqlList.setSpaces(getCode().toString(), 8);
           value += JSqlList.setSpaces(getOmschrijving().toString(), 12);
           value += JSqlList.setSpaces(getUitleenDatum().toString(), 18);
           value += JSqlList.setSpaces(getUitleenVervaldatum().toString(), 18);
           value += JSqlList.setSpaces(getUitleenTerugbrengDatum().toString(), 18);
           value += JSqlList.setSpaces(getUitleenBijzonderheden(), 20);
           value += JSqlList.setSpaces(getUitleenBoete().toString(), 30);
           value += JSqlList.setSpaces(getLidNummer().toString(), 5);
           value += JSqlList.setSpaces(getLidVoorletters().toString(), 5);
           value += JSqlList.setSpaces(getLidAchternaam().toString(), 18);
       


       return value;
  
    }

At last the view where i call my list:

 uitleenLijst.fillList2(uitl.getUitleenSpCode(speelgCode));

[aborgeld]

I get a nullpointer exception. I think it begins at my own ToString method: value.speelgCode = r.getString("speelgoed_code");
Can anybody please have a look at what i'm doing wrong.


run:
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
at model.Uitleen.toString2(Uitleen.java:358)
at componenten.JSqlList.fillList2(JSqlList.java:44)
at view.UitleningenPerSpeelgoed.<init>(UitleningenPer Speelgoed.java:29)
at view.Overzichten.uitlPerSpeelgoedButtonActionPerfo rmed(Overzichten.java:84)
at view.Overzichten.access$000(Overzichten.java:18)
at view.Overzichten$1.actionPerformed(Overzichten.jav a:43)
at javax.swing.AbstractButton.fireActionPerformed(Abs tractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed (AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed (DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultB uttonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseRe leased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.jav a:6267)
at javax.swing.JComponent.processMouseEvent(JComponen t.java:3267)
at java.awt.Component.processEvent(Component.java:603 2)
at java.awt.Container.processEvent(Container.java:204 1)
at java.awt.Component.dispatchEventImpl(Component.jav a:4630)
at java.awt.Container.dispatchEventImpl(Container.jav a:2099)
at java.awt.Component.dispatchEvent(Component.java:44 60)
at java.awt.LightweightDispatcher.retargetMouseEvent( Container.java:4577)
at java.awt.LightweightDispatcher.processMouseEvent(C ontainer.java:4238)
at java.awt.LightweightDispatcher.dispatchEvent(Conta iner.java:4168)
at java.awt.Container.dispatchEventImpl(Container.jav a:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2478 )
at java.awt.Component.dispatchEvent(Component.java:44 60)
at java.awt.EventQueue.dispatchEvent(EventQueue.java: 599)
at java.awt.EventDispatchThread.pumpOneEventForFilter s(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(E ventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarch y(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispa tchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispa tchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThre ad.java:122)
BUILD SUCCESSFUL (total time: 6 seconds)

[aborgeld]

With the code in this post (standard) and standard overriding ToString it works, but only with one query. I want to show it on screen like a report in one window.
But i need two queries and thats why i want to use my own toString, so i can create a ToString1 and ToString2 with different fields to set from the database

  
private Object[] dbObjecten;

 public void fillList(Object[] objecten) {
    this.dbObjecten = objecten;

    ArrayList<String> fillList = new ArrayList<String>();
    for (Object o : dbObjecten) {
      fillList.add(o.toString());      
    }
    this.list.setListData(fillList.toArray());
  }