如何使用java在mysql中存储位值0、1、2、3

import java.sql.*;

public class MySQLExample {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/your_database_name";
        String username = "your_username";
        String password = "your_password";

        try {
            Connection connection = DriverManager.getConnection(url, username, password);
            System.out.println("Successfully connected to the database!");

            // 在这里执行后续操作
        } catch (SQLException e) {
            System.out.println("Failed to connect to the database.");
            e.printStackTrace();
        }
    }
}

CREATE TABLE bit_values (
    id INT PRIMARY KEY AUTO_INCREMENT,
    value BIT(2)
);

try {
    String insertQuery = "INSERT INTO bit_values (value) VALUES (?)";
    PreparedStatement preparedStatement = connection.prepareStatement(insertQuery);
    
    // 将位值插入到数据库中
    preparedStatement.setInt(1, 0); // 0
    preparedStatement.executeUpdate();
    
    preparedStatement.setInt(1, 1); // 1
    preparedStatement.executeUpdate();
    
    preparedStatement.setInt(1, 2); // 10
    preparedStatement.executeUpdate();
    
    preparedStatement.setInt(1, 3); // 11
    preparedStatement.executeUpdate();
    
    System.out.println("Bit values inserted successfully!");
} catch (SQLException e) {
    System.out.println("Failed to insert bit values.");
    e.printStackTrace();
}

try {
    String selectQuery = "SELECT * FROM bit_values";
    Statement statement = connection.createStatement();
    ResultSet resultSet = statement.executeQuery(selectQuery);
    
    while (resultSet.next()) {
        int id = resultSet.getInt("id");
        int value = resultSet.getInt("value");
        
        System.out.println("ID: " + id + ", Value: " + value);
    }
} catch (SQLException e) {
    System.out.println("Failed to retrieve bit values from the database.");
    e.printStackTrace();
}