从select查询中将强制转换的值提取到数组中

SELECT CAST(column_name AS INT) FROM table_name;

import mysql.connector

# 连接数据库
cnx = mysql.connector.connect(user='username', password='password',
                              host='host', database='database_name')

# 创建游标对象
cursor = cnx.cursor()

# 执行查询语句
query = "SELECT CAST(column_name AS INT) FROM table_name"
cursor.execute(query)

# 提取查询结果到数组
result_array = []
for (value,) in cursor:
    result_array.append(value)

# 关闭游标和数据库连接
cursor.close()
cnx.close()

# 输出结果数组
print(result_array)

import java.sql.*;

public class Main {
    public static void main(String[] args) {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;

        try {
            // 连接数据库
            conn = DriverManager.getConnection("jdbc:mysql://host/database_name", "username", "password");

            // 创建Statement对象
            stmt = conn.createStatement();

            // 执行查询语句
            String query = "SELECT CAST(column_name AS INT) FROM table_name";
            rs = stmt.executeQuery(query);

            // 提取查询结果到数组
            List<Integer> resultArray = new ArrayList<>();
            while (rs.next()) {
                int value = rs.getInt(1);
                resultArray.add(value);
            }

            // 输出结果数组
            System.out.println(resultArray);
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            // 关闭ResultSet、Statement和Connection
            try {
                if (rs != null) {
                    rs.close();
                }
                if (stmt != null) {
                    stmt.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}