从对象创建动态Mysql插入

public class User {
    private int id;
    private String name;

    // 构造方法、getter和setter方法省略
}

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

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

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

            User user = new User();
            user.setId(1);
            user.setName("John");

            statement.setInt(1, user.getId());
            statement.setString(2, user.getName());

            statement.executeUpdate();
            System.out.println("Record inserted successfully.");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}