I want to fetch data from mysql and populate in dropdown box.
I used JSTL in jsp. I want to fetch name from User table and populate in firstName Listbox in jsp


My code is
<sql:setDataSource var="dataSource" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/example" user="example" password="example" />


<sql:query var="item" dataSource="${dataSource}">
select user_id,name from User;
</sql:query>


<td><select style="DISPLAY: block" size="1" id="dLbox"
name="firstName">

<c:forEach var="row" items="${item.rows}">
<option value="${row.user_id}">${row.name}</option>

</c:forEach>
</select>


The datas are displayed as row.name. It can't fetch data.

Please help me.