Murach's Java Servlets and JSPThis chapter shows how to code a Java servlet that works with a MySQL database. Along the way, it shows how to use the JDBC API and how to implement connection pooling. |
||
| Chapter 11 | How to use Java to work with a database | |
| How to work with JDBC | 334 | |
| How to obtain and install a database driver | 334 | |
| How to connect to a database | 336 | |
| How to return a result set and move the cursor through it | 338 | |
| How to retrieve data from a result set | 340 | |
| How to insert, update, and delete data | 342 | |
| How to work with prepared statements | 344 | |
| The SQL Gateway application | 346 | |
| The user interface | 346 | |
| The code for the JSP | 348 | |
| The code for the servlet | 350 | |
| The code for the utility class | 354 | |
| How to work with connection pooling | 356 | |
| How connection pooling works | 356 | |
| How to install a connection pool | 358 | |
| How to customize a connection pool | 358 | |
| How to use a connection pool | 360 | |
| The Email List application | 362 | |
| The user interface | 362 | |
| The code for the JSP | 362 | |
| The code for the servlet | 364 | |
| The code for the UserDB class | 366 | |
| t | ||
|
© Copyright 1998-2008 Mike Murach & Associates, Inc. All rights reserved. |
||
|
