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

Activity 1: Track Your Progress

Solution

  1. The student table holds information on the student:
    CREATE TABLE IF NOT EXISTS student
    (
    STUDENT_ID long,
    FIRST_NAME varchar(255),
    LAST_NAME varchar(255),
    PRIMARY KEY (STUDENT_ID)
    );
  2. The chapter table has a chapter number and a name:
    CREATE TABLE IF NOT EXISTS chapter
    (
    CHAPTER_ID long,
    CHAPTER_NAME varchar(255),
    PRIMARY KEY (CHAPTER_ID)
    );

    Note that the chapter ID is the chapter number.

  3. The student_progress table maps a student ID to a chapter ID, indicating that a particular student completed a particular chapter:
    CREATE TABLE IF NOT EXISTS student_progress
    (
    STUDENT_ID long,
    CHAPTER_ID long,
    COMPLETED date,
    PRIMARY KEY (STUDENT_ID, CHAPTER_ID)
    );

    Note that by using both student ID and chapter ID as the composite primary key, each student can complete each chapter just once. There are no do-overs.

  4. Here is a hypothetical student:
    INSERT INTO student
    (STUDENT_ID, FIRST_NAME, LAST_NAME)
    VALUES (1, &apos...