<div>
<div class="content wysiwyg-content">
Hello I am using &lt;sql:query&gt; along with &lt;c:forEach&gt; tag to display contents of a database table. It works fine.<br />
But now i want to format the numeric values returned from the Select statement.<br />
<br />
<br />
for example. In the code below the col1 values returned from sql are numeric without any 1000 separator commas. Eg 1000, 10000, 1000000 etc.<br />
<br />
I want to format them to display 1000 separator commans i.e 1,000, 10,000, 1000,000 etc. How can I do it ?<br />
<br />
&lt;sql:query&gt; ...&lt;/sql:query&gt;<br />
&lt;TABLE&gt;<br />
&lt;c:forEach&gt;<br />
&nbsp; &lt;tr&gt;<br />
&nbsp; &nbsp; &nbsp;&lt;td&gt;&lt;c:out value=&quot;${row.col1}&quot; /&gt;&lt;/td&gt;<br />
&nbsp; &nbsp;&lt;/tr&gt;<br />
<br />
&lt;/c:forEach&gt;<br />
&lt;/TABLE&gt;
</div>
</div>


Hello I am using <sql:query> along with <c:forEach> tag to display contents of a database table. It works fine.
But now i want to format the numeric values returned from the Select statement.


for example. In the code below the col1 values returned from sql are numeric without any 1000 separator commas. Eg 1000, 10000, 1000000 etc.

I want to format them to display 1000 separator commans i.e 1,000, 10,000, 1000,000 etc. How can I do it ?

<sql:query> ...</sql:query>
<TABLE>
<c:forEach>
  <tr>
     <td><c:out value="${row.col1}" /></td>
   </tr>

</c:forEach>
</TABLE>

Number format is JSP when using JSTL &lt;sql:query&gt; along with &lt;c:forEach&gt; tag. Simple  beginners question !!

Java Enterprise Edition (Java EE) is a specification defining a collection of Java-based server and client technologies and how they interoperate. Java EE specifies server and client architectures and uses profiles to define technology sets targeted at specific classes of applications. All Java EE profiles share a set of common features, such as naming and resource injection, packaging rules and security requirements.

Java EE

JavaServer Pages (JSP) allow the development of dynamically generated web pages. It uses the Java programming language; JSP pages are translated into servlets at runtime, with each servlet being cached and reused until the JSP is modified. JSP allows Java code to be interleaved with static web markup content, so the resulting page can be compiled and executed on the server to deliver the content.

Number format is JSP when using JSTL &lt;sql:query&gt; along with &lt;c:forEach&gt; tag. Simple beginners question !!

Number format is JSP when using JSTL <sql:query> along with <c:forEach> tag. Simple beginners question !!