Enabling entire column of database as options in dropdown list

Question

The code I have written gives me the output of only a single data in the drop down list. I want my drop down list to retrieve and hold all the data of the fname and userid column of the table. I am using struts concept and JSP. Kindly help as to how I should modify my code?

 public String subjectAllocation2()throws Exception
  {
   try{

       Map session=ActionContext.getContext().getSession();
       Long idd=(Long)session.get("USERID");

       System.out.println("sss"+idd);
      ResultSet rs=ConnectionDb.getStatement().executeQuery("select USERID,FNAME from    DIP_FACULTY"); 
       ResultSetMetaData metaData = rs.getMetaData();
        int columns = metaData.getColumnCount();
       ArrayList al = new ArrayList();
       while(rs.next())
       {

          for (int i = 1; i <= columns; i++)
           {
             String value1 = rs.getString(i);
               al.add(value1);
           }
       setUserid(rs.getString(1));
       setFname(rs.getString(2));
       System.out.println("The details="+rs.getString(1)+rs.getString(2)); 

        }
       catch(Exception e)
        {
        System.out.println("exception");
         }
       return "subjectAllocation2";
         }

and this is the JSP code

<s:form action="addSubject" method="post"  enctype="multipart/form-data">
                <table border="1" cellpadding="15" width="300">

                <tr><td><s:combobox name="semestar" label="Semestar" list="{'1st','2nd','3rd','4th','5th','6th','7th','8th'}"></s:combobox></td>
                <td><s:combobox name="branch" label="Branch" list="{'CSE','IT','EEE','ETC','MECH','EE','CIVIL'}"></s:combobox></td>
                <td><s:radio name="section" label="Section" list="{'A','B'}"/></td></tr>
                <tr><td>

                    <s:select name="fname" label="Faculty name" list="fname"></s:select>

                </td></tr>
            <tr><td><s:combobox name="userid" label="Faculty id" list="userid"></s:combobox></td></tr>
            <tr><td><s:combobox name="subject" label="Subject Name" list="{'Software Engineering','Soft Computing','Computer Graphics','Real Time System','Introduction To Digital Signal Processing','Entreprenaurship Development'}"></s:combobox></td></tr>
                <tr><td><s:select name="sub_code" label="Subject Code" list="{'PCS098','HCS232','WQ1232','PNB342','WQW232','QAZ213'}"></s:select></td></tr>
                <s:checkbox name="theory" label="Theory"></s:checkbox>
                <s:checkbox name="practical" label="Practical"></s:checkbox>





                <tr><td><s:submit value="allocate"/></td><td><s:submit action="reset" value="Reset"/></td></tr>



                </table>
        </s:form>
        <s:property value="msg"/>