15415 Recitation Homework 9 Building Enterprise Web Application









Untitled

JSP i. About the Tutorial. Java Server Pages (JSP) is a server-side programming technology that enables the creation of dynamic platform-independent method 
jsp tutorial


JSP File Uploading

A JSP can be used with an HTML form tag to allow users to upload files to the server. You can download it from http://commons.apache.org/io/.
jsp file uploading


Developing Web Applications Servlets

https://docs.oracle.com/cd/E12839_01/web.1111/e13712.pdf


Developing XML Solutions with JavaServer Pages Technology

lar as part of the Java software environment
jspxml






O'Reilly - JavaServer Pages 3rd Edition

You can download the Tomcat server in binary format or as source code that you compile yourself. If you're primarily interested in learning about JSP 


Sumo: An Authenticating Web Application with an Embedded R

Servlet and Java Server Pages (JSP) specifications 3Command to start R is configurable in the file 'sumo.xml'. ... org/doc/Rnews/Rnews_2003-3.pdf.
RJ


15415 Recitation Homework 9 Building Enterprise Web Application

Mar 27 2012 using JSP. 2 phases ... Server newcastle.db.cs.cmu. edu hw7 database. Client. Browser ... JSP is being turned into a Java file
recitation slides





JavaServer Pages™ (JSP™) v1.2 Syntax Reference

Aug 30 1999 Forwards a request to an HTML file
syntaxref


MEDICAL DEVICE AND HEALTH IT JOINT SECURITY PLAN

Jan 4 2019 JSP framework in Section VII of this document. ... direct download from the third-party that provides the product or.
HSCC MEDTECH JSP v


213567 15415 Recitation Homework 9 Building Enterprise Web Application

03/27/2012

15-415/615 Spring 2013

Homework 7

Building A Web Application

School of Computer Science

HW7 Outline

Building a simple Web application ("CMUFlix")

using JSP

2 phases

Phase I : design and documentation

due 4/2 hard copy in class

Phase II : implementation

due 4/11 both hard copy in class and electronically.

Start early!

descriptionreq. anal.top level I.F.D.sys. anal.conc. mod.impl.+test.task + doc forms.schema.code.task emul.testsuser's man.pseudo-code

Phase-IPhase-II

Database Design Methodology

[N. Roussopoulos and R.T. Yeh]

descriptionreq. anal.top level I.F.D.sys. anal.conc. mod.impl.+test.task + doc forms.schema.code.task emul.testsuser's man.pseudo-code

Phase-IPhase-II

Homework 7

A recommendation web application for

movies, like NetFlix.

Users can register, like a movie, get

recommendations, etc.

Tasks to implement

Registration (a simple example is already

provided)

Login/Logout

Profile Page

"Like" a movie

Ask for a movie recommendation

Reporting (website statistics)

descriptionreq. anal.top level I.F.D.sys. anal.conc. mod.impl.+test.task + doc forms.schema.code.task emul.testsuser's man.pseudo-code

Phase-IPhase-II

registration form

T1-reg. user record

Top level information flow

diagram (Homework I)

System boundarytasksinternal document

(database tables) external document (web forms) registration form

More on top level diagram

login form

T2 - login

T1-reg.

user record profile page

descriptionreq. anal.top level I.F.D.sys. anal.conc. mod.impl.+test.task + doc forms.schema.code.task emul.testsuser's man.pseudo-code

Phase-IPhase-II

Document + Task forms

Task forms and task list

not required for this homework

Document forms and document list

• D1: registration form • D2: login form • D3: profile form • Dx: user record internalexternal

Document forms (Homework I)

D1: registration form

login name password email

D3: profile form

• login name?

List-of:

Movies liked

Dx: user record

login name password email

descriptionreq. anal.top level I.F.D.sys. anal.conc. mod.impl.+test.task + doc forms.schema.code.task emul.testsuser's man.pseudo-code

Phase-IPhase-II

E-R diagram (Homework I)

users moviesloginemail?... passw o

Specify cardinalities

o

Think about weak/strong entities

like

Relational schema (Homework I)

users( login, passw, email ... ) movies(... ) ?

SQL DDL statements (Homework I)

create table users (login char(20), passwd char (20) NOT NULL (?), ... ); create table ? (... );

descriptionreq. anal.top level I.F.D.sys. anal.conc. mod.impl.+test.task + doc forms.schema.code.task emul.testsuser's man.pseudo-code

Phase-IPhase-II

Task emulation/pseudo-code

(Homework I)

Task1: Registration

