Results 1 to 1 of 1
- 11-01-2008, 11:24 AM #1
Member
- Join Date
- Nov 2008
- Posts
- 1
- Rep Power
- 0
how to populate data in drop-down box
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.
Similar Threads
-
drop down menu
By mike eriksen in forum AWT / SwingReplies: 2Last Post: 06-19-2008, 07:33 AM -
How to use a drop-down box in Struts
By piterskiy74 in forum Web FrameworksReplies: 1Last Post: 02-13-2008, 11:42 AM -
Drop down menu
By BenNeiderlander in forum New To JavaReplies: 3Last Post: 02-05-2008, 07:35 AM -
Drag and drop
By abhivenugopal in forum JavaServer Pages (JSP) and JSTLReplies: 0Last Post: 01-30-2008, 02:10 PM -
how to populate html:select with values from database
By sathya_k_83 in forum JavaServer Pages (JSP) and JSTLReplies: 1Last Post: 11-07-2007, 10:53 AM


LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks