如何在Kotlin中使用GROUP BY进行计数(*)？

import java.sql.DriverManager
import java.sql.ResultSet

fun main() {
    val connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/database", "username", "password")
    val statement = connection.createStatement()

    val query = "SELECT column, COUNT(*) FROM table GROUP BY column"
    val resultSet: ResultSet = statement.executeQuery(query)

    while (resultSet.next()) {
        val columnValue = resultSet.getString("column")
        val count = resultSet.getInt("COUNT(*)")

        println("Column: $columnValue, Count: $count")
    }

    resultSet.close()
    statement.close()
    connection.close()
}