Question

java中ResultSet，获取该对象的行数用哪个方法，就是获取记录总数

Answer 1

用.getMetaData().getColumnCount() 方法 意思就是用ResultSet的对象 获得元数据 在获得记录总数

Answer 2

不做其他的,单纯获取记录总数的话,可以循环,
int count = 0;
while(ResultSet.next()){

count + = 1;

}

Answer 3

可以使用 SQL
try {
// Select the number of rows in the table
Statement stmt = connection.createStatement();
ResultSet resultSet = stmt.executeQuery("SELECT COUNT(*) FROM my_table");

// Get the number of rows from the result set
resultSet.next();
int rowcount = resultSet.getInt(1);
} catch (SQLException e) {
}

方法2

try {
// Create a scrollable result set
Statement stmt = connection.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
ResultSet resultSet = stmt.executeQuery("SELECT * FROM my_table");

// Move to the end of the result set
resultSet.last();

// Get the row number of the last row which is also the row count
int rowCount = resultSet.getRow();
} catch (SQLException e) {
}