To get the size of a table using the JDBC operation mysql--

Get MySQL in JDBC we sometimes need to get the size of the table, which includes the number of rows and columns of the table, which we can get separately in the following ways:

Suppose we get a ResultSet object RS, the operation is as follows:

fetch the number of rows before reading the result set :

Rs.last ()//move the cursor to the last row Rs.getrow ()//Returns the line number of the current row, starting with the 1~nrs.beforfirst ()//To start the cursor, at which line number is 0

　　

get the number of result set columns :

Rs.getmetadata (). getColumnCount ()//Total number of columns getting metadata

　　

To get the size of a table using the JDBC operation mysql--