Server side programming database integration '/>
This presentation is the property of its rightful owner.
Sponsored Links
1 / 52

Server Side Programming Database Integration PowerPoint PPT Presentation


  • 102 Views
  • Uploaded on
  • Presentation posted in: General

Server Side Programming Database Integration. Peter O’Grady. Content. Introduction Server Side Programming (ASP) Database Integration. Introduction. Internet allows for client-server systems Programs can be invoked on either/both clients and servers:

Download Presentation

Server Side Programming Database Integration

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Server side programming database integration

Server Side ProgrammingDatabase Integration

Peter O’Grady

Server Side Programming ASP


Content

Content

  • Introduction

  • Server Side Programming (ASP)

  • Database

  • Integration

Server Side Programming ASP


Introduction

Introduction

  • Internet allows for client-server systems

  • Programs can be invoked on either/both clients and servers:

    • Client side includes Java Applets, ActiveX components with JScript or VBScript.

    • Server side includes CGI and ASP

  • Data can be kept on servers distributed across network and accessed via client (topic of this portion of course)

Server Side Programming ASP


Why use internet to access data

Why use Internet to access data?

  • People can access the data using a familiar browser interface. No special software required.

  • Data can be maintained centrally or distributed.

  • Data can be integrated with other information in an institution’s web pages

  • Information can be made available to anyone (with permission) on the Internet

Server Side Programming ASP


How can database be accessed by web browser

How can database be accessed by web browser?

Server Side Programming

e.g. Microsoft IIS server :

ASP (VBScript, JScript, SQL)

Database

Internet

Web browser

Web browser

Web browser

Server Side Programming ASP


Client side scripts

Client Side Scripts

  • They are browser-specific, so the same code may be interpreted differently depending on the browser being used. (Note recent use of ECMAScript as general JScript or JavaScript)

  • They can't be used to refer to a database (such as a product catalog).

  • They can lessen the burden on server and are particularly useful for such tasks as validating data before sending to server side to be processed.

Server Side Programming ASP


Server side programming asp

Server Side Programming (ASP)

Server Side Programming ASP


Content1

Content

  • Server Side programming overview

  • Example

    • Microsoft Internet Information Services (IIS)

    • Active Server Page(ASP)

    • VBScript/JScript

Server Side Programming ASP


Common gateway interface cgi

Common Gateway Interface (CGI)

  • CGI Is a standard for interfacing external applications with web servers (Common Gateway Interface, 1995).

  • Involves a new process each time it is invoked therefore can be slow with multiple users.

  • Alternatives: ISAPI (ASP), NSAPI.

Server Side Programming ASP


Server side programming database integration

IIS

  • IIS is a web server that runs on Win NT, 2000, Server2003 and XP Server.

  • Can use component-based (COM/ActiveX) client/server applications as well as JScript (ECMAScript) and VBScript

Server Side Programming ASP


What is asp

What is ASP?

Runs on IIS

"a server - side scripting environment that you can use to create and run dynamic, interactive, high - performance Web server applications”. Microsoft

Can include COM/ActiveX components and/or compiled code

Server Side Programming ASP


What are active server pages

What are Active Server Pages?

  • Server-side environment

  • Can provide compile-free application environment

  • Combine HTML, scripts, COM and ActiveX server components.

Server Side Programming ASP


Using asp

Using ASP

  • User usually completes HTML form in a browser and submits this to a .asp file on the server (note that you need a .asp file on the server)

  • .asp file contains both HTML and scripts/components

  • Scripts/components invoked and produce new HTML code

  • resulting page: original HTML + new HTML (generated by asp) - this is sent to client.

Server Side Programming ASP


Using asp1

Using ASP

  • Server evaluates tag starting with <% and ending with %>

  • Scripts/components contained within tags

  • Web servers supporting ASP:

    • Personal Web Server (Windows 95, 98, NT)

    • Internet Information Services (Windows NT Server, 2000 Server, Server 2003, XP)

Server Side Programming ASP


Asp application

ASP Application

  • Dell Computers

    • http://www.dell.com

  • Barnes and Noble Book Store

    • http://www.bn.com

  • Pricescan

    • http://www.pricescan.com

Server Side Programming ASP


Asp basics

ASP Basics

  • ASP file is a text file with the extension .asp

  • it contains any combination of:

    • Text

    • HTML Tags

    • ASP Script Commands/Components

Server Side Programming ASP


Asp script

ASP Script

  • ASP Script could be VBScript or Jscript (ECMAScript)

  • A script is a series of commands or instructions.

  • Script command instructs the web server to perform an action.

  • VBScript is similar to Visual Basic and Visual Basic for Application (VBA).

