CS 119.2 / CS 295.S52 / CIE 199 Enterprise Systems Programming
2nd Semester, 2008-2009
Instructor: John Paul Vergara
Syllabus
DISCS Policies on Academic Integrity and Lab Use
Announcements
- Reminder: Final project due on March 21,
demos on week of March 23.
- Reminder: Midterm exam on February 6, 9:30, Berchman's AVR.
- Merry Christmas!
Project 1 is due on January 12.
Specs are available under the Projects section.
- Welcome to this website! Visit this link regularly for
course material, announcements and updates
Slides/Course Material
- Week 1 tasks
( (Updated to include Java installation instructions)
- Week 2 tasks
- Week 3:
- Week 4:
- Week 5:
- Java code demo part 5:
Shapes.zip
(demonstrates GUI using applets, ArrayLists, and interfaces);
execute by opening the Shapes.html file through a browser.
- Lab 2 to be accomplished
during the first hour of class.
- JDBC
- Week 6:
- Databases
- Download this DB Query Application
that makes sending SQL statements to a database easier.
The application was written by Jejomar Dimayuga (BS MIS graduate).
Try formulating SQL statements for
these sample queries
on this database .
- Java programs
(demonstrated in class)
that access the sample database given above.
Uses both Statement and PreparedStatement classes.
- Week 7:
Today's agenda: Lab 3, Quiz on SQL, and midterm students' evaluation
of faculty.
(Your instructor will not be around today)
- Lab 3 to be accomplished by 11am today.
- A Quiz on SQL will be given at 11:00-11:20.
- You may leave once you have completed the lab,
submitted the quiz, and accomplished the evaluation form.
- Week 8:
Activity carried out today:
-
Research on the difference between
the GET and POST methods in html forms.
Visit search sites like
google
or
imdb
and log in pages like
mail.ateneo.edu
or
facebook
and then compare and contrast their html forms (view the source pages).
-
Create a web application that inserts
a record into the THING table of
the owners database
through a form that uses the POST method.
- Week 9:
- Servlets
- While waiting for your instructor,
think about how to do the following:
Create a web application that
updates a PERSON record in the Owners database.
The user will first be presented with a form
where a person's initials are encoded.
After clicking a button, a form containing
current contents for the corresponding record will be displayed
which could be updated.
An update button then causes the update.
This is a lab that will be submitted by the end of the period today.
- Week 10:
Midterm exam from 9:30-11:30 at the Berchman's AVR.
- Week 11:
- Week 12:
- Main activity for today: using JSP,
develop an update screen for the PERSON record of the
owners database,
similar to the exercise during Week 9.
Submit through
Moodle
- There will be a quiz towards the end of the period.
- Week 13:
- Topic discussed today:
Introduction to the Model-View-Controller (MVC) pattern,
using Beans, JSP, and servlets.
- Here is a simple Eclipse Project
demonstrating the MVC pattern.
- Announcement for graduating students:
Project deadline moved to March 2.
All students must demonstrate their projects by March 3pm
(A sign-up sheet will be available by monday morning).
Those who demonstrated their projects during class time need not sign up.
- Week 14:
- The non-eclipse version of the the sample MVC/bean web application
is available through moodle.
- Make sure you have the database design
for your project reviewed by your instructor.
- Week 15 (March 14):
Agenda
- (Note: class today will be held at F223)
- Quiz on JSP and Servlets (9:15-9:30)
- 9:30 onwards: Enterprise Systems demo
through a different platform (with Andrei Coronel)
- Announcement: no classes on March 21,
but the project is still due on that date.
Demos will be during the week of March 23.
Projects
- Project 1: Specs .
Due January 12, midnight.
- Project 2 for graduating students only (Due
Feb 28 March 2):
Create a complete web app using servlets and/or JSP
that supports add, update and delete of PERSON and THING records.
You may work in pairs.
- Project 2 for all other sudents (Due March 21, 9am):
Create a complete web app using servlets and/or JSP
that supports add, update and delete for any three-table database.
You may work in pairs.
You will be graded according to correctness and complexity
Links