New MySQL adopters, and maybe even more seasoned users, should visit the NetBeans Website, which is hosting a tutorial on creating a simple web application that connects to a MySQL database server. The tutorial, which is expected to take users about 30 minutes, also covers some basic ideas and technologies in web development, such as JavaServer Pages (JSP), JavaServer Pages Standard Tag Library (JSTL), the Java Database Connectivity (JDBC) API and two-tier, client-server architecture.
A continuance of the tutorial Connecting to a MySQL Database, this next installment assumes readers have a connection to a MySQL database created and registered in NetBeans IDE.
To successfully complete this tutorial, table data included in ifpwafcad.sql. is required. This SQL file creates two tables, Subject and Counselor, then populates them with sample data. Save this file to a local directory, then open it in NetBeans IDE and run it on the MySQL database. The database used in this tutorial is named MyNewDatabase.
The tutorial will cover the following topics:
- Getting the Software
- Planning the Structure
- Creating a New Project
- Preparing the Interface
- Setting up a Connection Pool: Setting up a JNDI Datasource, Referencing the Datasource from the Application and Adding the Database Driver's JAR File to the Server
- Adding Dynamic Logic: Adding the JSTL Library to the Project's Classpath, Adding taglib Directives to the JSP Pages, and Adding JSP and JSTL Code
- Deploying and Running the Project
Interested readers see Creating a Simple Web Application Using a MySQL Database
[...read more...]