Join David Gassner for an in-depth discussion in this video What you should know before starting this course, part of Java Database Integration with JDBC.
- View Offline
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.…
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