Learn how to create a simple web application that connects to a MySQL database server in a tutorial authored by Troy Giunipero, who also covers other web development technologies in his piece, such as JavaServer Pages (JSP), JavaServer Pages Standard Tag Library (JSTL), the Java Database Connectivity (JDBC) API, and two-tier, client-server architecture.

Content applies to NetBeans IDE 6.8, and is divided into the following sections:

• Planning the Structure
• Creating a New Project
• Preparing the Web Interface: Setting up the welcome page, creating the response page, creating a stylesheet
• Preparing Communication between the Application and Database: Setting up a JDBC data source and connection pool, referencing the data source from the application, adding the database driver's JAR file to the server
• Adding Dynamic Logic: Adding the JSTL library to the project's classpath, implementing JSTL code
• Running the Completed Application
• Troubleshooting covers these questions: Do database resources exist? Do the connection pool and data source exist on the server? Is the MySQL Connector/J driver accessible to GlassFish? Is the database password-protected? Are the connection pool properties correctly set?

Users should also have this software in order to complete the tutorial:

• Java Development Kit (JDK) version 5 or 6
• MySQL database server version 5.x
• MySQL Connector/J JDBC Driver version 5.x
• GlassFish application server v3

This tutorial is designed for beginners who have a basic understanding of web development and are looking to apply their knowledge using a MySQL database.

More Information

Creating a Simple Web Application Using a MySQL Database - Giunipero's tutorial

NetBeans IDE 6.8 Download

Details on NetBeans 6.8 [...read more...]

		fullsource
Print Email Current Profile Archive Blog Generate newsletter