A servlet runs a connection class to get a set of drawing numbers from an AS400 file. I want to display the result set in a pick list on a JSP so the user can get the detail info from a selected item in the list.
So far I have a java servlet that calls a class which makes a connection to the AS400 file and runs SQL statement bases on user input. I store the result set to an array using the rs.getArray(colName). Then the servlet opens the JSP which so far is blank. But I want to have a list on it of the array values which a user can select desired item and the details of that item will be displayed on another JSP.