Project 1

Project 1

Creating a Simple Web Application Using a MySQL Database

create a simple web application that connects to a MySQL database server.


including.

s JavaServer Pages (JSP), JavaServer Pages Standard Tag Library (JSTL),
the Java Database Connectivity (JDBC) API, and two-tier, client-server architecture




MySQL is a open source database management systme

using in web applications

why: speed, flexiblity and reliablity.



MySQL employ SQL (structured query language)

for what?

Accessing and processing data in database.

::

If I want to accessing and processing data in database, What do I have to look
I have used the MySQl. because this can manage the data.
Why do we chose MySQl because We love to use it for it's fliexiblity and reliablity and speed. and also it is open source.


To do this project

We need database

and

table :: Subject and Counselor.

database:: MyNewDatabase




Contents

Content on this page applies to NetBeans IDE 6.x

* Planning the Structure
* Creating a New Project
* Preparing the Interface
* Setting up a Connection Pool
o Setting up a JNDI Datasource
o Referencing the Datasource from the Application
o Adding the Database Driver's JAR File to the Server
* Adding Dynamic Logic
o Adding the JSTL Library to the Project's Classpath
o Adding taglib Directives to the JSP Pages
o Adding JSP and JSTL Code
* Deploying and Running the Project



software that required to finished this project

Software or Resource Version Required
NetBeans IDE version 6.x Java
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
or
Tomcat servlet container V2 UR2 or V3 Prelude

version 6.x