BlogJava-Oo ' Smiling on Java ' oO-最新评论http://www.blogjava.net/jwin/CommentsRSS.aspx从梦里回来,依然记得梦里有你...zh-cnTue, 14 Jun 2016 15:00:07 GMTTue, 14 Jun 2016 15:00:07 GMTcnblogsre: poi读excelhttp://www.blogjava.net/jwin/archive/2016/06/14/167093.html#430903Mary jamesMary jamesTue, 14 Jun 2016 15:00:00 GMThttp://www.blogjava.net/jwin/archive/2016/06/14/167093.html#430903I recommend this website:
http://how-to-program-in-java.com/
It was really helpful for me.

Mary james 2016-06-14 23:00 发表评论
]]>re: 获得ResultSet返回记录数http://www.blogjava.net/jwin/archive/2009/09/02/79501.html#293609douboerdouboerWed, 02 Sep 2009 08:09:00 GMThttp://www.blogjava.net/jwin/archive/2009/09/02/79501.html#293609类型就不对，你试过吗？不懂不要瞎说

douboer 2009-09-02 16:09 发表评论
]]>re: 获得ResultSet返回记录数http://www.blogjava.net/jwin/archive/2007/04/10/79501.html#109598furongfurongTue, 10 Apr 2007 04:08:00 GMThttp://www.blogjava.net/jwin/archive/2007/04/10/79501.html#109598他最后老提示我说
at sun.jdbc.odbc.JdbcOdbcResultSet.getInt(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getInt(Unknown Source)
好象是total那里出错了
请问这是为什么呢

furong 2007-04-10 12:08 发表评论
]]>re: 获得ResultSet返回记录数http://www.blogjava.net/jwin/archive/2007/03/13/79501.html#103622wypwypTue, 13 Mar 2007 12:58:00 GMThttp://www.blogjava.net/jwin/archive/2007/03/13/79501.html#103622

wyp 2007-03-13 20:58 发表评论
]]>re: 获得ResultSet返回记录数http://www.blogjava.net/jwin/archive/2007/02/08/79501.html#98749jasonujasonuThu, 08 Feb 2007 06:08:00 GMThttp://www.blogjava.net/jwin/archive/2007/02/08/79501.html#98749

jasonu 2007-02-08 14:08 发表评论
]]>re: 获得ResultSet返回记录数http://www.blogjava.net/jwin/archive/2006/11/07/79501.html#79703JwinJwinTue, 07 Nov 2006 13:54:00 GMThttp://www.blogjava.net/jwin/archive/2006/11/07/79501.html#79703
所以这两天我又在翻Sql的资料...
以防下次出这样的错误...

Jwin 2006-11-07 21:54 发表评论
]]>re: 获得ResultSet返回记录数http://www.blogjava.net/jwin/archive/2006/11/07/79501.html#79640马嘉楠马嘉楠Tue, 07 Nov 2006 08:18:00 GMThttp://www.blogjava.net/jwin/archive/2006/11/07/79501.html#79640
我也是最近写了一些这方面代码，多练习就熟悉了
其实SQL也有很多东西学的，只不过基本的掌握了，就可以应付大多数问题了


马嘉楠 2006-11-07 16:18 发表评论
]]>re: 获得ResultSet返回记录数http://www.blogjava.net/jwin/archive/2006/11/07/79501.html#79559JwinJwinTue, 07 Nov 2006 03:42:00 GMThttp://www.blogjava.net/jwin/archive/2006/11/07/79501.html#79559
这样也是可以的...
发现其实我还是SQL不过关,谢谢嘉楠兄的指导啦..

Jwin 2006-11-07 11:42 发表评论
]]>re: 获得ResultSet返回记录数http://www.blogjava.net/jwin/archive/2006/11/07/79501.html#79531马嘉楠马嘉楠Tue, 07 Nov 2006 02:04:00 GMThttp://www.blogjava.net/jwin/archive/2006/11/07/79501.html#79531con.prepareStatement( SQL, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

SQL是你的SQL语句，我记得似乎这样也可以

马嘉楠 2006-11-07 10:04 发表评论
]]>re: 获得ResultSet返回记录数http://www.blogjava.net/jwin/archive/2006/11/07/79501.html#79527马嘉楠马嘉楠Tue, 07 Nov 2006 01:56:00 GMThttp://www.blogjava.net/jwin/archive/2006/11/07/79501.html#79527
select count(*) total from DBTableName;

rs = stmt.executeQuery(sql);

int totalRows = rs.getLong("total");

之后totalRows就是你想要得记录数，只需要一步就能获得你要的结果

如果把所有的纪录都查出来，一行一行移动到最后一行，再取行号，效率也太慢了

遇到有几万几十万纪录的大表，你就该哭了（即使几千条也很慢啊）

而且如果是大表查数据的话，也只是返回一部分，例如返回前100个记录

select first 100 * from DBTableName



马嘉楠 2006-11-07 09:56 发表评论
]]>