аЯрЁБс > ўџ A C ўџџџ @ џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџьЅС k јП Ў bjbj Ў Ў `* }Ф }Ф ћ џџ џџ џџ l > > > > > > > $ b P \ x , b і А Т
Т
Т
Т
Т
К | t № < > е а Ѕ а u $ ." 9 > , Т
Т
, , <
> > Т
Т
в <
<
<
, Ъ > Т
> Т
<
, <
т <
V б @ > > q Т
Є UђУb Њ і F q $ ш 0 T А" <
А" q <
b b > > > > й C I P C o d e : F O R M T E X T
M E T R O P O L I T A N S T A T E C O L L E G E O F D E N V E R
O m n i b u s C o u r s e S y l l a b u s
S c h o o l o f F O R M T E X T L e t t e r s , A r t s , a n d S c i e n c e s
D e p a r t m e n t : F O R M T E X T M a t h e m a t i c a l a n d C o m p u t e r S c i e n c e s I n s t r u c t o r : F O R M T E X T P a t r i c i a T u c k e r
P r efix and Course Number: FORMTEXT CSS 390 _ Semester/year offered: FORMTEXT Fall 2004
Banner Number (for Academic Affairs use):__________________________
Course Title: FORMTEXT Integrating Database and Software
Credit Hours: FORMTEXT 3 (3+0) Contact Hours-students: FORMTEXT 45 Total Other Hours*: FORMTEXT
C o n t a c t H o u r s - f a c u l t y : F O R M T E X T 4 5
M e e t i n g T i m e s / D a t e s : F O R M T E X T T R 4 : 0 0 - 5 : 1 5 p m
G r a d i n g M o d e ( s ) : F O R M T E X T L e t t e r S c h e d u l e T y p e ( s ) : F O R M T E X T L e c t u r e
P r e r e q u i s i t e s / C o r e q u i s i t e s : F O R M T E X T C O T 2 8 0 1 a n d e i t h e r C S I 2 0 5 0 o r C S S 2267, each with a grade of "C" or better, or permission of instructor
Required Reading Materials (author, title, publisher, copyright date):
Java Database Programming Bible, 2nd Edition by John ODonahue, Wiley, 2002
Evaluation of Student Performance:
Homework and Programming Assignments
Quizzes and Examinations
Final Examination
Oral Presentations
Significant Programming Projects.
as determined by the instructor.
Specific (measurable) Student Behavioral Learning Objectives:
Upon completion of this course the student should be able to:
Design and build a two-tier client/server database application using JDBC and Swing components to update, retrieve, summarize, and group data.
Design and implement a three-tier Web site database application using JDBC, servlets, Java Server Pages, HTML forms, XSL transforms, and the JavaMail API.
Use JDBC and SQL in a database application that uses XML documents..
Detailed outline of course content (major topics and subtopics) or outline of field experience/ internship (experience, responsibilities and supervision):
Review of relational database concepts
JDBC Core API
Two-Tier and Three-Tier Models for Database Access
Passing SQL Statements to a Database
Transactions
ResultSets
Creating User Defined Data Types
Building a Two-Tier Client/Server Application with JDBC and SQL
Creating a Table with JDBC and SQL
Inserting, Updating, and Deleting Data
Retrieving Data with SQL Queries
Building a Three-Tier Web Site with JDBC
Using JDBC DataSources with Servlets and JavaServer Pages
Using PreparedStatements and CallableStatements
Using Blobs and Clobs to Manage Images and Documents
Using JSPs, XSL, and Scrollable ResultSets to Display Data
Using the JavaMail API with JDBC
Using Databases, JDBC, and XML
The XML Document Object Model and JDBC
Using Rowsets to Display Data
Accessing XML Documents Using SQL
Approved - Omnibus course:
_________________________________________________________ __________________
Department Chair Date
_________________________________________________________ __________________
Dean of School Date
_________________________________________________________ __________________
Associate Vice President for Academic Affairs Date
Approved - Field Experience/Internship Only:
______________________________________________________________________________
Location of Internship
_________________________________________________________ __________________
Faculty Evaluation Group Date
_________________________________________________________ __________________
Field Supervisor** Date
**Approval by the Field Supervisor is required and must be indicated by the original signature of that supervisor on the syllabus.
Guidelines as set forth in the omnibus course section of the Bulletin must be followed. An accurate copy of each course syllabus must be on file in the Office of Academic Affairs prior to the listing of such course in any semester schedule.
* , . 8 : > М а в ц ш ъ " $ > @ T V X О Р д ж и і ј њ # $ % . / H I S T U ^ _ ` Г Д О П Р с т у ђ ѓ § љїэљсљї їљїзљЯљї љїХљЯљ љїЛљЯљї љїБљЯљ љїЇљЯљї љїљЯљї љї jl >*U jц >*U j` >*U jЮ >*U j >*U >*mH nH u jv >*U j >*UmH nH uj >*U >* j >*U: > @ К М $ & њ ќ ` Є Ѕ у ф ^ ` Ц Ш f h H
I
J
њ њ ѕ ѕ ѕ ѕ ѓ ѓ ѓ ѓ ѓ ѓ ѓ ѓ ѓ э ѓ ѓ ѓ ѓ ѓ ѓ ѓ ѓ ѓ ц
Ц `' @ `@ $a$ $a$ Ј §§ § ў џ ! " , - . 0 1 F G Q R
< > R T V Z \ Ђ Є Т Ф ъ ь : < P R T b d Ђ Ж И К F
G
Д
іячя яхлячя яхбяХя яхЛячя яхБячя яхЇячя яхячя яхячя CJ jЄ >*U j >*U j >*U j
>*U j >*U j >*UmH nH uj >*U jЄ >*U >*>*mH nH u j >*U j" >*U8Д
Ж
щ ъ ) R
S
P Q R l У я 3 V a Ж З Ї Љ Ћ Ў § є ђ ђ є ю ю ычы с м OJ QJ
56CJ >*CJ CJ 56 \CJ OJ QJ ^J H*
о
п
' @ R e Ј Ћ щ ъ ( ) И S
3 ј і і х х х х х л л і ј ј в Ч Ч Ч Ѓ # $d %d &d 'd NЦџџџ OЦџџџ PЦџџџ QЦџџџ
& F
Ц `'
Ц рР! `'
Ц 88^8
& F
Ц
h 8`' 8^8
Ц `' 3 4 [ i С Ю й њ : ^
І Я
: o Њ Ы ъ / Q л а а Х Х Х Х Х а Х Х Х а Х Х Х Х Х а Х Х Х
& F
Ц `'
& F
Ц `' # $d %d &d 'd NЦџџџ OЦџџџ PЦџџџ QЦџџџ Q R m К з $ ? Т У № ? V Ѓ Ч є Э Љ Э Љ Э Љ Љ
Э Љ Э Љ Э Љ # $d %d &d 'd NЦџџџ OЦџџџ PЦџџџ QЦџџџ # $d %d &d 'd NЦ OЦ PЦ QЦ & dh $d %d &d 'd NЦ OЦ PЦ QЦ
Ц `' 8^8 3 Ж З Ј Љ Њ Ћ Ќ Ў л З З З В З $
Ц/ а p@ рАP № Р!$`' a$ dџ # $d %d &d 'd NЦџџџ OЦџџџ PЦџџџ QЦџџџ # $d %d &d 'd NЦ OЦ PЦ QЦ
. 0 0 P Аа/ Ар=!А8"А8#а$а%А А А . 0 0 P Аа/ Ар=!А "А #а$а%А А А v D џџџџ T e x t 1 5 D џџџџ L e t t e r s , A r t s , a n d S c i e n c e s И D џџџџ T e x t 2 " M a t h e m a t i c a l a n d C o m p u t e r S c i e n c e s D џџџџ T e x t 3 P a t r i c i a T u c k e r D џџџџ T e x t 4 C S S 3 9 0 _ D џџџџ T e x t 5 F a l l 2 0 0 4 Ж D џџџџ T e x t 6 ! I n t e g r a t i n g D a t a b a s e a n d S o f t w a r e D џџџџ T e x t 7 3 ( 3 + 0 ) x D џџџџ T e x t 8 4 5 t D џџџџ T e x t 9 z D џџџџ T e x t 1 0 4 5 D џџџџ T e x t 1 1 T R 4 : 0 0 - 5 : 1 5 p m D џџџџ T e x t 1 2 L e t t e r D џџџџ T e x t 1 3 L e c t u r e H D џџџџ T e x t 1 4 i C O T 2 8 0 1 a n d e i t h e r C S I 2 0 5 0 o r C S S 2 2 6 7 , e a c h w i t h a g r a d e o f " C " o r b e t t e r , o r p e r m i s s i o n o f i n s t r u c t o r
i < @ёџ < N o r m a l 1$ CJ _Hh mH sH tH < A@ђџЁ < D e f a u l t P a r a g r a p h F o n t 4 &@Ђ ё 4 F o o t n o t e R e f e r e n c e , @ , H e a d e r
Ц рР! , @ , F o o t e r
Ц рР! | * џџџџ 0* џџџџ E ] ^ § ў ` Є Ѕ у ф Z Ж З ф х 1 2 U z Ѕ И к ћ ў < = { | І ы Ў М я ! , M Б и љ " ] Т §
=
d
Є
Ѕ
Р
* w п C Љ і
g
ћ ќ § ў 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 `0 0 0 0 0 0 0 0 0 Ў 0 Ў 0 Ў 0 Ў 0 Ў 0 0 M 0 M 0 M 0 0 љ 0 љ 0 љ 0 љ 0 љ 0 0
0
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 @ 0 @ 0 @ 0
0 § Д
Ў
3 Q Ў
h t Ћ Ю п ы ћ $ . H T ^ Г П с ђ ў ! - 0 F R X q } Є Д Ш д л № ќ # / FДџFtџFtџFtџFtџFtџFtџFtџFtџFдџFtџFtџFtџFtџFtџџџ T e x t 1 5 T e x t 2 T e x t 3 T e x t 4 T e x t 5 T e x t 6 T e x t 7 T e x t 8 T e x t 9 T e x t 1 0 T e x t 1 1 T e x t 1 2 T e x t 1 3 T e x t 1 4 р I Д ѓ " G r Щ ё $
Я ќ / _ т 1 Y Е м ! # W _ ! + . 9 L V c u z Ђ Ш Ь т ь
j
q
Ѕ
ћ џ к м ш ъ Ѕ
П
ћ џ 3 3 3 џџ M e t r o S t a t e C o l l e g e ' C : \ s d r i v e c u r r . w o r d \ o m n i b u s s y l l a b u s . d o c M e t r o S t a t e C o l l e g e 1 C : \ T E M P \ A u t o R e c o v e r y s a v e o f o m n i b u s s y l l a b u s . a s d M e t r o S t a t e C o l l e g e ' C : \ s d r i v e c u r r . w o r d \ o m n i b u s s y l l a b u s . d o c M e t r o S t a t e C o l l e g e ' C : \ s d r i v e c u r r . w o r d \ o m n i b u s s y l l a b u s . d o c M e t r o S t a t e C o l l e g e ' C : \ s d r i v e c u r r . w o r d \ o m n i b u s s y l l a b u s . d o c M e t r o S t a t e C o l l e g e ' C : \ s d r i v e c u r r . w o r d \ o m n i b u s s y l l a b u s . d o c M e t r o S t a t e C o l l e g e ' C : \ s d r i v e c u r r . w o r d \ o m n i b u s s y l l a b u s . d o c M e t r o S t a t e C o l l e g e . C : \ s d r i v e c u r r . w o r d \ o m n i b u s s y l l a b u s . j u n e 0 0 . d o c r e e d m a i E : \ D o c u m e n t s a n d S e t t i n g s \ r e e d m a \ M y D o c u m e n t s \ S y l l a b u s \ C S S \ C S S 3 9 0 _ I n t e g r a t i n g D a t a b a s e a n d S o f t w a r e . d o c r e e d m a E : \ D o c u m e n t s a n d S e t t i n g s \ r e e d m a \ A p p l i c a t i o n D a t a \ M i c r o s o f t \ W o r d \ A u t o R e c o v e r y s a v e o f C S S 3 9 0 _ I n t e g r a t i n g D a t a b a s e a n d S o f t w a r e . a s d Х5QL6оoџџџџџџџџџ 5:-5 98Kџџџџџџџџџ *0^ џ аўЦ а^а`ўo( . ўЦ ^ `ў . pLџЦ p^p`Lџ . @ ўЦ @ ^@ `ў . ўЦ ^`ў . рLџЦ р^р`Lџ . АўЦ А^А`ў . ўЦ ^`ў . PLџЦ P^P`Lџ . 80§Ц 8^8`0§o( . ўЦ ^ `ўo( . $ ўЦ $ ^$ `ўo( . @ ўЦ @ ^@ `ў . ўЦ ^`ў . рLџЦ р^р`Lџ . АўЦ А^А`ў . ўЦ ^`ў . PLџЦ P^P`Lџ . hўЦ h^h`ўo( . *0^ 5:-5 Х5Q џџџџџџџџџџџџџџ џџ JБЌ X?ДЇФ!< њ ћ џ џ@\\NEBULA\SI1414000 Ne01: winspool HP LaserJet 4000 Series PCL \\NEBULA\SI1414000 4Cџ ъ
od X X Letter џџџџ DINU" 4 7еї \\NEBULA\SI1414000 4Cџ ъ
od X X Letter џџџџ DINU" 4 7еї Ѕ
Ѕ
Ќ6z Ѕ
Ѕ
4 S S p p @ p p @ џџ U n k n o w n џџ џџ џџ џџ џџ џџ G : џ T i m e s N e w R o m a n 5 S y m b o l 3& : џ A r i a l ?5 : џ C o u r i e r N e w " A ђа h /lІ8lІ
* Z б ђб 2 d + Є
2Q ђбп џџ C I P C o d e : _ _ _ _ _ _ _ _ _ _ _ _ _ _ C h a r l o t t e B a k e r r e e d m a ўџ р
ђљOhЋ +'Гй0 l А М д р №
( 4
@ L T \ d ф CIP Code:______________ IP Charlotte Baker har Normal t reedma t 3 ed Microsoft Word 9.0 _@ М e @ r4ЌђУ@ шюђУ * Z ўџ еЭе. +,љЎ0 h p Ј А И
Р ф ф MSCD e + 2 CIP Code:______________ Title
ўџџџ ўџџџ ! " # $ % & ' ( ) * + , - . / ўџџџ1 2 3 4 5 6 7 ўџџџ9 : ; < = > ? ўџџџ§џџџB E ўџџџG F ўџџџўџџџI J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` ўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџR o o t E n t r y џџџџџџџџ Р F >њПѕжD D a t a
џџџџџџџџџџџџ 1 T a b l e џџџџџџџџ А" W o r d D o c u m e n t џџџџ `* S u m m a r y I n f o r m a t i o n ( џџџџџџџџџџџџ 0 D o c u m e n t S u m m a r y I n f o r m a t i o n 8 џџџџџџџџ 8 C o m p O b j џџџџ j O b j e c t P o o l џџџџ џџџџ РБ^ђУРБ^ђУ ўџџџ ўџџџ ўџџџ
ўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ ўџ
џџџџ Р F Microsoft Word Document
MSWordDoc Word.Document.8 є9Вq DocumentLibraryFormDocumentLibraryFormDocumentLibraryForm
њПѕж У о Т M Ю Ч L Ф з Ф о Y е B 0 T У K Ф Щ в Q = = 2 џџџџ
єїПѕж>њПѕж I t e m
џџџџ џџџџ л P r o p e r t i e s џџџџџџџџџџџџ Щ O ж 3 о U Ь D H Ы U S Ц Э 5 е Q Ю 4 U F 1 Р = = 2 џџџџџџџџ
єїПѕж>њПѕж I t e m
џџџџ џџџџ H N1 P r o p e r t i e s џџџџџџџџџџџџ
Щ џџџџџџџџџџџџ ns:ds="http://schemas.openxmlformats.org/officeDocument/2006/customXml"/>
This value indicates the number of saves or revisions. The application is responsible for updating this value after each revision.