Ready to watch this entire course?
Become a member and get unlimited access to the entire skills library of over 4,900 courses, including more Developer and personalized recommendations.Start Your Free Trial Now
- View Offline
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.
- 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
Skill Level Intermediate
This course is designed for software developers who already have some experience programming with Java. You don't need to have worked in any particular application environment, such as Java enterprise edition, web applications, or Android app development. You just need to understand the basics of Java syntax, how to create simple console applications, and how to use Eclipse to create, compile, run, and debug. If you're brand-new to Java, I recommend first watching my course Java Essential Training. You'll get an introduction to the Java programming language and some valuable information about how the language and virtual machine work during compilation and at runtime.
You'll learn how to install Eclipse, how to create Java projects, packages, and classes, and you'll get an introduction to the fundamental concepts of object-oriented programming. You should then be ready for this course and for other lynda.com courses that put Java to specific use. When working with databases and JDBC, you'll need to use at least a little bit of SQL or Structured Query Language. In this course I'll show you all the SQL you need, including statements to select, insert, update, and delete data.
But if you want to learn more about SQL, check out the lynda.com course, SQL Essential Training. So let's get started learning about working with Java and Databases with JDBC.