Learn to Create Web Apps Using MySQL Database in 30 Minutes NetBeans Tutorial Covers Basic Web Development
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
Customized news reports about Sun Microsystems. Just the news you need, none of what you don't. 50,000+ Members. 20,000+ Articles Published since 1998.