How to pass variable from Mysql to Jsp

Question

shella 0 Light Poster

16 Years Ago

Hi all. I'm new with jsp and i'm just looking for create a login solution.
I use a mysql database and what i'm looking for is what follows:

Make a query to my sql database and then insert the output of one field in a variable.
I need this variable to pass the "id" to a form ... maybe with this code i will explain better.

/* part of the page with sql query

<sql:setDataSource
	url="jdbc:mysql://localhost/table"
	driver="com.mysql.jdbc.Driver"
	user="user"
	password="password" />
	
	<sql:query var="userdb" >
	SELECT * FROM table	WHERE etc etc...%>'
	</sql:query>

And the query work... so I get what i need with the following:

<c:forEach items="${userdb.rows}" var="blogs" >
<tr>
<td> <c:out value="${blogs.title}" /> </td>
<td> <c:out value="${blogs.description}" /> </td>
<td> <c:out value="${blogs.surname}" /> </td>
<td> <c:out value="${blogs.email}" /> </td>
<td> <c:out value="${blogs.id_user}" /> </td>

</tr>
</c:forEach>

And so everythings works...
The problem is that the:

<td> <c:out value="${blogs.id_user}" /> </td>

contains an output that i want to forward to a page with a form so that I can get the form pre-filled with the id_user... I tried with:

<c:set var="id_user" value="${blogs.id_user}" />

...but when i go to the page that contain:

[...]
<input type="hidden" name="id_user" value="<% out.write(id_user); %>" />
[...]

nothing works and no variable is passed to the form... i get errors of course...
I don't know how to manage this variables from mysql to jsp, can somebody help me please?
I hope that what i wrote was not too confused!
Thanks to all!

Shella.

java-jsp mysql

3 Contributors
2 Replies
421 Views
1 Year Discussion Span
Latest Post 14 Years Ago Latest Post by peter_budo

peter_budo 2,532 Code tags enforcer

14 Years Ago

Well done you solved 2 years old mystery.

Thread closed

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

pradeep42 0 Newbie Poster · Answer 1 · 2010-05-03T13:34:33+00:00

just add ur datasource in to the context.xml of server add check , i hope it works finee

Hi all. I'm new with jsp and i'm just looking for create a login solution.
I use a mysql database and what i'm looking for is what follows:
Make a query to my sql database and then insert the output of one field in a variable.
I need this variable to pass the "id" to a form ... maybe with this code i will explain better.
/* part of the page with sql query
<sql:setDataSource
	url="jdbc:mysql://localhost/table"
	driver="com.mysql.jdbc.Driver"
	user="user"
	password="password" />
	
	<sql:query var="userdb" >
	SELECT * FROM table	WHERE etc etc...%>'
	</sql:query>
And the query work... so I get what i need with the following:
<c:forEach items="${userdb.rows}" var="blogs" >
<tr>
<td> <c:out value="${blogs.title}" /> </td>
<td> <c:out value="${blogs.description}" /> </td>
<td> <c:out value="${blogs.surname}" /> </td>
<td> <c:out value="${blogs.email}" /> </td>
<td> <c:out value="${blogs.id_user}" /> </td>

</tr>
</c:forEach>
And so everythings works...
The problem is that the:
<td> <c:out value="${blogs.id_user}" /> </td>
contains an output that i want to forward to a page with a form so that I can get the form pre-filled with the id_user... I tried with:
<c:set var="id_user" value="${blogs.id_user}" />
...but when i go to the page that contain:
[...]
<input type="hidden" name="id_user" value="<% out.write(id_user); %>" />
[...]
nothing works and no variable is passed to the form... i get errors of course...
I don't know how to manage this variables from mysql to jsp, can somebody help me please?
I hope that what i wrote was not too confused!
Thanks to all!
Shella.