This complete example demonstrates every core JDBC operation: creating a table, inserting rows, querying, updating, and deleting. It uses SQLite, which stores the entire database in a single file — no server installation, no username/password, no background services to manage.

import java.sql.*;

public class PartyDatabase {

    public static void main(String[] args) {

        String url = "jdbc:sqlite:game.db";

        try (Connection conn = DriverManager.getConnection(url)) {

            Statement stmt = conn.createStatement();
            stmt.executeUpdate(
                "CREATE TABLE IF NOT EXISTS characters (" +
                "id INTEGER PRIMARY KEY AUTOINCREMENT, " +
                "name VARCHAR(50) NOT NULL, " +
                "char_class VARCHAR(50) NOT NULL)"
            );
            System.out.println("Table ready.");

            String insertSQL = "INSERT INTO characters (name, char_class) VALUES (?, ?)";
            try (PreparedStatement pstmt = conn.prepareStatement(insertSQL)) {
                String[][] party = {{"Hero", "Warrior"}, {"Zara", "Mage"}, {"Fletch", "Archer"}};
                for (String[] c : party) {
                    pstmt.setString(1, c[0]);
                    pstmt.setString(2, c[1]);
                    pstmt.executeUpdate();
                }
            }
            System.out.println("Characters inserted.\n");

            String selectSQL = "SELECT id, name, char_class FROM characters";
            try (PreparedStatement pstmt = conn.prepareStatement(selectSQL);
                 ResultSet rs = pstmt.executeQuery()) {
                System.out.println("Current party:");
                while (rs.next()) {
                    System.out.printf("  [%d] %s (%s)%n",
                        rs.getInt("id"),
                        rs.getString("name"),
                        rs.getString("char_class"));
                }
            }

            String updateSQL = "UPDATE characters SET char_class = ? WHERE name = ?";
            try (PreparedStatement pstmt = conn.prepareStatement(updateSQL)) {
                pstmt.setString(1, "Paladin");
                pstmt.setString(2, "Hero");
                int rows = pstmt.executeUpdate();
                System.out.println("\nUpdated " + rows + " row(s): Hero is now a Paladin.");
            }

            String deleteSQL = "DELETE FROM characters WHERE name = ?";
            try (PreparedStatement pstmt = conn.prepareStatement(deleteSQL)) {
                pstmt.setString(1, "Fletch");
                int rows = pstmt.executeUpdate();
                System.out.println("Deleted " + rows + " row(s): Fletch removed.\n");
            }

            try (PreparedStatement pstmt = conn.prepareStatement(selectSQL);
                 ResultSet rs = pstmt.executeQuery()) {
                System.out.println("Updated party:");
                while (rs.next()) {
                    System.out.printf("  [%d] %s (%s)%n",
                        rs.getInt("id"),
                        rs.getString("name"),
                        rs.getString("char_class"));
                }
            }

        } catch (SQLException e) {
            System.out.println("Database error: " + e.getMessage());
        }
    }

}