Server Side Programming ASP


Vbscript basics

VBScript Basics

  • Not case sensitive

  • Declaring Variables

    VBScript does not require variable declarations, but it is good scripting practice to declare all variables before using them. To declare a variable in VBScript, use the Dim, Public, or Private statement.

Server Side Programming ASP


Declaring variables

Declaring Variables

Dim: Declares variables and allocates storage space. Variables declared with Dim at the script level are available to all procedures within the script. At the procedure level, variables are available only within the procedure. Ex. Dim A,B

Private: Used at script level to declare private variables and allocate storage space. Private variables are available only to the script in which they are declared

Public: Used at script level to declare public variables and allocate storage space. Variables declared using the Public statement are available to all procedures in all scripts in all projects.

Server Side Programming ASP


Vbscript basics1

VBScript Basics

  • VBScript Operators:

    • Arithmetic: +, -, *, /, ^

    • Comparison: =, <>, <, >, <=, >=

    • Logical (for Boolean variables): Not, And, Or, Xor

Server Side Programming ASP


Vbscript basics2

VBScript Basics

  • Conditional Statement:

    • IF … Then… Else

      • If condition Then [Statement]

      • elseif condition-n Then [elseifstatment]…

      • else [elsestatements]

      • End if

Server Side Programming ASP


Vbscript basics3

VBScript Basics

  • Loop:

    • Do … Loop

    • While …Wend

    • For … Next

    • For Each …Next

  • Procedures:

    • Sub

    • Function

Server Side Programming ASP


Asp demo

ASP Demo

  • ASP uses <% and %> to enclose script commands.

    <html><head><title>ASP Example 1</title></head><body> <p>This page was last refreshed on <%= Date %> </p> <p>Now it is <%= Now %> </p></body></html>

    Note 1: The VBScript function Now returns the current time, Date returns current date.

    Note 2: No data is input by the user

Server Side Programming ASP


Running asp

Running ASP

  • Save file with .asp extension on server

  • Client accesses the file in similar fashion to .htm (or .html) file

  • Server detects .asp extension and runs script within ASP tags

  • Results sent to client

    http://128.255.21.191/Example1/Example1.asp

Server Side Programming ASP


Client server structure

Client-Server Structure

Running ASP

Script...

IIS

request

results

Client

Server Side Programming ASP


Example 2

Example 2

<html> <head><title>ASP Example 2</title></head> <body> <form method="POST" action="resultofexample2.asp"><p>A= <input type="text" name="ValueofA" size="20"></p><p>B= <input type="text" name="ValueofB" size="20"></p><p><input type="submit" value="Calculate" name="B1"></p></form></body></html>

http://128.255.21.191/Example2/Example2.htm

Server Side Programming ASP


Example 2 see web site

Example 2 see web site

Contained in HTML code:

<%@ language="vbscript" %>

<% dim A, B

A=Request.form("ValueofA")

B=Request.form("ValueofB")

%>

……….

<p>A+B= <%= eval(A)+eval(B) %> </p>

<p>A-B= <%= eval(A)-eval(B) %> </p>

<p>A*B= <%= eval(A)*eval(B) %> </p>

…….

Server Side Programming ASP


Server side programming database integration

example 2 asp<html> <head><title>Example 2 ASP Page</title></head> <body> <p>Example Page <%@ language="vbscript" %> <% dim A, BA=Request.form("ValueofA")B=Request.form("ValueofB") %> </p> <p>A+B= <%= eval(A)+eval(B) %> </p> <p>A-B= <%= eval(A)-eval(B) %> </p> <p>A*B= <%= eval(A)*eval(B) %> </p></body></html>

Server Side Programming ASP


Database overview

Database Overview

Server Side Programming ASP


What is a database

What is a Database?

  • A database is an organized collection of related data, typically stored on disk, and accessible by possibly many concurrent users.

  • Most common is relational database, which is a tabular database in which the data is defined so that it can reorganized and accessed in a number of different ways

Server Side Programming ASP


Database management systems

Database Management Systems

  • DBMS

  • A program to access, manipulate and present the data to a user.

  • Example DBMS:

    • Oracle

    • Sybase (Microsoft SQL)

    • IBM’s DB2, IMS and SQL/DS

    • dBase

    • Access

Server Side Programming ASP


Relational database structure

Relational Database Structure

  • set of tables containing data fitted into predefined categories.

  • each table(relation) contains one or more data categories in columns.

  • each row contains a unique instance of data for the categories defined by column.

