Choosing a Web-to-Database Integration Technology

Many Web sites integrate with live data from databases. These databases may include product specifications, customer data, office addresses, and other valuable information. To achieve this integration, most sites use one of three middleware technologies: ColdFusion, Active Server Pages (ASP), or Java. In this one-day course, students will gain hands-on experience in all three leading Web-to-database integration technologies. Based on this experience, and the criteria discussed in class, students will be able to successfully choose the technology that is best for their application.

After completing this course, students will be able to:

• Use Style Sheets and Templates for a Uniform Design
• Analyze your needs and technology environment to select the technology that is best for you
• Write basic programs in Cold Fusion
• Write basic programs in ASP
• Write basic programs in JSP
• Properly map out the steps necessary to build your database-driven Web application
• Explain the pros, cons, and costs of each server-side programming technology to colleagues, supervisors, direct reports, and outside vendors
  

Target audience

All students should have an excellent understanding of HTML acquired through practical experience or attendance on an advanced level course.

Course content

Course Introduction The Three Layers of a Web Application • Choosing the Best Server-Side Architecture for Your Application • Where do we go from here

Introduction to ColdFusion Overview • The Server Architecture • Using ColdFusion Studio • Exercise 1: Building an HTML Page with ColdFusion Studio

Building Forms with ColdFusion Studio Creating Form Elements • Exercise 2: Constructing a Short Form

Using ColdFusion to Process Form Data The cfoutput tag • Designating Variables in ColdFusion • Exercise 3: Processing the Name Submissions Form

A Review of Database Concepts

An Introduction to SQL Data Types in SQL • Retrieving Information from the Database via SELECT • How the Database for this Class is Structured

Querying a Database in ColdFusion The < cfquery> Tag • The cfoutput QUERY Attribute • Exercise 4: Building Your First Database-Driven Application • Exercise 5: Displaying Multiple Records

Displaying Multiple Records Returned by a Query with CFTABLE Exercise 6: Displaying All Orders with CFTABLE

Introduction to Active Server Pages What are Active Server Pages? • Which Web Servers Support Active Server Pages? • In What Languages Can I Write the Embedded Code? • Statements in VBScript • Enclosing Scripting Code within your ASPs • An Example: Hello World

Working with Forms in ASP Overview of the GET and POST Form Methods • The Request and Response Objects in ASP • The Request and Response Objects • Exercise 7: Processing Form Input

Introduction to ASP Database Connectivity Getting the Value of clientid from the Form • Creating the Connection and Recordset Objects • Connection to the Database • Assembling the SQL • Executing the SQL • Moving to the First (and only) Record and Retrieving Values • Displaying the Results • Closing the Recordset and Connection • Exercise 8: Completing a Data-Driven ASP Application

Displaying Multiple Records in ASP Dynamically Generating Tables in ASP • Exercise 9: Displaying a Table of All Orders

Introducing Java and JavaServer Pages What is Java? • In Which Environments does Java Run? • What Types of Programs is Java Used to Write? • Java File Types • More About Servlets • Adding Servlet/JSP Functionality to Your Web Server • Examining a Simple JSP that Uses Directives and Expressions • Directives with < %@ %> • Expressions with < %= %> • Examining a JSP that Uses Scriptlets • Embedding Scriptlets with < % %> • Java Operators • Implicit Objects • Introducing Classes, Objects, and Packages • Comments

Processing Form Input request.getParameter()o Exercise 10: Processing a Form Submission

Introducing JDBC Generating a List of Clients from the Database • The Seven Steps Carried Out by Database-Driven Applications • Loading the Database Driver • Connecting to the Database • Assemble the SQL Statement • Execute the SQL Statement • Display the Results • Close the Statement and ResultSet • Close the Connection • Exercise 11: Retrieving a Name from the Database

Working with ResultSetMetaData Getting a ResultSetMetaData Object • Obtaining the Column Count • Generating the HTML Table Column Headers • Generating the HTML Table Rows • Exercise 12: Completing a JSP that Retrieves All Orders from the Database

Conclusion How Can I Learn These Architectures in More Detail? • What Else Would I Learn by Taking In-Depth ColdFusion, ASP, or JSP Training?

Appendix A: Creating an ODBC DSN

Appendix B: Recommended Resources

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today