Java中，ResultSet的用法

会计考友

在Java中，获得ResultSet的总行数的方法有以下几种。
3 C7 B2 q* k( \: c3 \) b第一种：利用ResultSet的getRow方法来获得ResultSet的总行数
  L, x& r# q8 yJava代码
9 J2 `+ n2 |8 eStatement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rset = stmt.executeQuery("select * from yourTableName");
7 ?1 U/ o: g  E  R: q3 _0 \rset.last();
int rowCount = rset.getRow(); //获得ResultSet的总行数
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); ResultSet rset = stmt.executeQuery("select * from yourTableName"); rset.last(); int rowCount = rset.getRow(); //获得ResultSet的总行数第二种：利用循环ResultSet的元素来获得ResultSet的总行数
' E6 F" h' l  f* aJava代码
0 F# S' S& I5 [0 AResultSet rset = stmt.executeQuery("select * from yourTableName");
2 j8 M0 n8 k, b2 m- lint rowCount = 0;
6 R' S7 ?! M2 e4 |2 r, [( Fwhile(rset.next()) {
6 f% [* v6 f; K: d# q  rowCount++;
- s; i  A3 k- C$ l9 I  X& M) M}
ResultSet rset = stmt.executeQuery("select * from yourTableName"); int rowCount = 0; while(rset.next()) { rowCount++; }rowCount就是ResultSet的总行数。
3 `  V& a0 M) O3 b8 l0 H+ t# M: O第三种：利用sql语句中的count函数获得ResultSet的总行数
Java代码
ResultSet rset = stmt.executeQuery("select count(*) totalCount from yourTableName");
int rowCount = 0;
6 Z  A* ~* u! zif(rset.next()) {来自www.Examw.com
  rowCount=rset .getInt("totalCount ");
& d' B5 Y' h5 u}
& z7 E! I/ g2 l; {/ `) u' Y& [ResultSet rset = stmt.executeQuery("select count(*) totalCount from yourTableName"); int rowCount = 0; if(rset.next()) { rowCount=rset .getInt("totalCount "); }rowCount就是ResultSet的总行数。
3 t5 V& s6 G7 ?" o2 S? Java中获得ResultSet的总列数是非常简单事情，因为Java中ResultSet提供了ResultSetMetaData工具类,ResultSetMetaData 是ResultSet的元数据的集合说明。
  java获得ResultSet总列数的代码如下：
Java代码
$ S1 e& z5 u$ g3 G4 t3 nStatement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
) Y7 O4 y( J; i+ U% mResultSet rset = stmt.executeQuery("select * from yourtable");
ResultSetMetaData rsmd = rset.getMetaData() ;
int columnCount = rsmd.getColumnCount();
: }( W4 ~% y' i8 j5 c2 [4 cStatement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); ResultSet rset = stmt.executeQuery("select * from yourtable"); ResultSetMetaData rsmd = rset.getMetaData() ; int columnCount = rsmd.getColumnCount();columnCount 就是ResultSet的总列数。