Server Side Programming ASP


Example access

Example: Access

  • Relational database

  • Fairly good GUI.

  • Can use SQL

Server Side Programming ASP


Relationships in access

Relationships in Access

  • Multiple tables in one database

  • Matching key fields between table

    • A key is usually a field with the same name in both tables.

    • Such key is primary key for one table, foreign key in the other table.

Server Side Programming ASP


Server side programming database integration

SQL

  • SQL: Structured Query Language

  • It is used to query from and update database.

  • Systems using SQL:

    • Oracle

    • Sybase

    • Microsoft SQL server

    • Access

Server Side Programming ASP


Server side programming database integration

SQL

  • Standard SQL commands:

    • Select

    • Insert

    • Update

    • Delete

    • Create

Server Side Programming ASP


Sql example

SQL Example

database - example3.mdb

tablename - table1

columnname - ID, ItemName, Price

Server Side Programming ASP


Sql example1

SQL Example

  • To find out the ‘Price’ when ‘ItemName’ equals to Candy

    SELECT Price FROM Table1 WHERE ItemName = ‘Candy’

    Note:

    Can SELECT * to return whole row as an object - see Example 3 on website

Server Side Programming ASP


Sql basic

SQL Basic

  • Insert tablename (fieldname1, fieldname2…)

    values (value1, value2)

  • update tablename

    set column_name1=expression1

Server Side Programming ASP


Sql basic1

SQL Basic

  • Create tablename (fieldname1 type, fieldname2 type)

  • Delete [*] from tablename where clause (deletes whole row)

Server Side Programming ASP


Database integration requirements

Database Integration Requirements

  • Server (IIS)

  • Database

    • Internet database connector (ODBC) not always required can use ADODB

  • Dynamic Web Page (asp)

    • User Input using HTML forms

    • Data Transmission

    • Retrieving data from database

    • Display results

  • Server Side Programming ASP


    Operation

    Operation

    database

    ASP

    Server

    HTML

    Client

    Server Side Programming ASP


    Using web browser to access a database

    Using web browser to access a database

    • Web pages and forms are used to provide access to the database.

    • Database can be queried or updated.

    • Platform-independent front-end.

    • Database vendor-independent front-end

    • Client machine does not need database networking software

    Server Side Programming ASP


    Example implementation

    Example Implementation

    • Step 1: HTML file (containing forms) for user input on server.

    • Step 2: Database on server

    • Step 3: Setup database connection (ODBC)

    Server Side Programming ASP


    Step i html file with forms

    Step I: HTML File with Forms

    <form method="Post" action="Find.asp"><p> <select name = "item" method ="post" size ="1"><option selected value="Gum">Gum</option><option selected value="Suckers">Suckers</option><option selected value="Taffy">Taffy</option><option selected value="Skittles">Skittles</option><option selected value="M&Ms">M&Ms</option><option selected value="Lifesavers">Lifesavers</option><option selected value="Snickers">Snickers</option></select><input type="submit" value="Tell me the price"></p></form>

    • Example:

    This captures user input and sends result to result.asp

    Server Side Programming ASP


    Server side programming database integration

    Server Side Programming ASP


    Html forms example

    HTML Forms Example

    http://128.255.21.191/Example3/Example3.htm

    Server Side Programming ASP


    Step ii database

    Step II: Database

    • Under the home directory, create the access database named “Candy.mdb”

    • tablename - Products

    • columnname - ID, ItemName, Price

    Server Side Programming ASP


    Server side programming database integration

    <%@ LANGUAGE='VBSCRIPT'%><html><head></head><body><%dim priceSet MyConn = Server.CreateObject("ADODB.Connection")set rs = Server.CreateObject("ADODB.Recordset")MyConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Candy.mdb")item = Request.form("item")Set RS = MyConn.execute("Select * from Products where Candy = '" & item & "'")

    if rs.Eof thenPrice = ""elsePrice = RS("Price")End ifResponse.Write("It will cost you $" & price)Set MyConn = nothingSet rs  = nothing%></body></html>

    Server Side Programming ASP


    Running asp1

    Running ASP

    • Check the extension (asp)

    • server evaluates tag starting with <% and ending with %>

    • server replaces the tags with normal HTML using scripts

    • results page: original Markup + new Markup(generated by asp)

    Server Side Programming ASP


    Result

    Result

    Server Side Programming ASP


    Java2 enterprise edition

    Java2 Enterprise Edition

    Server Side Programming ASP

    EJBs (Enterprise JavaBeans) ----picture PCWeek


  • Login