向MySQL数据库插入数据的java代码

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

public class InsertDataToMySQL {
    public static void main(String[] args) {
        // 数据库连接信息
        String url = "jdbc:mysql://localhost:3306/mydatabase";
        String username = "username";
        String password = "password";

        // 要插入的数据
        String name = "John";
        int age = 25;
        String city = "New York";

        // JDBC相关变量
        Connection connection = null;
        PreparedStatement preparedStatement = null;

        try {
            // 连接数据库
            connection = DriverManager.getConnection(url, username, password);

            // 创建插入数据的SQL语句
            String sql = "INSERT INTO users (name, age, city) VALUES (?, ?, ?)";

            // 创建PreparedStatement对象
            preparedStatement = connection.prepareStatement(sql);

            // 设置参数值
            preparedStatement.setString(1, name);
            preparedStatement.setInt(2, age);
            preparedStatement.setString(3, city);

            // 执行插入操作
            preparedStatement.executeUpdate();

            System.out.println("数据插入成功");
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            // 关闭连接和PreparedStatement
            try {
                if (preparedStatement != null) {
                    preparedStatement.close();
                }
                if (connection != null) {
                    connection.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}