Oracle/MySQL °ü·Ã °Ô½ÃÆÇ |
---|
2013/09/24(18:34) from 210.93.7.52 | |
ÀÛ¼ºÀÚ : ÁÖÀÎÀå | Á¶È¸¼ö : 3448 , ÁÙ¼ö : 35 |
[MySQL] JDBC·Î record count ±¸Çϱâ |
---|
1. ù¹ø° ¹æ¹ý String SQL = "SELECT COUNT(*) FROM ip_info"; try { pstmt = conn.prepareStatement(SQL); rs = pstmt.executeQuery(); if (rs.next()) { totalRows = rs.getInt(1); } 2. µÎ¹ø° ¹æ¹ý ResultSet rs = stmt.executeQuery("SELECT * FROM table_name"); rs.last(); int rowcount = rs.getRow(); rs.beforeFirst(); System.out.println("Total rows : " + rowCnt); 3. ¼¼¹ø° ¹æ¹ý ResultSetMetaData rsmd=null; rsmd=rs.getMetaData(); int rowCnt = rsmd.getColumnCount(); |