ResultSet获得总行数的方法详解数据库

【方法一】利用ResultSet的getRow方法来获得ResultSet的总行数

Connection conn = null; 
		Statement sta = null; 
		ResultSet rs = null; 
		try { 
			Class.forName("com.mysql.jdbc.Driver"); 
		} catch (ClassNotFoundException e) { 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
		} 
		try { 
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123"); 
			sta = conn.createStatement(); 
			rs = sta.executeQuery("select * from test"); 
			rs.last(); 
			int row = rs.getRow(); 
			System.out.println("行数为："+row); 
		} catch (SQLException e) { 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
		}

【方法二】利用循环ResultSet的元素来获得ResultSet的总行数

Connection conn = null; 
		Statement sta = null; 
		ResultSet rs = null; 
		try { 
			Class.forName("com.mysql.jdbc.Driver"); 
		} catch (ClassNotFoundException e) { 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
		} 
		try { 
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123"); 
			sta = conn.createStatement(); 
			rs = sta.executeQuery("select * from test"); 
			int row = 0; 
			while(rs.next()){ 
				row++; 
			} 
			System.out.println("行数为："+row); 
		} catch (SQLException e) { 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
		}

【方法三】利用sql语句中的count函数获得ResultSet的总行数

Connection conn = null; 
		Statement sta = null; 
		ResultSet rs = null; 
		try { 
			Class.forName("com.mysql.jdbc.Driver"); 
		} catch (ClassNotFoundException e) { 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
		} 
		try { 
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123"); 
			sta = conn.createStatement(); 
			rs = sta.executeQuery("select count(*) totleRows from test"); 
			int row = 0; 
			while(rs.next()){ 
				row = rs.getInt("totleRows"); 
			} 
			System.out.println("行数为："+row); 
		} catch (SQLException e) { 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
		}