read login, password and email if ( login does not exist in 'users'){ insert into users values (login_id, password, email); } else{ print "error: login exists, choose another login name" should be valid

SQL queries

descriptionreq. anal.top level I.F.D.sys. anal.conc. mod.impl.+test.task + doc forms.schema.code.task emul.testsuser's man.pseudo-code

Phase-IPhase-II

Phase II

You will develop

JSP pages that handle user interactions

Processing logic written in Java class

Manipulating data in database, connect from

JSP to database using JDBC

UsersWeb app

(JSP, ASP, PHP)

Apache,

Tomcat,

Windows IIS

Web Server

Java Virtual

Machine

Web app

backend component

Backend Server

Database

Server

Client

Web Application Architecture

Multi-tier architecture

httpe.g. RMIJDBC ODBC

Homework 7: Architecture

Tomcat 6.0

CMUFlix app

JSP, Java

Web Server

newcastle.db.cs.cmu.edu

PostgreSQL

Database Server

newcastle.db.cs.cmu.edu hw7 database

Client

Browser

User httpJDBC

Registration example - register.jsp

Tomcat 6.0

Twitter app

JSP, Java

Web Server

newcastle.db.cs.cmu.edu

PostgreSQL

Database

Server

newcastle.db.cs.cmu. edu hw7 database

Client

Browser

User http:// newcastle.db.cs. cmu.edu:8080/ testuser415/ register.jsp register.jsp html page with input FORM

Submit FORM

with login_id, password and email

JDBC exec. query

java.sqlStatement. executeUpdate()

JDBC insert

succeeds

Html page with successful info

123456

Registration example - register.jsp

Registration example - register.jsp

(continued)

JSP Basics

JSP is a technology that helps

software

03/27/2012

15-415/615 Spring 2013

Homework 7

Building A Web Application

School of Computer Science

HW7 Outline

Building a simple Web application ("CMUFlix")

using JSP

2 phases

Phase I : design and documentation

due 4/2 hard copy in class

Phase II : implementation

due 4/11 both hard copy in class and electronically.

Start early!

descriptionreq. anal.top level I.F.D.sys. anal.conc. mod.impl.+test.task + doc forms.schema.code.task emul.testsuser's man.pseudo-code

Phase-IPhase-II

Database Design Methodology

[N. Roussopoulos and R.T. Yeh]

descriptionreq. anal.top level I.F.D.sys. anal.conc. mod.impl.+test.task + doc forms.schema.code.task emul.testsuser's man.pseudo-code

Phase-IPhase-II

Homework 7

A recommendation web application for

movies, like NetFlix.

Users can register, like a movie, get

recommendations, etc.

Tasks to implement

Registration (a simple example is already

provided)

Login/Logout

Profile Page

"Like" a movie

Ask for a movie recommendation

Reporting (website statistics)

descriptionreq. anal.top level I.F.D.sys. anal.conc. mod.impl.+test.task + doc forms.schema.code.task emul.testsuser's man.pseudo-code

Phase-IPhase-II

registration form

T1-reg. user record

Top level information flow

diagram (Homework I)

System boundarytasksinternal document

(database tables) external document (web forms) registration form

More on top level diagram

login form

T2 - login

T1-reg.

user record profile page

descriptionreq. anal.top level I.F.D.sys. anal.conc. mod.impl.+test.task + doc forms.schema.code.task emul.testsuser's man.pseudo-code

Phase-IPhase-II

Document + Task forms

Task forms and task list

not required for this homework

Document forms and document list

• D1: registration form • D2: login form • D3: profile form • Dx: user record internalexternal

Document forms (Homework I)

D1: registration form

login name password email

D3: profile form

• login name?

List-of:

Movies liked

Dx: user record

login name password email

descriptionreq. anal.top level I.F.D.sys. anal.conc. mod.impl.+test.task + doc forms.schema.code.task emul.testsuser's man.pseudo-code

Phase-IPhase-II

E-R diagram (Homework I)

users moviesloginemail?... passw o

Specify cardinalities

o

Think about weak/strong entities

like

Relational schema (Homework I)

users( login, passw, email ... ) movies(... ) ?

SQL DDL statements (Homework I)

create table users (login char(20), passwd char (20) NOT NULL (?), ... ); create table ? (... );

descriptionreq. anal.top level I.F.D.sys. anal.conc. mod.impl.+test.task + doc forms.schema.code.task emul.testsuser's man.pseudo-code

Phase-IPhase-II

Task emulation/pseudo-code

(Homework I)

Task1: Registration

read login, password and email if ( login does not exist in 'users'){ insert into users values (login_id, password, email); } else{ print "error: login exists, choose another login name" should be valid

SQL queries

descriptionreq. anal.top level I.F.D.sys. anal.conc. mod.impl.+test.task + doc forms.schema.code.task emul.testsuser's man.pseudo-code

Phase-IPhase-II

Phase II

You will develop

JSP pages that handle user interactions

Processing logic written in Java class

Manipulating data in database, connect from

JSP to database using JDBC

UsersWeb app

(JSP, ASP, PHP)

Apache,

Tomcat,

Windows IIS

Web Server

Java Virtual

Machine

Web app

backend component

Backend Server

Database

Server

Client

Web Application Architecture

Multi-tier architecture

httpe.g. RMIJDBC ODBC

Homework 7: Architecture

Tomcat 6.0

CMUFlix app

JSP, Java

Web Server

newcastle.db.cs.cmu.edu

PostgreSQL

Database Server

newcastle.db.cs.cmu.edu hw7 database

Client

Browser

User httpJDBC

Registration example - register.jsp

Tomcat 6.0

Twitter app

JSP, Java

Web Server

newcastle.db.cs.cmu.edu

PostgreSQL

Database

Server

newcastle.db.cs.cmu. edu hw7 database

Client

Browser

User http:// newcastle.db.cs. cmu.edu:8080/ testuser415/ register.jsp register.jsp html page with input FORM

Submit FORM

with login_id, password and email

JDBC exec. query

java.sqlStatement. executeUpdate()

JDBC insert

succeeds

Html page with successful info

123456

Registration example - register.jsp

Registration example - register.jsp

(continued)

JSP Basics

JSP is a technology that helps

software
12345 Next