String string="select count(*) from mytest_hotel ";
resultSet=con.createStatement().executeQuery(string);
resultSet.next();
System.out.println(resultSet.getInt(1));
=====================还有一种麻烦的方法
String string="select * from mytest_hotel ";
resultSet=con.createStatement().executeQuery(string);
int count=0;
while (resultSet.next())
{
count++;
}
System.out.println(count);