Java Database Integration with JDBC



Java Database Integration with JDBC
Topics include:
Importing a MySQL database
Connecting to databases
Handling JDBC exceptions
Looping through result sets
Limiting the number of fetched rows
Filtering data with prepared statements
Calling stored procedures
Inserting, updating, and deleting rows with prepared statements
Using a persistent database connection
Committing and rolling back transactions
Introduction 5m 23s
Welcome 53s
What you should know before starting this course 1m 20s
Using the exercise files 3m 10s
1. Installing Software 12m 2s
Testing your Java development environment 5m 14s
Importing a MySQL database 5m 1s
Creating a database user in MySQL 1m 47s
2. Getting Started with JDBC 32m 47s
What is JDBC? 4m 26s
Choosing a JDBC driver 6m 46s
Connecting to a MySQL database server 8m 7s
Connecting to a HyperSQL database file 6m 23s
Executing a static SQL statement 7m 5s
3. Managing Database Resources 17m 42s
Connecting to multiple databases 6m 24s
Handling JDBC exceptions 7m 7s
Closing database resources in Java 7 4m 11s
4. Reading Data 47m 25s
Looping through result sets 8m 23s
Moving the cursor in scrollable result sets 5m 51s
Limiting the number of fetched rows 6m 57s
Filtering data with prepared statements 6m 58s
Calling stored procedures 5m 48s
Handling multiple values from stored procedures 5m 54s
Using generic getter methods in Java SE 7 7m 34s
5. Managing Data 45m 23s
Managing data entities with JavaBean classes 5m 0s
Retrieving a single row as a JavaBean object 6m 5s
Inserting rows with prepared statements 8m 2s
Updating rows with prepared statements 5m 4s
Deleting rows with prepared statements 4m 9s
Managing data with updatable result sets 6m 6s
Using a persistent database connection 6m 43s
Committing and rolling back transactions 4m 14s
6. Using Metadata 9m 35s
Getting the DatabaseMetaData object 3m 40s
Getting column and data type information 5m 55s
Conclusion 50s
Next steps 50s
Format : QuickTime
Format/Info : Original Apple specifications
File size : 14.5 MiB
Duration : 7mn 34s
Overall bit rate : 267 Kbps
Encoded date : UTC 2012-11-28 01:46:07
Tagged date : UTC 2012-11-28 01:46:07
Writing library : Apple QuickTime
Copyright : lynda.com
Video #2
ID : 2
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.1
Format settings, CABAC : Yes
Format settings, ReFrames : 3 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 7mn 34s
Bit rate mode : Variable
Bit rate : 104 Kbps
Width : 960 pixels
Height : 540 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 15.000 fps
Resolution : 24 bits
Colorimetry : 4:2:0
Scan type : Progressive
Bits/(Pixel*Frame) : 0.013
Stream size : 5.63 MiB (39%)
Encoded date : UTC 2012-11-28 01:46:07
Tagged date : UTC 2012-11-28 01:46:07
Audio #1
ID : 1
Format : AAC
Format/Info : Advanced Audio Codec
Format version : Version 4
Format profile : LC
Format settings, SBR : No
Format settings, PS : Yes
Codec ID : 40
Duration : 7mn 34s
Bit rate mode : Variable
Bit rate : 160 Kbps
Maximum bit rate : 162 Kbps
Channel(s) : 2 channels
Channel positions : Front: L R
Sampling rate : 48.0 KHz
Resolution : 16 bits
Stream size : 8.67 MiB (60%)
Encoded date : UTC 2012-11-28 01:46:07
Tagged date : UTC 2012-11-28 01:46:07
No mirrors please

Java_Databu_Intege_JDBC.part1.rar
Java_Databu_Intege_JDBC.part2.rar
Java_Databu_Intege_JDBC.part3.rar