Advanced JavaServer Pages™

Chapter 10. DATABASES

Topics in this Chapter

• Database Creation

• Database Custom Tags

  • The Query Tag

  • The ColumnNames Tag

  • The Rows Tag

  • The Release Tag

  • The Release Tag

• Connection Pooling

  • Using a Connection Pool

  • Implementing a Simple Connection Pool

• Prepared Statements

• Transactions

• Scrolling Through Result Sets

The vast majority of commercial web sites are driven by relational databases. Servlets and JSP pages are excellent choices for database access because they can use JDBC (Java Database Connectivity), which provides a simple and portable way to access databases. Additionally, the servlet life cycle allows servlets and JSP pages to maintain database connections that span multiple requests. Because of the overhead involved in creating a database connection, the ...