将预准备语句的结果放入变量中

PreparedStatement statement = connection.prepareStatement("SELECT column_name FROM table_name WHERE condition = ?");
statement.setString(1, value); // 设置参数值
ResultSet resultSet = statement.executeQuery(); // 执行查询
if (resultSet.next()) {
    String result = resultSet.getString("column_name"); // 将查询结果存入变量
    // 进行后续操作
}

import mysql.connector

connection = mysql.connector.connect(host='localhost', database='database_name', user='username', password='password')
cursor = connection.cursor(prepared=True)
sql = "SELECT column_name FROM table_name WHERE condition = %s"
params = (value,) # 参数以元组形式提供
cursor.execute(sql, params) # 执行查询
result = cursor.fetchone()[0] # 将查询结果存入变量
# 进行后续操作

$statement = $connection->prepare("SELECT column_name FROM table_name WHERE condition = ?");
$statement->bindParam(1, $value); // 绑定参数值
$statement->execute(); // 执行查询
$result = $statement->fetchColumn(); // 将查询结果存入变量
// 进行后续操作