使用jdbc将枚举值保存并读取到数据库中？

public enum Color {
    RED,
    GREEN,
    BLUE
}

CREATE TABLE colors (
    id INT PRIMARY KEY,
    name VARCHAR(20)
);

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class EnumJdbcExample {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/mydatabase";
        String username = "root";
        String password = "password";

        try (Connection connection = DriverManager.getConnection(url, username, password)) {
            String insertQuery = "INSERT INTO colors (id, name) VALUES (?, ?)";
            PreparedStatement statement = connection.prepareStatement(insertQuery);

            // 保存枚举值到数据库
            for (Color color : Color.values()) {
                statement.setInt(1, color.ordinal() + 1);
                statement.setString(2, color.name());
                statement.executeUpdate();
            }

            System.out.println("枚举值保存成功！");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class EnumJdbcExample {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/mydatabase";
        String username = "root";
        String password = "password";

        try (Connection connection = DriverManager.getConnection(url, username, password)) {
            String selectQuery = "SELECT name FROM colors";
            PreparedStatement statement = connection.prepareStatement(selectQuery);
            ResultSet resultSet = statement.executeQuery();

            // 从数据库中读取枚举值
            while (resultSet.next()) {
                String colorName = resultSet.getString("name");
                Color color = Color.valueOf(colorName);
                System.out.println(color);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}