The Proceedings of the Information Systems Education Conference 2001: §08c Home Papers/Indices prev (§08b) Next (§09a)

Paper (refereed) Information Systems Curriculum

Recommended Citation: Haney, J D and C A VanLengen. Web Development in a Server-Centric Environment Using Java Server Pages (JSP) In The Proceedings of the Information Systems Education Conference 2001, v 18 (Cincinnati): §08c.

Web Development in a Server-Centric Environment Using Java Server Pages (JSP)

Refereed

John D. Haney    [a1] [a2]
College of Business Administration
Northern Arizona University    [u1] [u2]
Flagstaff, Arizona, USA    [c1] [c2]

Craig A. VanLengen    [a1] [a2]
College of Business Administration
Northern Arizona University    [u1] [u2]
Flagstaff, Arizona, USA    [c1] [c2]

The development of interactive Web page applications, where data is extracted from a database or a database is updated, can be a tedious process. Several options are available. The preference for this study is Java Server Pages (JSP). The fundamental processes for interactive Web page development are - querying from a database, adding a row to a database table, changing the fields within a row, or deleting a row from a database table. These processes form the foundation for any type of database interaction. The scripting language used for Java Server Pages is Java and the interaction with the database is done with Structured Query Language (SQL) against an Oracle database. In each of these processes a connection must be made to the database. A Java Database Connectivity (JDBC) connection to Open Database Connectivity (ODBC) connection is used since the Jakarta Java Web Server is used which runs on Internet Information Server (IIS) and NT. In the case of the query, where information is extracted from the database and placed into a table on the web page, only one Web page is required. For adding a record, changing a record, or deleting a record two Web pages are required. The first page contains a form with objects, which are posted to the second JSP page. The second JSP page then, by using SQL, inserts a record, modifies a record or deletes a record.

Keywords: Java Server Pages, Java, database connectivity, structured query language, database interaction

Read this refereed paper in Adobe Portable Document (PDF) format. (137 K bytes)
Preview this refereed paper in Plain Text (TXT) format. (26 K bytes)

CDpic
Comments and corrections to
webmaster@isedj.org