How to populate JTable using Hibernate?





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}







0















I am creating a simple application using Swing and Hibernate. I want to populate into a JTable, the list returned by HQL query in Hibernate. Please tell me where I am doing wrong.



List<Employee> employee= (List<Employee>)sess.createQuery("from Employee where ID<10").list();
String rows= {"Book Tile","Author","Price"};
for(Employee e:employee) {
String cols= {{e.getFirstName(),e.getLastName(),Double.toString(e.getSalary())},};
DefaultTableModel dtm = new DefaultTableModel(cols,rows);
table.setModel(dtm);
}


I expected to find a table containing all rows returned by HQL, but instead i am finding only the last row each time i run my application










share|improve this question































    0















    I am creating a simple application using Swing and Hibernate. I want to populate into a JTable, the list returned by HQL query in Hibernate. Please tell me where I am doing wrong.



    List<Employee> employee= (List<Employee>)sess.createQuery("from Employee where ID<10").list();
    String rows= {"Book Tile","Author","Price"};
    for(Employee e:employee) {
    String cols= {{e.getFirstName(),e.getLastName(),Double.toString(e.getSalary())},};
    DefaultTableModel dtm = new DefaultTableModel(cols,rows);
    table.setModel(dtm);
    }


    I expected to find a table containing all rows returned by HQL, but instead i am finding only the last row each time i run my application










    share|improve this question



























      0












      0








      0








      I am creating a simple application using Swing and Hibernate. I want to populate into a JTable, the list returned by HQL query in Hibernate. Please tell me where I am doing wrong.



      List<Employee> employee= (List<Employee>)sess.createQuery("from Employee where ID<10").list();
      String rows= {"Book Tile","Author","Price"};
      for(Employee e:employee) {
      String cols= {{e.getFirstName(),e.getLastName(),Double.toString(e.getSalary())},};
      DefaultTableModel dtm = new DefaultTableModel(cols,rows);
      table.setModel(dtm);
      }


      I expected to find a table containing all rows returned by HQL, but instead i am finding only the last row each time i run my application










      share|improve this question
















      I am creating a simple application using Swing and Hibernate. I want to populate into a JTable, the list returned by HQL query in Hibernate. Please tell me where I am doing wrong.



      List<Employee> employee= (List<Employee>)sess.createQuery("from Employee where ID<10").list();
      String rows= {"Book Tile","Author","Price"};
      for(Employee e:employee) {
      String cols= {{e.getFirstName(),e.getLastName(),Double.toString(e.getSalary())},};
      DefaultTableModel dtm = new DefaultTableModel(cols,rows);
      table.setModel(dtm);
      }


      I expected to find a table containing all rows returned by HQL, but instead i am finding only the last row each time i run my application







      java hibernate swing jtable hql






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Jan 7 at 2:30









      Andrew Thompson

      154k29165349




      154k29165349










      asked Jan 3 at 21:18









      Khalif DirieKhalif Dirie

      1




      1
























          2 Answers
          2






          active

          oldest

          votes


















          1















          but instead i am finding only the last row each time i run my application




          That is because you keep creating a new TableModel each time you iterate through the for loop.



          What you need to do is:




          1. create an empty table model outside the loop

          2. in the loop you add new rows of data to the model.

          3. when the loop finishes, you create the table with your model.


          So the logic would be something like:



          DefaultTableModel dtm = new DefaultTableModel(cols, 0);

          for(Employee e:employee)
          {
          String row= {e.getFirstName(), e.getLastName(), Double.toString(e.getSalary())};
          dtm.addRow( row );
          }

          table.setModel(dtm);





          share|improve this answer
























          • Thank you sir , i will check let you know the feedback

            – Khalif Dirie
            Jan 4 at 7:13











          • Much appreciated. Great it worked on the fly. Thank you sir

            – Khalif Dirie
            Jan 10 at 18:54











          • @KhalifDirie, glad it helped. Don't forget to "accept" the answer so people know the problem has been solved.

            – camickr
            Jan 10 at 19:34



















          0














          On each iteration you are replacing datamodel instance with other with the current object. Instead you must declare array with list size, after populate it with list resukls and Last, outside of for, create datamodel and asign it to jtable.






          share|improve this answer
























            Your Answer






            StackExchange.ifUsing("editor", function () {
            StackExchange.using("externalEditor", function () {
            StackExchange.using("snippets", function () {
            StackExchange.snippets.init();
            });
            });
            }, "code-snippets");

            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "1"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














            draft saved

            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54029937%2fhow-to-populate-jtable-using-hibernate%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            2 Answers
            2






            active

            oldest

            votes








            2 Answers
            2






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            1















            but instead i am finding only the last row each time i run my application




            That is because you keep creating a new TableModel each time you iterate through the for loop.



            What you need to do is:




            1. create an empty table model outside the loop

            2. in the loop you add new rows of data to the model.

            3. when the loop finishes, you create the table with your model.


            So the logic would be something like:



            DefaultTableModel dtm = new DefaultTableModel(cols, 0);

            for(Employee e:employee)
            {
            String row= {e.getFirstName(), e.getLastName(), Double.toString(e.getSalary())};
            dtm.addRow( row );
            }

            table.setModel(dtm);





            share|improve this answer
























            • Thank you sir , i will check let you know the feedback

              – Khalif Dirie
              Jan 4 at 7:13











            • Much appreciated. Great it worked on the fly. Thank you sir

              – Khalif Dirie
              Jan 10 at 18:54











            • @KhalifDirie, glad it helped. Don't forget to "accept" the answer so people know the problem has been solved.

              – camickr
              Jan 10 at 19:34
















            1















            but instead i am finding only the last row each time i run my application




            That is because you keep creating a new TableModel each time you iterate through the for loop.



            What you need to do is:




            1. create an empty table model outside the loop

            2. in the loop you add new rows of data to the model.

            3. when the loop finishes, you create the table with your model.


            So the logic would be something like:



            DefaultTableModel dtm = new DefaultTableModel(cols, 0);

            for(Employee e:employee)
            {
            String row= {e.getFirstName(), e.getLastName(), Double.toString(e.getSalary())};
            dtm.addRow( row );
            }

            table.setModel(dtm);





            share|improve this answer
























            • Thank you sir , i will check let you know the feedback

              – Khalif Dirie
              Jan 4 at 7:13











            • Much appreciated. Great it worked on the fly. Thank you sir

              – Khalif Dirie
              Jan 10 at 18:54











            • @KhalifDirie, glad it helped. Don't forget to "accept" the answer so people know the problem has been solved.

              – camickr
              Jan 10 at 19:34














            1












            1








            1








            but instead i am finding only the last row each time i run my application




            That is because you keep creating a new TableModel each time you iterate through the for loop.



            What you need to do is:




            1. create an empty table model outside the loop

            2. in the loop you add new rows of data to the model.

            3. when the loop finishes, you create the table with your model.


            So the logic would be something like:



            DefaultTableModel dtm = new DefaultTableModel(cols, 0);

            for(Employee e:employee)
            {
            String row= {e.getFirstName(), e.getLastName(), Double.toString(e.getSalary())};
            dtm.addRow( row );
            }

            table.setModel(dtm);





            share|improve this answer














            but instead i am finding only the last row each time i run my application




            That is because you keep creating a new TableModel each time you iterate through the for loop.



            What you need to do is:




            1. create an empty table model outside the loop

            2. in the loop you add new rows of data to the model.

            3. when the loop finishes, you create the table with your model.


            So the logic would be something like:



            DefaultTableModel dtm = new DefaultTableModel(cols, 0);

            for(Employee e:employee)
            {
            String row= {e.getFirstName(), e.getLastName(), Double.toString(e.getSalary())};
            dtm.addRow( row );
            }

            table.setModel(dtm);






            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered Jan 3 at 21:27









            camickrcamickr

            277k16127241




            277k16127241













            • Thank you sir , i will check let you know the feedback

              – Khalif Dirie
              Jan 4 at 7:13











            • Much appreciated. Great it worked on the fly. Thank you sir

              – Khalif Dirie
              Jan 10 at 18:54











            • @KhalifDirie, glad it helped. Don't forget to "accept" the answer so people know the problem has been solved.

              – camickr
              Jan 10 at 19:34



















            • Thank you sir , i will check let you know the feedback

              – Khalif Dirie
              Jan 4 at 7:13











            • Much appreciated. Great it worked on the fly. Thank you sir

              – Khalif Dirie
              Jan 10 at 18:54











            • @KhalifDirie, glad it helped. Don't forget to "accept" the answer so people know the problem has been solved.

              – camickr
              Jan 10 at 19:34

















            Thank you sir , i will check let you know the feedback

            – Khalif Dirie
            Jan 4 at 7:13





            Thank you sir , i will check let you know the feedback

            – Khalif Dirie
            Jan 4 at 7:13













            Much appreciated. Great it worked on the fly. Thank you sir

            – Khalif Dirie
            Jan 10 at 18:54





            Much appreciated. Great it worked on the fly. Thank you sir

            – Khalif Dirie
            Jan 10 at 18:54













            @KhalifDirie, glad it helped. Don't forget to "accept" the answer so people know the problem has been solved.

            – camickr
            Jan 10 at 19:34





            @KhalifDirie, glad it helped. Don't forget to "accept" the answer so people know the problem has been solved.

            – camickr
            Jan 10 at 19:34













            0














            On each iteration you are replacing datamodel instance with other with the current object. Instead you must declare array with list size, after populate it with list resukls and Last, outside of for, create datamodel and asign it to jtable.






            share|improve this answer




























              0














              On each iteration you are replacing datamodel instance with other with the current object. Instead you must declare array with list size, after populate it with list resukls and Last, outside of for, create datamodel and asign it to jtable.






              share|improve this answer


























                0












                0








                0







                On each iteration you are replacing datamodel instance with other with the current object. Instead you must declare array with list size, after populate it with list resukls and Last, outside of for, create datamodel and asign it to jtable.






                share|improve this answer













                On each iteration you are replacing datamodel instance with other with the current object. Instead you must declare array with list size, after populate it with list resukls and Last, outside of for, create datamodel and asign it to jtable.







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Jan 3 at 21:25









                lugolulugolu

                4615




                4615






























                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Stack Overflow!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54029937%2fhow-to-populate-jtable-using-hibernate%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    Monofisismo

                    Angular Downloading a file using contenturl with Basic Authentication

                    Olmecas