MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Java Database Integration with JDBC

Course Summary

Describes how to read and manage data from relational databases such as MySQL and SQL Server using the Java Database Connectivity (JDBC) API in applications programmed with Java.       

  • +

    Course Syllabus

       What you should know before starting this course
       Using the exercise files
    1. Installing Software
       Testing your Java development environment
       Importing a MySQL database
       Creating a database user in MySQL
    2. Getting Started with JDBC
       What is JDBC?
       Choosing a JDBC driver
       Connecting to a MySQL database server
       Connecting to a HyperSQL database file
       Executing a static SQL statement
    3. Managing Database Resources
       Connecting to multiple databases
       Handling JDBC exceptions
       Closing database resources in Java 7
    4. Reading Data
       Looping through result sets
       Moving the cursor in scrollable result sets
       Limiting the number of fetched rows
       Filtering data with prepared statements
       Calling stored procedures
       Handling multiple values from stored procedures
       Using generic getter methods in Java SE 7
    5. Managing Data
       Managing data entities with JavaBean classes
       Retrieving a single row as a JavaBean object
       Inserting rows with prepared statements
       Updating rows with prepared statements
       Deleting rows with prepared statements
       Managing data with updatable result sets
       Using a persistent database connection
       Committing and rolling back transactions
    6. Using Metadata
       Getting the DatabaseMetaData object
       Getting column and data type information
       Next steps


Course Fee:
USD 25

Course Type:


Course Status:



3 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top