如何使用java将表单数据插入到GoogleCloud Mysql数据库中

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

public class InsertFormData {
    public static void main(String[] args) {
        String projectId = "your-project-id";
        String instanceConnectionName = "your-instance-connection-name";
        String databaseName = "your-database-name";
        String username = "your-username";
        String password = "your-password";

        String jdbcUrl = String.format(
            "jdbc:mysql://google/%s?cloudSqlInstance=%s&"
            + "socketFactory=com.google.cloud.sql.mysql.SocketFactory&user=%s&password=%s",
            databaseName, instanceConnectionName, username, password);

        try (Connection connection = DriverManager.getConnection(jdbcUrl);
             PreparedStatement statement = connection.prepareStatement(
                 "INSERT INTO your_table_name (column1, column2) VALUES (?, ?)")) {
            statement.setString(1, "value1"); // 设置表单数据的值
            statement.setString(2, "value2");

            int rowsAffected = statement.executeUpdate();
            System.out.println(rowsAffected + " row(s) affected.");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}