Returning multiple results in JDBC

i want to get multple data from specific criteria from by mysql , however i'm only getting the first row that meets the criteria ere is the code:

Code:

---

try
                {
                        Connection con = DriverManager.getConnection("jdbc:mysql://localhost/?","?","?");
                        Statement stat = con.createStatement ();
                        ResultSet rs = stat.executeQuery("SELECT * FROM ncu_courses WHERE user_name='" + userName +"'");
                       
                        while (rs.next ())
                        {
                                int x = 0;
                                currentCourses[x] = rs.getString("course");
                                lecturer [x] = rs.getString("lecturer");
                                time [x] = rs.getString("time");
                                day [x] = rs.getString("day");
                                x++;
                        }
                }
               
                catch (SQLException e)
                {
                        System.out.println ("SQL Error " +e.getMessage ());
                        e.printStackTrace ();
                }

---

You put this line in the wrong place:

Code:

---

int x = 0;

---

Quote:

---

Originally Posted by JeffGrigg

You put this line in the wrong place:

Code:

---

int x = 0;

---

---

ok but i don't think that's the problem

Quote:

---

Originally Posted by mDennis10

ok but i don't think that's the problem

---

Well, it is; put that line above your while loop and see for yourself.

kind regards,

Jos

Quote:

---

Originally Posted by mDennis10

ok but i don't think that's the problem

---

Hint: It's why this line isn't doing anything useful:

Code:

---

x++;

---

You increment the value of X, but then you set it right back to 0 when the loop begins agian.

Unrelated to this, but learn about PreparedStatements as this should really be one:

Code:

---

                        Statement stat = con.createStatement ();
                        ResultSet rs = stat.executeQuery("SELECT * FROM ncu_courses WHERE user_name='" + userName +"'");

---

Also read up on SQL injection as to one of several reasons why you should.

Quote:

---

Originally Posted by Willriker

You increment the value of X, but then you set it right back to 0 when the loop begins agian.

---

yes your right didn't realize that i was doing that