fetching database values into a textarea with jsp page

[vishal prada]

hi
i have a problem about to fetch the value into the textarea with jsp page which contains characters and symbols also

there is one textarea tag field on my jsp form and i want to retrieve value for that textarea tag field from mysql database.
same if i use <input type...> tag then all is well done but is problems with only textarea tag.
what to do for retrieve the value ..?
plz help me.
with regard

[r035198x]

You put the value between the text area tag

<textarea name='textAreaName' id='textAreaId'>
<c:out value="${variableWithTheValue}"/>
 
</textarea>

[vishal prada]

hi ro35198x thankx for ur quick response.
actually i am beginner in java with jsp so i need to create one profile editing form where some input, textarea, and some dropdown fields are there and want to retrieve value from mysql database for that fields.
now plz can u give me one demo example then i think i will be get right way to code .
plz r035198x
with regard

[r035198x]

Use JSF as explained here:http://docs.oracle.com/javaee/6/tutorial/doc/bnadp.html

[vishal prada]

i am using mysql database for this .
then how to do that ?

[r035198x]

You write a data access layer that connects to the database to give you back the results.
The easiest way is to use JPA/Hibernate because then you don't have to write any SQL and your code should work on any database.
If JPA is not an option then write write your own data access layer using JDBC which returns DTOs that you use in your JSPs' backing beans.

[vishal prada]

sir i am beginner all these things which u r suggest me i can't understand there is any easy way ?
or if possible then plz send me one demo example which is use to retrieve database value from mysql with jsp form.
or like edit profile code.
plz.

[r035198x]

You need to spend time reading about all these things that you need to use before writing the application then.
Here is a useful blog for JSF: http://balusc.blogspot.com/2008/10/e...d-sorting.html

[vishal prada]

ya u r right r035198x.
and r035198x i use ur suggested syntax for value retrieve and it's work perfectly ,
thank you very much .
plz suggest me what to do best practice for jsp programmer i like to work in it.
and finally i retrieve the values so i am very happy.
again thanks but one more problem is there what about dropdown box how to retrieve values on form from mysql....?
best regard

[r035198x]

Generally you should prefer developing web applications with JSF/Facelets these days according to the EE6 spec.

You display select options using a <c:foreach tag that loops through a collection of objects. In the loop you create the select options and display them, something like

<select name="selectName"> 
   <c:forEach var="listItem" items="${list}" >
     <option value="${listItem.id}"> 
          <c:out value="${listItem.name}" />
     </option>
   </c:forEach>
</select>