get multiple value

[raya jaya]

hello,
when i execute this code, it just give me one studentID number

try {
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection con = DriverManager.getConnection("jdbc:odbc:StudentManagement");

    Statement st = con.createStatement();
    ResultSet rs = st.executeQuery("SELECT studentID FROM marking WHERE lectName ="+"'"+lctName+"'");
    if (rs.next()) {
        ID.addItem(rs.getString(1));
  
    }

how cn i get more than one number of studentID

[Added code tags - see UseCodeTags for details]

[William P O'Sullivan]

Welcome raya,

Sorry to be honest, It seems you need to do some more basic Java programming.

Your if statement is working fine. The result set has a "next" (or first) record,
you add it to the collection, then leave the if. There could be 10000 more results.

Try reading about loops and in particular the "while" statement.

WP

[raya jaya]

thank you