Join David Gassner for an in-depth discussion in this video Testing your Java development environment, part of Java Database Integration with JDBC.
- View Offline
The exercises in this course are designed to work with Java 7, the most recent version…of the Java Programming Language as of the time of this recording.…If you haven't programmed with Java 7 before, you want to install it on your computer and make sure it's working.…If you need to install Java 7, you can get the JDK or the Java Developers Kit from Oracle.…Go to the URL oracle.com/Java, that will take you to the main Java page,…then go to the Downloads menu and select Java for Developers.…
On this screen you'll see that there are two downloads available, the JDK or Java Developers Kit,…and the JRE or Java Runtime Environment. You'll want the JDK.…I'll click that link, and I'll see a listing of all the different installations for various Operating Systems.…You can choose from the Mac version or the Windows version, and notice that there are…two versions for Windows, one for 64 bit and one for X86 or 32-bit.…After following the rest of the instructions to install the JDK on your system, if you're…working on a Mac, make sure that you have set the Java 7 Runtime as your default.…
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