Java Database Integration with JDBC

Whether you’re building a web- or desktop-based application with Java SE or Java EE, many Java applications need to integrate data from a relational database. This course describes how to read and manage data from relational databases such as MySQL and SQL Server using the Java Database Connectivity (JDBC) API.
Author David Gassner explains how to choose a JDBC driver and connect to one or more databases. He also provides detailed instructions on reading, selecting, and updating data; calling stored procedures; managing data via JavaBean classes or with prepared statements; and working with metadata.

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

Table of content

• Introduction
  • Welcome
  • What you should know before starting this course
  • Using the exercise files
• Installing Software
  • Testing your Java development environment
  • Importing a MySQL database
  • Creating a database user in MySQL
• 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
• Managing Database Resources
  • Connecting to multiple databases
  • Handling JDBC exceptions
  • Closing database resources in Java 7
• 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
• 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
• Using Metadata
  • Getting the DatabaseMetaData object
  • Getting column and data type information
• Conclusion
  • Next steps

Uploaded.net

1. http://ul.to/ildruhng
2. http://ul.to/nxrlk5wp

Rapidgator.net

1. apidgator.net 
2. bit.ly/1lnUZIt