Book Image

Java EE 5 Development with NetBeans 6

Book Image

Java EE 5 Development with NetBeans 6

Overview of this book

Table of Contents (17 chapters)
Java EE 5 Development with NetBeans 6
Credits
About the Author
About the Reviewers
Preface
Identifying Performance Issues with NetBeans Profiler

SQL JSTL Tags


JSTL includes an SQL tag library that allows us to quickly and easily write web applications that interact with a relational database. NetBeans supports the most commonly used tags in the SQL tag library, allowing us to use these tags by simply dragging them from its palette into our JSP pages.

Note

All JSTL tags are supported in NetBeans, however only a subset of them is available in the NetBeans palette to be dropped in our JSPs. For tags not included in the palette, we simply need to type the appropriate tag in the page markup.

Although SQL JSTL tags allow us to quickly create web applications that interact with a database, they tend to create applications that are hard to maintain, since they mix database access with display logic. For this reason, these tags are suitable for prototyping and for "throwaway" applications.

In order to successfully use the SQL JSTL tags, we need to create a connection pool and data source in the application server we are using to deploy our...