Hi all, I am using JSTL SQL tags for populating some form elements in my JSP. It is noted that it should not be used SQL tags for performance or some thing else. I found that its very easy way to populating the elements. My doubt is why dont I have to use SQL tags. Please anybody clearify my doubt. thanks in advance
Because it is bad form to put database (DB) access code in a JSP.
Even with the JSTL tags, you lose the separation of concerns that you would get if you put your db code in Javabeans. Moving all of this code to beans will allow you to add a main method and run all of your initial tests right from the command line. You can later call these methods from unit/integration testing scripts for regression testing.