ResultSet is only returning one row while database has more rows java/sql

Question

the problem i am facing is that my result set is only returning one row value while there are three. and i could not found where the problem is:

  public void eventInfo() throws SQLException
    {
     openConnection();
    PreparedStatement ps1=null;

    String query1="select * from events";

    try {
        ps1 = con.prepareStatement(query1);
    } catch (SQLException ex) {
        Logger.getLogger(Database.class.getName()).log(Level.SEVERE, null, ex);
    }





            EventData e= new EventData();
            e.edata.clear();
            Events obj = new Events();

    ResultSet s=ps1.executeQuery();
    int i=0;

            System.out.println(s);

    if(s.next())
    {
//                        obj.setId(s.getInt("id"));
//          obj.setTitle(s.getString("title"));
//          obj.setDescription(s.getString("description"));
//          
//          obj.setType(s.getString("type"));
//          obj.setOrganization(s.getString("organization"));
 //         obj.setPlace(s.getString("place"));
 //         obj.setTime(s.getString("time"));
 //         obj.setDate(s.getString("date"));
 //         obj.setRepetetion(s.getString("repetetion"));
 //         obj.setParticipants(s.getInt("participants"));
 //         obj.setLimit(s.getInt("elimit"));

                    System.out.println(i);
                    System.out.println(s.getString("title"));
                    i++;

                 //   e.edata.add(obj);


    }


    if(con!=null)
    {
        con.close();
    }

    }

the database tables like enter image description here

the output looks like enter image description here

can anyone help me with that?

Smutje · Accepted Answer · 2020-05-20 11:35:27Z

3

It should not surprise you that

if(s.next())

is not a loop but rather a condition. If you want to continuously access the result set you have to use a loop

while (s.next())

answered May 20, 2020 at 11:35

Smutje

18.2k4 gold badges26 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Usama Munir Over a year ago

Thank you so much...i just ignored that... thank you so much

Bartosz Walusiak · Accepted Answer · 2020-05-20 11:35:55Z

1

while (s.next()) {...}

...should do it for you. This will iterate through all rows.

answered May 20, 2020 at 11:35

Bartosz Walusiak

601 silver badge8 bronze badges

1 Comment

Usama Munir Over a year ago

Thank sir ... i got the result now

Collectives™ on Stack Overflow

ResultSet is only returning one row while database has more rows java/sql

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related