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...]

From the latest issue:

Recent Blog Entries as of March 17, 2010, 8:38 pm
A More Direct Channel Model Planned for Oracle-Sun Oracle, OpenSolaris, and Solaris Flash Storage in Exadata V2 Cuts Query Processing Time Significantly Document Freedom Day Set for March 31st What's in Store for the Oracle Office Product Family	Running VirtualBox VMs as Services in Windows 'Solaris 10 ZFS Essentials' Mobile Desktop Grid Oracle Management Connector for Ops Center Design Priniciples for Thread-based Systems
Blog RSS Feed