Book Image

The Java Workshop

By : David Cuartielles, Andreas Göransson, Eric Foster-Johnson
Book Image

The Java Workshop

By: David Cuartielles, Andreas Göransson, Eric Foster-Johnson

Overview of this book

Java is a versatile, popular programming language used across a wide range of industries. Learning how to write effective Java code can take your career to the next level, and The Java Workshop will help you do just that. This book is designed to take the pain out of Java coding and teach you everything you need to know to be productive in building real-world software. The Workshop starts by showing you how to use classes, methods, and the built-in Collections API to manipulate data structures effortlessly. You’ll dive right into learning about object-oriented programming by creating classes and interfaces and making use of inheritance and polymorphism. After learning how to handle exceptions, you’ll study the modules, packages, and libraries that help you organize your code. As you progress, you’ll discover how to connect to external databases and web servers, work with regular expressions, and write unit tests to validate your code. You’ll also be introduced to functional programming and see how to implement it using lambda functions. By the end of this Workshop, you’ll be well-versed with key Java concepts and have the knowledge and confidence to tackle your own ambitious projects with Java.
Table of Contents (20 chapters)

7. Databases and JDBC

Overview

In the following chapter, you will learn how to use Java Database Connectivity (JDBC) to access relational databases from your Java applications. This begins with creating tables in relational databases to store and sort data. Only then can you manipulate these tables by writing basic SQL queries to retrieve and modify that data. Once this baseline is established, you'll be able to apply these skills to Java applications, specifically, in order to access databases and run queries from JDBC. You will further practice using the JDBC PreparedStatement interface to allow for parameterized SQL statements, boosting your speed by cutting out time-consuming and repetitive keystrokes. By the end of this chapter, you will know how to insert and update data from the JDBC, and handle any exceptions it throws with confidence and skill.